// start a session session_start(); // check if user is logged in. if not, send to login. if (!(isset($_SESSION["login"]) && $_SESSION["login"] != "")) { header("Location: ../login-sign-in/sign-in.html"); exit; } //DB Credentials $username = "******"; $host = "localhost"; $database = "vishwasm_marketplace"; $password = "******"; //Connect to Database $conn = connectDB($host, $database, $username, $password); $queryS = "SELECT v.vendor_id, count(1) as vendor_count FROM\n(SELECT u.product_id, p.vendor_id\nFROM userlog u\nLEFT JOIN products p on p.product_id = u.product_id ) v\ngroup by v.vendor_id order by vendor_id"; $result = runSelectQuery($queryS, $conn); $numRows = mysql_num_rows($result); if ($numRows <= 0) { die("Select query returned no rows"); } /*for ($i = 0; $i < $numRows; $i++) { print("<br/>"); for ($j = 0; $j < 2; $j++) { print(" " . mysql_result($result, $i, $j)); } print("<br/>"); }*/ //echo mysql_result($result, 0, 1); function connectDB($host, $database, $username, $password) { if (!($conn = @mysql_connect($host, $username, $password))) {
$ttmResult = returnArray($ttmResult1); //For Giftshop $giftQuery = "SELECT v.product_name, count(1) as visit_count FROM\n\t\t(SELECT p.product_name, u.product_id\n\t\tFROM userlog u\n\t\tLEFT JOIN products p on p.product_id = u.product_id where p.vendor_id='little') v\n\t\tgroup by v.product_name order by visit_count desc limit 5"; $giftResult1 = runSelectQuery($giftQuery, $database); $giftResult = returnArray($giftResult1); //For GameOn $gameQuery = "SELECT v.product_name, count(1) as visit_count FROM\n\t\t(SELECT p.product_name, u.product_id\n\t\tFROM userlog u\n\t\tLEFT JOIN products p on p.product_id = u.product_id where p.vendor_id='dextrous') v\n\t\tgroup by v.product_name order by visit_count desc limit 5"; $gameResult1 = runSelectQuery($gameQuery, $database); $gameResult = returnArray($gameResult1); //For Dhaba $dhabaQuery = "SELECT v.product_name, count(1) as visit_count FROM\n\t\t(SELECT p.product_name, u.product_id\n\t\tFROM userlog u\n\t\tLEFT JOIN products p on p.product_id = u.product_id where p.vendor_id='dhabaonwhe') v\n\t\tgroup by v.product_name order by visit_count desc limit 5"; $dhabaResult1 = runSelectQuery($dhabaQuery, $database); $dhabaResult = returnArray($dhabaResult1); //For Maru Maru $maruQuery = "SELECT v.product_name, count(1) as visit_count FROM\n\t\t(SELECT p.product_name, u.product_id\n\t\tFROM userlog u\n\t\tLEFT JOIN products p on p.product_id = u.product_id where p.vendor_id='maru') v\n\t\tgroup by v.product_name order by visit_count desc limit 5"; $maruResult1 = runSelectQuery($maruQuery, $database); $maruResult = returnArray($maruResult1); function runSelectQuery($query, $database) { if (!($result = mysql_query($query, $database))) { die("Could not execute select query" . mysql_error()); } return $result; } function returnArray($result) { $arrayData = array(); while ($row = mysql_fetch_assoc($result)) { array_push($arrayData, $row); } return $arrayData;