0) {
$tableExist = true;
}else{
$tableExist = false;
}
if(!$tableExist){
if($table == 'user_70'){
$query_string = "create table user_70(name char(50),address char(50),password char(50))ENGINE=MyISAM DEFAULT CHARSET=utf8";
mysqli_query($link,$query_string);
$query_string = "insert into user_70(name,address,password)values('mike','chengdu','c4ca4238a0b923820dcc509a6f75849b')";
mysqli_query($link,$query_string);
$query_string = "insert into user_70(name,address,password)values('mike','beijing','c4ca4238a0b923820dcc509a6f75849b')";
mysqli_query($link,$query_string);
$query_string = "insert into user_70(name,address,password)values('tom','chengdu','c4ca4238a0b923820dcc509a6f75849b')";
mysqli_query($link,$query_string);
$query_string = "insert into user_70(name,address,password)values('rose','chengdu','c4ca4238a0b923820dcc509a6f75849b')";
mysqli_query($link,$query_string);
}
else if($table == 'nucleic_acid_test_2'){
$eventTime=mktime(12,12,12,12,12,2022);
$query_string = "create table nucleic_acid_test_2(id varchar(50),name varchar(50),address varchar(50),event_time int,insert_time int,code varchar(1))ENGINE=MyISAM DEFAULT CHARSET=utf8";
mysqli_query($link,$query_string);
$query_string = "insert into nucleic_acid_test_2(id,name,address,event_time,insert_time,code)values('510103199010210012','mike','shanghai',$eventTime,'1597238637','3')";
mysqli_query($link,$query_string);
$query_string ="insert into nucleic_acid_test_2(id,name,address,event_time,insert_time,code)values('510103198310607013','rose','beijing',$eventTime,'1597242237','2')";
mysqli_query($link,$query_string);
}else if($table == 'patient_90'){
$query_string = "create table patient_90(patient_id char(50),patient_name char(50),patient_gender char(1),patient_address char(50))ENGINE=MyISAM DEFAULT CHARSET=utf8";
mysqli_query($link,$query_string);
$query_string = "insert into patient_90 values('123456','王某','1','1')";
mysqli_query($link,$query_string);
}
select_table($link, $table);
}else{
echo "表已存在";
}
}
function select_table($link, $table){
$result = mysqli_query($link,"show tables like '$table'");
var_dump($result);
echo "
";
if ($result && mysqli_num_rows($result) > 0) {
$tableExist = true;
}else{
$tableExist = false;
}
if($tableExist){
if($table == 'user_70'){
$query_string = "select * from user_70";
$result = mysqli_query($link,$query_string);
echo "";
var_dump($result);
echo "
";
while($row = mysqli_fetch_array($result)){
echo $row['name']."
";
echo $row['address']."
";
echo $row['password']."
";
echo "
";
}
}
else if($table == 'nucleic_acid_test_2'){
$query_string = "select * from nucleic_acid_test_2";
$result = mysqli_query($link,$query_string);
echo "";
var_dump($result);
echo "
";
while($row = mysqli_fetch_array($result)){
echo $row['id']."
";
echo $row['name']."
";
echo $row['address']."
";
echo $row['event_time']."
";
echo $row['insert_time']."
";
echo $row['code']."
";
echo "
";
}
}
else if($table == 'patient_90'){
$query_string = "select * from patient_90";
$result = mysqli_query($link,$query_string);
echo "";
var_dump($result);
echo "
";
while($row = mysqli_fetch_array($result)){
echo $row['patient_id']."
";
echo $row['patient_name']."
";
echo $row['patient_gender']."
";
echo $row['patient_address']."
";
echo "
";
}
}
}
}