php 에서 mysql 프로시저 호출

php 에서 mysql 프로시저 호출

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 ‘’; } ?>

공유하기 글 요소 저작자표시

from http://devlink.tistory.com/642 by ccl(A) rewrite - 2021-09-14 19:01:03