MYSQL: simple select';
$rs = mysql_query( 'SELECT * FROM users;' );
while($row = mysql_fetch_assoc($rs))
{
debug($row);
}
print 'MYSQL: calling sp with out variables
';
$rs = mysql_query( 'CALL get_user(1, @first, @last)' );
$rs = mysql_query( 'SELECT @first, @last' );
while($row = mysql_fetch_assoc($rs))
{
debug($row);
}
print 'MYSQL: calling sp returning a recordset - doesn\'t work
';
$rs = mysql_query( 'CALL get_users()' );
while($row = mysql_fetch_assoc($rs))
{
debug($row);
}
// MYSQLI
$mysqli = new mysqli('localhost', 'example', 'example', 'test');
print 'MYSQLI: simple select
';
$rs = $mysqli->query( 'SELECT * FROM users;' );
while($row = $rs->fetch_object())
{
debug($row);
}
print 'MYSQLI: calling sp with out variables
';
$rs = $mysqli->query( 'CALL get_user(1, @first, @last)' );
$rs = $mysqli->query( 'SELECT @first, @last' );
while($row = $rs->fetch_object())
{
debug($row);
}
print 'MYSQLI: calling sp returning a recordset
';
$rs = $mysqli->query( 'CALL get_users()' );
while($row = $rs->fetch_object())
{
debug($row);
}
// PDO
$pdo = new PDO('mysql:dbname=test;host=127.0.0.1', 'example', 'example');
print 'PDO: simple select
';
foreach($pdo->query( 'SELECT * FROM users;' ) as $row)
{
debug($row);
}
print 'PDO: calling sp with out variables
';
$pdo->query( 'CALL get_user(1, @first, @last)' );
foreach($pdo->query( 'SELECT @first, @last' ) as $row)
{
debug($row);
}
print 'PDO: calling sp returning a recordset
';
foreach($pdo->query( 'CALL get_users()' ) as $row)
{
debug($row);
}
function debug($o)
{
print '';
print_r($o);
print '
';
}
?>