Error querying database in PHP, MySQL

Question

I have this code in PHP. It connects to the DB fine, but pops an error, when tryinto to insert the info.

$dbc = mysqli_connect('localhost', 'root', 'marina', 'aliendatabase') or die('Error connecting to MySQL server.');

$query = "INSERT INTO aliens_abduction (name, email) VALUSE ('John', '[email protected]')";

$result = mysqli_query($dbc, $query) or die('Error querying database.');
mysqli_close($dbc);

Here's a screenshot: http://img532.imageshack.us/img532/2930/63306356.jpg

Thanks, R

die('Error querying database.')-> trigger_error(mysqli_error().$query); — Your Common Sense
– Your Common Sense, Commented Apr 2, 2010 at 12:58
It would be helpful if you tell us which error you get :) — Felix Kling
– Felix Kling, Commented Apr 2, 2010 at 13:03
Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\xampp\xampp\htdocs\rob\report.php on line 43 Notice: INSERT INTO aliens_abduction (name, email) VALUES ('John', '[email protected]') in C:\xampp\xampp\htdocs\rob\report.php on line 43 — Roger Travis
– Roger Travis, Commented Apr 2, 2010 at 13:05
@user296516: Can you also post the corresponding code? It seems that you try to call mysqli_error() without passing any parameter. In the code you have given currently there is no mysqli_error(). — Felix Kling
– Felix Kling, Commented Apr 2, 2010 at 13:09
@user296516: You have to use it this way: mysqli_error($dbc). — Felix Kling
– Felix Kling, Commented Apr 2, 2010 at 13:23

parserr · Accepted Answer · 2010-04-02 12:56:10Z

3

seems that you've misspelled VALUES in your query.

answered Apr 2, 2010 at 12:56

parserr

7291 gold badge5 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Roger Travis Over a year ago

edited the typo, thanks. but still the same error keeps popping. :/

sth · Accepted Answer · 2011-11-13 15:03:28Z

3

Try this:

$query = "INSERT INTO aliens_abduction (name, email, when_did_it_happen, what_did_they_do, " . "seen_Fang", "anything_else") VALUES ($'name', '$email', '$when_did_it_happen',". "'$what_did_they_do', '$seen_Fang', '$anything_else')";

edited Nov 13, 2011 at 15:03

sth

231k56 gold badges288 silver badges370 bronze badges

answered Oct 28, 2011 at 17:16

Jane

311 bronze badge

Comments

Klaus Byskov Pedersen · Accepted Answer · 2010-04-02 12:56:51Z

2

You have a typo in your query. Try changing VALUSE to VALUES.

answered Apr 2, 2010 at 12:56

Klaus Byskov Pedersen

122k31 gold badges191 silver badges223 bronze badges

1 Comment

Roger Travis Over a year ago

edited the typo, thanks. but still the same error keeps popping. :/

Jimmy · Accepted Answer · 2010-04-02 12:56:46Z

1

$query = "INSERT INTO aliens_abduction (name, email) VALUES ('John', '[email protected]')";

answered Apr 2, 2010 at 12:56

Jimmy

9,82514 gold badges62 silver badges81 bronze badges

1 Comment

Roger Travis Over a year ago

edited the typo, thanks. but still the same error keeps popping. :/

sth · Accepted Answer · 2011-11-13 15:03:45Z

1

I think you need to write something along the lines of...

$query = "INSERT INTO aliens_abduction (name, email, when_did_it_happen, what_did_they_do, " .
"seen_Fang", "anything_else") VALUES ('John', '[email protected]', 'tuesday', 'nothing', 'no', ' ')";

When you insert data into the table, you need to specify every row you have in that table in the brackets before the Values...

By now you have probably found out the answer for yourself :P However for others that may have a similar error (such as myself) may find this information useful.

edited Nov 13, 2011 at 15:03

sth

231k56 gold badges288 silver badges370 bronze badges

answered Feb 10, 2011 at 14:09

karinashenaz

111 bronze badge

Comments

Dushan · Accepted Answer · 2018-05-27 07:30:15Z

0

I was doing the same exercise from Headfirst PHP & MYSQL and got the same error and figured out why this happened. In my end, this happened just because I had filled one of the form field with a text containing apostrophe ( ' ). I have circled that text in Red color in below screenshot. Hope this helps someone to go ahead.

and also explanation and sample codes in this link will help you to display error messages relevant to the errors in your code.

answered May 27, 2018 at 7:30

Dushan

7998 silver badges14 bronze badges

Collectives™ on Stack Overflow

Error querying database in PHP, MySQL

6 Answers 6

1 Comment

Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related