['type' => 'text', 'name' => 'user', 'size' => '25'],
'tag' => 'input',
'text' => '姓 名：',
],
[
'tag' => 'input',
'text' => '邮 箱：',
'attr' => ['type' => 'text', 'name' => 'email', 'size' => '25']
], [
'text' => '手机号码：',
'tag' => 'input',
'attr' => ['type' => 'text', 'name' => 'tel', 'size' => '25']
], [
'tag' => 'input',
'text' => '性 别：',
'attr' => ['type' => 'radio', 'name' => 'gender'],
'option' => ['m' => '男', 'w' => '女'],
'default' => 'm'
], [
'tag' => 'input',
'text' => '爱 好：',
'attr' => ['type' => 'checkbox', 'name' => 'hobby[]'],
'option' => ['swimming' => '游泳', 'reading' => '读书', 'running' => '跑步',],
'default' => ''
], [
'tag' => 'select',
'text' => '住 址：',
'attr' => ['name' => 'area'],
'option' => ['' => '--请选择--', 'BJ' => '北京', 'SH' => '上海', 'SZ' => '深圳',]
], [
'tag' => 'textarea',
'text' => '自我介绍：',
'attr' => ['name' => 'declare', 'cols' => '50', 'rows' => '5']
], [
'tag' => 'input',
'attr' => ['type' => 'submit', 'value' => '提交']
]
];
function generate($elements){
$items='';
$default=['tag'=>'','text'=>'','attr'=>[],'option'=>[],'default'=>''];
foreach($elements as $v){
$v= array_merge($default,$v);
$v['attr']=generate_attr($v['attr']);
$generate='generate_' . array_shift($v);
$items .='' . call_user_func_array($generate,$v) . '
';
}
return "";
}
function generate_attr($attr,$items=''){
foreach($attr as $k =>$v){
$items.="$k=\"$v\" ";
}
return $items;
}
function generate_input($text,$attr,$option,$default){
if(empty($option)){
$items = "";
}else{
$items='';
foreach ($option as $k => $v){
$checked=in_array($k,(array)$default,true)?'checked':'';
$items .="$v";
}
}
return "$text | $items | ";
}
function generate_textarea($text,$attr,$option,$default){
$textarea="";
return "$text | $textarea | ";
}
function generate_select($text,$attr,$option,$default){
$items='';
foreach($option as $k => $v){
$selected=($default ===$k)?'selected':'';
$items .="";
}
$select="";
return "$text | $select | ";
}
#$serverName = '47.120.42.125:888';
$serverName = 'db4free.net:3306';
$dbName = 'qixiaorantut';
#$dbUsername = 'root';
$dbUsername = 'qixiaorantut';
#$dbPassword = 'Jwj.258079';
$dbPassword = 'jwj258079';
$con=mysqli_connect($serverName,$dbUsername,$dbPassword,$dbName);
if (isset($_POST)){
$pattern="/^[a-zA-Z][a-zA-Z0-9_]{4,15}$/";
$name=$_POST['user'];
$email=$_POST['email'];
$phone=$_POST['tel'];
$sex=$_POST['gender'];
$hobby=$_POST['hobby'];
if($hobby!=null) $hobbys = join(",",$hobby);
$home=$_POST['area'];
$intro=$_POST['declare'];
if(preg_match($pattern,$name)){
$sql="insert into user values(null,'" . $name ."','" . $email ."','" . $phone ."','" . $sex ."','" . $hobbys ."','" . $home ."','" . $intro."');";
echo $sql;
$result = mysqli_query($con,$sql);
if($result && mysqli_affected_rows($con) > 0){
echo '添加成功';
var_dump(mysqli_insert_id($con));
}else{
echo '插入失败';
}
mysqli_close($con);
}else{
echo "帐号是否合法(字母开头，允许5-16字节，允许字母数字下划线)";
}
}
?>
Web表单生成器