php增删改

最新推荐文章于 2023-06-16 09:36:12 发布

RunAtWorld

最新推荐文章于 2023-06-16 09:36:12 发布

阅读量389

点赞数

分类专栏： PHP

本文链接：https://blog.csdn.net/RunAtWorld/article/details/76795068

版权

PHP 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

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

<?php
mysql_close($conn);
?>

插入demo : insert_demo.php

<?php
//指定网页头编码为utf-8
header ( "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>


<?php
include_once("./connection_destroy.php");
?>