<?php
$host = $_POST["host"];
$name = $_POST["name"];
$pass = $_POST["pass"];
$data = $_POST["data"];
$tabl = $_POST["tabl"];
$firs = $_POST["firstname"];
$age = $POST["age"];
$sex = $_POST["SEX"];
$con = mysql_connect($host,$name,$pass);
if(mysql_query("create database $data",$con)){
if(mysql_select_db($data,$con)){
if(mysql_query("create table $tabl(name varchar(20),age int,sex varchar(2))",$con)){
$sql = "INSERT INTO $tabl(name,age,sex)values('$firs',$age,$sex)";
if(mysql_query($sql,$con)){
echo "ok";
}
}
}
}
mysql_close($con);
?>另外,不知道这段代码可以封装码?
$host = $_POST["host"];
$name = $_POST["name"];
$pass = $_POST["pass"];
$data = $_POST["data"];
$tabl = $_POST["tabl"];
$firs = $_POST["firstname"];
$age = $POST["age"];
$sex = $_POST["SEX"];
$con = mysql_connect($host,$name,$pass);
if(mysql_query("create database $data",$con)){
if(mysql_select_db($data,$con)){
if(mysql_query("create table $tabl(name varchar(20),age int,sex varchar(2))",$con)){
$sql = "INSERT INTO $tabl(name,age,sex)values('$firs',$age,$sex)";
if(mysql_query($sql,$con)){
echo "ok";
}
}
}
}
mysql_close($con);
?>另外,不知道这段代码可以封装码?
表创建成功了,字段也有,其实我就不懂sql语句,就会创建库,创建表,这么两句。
$POST["age"]; //这个错了吧???$_POST 才对
echo $sql;exit; echo一下,然后把语句粘到mysql里面直接运行一下就知道了