php增删改

来源：互联网发布：sql分页查询语句join 编辑：程序博客网时间：2024/05/18 23:25

connection.php

<?php$servername = "localhost";$username = "root";$password = "lipengfei2015";$dbname = "classplatform";// 创建连接$conn=mysql_connect($servername,$username,$password) or die('Connecting failed!');mysql_select_db($dbname) or die('Unable to select database!');mysql_query('set names utf8');?>

connection_destroy.php

<?phpmysql_close($conn);?>

插入demo : insert_demo.php

<?php//指定网页头编码为utf-8header ( "Content-type:text/html;charset=utf-8" );  //网页统一输出编码为utf-8  echo "<title>mysql 插入demo</title>";  //指定网页标题//导入数据库连接文件include_once("./connection.php");//获取表单中的值$_POST['swname'] = "ss";$_POST['description'] ="1"; $_POST['category'] = "1";$_POST['secretkey'] = "121";$_POST['baidusecretlink'] = "8823";$swname = $_POST['swname'];$description = $_POST['description'];$category = $_POST['category'];$secretkey = $_POST['secretkey'];$baidusecretlink = $_POST['baidusecretlink'];?><body> <?php//去除空格$swname=trim($swname);$description=trim($description);$category=trim($category);$secretkey=trim($secretkey);$baidusecretlink=trim($baidusecretlink);//检查表单中的值是否符合标准，并做适当转义，防止SQL注入 $swname=empty($swname) ? die("swname字段为空") : mysql_escape_string($swname);$description=empty($description) ? die("description字段为空") : mysql_escape_string($description);$category=empty($category) ? die("category字段为空") : mysql_escape_string($category);$secretkey=empty($secretkey) ? die("secretkey字段为空") : mysql_escape_string($secretkey);$baidusecretlink=empty($baidusecretlink) ? die("baidusecretlink字段为空") : mysql_escape_string($baidusecretlink);$sql="INSERT INTO t_software(swname,description,category,secretkey,baidusecretlink,created,lastmodified) VALUES ('$swname','$description','$category','$secretkey','$baidusecretlink',NOW(),NOW())";//执行插入  if($result = mysql_query($sql) or die("Error: $sql. ".mysql_error()))echo "added new record , mysql_insert_id() = ".mysql_insert_id();//插入操作成功后，显示插入记录的记录号?></body><?phpinclude_once("./connection_destroy.php");?>

阅读全文

0 0