function get_teikei() { require_once(dirname(__FILE__)."/../../../init.inc.php"); require_once(C_INC_DIR_SSL."db_utils.php"); $conn = connect_db(); $sql = "SELECT"; $sql.= " company_no,"; $sql.= " company_nm "; $sql.= "FROM"; $sql.= " m_company "; $sql.= "WHERE"; $sql.= " keisai_flg = 1"; $sql.= " and keisai_logo_flg = 0 "; $sql.= "ORDER BY RAND() "; $sql.= "LIMIT 18;"; $teikei_dict = []; foreach ($conn->query($sql) as $row) { $company_no = $row["company_no"]; $company_nm = $row["company_nm"]; $src = ""; if(file_exists(C_IMG_PATH."logo/".$company_no)){ $src = C_IMG_ROOT_URL."logo/".$company_no; } $teikei_dict[$company_nm] = $src; } $conn = null; return $teikei_dict; }
function show_site($id_user) { $ref_show = $_SESSION['ref_sell_number']; connect_db(); // Show SOLD ITEMS by USER in the session $sql_select = "SELECT * FROM Barcode INNER JOIN Item ON Item.id_item=Barcode.Item_id_item INNER JOIN Barcode_has_Buyer ON Barcode.id_Barcode=Barcode_has_Buyer.Barcode_id_Barcode Where stock_out=1 AND Barcode_has_Buyer.user_2='{$id_user}' AND ref_sell_number='{$ref_show}' ORDER BY date_sold DESC"; //show transaction started as zero means a fresh transaction that dad //if($ref_show==0) // $sql_select="SELECT * FROM Barcode INNER JOIN Item ON Item.id_item=Barcode.Item_id_item INNER JOIN Barcode_has_Buyer ON Barcode.id_Barcode=Barcode_has_Buyer.Barcode_id_Barcode Where stock_out=1 AND Barcode_has_Buyer.user_2='$id_user' AND ref_sell_number='$ref_show' ORDER BY date_sold DESC"; $result = query_select($sql_select); while ($rek = mysql_fetch_array($result)) { echo "<tr><td>"; echo $rek["Barcode"]; echo "</td><td>"; echo $rek["stock_in"]; echo "</td><td>"; echo $rek["stock_out"]; //echo "sdfsdf"; echo "</td><td>"; echo $rek["Item_id_item"]; echo "</td><td>"; echo $rek["date"]; echo "</td><td>"; echo $rek["name"]; echo "</td><td>"; echo $rek["brand"]; echo "</td><td>"; echo $rek["pn"]; echo "</td><td>"; echo $rek["ref_sell_number"]; echo "</td><td>"; echo "Sold"; echo "</td></tr>"; } }
function lookup_user($usr_id, $cur_time) { // check if user exists (if not, create user) // check if url exists (if not, create url) // add vote if ($con = connect_db('../auth.txt')) { $result = pg_prepare($con, "check_user", 'SELECT * FROM users where id = $1'); $result = pg_execute($con, "check_user", array($usr_id)); $usr_entry = pg_fetch_array($result); pg_free_result($result); if (!$usr_entry) { $result = pg_prepare($con, "reg_user", 'INSERT INTO users VALUES ($1, $2, $3)'); $result = pg_execute($con, "reg_user", array($usr_id, 0, (int) $cur_time)); pg_free_result($result); $id = $usr_id; $spent = 0; $reg = $cur_time; } else { $id = $usr_entry[0]; $spent = $usr_entry[1]; $reg = $usr_entry[2]; } echo json_encode(array("usr" => $id, "spent" => $spent, "reg" => $reg)); } else { echo json_encode(array("f**k" => "nuts")); } }
function ObtenerProductos() { $success = false; $datos = array(); $cantidad = 0; $db = connect_db(); if ($db) { try { $query = "select * from publicar1;"; $db->query("SET CHARACTER SET utf8"); $result = $db->query($query); while (is_object($result) && ($row = $result->fetch_assoc())) { $dato = new stdClass(); $dato->id = $row["pu1_id"]; $dato->nombre = $row['pu1_nombre']; array_push($datos, $dato); } $result->free(); $success = true; $db->close(); } catch (Exception $exc) { echo $exc->getTraceAsString(); } } $res = array('success' => $success, 'total' => $cantidad, 'datos' => $datos); return $res; }
function show_site() { connect_db(); $sql_select = "SELECT * FROM Buyer WHERE postcode NOT Like 'Blank' ORDER BY id_Buyer DESC"; $result = query_select($sql_select); while ($rek = mysql_fetch_array($result)) { //echo "<table>"; echo "<tr><td>"; echo $rek["postcode"]; echo "</td><td>"; echo $rek["company_name"]; echo "</td><td>"; echo $rek["name"]; // echo "sdfsdf"; echo "</td><td>"; echo $rek["surname"]; echo "</td><td>"; echo $rek["address"]; echo "</td><td>"; echo $rek["town"]; echo "</td><td>"; //$postal_code = strtoupper (str_replace(' ', '', $postal_code)); echo $email = $rek['email']; echo "</td><td>"; echo $phone = $rek['phone']; echo "</td><td>"; if (empty($rek['ttl_nr'])) { echo "-"; } else { echo $rek['ttl_nr']; } echo "</td><td>"; echo "</td></tr>"; } }
function lisa() { // siia on vaja funktsionaalsust (13. nädalal) if (!empty($_SESSION["user"])) { if ($_SERVER['REQUEST_METHOD'] == "POST") { // postitus on tehtud if (in_array("", $_POST) || $_FILES["pilt"]["error"] > 0) { $errors[] = "Mingi väli jäi postitamisel tühjaks või on faili üleslaadimisel tekkinud viga."; include_once 'views/loomavorm.html'; } else { // kõik ok, laeme faili üles ja teeme kirje tabelisse connect_db(); upload("pilt"); $query = "INSERT INTO ttilk__loomaaed (NIMI, PUUR, PILT) \n\t\t\t\t\t\t\tVALUES ('" . mysqli_real_escape_string($GLOBALS['connection'], $_POST["nimi"]) . "', '" . mysqli_real_escape_string($GLOBALS['connection'], $_POST["puur"]) . "', '" . "pildid/" . $_FILES["pilt"]["name"] . "');"; $result = mysqli_query($GLOBALS['connection'], $query) or die("{$query} - " . mysqli_error($GLOBALS['connection'])); echo $_FILES["pilt"]["name"]; //header("refresh:3; url=loomaaed.php?page=loomad"); } // if } else { include_once 'views/loomavorm.html'; } // if $_SERVER } else { header("Location: loomaaed.php?page=login"); } // if !empty }
function getmatches_data() { $db_connect = connect_db(); $query = "select * from matchfixture WHERE match_date >= CURDATE()"; $result = mysql_query($query, $db_connect) or die(mysql_error()); $i = 1; $ipl_result = ''; while ($row = mysql_fetch_array($result)) { /*echo '<br>'; echo '<br> id =' .$row['id']; echo '<br>match date='.$row['match_date']; echo '<br>match timing='.$row['match_time']; echo '<br>team1 name='.$row['team1']; echo '<br>team2 name='.$row['team2']; echo '<br>match venue='.$row['venue'];*/ $ipl_result .= $i . ". " . $row['team1'] . " Vs " . $row['team2'] . " on " . date('F j', strtotime($row['match_date'])) . ", " . $row['match_time'] . " at " . $row['venue'] . "\n"; $i++; } echo $ipl_result; if ($ipl_result != "") { $total_return = $ipl_result; $source_machine = $machine_id; $current_file = "/temp/{$numbers}"; file_put_contents(DATA_PATH . $current_file, $total_return); include 'allmanip.php'; $to_logserver['source'] = 'championsTrophy'; putOutput($total_return); exit; } }
function get_received_applies($tweet_id, $num, $page, $count = false) { include_once 'login.inc.php'; $id = get_current_user_id(); if ($count) { $limit = ""; $select = "COUNT(*)"; } else { if (!$page) { $page = "0"; } $select = "*"; $page = intval($page) * $num; $limit = " LIMIT {$page} , {$num}"; } connect_db(); $view = "SELECT {$select} from applications AS ap, (SELECT * FROM tweets WHERE tweet_id='{$tweet_id}' AND deleted=0) AS tweets, (SELECT user_site_id, site_id from accountbindings WHERE user_id = '{$id}') AS ab WHERE tweets.deleted=0 AND ap.deleted=0 AND ap.tweet_id='{$tweet_id}' AND tweets.user_site_id = ab.user_site_id AND tweets.site_id = ab.site_id ORDER BY tweets.post_datetime DESC{$limit}"; $list = mysql_query($view); $result = array(); $i = 0; while ($row = mysql_fetch_array($list)) { $result[$i++] = $row; } return $result; }
public function __construct() { //Connect to database $this->db_connection = connect_db('local'); $this->db = $this->db_connection->{'findit_log'}; $this->collection = $this->db->{'intlayer'}; }
function kuva_puurid() { // siia on vaja funktsionaalsust global $connection; if (empty($_SESSION["user"])) { header("Location: ?page=login"); } connect_db(); global $connection; $puurid = array(); $puurinumbrid = array(); $query_puurinumbrid = "SELECT DISTINCT(puur) FROM `markask_loomaaed`"; $result_puurinumbrid = mysqli_query($connection, $query_puurinumbrid) or die("{$query_puurinumbrid} - " . mysqli_error($connection)); while ($row = mysqli_fetch_array($result_puurinumbrid)) { $puurinumbrid[] = $row['puur']; } //Array ( [0] => 8 [1] => 2 [2] => 4 [3] => 5 [4] => 7 ) foreach ($puurinumbrid as &$puurinumber) { $loomarida = array(); $query_puurinumber = "SELECT * FROM `markask_loomaaed` WHERE puur={$puurinumber} ORDER BY puur ASC"; $result_loomad = mysqli_query($connection, $query_puurinumber) or die("{$query_puurinumbrid} - " . mysqli_error($connection)); while ($loom = mysqli_fetch_assoc($result_loomad)) { $loomarida[] = $loom; } $puurid[$puurinumber] = $loomarida; } /* echo "<pre>"; * print_r($puurid); * echo "</pre>"; */ include_once 'views/puurid.php'; }
function deletemessage($mid) { $cn = connect_db(); $sql = "delete from message where id='" . $mid . "'"; $result = mysql_query($sql, $cn) or die("ERROR :" . mysql_error()); disconnect_db($cn); }
function query($argv = '') { error_reporting(7); $table_queryer_file = __DIR__ . DIRECTORY_SEPARATOR . 'ThinkPHP-Queryer'; $content = file_get_contents($table_queryer_file); $sep = '##########################################################################'; $arr_content = split($sep, $content); $sql = trim($arr_content[0]); connect_db($argv); $result = mysql_query($sql); $rows = array(); if ($result) { $i = 0; while ($row = mysql_fetch_assoc($result)) { if ($i == 0) { $header = array_keys($row); } $i++; $rows[] = array_values($row); } } require __DIR__ . '/table.php'; $in = array('header' => $header ? $header : array(), 'rows' => $rows); // file_put_contents('./', data); file_put_contents('./debug.php', var_export($in, 1)); if ($rows) { $table = new table($in); $output = $table->render(0); } if (!$output) { $output = 'no results!'; } exit($output); }
static function authenticateUser($email, $password) { if (empty($email)) { throw new InvalidArgumentException("email may not be empty", 400); } if (empty($password)) { throw new InvalidArgumentException("password may not be empty", 400); } require_once '../api/include/connect_db.php'; $conn = connect_db(); $email = $conn->real_escape_string($email); $password = $conn->real_escape_string($password); $sql_query = "SELECT `id`,`hash` FROM `users` WHERE "; $sql_query .= "`email`='{$email}' LIMIT 1"; if (!($result = $conn->query($sql_query))) { throw new DatabaseException(); } if ($result->num_rows === 0) { throw new UnexpectedValueException("No such user", 400); } $row = mysqli_fetch_assoc($result); $hash = $row['hash']; $res = password_verify($password, $hash); if (!$res) { throw new UnexpectedValueException("Invalid credentials", 400); } return $row['id']; }
function tweet_delete() { include_once 'login.php'; include_once 'sinaoauth.inc.php'; $id = get_current_user_id(); $args = func_get_args(); $key = $args[2]; if (!$key) { die('Invalid Argument!'); } connect_db(); $view = "SELECT tweets.* FROM tweets, (SELECT user_id, user_site_id, site_id FROM accountbindings) AS ac WHERE tweets.user_site_id = ac.user_site_id AND ac.user_id='{$id}' AND ac.site_id = tweets.site_id AND tweets.tweet_id='{$key}' AND tweets.deleted='0'"; $list = mysql_query($view); $row = mysql_fetch_array($list); if ($row or user_is_admin()) { if ($row) { $c = new WeiboClient(SINA_AKEY, SINA_SKEY, $GLOBALS['user']['sinakey']['oauth_token'], $GLOBALS['user']['sinakey']['oauth_token_secret']); $msg = $c->destroy($row['tweet_site_id']); } $view = "UPDATE tweets SET deleted='1' WHERE tweet_id='{$key}'"; $list = mysql_query($view) or die("Delete error!"); } else { print $key; die(": Non-exist Error!"); } }
function look_up_tense($tense) { connect_db(); $sql = sprintf("SELECT tense FROM tenses WHERE id = %d", $tense); $result = mysql_query($sql) or die(mysql_error()); $tense = mysql_fetch_array($result); return $tense[0]; }
function deleteMember($num) { connect_db(); $sql = "DELETE FROM member WHERE m_num = " . strval($num); $result = mysql_query($sql); mysql_close(); return $result; }
function check_answer_exist($user_id, $survey_id, $question_id, $option_id) { $connection = connect_db(); $sql = "SELECT *\n \t\t\tFROM user_answers\n \t\t\tWHERE user_id=" . $user_id . " AND survey_id=" . $survey_id . " AND question_id=" . $question_id . " AND option_id=" . $option_id; $query_results = mysqli_query($connection, $sql) or die(mysql_error()); $answer_exists = mysqli_num_rows($query_results) > 0 ? true : false; return $answer_exists; close_db($connection); }
function create_table($connect) { if (!is_connected) { $connect = connect_db(); return false; } $createUsersSql = "CREATE TABLE users (\r\n\t\tid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, \r\n\t\tusername VARCHAR(60) NOT NULL,\r\n\t\temail VARCHAR(50),\r\n\t\treg_date TIMESTAMP)"; $createPicsSql = "CREATE TABLE MyGuests (\r\n\t\tid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, \r\n\t\tnickname VARCHAR(30) NOT NULL,\r\n\t\tlocation VARCHAR(100) NOT NULL,\r\n\t\tuserid INT,\r\n\t\tFOREIGN KEY(userid) REFERENCES users(id)"; }
function get_links() { $db_con = connect_db(); if ($db_con) { $sql = 'SELECT Categories.category,Links.link,Links.status,Links.id FROM Links INNER JOIN Categories ON Links.category = Categories.id'; $links = $db_con->query($sql); } return $links; }
function DB_insert($query) { $link = connect_db(); if ($link) { $result = mysql_query($query); } else { return false; } return $result; }
function get_new_messages_count() { connect_db(); $query = mysql_query("SELECT COUNT( * ) AS count " . "FROM `messages` LEFT JOIN `users` ON `users`.`id` = `messages`.`idUserTo` " . "WHERE `messages`.`idUserOwner` = " . $_SESSION['userId'] . " AND `messages`.`isRead` = FALSE" . " AND `messages`.`idUserTo` = " . $_SESSION['userId']); $result = mysql_fetch_assoc($query); if ($result) { return $result['count']; } return 0; }
function getMemberCount() { // member데이블 레코드 갯수 확인 connect_db(); $sql = " SELECT count(*) FROM member"; $result = mysql_query($sql); $count = mysql_result($result, 0, 0); var_dump($count); mysql_close(); return $count; }
/** * Gets the Bible version meta data * @param $name string Version name * @return array Version meta data */ function getBibleMeta($name) { $db = connect_db($name); $query = "SELECT * FROM meta"; $result = $db->query($query); $out = array(); while ($row = $result->fetch_array(MYSQLI_ASSOC)) { $out[$row["name"]] = $row["value"]; } return $out; }
function search($from, $to, $date, $count) { $str = "select * from flight " . "where from_city='{$from}' and to_city='{$to}' and fdate='{$date}' and capacity >= {$count}"; //var_dump($str);exit; $result = mysql_query($str, connect_db()); $r = array(); while ($row = mysql_fetch_assoc($result)) { array_push($r, $row); } return $r; }
function updatePlugins() { connect_db(); $list = $this->getPluginsList(); // Delete anything lingering in the database mysql_query("TRUNCATE TABLE plugins"); foreach (array_slice($list, 0, 999) as $fileNames) { $this->parseFilename($fileNames); } close_db(); echo 'Success!'; }
function faculty_select() { $dblink = connect_db(); $strSQL = "SELECT fID, fNameT FROM tblfaculty"; $resultSQL = mysqli_query($dblink, $strSQL); echo '<select name="fID">'; echo '<option value="">---------- เลือกคณะ ----------</option>'; while ($rows = mysqli_fetch_array($resultSQL)) { echo '<option value="' . $rows['fID'] . '">' . $rows['fNameT'] . '</option>'; } echo '</select>'; }
function check_login($page_root) { global $forbidden_str; $conn = connect_db(); // if (isset($_SESSION['username'])) { echo '<span id="welcome-line" class="welcome-line">'; echo '<button id="home_page" type="button" style="float: left;" onclick="location.href=\'home_page.php\'">Return to Home Page</button>'; echo "Welcome {$_SESSION["dbuser_first_name"]} {$_SESSION["dbuser_last_name"]}!"; echo ' '; echo '<input id="logout-button" type="button" value="Logout" onclick="document.getElementById(\'logout\').submit();"></span>'; echo '<br>'; // if ($page_root == 'home_page' and check_perms($_SESSION['permissions'], 'table_maintenance')) { // $sql = "SELECT count(*) FROM `suggestions` WHERE `suggestion_status` LIKE 'unread'"; list($num_unread, $err) = fetch_db($sql, [], $conn); $sql = "SELECT count(*) FROM `suggestions` WHERE `suggestion_status` LIKE 'flagged'"; list($num_flagged, $err) = fetch_db($sql, [], $conn); // $num_unread = $num_unread[0]['count(*)']; $num_flagged = $num_flagged[0]['count(*)']; $flag_style = 'color: orange;'; $unread_style = 'color: red;'; if ($num_flagged == 0) { $flag_style = 'color: green;'; } if ($num_unread == 0) { $unread_style = 'color: green;'; } // echo '<span id="admin-messages" class="welcome-line">'; echo '<label style="text-align:left; min-width:initial; font-weight: bold; margin-right:1.5em;">Suggestions:</label>'; echo "<a style=\"{$flag_style}\" onclick=\"view_suggestions('flagged');\">{$num_flagged} Flagged</a> "; echo "<a style=\"{$unread_style}\" onclick=\"view_suggestions('unread');\">{$num_unread} Unread</a> "; echo '</span>'; } // echo '<span id="suggestion-line" class="welcome-line">'; echo '<a id="leave_suggestion" onclick="enter_suggestion();">Leave a Suggestion!</a> '; echo '</span>'; } else { echo "<script>document.getElementById('invalid_login').submit();</script>"; session_destroy(); } // checking user perms for the page $access = check_perms($_SESSION['permissions'], $page_root); if (!$access) { echo '<span id="forbidden-page" class="forbidden-page">' . $forbidden_str . '</span>'; die; } }
public function CityList($id) { $select = "select * from city where country_id=" . $id; $query = mysql_query($select, connect_db()); $cities = array(); while ($row = mysql_fetch_assoc($query)) { $temp = array(); $temp['id'] = $row['id']; $temp['en_name'] = $row['en_name']; array_push($cities, $temp); } return $cities; }
public function deleteData($obj) { if ($obj == NULL) { return NULL; } //connect to the database. $DB = connect_db(false); //save changes $sql = "DELETE FROM mime_type_cross WHERE id=?"; $DB->execute($sql, array($obj->id)); close_db($DB); return NULL; }
/** * Update one item in the table * @param VOTimeline to be updated * @return NULL */ public function updateData($obj) { if ($obj == NULL) { return NULL; } //connect to the database. $DB = connect_db(false); //save changes $sql = "UPDATE btk_user_info SET ts_username='******', ts_password='******',reg_username='******', reg_password='******'"; $DB->execute($sql); close_db($DB); return NULL; }