Web-Sites-Design-and-Programming-10--计算机科学与技术---网站设计与编程--双语教学课件.ppt

Web Sites Design and Programming Lecturer: Lijie Guo Room: XNA508 Phone: Email: guo_lijie163@163.com More PHP and MySQL Overview Other function Form Handling Files Architectures for Database Access Introduction to SQL The MySQL Database System PHP Information The phpinfo() function is used to output PHP information. Form Handling Forms could be handled by the same document that creates the form, but that may be confusing A separate document to handle the form can be specified as the value of the action attribute It does not matter whether GET or POST method is used to transmit the form data PHP builds an array of the form values $_GET for the GET method $_POST for the POST method Files (self-study) PHP is able to create, read and write files on the server system Opening a file Prepares file for use and associates a variable with the file for future reference $fptr = fopen(filename, use_indicator) Every open file has an internal pointer (where the next file operations should take place) Because fopen could fail, use it with die $file_var = fopen (“test.dat”, “r”) or die (“Error – test.dat can’t be opened”); File Use Indicators (self-study) Files (self-study) Use file_exists(filename) to determine whether file exists before trying to open it Use fclose(file_var) to close a file Reading from a file 1. Read all or part of the file into a string variable $str = fread($file_var, #bytes) To read the whole file, use filesize(file_name) as the second parameter $file_string = fread ($file_var, filesize(“test.dat”)); 2. Read the lines of the file into an array $file_lines = file(file_name); Need not open or close the file Files (self-study) Reading from a file (continued) 3. Read one line from the file $line = fgets(file_var, #bytes) Reads characters until eoln, eof, or #bytes characters have been read 4. Read one character at a time $ch = fgetc(file_var) Control reading lines or characters with eof detection