A simple crud application that I wrote using PHP and MySQLI which is already compliant with the new version of PHP.
My email address are the following jakerpomperada@gmail.com and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.
My email address are the following jakerpomperada@gmail.com and jakerpomperada@yahoo.com.
My telephone number at home here in Bacolod City, Negros Occidental Philippines is +63 (034) 4335675.
Sample Program Output
Program Listing
add.php
<html>
<head>
<link rel="stylesheet" type="text/css" href="mystyle.css">
<title>User Record System Using PHP and MySQLI</title>
</head>
<body>
<?php
require_once 'connections.php';
if($_POST) {
$name = $_POST['name'];
$age = $_POST['age'];
$sql = "INSERT INTO person (name,age) VALUES ('$name', '$age')";
if($connect->query($sql) === TRUE) {
echo "<p>New Record Successfully Created</p>";
echo "<a href='create.php'><button type='button'>Back</button></a>";
echo "<a href='index.php'><button type='button'>Home</button></a>";
} else {
echo "Error " . $sql . ' ' . $connect->connect_error;
}
$connect->close();
}
?>
</body>
</html>
delete.php
<?php
require_once 'connections.php';
if($_GET['id']) {
$id = $_GET['id'];
$sql = "SELECT * FROM person WHERE id = {$id}";
$result = $connect->query($sql);
$data = $result->fetch_assoc();
$connect->close();
?>
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" type="text/css" href="mystyle.css">
<title>Delete User Record</title>
</head>
<body>
<h3>Do you really want to delete the record of
<?php echo strtoupper($data['name'].'?'); ?>
</h3>
<form action="remove.php" method="post">
<input type="hidden" name="id" value="<?php echo $data['id'] ?>" />
<button type="submit">Ok</button>
<a href="index.php"><button type="button">Back</button></a>
</form>
</body>
</html>
<?php
}
?>
edit.php
<?php
require_once 'connections.php';
if($_GET['id']) {
$id = $_GET['id'];
$sql = "SELECT * FROM person WHERE id = {$id}";
$result = $connect->query($sql);
$data = $result->fetch_assoc();
$connect->close();
?>
<!DOCTYPE html>
<html>
<head>
<title>Edit Users</title>
<link rel="stylesheet" type="text/css" href="mystyle.css">
</head>
<body>
<fieldset>
<legend>Edit Users</legend>
<form action="update.php" method="post">
<table cellspacing="0" cellpadding="0">
<tr>
<th>Name</th>
<td><input type="text" name="name" placeholder="Name" value="<?php echo $data['name'] ?>" /></td>
</tr>
<tr>
<th>Age</th>
<td><input type="text" name="age" placeholder="Age" value="<?php echo $data['age'] ?>" /></td>
</tr>
<tr>
<input type="hidden" name="id" value="<?php echo $data['id']?>" />
<td ><button id="someTable" type="submit">Save Changes</button>
<a href="index.php"><button type="button">Back</button></a></td>
</tr>
</table>
</form>
</fieldset>
</body>
</html>
<?php
}
?>
index.php
<html>
<?php require_once 'connections.php'; ?>
<!DOCTYPE html>
<<br>
<h3 align="center"> User Record System Using PHP and MySQLI </h3>html>
<head>
<link rel="stylesheet" type="text/css" href="mystyle.css">
<title>User Record System Using PHP and MySQLI</title>
</head>
<body>
<br>
<div class="manageUser">
<a href="create.php"><button type="button">Add User</button></a>
<table border="1" cellspacing="0" cellpadding="0">
<thead>
<tr>
<th>Name</th>
<th>Age</th>
<th>Option</th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM person";
$result = $connect->query($sql);
if($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "<tr>
<td>".$row['name']."</td>
<td>".$row['age']."</td>
<td>
<a href='edit.php?id=".$row['id']."'><button type='button'>Edit</button></a>
<a href='delete.php?id=".$row['id']."'><button type='button'>Remove</button></a>
</td>
</tr>";
}
} else {
echo "<tr><td colspan='5'><center>No Data Avaliable</center></td></tr>";
}
?>
</tbody>
</table>
</div>
</body>
</html>
update.php
<html>
<head>
<link rel="stylesheet" type="text/css" href="mystyle.css">
<title>User Record System Using PHP and MySQLI</title>
</head>
<body>
<?php
require_once 'connections.php';
if($_POST) {
$name = $_POST['name'];
$age = $_POST['age'];
$id = $_POST['id'];
$sql = "UPDATE person SET name = '$name',age = '$age' WHERE id = {$id}";
if($connect->query($sql) === TRUE) {
echo "<p>Succcessfully Updated</p>";
echo "<a href='edit.php?id=".$id."'><button type='button'>Back</button></a>";
echo "<a href='index.php'><button type='button'>Home</button></a>";
} else {
echo "Erorr while updating record : ". $connect->error;
}
$connect->close();
}
?>
</body>
</html>
connections.php
<?php
$localhost = "localhost";
$username = "root";
$password = "";
$dbname = "user";
// create connection
$connect = new mysqli($localhost, $username, $password, $dbname);
// check connection
if($connect->connect_error) {
die("connection failed : " . $connect->connect_error);
} else {
// echo "Successfully Connected";
}
?>
create.php
<!DOCTYPE html>
<html>
<head>
<title>Add Member</title>
<link rel="stylesheet" type="text/css" href="mystyle.css">
</head>
<body>
<fieldset>
<legend>Add User</legend>
<form action="add.php" method="post">
<table cellspacing="0" cellpadding="0">
<tr>
<th>Name</th>
<td><input type="text" name="name" placeholder="Name" /></td>
</tr>
<tr>
<th>Age</th>
<td><input type="text" name="age" placeholder="Age" /></td>
</tr>
<tr>
<td><button type="submit">Save Changes</button></td>
<td><a href="index.php"><button type="button">Back</button></a></td>
</tr>
</table>
</form>
</fieldset>
</body>
</html>
remove.php
<html>
<head>
<link rel="stylesheet" type="text/css" href="mystyle.css">
<title>User Record System Using PHP and MySQLI</title>
</head>
<body>
<?php
require_once 'connections.php';
if($_POST) {
$id = $_POST['id'];
$sql = "DELETE FROM person WHERE id = {$id}";
if($connect->query($sql) === TRUE) {
echo "<link rel='stylesheet' type='text/css href='mystyle.css'>";
echo "<p>Record Sucessfully Remove from the Database !!!</p>";
echo "<a href='index.php'><button type='button'>Back</button></a>";
} else {
echo "Error removing record : " . $connect->error;
}
$connect->close();
}
?>
</body>
<html>
mystyle.css
.manageUser {
width: 50%;
margin: auto;
}
table {
font-family:arial;
font-weight:bold;
size:18px;
width: 100%;
margin-top: 20px;
}
body {
background-color:lightgreen;
font-family:arial;
font-weight:bold;
size:18px;
}
fieldset {
margin: auto;
margin-top: 100px;
width: 50%;
}
table tr th {
padding-top: 10px;
}
user.sql
-- phpMyAdmin SQL Dump
-- version 3.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 04, 2014 at 06:55 AM
-- Server version: 5.1.30
-- PHP Version: 5.2.8
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `user`
--
-- --------------------------------------------------------
--
-- Table structure for table `person`
--
CREATE TABLE IF NOT EXISTS `person` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`age` int(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `person`
--
INSERT INTO `person` (`id`, `name`, `age`) VALUES
(1, 'Manuel Uy', 36),
(2, 'Jorge Vargas', 12),
(3, 'Maria Buenavista', 22);
No comments:
Post a Comment