Question

php $result问题

<?php
if($_SERVER['REQUEST_METHOD']=='GET'){
$cname=$_GET['ChineseName'];
$ename=$_GET['EnglishName'];
$score=$_GET['Testscore'];}
echo $cname.$ename.$score;
$sql="insert into testing values ('$cname','$ename','$score')";
$conn=mysql_connect("localhost","root","123") or die ("Unable to connect!");
mysql_select_db("my") or die ("Unable to select database!");
//$query="select * from testing";
$result=mysql_query($sql) or die ("Error in query:".mysql_errno());
echo $result;
为什么$RESULT输出的是1呢，怎么才能输出资源呢？

Answer 1

mysql_query($sql);
如果$sql是查询语句返回的是资源，
如果是插入，修改或者删除则返回的是操作影响的记录条数
如插入1条记录这返回1

Answer 2

<?php
if($_SERVER['REQUEST_METHOD']=='GET'){
$cname=$_GET['ChineseName'];
$ename=$_GET['EnglishName'];
$score=$_GET['Testscore'];}
echo $cname.$ename.$score;
$sql="insert into testing values ('$cname','$ename','$score')";
$conn=mysql_connect("localhost","root","123") or die ("Unable to connect!");
mysql_select_db("my") or die ("Unable to select database!");
//$query="select * from testing";
$result=mysql_query($query) or die ("Error in query:".mysql_errno());
while($v=mysql_fetch_array($result)){
echo $v['cname'];
//获知var_dump($v);看看里面的值
}

Answer 3

$row=mysql_fetch_array($result);
print_r($row);

Answer 4

$result=mysql_query($sql)

$sql是啥？

Answer 5

$rows = array();
while($trow = @mysql_fetch_array($result)){//取所有结果.
$rows[] = $trow;
}
print_r($rows)//输出取到的内容.