note 112262 added to mysqli.quickstart.stored-procedures

<?php /* * *Creating Session Variable with Prepared Statement * *for IN/OUT variable to stored procedure * *using Data Binding to get the data back * *@params * $mysql: mysqli() instance * $var: input and output paramater to stored procedure */ function stored_procedure($mysql , &$var = 'hello world') { $stmt = $mysql->stmt_init(); // initialize statement if($stmt->prepare("SET @var = ?")) // prepare set command { $var = $mysql->real_escape_string($var); // escape input $stmt->bind_param('s',$var); // bind data $stmt->execute(); // create session variable $stmt->free_result(); // free resutl if($stmt->prepare("CALL stored_procedure(@var)"))//call stored procedure with database server session variable { $stmt->execute(); $stmt->free_result(); } if($stmt->prepare(" SELECT @var AS var ")) // prepare command to select the database server session variable { $stmt->execute(); // execure $out_var = NULL; $stmt->bind_result($out_var); // bind $stmt->fetch(); // fetch one row echo $out_var.'<br />';// display OUT variable } } } ?> ---- Server IP: 69.147.83.199 Probable Submitter: 98.176.50.73 ---- Manual Page -- http://php.net/manual/en/mysqli.quickstart.stored-procedures.php Edit -- https://master.php.net/note/edit/112262 Del: integrated -- https://master.php.net/note/delete/112262/integrated Del: useless -- https://master.php.net/note/delete/112262/useless Del: bad code -- https://master.php.net/note/delete/112262/bad+code Del: spam -- https://master.php.net/note/delete/112262/spam Del: non-english -- https://master.php.net/note/delete/112262/non-english Del: in docs -- https://master.php.net/note/delete/112262/in+docs Del: other reasons-- https://master.php.net/note/delete/112262 Reject -- https://master.php.net/note/reject/112262 Search -- https://master.php.net/manage/user-notes.php