$items[] = $item["result"]; } echo implode(";", $items); }); $app->post('/genv/payhulu', function ($request, $response) { $uid = $_SESSION['uid']; $amount = $this->request->getParam("amount"); try { ORM::get_db()->setAttribute(PDO::ATTR_AUTOCOMMIT, 0); ORM::get_db()->beginTransaction(); //减去余额 $sql = vsprintf("UPDATE %s SET `balance` = balance-%d WHERE `uid` = %d and `balance`>=%d ", array(table("members_points"), $amount, $uid, $amount)); ORM::raw_execute($sql); //增加积分; $sql = vsprintf("UPDATE %s SET `points` = points+%d WHERE `uid` = %d ", array(table("members_points"), $amount, $uid)); ORM::raw_execute($sql); echo ORM::get_last_query(); // // Order::deduct_stock($order['coohua_id'], $order['product_id'], $order['order_code']); // ORM::raw_execute("UPDATE `order` SET `check` = 5 WHERE `order_code` = ? and `check`=4 ", array($order['order_code'])); ORM::get_db()->commit(); ORM::get_db()->setAttribute(PDO::ATTR_AUTOCOMMIT, 1); } catch (Exception $e) { //dump($e); ORM::get_db()->rollBack(); } }); function listDir($dir) { if (is_dir($dir)) { if ($dh = opendir($dir)) {
<?php if (isset($_GET["buy_tickets"]) && !empty($_GET["buy_tickets"])) { $travel_id = $_GET["TRAVEL_ID"]; ORM::raw_execute("UPDATE seats " . "SET status = :status_value " . "WHERE travel_id = :travel_id " . "AND updated_by = :user_id", array("status_value" => 'U', "travel_id" => $travel_id, "user_id" => 'user_id')); } ?> <script> function ajax_post(seat_number){ // Create our XMLHttpRequest object var hr = new XMLHttpRequest(); // Create some variables we need to send to our PHP file var url = "reserve_seat.php"; //var fn = document.getElementById("1_1").innerHTML; var fn = seat_number.innerHTML; var user = "******"; var travel_id = <?php echo $_GET["TRAVEL_ID"]; ?> ; var vars = "reserve_seat=true&seat_number="+fn+"&user_id="+user+"&travel_id="+travel_id+"&status_value=A"; //check if seat is not sold or reserved hr.open("POST", "reserve_seat.php", true); // Set content type header information for sending url encoded variables in the request hr.setRequestHeader("Content-type", "application/x-www-form-urlencoded"); // Access the onreadystatechange event for the XMLHttpRequest object hr.onreadystatechange = function() {
/** * @public */ static function prefs($prefs) { global $app; $req = $app->request(); if (!has_session()) { throw new AccessException(); } if ($req->isGet()) { return current_user()->getPrefs(true); } if ($req->isPost()) { // preferences are set by the client, so we allow pretty much // anything to be stored there - don't forget this! // it's really designed for storing flags, like whether or not // a particular screen or message has been seen before foreach ($prefs as $pname => $value) { $name = 'pref_' . trim($pname); if (strlen($name) > UserSetting::MAX_NAME_LENGTH) { throw new Exception("Preference name [{$pname}] is too long"); } if (!preg_match('/^[\\w_-]+$/', $name)) { throw new Exception("Invalid preference name [{$pname}] is too long"); } ORM::raw_execute("\n INSERT INTO user_setting (\n `user_id`,\n `name`,\n `value`\n ) VALUES (\n ?, ?, ?\n ) ON DUPLICATE KEY UPDATE\n `user_id` = VALUES(`user_id`),\n `name` = VALUES(`name`),\n `value` = VALUES(`value`) \n ", array(current_user()->id, $name, maybe_serialize($value))); } } if ($req->isDelete()) { foreach ($prefs as $pname => $value) { $name = 'pref_' . trim($pname); ORM::raw_execute("\n DELETE FROM user_setting \n WHERE\n `user_id` = ?\n AND `name` = ?\n LIMIT 1\n ", array(current_user()->id, $name)); } } }
function update_resume_num($id) { $count = resume_log_num($id); \ORM::raw_execute(vsprintf("update %s set num=%d where id=%d", array(table("resume_temp"), $count, $id))); if ($count >= 3) { update_resume_status($id); //如果有三条都通过的记录,直接导入简历; $rs = \ORM::for_table(table("resume_check_log"))->where("rid", $id)->where("pass", 1)->find_array(); if ($rs && count($rs) >= 3) { import_resume_temp($id); } } }
public function raw_execute($query, $parameters = array()) { return \ORM::raw_execute($query, $parameters = array(), $this->connectionName); }
<?php require 'setup.php'; date_default_timezone_set('America/Mexico_City'); if (isset($_POST["reserve_seat"]) && !empty($_POST["reserve_seat"])) { $travel_id = $_POST["travel_id"]; $seat_number = $_POST["seat_number"]; $status_value = $_POST['status_value']; $user_id = $_POST['user_id']; $check = ORM::for_table('seats')->select('seats.status')->where(array('travel_id' => $travel_id, 'seat_number' => $seat_number))->find_one(); $status = $check->status; $user_check = ORM::for_table('seats')->select('seats.updated_by')->where(array('travel_id' => $travel_id, 'seat_number' => $seat_number))->find_one(); $user = $user_check->updated_by; if ($status === '0') { ORM::raw_execute("UPDATE seats " . "SET status = :status_value " . ",updated_by = :updated_by " . "WHERE travel_id = :travel_id " . "AND seat_number = :seat_number ", array("status_value" => $status_value, "updated_by" => $user_id, "travel_id" => $travel_id, "seat_number" => $seat_number)); header("Content-type: text/xml"); echo '<this><is><color>#FFFF00</color></is></this>'; } if ($status === 'A' && $user === $user_id) { ORM::raw_execute("UPDATE seats " . "SET status = :status_value " . ", updated_by= :updated_by " . "WHERE travel_id = :travel_id " . "AND seat_number = :seat_number ", array("status_value" => '0', "updated_by" => '', "travel_id" => $travel_id, "seat_number" => $seat_number)); header("Content-type: text/xml"); echo '<this><is><color>#006600</color></is></this>'; } /* else { echo 'Alguien mas acaba de apartar este asiento'; } */ }
$ins = ORM::raw_execute("INSERT INTO `modules` VALUES (1, 'tv_shows', 'TV shows', 1)"); $ins = ORM::raw_execute("INSERT INTO `modules` VALUES (2, 'movies', 'Movies', 1)"); $ins = ORM::raw_execute("INSERT INTO `modules` VALUES (7, 'submit_links', 'Submit links', 1)"); $ins = ORM::raw_execute("INSERT INTO `modules` VALUES (6, 'requests', 'Requests', 1)"); print "<span style='color:#00aa00'>Success</span><br />"; ?> Adding default settings... <?php $ins = ORM::raw_execute("INSERT INTO `settings` VALUES (1, 'default_language', 'en')"); $ins = ORM::raw_execute("INSERT INTO `settings` VALUES (2, 'maxtvperpage', '50')"); $ins = ORM::raw_execute("INSERT INTO `settings` VALUES (3, 'maxmoviesperpage', '50')"); $ins = ORM::raw_execute("INSERT INTO `settings` VALUES (4, 'countdown_free', '30')"); $ins = ORM::raw_execute("INSERT INTO `settings` VALUES (5, 'countdown_user', '0')"); $ins = ORM::raw_execute("INSERT INTO `settings` VALUES (6, 'seo_links', '1')"); $ins = ORM::raw_execute("INSERT INTO `settings` VALUES (7, 'smart_bar', '0')"); print "<span style='color:#00aa00'>Success</span><br />"; ?> Changing Admin Panel Name... <?php rename(realpath(dirname(__FILE__)) . '/../control', realpath(dirname(__FILE__)) . '/../' . $_SESSION['admin_folder']); print "<span style='color:#00aa00'>Success</span><br />"; ?> Congratulation. Your site is all set up<br /><br /> Next steps:<br /><br /> <ul> <li><a href="<?php print $_SESSION['site_url'];
// to let static ember help pages work even if unconfigured date_default_timezone_set(defined('AMTC_TZ') ? AMTC_TZ : 'Europe/Berlin'); set_include_path(get_include_path() . PATH_SEPARATOR . AMTC_WEBROOT . '/lib' . PATH_SEPARATOR . AMTC_WEBROOT . '/lib/db-model'); spl_autoload_extensions('.php'); spl_autoload_register(); require 'idiorm.php'; require 'paris.php'; require 'Slim/Slim.php'; // Initialize http://j4mie.github.io/idiormandparis/ if (defined("AMTC_PDOSTRING")) { ORM::configure(AMTC_PDOSTRING); ORM::configure('username', AMTC_DBUSER); ORM::configure('password', AMTC_DBPASS); // small hack to enforce constraint checking for sqlite; requires 3.6+ if (substr(AMTC_PDOSTRING, 0, 6) == 'sqlite') { ORM::raw_execute('PRAGMA foreign_keys = ON'); } } // Initialize http://www.slimframework.com/ \Slim\Slim::registerAutoloader(); $app = new \Slim\Slim(); $app->config('debug', false); // false enables custom error handler below $app->response()->header('Content-Type', 'application/json;charset=utf-8'); $app->notFound(function () { echo json_encode(array('error' => 'Not found')); }); $app->error(function (\Exception $e) { echo strlen($e->getMessage()) > 128 ? substr($e->getMessage(), 0, 128) . '...' : $e->getMessage(); }); class SlimUtil