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>