<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
$con = mysql_connect('localhost','root','123456') or die ('数据库链接错误 '.mysql_error());
$db = mysql_select_db('test');
mysql_query('set names utf8');
/*
$sql = "
create procedure myproce()
begin
INSERT INTO user (username,pass,real_name) VALUES ('ceshiuser', 'ceshipass', '张开广');
end;
";
$sql = "
create procedure myproce()
begin
UPDATE user SET real_name = '光光' WHERE user_id='2';
end;
";
mysql_query($sql);
unset($sql);
$sql = "
create procedure myproce()
begin
DELETE FROM user WHERE user_id='2';
end;
";
*/
$sql = "
create procedure myproce()
begin
SELECT * FROM user;
end;
";
mysql_query($sql);
unset($sql);
$sql = "call test.myproce();";
$rel = mysql_query($sql);
$row = mysql_fetch_array($rel);
var_dump($row);
<?php
$con = mysql_connect('localhost','root','123456') or die ('数据库链接错误 '.mysql_error());
$db = mysql_select_db('test');
mysql_query('set names utf8');
/*
$sql = "
create procedure myproce()
begin
INSERT INTO user (username,pass,real_name) VALUES ('ceshiuser', 'ceshipass', '张开广');
end;
";
$sql = "
create procedure myproce()
begin
UPDATE user SET real_name = '光光' WHERE user_id='2';
end;
";
mysql_query($sql);
unset($sql);
$sql = "
create procedure myproce()
begin
DELETE FROM user WHERE user_id='2';
end;
";
*/
$sql = "
create procedure myproce()
begin
SELECT * FROM user;
end;
";
mysql_query($sql);
unset($sql);
$sql = "call test.myproce();";
$rel = mysql_query($sql);
$row = mysql_fetch_array($rel);
var_dump($row);
?>