Transcript Digital Spray template

Login to a Database (from a Webpage),
Inserting data into a database from a form,
getting data from database and display on
Webpage
Done by: Mashail Alsolamy
Tools:
• Notepad++
• Internet Explorer
• WampServer
Outlines:
• Connecting to Database (Login to
Database)
• Insert data into database from a form
• getting data from database and display
on Webpage
Why do we choose MySQL
Database?
MySQL is currently the most popular open
source database server in existence. It is
very commonly used in conjunction with
PHP scripts to create powerful and
dynamic server-side applications.
MySQL phpMyAdmin:
It is a popular web interface that is
included with almost every type of
Shared, Virtual or Dedicated hosting
solution
and
the
very
popular
phpMyAdmin tool should come with your
web hosting plan.
How do we open phpMyAdmin and
create databases and tables:
1. Open your cPanel.
2. Click on phpMyAdmin in the section of
database.
3. Create a new database
4. Create a new user with password
5. Assign the user to the database
6. Create table inside this database.
Example
Server : localhost Database : test
Table : example
Username : admin
Password : 1admin
Login to Mysql Database from
webpage:
1. Create login form to access the
database through it.
2. Verify the username and password
3. If username and pass word correct then
use bellow command to connect to
certain database.
// Make a MySQL Connection
mysql_connect( host, username, password) or die (mysql_error());
mysql_select_db( Name of database) or die (mysql_error());
The default values in
wampserver are:
Host=“localhost”
Username=“root”
Password=“”
4. After connect, we can insert data to the
table through the form.
4. To display The contents of the table
onto a webpage use this command:
4. To delete a record from the table use
this command:
Thank you for your attention
and
I hope I explained the subject well