How to generate query errors in php

Question

i have a query that doesn't seem to be executing for some reason. I've checked all the vars are the right names, that they all have the right data in them but for some reason it just won't fire.

Now i know there is a way to generate the error but i can't remember or find it on the internet. I'm using mysqli to run the query are this is the code for the query:

$stmt = $this->conn->query("INSERT INTO seminar_signup(email, firstname, surname, address_1, address_2, postcode) VALUES ('$san_email', '$san_firstname', '$san_surname', '$san_address1', '$san_address2', '$san_postcode')");

I've more or less copied the code from another function that does close to the same thing and that works fine.

thanks for the help.

What kind of object is $this -> conn? A MySQLi instance? A PDO instance? A custom-built object that extends one of the above objects? A custom-built object that doesn't extend either of the above? — GordonM
– GordonM, Commented Mar 12, 2012 at 10:46
You have a query, try it directly on MySQL, you just need to replace dummy data in that variables — Uday Sawant
– Uday Sawant, Commented Mar 12, 2012 at 10:48

sdjuan · Accepted Answer · 2012-03-12 10:48:44Z

1

Maybe this: mysqli error

answered Mar 12, 2012 at 10:48

sdjuan

7197 silver badges17 bronze badges

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

Comments

jagdish · Accepted Answer · 2012-03-12 11:33:23Z

1

try to $stmt = $this->conn->query("INSERT INTO seminar_signup(email, firstname, surname, address_1, address_2, postcode) VALUES ('".$san_email."', '".$san_firstname."', '".$san_surname."', '".$san_address1."', '".$san_address2."', '".$san_postcode."')");

answered Mar 12, 2012 at 11:33

jagdish

111 bronze badge

Comments

Mathias R. Jessen · Accepted Answer · 2012-03-12 10:46:58Z

0

$stmt = @$this->conn->query("INSERT INTO seminar_signup(email, firstname, surname, address_1, address_2, postcode) VALUES ('$san_email', '$san_firstname', '$san_surname', '$san_address1', '$san_address2', '$san_postcode')");

echo mysql_error();

answered Mar 12, 2012 at 10:46

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

Comments

Duke · Accepted Answer · 2012-03-12 10:51:58Z

0

$stmt = $this->conn->query("INSERT INTO seminar_signup(email, firstname, surname, address_1, address_2, postcode) VALUES ('$san_email', '$san_firstname', '$san_surname', '$san_address1', '$san_address2', '$san_postcode')") or die(mysql_error());

answered Mar 12, 2012 at 10:51

Duke

37.3k13 gold badges57 silver badges74 bronze badges

Comments

Uday Sawant · Accepted Answer · 2012-03-12 10:53:46Z

0

Try the same query directly on MySQL, If you still want to get errors in PHP following are the MySQLi functions to get last errors

mysqli::$errno — Returns the error code for the most recent function call
mysqli::$error_list — Returns a list of errors from the last command executed
mysqli::$error — Returns a string description of the last error

answered Mar 12, 2012 at 10:53

Uday Sawant

5,8083 gold badges35 silver badges46 bronze badges

Comments

nbhatti2001 · Accepted Answer · 2012-03-12 11:08:20Z

0

First check the connection is it opened

then get the sql query by echo which is going to execute in your query function of $this->conn, and execute it in your phpmyadmin or what ever GUI you have.

answered Mar 12, 2012 at 11:08

nbhatti2001

3632 gold badges7 silver badges33 bronze badges

Collectives™ on Stack Overflow

How to generate query errors in php

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related