Delimiter // Create procedure insertuser(in username varchar(20),in userpwd varchar(32)) Begin Insert into welefen.user(Name,Pwd) values (username,md5(userpwd)); End // 驗證用戶的存儲過程,代碼如下:
Delimiter // Create procedure validateuser(in username varchar(20),out param1) Begin Select Pwd into param1 from welefen.user where Name=username; End // 修改密碼的存儲過程,代碼如下:
Delimiter // Create procedure modifyPwd(in username varchar(20),in userpwd varchar(32)) Begin Update welefen.user set Pwd=md5(userpwd) where Name=username; End // 刪除用戶的存儲過程,代碼如下:
Delimiter // Create procedure deleteuser(in username varchar(20)) Begin delete from welefen.user where Name=username; End // 在客戶端,我們給出如下的程序,代碼如下:
<?php if (!mysql_connect("localhost","root","welefen")){ echo "連接數據庫失敗"; } if (!mysql_select_db("welefen")){ echo "選擇數據庫表失敗<br>"; }
