PHP实现PDO操作mysql存储过程示例

create procedure pro_reg (in nc varchar(80), in pwd varchar(80), in email varchar(80),in address varchar(50))
begin
insert into tb_reg (name, pwd ,email ,address) values (nc, pwd, email, address);
end;

!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
html xmlns="http://www.w3.org/1999/xhtml">
head>
meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
title>用户注册/title>
link rel="stylesheet" type="text/css" href="style.css" rel="external nofollow" >
/head>
script language="javascript">
 function chkinput(form){
  if(form.nc.value==""){
     alert("请输入用户昵称!");
     form.nc.select();
     return(false);
    }
  if(form.pwd.value==""){
     alert("请输入注册密码!");
     form.pwd.select();
     return(false);
    }
     if(form.email.value==""){
     alert("请输入E-mail地址!");
     form.email.select();
     return(false);
    }
    if(form.address.value==""){
     alert("请输入家庭地址!");
     form.address.select();
     return(false);
    }
  return(true);
 }
/script>
body>
table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
 tr>
  td>img src="images/banner.gif" width="500" height="65" />/td>
 /tr>
/table>
table width="500" height="10" border="0" align="center" cellpadding="0" cellspacing="0">
 tr>
  td>/td>
 /tr>
/table>
table width="500" border="0" align="center" cellpadding="0" cellspacing="0">
 tr>
  td bgcolor="#1170FF">table width="500" height="157" border="0" align="center" cellpadding="0" cellspacing="1">
   form name="form1" method="post" action="index.php" onsubmit="return chkinput(this)">
     tr>
    td height="25" colspan="2" bgcolor="#B5D3FF">div align="center">用户注册/div>/td>
   /tr>
   tr>
    td width="150" height="25" bgcolor="#FFFFFF">div align="center">用户昵称：/div>/td>
    td width="347" bgcolor="#FFFFFF">nbsp;input type="text" name="nc" class="inputcss" size="25">/td>
   /tr>
   tr>
    td height="25" bgcolor="#FFFFFF">div align="center">注册密码：/div>/td>
    td height="25" bgcolor="#FFFFFF">nbsp;input type="password" name="pwd" class="inputcss" size="25">/td>
   /tr>
   tr>
    td height="25" bgcolor="#FFFFFF">div align="center">E-mail：/div>/td>
    td height="25" bgcolor="#FFFFFF">nbsp;input type="text" name="email" class="inputcss" size="25">/td>
   /tr>
   tr>
    td height="25" bgcolor="#FFFFFF">div align="center">家庭住址：/div>/td>
    td height="25" bgcolor="#FFFFFF">nbsp;input type="text" name="address" class="inputcss" size="25">/td>
   /tr>
   tr>
    td height="25" colspan="2" bgcolor="#FFFFFF">div align="center">input type="submit" name="submit" value="注册" class="buttoncss">nbsp;nbsp;input type="reset" value="重写" class="buttoncss">/div>/td>
   /tr>
     /form>
  /table>/td>
 /tr>
/table>
table width="600" height="80" border="0" align="center" cellpadding="0" cellspacing="0">
 tr>
  td>div align="center">br />
    版权所有nbsp;吉林省**科技有限公司! 未经授权禁止复制或建立镜像!br />
   Copyright copy;nbsp;, All Rights Reserved! br />
   br />
   建议您在大于1024*768的分辨率下使用 /div>/td>
 /tr>
/table>
?php
 if($_POST['submit']!=""){
     $dbms='mysql'; //数据库类型 ,对于开发者来说，使用不同的数据库，只要改这个，不用记住那么多的函数
    $host='localhost'; //数据库主机名
    $dbName='db_database15'; //使用的数据库
    $user='root'; //数据库连接用户名
    $pass='root'; //对应的密码
    $dsn="$dbms:host=$host;dbname=$dbName";
    try {
      $pdo = new PDO($dsn, $user, $pass); //初始化一个PDO对象，就是创建了数据库连接对象$pdo
        $pdo->query("set names utf8"); //设置数据库编码格式
        $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
         $nc=$_POST['nc'];
      $pwd=md5($_POST['pwd']);
      $email=$_POST['email'];
      $address=$_POST['address'];
        $query="call pro_reg('$nc','$pwd','$email','$address')";
        $result=$pdo->prepare($query);
        if($result->execute()){
            echo "数据添加成功！";
        }else{
            echo "数据添加失败！";
        }
    } catch (PDOException $e) {
      echo 'PDO Exception Caught.';
        echo 'Error with the database:br/>';
        echo 'SQL Query: '.$query;
        echo 'pre>';
      echo "Error: " . $e->getMessage(). "br/>";
        echo "Code: " . $e->getCode(). "br/>";
        echo "File: " . $e->getFile(). "br/>";
        echo "Line: " . $e->getLine(). "br/>";
        echo "Trace: " . $e->getTraceAsString(). "br/>";
        echo '/pre>';
    }
 }
?>
/body>
/html>