MySQL trouble inserting row when using php

Asked Jul 14 '15 at 15:09

Active Jul 14 '15 at 15:09

Viewed 21 times

I am trying to insert a row into my table tutorial_info using the command:

$sql3 = "INSERT INTO tutorial_info(tutorial_id,tutorial_title,tutorial_author,submission_date)
         VALUES(NULL,"Math","Bob Trotter",CURRENT_TIMESTAMP);";

 if($conn->query($sql3)===TRUE){

     echo "Added data\n";

   }

    else echo "Could not add data to the table ".$conn->error;

The insert function is not working. I am not getting any error displayed at all.

$conn is my mysqli object. I have managed to get other queries working on $conn. I have also cut and paste

INSERT INTO tutorial_info(tutorial_id,tutorial_title,tutorial_author,submission_date)
             VALUES(NULL,"Math","Bob Trotter",CURRENT_TIMESTAMP);

directly into MySQL to confirm the syntax is correct and it works.

Any tips on what I might be doing wrong?

edited Jul 14 '15 at 15:09

Your Common Sense

154,967
38
205
325

asked Jul 14 '15 at 15:09

KexAri

3,767
5
38
74

you have problem here `CURRENT_TIMESTAMP);";` look at the end – Shehary Jul 14 '15 at 15:12
@shehary, there's absolutely nothing wrong with that bit. – Styphon Jul 14 '15 at 15:16
@Styphon, May be, i never seen this `;";` before but php is what sky is the limit :) – Shehary Jul 14 '15 at 15:18
@shehary that's because most people don't terminate their MySQL statements. The first semi-colon terminates the SQL query, the quote ends the string and the second semi-colon terminates the PHP line. – Styphon Jul 14 '15 at 15:20
@Styphon, Thanks for clearing it up, you are right. – Shehary Jul 14 '15 at 15:22

MySQL trouble inserting row when using php

0 Answers0