PHP implementation code for batch generating html and txt files_PHP tutorial

First create a conn.php file to connect to the database

Copy the code The code is as follows:

$link = mysql_connect("mysql_host" , "mysql_user" , "mysql_password" )or die("Could not connect : " . mysql_error());
mysql_query("set names utf8") ;
mysql_select_db("my_database") or die("Could not select database");
?>

php batch generate html

Copy code The code is as follows:

require_once(“conn.php”);
$query = "SELECT id,title,introduce FROM my_table";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
/* Generate HTML results*/
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

$id=$row['id'];
$title=$row['title'];
$introduce= $row['introduce'];
                                                                                                                                                                                                                                                                                         > $ Str = Fread ($ FP, Filesize ("Template.html"); // Read the content in the template
$ Str = Str_replace ("{Title}", $ Title, $ Str);
$str=str_replace("{introduce}",$introduce,$str);//Replacement content
                                                                                           Open the news path
in the import mode ;a href=html/$id.html>Generated successfully"."
";
}
/* Release resources*/
mysql_free_result($result);
mysql_close($link);
?>



template.html file content:

Copy code
The code is as follows:

< meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

{introduce}





php batch generate txt

Copy code
The code is as follows:

require_once(“conn.php”); $query = "SELECT kid,title,introduce FROM pro_courses";

$result = mysql_query($query) or die("Query failed : " . mysql_error());

/* Generate txt result*/
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

$id=$row['id'];
$title=$row['title'];
$introduce =$row['introduce'];
$path="html/$id.txt";
$handle=fopen($path,"w"); //Open the news path in writing mode
           fwrite($handle,strip_tags($introduce)); //Write the content just replaced into the generated txt file
                                                                                                                                              who’ whom’ who who’ who’ who’ who’ who who who’ who who who who who who’s who who’ who who who’s’scoming’s,singling, > mysql_free_result($result);
mysql_close($link);
?>

http://www.bkjia.com/PHPjc/327898.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/327898.htmlTechArticleFirst create a conn.php file to link to the database. Copy the code as follows: ?php $link = mysql_connect( "mysql_host" , "mysql_user" , "mysql_password" )or die("Could not con...