Config.php
<?php
$databaseHost = 'localhost';
$databaseName = 'test';
$databaseUsername = 'root';
$databasePassword = '';
$mysqli = mysqli_connect($databaseHost,
$databaseUsername, $databasePassword, $databaseName);
?>
2. add.html
<html>
<head>
<title>Add
Data</title>
</head>
<body>
<a
href="index.php">Home</a>
<br/><br/>
<form
action="add.php" method="post" name="form1">
<table
width="25%" border="0">
<tr>
<td>Name</td>
<td><input
type="text" name="name"></td>
</tr>
<tr>
<td>Age</td>
<td><input
type="text" name="age"></td>
</tr>
<tr>
<td>Email</td>
<td><input
type="text" name="email"></td>
</tr>
<tr>
<td></td>
<td><input
type="submit" name="Submit"
value="Add"></td>
</tr>
</table>
</form>
</body>
</html>
3. add.php
<html>
<head>
<title>Add
Data</title>
</head>
<body>
<?php
//including the database connection file
include_once("config.php");
if(isset($_POST['Submit']))
{
$name =
$_POST['name'];
$age = $_POST['age'];
$email =
$_POST['email'];
// checking empty
fields
if(empty($name) ||
empty($age) || empty($email))
{
if(empty($name))
{
echo
"<font color='red'>Name field is
empty.</font><br/>";
}
if(empty($age))
{
echo
"<font color='red'>Age field is
empty.</font><br/>";
}
if(empty($email))
{
echo
"<font color='red'>Email field is
empty.</font><br/>";
}
//link
to the previous page
echo
"<br/><a href='javascript:self.history.back();'>Go
Back</a>";
} else {
//
if all the fields are filled (not empty)
//insert
data to database
$result
= mysqli_query($mysqli, "INSERT INTO users(name,age,email) VALUES('$name','$age','$email')");
//display
success message
echo
"<font color='green'>Data added successfully.";
echo
"<br/><a href='index.php'>View Result</a>";
}
}
?>
</body>
</html>
4.index.php
<?php
include_once("config.php");
$result = mysqli_query($mysqli, "SELECT
* FROM users ORDER BY id DESC");
?>
<html>
<head>
<title>Homepage</title>
</head>
<body>
<a
href="add.html">Add New Data</a><br/><br/>
<table width='80%'
border=0>
<trbgcolor='#CCCCCC'>
<td>Name</td>
<td>Age</td>
<td>Email</td>
<td>Update</td>
</tr>
<?php
//while($res
= mysql_fetch_array($result)) { // mysql_fetch_array is deprecated, we need to
use mysqli_fetch_array
while($res
= mysqli_fetch_array($result)) {
echo
"<tr>";
echo
"<td>".$res['name']."</td>";
echo
"<td>".$res['age']."</td>";
echo
"<td>".$res['email']."</td>";
echo
"<td><a href=\"edit.php?id=$res[id]\">Edit</a>
| <a href=\"delete.php?id=$res[id]\" onClick=\"return
confirm('Are you sure you want to delete?')\">Delete</a></td>";
}
?>
</table>
</body>
</html>
5.edit.php
<?php
// including the database connection file
include_once("config.php");
if(isset($_POST['update']))
{
$id = $_POST['id'];
$name=$_POST['name'];
$age=$_POST['age'];
$email=$_POST['email'];
// checking empty
fields
if(empty($name) ||
empty($age) || empty($email))
{
if(empty($name))
{
echo
"<font color='red'>Name field is
empty.</font><br/>";
}
if(empty($age))
{
echo
"<font color='red'>Age field is empty.</font><br/>";
}
if(empty($email))
{
echo
"<font color='red'>Email field is
empty.</font><br/>";
}
} else
{
//updating
the table
$result
= mysqli_query($mysqli, "UPDATE users SET
name='$name',age='$age',email='$email' WHERE id=$id");
//redirectig
to the display page. In our case, it is index.php
header("Location:
index.php");
}
}
?>
<?php
//getting id from url
$id = $_GET['id'];
//selecting data associated with this
particular id
$result = mysqli_query($mysqli, "SELECT
* FROM users WHERE id=$id");
while($res = mysqli_fetch_array($result))
{
$name = $res['name'];
$age = $res['age'];
$email =
$res['email'];
}
?>
<html>
<head>
<title>Edit
Data</title>
</head>
<body>
<a
href="index.php">Home</a>
<br/><br/>
<form
name="form1" method="post" action="edit.php">
<table
border="0">
<tr>
<td>Name</td>
<td><input
type="text" name="name" value="<?php echo
$name;?>"></td>
</tr>
<tr>
<td>Age</td>
<td><input
type="text" name="age" value="<?php echo
$age;?>"></td>
</tr>
<tr>
<td>Email</td>
<td><input
type="text" name="email" value="<?php echo
$email;?>"></td>
</tr>
<tr>
<td><input
type="hidden" name="id" value=<?php echo
$_GET['id'];?>></td>
<td><input
type="submit" name="update"
value="Update"></td>
</tr>
</table>
</form>
</body>
</html>
include("config.php");
<?php
//getting id of the data from url
$id = $_GET['id'];
//deleting the row from table
$result = mysqli_query($mysqli, "DELETE
FROM users WHERE id=$id");
//redirecting to the display page (index.php
in our case)
header("Location:index.php");
?>
0 Comments