php multiple query problem

Question

First of all, this is a problem with an older combination of php/mysql: PHP 5.2.0-8, mysql Ver 14.12 Distrib 5.0.32

So here is what I'm trying to do:

$con = db_connect();
$last_id = 123;
$q1 = db_select_all( $con, "t1", "WHERE id=" . $last_id );
$r1 = $q1->fetch();
$q2 = db_select_all( $con, "t2", "WHERE id=" . $last_id );
$r2 = $q2->fetch();

function db_connect()
{
    $con = new PDO();
    return $con;
}

function db_select_all( $con, $tab, $cond )
{
    $cmd = "SELECT * FROM " . $tab . " " . $cond;
    print "$cmd\n";
    $res = $con->query( $cmd );
    return $res;
}

Problem is the second call to $con->query() will always return a NULL object.

This doesn't happen to an newer version of php/mysql

If I close the connection and reconnect, then it'll work fine.

So it looks like the combination doesn't support multiple query at the same time. Is this a known limitation or there is way to make it working?

As always, any input welcomed.

Show us some real code. For example, you have to fetch() on the object returned by query(); not on the connection object. So your example is pretty much useless. — ThiefMaster
– ThiefMaster, Commented Jan 20, 2011 at 11:19
You can format code with the {} toolbar button. I've done it for you this time. — Álvaro González
– Álvaro González, Commented Jan 20, 2011 at 11:23

Xavier Barbosa · Accepted Answer · 2011-01-20 13:29:09Z

1

You need to close cursor, see the doc : PDOStatement::closeCursor()

answered Jan 20, 2011 at 13:29

Xavier Barbosa

3,9471 gold badge22 silver badges18 bronze badges

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

1 Comment

lang2 Over a year ago

that works fine initially. but soon i hit another problem. I put the following in a loop but it only works the first time. the second time will always return an emtpy row: $q1 = db_select_all( $con, "t1", "WHERE id=" . $last_id ); $r1 = $q1->fetch(); $q1->closeCursor()

Collectives™ on Stack Overflow

php multiple query problem

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related