Php batch generate html and txt file implementation code

This article provides a detailed analysis of the implementation code of html and txt files generated in batches using php. For more information, see

This article provides a detailed analysis of the implementation code of html and txt files generated in batches using php. For more information, see

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

The Code is as follows:

$ Link = mysql_connect ("mysql_host", "mysql_user", "mysql_password") or die ("cocould not connect:". mysql_error ());
Mysql_query ("set names utf8 ");
Mysql_select_db ("my_database") or die ("cocould not select database ");
?>

Php batch generate html

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 ['inserted'];
$ Path = "html/$id.html ";
$ Fp = fopen ("template.html", "r"); // read-only open Template
$ Str = fread ($ fp, filesize ("template.html"); // read the template content
$ Str = str_replace ("{title}", $ title, $ str );
$ Str = str_replace ("{introduce}", $ introduce, $ str); // replace content
Fclose ($ fp );
$ Handle = fopen ($ path, "w"); // The path to open the news in writing mode.
Fwrite ($ handle, strip_tags ($ introduce); // write the replaced content into the generated HTML file.
Fclose ($ handle );
// Echo "generated successfully "."
";
}
/* Release resources */
Mysql_free_result ($ result );
Mysql_close ($ link );
?>

Template.html file content:

The Code is as follows:

{Title}


{Introduce}

Php batch generate txt

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 results */
While ($ row = mysql_fetch_array ($ result, MYSQL_ASSOC )){

$ Id = $ row ['id'];
$ Title = $ row ['title'];
$ Introduce = $ row ['inserted'];
$ Path = "html/$id.txt ";
$ Handle = fopen ($ path, "w"); // The path to open the news in writing mode.
Fwrite ($ handle, strip_tags ($ introduce); // write the replaced content into the generated txt file.
Fclose ($ handle );
}
/* Release resources */
Mysql_free_result ($ result );
Mysql_close ($ link );
?>

, Website space, Hong Kong server, and Hong Kong Virtual Host