php多次查询,php – 使用不同的SQL查询多次将此MySQL重复为CSV

我有以下PHP,它会以CSV格式将结果返回给我查询,但顶部显示的LIKE语句中的代码(两个字母)需要在多个不同的代码之间进行更改.

我有大约30种不同的代码.我需要定义所有代码,例如：

CV,LC,RCA,JOR等……

并让脚本为每个不同的代码创建一个新的CSV,然后快速地逐个处理每个代码.所以我最终得到了30个文件.我可能需要这样做几次,所以手动更改它30次不是我的首选.

PHP

// database variables

$hostname = "localhost";

$user = "###";

$password = "###";

$database = "###";

$select = "select * from subscribers where list=27 and custom_fields LIKE '%\%CV\%%'";

$con = MysqL_connect($hostname,$user,$password);

$db_selected = MysqL_select_db($database,$con);

// Check connection

if (!$con)

{

die('Could not connect: ' . MysqL_error());

}

$export = MysqL_query ( $select ) or die ( "sql error : " . MysqL_error( ) );

$fields = MysqL_num_fields ( $export );

for ( $i = 0; $i < $fields; $i++ )

{

$header .= MysqL_field_name( $export,$i ) . "\t";

}

while( $row = MysqL_fetch_row( $export ) )

{

$line = '';

foreach( $row as $value )

{

if ( ( !isset( $value ) ) || ( $value == "" ) )

{

$value = "\t";

}

else

{

$value = str_replace( '"','""',$value );

$value = '"' . $value . '"' . "\t";

}

$line .= $value;

}

$data .= trim( $line ) . "\n";

}

$data = str_replace( "\r","",$data );

if ( $data == "" )

{

$data = "\n(0) Records Found!\n";

}

header("Content-type: application/octet-stream");

header("Content-Disposition: attachment; filename=list-export.xls");

header("Pragma: no-cache");

header("Expires: 0");

print "$header\n$data";

?>