您好,我在让这段代码工作时遇到了一些麻烦。
<?php
$filename = "test.php";
$filehandle = fopen($filename, 'a') or die("can't open file");
$test=
'
$conn = mysql_connect("server", "username", "password" ) or die (mysql_error()) ;
mysql_select_db("db", $conn);
$query = "select * from test";
$result = mysql_query ($query);
$row = mysql_fetch_array( $result );
echo $row[''test''];
';
fwrite($filehandle, $test);
fclose($filehandle);
?>
而不是输出查询的结果,而是输出查询,我想这是因为我将完整的查询存储在变量中,有谁知道我将如何输出查询结果而不是实际查询?谢谢你的帮助。
你应该使用MySQLi或PDO
但是,您的代码应如下所示:
$filename = "test.php";
$filehandle = fopen( $filename ,'a' ) or die( "can't open file" );
$conn = mysql_connect( "server" ,"username" ,"password" ) or die ( mysql_error() ) ;
mysql_select_db( "db" ,$conn );
$query = "select * from test";
$result = mysql_query( $query );
// Iterate through results
while( $row = mysql_fetch_array( $result ) )
{
// var_dump[$row];
// Replace your-column-name below with the actual name :
fwrite( $filehandle ,$row['your-column-name'] );
}
fclose( $filehandle );
从手册页中找到一些例子:mysql_fetch_array、mysql_fetch_assoc、mysql_fetch_array。
你不认为它应该是这样的:
<?php
$conn = mysql_connect("server", "username", "password" ) or die (mysql_error()) ;
mysql_select_db("db", $conn);
$query = "select * from test";
$result = mysql_query ($query);
$row = mysql_fetch_array( $result );
$test = $row['test'];
$filename = "test.php";
$filehandle = fopen($filename, 'a') or die("can't open file");
fwrite($filehandle, $test);
fclose($filehandle);
?>
<?php
$filename = "test.php";
$filehandle = fopen($filename, 'a') or die("can't open file");
// do the query
$conn = mysql_connect("server", "username", "password" ) or die (mysql_error()) ;
mysql_select_db("db", $conn);
$query = "select * from test";
$result = mysql_query ($query);
// get the result row
$row = mysql_fetch_array( $result );
// write a field to file
fwrite($filehandle, $row['test']);
fclose($filehandle);
?>