<h插入操作< h =
""
<?php =
""
if
(!isset(
$_post
[
'submit'
])){ =
""
如果没有表单提交,显示一个表单 =
""
?=
""
>
<form action=
""
method=
"post"
>
国家:<input type=
"text"
name=
"country"
>
动物名称(英文):<input type=
"text"
name=
"animal"
>
动物名称(中文):<input type=
"text"
name=
"cname"
>
<input type=
"submit"
name=
"submit"
value=
"提交表单"
>
<!--?php
}
else
{
$host
=
"localhost"
;
$user
=
"root"
;
$pass
=
"zq"
;
$db
=
"phpdev"
;
$country
=
empty
(
$_POST
[
'country'
])?
die
(
"请输入国家名称"
):
mysql_escape_string(
$_POST
[
'country'
]);
$animal
=
empty
(
$_POST
[
'animal'
])?
die
(
"请输入英文名"
):
mysql_escape_string(
$_POST
[
'animal'
]);
$cname
=
empty
(
$_POST
[
'cname'
])?
die
(
"请输入中文名"
):
mysql_escape_string(
$_POST
[
'cname'
]);
$connection
= mysql_connect(
$host
,
$user
,
$pass
)
or
die
(
"Unable to connect!"
);
mysql_select_db(
$db
)
or
die
(
"Unable to select database!"
);
$query
=
"INSERT INTO symbols(country, animal, cname) VALUE('$country', '$animal', '$cname')"
;
$result
= mysql_query(
$query
)
or
die
(
"Error in query: $query. "
.mysql_error());
echo
"记录已经插入, mysql_insert_id() = "
.mysql_insert_id();
mysql_close(
$connection
);
}
?--></input type=
"submit"
name=
"submit"
value=
"提交表单"
></input type=
"text"
name=
"cname"
></input type=
"text"
name=
"animal"
></input type=
"text"
name=
"country"
></form action=
""
method=
"post"
></h插入操作<>