public function testCreateUser()
{
$params = array('table' => 'my_record', 'first_name' => 'fname', 'last_name' => 'lname', 'address' => 'address', 'phone' => 'phone');
$conn = new connection();
$result = $conn->create('users', 'fname', 'lname', 'address', 'phone');
$this->assertEquals(true, $result);
}
///////////////////////create trigger to products////////////***************
$query = "DELIMITER //\n\t\t\tCREATE TRIGGER changes BEFORE INSERT ON\n\t\t\tProducts FOR EACH ROW BEGIN\n\t\t\t\t\tUPDATE changes\n\t\t\tSET changeDate = NOW() where tableName='Products'\n\t\t\tEND //\n\t\t\tDELIMITER ;";
mysqli_query(connection::$obj, $query);
///////////////////////create trigger to category////////////***************
$query = "DELIMITER //\n\t\t\tCREATE TRIGGER changes BEFORE INSERT ON\n\t\t\tCategory FOR EACH ROW BEGIN\n\t\t\t\t\t\tUPDATE changes\n\t\t\tSET changeDate = NOW() where tableName='Category'\n\t\t\tEND //\n\t\t\tDELIMITER ;";
mysqli_query(connection::$obj, $query);
///////////////////////create trigger to Room////////////***************
$query = "DELIMITER //\n\t\t\tCREATE TRIGGER changes BEFORE INSERT ON\n\t\t\tRoom FOR EACH ROW BEGIN\n\t\t\t\t\t\tUPDATE changes\n\t\t\tSET changeDate = NOW() where tableName='Room'\n\t\t\tEND //\n\t\t\tDELIMITER ;";
mysqli_query(connection::$obj, $query);
//////////////////////create trigger to Orders////////////***************
$query = "DELIMITER //\n\t\t\tCREATE TRIGGER changes BEFORE INSERT ON\n\t\t\tOrders FOR EACH ROW BEGIN\n\t\t\t\t\t\tUPDATE changes\n\t\t\tSET changeDate = NOW() where tableName='Orders'\n\t\t\tEND //\n\t\t\tDELIMITER ;";
mysqli_query(connection::$obj, $query);
/////////////////add relationship between tables
$sq = "alter table Users add foreign key (rid) references Room (rid);";
connection::$obj->query($sq);
$sq = "alter table Products add foreign key (cid) references Category (cid);";
connection::$obj->query($sq);
$sq = "alter table Orders add foreign key (uid) references Users (uid);";
connection::$obj->query($sq);
$sq = "alter table Orders add foreign key (rid) references Room (rid);";
connection::$obj->query($sq);
$sq = "alter table orderProducts add foreign key (oid) references Orders (oid);";
connection::$obj->query($sq);
$sq = "alter table orderProducts add foreign key (pid) references Products (pid);";
connection::$obj->query($sq);
$sq = "alter table orderProducts add primary key (oid,pid);";
connection::$obj->query($sq);
}
}
connection::create();
<?php
include_once 'connection.php';
$con = new connection();
$table = "users";
if (isset($_POST['submit'])) {
$fname = $_POST['first_name'];
$lname = $_POST['last_name'];
$address = $_POST['address'];
$phone = $_POST['phone'];
$res = $con->create($table, $fname, $lname, $address, $phone);
if ($res) {
header('Location: ' . 'index.php');
}
}
?>
<html>
<head>
<title>CRUD</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
</head>
<body>
<div class="container">
<div class="row">
<label for="Edit user">Create User:</label>
<form method="post">
<table align="center" class="table table-bordered">
<tr>
<td>First Name:</td>
<td><input type="text" name="first_name" placeholder="First Name" required/></td>
