<?php
//------------------------------------------------------------------------------/
// CREATE TODAY'S EVENTS
//------------------------------------------------------------------------------/
/**
* Launch this script to clear and refresh today's event.
*/
use QuickPdo\QuickPdo;
require_once __DIR__ . "/../init.php";
//------------------------------------------------------------------------------/
// SCRIPT
//------------------------------------------------------------------------------/
$lorem = "Lorem ipsum dolor sit amet, id nam munere fabulas. Ei soluta scribentur signiferumque mel. Ea vel prima albucius deleniti, te semper principes pro, cu duis illud nobis cum. Sensibus tincidunt ne duo. Vel ut porro essent.";
$day = date('Y-m-d ');
$events = [['title' => 'event 1', 'description' => $lorem, 'start_date' => $day . '10:00:00', 'end_date' => $day . '10:35:00'], ['title' => 'event 2', 'description' => $lorem, 'start_date' => $day . '10:05:36', 'end_date' => $day . '10:05:56'], ['title' => 'event 3', 'description' => $lorem, 'start_date' => $day . '11:02:00', 'end_date' => $day . '11:12:30'], ['title' => 'event 4', 'description' => $lorem, 'start_date' => $day . '13:15:00', 'end_date' => $day . '15:15:00']];
a("clear the the_events table");
a(QuickPdo::delete('the_events'));
a("inserting events");
foreach ($events as $event) {
a(QuickPdo::insert('the_events', $event));
}
<?php
//------------------------------------------------------------------------------/
// INSERT EVENT
//------------------------------------------------------------------------------/
/**
* Tim service, it's a tim success if the insert is done,
* and a tim failure otherwise.
*/
use QuickPdo\QuickPdo;
use Tim\TimServer\TimServer;
use Tim\TimServer\TimServerInterface;
require_once __DIR__ . "/../../init.php";
TimServer::create()->start(function (TimServerInterface $server) {
if (isset($_POST['title']) && isset($_POST['description']) && isset($_POST['start_date']) && isset($_POST['end_date'])) {
if (false !== ($id = QuickPdo::insert('the_events', ['title' => $_POST['title'], 'description' => $_POST['description'], 'start_date' => $_POST['start_date'], 'end_date' => $_POST['end_date']]))) {
$server->success($id);
} else {
appLog("[app]/www/service/insert-event: pdo error: {pdoError}", ['pdoError' => QuickPdo::getLastError()]);
$server->error('An error occurred with the database, please retry later.');
}
}
})->output();
if (true === QuickPdo::update($table, $nac2Values, $where)) {
$msg = $mc->getFormDataProcessor()->getSuccessMessage($formId, 'update');
if (false === $msg) {
$msg = MeredithSupervisor::inst()->translate("The record has been successfully updated");
}
$server->success(['msg' => $msg]);
} else {
$server->error(MeredithSupervisor::inst()->translate("An error occurred with the database, please retry later"));
}
} else {
throw new MeredithException("Permission not granted to update with {$formId}");
}
} else {
// insert
if (true === MeredithSupervisor::inst()->isGranted($formId, 'insert')) {
if (false !== ($id = QuickPdo::insert($table, $nac2Values))) {
$msg = $mc->getFormDataProcessor()->getSuccessMessage($formId, 'insert');
if (false === $msg) {
$msg = MeredithSupervisor::inst()->translate("The record has been successfully recorded");
}
$server->success(['msg' => $msg]);
} else {
$server->error(MeredithSupervisor::inst()->translate("An error occurred with the database, please retry later"));
}
} else {
throw new MeredithException("Permission not granted to insert with {$formId}");
}
}
} catch (\PDOException $e) {
if ('23000' === $e->getCode()) {
// integrity constraint violation
