mysql_connect("localhost","root","");==>参数可选
mysql_select_db("database")==》数据库选择
$sql = "select title,neirong from table where 1<2 order by id";==》表及字段选择
$quy = mysql_query($sql);
$string = '';
while($value = mysql_fetch_array($quy)){
$string. = $value[title].$value[neirong]."\n";
}
$file = fopen('1.txt','w');//打开文件,不存在则自动建立,状态为可写
fwrite($file,$string);//写文件
fclose($file);//关闭文件
mysql_select_db("database")==》数据库选择
$sql = "select title,neirong from table where 1<2 order by id";==》表及字段选择
$quy = mysql_query($sql);
$string = '';
while($value = mysql_fetch_array($quy)){
$string. = $value[title].$value[neirong]."\n";
}
$file = fopen('1.txt','w');//打开文件,不存在则自动建立,状态为可写
fwrite($file,$string);//写文件
fclose($file);//关闭文件
如
id1
id2
id3
.....
//就将heheheihei作为一行写到文本应该是以title neirong的格式写入文本
就是将hehe heihei作为一行写到文本
$select = mysql_select_db('database');
$result = mysql_query("select * from test", $connect);
$rows=mysql_num_rows($result);
for($i=0;$i<$rows;$i++){
$total=mysql_fetch_array($result);
$ttt =test2($total['title'],$total['neirong']);
$file = fopen('1.txt','w');
fwrite($file,$ttt."\n");
}
mysql_close($connect); 以上代码,好像只能记录最后一个记录在文本里,
那里出错了?
$select = mysql_select_db('database');
$result = mysql_query("select * from test", $connect); $file = fopen('1.txt','w'); //要在循环外面打开文件$rows=mysql_num_rows($result);
for($i=0;$i<$rows;$i++){
$total=mysql_fetch_array($result);
$ttt =test2($total['title'],$total['neirong']);
fwrite($file,$ttt."\n");
}
mysql_close($connect);
什么叫太简单了,我那个有条数的限制吗,晕倒。
你看唠叨老大的写法,用FOR,我用WHILE,还不都一样!
他一行一行写,我是全部读取出来再写;也是一样!