|
|
Posted by Jeff on 01/22/07 10:31
Hey
I've created a stored procedure in a MySql5 database, and now I want to call
this SP from my php (php version 5.2.0) code.
Basically I don't know how to call this SP so that my php code can retrieve
the id (see parameter list in my SP, this parameter is a INOUT parameter)
parameter, so I post here just in case some of you have some tips about
this.
I want to use the object-oriented approach of mysqli
CREATE PROCEDURE SaveProperty ( INOUT id int unsigned, field1 int, field2
int)
BEGIN
DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
ROLLBACK;
END;
START TRANSACTION;
IF (id IS NULL) THEN
INSERT INTO Property (Field1, Field2) VALUES (field1, field2);
ELSE
UPDATE Property Set Field1 = field1, Field2 = field2 WHERE Id = id;
END IF;
COMMIT;
END;
Jeff
Navigation:
[Reply to this message]
|