for PHP code
| From: | jeeson john | Date: | Tue, 10 May 2011 07:23:51 +0000 |
| Subject: | for PHP code | ||
| Groups: | php.webmaster | ||
| Request: | Send a blank email to php-webmaster+get-10981@lists.php.net to get a copy of this message | ||
i have a database "employee" with values
my stored procedure is below, how to get the select value at front end ,
please give the PHP code...
DELIMITER $$
DROP PROCEDURE IF EXISTS
jeeson.emp_select$$
CREATE DEFINER=root@localhost PROCEDURE emp_select
(
as_mode varchar(1)
)
BEGIN
IF as_mode = 'S' THEN
SELECT
employee.emp_id,employee.name,employee.designation_id,employee.adress,employee.phone,employee.email,employee.date_of_birth
FROM employee
;
END IF;
END$$
DELIMITER ;