4、服务器端包含 |
<!--?php require_once ( 'conn.php' ); ?--> |
5、如何将一条记录写入数据库,然后提示并跳转页面 |
<!--?php |
$ly_title = $_POST [ "ly_title" ]; |
$ly_content = $_POST [ "ly_content" ]; |
$ly_time = $_POST [ "ly_time" ]; |
$ly_author = $_POST [ "ly_author" ]; |
$ly_email = $_POST [ "ly_email" ]; |
$sql = "insert into liuyan(ly_title,ly_content,ly_time,ly_author,ly_email) values('" . $ly_title . "','" . $ly_content . "','" . $ly_time . "','" . $ly_author . "','" . $ly_email . "')" ; |
mysql_query( $sql , $connec ); |
echo ( "<script type='text/javascript'--> alert('添加成功!');location.href='index.php';" ); |
?> |
6、弹出对话框,并发生页面跳转 |
<!--?php |
echo ( "<script type='text/javascript'--> alert('添加成功!');location.href='index.php';" ); |
?> |
7、信息查看页面(有条件读取数据库) |
1)有条件读取数据库 |
<!--?php $sql = "select * from liuyan where ly_id=$_GET[id]" ; $conn =mysql_query( $sql , $connec ); $rs =mysql_fetch_array( $conn ); ?--> |
2)将某个字段输出 |
<!--?= $rs [ly_title]? --> |
3)关闭数据库 |
<!--?php mysql_close(); ?--> |
8、对数据库中某一条记录进行更新操作,并作提示跳转 |
<!--?php |
$ly_title = $_POST [ "ly_title" ]; |
$ly_content = $_POST [ "ly_content" ]; |
$ly_time = $_POST [ "ly_time" ]; |
$ly_author = $_POST [ "ly_author" ]; |
$ly_email = $_POST [ "ly_email" ]; |
$sql = "update liuyan set ly_title='$ly_title',ly_content='$ly_content',ly_time='$ly_time',ly_author='$ly_author',ly_email='$ly_email' where ly_id=$_GET[id]" ; |
mysql_query( $sql , $connec ); |
echo ( "<script type='text/javascript'--> alert('更新成功!');location.href='../index.php';" ); |
?>; |