Use of database in PHP
Introduction of Database
A database is a collection of program and tools that facilitate users to create and maintain the database. It provides the enterprise with centralized control of its operational data- which is one of its most relevant assets.
We will be using MYSQL it is the most popular database system in the world. It stands for structure query language. The first word MY stands for the daughter's name of co-founder Michael Widenius. It is an open source, most popular and it helps to execute the command or query.
Example of Students table
The table is divided in three parts Column Rows and Field
Id | Name | Address | class |
1 | Karna Singh | L 780 the Lotus arena sector70, Noida | 8th |
2 | Diva verma | 348 , Brigton Towers, Lokhandwala, Andheri (west) | 10th |
3 | Sikha yadav | 87, Raj Apartments, JyotiGunj Noida - 498176 | 12th |
4 | Vipin rana | 54, Mukti Chowk, Delhi- 160598 | 6th |
Creating a database in PHPmyadmin
PHPmyadmin allows us to create a database we can create database and manage the database and many more things .
Open your browser on address bar write localhost/phpmyadmin click Enter.
click on database option and create a database gives a name to your database School
Or click on SQL write query to make your database
CREATE DATABASE School
There are many more options in the database such as SQL, status, users, export, import, settings, replications, variables and more each has different functions and different use .
Creating Tables and Inserting Data in database
Click on the database School and create a table students and the number is 4
After making table, click save there you get the table students and then enter the data in the students table.
In this table, we use id as an integer and A_I auto increment so it increases as you enter any record.
We can edit and drop our students table .
Design student view page
By using bootstrap classes
student.php
<html>
<head>
<title>This is demo</title>
<meta charset="utf-8">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<h2>Student Form</h2>
<form class="form-horizontal" action="student.php" method="post">
<div class="form-group">
<label class="control-label col-sm-2">Name:</label>
<div class="col-sm-7">
<input type="text" class="form-control" id="name" placeholder="Enter Name" name="name">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="pwd">Address:</label>
<div class="col-sm-7">
<input type="text" class="form-control" id="address" placeholder="Enter Address" name="address">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2">Class:</label>
<div class="col-sm-7">
<input type="text" class="form-control" id="class" placeholder="Enter Class" name="class">
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-10">
<button type="submit" name="submit" class="btn btn-success">Submit</button>
</div>
</div>
</form>
</div>
</body>
</html>
Receiving Post data from check
student.php
<?php
if(isset($_POST['submit'])){
$name = $_POST['name'];
$address = $_POST['address'];
$class = $_POST['class'];
echo $name;
echo $address;
echo $class;
}
?>
<html>
<head>
<title>This is demo</title>
<meta charset="utf-8">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<h2>Student Form</h2>
<form class="form-horizontal" action="student.php" method="post">
<div class="form-group">
<label class="control-label col-sm-2">Name:</label>
<div class="col-sm-7">
<input type="text" class="form-control" id="name" placeholder="Enter Name" name="name">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2">Address:</label>
<div class="col-sm-7">
<input type="text" class="form-control" id="address" placeholder="Enter Address" name="address">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2">Class:</label>
<div class="col-sm-7">
<input type="text" class="form-control" id="class" placeholder="Enter Class" name="class">
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-10">
<button type="submit" name="submit" class="btn btn-success">Submit</button>
</div>
</div>
</form>
</div>
</body>
</html>
To check the data in another way
Whether the data is received in the form or not we have to check the data by using if and else statement in PHP.
student.php
//Using if and else condition to check the form data
<?php
if(isset($_POST['submit'])){
$name = $_POST['name'];
$address = $_POST['address'];
$class = $_POST['class'];
If ($name && $address && $class){
echo $name;
echo $address;
echo $class;
} else {
echo "Please fill the form";
}
}
?>
Connection of database by using PHP
To make a connection of database we use the mysqli_connect. mysqli_connect takes 4 arguments and return connection link:
1. Host
2. Database User
3. Database Password
4. Database Name
student.php
<?php
if(isset($_POST['submit'])){
$name = $_POST['name'];
$address = $_POST['address'];
$class = $_POST['class'];
// code for database connection
$connection = mysqli_connect('localhost', 'root', '', 'school');
If ($connection) {
echo "Your connection has been established";
} else {
echo "Database Error No.: " . mysqli_connect_errno() . PHP_EOL;
echo "Database Error: " . mysqli_connect_error() . PHP_EOL;
die("Please try again");
}
}
?>
For more use click here