// Start the program
$ Db = mysql_connect ("localhost", "root "); Mysql_select_db ("study", $ db );
// Determine whether the file is modified
If ($ submit ){ $ SQL = "UPDATE wenzhang SET timu = $ timu, zuozhe = $ zuozhe,
Laiyuan = $ laiyuan, textt = $ textt WHERE id = $ id ";
// Issue SQL commands to the database
$ Result = mysql_query ($ SQL );
// Document generation
$ T = date ("Y-m-d h: I: s ");
$ Muoban1 = fopen ("muoban1.txt", "r ");
$ Muoban2 = fopen ("muoban2.txt", "r ");
$ Muoban3 = fopen ("muoban3.txt", "r ");
$ Qita ="
Author: $ zuozhe Source: $ laiyuan
Time: $ t
|
";
$ Muoban4 = fread ($ muoban1, 1000 );
$ Muoban5 = fread ($ muoban2, 1000 );
$ Muoban6 = fread ($ muoban3, 1000 );
Fclose ($ muoban1 );
Fclose ($ muoban2 );
Fclose ($ muoban3 );
$ Main = "$ muoban4 $ timu $ qita $ muoban5 $ textt $ muoban6 ";
// Document generation
$ Ttt = ". html ";
$ N = $ id. $ ttt;
$ F = fopen ($ n, "w ");
Fwrite ($ f, $ main );
Fclose ($ f );
Echo "record modified successfully!";
} // Do we enter the editing and modification status?
If ($ id ){
// We are editing the modification status. for some reasons, select a record.
$ SQL = "SELECT * FROM wenzhang WHERE id = $ id "; $ Result = mysql_query ($ SQL ); $ Myrow = mysql_fetch_array ($ result ); $ Id = $ myrow ["id"]; $ Timu = $ myrow ["timu"]; $ Zuozhe = $ myrow ["zuozhe"]; $ Laiyuan = $ myrow ["laiyuan"]; $ Textt = $ myrow ["textt"];
// Display the id for editing and modification.
$ Fom1 = "";
Echo $ fom1;
}
If (! $ Id ){
// If the status is not modified, the employee list is displayed.
$ Result = mysql_query ("SELECT * FROM wenzhang", $ db );
Printf ("
");
While ($ myrow = mysql_fetch_array ($ result )){
Printf ("
- % S n ",
$ Myrow ["id"], $ myrow ["timu"]);Printf ("(Modify)
", $ PATH_INFO, $ myrow [" id "]);
}
Printf ("
");}
// End the program
?>
|
