Transcript Select Data from MySQL Database

Lesson 6


Retrieve input from form and do
processing
There are two ways the browser client can
send information to the web server.
◦ The GET Method
◦ The POST Method

There are two ways the web server
retrieved the data send by web client.
◦ $_GET[‘variableName’];
◦ $_POST[‘variableName’];

Make sure you run
◦ Apache
◦ MySQL
before you doing coding in php and database

There are a few procedure that you need to
follow when doing coding php and MySQL

Connect to database

Insert data to database

Connect to database

Connect to database

Query the database

Retrieve results using the cursor

Retrieve results using the cursor and display
the ouput to web browser

Close the connection to database