function get_weee_categories() { connect_dbi(); $weee_cat = array(); $weee_cat_name = array(); $blank = array(); $sql = "SELECT * FROM category"; $result = query_selecti($sql); //count how many categories are there. Mind some may be non active or visible. BYt bu unique it we calculate all $num_categories_availible = mysqli_num_rows($result); //echo $num_categories_availible; $i = 0; while ($rek = mysqli_fetch_array($result, MYSQLI_BOTH)) { $i++; //var_dump($rek); //echo $rek['id']; // GET CATEGORY UNIQU AI NUMBER $weee_cat_name[$i] = $rek['name_cat']; $weee_cat[$i] = $rek['id']; $blank[$i] = 0; //echo $weee_cat[$i]; } //here we initialise an array /* for($i=0;$i=$num_categories_availible;$i++) { $weee_cat } */ return array($weee_cat, $weee_cat_name, $blank); //zero to zero for calculation assignment. cant properly define cat indexes be default 0 }
function show_site() { $db = connect_dbi(); $sql_select = "SELECT * FROM Origin" . " INNER JOIN Source ON source.source_id=Origin.Source_source_id" . " ORDER BY origin_id DESC"; $result = query_selecti($db, $sql_select); while ($rek = mysqli_fetch_array($result)) { //echo "<table>"; echo "<tr><td>"; echo $rek["post_code"]; 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["street"]; echo "</td><td>"; echo $rek["town"]; echo "</td><td>"; //$postal_code = strtoupper (str_replace(' ', '', $postal_code)); echo $rek["Source_source_id"]; echo "</td><td>"; echo $rek["town_name"]; echo "</td><td>"; echo $email = $rek['email']; echo "</td><td>"; echo $phone = $rek['phone']; echo "</td></tr>"; } mysqli_free_result($result); mysqli_close($db); }
function check_cat($id) { $db = connect_dbi(); $sql = "SELECT * FROM category"; $result = query_selecti($db, $sql); while ($rek = mysqli_fetch_array($result)) { echo "<option value='" . $rek['id'] . "'>" . $rek['name_cat'] . "</option>"; } // return $rek['town_name']; }
function check_cat($id) { $db = connect_dbi(); $sql = "SELECT * FROM item_has_cat INNER JOIN item ON item.Item_has_cat_id_item_cat=item_has_cat.id_item_cat WHERE active=1 GROUP BY assign_nr ORDER By id_item_cat"; $result = query_selecti($db, $sql); // echo $id; while ($rek = mysqli_fetch_array($result)) { $sub_cat = $rek['sub_cat']; if ($id == $rek['id_item_cat']) { echo "<option value='" . $rek['id_item_cat'] . "' selected >" . $rek['name'] . " - <b>" . get_sub_cat_name($sub_cat) . "</b></option>"; } else { echo "<option value='" . $rek['id_item_cat'] . "'>" . $rek['name'] . " - <b>" . get_sub_cat_name($rek['sub_cat']) . "</b></option>"; } } // return $rek['town_name']; }
$fp = fopen("{$DOCUMENT_ROOT}/../user.txt", LOCK_EX); if (!$fp) { echo "Could not open log file"; } fwrite($fp, $tofile, strlen($tofile)); flock($fp, LOCK_UN); fclose($fp); } function redirect($gdzie, $czas) { echo "<head><meta http-equiv=\"Refresh\" content=\"{$czas}; URL={$gdzie}\" /></head>"; } //This function checks if log button was sumbited if (isset($_POST['log'])) { //connect Database by mysqli interface $db = connect_dbi(); //return a row when admin login in User_2 table $sql_select_admin = mysqli_query($db, 'SELECT * FROM User_2 WHERE login = "******"'); $result_select_admin = mysqli_fetch_array($sql_select_admin) or die(mysql_error()); if ($sql_select_admin) { if (isset($_POST['password'])) { if ($_POST['password'] == $result_select_admin['pass']) { $name_p = $_POST['name_p']; //initialize name_p variable $WEIGHT_PASS = 1; } else { echo 'Wrong Data!'; // $WR=1; // These 4 variables send back to add stock if login is wrong $barcode = $bb = $_POST['barcode_p']; $item = $ii = $_POST['name_p']; $brand = $ib = $_POST['brand_p'];
<?php session_start(); #include 'second_lvl_api.php';//include all needed functions #include 'first_lvl_api.php'; #include 'session_device.php'; //include 'header_mysql_tablet.php'; include 'third_lvl_api.php'; require 'first_lvl_api.php'; //for manifest sticker manipulation error_reporting(E_ALL); ini_set('display_errors', 'off'); //reset_tokens_on_sub_cat(); connect_dbi(); $legged = 0; if ($_SESSION['logged'] == 1) { $logged = $_SESSION['logged']; $user = $_SESSION['l_klient']; } ?> <html> <head> <title>GRR Collection System</title> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1,maximum-scale=1"> <link rel="stylesheet" href="jquery.mobile/jquery.mobile-1.4.4.min.css"/> <script src="jquery-2.1.1.js"></script> <script src="jquery.mobile/jquery.mobile-1.4.4.min.js"></script> </head>
function check_cat_ext($id) { $db = connect_dbi(); $sql = "SELECT * FROM weee_extension"; $result = query_selecti($db, $sql); // echo $id; while ($rek = mysqli_fetch_array($result)) { //$sub_cat=$rek['sub_cat']; if ($id == $rek['idweee_extension']) { echo "<option value='" . $rek['idweee_extension'] . "' selected >" . $rek['name_ext'] . " - <b>" . $rek['weee_extension'] . "</b></option>"; } else { echo "<option value='" . $rek['idweee_extension'] . "'>" . $rek['name_ext'] . " - <b>" . $rek['weee_extension'] . "</b></option>"; } } // return $rek['town_name']; }
function reset_tokens_on_sub_cat() { connect_dbi(); $update = "UPDATE `sub_cat` SET `token_dynamic_idtoken`=1"; query_selecti($update); }