DaniWeb Forum Index > Web Development > PHP

how to create-call stored procedure

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

Reply

•

•

Join Date: Apr 2006

Posts: 62

Reputation: Fenerbahce is an unknown quantity at this point

Fenerbahce is an unknown quantity at this point

Solved Threads: 0

Fenerbahce Fenerbahce is offline

Fenerbahce is offline

Offline

Junior Poster in Training

how to create-call stored procedure

0

#1

Apr 7th, 2008

Hi,
I want to call a stored procedure for the below php code. How can i create a stored procedure and call it for below program instead. Mysql please.
Thanks.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$comboSecenek=$_POST["ComboBox"];
$adet=$_POST["adet"];
 
$sql = "UPDATE product SET amount = amount + '$adet' WHERE name = '$comboSecenek'";
$comboSecenek=$_POST["ComboBox"];
$adet=$_POST["adet"];

$sql = "UPDATE product SET amount = amount + '$adet' WHERE name = '$comboSecenek'";

Last edited by peter_budo; Apr 7th, 2008 at 8:50 pm. Reason: Double post

Reply With Quote

Quick reply to this message

•

•

Join Date: Jul 2006

Posts: 883

Reputation: pritaeas will become famous soon enough

pritaeas will become famous soon enough

pritaeas will become famous soon enough

Solved Threads: 144

pritaeas is offline

Offline

Practically a Posting Shark

Re: how to create-call stored procedure

0

#2

Apr 8th, 2008

http://dev.mysql.com/doc/refman/5.0/...procedure.html

http://dev.mysql.com/doc/refman/5.0/en/call.html

Reply With Quote

Quick reply to this message

Reply

Quick Reply to Thread

Show Printable Version

Similar Threads

Getting OUTPUT values back from SQL Stored Procedure (C#)
Calling and executing stored Procedure (C)
Can we call a User defined Function using Linked Servers ? (MS SQL)
how to create a sql table through coding in vb.net (IT Professionals' Lounge)
C# calling parameterized Oracle storage procedure ? (C#)
Long ado net question but urgent help required (ASP.NET)
how do I run a "disconnected" stored procedure (MS SQL)
Stored procedure call with ADO (C)
Retrieving a field from a SQL procedure (ASP)

Other Threads in the PHP Forum

Previous Thread: Help requested with sorting results into groups
Next Thread: want to pass php variable to javascript

Views: 1660 | Replies: 1

Thread Tools	Search this Thread
Show Printable Version Email this Page

About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy |