function testBrxCntDist()
{
$systems = array("NMBS", "MIVB");
$data = new DataLayer("EN");
//Brussel Centraal liveboard
$liveboard = $data->getLiveboard(4.35, 50.85, "DEP", $systems[0]);
$this->assertEqual($liveboard[0]["stationinfo"]["distance"], "455m");
}
public static function Insert(ContactsDetails $c)
{
global $conn;
$dl = new DataLayer($conn->link);
$dl->debug = false;
$lab_contacts = array('contact_name' => $c->_contact_name, 'contact_email' => $c->_contact_email, 'contact_type' => $c->_contact_type, 'contact_company' => $c->_contact_company, 'contact_title' => $c->_contact_title, 'contact_subject' => $c->_contact_subject, 'contact_message' => $c->_contact_message, 'contact_date_submited' => $c->_contact_date_submited);
$dl->insert("lab_contacts", $lab_contacts) or die($dl->getError());
$val_array = array("id" => $dl->inserted(""));
return $val_array;
}
public function Delete()
{
$datalayer = new DataLayer();
$datalayer->OpenConnection();
try {
$datalayer->DeleteObject($this);
} catch (Exception $e) {
$this->ServerErr = $e->getMessage();
$this->ServerErrNo = $e->getCode();
}
$datalayer->CloseConnection();
}
public function test1()
{
DataLayer::testRow0a(1);
DataLayer::testRows1(1);
DataLayer::testRowsWithIndex1(100);
DataLayer::testRowsWithKey1(100);
}
public static function RightBlocks($page_id)
{
global $conn;
$dl = new DataLayer($conn->link);
$dl->debug = false;
$query = "SELECT block_id,page_id,block_title,block_has_title,block_content";
$query .= " FROM ";
$query .= "lab_blocks";
$conditions = array('block_direction' => "RIGHT", 'page_id' => $page_id);
$order = array('block_order' => "ASC");
$limit = array();
$fun_array = $dl->select($query, $conditions, $order, $limit) or die($dl->getError());
if (!empty($fun_array[0])) {
return $fun_array;
}
return false;
}
public static function ChildServicesList($service_parent_id)
{
global $conn;
$dl = new DataLayer($conn->link);
$dl->debug = false;
$query = "SELECT service_id,service_parent_id,service_title,service_description,service_date_submited";
$query .= " FROM ";
$query .= "lab_services";
$conditions = array('service_parent_id' => $service_parent_id);
$order = array('service_order' => "ASC", 'service_title' => "ASC", 'service_date_submited' => "DESC");
$limit = array();
$fun_array = $dl->select($query, $conditions, $order, $limit) or die($dl->getError());
if (!empty($fun_array[0])) {
return $fun_array;
}
return false;
}
public static function CategoryList()
{
global $conn;
$dl = new DataLayer($conn->link);
$dl->debug = false;
$query = "SELECT category_id,category_title";
$query .= " FROM ";
$query .= "lab_categories";
$conditions = array();
$order = array('category_title' => "ASC", 'category_id' => "ASC");
$limit = array();
$fun_array = $dl->select($query, $conditions, $order, $limit) or die($dl->getError());
if (!empty($fun_array[0])) {
return $fun_array;
}
return false;
}
/**
* Test constant __DIR__ with several characters that need escaping.
*/
public function test5()
{
$dir_name = realpath(__DIR__ . '/../../test/MySql/psql/ test_escape \' " @ $ ! .');
if ($dir_name) {
$ret = DataLayer::magicConstant05();
$this->assertEquals($dir_name, $ret);
}
}
public static function ClientsFeatured()
{
global $conn;
$dl = new DataLayer($conn->link);
$dl->debug = false;
$query = "SELECT client_id,client_title,client_brief,client_thumbnail,client_date_submited";
$query .= " FROM ";
$query .= "lab_clients";
$conditions = array('client_featured' => "Y");
$order = array('client_order' => "ASC", 'client_title' => "ASC", 'client_date_submited' => "DESC");
$limit = "5";
$fun_array = $dl->select($query, $conditions, $order, $limit) or die($dl->getError());
if (!empty($fun_array[0])) {
return $fun_array;
}
return false;
}
public static function PortfolioDetails($portfolio_id)
{
global $conn;
$dl = new DataLayer($conn->link);
$dl->debug = false;
$query = "SELECT port.portfolio_id,port.category_id,cat.category_title,port.portfolio_title,port.portfolio_brief,port.portfolio_thumbnail,port.portfolio_image,port.portfolio_date_submited";
$query .= " FROM ";
$query .= "lab_portfolios as port";
$query .= " INNER JOIN ";
$query .= "lab_categories as cat";
$query .= " ON ";
$query .= "port.category_id = cat.category_id";
$conditions = array('portfolio_id' => $portfolio_id);
$order = array();
$limit = array(1);
$fun_array = $dl->select($query, $conditions, $order, $limit) or die($dl->getError());
if (!empty($fun_array[0])) {
return $fun_array;
}
return false;
}
public static function GetSelectedPage($page_id)
{
global $conn;
$dl = new DataLayer($conn->link);
$dl->debug = false;
$query = "SELECT page.page_id,\r\n\t\t\t\t\t\tpage.control_id, \r\n\t\t\t\t\t\tpage.page_title,\r\n\t\t\t\t\t\tpage.page_description, \r\n\t\t\t\t\t\tpage.page_meta_keyword,\r\n\t\t\t\t\t\tpage.page_meta_description,\r\n\t\t\t\t\t\tcontrol.control_file";
$query .= " FROM ";
$query .= "lab_pages as page";
$query .= " LEFT OUTER JOIN ";
$query .= "lab_controls as control";
$query .= " ON ";
$query .= "page.control_id = control.control_id";
$conditions = array('page.page_id' => $page_id);
$order = array();
$limit = "0,1";
$fun_array = $dl->select($query, $conditions, $order, $limit) or die($dl->getError());
if (!empty($fun_array[0])) {
return $fun_array;
}
return false;
}
/**
* Stored routine with designation type table must show table.
*/
public function test1()
{
$template_table = '
+---------+---------+---------+---------+---------------------+------+------+
| tst_c00 | tst_c01 | tst_c02 | tst_c03 | tst_c04 | t | s |
+---------+---------+---------+---------+---------------------+------+------+
| Hello | 1 | 0.543 | 1.23450 | 2014-03-27 00:00:00 | 4444 | 1 |
| World | 3 | 0.00003 | 0.00000 | 2014-03-28 00:00:00 | | 1 |
+---------+---------+---------+---------+---------------------+------+------+
';
ob_start();
DataLayer::testTable();
$table = ob_get_contents();
ob_end_clean();
$this->assertEquals($table, $template_table);
}
/**
* Function is initializing App data storage
* @param string $storageType
* @return FileDataConnector|MySql|null return the specific type connector
*/
public static function Init($storageType)
{
self::$_logger = Logger::GetInstance();
$logLevel = LogLevels::INFO;
if (self::$_connector == NULL) {
switch ($storageType) {
default:
case AppConstants::FILE_STORAGE:
self::$_connector = new FileDataConnector();
self::$_logger->WriteLog('File data storage inited.', $logLevel);
break;
case AppConstants::MYSQL_STORAGE:
self::$_connector = new MySql();
self::$_logger->WriteLog('SQL data storage inited.', $logLevel);
break;
}
}
return self::$_connector;
}
/**
* Test must not be a problem.
*/
public function test2()
{
$data[] = ['field1' => 1, 'field2' => 1, 'field3' => 1, 'field4' => 1, 'field5' => 1];
// int,
DataLayer::testBulkInsert02($data);
}
<tbody>
<?php
$sort = " ";
if (isset($_GET['name'])) {
$sort = 2;
}
if (isset($_GET['topic'])) {
$sort = 6;
}
if (isset($_GET['time'])) {
$sort = 3;
}
if (isset($_GET['status'])) {
$sort = 5;
}
if (isset($_GET['school'])) {
$sort = 7;
}
$data = new DataLayer();
$res = $data->getAll($sort, $_SESSION['school'], $_SESSION['sec']);
foreach ($res as $row) {
echo "<tr>\n <td>{$row['2']}</td>\n <td>{$row['3']}</td>\n <td>{$row['6']}</td>\n <td>{$row['7']}</td>\n <td>{$row['8']}</td>\n <td>{$row['5']}</td>\n <td><a href='{$row['4']}'>{$row['4']}</a></td>\n </tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</body>
*/
require_once "Complaint.php";
require_once "DataLayer.php";
require_once "lib.php";
$complaints;
$searchText = "";
$errors = array();
//$hey = new DataLayer();
//$hey->addPicture();
if (count($_POST) > 0) {
if ($_POST["search"]) {
$searchText = $_POST["searcher"];
if (empty($searchText)) {
$errors[] = "Please type some text to search";
} else {
$dl = new DataLayer();
$complaints = $dl->findComplaintByIssue($searchText);
if (count($complaints) < 1) {
$errors[] = "Your search yielded no results";
}
}
} else {
$complaints = null;
}
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
public function Delete()
{
require_once dirname(__FILE__) . '/datalayer.php';
$datalayer = new DataLayer();
$datalayer->DeleteObject($this);
}
/**
* Stored routine with designation type rows_with_index must return empty array when no rwos are selected.
*/
public function test2()
{
$rows = DataLayer::testRowsWithIndex1(0);
$this->assertInternalType('array', $rows);
$this->assertCount(0, $rows);
}
/**
* An exception must be thrown when a stored routine with designation type row1 returns more than 1 rows.
*
* @expectedException SetBased\Stratum\Exception\ResultException
*/
public function test3()
{
DataLayer::testRow1a(2);
}
/**
* An exception must be thrown when a stored routine with designation type singleton1 returns more than 1 values.
*
* @expectedException SetBased\Stratum\Exception\ResultException
*/
public function test3()
{
DataLayer::testSingleton1a(2);
}
<?php
// includes
require_once __DIR__ . DIRECTORY_SEPARATOR . 'includes' . DIRECTORY_SEPARATOR . 'classes' . DIRECTORY_SEPARATOR . 'template.php';
require_once __DIR__ . DIRECTORY_SEPARATOR . 'includes' . DIRECTORY_SEPARATOR . 'classes' . DIRECTORY_SEPARATOR . 'datalayer.php';
// datalayer
$db = new DataLayer();
// actions
if (isset($_REQUEST['btnCancel'])) {
header("Location: browse.php");
exit(0);
}
if (isset($_REQUEST['btnOk'])) {
$newContact = new Contact();
$newContact->name = $_POST['name'];
$newContact->email = $_POST['email'];
$newContact->role = $_POST['role'];
$newContact->comments = $_POST['comments'];
$newId = $db->insertContact($newContact);
if ($_FILES['picture']['tmp_name'] != "") {
// upload picture
$copyTo = __DIR__ . '/files/avatars/avatar_' . $newId . '.jpg';
$copyFrom = $_FILES['picture']['tmp_name'];
move_uploaded_file($copyFrom, $copyTo);
boxScaleJpg($copyTo, 100, 70);
} else {
$copyTo = __DIR__ . '/files/avatars/avatar_' . $newId . '.jpg';
$copyFrom = __DIR__ . '/files/avatars/no_thn.jpg';
copy($copyFrom, $copyTo);
}
header("Location: browse.php");
<?php
/**
* Created by PhpStorm.
* User: randyjp
* Date: 4/29/15
* Time: 11:27 PM
*/
require_once "Complaint.php";
require_once "DataLayer.php";
require_once "lib.php";
$dl = new DataLayer();
$id = $_GET["id"];
$messages = array();
$success = true;
if (count($_POST) > 0) {
$id = $_POST["hiddenId"];
if (!empty($_POST["txtComments"])) {
$dl->addCommentById($id, $_POST["txtComments"]);
$messages[] = "Comment Added Successfully";
} else {
$messages[] = "Comments can't be empty.";
$success = false;
}
}
if (empty($id)) {
header("location:index.php");
die;
}
$complaint = $dl->findComplaintById($id);
?>
private static function prettifydatavalue($value, $fieldinfo)
{
// tinyint_ 1
// boolean_ 1
// smallint_ 2
// int_ 3
// float_ 4
// double_ 5
// real_ 5
// timestamp_ 7
// bigint_ 8
// serial 8
// mediumint_ 9
// date_ 10
// time_ 11
// datetime_ 12
// year_ 13
// bit_ 16
// decimal_ 246
// text_ 252
// tinytext_ 252
// mediumtext_ 252
// longtext_ 252
// tinyblob_ 252
// mediumblob_ 252
// blob_ 252
// longblob_ 252
// varchar_ 253
// varbinary_ 253
// char_ 254
// binary_ 25
$retval = $value;
if ($value) {
if (DataLayer::fieldisnotnumeric($fieldinfo)) {
//timestamp - 7
//datetime - 12
if (($fieldinfo->type == 7 || $fieldinfo->type == 12) && $value == 'now()') {
$retval = $value;
} else {
$retval = "'" . $value . "'";
}
}
} else {
$retval = 'null';
}
return $retval;
}
public function Delete()
{
require_once 'common/datalayer.php';
$datalayer = new DataLayer();
$datalayer->DeleteObject($this);
}
<?php
require "dataLayer.class.php";
$data = new DataLayer();
session_start();
if (!isset($_SESSION['userId']) || !$data->checkToken($_SESSION['userId'], session_id())) {
header("Location: login.php");
die;
}
if ($title === "prof") {
$res = $data->getStudent($_SESSION['userId']);
if ($res[6] != 1) {
header("Location: login.php");
}
}
/**
* Stored routine with designation type function execute stored function and return result.
*/
public function test2()
{
$ret = DataLayer::testFunction(3, 4);
$this->assertNotEquals(5, $ret);
}
/**
* Stored routine with designation type rows must return an array with 3 rows when 3 rows are selected.
*/
public function test3()
{
$ret = DataLayer::testRows1(2);
$this->assertInternalType('array', $ret);
$this->assertCount(2, $ret);
}
/**
* An exception must be thrown when a stored routine with designation type singleton1 returns more than 1 values.
*
* @expectedException SetBased\Stratum\Exception\ResultException
*/
public function test3()
{
DataLayer::testSingleton1aWithLob(2, 'blob');
}
<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
require_once 'DAL/DataLayer.php';
require_once 'DAL/usersListGen.php';
require_once 'DAL/AppConstants.php';
$serializer = new UserListGenerator('userList.json');
//$serializer->WriteData();
$tmp = new DataLayer();
//echo 'DataLayer: ' . $tmp;
$connector = $tmp->GetConnector();
$user = $connector->getUser('test0', 'testpass0');
//echo ('User: '. $user. "\n");
<?php
// includes
require_once __DIR__ . DIRECTORY_SEPARATOR . 'includes' . DIRECTORY_SEPARATOR . 'classes' . DIRECTORY_SEPARATOR . 'datalayer.php';
// datalayer
$db = new DataLayer();
// to demonstrate the async aspect
sleep(1);
// get vars
$action = isset($_GET['action']) ? $_GET['action'] : '';
// all action; unused in this exercise but provided as sample action
// usage: call api.php?action=all
if ($action == 'all') {
// get contacts
$contacts = $db->getContacts();
// send to client
exit(json_encode(array('contacts' => $contacts, 'status' => 200, 'message' => 'delete OK')));
}
// delete action
if ($action == 'delete') {
// get id
$id = isset($_GET['id']) ? $_GET['id'] : '';
// contact does not exist
if (!$db->existsContact($id)) {
// give notice to client
http_response_code(404);
exit(json_encode(array('status' => 404, 'message' => 'delete failed: contact not found')));
}
// delete it
$db->deleteContact($id);
// give notice to client
