function callback_read($buffer, $base) { global $crlf; echo "read running...\n"; $data = ''; while ($read = $buffer->read(1024)) { $data .= $read; } list($cmd, $ret) = explode($crlf, $data); echo 'resp: ', var_export(json_decode($ret, true), true), PHP_EOL; switch ($cmd) { case 'c.ehlo': $req = 's.cmd' . $crlf; break; case 'c.ok.1': $req = 's.ls -al' . $crlf; break; case 'c.ok.2': $req = 's.end' . $crlf; break; case 'c.ok.3': free($buffer, $base); return; // break; } echo "req: " . trim($req), PHP_EOL, PHP_EOL; $buffer->write($req); }
function insert($quote, $user) { $conn = connect(); $query = "INSERT INTO quotes (data, user, score) VALUES ('{$quote}', '{$user}', 0)"; $result = query($query); free($result); close($conn); }
function callback_write($buffer, $base) { echo "write running...\n"; // 没有释放 EventBufferEvent 会产生 // Event::EOF 情况 free($buffer, $base); echo "close server.\n"; }
/** * Get a post saved in the database. * * @param integer $idPost * @return Post */ function getPost($idPost) { $sql = "SELECT * FROM post WHERE id_post = '" . $idPost . "'"; $res = query($sql); $row = mysqli_fetch_assoc($res); $post = array('id_post' => $row['id_post'], 'title' => $row["title"], 'headline' => $row['headline'], 'date' => $row['date'], 'body' => $row['body'], 'source' => $row["source"], 'post_image' => $row["post_image"], 'type_image' => $row["type_image"], 'category' => $row['category']); free($res); return $post; }
/** * Get a work image saved in the database. * * @param integer $idWorkImage * @return array */ function getWorkImage($idWorkImage) { $sql = "SELECT * FROM work_image WHERE id_work_image = '" . $idWorkImage . "'"; $res = query($sql); $row = mysqli_fetch_assoc($res); $workImage = array("id_work_image" => $row['id_work_image'], "id_work" => $row["id_work"], "work_image" => $row['work_image'], "type_image" => $row['type_image']); free($res); return $workImage; }
/** * Get all the providers categories saved in the database. * * @return array */ function getProviderCategoriesByFirstLetter($firstLetter) { $providerCategories = array(); $sql = "SELECT * FROM provider_category WHERE category_name LIKE '" . $firstLetter . "%' OR '" . strtoupper($firstLetter) . "%' ORDER BY category_name ASC"; $res = query($sql); while ($row = mysqli_fetch_assoc($res)) { $providerCategories[] = array('id_provider_category' => $row['id_provider_category'], 'category_name' => $row['category_name']); } free($res); return $providerCategories; }
function callback_read($buffer, $base) { echo "read running...\n"; $data = ''; while ($read = $buffer->read(1024)) { $data .= $read; } echo 'data: ', $data, PHP_EOL; // 没有释放 EventBufferEvent 会产生 // Event::EOF 情况 free($buffer, $base); }
/** * Confirms the existence of the client's password. * * @param string $user * @param string $password * @return integer */ function searchPassword($user, $password) { $sql = "SELECT * FROM client WHERE user = '******'"; $res = query($sql); $row = mysqli_fetch_assoc($res); /* If the user exists verify the password */ if (mysqli_num_rows($res)) { free($res); require_once "../ap-admin/extensions/mcrypt/MCrypt.php"; $mcrypt = new MCrypt(); if ($row["password"] === $mcrypt->encrypt($password)) { $res = 1; } else { $res = 0; } } else { $res = 0; } return $res; }
/** * Get the gallery linked to a Professional. * * @param integer $idProfessional * @return array */ function getProfessionalGallery($idProfessional) { $gallery = array(); $sql = "SELECT * FROM professional_image \n\t\tWHERE id_professional = '" . $idProfessional . "' \n\t\tORDER BY id_professional_image ASC"; $res = query($sql); while ($row = mysqli_fetch_assoc($res)) { $gallery[] = new ProfessionalImage($row['id_professional_image'], $row["id_professional"], $row['professional_image'], $row['type_image']); } free($res); return $gallery; }
function getNotes() { $notes = array(); $sql = "SELECT * FROM note ORDER BY id_note ASC"; $res = query($sql); while ($row = mysqli_fetch_assoc($res)) { $notes[] = new Note($row['id_note'], $row["note"], $row['note_text']); } free($res); return $notes; }
<head> <?php include "inc/head.inc"; ?> <title> RIT Quotes </title> </head> <body> <?php include "inc/navbar.inc"; include "inc/config.php"; $link = connect(); $query = "SELECT * FROM quotes ORDER BY id DESC"; $result = query($query); while ($line = fetch($result)) { echo "<div class=\"q-container\">\n"; echo "<table class=\"quote-title\">\n"; echo "<tr>\n"; echo "<td><a title=\"Direct Link\" href=\"/rit/quote.php?id=" . $line["id"] . "\">#" . $line["id"] . "</a></td>"; echo "<td id=\"score\" class=\"" . $line["score"] . "\"> score: " . $line["score"] . "</td>"; echo "<td><a title=\"vote up\" id=\"" . $line["id"] . "\" class=\"ui-icon ui-icon-plusthick\" >+</a></td>"; echo "<td id=\"uname\" ><b>user: </b>" . $line["user"] . "</td>\n"; echo "</tr>\n"; echo "</table>\n"; echo "<div id=\"quote\">\n"; echo $line["data"]; echo "</div>\n"; echo "</div>\n"; } free($result); close($link); include "inc/footer.inc";
function CheckPluginUpdate() { return; echo "<h3>", sprintf(_("Check for necessary %s updates"), _("plugin argument")), "</h3>\n"; $this->_configUpdates = array(); $this->_configUpdates[] = new UpgradePluginEntry($this, array('key' => 'plugin_randompage_numpages', 'fixed_with' => 1012.0, 'check_args' => array("plugin RandomPage pages", "/(<\\?\\s*plugin\\s+ RandomPage\\s+)pages/", "\\1numpages"))); $this->_configUpdates[] = new UpgradePluginEntry($this, array('key' => 'plugin_createtoc_position', 'fixed_with' => 1013.0, 'check_args' => array("plugin CreateToc align", "/(<\\?\\s*plugin\\s+ CreateToc[^\\?]+)align/", "\\1position"))); if (empty($this->_configUpdates)) { return; } foreach ($this->_configUpdates as $update) { $pages = $this->dbi->fullSearch($this->check_args[0]); while ($page = $allpages->next()) { $current = $page->getCurrentRevision(); $pagetext = $current->getPackedContent(); $update->check($this->check_args[1], $this->check_args[2], $pagetext, $page, $current); } } free($allpages); unset($pagetext); unset($current); unset($page); }
function writecb($buffer, $base) { echo "write running...\n"; free($buffer, $base); echo "close client.\n"; }
function getIndexes() { $indexes = array(); $sql = "SELECT * FROM cindex ORDER BY id_index DESC LIMIT 0,5"; $res = query($sql); while ($row = mysqli_fetch_assoc($res)) { $indexes[] = new Index($row['id_index'], $row["month"], $row['price'], $row['main_index'], $row['variation']); } free($res); return $indexes; }
/** * Get a sponsor image saved in the database. * * @param integer $idSponsorImage * @return SponsorImage */ function getSponsorImage($idSponsorImage) { $sponsorImage = array(); $sql = "SELECT * FROM sponsor_image WHERE id_sponsor_image = '" . $idSponsorImage . "'"; $res = query($sql); $row = mysqli_fetch_assoc($res); $sponsorImage = array("id_sponsor_image" => $row['id_sponsor_image'], "id_sponsor" => $row["id_sponsor"], "sponsor_image" => $row['sponsor_image'], "type_image" => $row['type_image']); free($res); return $sponsorImage; }
if ($ext = $result->fetch_assoc()) { if ($mysqli->query("UPDATE `extensions` SET `soldTimes`=" . $ext['soldTimes'] + 1 . " WHERE `id` = " . $payment['buyWhat'])) { $toRet = array('done' => true); } } } } } } } else { if ($_GET['free'] == 'true') { //free, user and ext //If extension was free user don't have to pay and Server will //set it as purchased. //If everything is OK, server will return done=>true if (free($_GET['ext'])) { if ($result = $mysqli->query("SELECT * FROM `userExtensions` WHERE `userId` = " . $user)) { $row = $result->fetch_assoc(); $array = unserialize($row['extensions']); array_push($array, $_GET['ext']); $array = serialize($array); $query = "UPDATE `userExtensions` SET `extensions` = '" . $array . "' WHERE `userId` = " . $user; if ($mysqli->query($query)) { if ($result = $mysqli->query("SELECT * FROM `extensions` WHERE `id` = " . $payment['buyWhat'])) { if ($ext = $result->fetch_assoc()) { if ($mysqli->query("UPDATE `extensions` SET `soldTimes`=" . $ext['soldTimes'] + 1 . " WHERE `id` = " . $payment['buyWhat'])) { $toRet = array('done' => true, 'toPay' => 0); } } } }
/** * Get a professional image saved in the database. * * @param integer $idProfessionalImage * @return ProfessionalImage */ function getProfessionalImage($idProfessionalImage) { $professionalImage = array(); $sql = "SELECT * FROM professional_image WHERE id_professional_image = '" . $idProfessionalImage . "'"; $res = query($sql); $row = mysqli_fetch_assoc($res); $professionalImage = array("id_professional_image" => $row['id_professional_image'], "id_professional" => $row["id_professional"], "professional_image" => $row['professional_image'], "type_image" => $row['type_image']); free($res); return $professionalImage; }