Detailed explanation of PHP script and database functions (Part 2)_PHP tutorial

Previous article: Detailed explanation of PHP script and database functions (Part 1)

Use PHP to save files to the database
The database is the center of data organization and storage. What will be processed may also be various data, including programs, files, reports, and even audio and video data. Because through the browser, individual users can only fill in a small part of their resume. Therefore, here we demonstrate the function of uploading a user's resume. Other types of data can follow this example.

The first is the information collection page. Let the user select files to upload. The html code of this page is as follows:

　〈!-- begin of post.htm--〉

　〈p〉　〈/p〉

　

　〈p〉〈b〉Resume submission〈/b〉〈/p〉

　〈p〉 Name: 〈br〉

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

　

Personal profile: 〈br〉

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

　

Resume file: 〈br〉

　〈input type="file" name="ResuFile"〉〈/p〉

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

〈/form〉

〈!-End of post.htm--〉

Note that the ENCTYPE keyword must not be omitted, otherwise the file will not be uploaded correctly.

Here, we redesign the code for inserting records into the database:

　〈?

　//begin of file insert.php

if( $ResuFile != "none")

// Make sure the user selects the file

　{

$Size = filesize($ResuFile);

　/Determine the file size

　$mFileData = addslashes(fread(fopen($ResuFile, "r"), $Size));

　//Read the file and process the content

unlink($ResuFile);

//Delete upload temporary files

}

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

　$DBID = @mysql_select_db("ResumeDB",$LinkID) or die ("Error selecting database, the database you specified may not exist!");

　$query = "insert into Resume(Name,Intro,ResuFile) values('$Name', '$Intro', '$mFileData')";

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

　if(! $result)

echo "Data insertion failed!";

else

echo "File uploaded successfully!";

@mysql_close($LinkID);

　 //end of file insert.php

　?〉

With the above foundation, it should be very simple to write a program to read data from the database. What needs to be noted is the method in which the files are sent to the client. The server must send header information to the browser indicating that the data to be sent is a word document. If MSWord is installed on the user's computer, the browser will automatically call word to display the document.

We can set 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 and password are wrong!");

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

http://www.bkjia.com/PHPjc/364136.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/364136.htmlTechArticlePrevious article: Detailed explanation of PHP script and database functions (Part 1) Use PHP to save files to the database. The database is a data organization , storage center. What will be processed may also be various data, including...