public function save() { $keys = $this->index(); Database::insert($this->tableName(), $this->_data, true); $t = Database::lastID(); $this->{$keys[0]} = $t; return true; }
if (isset($_POST["titlechange"]) && $isadmin == 1) { $tickid = $mydb->clean($_POST["tickid"], '', ''); $mydb->query_update("list", array('title' => $_POST["titlechange"]), "id='{$tickid}'"); echo "Title changed."; } if (isset($_POST["closeticket"]) && $isadmin == 1) { $closeticket = $mydb->clean($_POST["tickid"], '', ''); $mydb->query_update('list', array('status' => 0, 'finished' => time()), "id='{$closeticket}'"); echo "Ok"; } if (isset($_POST["openticket"]) && $isadmin == 1) { $closeticket = $mydb->clean($_POST["tickid"], '', ''); $mydb->query_update('list', array('status' => 1, 'finished' => '0'), "id='{$closeticket}'"); echo "Ok"; } if (isset($_POST["changepri"]) && $isadmin == 1) { $changepri = $mydb->clean($_POST["changepri"], '', ''); $id = $mydb->clean($_POST["id"], '', ''); $mydb->query_update('list', array('priority' => $changepri), "id='{$id}'"); //print_r($_POST); } // adds to do items if (isset($_POST["addtodo"])) { $id = $mydb->clean($_POST["id"], '', ''); $mydb->query_insert('todo_list', array('id' => 'null', 'tid' => $_POST['id'], 'content' => $_POST['item'], 'status' => 0)); echo $mydb->lastID(); } if (isset($_POST["markfinish"])) { $mydb->query_update('todo_list', array('status' => 1), "id='" . $mydb->clean($_POST["id"], '', '') . "'"); } //print_r($_POST);
echo "{$errstr} ({$errno})<br />\n"; } else { $out = "GET /api/v1/xml/" . $user_proj . "/commits/master HTTP/1.1\r\n"; $out .= "Host: google.com \r\n"; $out .= "Connection: Close\r\n\r\n"; fwrite($fp, $out); while (!feof($fp)) { $results .= fgets($fp, 128); } fclose($fp); } $post_results = parseHttpResponse($results); $objXML = new xml2Array(); $arrOutput = $objXML->parse($post_results); $github_result = $arrOutput[0]['children']; for ($i = 0; $i < count($github_result); $i++) { $commit_id = $github_result[$i]['children'][4]['tagData']; $message = $github_result[$i]['children'][0]['tagData']; $date = str_replace('T', ' T ', $github_result[$i]['children'][5]['tagData']); $commiter = $github_result[$i]['children'][3]['children'][0]['tagData'] . "/" . $github_result[$i]['children'][3]['children'][1]['tagData']; $unix_stamp = strtotime($date); echo "{$message} [{$commit_id}] was commited by {$commiter} on " . $unix_stamp . " \n"; if (strlen($mydb->first("SELECT `sum` FROM commits WHERE `sum`='{$commit_id}'")) == 0) { $ar = array('id' => null, 'user' => $commiter, 'message' => $message, 'sum' => $commit_id, 'project' => $r['id']); $mydb->query_insert('commits', $ar); $LASTID = $mydb->lastID(); $s->n($LASTID, '', 'git', $r['id'], $unix_stamp); } //echo "<a href='#' onclick=\"insertAtCursor(document.reply.report, '[GIT]".$commit_id."[/GIT]');\" title=\".". $date . "\">" .$message . "</a><small>[" . $commit_id . "]</small>"; } }
$gui = new AdminGui($db); $works_records = $gui->select('works'); $media_records = $gui->joinThree('works', 'media_for_works', 'media', 'media_title', 'work_id', 'media_id'); $categories_records = $gui->joinThree('works', 'categories_for_works', 'categories', 'category', 'work_id', 'category_id'); $techniques_records = $gui->joinThree('works', 'techniques_for_works', 'techniques', 'technique', 'work_id', 'technique_id'); $technologies_records = $gui->joinThree('works', 'technologies_for_works', 'technologies', 'technology', 'work_id', 'technology_id'); if (!empty($_POST)) { $post_works = array_slice($_POST, 0, 2); $db->table('works'); $validator = new Validator($db, $errorHandler); $validation = $validator->check($post_works, ['work_title' => ['required' => true], 'work_description' => ['required' => false]]); if ($validation->fails()) { echo '<pre>', print_r($validation->errors()->all()), '</pre>'; } else { if ($db->insert($post_works)) { $last_id = $db->lastID(); if ($_POST['media']) { $post_media = $_POST['media']; for ($m = 0; $m < count($post_media); $m++) { $insert_media = ['media_id' => $post_media[$m], 'work_id' => $last_id]; $db->table('media_for_works')->insert($insert_media); } } if ($_POST['category']) { $post_category = $_POST['category']; for ($n = 0; $n < count($post_category); $n++) { $insert_category = ['category_id' => $post_category[$n], 'work_id' => $last_id]; $db->table('categories_for_works')->insert($insert_category); } } if ($_POST['technique']) {
public static function query($query, $inputArray) { // Run the query $result = self::$database->prepare($query); if (!$result->execute($inputArray)) { return false; } // Get Last ID that was inserted into the database (if applicable) self::$lastID = (int) self::$database->lastInsertId(); // Retrieve the number of rows that were affected self::$rowsAffected = (int) $result->rowCount(); return true; }