PHP mysql_query() cannot query sql requested

Question

This is my SQL statement:

UPDATE approved_student SET barcode='11',phone='11',table_name='2',remark='' WHERE
studentid='5230010'; UPDATE approved_student SET 
barcode='22',phone='22',table_name='2',remark='' WHERE studentid='5230009';

Executing the SQL using PHP is not resulting in the desired outcome.

PHP source:

mysql_connect("localhost","root","1234"); //connect database
mysql_select_db("lasto");//select name of the database

if($sql=mysql_query($data1)){
    echo 1;
}else{
    echo $data1;
}

mysql_close();

I sent the SQL using POST, but it does not work.

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — ComFreek
– ComFreek, Commented Aug 20, 2013 at 14:25
HERE IS MY ANSWER! $mysqli = new mysqli("localhost","root","1234","lasto"); //connect database //mysqli_select_db($con,"lasto");//select name of the database if($mysqli->multi_query($data1)){ echo 1; }else{ echo $data1; } $mysqli->close(); — Jongz Puangput
– Jongz Puangput, Commented Aug 20, 2013 at 15:00

Nils · Accepted Answer · 2013-08-20 14:24:41Z

6

You can only execute one commands at the time with mysql_query(), you should look at using mysqli or PDO instead.

mysql_query("UPDATE approved_student SET barcode='11',phone='11',table_name='2',remark='' WHERE
studentid='5230010'"); 

...

mysql_query("UPDATE approved_student SET 
barcode='22',phone='22',table_name='2',remark='' WHERE studentid='5230009'");

answered Aug 20, 2013 at 14:24

Nils

4462 silver badges5 bronze badges

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

2 Comments

Jongz Puangput Over a year ago

you mean that mysqli or PDO can execute at the same time right ?

Nils Over a year ago

@JongzPuangput Yeah that shouldn't be a problem.

Collectives™ on Stack Overflow

PHP mysql_query() cannot query sql requested

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related