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

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

一代碼

sql語(yǔ)句：

createprocedurepro_reg(inncvarchar(80),inpwdvarchar(80),inemailvarchar(80),inaddressvarchar(50))

begin

insertintotb_reg(name,pwd,email,address)values(nc,pwd,email,address);

index.php：

!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN"

"/TR/xhtml1/DTD/xhtml1-transitional.dtd"

htmlxmlns="/1999/xhtml"

head

metahttp-equiv="Content-Type"content="text/html;charset=utf-8"/

title用戶注冊(cè)/title

linkrel="stylesheet"type="text/css"href="style.css"rel="externalnofollow"

/head

scriptlanguage="javascript"

functionchkinput(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

tablewidth="200"border="0"align="center"cellpadding="0"cellspacing="0"

tdimgsrc="images/banner.gif"width="500"height="65"http://td

/tr

/table

tablewidth="500"height="10"border="0"align="center"cellpadding="0"cellspacing="0"

td/td

/tr

/table

tablewidth="500"border="0"align="center"cellpadding="0"cellspacing="0"

tdbgcolor="#1170FF"tablewidth="500"height="157"border="0"align="center"cellpadding="0"cellspacing="1"

formname="form1"method="post"action="index.php"onsubmit="returnchkinput(this)"

tdheight="25"colspan="2"bgcolor="#B5D3FF"divalign="center"用戶注冊(cè)/div/td

/tr

tdwidth="150"height="25"bgcolor="#FFFFFF"divalign="center"用戶昵稱：/div/td

tdwidth="347"bgcolor="#FFFFFF"nbsp;inputtype="text"name="nc"size="25"/td

/tr

tdheight="25"bgcolor="#FFFFFF"divalign="center"注冊(cè)密碼：/div/td

tdheight="25"bgcolor="#FFFFFF"nbsp;inputtype="password"name="pwd"size="25"/td

/tr

tdheight="25"bgcolor="#FFFFFF"divalign="center"E-mail：/div/td

tdheight="25"bgcolor="#FFFFFF"nbsp;inputtype="text"name="email"size="25"/td

/tr

tdheight="25"bgcolor="#FFFFFF"divalign="center"家庭住址：/div/td

tdheight="25"bgcolor="#FFFFFF"nbsp;inputtype="text"name="address"size="25"/td

/tr

tdheight="25"colspan="2"bgcolor="#FFFFFF"divalign="center"inputtype="submit"name="submit"value="注冊(cè)"nbsp;nbsp;inputtype="reset"value="重寫"/div/td

/tr

/form

/table/td

/tr

/table

tablewidth="600"height="80"border="0"align="center"cellpadding="0"cellspacing="0"

tddivalign="center"br/

版權(quán)所有nbsp;吉林省**科技有限公司!未經(jīng)授權(quán)禁止復(fù)制或建立鏡像!br/

Copyrightcopy;nbsp;,AllRightsReserved!br/

br/

建議您在大于1024*768的分辨率下使用/div/td

/tr

/table

if($_POST['submit']!=""){

$dbms='mysql';//數(shù)據(jù)庫(kù)類型,對(duì)于開發(fā)者來說，使用不同的數(shù)據(jù)庫(kù)，只要改這個(gè)，不用記住那么多的函數(shù)

$host='localhost';//數(shù)據(jù)庫(kù)主機(jī)名

$dbName='db_database15';//使用的數(shù)據(jù)庫(kù)

$user='root';//數(shù)據(jù)庫(kù)連接用戶名

$pass='root';//對(duì)應(yīng)的密碼

$dsn="$dbms:host=$host;dbname=$dbName";

try{

$pdo=newPDO($dsn,$user,$pass);//初始化一個(gè)PDO對(duì)象，就是創(chuàng)建了數(shù)據(jù)庫(kù)連接對(duì)象$pdo

$pdo-query("setnamesutf8");//設(shè)置數(shù)據(jù)庫(kù)編碼格式

$pdo-setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

$nc=$_POST['nc'];

$pwd=md5($_POST['pwd']);

$email=$_POST['email'];

$address=$_POST['address'];

$query="callpro_reg('$nc','$pwd','$email','$address')";

$result=$pdo-prepare($query);

if($result-execute()){

echo"數(shù)據(jù)添加成功！";

}else{

echo"數(shù)據(jù)添加失敗！";

}catch(PDOException$e){

echo'PDOExceptionCaught.';

echo'Errorwiththedatabase:br/

echo'SQLQuery:'.$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)