Home > Backend Development > PHP Tutorial > php无法向mysql中插入值解决方案

php无法向mysql中插入值解决方案

WBOY
Release: 2016-06-13 13:32:36
Original
909 people have browsed it

php无法向mysql中插入值

PHP code
<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->
conn.php
<?php /*
 * Created on 2012-5-7
 *
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */
 $conn=@ mysql_connect("localhost","root","admin") or die("数据库连接失败");
 mysql_select_db("bbs",$conn);
 mysql_query("set names 'GBK'"); //使用GBK中文编码;
?>

add.php
<?php /*
 * Created on 2012-5-7
 *
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 *
 */
 include("conn.php");

 if($_POST['submit']){
  $sql="insert into message (id,user,title,content,lastdate)" .
             "values ('','$_POST[user]','$_POST[title]','$_POST[content]',now())";
  mysql_query($sql);
  echo "发表成功";
 }
?>

  
Copy after login
用户:
标题:
内容:


------解决方案--------------------
mysql_query($sql) or die(mysql_error()); //这样提示什么错误
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template