PHP 连接 MySQL 访问存储过程 CreateName3() 实例：生成随机姓名

PHP 连接 MySQL 访问存储过程 CreateName3() 实例：生成随机姓名

}

/*

delimiter // CREATE FUNCTION CreateName3() RETURNS varchar(60) CHARSET utf8 begin DECLARE MN VARCHAR(500); DECLARE FN VARCHAR(500); DECLARE MN_N INT; DECLARE FN_N INT; DECLARE RES VARCHAR(30) default ''; declare c_n int; DEClare n int default 1; SET MN='伟刚勇毅俊云莲真环雪荣爱妹霞莺媛艳瑞凡佳嘉琼勤珍贞莉桂娣叶璧才发武丽琳轮翰朗伯宏若鸣朋斌梁栋维启克伦翔旭鹏泽晨以建家致树炎德河哲江超浩璐娅琦晶裕华慧巧美婕馨影荔枝思邦承乐绍功松善厚庆磊民友萍红娥玲芬芳燕彩兰凤洁梅秀娟英时泰盛雄琛钧冠策腾楠榕风航弘'; SET FN='伟刚勇毅俊云莲真环雪荣爱妹霞莺媛艳瑞凡佳嘉琼勤珍贞莉桂娣叶璧才发武丽琳轮翰朗伯宏若鸣朋斌梁栋维启克伦翔旭鹏泽晨以建家致树炎德河哲江超浩璐娅琦晶裕华慧巧美婕馨影荔枝思邦承乐绍功松善厚庆磊民友萍红娥玲芬芳燕彩兰凤洁梅秀娟英时泰盛雄琛钧冠策腾楠榕风航弘峰强军平保东辉明永健世志义兴良海仁波宁贵福龙元全国胜学祥才发武新利清飞彬富顺信杰涛昌成康星光天达安岩中茂进林有坚和彪博诚先敬震振壮会思群豪邦承乐绍功松善厚庆磊民友裕河哲江超浩亮政谦亨奇固之轮翰朗伯宏若鸣朋斌梁栋维启克伦翔旭鹏泽晨以建家致树炎德时泰盛雄琛钧冠策腾楠榕风航弘'; SET MN_N=CHAR_LENGTH(MN); SET FN_N=CHAR_LENGTH(FN);

loop_1:loop
set c_n=round(rand()*100,0)%2;
if c_n =1 then
 set RES=Concat(RES,Concat(substring(MN,ceil(rand()*MN_N),1),
                           substring(FN,ceil(rand()*FN_N),1)));
                           else
                            set RES=Concat(RES,substring(MN,ceil(rand()*MN_N),1));
                           end if;
set RES=Concat(RES,',');               
                           set n=n+1;
                           if n>10 then
                           leave loop_1;
                           end if;
 end loop;
 return RES;

End// delimiter ;

delimiter // create function CreateName2() RETURNS varchar(3) charset utf8 begin DECLARE MN VARCHAR(500); DECLARE FN VARCHAR(500); DECLARE MN_N INT; DECLARE FN_N INT; SET MN='伟刚勇毅俊云莲真环雪荣爱妹霞莺媛艳瑞凡佳嘉琼勤珍贞莉桂娣叶璧才发武丽琳轮翰朗伯宏若鸣朋斌梁栋维启克伦翔旭鹏泽晨以建家致树炎德河哲江超浩璐娅琦晶裕华慧巧美婕馨影荔枝思邦承乐绍功松善厚庆磊民友萍红娥玲芬芳燕彩兰凤洁梅秀娟英时泰盛雄琛钧冠策腾楠榕风航弘峰强军平保东辉明永健世志义兴良海仁波宁贵福龙元全国胜学祥才发武新利清飞彬富顺信杰涛昌成康星光天达安岩中茂进林有坚和彪博诚先敬震振壮会思群豪邦承乐绍功松善厚庆磊民友裕河哲江超浩亮政谦亨奇固之轮翰朗伯宏若鸣朋斌梁栋维启克伦翔旭鹏泽晨以建家致树炎德时泰盛雄琛钧冠策腾楠榕风航弘'; SET FN='伟刚勇毅俊云莲真环雪荣爱妹霞莺媛艳瑞凡佳嘉琼勤珍贞莉桂娣叶璧才发武丽琳轮翰朗伯宏若鸣朋斌梁栋维启克伦翔旭鹏泽晨以建家致树炎德河哲江超浩璐娅琦晶裕华慧巧美婕馨影荔枝思邦承乐绍功松善厚庆磊民友萍红娥玲芬芳燕彩兰凤洁梅秀娟英时泰盛雄琛钧冠策腾楠榕风航弘峰强军平保东辉明永健世志义兴良海仁波宁贵福龙元全国胜学祥才发武新利清飞彬富顺信杰涛昌成康星光天达安岩中茂进林有坚和彪博诚先敬震振壮会思群豪邦承乐绍功松善厚庆磊民友裕河哲江超浩亮政谦亨奇固之轮翰朗伯宏若鸣朋斌梁栋维启克伦翔旭鹏泽晨以建家致树炎德时泰盛雄琛钧冠策腾楠榕风航弘'; SET MN_N=CHAR_LENGTH(MN); SET FN_N=CHAR_LENGTH(FN); return Concat(substring(MN,ceil(rand()*MN_N),1),substring(FN,ceil(rand()*FN_N),1)); End// delimiter ;

*/

function test_input($data) { $data = trim($data); $data = stripslashes($data); $data = htmlspecialchars($data); return $data; }

if(isset($_POST['button1'])) {

@ $db = mysqli_connect('localhost','root','123456','test');
	if(mysqli_connect_errno()){
 	 echo 'Error: Could not connect to mysql database.';
 	 exit;
	}
	mysqli_query($db,'set names utf8'); 
	
	  //  global $farr;

	$childName= $_SESSION['farr'];
	$q = 'insert into child(parent_id,name, birthdate, sex, time,password) values(2,'$childName','2023/2/3','male','2021/2/3','12345')';
	//$result = mysqli_query($db,$q);
	  if (mysqli_query($db,$q)) 
	  {
	       echo 'New record created successfully234';
	    } else {
	       echo 'Error: ' . $q . '' . mysqli_error($db);
	    }


	
	mysqli_close($db);

// echo '这是按钮1被选中'; }

if(isset($_POST['button2'])) {

$b=133;
//GLOBAL $farr;
$a= $_SESSION['farr'];
echo '<script type='text/javascript'>alert('$a');</script>';

$arr_arg=array($a,$b);

//使用implode函数将数组桥接成一个字符串

$arg=implode('-',$arr_arg);

//定向到b.php

header('Location: b.php?arg='.urlencode($arg));
//echo '这是被选中的按钮2';

}

?>

<input type='submit' name='button1' value='按钮1'/>
  <input type='submit' name='button2' value='按钮2'/>