function draw_svg($pie_id, $base_name, $args) { global $output_dir; global $svg_template; global $bg_schemes; $bar_start = 48; $bar_end = 312.4; $bar_len = $bar_end - $bar_start; $svg_output = $output_dir . $base_name . '.svg'; if (file_exists($svg_output)) { return $svg_output; } // Parse $xdoc = new DomDocument(); $xdoc->Load($svg_template); $xp = new DomXPath($xdoc); // Get progress from DB $result = pg_query("SELECT state FROM pieces WHERE pie = " . $pie_id); $states = pg_fetch_all_columns($result, 0); $progress = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0); $full_sum = 9 * count($states); $current_sum = 0; foreach ($states as $st) { $progress[$st]++; $current_sum += $st; } // Calculate bars positions and widths $offset = $bar_start; $step = $bar_len / count($states); for ($i = 0; $i <= 9; $i++) { $elem = find_by_id($xp, 'bar_' . $i); $elem->setAttribute('x', $offset); $elem->setAttribute('width', $step * $progress[$i]); $offset += $step * $progress[$i]; } // Set percent $percent = round($current_sum / $full_sum * 100); find_by_id($xp, 'percent-fg')->nodeValue = $percent . '%'; // Set BG color gradient; $current_bg_scheme = $bg_schemes['middle']; if ($progress[9] / count($states) > 0.6) { $current_bg_scheme = $bg_schemes['high']; } else { if ($progress[0] / count($states) > 0.6) { $current_bg_scheme = $bg_schemes['low']; } } find_by_id($xp, 'bg-grd-start')->setAttribute('style', 'stop-color:#' . $current_bg_scheme[0] . ';stop-opacity:1'); find_by_id($xp, 'bg-grd-stop')->setAttribute('style', 'stop-color:#' . $current_bg_scheme[1] . ';stop-opacity:1'); // Save it to file if (($fd = fopen($svg_output, 'w')) === false) { throw new Exception("Cant open SVG file for saving"); } fwrite($fd, $xdoc->saveXML()); fclose($fd); return $svg_output; }
function manyToOneQuery($ar) { $z = extract($ar); //$act=($this->useWiki) ? ' WHERE active>0 ' : ''; $SQL = "SELECT DISTINCT {$many} FROM " . $this->tabl; $rZ = $this->xQuery($SQL, 0); $aList = compileList(',', pg_fetch_all_columns($rZ)); pg_free_result($rZ); $act = $useWiki ? 'WHERE active>0 AND ' : 'WHERE '; $SQL = "SELECT DISTINCT {$key},{$var} FROM {$tabl} {$act} " . "{$key} IN (" . implode(',', $aList) . ")"; return $SQL; }
function _update_users_claims($res, $from, $to_all) { global $connection; $user_list = array('user_list', array()); $claim_list = array('claim_list', array()); // Buffer array $users = array(); $result = pg_query($connection, 'SELECT pieces.id, pieces.index, users.nick, users.color FROM pieces JOIN users ON users.id = pieces.owner WHERE pie = ' . $from->pieid . ' ORDER BY pieces.index'); $piece_ids = pg_fetch_all_columns($result, 0); // Users who has pieces while ($row = pg_fetch_assoc($result)) { if (isset($users[$row['nick']])) { $users[$row['nick']]['owns'][] = $row['index']; } else { $users[$row['nick']] = array('owns' => array($row['index']), 'color' => array($row['color']), 'online' => false); } } if (count($piece_ids) != 0) { $result = pg_query($connection, 'SELECT claims.id, users.nick, users.color, pieces.index, score FROM claims JOIN pieces on claims.piece = pieces.id JOIN users ON users.id = claims.author WHERE piece IN (' . implode(',', $piece_ids) . ')'); while ($row = pg_fetch_assoc($result)) { $claim_list[1][] = array('claim_id' => $row['id'], 'piece_index' => $row['index'], 'vote_balance' => $row['score'], 'owner' => $row['nick']); // Users who has claims if (!isset($users[$row['nick']])) { $users[$row['nick']] = array('owns' => array(), 'color' => array($row['color']), 'online' => false); } } } // Adding all online users: chat_members JOIN users $result = pg_query($connection, 'SELECT users.id, users.nick, users.color FROM chat_members LEFT JOIN users ON users.id = member WHERE pie = ' . $from->pieid); while ($row = pg_fetch_assoc($result)) { // If new user -> set it fully if (!isset($users[$row['nick']])) { $users[$row['nick']] = array('owns' => array(), 'color' => array($row['color'])); } $users[$row['nick']]['online'] = true; } // Generating user_list from userbuffer array foreach ($users as $user_nick => $attrs) { $user_list[1][] = array('user_nick' => $user_nick, 'color' => $attrs['color'], 'reserved' => $attrs['owns'], 'online' => $attrs['online']); } if ($to_all) { $res->to_pie($from, $user_list); $res->to_pie($from, $claim_list); } else { $res->to_sender($user_list); $res->to_sender($claim_list); } }
public function as_array($key = NULL, $value = NULL) { if ($this->_total_rows === 0) { return array(); } if (!$this->_as_object and $key === NULL) { // Rewind $this->_current_row = 0; if ($value === NULL) { // Indexed rows return pg_fetch_all($this->_result); } // Indexed columns return pg_fetch_all_columns($this->_result, pg_field_num($this->_result, $value)); } return parent::as_array($key, $value); }
function ChangeBuckets() { global $SysConf; global $PG_CONN; $uploadId = GetParm("upload", PARM_STRING); $uploadTreeId = GetParm("item", PARM_STRING); $sql = "SELECT bucketpool_fk from bucket_ars where upload_fk = {$uploadId};"; $result = pg_query($PG_CONN, $sql); DBCheckResult($result, $sql, __FILE__, __LINE__); $bucketpool_array = pg_fetch_all_columns($result, 0); pg_free_result($result); $buckets_dir = $SysConf['DIRECTORIES']['MODDIR']; /** rerun bucket on the file */ foreach ($bucketpool_array as $bucketpool) { $command = "{$buckets_dir}/buckets/agent/buckets -r -t {$uploadTreeId} -p {$bucketpool}"; exec($command); } }
public function selectCol($query) { $result = call_user_func_array([$this, 'query'], func_get_args()); return pg_fetch_all_columns($result, 0); }
/** * fetchColumn * * Fetch a column from a result. * * @access public * @param string $name * @return array */ public function fetchColumn($name) { return pg_fetch_all_columns($this->handler, $this->getFieldNumber($name)); }
/** * \brief Gets the list of jobqueue records with the requested $status * * \param string $status - the status might be: * Started, Completed, Restart, Failed, Paused, etc * the status 'Started' and 'Restart', you can call them as running status * to get all the running job list, you can set the $status as 'tart' * * \return job list related to the jobstatus, * the result is like: Array(1, 2, 3, .., i), sorted **/ function GetJobList($status) { /* Gets the list of jobqueue records with the requested $status */ global $PG_CONN; if (empty($status)) { return; } $sql = "SELECT jq_pk FROM jobqueue WHERE jq_endtext like '%{$status}%' order by jq_pk;"; $result = pg_query($PG_CONN, $sql); DBCheckResult($result, $sql, __FILE__, __LINE__); $job_array = pg_fetch_all_columns($result, 0); pg_free_result($result); return $job_array; }
function getDBColumn_SQL($SQL) { $r = newQuery($SQL, 0); $ar = pg_fetch_all_columns($r, 0); pg_free_result($r); return $ar; }
</table> <br /> <?php //run query if (isset($_REQUEST["SearchBtn"])) { $ret = pg_exec($db_handle, $new_str); if (!$ret) { echo "<br />Query Failed!\n"; var_dump($ret); } else { //print out table containing the query $record_found = pg_numrows($ret); echo "<p>{$record_found} records found!</p>"; $q_array = pg_fetch_all_columns($ret, 3); $region_array = pg_fetch_all_columns($ret, 1); $id_array = pg_fetch_all_columns($ret, 0); echo "<table border=1 bgcolor='white' cellspacing=7 cellpadding=2>"; echo "<tr><th>\"State\"</th><th>\"Region\"</th><th>\"Link\"</th></tr>"; for ($i = 0; $i < count($q_array); $i++) { if (strlen($q_array[$i]) == 0) { $str_out = "UNKNOWN"; } else { $str_out = $q_array[$i]; } echo "<tr><td>{$str_out}</td>"; if (strlen($region_array[$i]) == 0) { $str_out2 = "UNKNOWN"; } else { $str_out2 = $region_array[$i]; } echo "<td>{$str_out2}</td>";
function _update_user_reserved($res, $from, $user_id, $nick) { global $connection; $result = pg_query($connection, 'SELECT index FROM pieces WHERE owner = ' . $user_id . ' and pie = ' . $from->pieid . ' ORDER BY index'); $piece_indexes = pg_fetch_all_columns($result, 0); if ($piece_indexes === false) { $piece_indexes = array(); } $res->to_pie($from, array('user_update', array('current_nick' => $nick, 'reserved' => $piece_indexes))); }
/** * Selects records and return values (first field) as an array using a SQL statement. * * @param string $sql The SQL query * @param array $params array of sql parameters * @return array of values * @throws dml_exception A DML specific exception is thrown for any errors. */ public function get_fieldset_sql($sql, array $params = null) { list($sql, $params, $type) = $this->fix_sql_params($sql, $params); $this->query_start($sql, $params, SQL_QUERY_SELECT); $result = pg_query_params($this->pgsql, $sql, $params); $this->query_end($result); $return = pg_fetch_all_columns($result, 0); pg_free_result($result); return $return; }
function display_menubar() { if (!isset($_SESSION['athlete_id'])) { echo <<<ENDHTML \t<H2>Your session has expired</H2> \t<FONT size=1>Please <a href=index.php >return to the <u>login page</u> and log in again.<a></FONT><br> ENDHTML; exit; } $login = $_SESSION['login']; $athlete_id = $_SESSION['athlete_id']; require_once "access_check.php"; $filename = basename(__FILE__); #access_check( $filename ) ; // Connect to DB include_once "sql_functions.php"; #$dbconn = pg_connect("host=localhost dbname=training_diary user=athlete password=ironman") # or die('Could not connect: ' . pg_last_error()); $query = "SELECT name from athlete WHERE athlete_id = {$athlete_id}"; #$result = pg_query($query) or die('Query failed: ' . pg_last_error()); $result = do_sql($query); $row = pg_fetch_array($result, null, PGSQL_ASSOC); $firstname = $row['name']; $query = "SELECT function FROM user_access WHERE athlete_id = '{$athlete_id}'"; $result = do_sql($query) or die('Query failed: ' . pg_last_error()); $allowed = pg_fetch_all_columns($result, 0); echo <<<HTMLEND <TABLE> <TR><TD align=right class=fitnessmad > <b><font size=3 color=#885555 > <i> FitnessMad.Net </i> </FONT><br/> <font color=#AA5555 > Training Log </FONT> </b> </TD><TD class=mainmenu align=right valign=bottom > You are logged in {$firstname}<br> </TD> </TR> </TABLE> <HR> HTMLEND; echo <<<ENDHTML <TABLE><TR><TD> <UL class="nav"> ENDHTML; // Assume we want to jump to today's date, won't do anything if // this is not in the date range selected. $jumpto = "anchorD" . date("Ymd"); // View My Log if (in_array("view_log.php", $allowed)) { echo <<<HTMLEND <LI class=menuheader ><a href="view_log.php#{$jumpto}"> View My Log</a> </LI> HTMLEND; } // Add Log Entry $date = date("d/m/Y"); if (in_array("add_log_entry.php", $allowed)) { echo <<<HTMLEND <LI class=menuheader > <!-- <a href="javascript:launchRemote('add_log_entry.php#{$jumpto}')" > --> <a href="javascript:launchRemote('add_log_entry.php?start_date={$date}')" > Add Log entry</a> </LI> HTMLEND; } // Start dropdown menu for Configuration options echo <<<CONFIGMENU <li class=menuheader ><a >Configuration</a> <ul> CONFIGMENU; if (in_array("configure_view.php", $allowed)) { echo <<<CONFIGMENU \t<li><a href="configure_view.php"> \t\tConfigure View</a></li> CONFIGMENU; } if (in_array("configure_log_entry.php", $allowed)) { echo <<<CONFIGMENU \t<li><a href="configure_log_entry.php"> \t\tConfigure Log Entry Fields</a></li> CONFIGMENU; } if (in_array("configure_exercise_types.php", $allowed)) { echo <<<CONFIGMENU \t<li><a href="configure_exercise_types.php"> \t\tConfigure Exercise Types</a></li> \t</ul> \t</li> CONFIGMENU; } //User admin Menu echo <<<USERMENU <li class=menuheader ><a>User</a> <ul> USERMENU; if (in_array("change_password.php", $allowed)) { echo <<<HTMLEND \t<LI><a href="change_password.php" >Change Password</a> \t</LI> HTMLEND; } if (in_array("newuser.php", $allowed)) { echo <<<HTMLEND \t<LI><a href="newuser.php" > Add New User</a> \t</LI> HTMLEND; } if (in_array("configure_share_permissions.php", $allowed)) { echo <<<HTMLEND \t<LI><a href="configure_share_permissions.php" > \tConfigure Shared Access</a> \t</LI> HTMLEND; } if (in_array("configure_security_access.php", $allowed)) { echo <<<HTMLEND \t<LI><a href="configure_security_access.php" > Configure User Access</a> \t</LI> HTMLEND; } if (in_array("access_other_user.php", $allowed)) { echo <<<HTMLEND \t<LI><a href="access_other_user.php"> View Other Athlete's Log</a> \t</LI> HTMLEND; } if (in_array("see_who_is_online.php", $allowed)) { echo <<<HTMLEND \t<LI><a href="see_who_is_online.php"> Currently Connected Users</a> \t</LI> HTMLEND; } if (in_array("view_login_log.php", $allowed)) { echo <<<HTMLEND \t<LI><a href="view_login_log.php"> View log of recent logins</a> \t</LI> HTMLEND; } if (in_array("logout.php", $allowed)) { echo <<<HTMLEND \t<LI><a href="logout.php" > Logout</a> \t</LI> HTMLEND; } echo <<<ENDUSER </UL> </LI> ENDUSER; if (in_array("logout.php", $allowed)) { echo <<<HTMLEND \t<LI class=menuheader ><a href="logout.php"> \tLogout</a> \t</LI> HTMLEND; } echo <<<HTMLEND \t<LI class=menuheader ><a href="loggedin.php" > \tHelp</a> \t</LI> HTMLEND; echo <<<HTMLEND </LI> </UL> </TD></TR></TABLE> HTMLEND; //END of function display_menubar }
function is_authentified() { global $DB; $res = $DB->tab_result("SELECT * FROM admin_svg.utilisateur WHERE login = '******' AND psw = '" . $this->pass . "';"); if (count($res) == 0) { return 0; } else { $this->insee = $res[0]['idcommune']; $res2 = $DB->tab_result("SELECT idagglo FROM admin_svg.commune WHERE idcommune = '" . $res[0]['idcommune'] . "';"); $this->idagglo = $res2[0]['idagglo']; $this->idutilisateur = $res[0]['idutilisateur']; $this->droit = $res[0]['droit']; $this->droit_appli = ""; $this->acces_ssl = true; $res1 = pg_query($DB->con, "select application.libelle_appli from admin_svg.application inner join admin_svg.apputi on admin_svg.application.idapplication=admin_svg.apputi.idapplication join admin_svg.utilisateur on admin_svg.apputi.idutilisateur=admin_svg.utilisateur.idutilisateur where apputi.idutilisateur='" . $res[0]['idutilisateur'] . "' order by application.type_appli asc;"); $this->liste_appli = pg_fetch_all_columns($res1, 0); $this->roles[] = 2; if ($res[0]['droit'] == 'AD') { // FIXME: affiner la gestion des droits $this->roles[] = 1; } return 1; } }
function getRowList() { if ($this->useWiki) { $useAct = ' WHERE active>0 '; } else { $useAct = ''; } $wh = $this->sqlSubset(); if ($wh and !$useAct) { $useAct = ' WHERE '; } elseif ($wh) { $useAct .= ' AND '; } else { $nought = 0; } if ($wh) { $useAct .= $wh; } $r = $this->xQuery("SELECT " . $this->indx . "," . $this->getDisplayText() . " FROM " . $this->tabl . " {$useAct} ORDER BY " . $this->getDisplayText() . ";", 1); $ids = pg_fetch_all_columns($r, 0); $names = pg_fetch_all_columns($r, 1); pg_free_result($r); return array_combine($ids, $names); }
/** * Выбрать колонку из БД. * * @return unknown */ public function fetchColumn() { $this->select_prepare(); $result = pg_query($this->connection, $this->query); if (!$result) { trigger_error('Select error: ' . pg_last_error($this->connection), E_USER_ERROR); } return pg_fetch_all_columns($result); }
function sql_assoc($query, $back) { global $db; if (DEBUG) { echo "<br>{$query}"; } $result = pg_query($db, $query) or die("Erreur pgSQL : " . $query); unset($query); if ($back) { for ($i = 0; $i < pg_num_fields($result); $i++) { $colname = pg_field_name($result, $i); $ligne[$colname] = pg_fetch_all_columns($result, $i); } } else { $ligne = array(); } pg_free_result($result); return $ligne; }
$app->get('/delete/', function () use($app) { $_con = getDBConnection(); $sqlresult = pg_query($_con, 'DELETE FROM tones'); pg_close($_con); return $app['twig']->render('echo_tone.twig', array('tone' => 'all tone deleted')); }); //get tone list $app->get('/get/tonelist/', function () use($app) { $result; $_con = getDBConnection(); $sqlresult = pg_query($_con, 'SELECT id,tone FROM tones ORDER BY created desc'); if (!$sqlresult) { echo "An error occurred.\n"; exit; } $arr = pg_fetch_all_columns($sqlresult, 1); pg_close($_con); return $app['twig']->render('echo_tone.twig', array('tone' => implode(',', $arr))); }); //get tone list as json $app->get('/get/tonelist/json/', function () use($app) { $result; $_con = getDBConnection(); $sqlresult = pg_query($_con, 'SELECT id,tone FROM tones ORDER BY created desc'); //$sqlresult = pg_query($_con, "SELECT array_to_json( array_agg(tones)) FROM tones"); if (!$sqlresult) { echo "An error occurred.\n"; exit; } $arr = pg_fetch_all($sqlresult); pg_close($_con);
public function FetchAll(int $column = NULL) { return is_null($column) ? pg_fetch_all($this->ds) : pg_fetch_all_columns($this->ds, $column); }
/** * query and fetch all rows at once * * @param string $sql * @return array */ public static function fetchfieldarray($sql) { $result = self::query($sql); $fieldarray = pg_fetch_all_columns($result); pg_free_result($result); return $fieldarray; }
/** * Selects records and return values (first field) as an array using a SQL statement. * * @param string $sql The SQL query * @param array $params array of sql parameters * @return array of values * @throws dml_exception A DML specific exception is thrown for any errors. */ public function get_fieldset_sql($sql, array $params = null) { list($sql, $params, $type) = $this->fix_sql_params($sql, $params); $this->query_start($sql, $params, SQL_QUERY_SELECT); $result = pg_query_params($this->pgsql, $sql, $params); $this->query_end($result); $return = pg_fetch_all_columns($result, 0); if (pg_field_type($result, 0) == 'bytea') { foreach ($return as $key => $value) { $return[$key] = $value === null ? $value : pg_unescape_bytea($value); } } pg_free_result($result); return $return; }
<?php header("Access-Control-Allow-Origin: *"); $dbconn = pg_connect("host=localhost dbname=01_20 port=5432 user=postgres password=admin ") or die('Could not connect: ' . pg_last_error()); if ($stat == PGSQL_CONNECTION_OK) { // echo 'jobb egy lud nyak ket tyuk nyaknal'; } else { echo 'Connection status bad'; } $query = "SELECT r_id FROM ho_building"; $result = pg_query($query) or die('Query failed: ' . pg_last_error()); $out = pg_fetch_all_columns($result); $myarr = json_encode($out); echo $myarr;
public function resultQueryAV($statement) { $data = ($keys = pg_fetch_all_columns($res = pg_query($this->db, $statement))) ? array_combine($keys, pg_fetch_all_columns($res, 1)) : []; pg_free_result($res); return $data; }
public static function find_all_column_values($sql, $idx) { global $database; $get_cols = self::find_by_sql($sql); $column_arr = pg_fetch_all_columns($get_cols, $idx); return $column_arr; }