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"); ?>
