php怎么样连接sql数据库? $quety="insert into library (name,author,id,classname,editdate) values('$name','$author','$id','$classname','$editdate')";$quety ? 呵呵,笔误~ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1、 $quety????2、 sql语句有错误,你试一试如下:$quety="insert into library set name='$name',author='$author',id='$id',classname='$classname',editdate='$editdate'"; <?php$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"; ??? mysam,试了你的语句,也加不上, mysql_select_db("tushu");改为mysql_select_db("tushu",$con);试试 $result=mysql_query("$query",$con);改为$result=mysql_query($query,$con);试试 <?php$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);现在改成这了,还不行. 建立数据库drop database if exists tushu;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!";?>这个在我机器上可以用 这个也可以用<?php$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什么意思? 不是吧,mysql_connect() 这个也没有定义,不可能啊,你的php版本? PHP V5.0.0 Beta 1 For Windows怎么办? 等我一下,我要重新安装Apache2和PHP 我用的是4.2.6的<?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");?>在我的机上通过! php 刚开始自学 请前辈一定帮忙。 (高难度)PHP实现不同数据库之间的互拷,与远程FTP的数据互换 求助:出错了,好像跟php版本有关 ======= PHP UpDate MySQL 问题 ================= 为何method=post时无法读取变量和数组的值? (菜鸟问得瓜)关于apache的事,apache社区那里没啥人气,只好跑到这里来了 限制表格的宽度 高手帮忙 SQL问题 各位大哥,给我看一下代码哪里有错!! laravel 怎么配置一个像session一样的全局变量呢? 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");
?>
在我的机上通过!