Tagged Questions

-1
votes
1answer
22 views

Send a picture from iOS app to php script to mySQL DB

I've a problem: I want to send a picture from my iOS app to a php script to insert this image in a mysql db. The field in mysql db for the image is LONGBLOB. The image that is sending is ...
0
votes
1answer
16 views

Suggestions for website template/design - Backend

I'm creating a website using Codeigniter which hosts online novels/e-books. The novel(s) have multiple chapters similar to a hard copy. Im planning to design the layout as following. User goes to ...
1
vote
3answers
52 views

Getting all different values but not duplicates from multiple records

I have the following SQL: SELECT o.order_id, ol.product_manufacturer FROM orders o INNER JOIN order_lines ol ON o.order_id = ol.order_id WHERE o.deadline_time > UNIX_TIMESTAMP() I also have ...
0
votes
0answers
33 views

Retrieving values of php var in mysql trigger

I have php file which insert the sentence and perform trigger operation as below: < html > <body > <?php $s = $_POST['sent']; echo "Entered sentence : $s"; if ...
2
votes
1answer
24 views

Issue changing from MySQL to pdo

I'm changing from mysql to pdo syntax as it will be removed. But I have a problem with the errors. Here is the code with mysql_* : $userquery = mysql_query("select * from user") or die ("Erorr in ...
-1
votes
1answer
30 views

Failed to read auto-increment value from storage engine [on hold]

I receive this error when trying to insert something in the DB. Error: (1467) Failed to read auto-increment value from storage engine This is my table info: Row Statistics Format ...
5
votes
2answers
26 views

PDO query() or fetch() not working

I have this code that I made for showing comments in my website from the database but the comment is not shown. I think maybe PDO query() or fetch() is not working but the problem is that I don't get ...
0
votes
2answers
20 views

MySQL: managing user billing and shipping addresses [on hold]

At first I thought it would be good to have an addresses table in order to keep track of a users billing and shipping addresses... these of course will be used for orders, etc. But once I started ...
0
votes
2answers
22 views

Issue with delete query for a specific field only

I'm trying to delete a specific field (not an entire row) in my database. But right now, it's not deleting anything in my database. When the user clicks on the delete button, i want to empty the ...
-1
votes
1answer
32 views

How to order MySQL output using PDO

With the MYSQL functions being depreciated I've been trying to move my code to PDO, but there are a couple of features I've got used to with SQL that I can't replicate in PDO. Here's my code for ...
0
votes
2answers
35 views

MySQL Category Count

I'm trying to make a search filter that displays categories with an item count. I have a category/post relationship table as follows entry_id | cat_id ------------------ 1 | 1 ...
0
votes
0answers
34 views

Dropdown Box shows as blank instead of pulling items from the Database

For some reason, my PHP code won't show up database in the drop down box that I retrieve from MySQL. CS_JOBS and CS_JOBS_CATEGORY are tables in the database. I join CS_JOBS_CATEGORY and CS_JOBS, since ...
0
votes
0answers
18 views

Access MySQL database and edit throw php page

The point is making a page soming looking like this : http://www.scriptcase.net/scriptcase-samples/php-form/simple-form-with-copy-button/ I want to navigate in the registers in my database still the ...
0
votes
1answer
25 views

MySQLi / PHP: Not redirecting to error page?

So what I'm trying to do here is have my users login in. This is the script I am using to do that. I have just used an converter found here: ...
0
votes
1answer
27 views

Insert php variable in database on trigger event

You might say that this question already asked many time! You right, but those dont give me solution. I am trying to insert inserted data and two var into database using trigger on insert event, code ...

1 2 3 4 5 … 531
15 30 50 per page