PHP MySQLi Stored Procedures return call

I cannot figure a way to retrieve the return statement in PHP. It works just perfect in MySQL, but this from PHP doesn’t for some reason.

PHP Code:


<?php

        
public function call()

        {

          
$out = array();

            echo 
'<pre>';

            if ($this->multi_query("CALL testOut(@outvar); SELECT @outvar;"))

            {

                do

                {

                    if (
$result $this->store_result())

                    {

                        while (
$row $result->fetch_object())

                        {

                            
$out[] = $row;

                        }

                        $result->close();

                    }

                    $this->next_result();

                }

                while (
$this->more_results());

            }

            var_dump($out);

            return (array) $out;

        }

?>


View full post on Webmaster-Talk.com

, , , ,

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Get Adobe Flash playerPlugin by wpburn.com wordpress themes


RSS Site FeedRSS Site Feed

© 1992-2011 DC2NET™, Inc. All Rights Reserved