Home
Backend Development
PHP Tutorial
National People's Congress copy data processing program_Query_PHP tutorial
Backend Development
PHP Tutorial
National People's Congress copy data processing program_Query_PHP tutorial
National People's Congress copy data processing program_Query_PHP tutorial
。
for
deal with
copy
Library
search
article
date
Inquire
at present
program
design
material
//This program is a search, currently designed to serve the article library.
//Editor: Kong Xiuxiang. Date: 2001/4/10
if(!$UploadAction):
require "config.php3";
if(!isset($table)){
//$table="artical ";
}
/*
$link_id=@MYSQL_CONNECT($hostname,$dbusername,$dbpassword) OR DIE("Cannot connect to database!");
@mysql_select_db("$dbname" ) or die("Cannot select database!");
$q="select count(id) from $table where 1 ";
$result = @mysql_query($q);
$row = @mysql_fetch_array($result);
$r_count=$row["count(artical_id)"];
*/
?>
| This program takes time to run, so you need to wait patiently. |
|---|
else:
require "config.php3";
$UploadAction=0;
$added=0;
$die=0;
$single_chinese=0;
$TimeLimit=0; /*Set the timeout limit, the default time is 30 seconds and set to 0, it is unlimited*/
set_time_limit($TimeLimit );
if($data_search==""){
// Index the entire database
header("location:progsdata_index.php3");
//$msg= "The search content cannot be empty. ";
//xueroom_error_exit($msg,$PHP_SELF);
}
$link_id=@MYSQL_CONNECT($hostname,$dbusername,$dbpassword) OR DIE("Cannot connect Database! ");
@mysql_select_db("$dbname") or die("Cannot select database!");
//SELECT id,file_name,artical_author from textfile where 1 LIMIT 0, 30
if ($table=="artical")
{
$sid="artical_id";
$stitle="artical_title";
$sauthor="artical_author";
$sdata=" artical_data";
$prog="readfile.php3";
if($a_data=="month" )
$key_where="where origin_periodical rlike '^.*$data_search.*'";
}
if($a_data=="data" )
$key_where="where $sdata rlike '^.*$data_search.*'";
if($a_data=="title" )
$key_where="where $stitle rlike '^.*$data_search.*'";
if($a_data=="author" )
$key_where="where $sauthor rlike '^. *$data_search.*'";
//$q="select $sid,$stitle,$sauthor from $table where $sdata rlike '^.*$data_search.*'order by $stitle" ;
if(($a_data=="data")&&(strlen($data_search)==2)){
$q="select $sid,$stitle,$sauthor,$sdata from $table $key_where order by $stitle";
$single_chinese=1;
}
else{
$q="select $sid,$stitle,$sauthor from $table $key_where order by $stitle ";
}
$index_data="";
$count=0;
$result =@ mysql_query($q);
if(!$result){
$msg="There are no records that meet the requirements. ";
xueroom_error_exit($msg,$PHP_SELF);
}
while($row = @mysql_fetch_array($result)) {
if(($single_chinese)&&(!myStrPos($row [$sdata],$data_search)))
continue;
else
{
$id=$row[$sid];
$title=$row[$stitle];
$author=$row[$sauthor];
if($table=="textfile")
$title=preg_replace("/.txt/","",$title);
// $data=$row["artical_data"];
//if(myStrPos($data,$data_search)) //Can be used to find a single Chinese character.
// if(strpos($data, $data_search)){ //This judgment formula is used when it is larger than one Chinese character, which is faster.
$index_data.="
$count++;
//fputs($fp, "
// }
}
}
@mysql_free_result($result);
mysql_close($link_id);
set_time_limit(30);
if($index_title==""){
$index_title="学而斋资料";
}
$index_title=$index_title."_".$data_search;
$html_header="
$html_header.="
$index_title
rn";$dte_created=date('Y-m-d H:i:s');
$html_header.="$index_describe 发现了 $count 条/查询日期：$dte_created
rn";
$html_header.="