In PHP & MySql programming how to executive more then 3 queries in a single statement?

Question

i want to execute a more then 3 queries in a single statement. is is possible?

i need to insert the values into the table select entire table count the users.

is it possible to do all these in a single statement.

Thanks

that sounds like two statements, but no, that's not possible in a single statement. — Ja͢ck, May 31 '13 at 06:58
possible duplicate of http://stackoverflow.com/q/9927097/1894905 — 6339, May 31 '13 at 07:02
insert into table/select * from table/select count(*) from users — Doc, May 31 '13 at 07:04
phoenix said 3 queries and jack said that there were only 2, so i pointed out the 3 queries... — Doc, May 31 '13 at 08:07

score 1 · Accepted Answer · edited May 31 '13 at 07:06

1

You can use more than 3 queries only in mysqli using mysqli_multi_query(), but mysql doesn't support it.

edited May 31 '13 at 07:06

Deepika

826
6
14

answered May 31 '13 at 06:59

Winston

1,758
2
17
29

3

Don't forget to remind the security concerns: http://php.net/manual/en/mysqli.quickstart.multiple-statement.php – Bart Friederichs May 31 '13 at 07:01
can we implement this concept in mysql without using mysqli – Phoenix Bird May 31 '13 at 07:07

score 0 · Answer 2 · answered May 31 '13 at 07:30

Example code :

<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$query  = "SELECT CURRENT_USER();";
$query .= "SELECT Name FROM City ORDER BY ID LIMIT 20, 5";

/* execute multi query */
if ($mysqli->multi_query($query)) {
    do {
        /* store first result set */
        if ($result = $mysqli->store_result()) {
            while ($row = $result->fetch_row()) {
                printf("%s\n", $row[0]);
            }
            $result->free();
        }
        /* print divider */
        if ($mysqli->more_results()) {
            printf("-----------------\n");
        }
    } while ($mysqli->next_result());
}

/* close connection */
$mysqli->close();
?>

Change it accordingly. It shows multiquery in action using mysqli.

i need to implement in mysql with out using mysqli – Phoenix Bird May 31 '13 at 07:36 — Phoenix Bird, May 31 '13 at 07:36

In PHP & MySql programming how to executive more then 3 queries in a single statement?

2 Answers2