How to call a MySQL stored procedure from within PHP code?

by

I now found solution by using mysqli instead of mysql.

<?php 

// enable error reporting
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
//connect to database
$connection = mysqli_connect("hostname", "user", "password", "db", "port");

//run the store proc
$result = mysqli_query($connection, "CALL StoreProcName");

//loop the result set
while ($row = mysqli_fetch_array($result)){     
  echo $row[0] . " - " . + $row[1]; 
}

I found that many people seem to have a problem with using mysql_connect, mysql_query and mysql_fetch_array.

More Related Contents:

  1. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  2. inserting information and image in php and mysql
  3. mysqli or die, does it have to die?
  4. How to display errors for my MySQLi query? [duplicate]
  5. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  6. MySQL vs MySQLi when using PHP [closed]
  7. When should I use MySQLi instead of MySQL?
  8. How to get count of rows in MySQL table using PHP?
  9. Example of how to use bind_result vs get_result
  10. mysqli::query(): Couldn’t fetch mysqli
  11. PHP MySQLI Prevent SQL Injection [duplicate]
  12. How can I enable the MySQLi extension in PHP 7?
  13. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  14. How can I use mysqli_fetch_array() twice?
  15. Advantages Of MySQLi over MySQL [closed]
  16. check if the query results empty row mysqli [duplicate]
  17. PHP PDO and MySQLi [duplicate]
  18. using nulls in a mysqli prepared statement
  19. Store procedures in phpMyAdmin
  20. PHP: Calling MySQL Stored Procedure with Both INPUT AND OUTPUT Parameters (NOT “INOUT”)
  21. Is mysql_real_escape_string() necessary when using prepared statements?
  22. Updating from MYSQL to MYSQLI [duplicate]
  23. How to prepare statement for update query? [duplicate]
  24. php password_verify() hash and pass won’t match
  25. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  26. PHP to MySQL SSL Connections
  27. mysqli prepared statement num_rows returns 0 while query returns greater than 0 [duplicate]
  28. Using Prepared Statement, how I return the id of the inserted row?
  29. When should I close a database connection in PHP?
  30. MySqli Commands out of sync; you can’t run this command now [duplicate]

Leave a Comment