DaniWeb Forum Index > Web Development > PHP

PHP MySQL 5.0 stored procedure

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jan 2006

Posts: 29

Reputation: rcasinillo_s is an unknown quantity at this point

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

Solved Threads: 1

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);
?>

•

Join Date: May 2008

Posts: 2

Reputation: kladizkov is an unknown quantity at this point

Solved Threads: 1

kladizkov

Offline

Newbie Poster

Re: PHP MySQL 5.0 stored procedure

May 4th, 2008

Oh it was simple, just execute "call proc_name"

http://fabinm.com/content/view/17/9/

•

Join Date: Sep 2008

Posts: 3

Reputation: thinktejas is an unknown quantity at this point

Solved Threads: 1

thinktejas thinktejas is offline

Offline

Newbie Poster

Re: PHP MySQL 5.0 stored procedure

Sep 10th, 2008

There is an article on this site which shows how to access Mysql Stored procedures using PDO and PHP
http://tejuspratap.co.cc/2008/08/29/...-using-php-50/

Last edited by thinktejas; Sep 10th, 2008 at 4:39 am.

•

Join Date: Jan 2009

Posts: 16

Reputation: mazeroth is an unknown quantity at this point

Solved Threads: 3

mazeroth

Offline

Newbie Poster

Re: PHP MySQL 5.0 stored procedure

Jan 27th, 2009

Here's a quick tutorial on executing mysql stored procedures in php using mysql, mysqli, and pdo for the people using the different database extension:

http://www.joeyrivera.com/2009/using...ysqlmysqlipdo/

•

Join Date: Sep 2008

Posts: 3

Reputation: thinktejas is an unknown quantity at this point

Solved Threads: 1

thinktejas thinktejas is offline

Offline

Newbie Poster

Re: PHP MySQL 5.0 stored procedure

Jul 13th, 2009

•

Originally Posted by thinktejas

There is an article on this site which shows how to access Mysql Stored procedures using PDO and PHP
http://tejuspratap.co.cc/2008/08/29/...-using-php-50/

The article has been moved to http://www.tejuspratap.com/main/node/18

•

Join Date: Sep 2008

Posts: 3

Reputation: thinktejas is an unknown quantity at this point

Solved Threads: 1

thinktejas thinktejas is offline

Offline

Newbie Poster

Re: PHP MySQL 5.0 stored procedure

Jul 16th, 2009

•

Originally Posted by thinktejas

The article has been moved to http://www.tejuspratap.com/main/node/18

I am sorry I gave the wrong url before.

The article has been moved to http://www.tejuspratap.com/main/cont...s-using-php-50

Last edited by thinktejas; Jul 16th, 2009 at 4:26 am. Reason: I gave the wrong url before.

•

Join Date: Nov 2009

Posts: 2

Reputation: kbramprasath is an unknown quantity at this point

Solved Threads: 0

kbramprasath kbramprasath is offline

Offline

Newbie Poster

Nov 16th, 2009

 Help with Code Tags 
 mysql Syntax (Toggle Plain Text) 
DROP PROCEDURE IF EXISTS `UsersR_DELETE_byPK` 
GO
 
CREATE PROCEDURE UsersR_DELETE_byPK
   (
        IN  UsersID             INT(11) 
)	
BEGIN 
 
   DELETE FROM UsersR   
 
           WHERE  UsersID=UsersID;
 
 
  END
DROP PROCEDURE IF EXISTS `UsersR_DELETE_byPK` 
GO

CREATE PROCEDURE UsersR_DELETE_byPK
   (
        IN  UsersID             INT(11) 
)	
BEGIN 

   DELETE FROM UsersR   
                     
           WHERE  UsersID=UsersID;
                             
        
  END

it is my stored proceder how to call php code perfom delete operation

Last edited by nav33n; Nov 16th, 2009 at 6:25 am. Reason: Please use [code] tags to wrap your code.

•

Join Date: Dec 2009

Posts: 1

Reputation: topspindex is an unknown quantity at this point

Solved Threads: 0

topspindex topspindex is offline

Offline

Newbie Poster

5 Days Ago

•

Originally Posted by rcasinillo_s

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

Thank you.

Roland

I'll give you a very simple connection.. and how to call a procedure very simply. here it is -
------->
//first create a connection to your database...
function connection(){
$mysqli = new mysqli('$hostname','$dbusername', '$dbpassword', '$dbname');
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

return $mysqli;

}
//second create the function to call the stored procedure
function query($query){
//call the connection function
if($result = connection()->query($query)){
while($row = $result->fetch_assoc()){
$data[] = $row;
}
return $data;
}else {
print('error on:'.$query.mysqli_error($this));
}
}
//then call the function to execute stored procedure
query("call store_proc('$param1')");
done! it's that simple... thanks

http://quijanod.co.cc/