$quety="insert into library (name,author,id,classname,editdate) values('$name','$author','$id','$classname','$editdate')";$quety ? 呵呵,笔误~
解决方案 »
- 求熟悉正则的给个判断方法
- ________怎样下载php文件_______我用迅雷下载只有1kb_______只写着Access Denied_________怎办___________
- php 报这个错误 大侠们进来看看
- 急。。在线等。。mysql索引设置问题
- 这个函数你能看懂不?
- 我的主页是index.php如何才能用程序将它转化为index.html页面
- PHP如何防止远程提交?
- 我想学习php,有几个简单问题请教,谢谢
- 请会编程的帮忙修改下实现PHP代码读取http://www.testgod8.com/1.xml内容并显示
- 为什么PHP文件输出后面会带有分号和结束符,如图所示。
- 3 Question about sql.
- 从数据库掉不出数据..
2、 sql语句有错误,你试一试如下:
$quety="insert into library set name='$name',author='$author',id='$id',classname='$classname',editdate='$editdate'";
$con=mysql_connect("localhost","root","1234");
mysql_select_db("tushu");
$query="select name,author,id,classname,editdate from library";
$result=mysql_query("$query",$con);
$rownumber=mysql_num_rows($result);
echo"<cneter>";
这是从数据库调出数据,可是掉不出来?
是不是应该改成$query="select *from library"; ???
$con=mysql_connect("localhost","root","1234");
mysql_select_db("tushu",$con);
$query="select *from library";
$result=mysql_query($query,$con);
$rownumber=mysql_num_rows($result);
现在改成这了,还不行.
create database tushu;
use tushu;CREATE TABLE library (
name varchar(50) DEFAULT '' NOT NULL,
author varchar(50) DEFAULT '' NOT NULL,
id int(10) DEFAULT '0' NOT NULL,
classname varchar(50),
editdate varchar(15),
KEY names (name));grant all on tushu.* to tushu@localhost identified by "tushu";写个脚本
<?php
$con=mysql_connect("localhost","tushu","tushu");
mysql_select_db("tushu",$con);
$query="insert into library values(\" abc \",\" ustcfrank \",\"001 \" ,NULL,NULL)";
$result=mysql_query("$query",$con);echo "insert success!";
?>这个在我机器上可以用
$con=mysql_connect("localhost","tushu","tushu");
mysql_select_db("tushu",$con);
$query="select * from library";
$result=mysql_query("$query",$con);$r=mysql_fetch_array($result);
echo $r[0];echo "<br>";echo $r[1];?>
Fatal error: Call to undefined function: mysql_connect() in C:\www\test1.php on line 2
什么意思?
怎么办?
<?php
$con=mysql_connect("localhost","root","1234");
mysql_select_db("tushu");
$quety="insert into library (name,author,id,classname,editdate) values('$name','$author','$id','$classname','$editdate')";
$result=mysql_query("$query",$con);
require("tushudis.php");
?>
我改为以下
<?php
$con=mysql_connect("localhost","root","1234");
mysql_select_db("tushu");
$query="insert into library (name,author,id,classname,editdate) values('$name','$author','$id','$classname','$editdate')";
$result=mysql_query("$query");
require("tushudis.php");
?>
在我的机上通过!