PHP Scripting and database functionality (medium) _php tutorial

Previous: PHP script and database function detailed (above)

Using PHP to save files to a database
A database is the center of data organization and storage. It is also possible to process a variety of data, including programs, files, reports, and even audio and video data. As a result of the browser, individual users can only fill in a small portion of their CV. Therefore, here we demonstrate the user's resume upload function. Other types of data can be manipulated by mimicking this example.

The first is the information collection 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= "commit" 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 re-design the code that inserts records into the database:

〈?

Begin of File insert.php

if ($ResuFile! = "None")

Determine if the user has selected a 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 user name password is incorrect! ");

$DBID = @mysql_select_db ("Resumedb", $LinkID) or Die ("error selecting database, possibly the database you specified does not exist!") ");

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

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

if (! $result)

echo "Data insertion failed! ";

Else

echo "File upload succeeded!";

@mysql_close ($LinkID);

End of File insert.php

?〉

With the basics above, it's easy to write a program that reads data from a database. Note that the method that the file sends to the customer. The server must send a header message to the browser stating that the data will be sent as a Word document. If the user's computer is installed with MSWord, the browser will automatically invoke word to display the document.

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 user name password is incorrect! ");

• Total 2 Pages:
• Previous page
• 1
• 2
• Next page

http://www.bkjia.com/PHPjc/364136.html www.bkjia.com true http://www.bkjia.com/PHPjc/364136.html techarticle Previous: PHP script and database functions in detail (above) using PHP to save files to the database database is the center of data organization and storage. It is also possible to deal with a variety of data, including ...

