PHP and MySQL Stored Procedure Exec Problem 


  • <?php

  • $Server = "127.0.0.1";

  • $DataBase = "tedt";

  • $UserName = "root";

  • $PassWord = "124@#";

  • $Conn = mysqli_connect($host, $UserName, $PassWord);

  • if(!$Conn)

  • {

  •     die("Could not connect to server : " . mysqli_error());

  • }

  • else

  • {

  •     mysqli_select_db($Conn,$DataBase) or die("Could not connect to database");

  • }

  • ?>

  • <?php

  • print "Procedure #1";



  • $res= $Conn->query("CALL storepro;");

  • print_r($res) ;

    • ?>

    Comments

    Post a Comment

    Popular posts from this blog

    codeigniter Deprecated error and A PHP Error was encountered [SOLVE]

    Deprecated : Assigning the return value of new by reference is deprecated in D:\xampp\htdocs\hes\system\codeigniter\Common.php on line 123    SOLVE to replace -> $objects[$class] =& new $name(); to $objects[$class] = new $name(); Deprecated : Assigning the return value of new by reference is deprecated in D:\xampp\htdocs\hes\system\codeigniter\Common.php on line 129   SOLVE to replace ->  $objects[$class] =& new $name(); to $objects[$class] =new $name();   A PHP Error was encountered Severity: 8192 Message: Function set_magic_quotes_runtime() is deprecated Filename: codeigniter/CodeIgniter.php Line Number: 60 SOLVE to replace - set_magic_quotes_runtime(0);  to ini_set("magic_quotes_runtime",0); then restart your web server application.,.,. A PHP Error was encountered Severity: 8192 Message: Assigning the return value of new by reference is deprecated Filename: libraries/Loader.php Line Number: 248 SOLVE to replace -     ...
    Read more

    how to check ban-word user in put using php

    function banned_words_chk($phrase) { global $conn, $config; $query = "SELECT word from bans_words"; $executequery = $conn->Execute($query); $bwords = $executequery->getarray(); $found = 0; $words = explode(" ", $phrase); foreach($words as $word) { foreach($bwords as $bword) { if($word == $bword[0]) { $found++; } else { $pos2 = strpos($word, $bword[0]); if($pos2 !== false) { $found++; } } } } if($found > 0) { return true; } else { return false; } } ------------------------------------------------------------- if you helpful my code please donate some few amount to developing and free to post. -------------------------------------------------------------
    Read more

    Difference between session_register and $_SESSION[] in phpsession_register and $_SESSION[] in php

    We can use either   session_register   or $_SESSION for registering session variable in php. Find below the difference between both of them.   session_register () is a   function   and   $_SESSION   is a superglobal   array . session_register() is used to register a session variable and it works only when register_globals is   turned on . ( Turning ON register_globals will create mesh-ups, but some applications (e.g OScommerce) requires turning ON of register_globals) But $_SESSION works even when register_globals is turned off. If   session_start()   was not called before   session_register()   is called, an implicit call to session_start() with no parameters will be made. But $_SESSION requires session_start() before use. session_register function returns boolean value and $_SESSION returns string value session_register() function has been DEPRECATED as of PHP 5.3.0 and REMOVED as of PHP 6.0.0. We know that Webpages ar...
    Read more