PHP文件代码
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>标题名称</title>
</head>
<body>
<form action="">
<div class="form-group" >
</div>
<input type="text" name="keywords" class="form-control" value="" placeholder="请输入关键字" style="width:300px;position:relative;top:0px;left:430px;"/>
<input type="submit" value="Submit" class="btn btn-primary" style="position:relative;top:-45px;left:735px;"/>
</form>
<div style="top:-100px; align:center;" >
<?php
header('conten-type:text/html;charset=utf-8');
$PHP_SELF = &$_SERVER['PHP_SELF'];
$EXCEL_OUT = &$_SERVER['EXCEL_OUT'];
//测试关键字获取功能
$keywords=isset($_GET['keywords'])?trim($_GET['keywords']):'无法显示keywords';
//测试获取的关键字
//echo '查询关键词:'.$keywords;
//echo'</br>';
//连接数据库
include_once('connect.php');
mysqli_select_db($link,$db_name);
mysqli_query($link,"set names ’utf8’ ");
mysqli_query($link,"set character_set_client=utf8");
mysqli_query($link,"set character_set_connection=utf8");
mysqli_query($link,"set character_set_results=utf8");
//测试数据库连接是否成功:echo '连接成功'
//把数据检索的结果保存到临时表中
$tmp_sql='create temporary table temps(
tmp_fang_name varchar(255) character set utf8 collate utf8_general_ci not null,
tmp_part_medicine varchar(1000) character set utf8 collate utf8_general_ci not null)';
//数据检索
$tmp_query=mysqli_query($link,$tmp_sql);
$sql= "INSERT INTO temps(tmp_fang_name,tmp_part_medicine) SELECT fang_name,part_medicine FROM prescription WHERE symptom LIKE '%".$keywords."%'";
//$sql="SELECT * FROM temps";
//查询
mysqli_query($link, $sql);
$sql="select * from temps";
$query1=mysqli_query($link, $sql);
//echo mysqli_num_rows($query1);
//$res = mysqli_query($link, $sql);
/* //测试临时表数据是否获取成功
if(!mysqli_query($link,$sql)){
echo "添加数据失败!".mysql_error();
} else {
echo "添加数据成功!";
}
*/
$array = array();
$query = "select tmp_fang_name,tmp_part_medicine from temps";
$res = mysqli_query($link, $query);
//遍历数据表
while ($row = mysqli_fetch_assoc($res)) {
$array[] = $row;
//var_dump($array);
};
//print_r($array);
$fn ='要写入的csv文件路径/'.$keywords.'.csv';
$fn = iconv('UTF-8', 'GB2312//IGNORE', $fn);
$fh = fopen($fn,'w') or die("Can't open csv file");
fwrite($fh,chr(0xEF).chr(0xBB).chr(0xBF));
foreach ($array as $array_line) {
$array=iconv('UTF-8', 'GB2312//IGNORE', var_dump($array_line));
if (fputcsv($fh, $array_line) === false) {
die("Can't write CSV line");
}
}
fclose($fh) or die("Can't close file.csv");
?>
</div>
</body>
</html>
数据库连接文件connect.php
<?php
$host="localhost";
$db_user="root";
$db_pass="你设置的密码";
$db_name="数据库名称";
$timezone="Asia/Beijing";
$link=mysqli_connect($host,$db_user,$db_pass);
if(! $link )
{
die('Could not connect: ' . mysql_error());
}
// echo 'Connected successfully';
//mysqli_select_db($link,$db_name);
//mysqli_query( $link, $db_name );
?>