// 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;
