php mysql增修删_php mysql增、删、改、查

require_once "connect.php";

echo <<<_end>

ADD DEMO

Name:

Age:

Sex:

_END;

if (isset($_POST["name"]) && isset($_POST["age"]) && isset($_POST["sex"]) && isset($_POST["add_submit"])) {

$name=$_POST["name"];

$age=$_POST["age"];

$sex=$_POST["sex"];

}

if(isset($_POST["add_submit"])){

mysql_query("set names utf8");

$add_query="insert into users(name,age,sex) values('$name','$age','$sex')";

mysql_query($add_query);

}

mysql_query("set names utf8");

$select_query="select * from users";

$results=mysql_query($select_query);

while ($rows=mysql_fetch_row($results)) {

echo "Id:".$rows[0]."
";

echo "Name:".$rows[1]."
";

echo "Age:".$rows[2]."
";

echo "Sex:".$rows[3]."
"."
"."
";

}

echo <<<_end>

DELETE DEMO

ID:

_END;

if(isset($_POST["id"]) && isset($_POST["del_submit"])){

$id=$_POST["id"];

}

if(isset($_POST["del_submit"])){

$del_query="delete from users where id='$id'";

mysql_query($del_query);

}

mysql_query("set names utf8");

$select_query="select * from users";

$results=mysql_query($select_query);

while ($rows=mysql_fetch_row($results)) {

echo "Id:".$rows[0]."Edit"."
";

echo "Name:".$rows[1]."
";

echo "Age:".$rows[2]."
";

echo "Sex:".$rows[3]."
"."
"."
";

}

echo <<<_end>

UPDATE DEMO

ID:

Name:

Age:

Sex:

_END;

if(isset($_POST["name"]) && isset($_POST["age"]) && isset($_POST["sex"]) && isset($_POST["update_submit"])){

$name=$_POST["name"];

$age=$_POST["age"];

$sex=$_POST["sex"];

$id=$_POST["id"];

}

if(isset($_POST["update_submit"])){

$up_query="update users set name='$name',age='$age',sex='$sex' where id='$id'";

mysql_query($up_query);

}

mysql_query("set names utf8");

$select_query="select * from users";

$results=mysql_query($select_query);

while ($rows=mysql_fetch_row($results)) {

echo "Id:".$rows[0]."Edit"."
";

echo "Name:".$rows[1]."
";

echo "Age:".$rows[2]."
";

echo "Sex:".$rows[3]."
"."
"."
";

}

echo <<<_end>

SELECT DEMO

ID:

Name:

Age:

Sex:

_END;

if (isset($_POST["select_submit"])) {

if(isset($_POST["name"])){

$name=$_POST["name"];

$sel_results=mysql_query("select * from users where name='$name'");

while ($rows=mysql_fetch_row($sel_results)) {

echo "id: ".$rows[0]."
";

echo "name: ".$rows[1]."
";

echo "age: ".$rows[2]."
";

echo "sex: ".$rows[3]."
"."
";

}

}

if (isset($_POST["age"])) {

$age=$_POST["age"];

$sel_results=mysql_query("select * from users where age='$age'");

while ($rows=mysql_fetch_row($sel_results)) {

echo "id: ".$rows[0]."
";

echo "name: ".$rows[1]."
";

echo "age: ".$rows[2]."
";

echo "sex: ".$rows[3]."
"."
";

}

}

if (isset($_POST["sex"])) {

$sex=$_POST["sex"];

$sel_results=mysql_query("select * from users where sex='$sex'");

while ($rows=mysql_fetch_row($sel_results)) {

echo "id: ".$rows[0]."
";

echo "name: ".$rows[1]."
";

echo "age: ".$rows[2]."
";

echo "sex: ".$rows[3]."
"."
";

}

}

if (isset($_POST["id"])) {

$id=$_POST["id"];

$sel_results=mysql_query("select * from users where id='$id'");

while ($rows=mysql_fetch_row($sel_results)) {

echo "id: ".$rows[0]."
";

echo "name: ".$rows[1]."
";

echo "age: ".$rows[2]."
";

echo "sex: ".$rows[3]."
"."
";

}

# code...

}

}

?>