Add information through a stored procedure and PHP?

Question

I have a form which contains a lot of elements, my DB guy has generated an SP and now i need to call that stored procedure. My form has twenty elements, when i click on submit the data must be saved in database. I know how to do this on insert query, but how to call an SP and perform this operation.

There are 10 tables where the data is going to get saved.

Answer 1

I've never used stored procedures in MySQL, but it's no different from "plain" SQL queries, except you use CALL as the query keyword.

Instead of:

INSERT INTO table (column1, column2, column3) VALUES ('value 1', 'value 2', 3)

you do:

CALL function_name('value 1', 'value 2', 3);

(this is assuming your stored procedure is called function_name and takes 2 string arguments and a numeric argument.

Answer 2

use CALL see http://dev.mysql.com/tech-resources/articles/mysql-storedproc.html

Answer 3

PDO has a nice way of working with stored procedures through prepared statements. I strongly recommend working with it instead of working with "plain damn SQL".

<?php
// Calling a stored procedure with an output parameter
$stmt = $dbh->prepare("CALL sp_returns_string(?)");
$stmt->bindParam(1, $return_value, PDO::PARAM_STR, 4000); 

// call the stored procedure
$stmt->execute();

print "procedure returned $return_value\n";
?>