PHP Script Database features (middle) _php Foundation

Using PHP to save files to a database
A database is the center of data organization and storage. It can also be a variety of data, including programs, files, reports, and even audio and video data. Because through the browser, individual users can only fill in a small number of personal resumes. Therefore, we demonstrate the user's personal resume upload function. Other types of data can be manipulated by imitating this example.

The first is the information gathering page. Let the user select the file to upload. The HTML code for this page is as follows:

!--begin of Post.htm--〉

〈p〉〈/p〉

〈form method= "POST" action= "insert.php" enctype= "Multipart/form-data"

〈p〉〈b〉 Personal Resume Submission 〈/b〉〈/p〉

〈p〉 Name: 〈br〉

〈input type= "text" name= "name" size= "20" 〉〈/p〉

〈p〉 Profile: 〈br〉

〈textarea rows= "2" name= "Intro" cols= "20" 〉〈/textarea〉〈/p〉

〈p〉 Resume File: 〈br〉

〈input type= "File" Name= "Resufile" 〉〈/p〉

〈p〉〈input type= "Submit" value= "submitted" name= "B1" 〉〈/p〉

〈/form〉

〈!-end of post.htm--〉

Note that the Enctype keyword must not be saved, otherwise the file cannot be uploaded correctly.

Here, we redesign the code that inserts records into the database:

〈?

Begin of File insert.php

if ($ResuFile!= "None")

Make sure the user selects the file

{

$Size = FileSize ($ResuFile);

Determine file size

$mFileData = Addslashes (Fread (fopen ($ResuFile, "R"), $Size));

Read the file and process the content

Unlink ($ResuFile);

Delete Upload temp file

}

$LinkID = @mysql_connect ("localhost", "root", "") or Die ("Cannot connect to the database server!") The database server may not be started, or the username password is incorrect! ");

$DBID = @mysql_select_db ("Resumedb", $LinkID) or Die ("Select Database error, you may have specified a database that does not exist!") ");

$query = "INSERT into Resume (name,intro,resufile) VALUES (' $Name ', ' $Intro ', ' $mFileData ')";

$result = @mysql_query ("$query", $LinkID); Execute the query, insert the file into the database

if (! $result)

echo "Data insertion failed!" ";

Else

echo "File upload succeeded!";

@mysql_close ($LinkID);

End of File insert.php

?〉

With the above foundation, it should be easy to write a program that reads data from a database. What you need to be aware of is how the file is sent to the customer. The server must send a header message to the browser stating that the data that will be sent is a Word document. If the user's computer is equipped with MSWord, the browser automatically calls word for the document display.

We can set up a hyperlink to download this Word file:

〈?

Begin of File show.php

$LinkID = @mysql_connect ("localhost", "root", "") or Die ("Cannot connect to the database server!") The database server may not be started, or the username password is incorrect! ");

$DBID = @mysql_select_db ("Resumedb", $LinkID) or Die ("Select Database error, you may have specified a database that does not exist!") ");

$query = "INSERT into Resume (name,intro,resufile) VALUES (' $Name ', ' $Intro ', ' $mFileData ')";

$result = @mysql_query ("$query", $LinkID);

Execute the query, insert the file into the database

$query = "Select Id,name,intro from Resume";

Generate SQL statements

$result = mysql_query ($query, $LinkID); execution, the result set is saved to the variable $result

$num = mysql_num_rows ($result); Get the number of rows returned by a query

if ($num = = 0)

{

echo "did not find any records";

Exit ();

}

while ($row =mysql_fetch_array ($result))//Take the next line of data from the result set into the array $row

{

echo $row ["ID"]. " ". $row [" Name]. " ". $row [" Intro "]." ";

echo "〈a href=" download.php?id= ". $row [" ID "]." " View Word document 〈/a〉〈br〉 ";

}

End of File show.php

?〉

Accessing file show.php, the user sees a list of personal brief information. Click "View Word document" To see the detailed resume of the corresponding member.

The Word document is displayed with the following file:

〈?

Begin of File download.php

$LinkID = @mysql_connect ("localhost", "root", "") or Die ("Cannot connect to the database server!") The database server may not be started, or the username password is incorrect! ");

$DBID = @mysql_select_db ("Resumedb", $LinkID) or Die ("Select Database error, you may have specified a database that does not exist!") ");

$query = "Select Resufile from Resume where id= $ID";

$ID the variable passed for the call

$result = @mysql_query ("$query", $LinkID);

Execute query to read file contents from database

if (mysql_num_rows ($result) 〈1)

{

echo "did not find the appropriate file!" ";

Exit ();

}

$row = Mysql_fetch_array ($result);

$mFileData = $row ["Resufile"];

Read the contents of a resume (Word file format data)

Header ("Content-type:application/msword");

Send header information stating that the data that will be sent is a Word document

Echo $mFileData;

Send document data

End of File download.php

?〉

At this point, we have achieved the personal resume submission, database storage, information browsing and other functions, basically completed the "Talent Information exchange" framework function.

It should be explained that file upload and database storage through PHP is a more prominent technical problem. Many of the sites on PHP continue to have such problems. These operations are more dependent on the platform and environment settings. Different platform configurations can cause the operation to fail. This article is attached with the operating platform of the above program, compiling parameters for reference.