Free Programming Source Codes and Computer Programming Tutorials: user record system in php and mysqli

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 telephone number at home here in Bacolod City, Negros Occidental Philippines is +63 (034) 4335675.

Sample Program Output

Program Listing

add.php

<html>

<head>

<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>

<title>Delete User Record</title>

</head>

<body>

<h3>Do you really want to delete the record of

<?php echo strtoupper($data['name'].'?'); ?>

</h3>

</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>

</head>

<body>

<legend>Edit Users</legend>

<tr>

</tr>

<tr>

</tr>

<tr>

<td ><button id="someTable" type="submit">Save Changes</button>  

</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>

<title>User Record System Using PHP and MySQLI</title>

</head>

<body>

<br>

<thead>

<tr>

<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>

<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>

<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>

</head>

<body>

<tr>

</tr>

<tr>

</tr>

<tr>

<td><button type="submit">Save Changes</button></td>

</tr>

</table>

</form>

</fieldset>

</body>

</html>

remove.php

<html>

<head>

<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);

DONWLOAD SOURCE CODE HERE

Free Programming Source Codes and Computer Programming Tutorials

Monday, March 5, 2018

User Record System in PHP and MySQLI

Google Ads

Followers