<?php
require "includes/index.php";
require_once "Slim/Slim.php";
$data = new Slim();
$data->get('/books/search', function () use($data) {
$query = $data->request()->params('name');
findByName($query);
});
$data->get('/books', 'getBooks');
$data->get('/books/:id', 'getBook');
//$data->get('/books/search:query', 'findByName');
$data->post('/books', 'addBook');
$data->put('/books/:id', 'updateBook');
$data->delete('/books/:id', 'deleteBook');
$data->run();
function getBooks()
{
$sql = "select * FROM books ORDER BY id DESC";
try {
$db = getConnection();
$stmt = $db->query($sql);
$books = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
echo json_encode($books);
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
function getBook($id)
{
foreach ($vars as $key => $value) {
$body->set($key, $value);
}
}
} else {
$body = new Template("templates/aa/aa.default.tmpl.php");
}
break;
case 1:
// Search AAs
check_authorization();
$body = new Template("templates/aa/aa.searchresults.tmpl.php");
if (isset($_GET['aaid']) && $_GET['aaid'] != "ID") {
$results = findByID($_GET['aaid']);
} else {
$results = findByName($_GET['search']);
}
$body->set("results", $results);
$body->set('eqexpansions', $eqexpansions);
break;
case 28:
// Search by expansion / class
check_authorization();
$cls = isset($_GET['cls']) ? $_GET['cls'] : null;
$exp = isset($_GET['exp']) ? $_GET['exp'] : null;
$body = new Template("templates/aa/aa.searchresults.tmpl.php");
$body->set('eqexpansions', $eqexpansions);
$body->set('results', null);
if ($cls != null && $exp != null) {
$results = findByClsExp($cls, $exp);
$body->set('results', $results);
/**
* Get the default group ID's for a new user.
*
* @return array
*/
public static function getDefaultGroupIds()
{
$groupIds = array();
if (!empty(GO::config()->register_user_groups)) {
$groups = explode(',', GO::config()->register_user_groups);
foreach ($groups as $groupName) {
$group = GO\Base\Model\Group::model() - findByName(trim($groupName));
$groupIds[] = $group->id;
}
}
if (!in_array(GO::config()->group_everyone, $groupIds)) {
$groupIds[] = GO::config()->group_everyone;
}
return $groupIds;
}
<?php
session_start();
include '../dao/dbcon.php';
include '../dao/address.php';
include '../dao/provider.php';
$cname = $_GET['cname1'];
$ccode = $_GET['ccode1'];
$errors = "";
$res = checkcnamepassword($cname, $ccode);
if (!strcmp($cname, null) || !strcmp($ccode, null)) {
$errors .= "<li >Please fill all boxes.</li>";
} else {
if ($res == '1') {
////login successfull
$temp = findByName($cname);
//var_dump($temp);die;
$_SESSION['provider'] = $temp;
echo "OK";
} else {
$errors .= "<li >Invalid Company name or Company Code</li>";
}
}
echo $errors;
$items = $select->fetchAll();
unset($select);
$row_num = count($items);
$obj = (object) array('result' => true, 'count' => "Найдено записей: " . $row_num, 'items' => $items);
echo json_encode($obj);
$result_out = true;
} catch (PDOException $e) {
$obj = (object) array('result' => false, 'error' => "Ошибка выполнения запроса");
echo json_encode($obj);
$result_out = true;
exit;
}
}
//поиск организации по названию
if (isset($name)) {
findByName($name);
}
function findByName($name)
{
global $conn;
global $result_out;
$name = mb_ereg_replace("/[^a-zа-яё0-9/-]/", "", $name);
try {
$select = $conn->query("SELECT company.name,building.adress FROM building\n\t\t\tINNER JOIN company ON (building.id_b = company.id_b) where company.name LIKE CONCAT('%', '{$name}', '%')");
$select->setFetchMode(PDO::FETCH_OBJ);
$items = $select->fetchAll();
unset($select);
$row_num = count($items);
$obj = (object) array('result' => true, 'count' => "Найдено записей: " . $row_num, 'items' => $items);
echo json_encode($obj);
$result_out = true;
