PHP MySQL 5.0 stored procedure

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 402,659 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,248 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 24384 | Replies: 2

•

Join Date: Jan 2006

Posts: 29

Reputation: rcasinillo_s is an unknown quantity at this point

Rep Power: 3

Solved Threads: 0

rcasinillo_s rcasinillo_s is offline

Offline

Light Poster

PHP MySQL 5.0 stored procedure

Mar 15th, 2006

Any could give me a PHP script on how to call or execute mysql stored procedure.

Thank you.

Roland

•

Join Date: Mar 2006

Posts: 2

Reputation: ameer is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

ameer

Offline

Newbie Poster

Re: PHP MySQL 5.0 stored procedure

Mar 21st, 2006

Before you installed the php_mysqli.dll

<?php

/* Connect to a MySQL server */
$link = mysqli_connect(
'localhost', /* The host to connect to */
'root', /* The user to connect as */
'root', /* The password to use */
'db_name'); /* The default database to query */

if (!$link) {
printf("Can't connect to MySQL Server. Errorcode: %s\n", mysqli_connect_error());
exit;
}

/* Send a query to the server */
if ($result = mysqli_query($link, "call se_proc('crm')")) {

/* Fetch the results of the query */
while( $row = mysqli_fetch_array($result) ){

echo ($row[0]. "--------- SR. " . $row[1] . "<br>");

}

/* Destroy the result set and free the memory used for it */
mysqli_free_result($result);
}

/* Close the connection */
mysqli_close($link);
?>