PHP MySQL 5.0 stored procedure

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

 
0
  #1
Mar 15th, 2006
Any could give me a PHP script on how to call or execute mysql stored procedure.

Thank you.

Roland
Reply With Quote Quick reply to this message  
•
•
Join Date: Mar 2006
Posts: 2
Reputation: ameer is an unknown quantity at this point 
Solved Threads: 1
ameer ameer is offline Offline
Newbie Poster

Re: PHP MySQL 5.0 stored procedure

 
0
  #2
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);
?>
Reply With Quote Quick reply to this message  
•
•
Join Date: May 2008
Posts: 2
Reputation: kladizkov is an unknown quantity at this point 
Solved Threads: 1
kladizkov kladizkov is offline Offline
Newbie Poster

Re: PHP MySQL 5.0 stored procedure

 
0
  #3
May 4th, 2008
Oh it was simple, just execute "call proc_name"

http://fabinm.com/content/view/17/9/
Reply With Quote Quick reply to this message  
•
•
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

 
0
  #4
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.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jan 2009
Posts: 16
Reputation: mazeroth is an unknown quantity at this point 
Solved Threads: 3
mazeroth mazeroth is offline Offline
Newbie Poster

Re: PHP MySQL 5.0 stored procedure

 
0
  #5
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/
Reply With Quote Quick reply to this message  
•
•
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

 
0
  #6
Jul 13th, 2009
•
•
•
•
Originally Posted by thinktejas View Post
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
Reply With Quote Quick reply to this message  
•
•
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

 
0
  #7
Jul 16th, 2009
•
•
•
•
Originally Posted by thinktejas View Post
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.
Reply With Quote Quick reply to this message  
•
•
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
 
0
  #8
29 Days Ago
mysql Syntax (Toggle Plain Text) 
  1. DROP PROCEDURE IF EXISTS `UsersR_DELETE_byPK` 
  2. GO
  3.  
  4. CREATE PROCEDURE UsersR_DELETE_byPK
  5.    (
  6.         IN  UsersID             INT(11) 
  7. )	
  8. BEGIN 
  9.  
  10.    DELETE FROM UsersR   
  11.  
  12.            WHERE  UsersID=UsersID;
  13.  
  14.  
  15.   END
it is my stored proceder how to call php code perfom delete operation
Last edited by nav33n; 29 Days Ago at 6:25 am. Reason: Please use [code] tags to wrap your code.
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread has been marked solved.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the PHP Forum
Thread Tools Search this Thread



Tag cloud for PHP
.htaccess access ajax apache api array beginner binary broken cakephp checkbox class cms code cron curl data database date directory display download dynamic echo email error file files folder foreach form forms function functions google href htaccess html httppost image include insert integration ip java javascript joomla limit link links login loop mail md5 menu mlm mod_rewrite multiple mysql mysql_real_escape_string oop parse paypal pdf php problem query radio random recursion regex remote replace script search server session sessions sms soap source space sql structure syntax system table tutorial update upload url validation validator variable video volume votedown web xml youtube
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC