public static function setRolesFor($user_id, $roles) { Record::deleteWhere('UserRole', 'user_id = :user_id', array(':user_id' => (int) $user_id)); foreach ($roles as $role => $role_id) { Record::insert('UserRole', array('user_id' => (int) $user_id, 'role_id' => (int) $role_id)); } }
function redirector_log_404() { $redirect = Record::findAllFrom('Redirector404s', 'url = \'' . $_SERVER['REQUEST_URI'] . '\''); if (sizeof($redirect) > 0) { Record::update('Redirector404s', array('hits' => $redirect[0]->hits + 1), 'id = ' . $redirect[0]->id); } else { Record::insert('Redirector404s', array('url' => $_SERVER['REQUEST_URI'])); } }
require_once 'Request.php'; require_once 'Users.php'; if (check_cookie($_SERVER['PHP_SELF'], 1)) { if (!empty($_POST)) { if (!empty($_POST['aid'])) { $asn = new Assign(); $asn->id = $_POST['aid']; $asn->find(); $rec = new Record(); $rec->aid = $_POST['aid']; $rec->uid = $asn->rid; $rec->date = parse_date($_POST); $rec->hours = $_POST['hours']; $rec->materials = $_POST['materials']; $rec->cost = str_replace('$', '', $_POST['cost']); $rec->insert(); } else { if (!empty($_POST['id'])) { $rec = new Record(); $date = parse_date($_POST); $cost = str_replace('$', '', $_POST['cost']); $query = 'UPDATE record ' . "SET date='{$date}', " . "hours={$_POST['hours']}, " . "materials='{$_POST['materials']}', " . "cost={$cost} " . "WHERE id={$_POST['id']}"; $rec->query($query); } } } // Initialize values! $aid = isset($_GET['aid']) ? $_GET['aid'] : ''; $id = isset($_GET['id']) ? $_GET['id'] : ''; $requestor = ''; $requestor_phone = '';
/** * Videos */ public function video_create() { $record = Record::insert('ecommerce_product_video', $_POST['product_video']); echo Record::lastInsertId(); }