Miniproject-PHP-MySQL

---

Overview

• Setting up a development environment for PHP programming is easy.

• Download the code editor you prefer, I personally like Visual Studio Code text editor.

• Next is to install XAMPP, the most popular PHP development environment.

• This package contains Apache, PHP & MariaDB or MySQL database applications.

---

How to run PHP code

Go to XAMPP server directory place your code here..... I’m using Windows, so my root server directory is “C:\xampp\htdocs\” Save the filename with .php extension

To see output, On you browser window, type "http://localhost/filename.php"

---

Manage MySQL with PhpMyAdmin

MySQL is an open-source relational database management system (RDBMS). MySQL is a popular choice of database for use in web applications.

phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser.

---

👉 Creating a Database

1. Go to http://localhost/phpmyadmin/
2. Click the “New” link on the upper left corner (under recent tables)
3. Fill out the “Database Name” field
4. Click the “Create” button

👉 Creating a Table

1. Click “Database Name” on the left side of the screen
2. On the “Create Table” section, fill out the Name and Number of Columns
3. Click “Go” button
4. Fill out the Fields with id, name, etc.
5. Click the “Save” button

---

Exercises

1. Create a simple webpage using PHP.

2. Design a form to create an email. Store the data in a database. Validate all the input fields. Database connectivity in PHP with MySQL.

3. Create a MySQL database table tbl_login with fields user name and Password. Perform all database operations like Select, Insert, Delete, Update on the table tbl_login

4. Develop a CRUD application, which stands for Create, Read, Update, Delete.

5. Create a table with two columns namely the name of the player and number of wickets. Create a chart to display the data.

---