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