public function showAllSpecializations() { $s = Specialization::all(); return Response::data($s); }
require_once 'header.php'; require_once 'classes/Entity/Specialization.php'; require_once 'classes/Connection.php'; $db = new Connection('localhost', 'itstep', '123123', 'itstep_db'); if (isset($_POST['add'])) { if (isset($_POST['name']) && !empty($_POST['name'])) { $query = 'INSERT INTO spec (Name) VALUES (\'%s\')'; $query = sprintf($query, $_POST['name']); $db->query($query); } } if (isset($_GET['del_id'])) { $delId = $_GET['del_id']; Specialization::delete($delId); } $specs = Specialization::getAll(); ?> <form action="" method="post"> <input type="text" name="name"/> <input type="submit" value="Добавить" name="add"/> </form> <ul> <? foreach($specs as $spec) { ?> <li><?php echo $spec['Name']; ?> <a href="?del_id=<?php echo $spec['Id']; ?> "> X </a></li>
function Add_Specialization(Specialization $specialization) { $Name = $specialization->getName(); $Name_Amharic = $specialization->getNameAmharic(); $General_Category = $specialization->getGeneralCategory(); $query0 = "START TRANSACTION"; $result0 = mysqli_query($this->getDbc(), $query0); //insert into the specialization table $query1 = "insert into specialization (Name,Name_Amharic,General_Category) VALUE ('{$Name}','{$Name_Amharic}','{$General_Category}')"; $result1 = mysqli_query($this->getDbc(), $query1); if ($result0 and $result1) { $query3 = "COMMIT"; mysqli_query($this->getDbc(), $query3); return TRUE; } else { $query_roll = "ROLLBACK"; mysqli_query($this->getDbc(), $query_roll); echo "Rolled back"; return FALSE; } }