晕了,你的还不行,呵呵
不会一点结果都没有吧,
for($i=0;$i<$num_records;$i++)
{
$row=@mysql_fetch_array($result);
echo $row[0];
echo"ok";
}
看看输出什么
不会一点结果都没有吧,
for($i=0;$i<$num_records;$i++)
{
$row=@mysql_fetch_array($result);
echo $row[0];
echo"ok";
}
看看输出什么
$query="select * from qm";
$results = mysql_query($query);
while ($row = (string)mysql_fetch_object($results)) {
echo ($row->name);
$handle = fopen("c:\file.txt", 'a');
$string=(string)$row;
fwrite($handle,$string);
fclose($handle);
我在文件c:\file.txt中的不到我检索出是数据而是OBJECT比如我检索的结果应该是QM ,QM0445在文件中也应该是QM ,QM0445才对可是现在在文件中结果是OBJECT,OBJECT为什么,
<?
$host='localhost';
$user='root';
$passwd='';
$link=mysql_connect($host,$user,$passwd);
$db_list=mysql_list_dbs($link);
while ($row=mysql_fetch_object($db_list)){
echo "<B>".strtoupper($row->Database)."</B><br>";
$table_list=mysql_list_tables($row->Database);
while($row2=mysql_fetch_row($table_list)){
echo " ".strtoupper($row2[0]);
$field_list=mysql_list_fields($row->Database,$row2[0],$link);
echo " <table border=1 cellpadding=0 cellspacing=0 bordercolorlight=#000000 bordercolordark=#ffffff>";
echo "<tr>";
$num=mysql_num_fields($field_list);
for($i=0;$i<$num;$i++){
echo "<th>".mysql_field_name($field_list,$i)."</th>";
}
echo "</tr>";
$result=mysql_query("select * from ".$row2[0]);
while($row3=mysql_fetch_array($result)){
echo "<tr>";
for($i=0;$i<$num;$i++){
echo "<td>".$row3[$i]."</td>";
}
echo "</tr>";
}
echo "</table>";
}
echo "<hr width=80% height=1>";
}
?>
读取时用mysql_fetch_array较好
一定要用mysql_fetch_object的话应转换成数组
settype($row,"array");
写入文件时用:
$string=join(",",$row);
fwrite($handle,$string);
settype($row,"array");是不是转化成ARRAY类型?那
$string=join(",",$row);的意思是什么?
join(",",$row);将数组$row连接成字符串,分隔符为","