快捷導(dǎo)航

PHP實(shí)現(xiàn)PDO操作mysql存儲(chǔ)過程示例

更新時(shí)間：2019年02月13日 11:00:09 作者：chengqiuming

這篇文章主要介紹了PHP實(shí)現(xiàn)PDO操作mysql存儲(chǔ)過程,結(jié)合具體實(shí)例形式分析了php使用pdo操作mysql存儲(chǔ)過程實(shí)現(xiàn)用戶注冊(cè)功能相關(guān)技巧,需要的朋友可以參考下

本文實(shí)例講述了PHP實(shí)現(xiàn)PDO操作mysql存儲(chǔ)過程。分享給大家供大家參考，具體如下：

一代碼

sql語句：

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;

index.php：

<!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>用戶注冊(cè)</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("請(qǐng)輸入用戶昵稱!");
     form.nc.select();
     return(false);
    }
  if(form.pwd.value==""){
     alert("請(qǐng)輸入注冊(cè)密碼!");
     form.pwd.select();
     return(false);
    }
     if(form.email.value==""){
     alert("請(qǐng)輸入E-mail地址!");
     form.email.select();
     return(false);
    }
    if(form.address.value==""){
     alert("請(qǐng)輸入家庭地址!");
     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">用戶注冊(cè)</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">注冊(cè)密碼：</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="注冊(cè)" 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 />
    版權(quán)所有&nbsp;吉林省**科技有限公司! 未經(jīng)授權(quán)禁止復(fù)制或建立鏡像!<br />
   Copyright &copy;&nbsp;, All Rights Reserved! <br />
   <br />
   建議您在大于1024*768的分辨率下使用 </div></td>
 </tr>
</table>
<?php
 if($_POST['submit']!=""){
     $dbms='mysql'; //數(shù)據(jù)庫類型 ,對(duì)于開發(fā)者來說，使用不同的數(shù)據(jù)庫，只要改這個(gè)，不用記住那么多的函數(shù)
    $host='localhost'; //數(shù)據(jù)庫主機(jī)名
    $dbName='db_database15'; //使用的數(shù)據(jù)庫
    $user='root'; //數(shù)據(jù)庫連接用戶名
    $pass='root'; //對(duì)應(yīng)的密碼
    $dsn="$dbms:host=$host;dbname=$dbName";
    try {
      $pdo = new PDO($dsn, $user, $pass); //初始化一個(gè)PDO對(duì)象，就是創(chuàng)建了數(shù)據(jù)庫連接對(duì)象$pdo
        $pdo->query("set names utf8"); //設(shè)置數(shù)據(jù)庫編碼格式
        $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 "數(shù)據(jù)添加成功！";
        }else{
            echo "數(shù)據(jù)添加失?。?;
        }
    } 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>

二運(yùn)行結(jié)果