my summer holiday English composition for interactive use with PHP4 and MySQL

1. Start by establishing a connection to the MySQL database.
First, we should create an infostar table in a database in MySQL:
Follow the steps for testing MySQL, and after seeing the "mysql>" prompt, manually create the table we need:
mysql>CREATE DATABASE mydb
mysql>USE mydb
mysql>CREATE TABLE infostar(
->name VARCHAR(25),
->email VARCHAR(25),
->choice VARCHAR(10));
Okay, the table is created.Next, create a meeting form with users (pure HTML file)
diaocha.htm

What fruit do you like

Name:	Email:
Apple Orange Pear Coconut Watermelon Banana < /table> The format is as follows: What fruit do you like to eat? Name: Email: Please choose: Apple Orange Pear Coconut Watermelon Banana Next, create a PHP program to receive and process the information from the diaocha.htm form diaocha.php /* Define some related variables for the mysql_connect() function below*/ $hostname="localhost "; $username="root"; $password=""; $dbname="mydb"; /* Used to store the email address of the site administrator*/ $adminaddress="webmaster@youweb.com"; /* This is the table we just created to store user data*/ $userstable="infostar"; /* Create a connection below*/ mysql_connect($hostname,$username,$password) or die (" Unable to connect database"); /* Select the database mydb below. Adding the (@) symbol before the function will suppress the display of error messages.*/ @mysql_select_db("$dbname")or die("Unable ro select database"); print" "; print"Hello:$name."; print" "; print"Your email is:$email "; print"Thank you for your participation "; /* Insert the information into the table infostar*/ /* Because the database table was selected previously using the mysql_select_db function. Therefore, There is no need to enter the table name below*/ $query="INSERT INTO $userstable VALUES('$name','$email','$choice')"; $result=mysql_query($query); print "We have saved your information in the database."; /* Close the database connection*/ mysql_close(); ?> Note: If you are programming like the above: define the string variable at the beginning, modify it We have stored the information in the database, so how can we browse the data? Next, we try to list all the friends who like to eat apples and create the apple.php file apple.php < ?php /* Define some related variables for use by the mysql_connect() function below*/ $hostname="localhost"; $username="root"; $password=""; $dbname="mydb" ; $userstable="infostar" ; /* Establish a connection below and select the database*/ mysql_connect($hostname,$username,$password) or die ("Unable to connect database"); @mysql_select_db("$ dbname")or die("Unable ro select database"); /* Select all users who like Apple*/ $query="SELECT * FROM $userstable WHERE choice='apple'"; $result=mysql_query($ query); /* Calculate how many such users there are*/ $number=mysql_num_rows($result); /* Display the results*/ $i=0; IF ($number==0){ print" No one likes Apple ";} ELSE{ print" Users who like to eat apples are: $number "; WHILE ($i<$number): $name=mysql_result($result,$ i,"name"); $email=mysql_result($result,$i,"email"); print"$name likes to eat apples "; print"Email address: $email < ;br>"; $i++; endwhile; print" "; } ?> Call apple.php in the browser and see what appears. The above introduces the interactive use of PHP4 and MySQL in my summer holiday English composition, including the content of my summer holiday English composition. I hope it will be helpful to friends who are interested in PHP tutorials. Statement of this Website The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn Hot AI Tools Undresser.AI Undress AI-powered app for creating realistic nude photos AI Clothes Remover Online AI tool for removing clothes from photos. Undress AI Tool Undress images for free Clothoff.io AI clothes remover Video Face Swap Swap faces in any video effortlessly with our completely free AI face swap tool! Show More Hot Article How to fix KB5055523 fails to install in Windows 11? 4 weeks ago By DDD How to fix KB5055518 fails to install in Windows 10? 4 weeks ago By DDD Roblox: Grow A Garden - Complete Mutation Guide 2 weeks ago By DDD Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys 3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌 How to fix KB5055612 fails to install in Windows 10? 3 weeks ago By DDD Show More Hot Tools Notepad++7.3.1 Easy-to-use and free code editor SublimeText3 Chinese version Chinese version, very easy to use Zend Studio 13.0.1 Powerful PHP integrated development environment Dreamweaver CS6 Visual web development tools SublimeText3 Mac version God-level code editing software (SublimeText3) Show More Hot Topics Java Tutorial 1664 14 CakePHP Tutorial 1421 52 Laravel Tutorial 1315 25 PHP Tutorial 1266 29 C# Tutorial 1239 24 Show More Related knowledge Explain different error types in PHP (Notice, Warning, Fatal Error, Parse Error). Apr 08, 2025 am 12:03 AM There are four main error types in PHP: 1.Notice: the slightest, will not interrupt the program, such as accessing undefined variables; 2. Warning: serious than Notice, will not terminate the program, such as containing no files; 3. FatalError: the most serious, will terminate the program, such as calling no function; 4. ParseError: syntax error, will prevent the program from being executed, such as forgetting to add the end tag. PHP and Python: Comparing Two Popular Programming Languages Apr 14, 2025 am 12:13 AM PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners. Explain secure password hashing in PHP (e.g., password_hash, password_verify). Why not use MD5 or SHA1? Apr 17, 2025 am 12:06 AM In PHP, password_hash and password_verify functions should be used to implement secure password hashing, and MD5 or SHA1 should not be used. 1) password_hash generates a hash containing salt values ​​to enhance security. 2) Password_verify verify password and ensure security by comparing hash values. 3) MD5 and SHA1 are vulnerable and lack salt values, and are not suitable for modern password security. PHP in Action: Real-World Examples and Applications Apr 14, 2025 am 12:19 AM PHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved. PHP: A Key Language for Web Development Apr 13, 2025 am 12:08 AM PHP is a scripting language widely used on the server side, especially suitable for web development. 1.PHP can embed HTML, process HTTP requests and responses, and supports a variety of databases. 2.PHP is used to generate dynamic web content, process form data, access databases, etc., with strong community support and open source resources. 3. PHP is an interpreted language, and the execution process includes lexical analysis, grammatical analysis, compilation and execution. 4.PHP can be combined with MySQL for advanced applications such as user registration systems. 5. When debugging PHP, you can use functions such as error_reporting() and var_dump(). 6. Optimize PHP code to use caching mechanisms, optimize database queries and use built-in functions. 7 What are HTTP request methods (GET, POST, PUT, DELETE, etc.) and when should each be used? Apr 09, 2025 am 12:09 AM HTTP request methods include GET, POST, PUT and DELETE, which are used to obtain, submit, update and delete resources respectively. 1. The GET method is used to obtain resources and is suitable for read operations. 2. The POST method is used to submit data and is often used to create new resources. 3. The PUT method is used to update resources and is suitable for complete updates. 4. The DELETE method is used to delete resources and is suitable for deletion operations. Explain the difference between self::, parent::, and static:: in PHP OOP. Apr 09, 2025 am 12:04 AM In PHPOOP, self:: refers to the current class, parent:: refers to the parent class, static:: is used for late static binding. 1.self:: is used for static method and constant calls, but does not support late static binding. 2.parent:: is used for subclasses to call parent class methods, and private methods cannot be accessed. 3.static:: supports late static binding, suitable for inheritance and polymorphism, but may affect the readability of the code. How does PHP handle file uploads securely? Apr 10, 2025 am 09:37 AM PHP handles file uploads through the $\_FILES variable. The methods to ensure security include: 1. Check upload errors, 2. Verify file type and size, 3. Prevent file overwriting, 4. Move files to a permanent storage location. See all articles Public welfare online PHP training，Help PHP learners grow quickly！ About us Disclaimer Sitemap © php.cn All rights reserved