$lastInsertedObject = $dbOut->getLastInsertedId(); $resultUsername = $dbOut->buildQuery("SELECT Username FROM sellers WHERE Username=%s", $userSeller['username']); $usernameExist = $dbOut->getHasRows($resultUsername); if (!$usernameExist) { $dbOut->insert("sellers", $userSeller); } $newFormatCatObj = array("object_id" => $lastInsertedObject, "category_id" => $categoryIds[$objectArr['Categorie']]); $dbOut->insert("object_in_category", $newFormatCatObj); $result = $dbIn->buildQuery("SELECT * FROM Illustraties WHERE ItemID = %s", $objectArr['ID']); $getFiles = $dbIn->fetchAssoc($result); $newFormatPic = array("filename" => substr($getFiles['IllustratieFile'], 0, 37), "objectid" => $lastInsertedObject); if (!empty($newFormatPic['filename'])) { $dbOut->insert("files", $newFormatPic); } } $objectVar = getObjects(); echo "Inserting objects\r\n"; foreach ($objectVar as $object) { setObjects($object); } $objectsInsertTime = date('U') - ($beginTime + $categoryInsertTime + $secQuestionsInsertTime + $usersInsertTime); echo "Done inserting objects. (took " . $objectsInsertTime . " seconds)\r\n\r\n"; echo "Fetching minimal bids.\r\n"; function getMinimalBids() { //Create array with minimal bids $minimalBids = array(array("upper_limit" => 50, "raise" => 0.5), array("upper_limit" => 500, "raise" => 1), array("upper_limit" => 1000, "raise" => 5), array("upper_limit" => 5000, "raise" => 10), array("upper_limit" => 1000000, "raise" => 50)); return $minimalBids; } $minBidVar = getMinimalBids(); echo "Done fetching minimal bids.\r\n";
<?php session_start(); include_once "connect.php"; function getObjects() { $sql = mysql_query("SELECT id, name, parent_id FROM objects"); $res = array(); while ($row = mysql_fetch_array($sql)) { $res[$row["parent_id"]][] = $row; } return $res; } //В переменную $objects_arr записываем все объекты $objects_arr = getObjects(); function OutTree($parent_id, $lvl) { global $objects_arr; //Делаем переменную $objects_arr видимой в функции $exp = "expand"; $aj_func = "javascript:show_descr(this);"; //$edit = "<a class='edit'> if (isset($_SESSION['uid'])) { $show = ""; $exp = "collapse"; $aj_func = "javascript:edit_object(this);"; } elseif ($parent_id == 0) { $show = ""; } else { $show = " class=\"collapsed\""; }
public function getColumns() { $sql = <<<SQL SELECT f.attname AS name, f.attnotnull AS notnull, pg_catalog.format_type(f.atttypid,f.atttypmod) AS type, CASE WHEN p.contype = 'p' THEN 't' ELSE 'f' END AS primarykey, CASE WHEN p.contype = 'u' THEN 't' ELSE 'f' END AS uniquekey, CASE WHEN p.contype = 'f' THEN g.relname END AS foreignkey, CASE WHEN p.contype = 'f' THEN p.confkey END AS foreignkey_fieldnum, CASE WHEN p.contype = 'f' THEN g.relname END AS foreignkey, CASE WHEN p.contype = 'f' THEN p.conkey END AS foreignkey_connnum, CASE WHEN f.atthasdef = 't' THEN d.adsrc END AS default FROM pg_attribute f JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum LEFT JOIN pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey) LEFT JOIN pg_class AS g ON p.confrelid = g.oid WHERE c.relkind = 'r'::char AND n.nspname = 'public' AND c.relname = ? -- Replace with Schema name AND f.attnum > 0 ORDER BY f.attnum; SQL; return getObjects($sql, $this->name); }
function get_posts($token = null, $username = null, $olderThan = null) { global $error_message; $db = new Database(df_db()); $user = get_user(); if (!$user) { $error_message = "You are not logged in"; return false; } if (!$username) { $username = $user; } if (!$olderThan) { $olderThan = time(); } $out = getObjects("select post_id, username, date_posted, comment, photo from posts where username=:username and date_posted <= :older_than", array('username' => $username, 'older_than' => $olderThan)); foreach ($out as $r) { if ($o->photo) { $o->photo = get_post_photo_url($o); } } return $out; }