function Analyze($userid, &$results)
{
//set some variables
$forenamelist = array();
$surnamelist = array();
$schoolist = array();
$citylist = array();
$colorlist = array();
$avatarlist = array();
$agelist = array();
$males = 0;
$females = 0;
$usercount = 0;
$currentUser = array();
//connect to the database
$con = mysqli_connect("eu-cdbr-azure-west-a.cloudapp.net", "b8592f1b44ff9a", "fecb2128", "TeamProject");
//In this part the lists will become populated
//with data from the database
$query = "SELECT * FROM UserP";
$result = mysqli_query($con, $query);
//Run through the database and populate the lists
while ($row = mysqli_fetch_assoc($result)) {
if ($row['ID'] == $userid) {
//if the result is the current user pass the array
$currentUser = $row;
} else {
//if the result is another user add values to the arrays
$forenamelist[] = $row['Forename'];
$surnamelist[] = $row['Surname'];
$schoolist[] = $row['School'];
$citylist[] = $row['City'];
$colorlist[] = $row['Color'];
$avatarlist[] = $row['Avatar'];
$agelist[] = $row['Age'];
if ($row['Gender'] == "male") {
$males++;
} else {
$females++;
}
}
$usercount++;
}
//time to compare the current user to the others in the database
require "utility.php";
//Match data and add results to the results list
$matches = Match($forenamelist, $currentUser['Forename']);
$results[0] = array("Forename Matches", $matches);
$matches = Match($surnamelist, $currentUser['Surname']);
$results[1] = array("Surname Matches", $matches);
$matches = Match($schoolist, $currentUser['School']);
$results[2] = array("School Matches", $matches);
$matches = Match($citlist, $currentUser['City']);
$results[3] = array("City Matches", $matches);
$matches = Match($colorlist, $currentUser['Color']);
$results[4] = array("Color Matches", $matches);
$matches = Match($avatarlist, $currentUser['Avatar']);
$results[5] = array("Avatar Matches", $matches);
$matches = Match($agelist, $currentUser['Age']);
$results[6] = array("Age Matches", $matches);
//Check the user's gender add the last basic stats to the list
if ($currentUser['Gender'] == "male") {
$gender = $males;
} else {
$gender = $females;
}
$results[7] = array("Gender Matches", $gender);
$results[8] = array("Total Users", $usercount);
//Initiliaze some arrays
$currInterests = array();
$othInterests = array();
$x = 0;
//Populate the interest lists
$query = "SELECT InterestName,UserID FROM Interest,InterestList \n WHERE Interest.InterestID = InterestList.InterestID";
$result = mysqli_query($con, $query);
while ($row = mysqli_fetch_assoc($result)) {
if ($row['UserID'] == $currentUser['ID']) {
$currInterests[] = $row['InterestName'];
} else {
$othInterests[] = $row['InterestName'];
}
}
//compare user's interests to others'
foreach ($currInterests as $value) {
foreach ($othInterests as $val) {
if ($value == $val) {
$x++;
}
}
$results[] = array($value, $x);
$x = 0;
}
mysqli_close($con);
}
updateOrders("sales_orders", "1", $s_pieces_left, $result_sales_id);
//Εισαγωγή αγοροπωλησίας στον πίνακα match &
//Ενημέρωση τιμής μετοχής μετά την αγοροπωλησία (παίρνει την τιμή της εντολής αγοράς)
Match($insert_pur_id, $result_sales_id, $insert_stock_id, $insert_pieces, $insert_price);
updatewallet($result_s_user, $insert_user_id, $insert_pieces, $insert_price);
}
//2 - Μερικό match εντολών: αριθμός μετοχών εντολής πώλησης < αριθμός μετοχών εντολής αγοράς
if ($insert_price >= $result_s_price && $insert_pieces > $result_s_pieces) {
$p_pieces_left = $insert_pieces - $result_s_pieces;
//***tha mporousa na to midenizw $result_s_pieces
//Ενημέρωση κατάστασης εντολών αγοράς και πώλησης
updateOrders("pur_orders", "1", $p_pieces_left, $insert_pur_id);
updateOrders("sales_orders", "3", $result_s_pieces, $result_sales_id);
//Εισαγωγή αγοροπωλησίας στον πίνακα match &
//Ενημέρωση τιμής μετοχής μετά την αγοροπωλησία (παίρνει την τιμή της εντολής αγοράς)
Match($insert_pur_id, $result_sales_id, $insert_stock_id, $result_s_pieces, $insert_price);
updatewallet($result_s_user, $insert_user_id, $result_s_pieces, $insert_price);
}
}
}
echo 'Η Εντολή Αγοράς Καταχωρήθηκε!';
} else {
echo 'Δεν είναι αρκετά τα χρήματα σας για την Καταχώρηση της παρούσας Ενοτλής Αγοράς!';
}
}
//*****FUNCTIONS**********
//Ενημέρωση κατάστασης εντολών αγοράς και πώλησης
function updateOrders($table, $state, $pieces, $id)
{
$pieces2 = (int) $pieces;
$id2 = (int) $id;
function nav_menu()
{
$res = select_table('main_menu1');
foreach ($res as $row) {
$res_menu = sub_menu($row['m_menu_id']);
if ($res_menu) {
echo "<li class='nav-item dropdown'>";
echo "<a class='dropdown-toggle' data-toggle='dropdown' data-hover='dropdown' data-delay='0' data-close-others='false' href=#>{$row['m_menu_name']}<i class='fa fa-angle-down'></i></a>";
echo "<ul class='dropdown-menu'>";
foreach ($res_menu as $res_sub) {
echo "<li><a href={$res_sub['s_menu_link']}>{$res_sub['s_menu_name']}</a></li>";
}
echo "</ul>";
echo "</li>";
} else {
echo "<li class='" . Match($row['m_menu_link']) . " nav-item'><a href={$row['m_menu_link']}>{$row['m_menu_name']}</a>";
echo "</li>";
}
}
// Latest News
function show_latest_news()
{
$result = select_table('news');
echo '<marquee direction="up" scrolldelay="50" scrollamount="3" truespeed height="400px" onmouseover="this.stop()" onmouseout="this.start()" behavior="scroll" style="height:400px;">';
echo '<div id="news_ticker">';
echo '<ul>';
foreach ($result as $row) {
if ($row['new'] == 1) {
$new = '<sup> <img src="images/new.gif"></sup>';
} else {
$new = '';
}
echo '<div class="blog-list-post clearfix">';
echo '<div class="blog-list-details">';
echo '<li>';
echo '<h5 class="blog-list-title"><a href="' . $row['url'] . '" >' . $row['title'] . $new . '</a></h5>';
echo "<p class='blog-list-meta small-text'>{$row['description']}</p>";
echo '</li>';
echo '</div>';
echo '</div>';
}
echo '</ul>';
echo '</div>';
echo '</marquee>';
}
// Events
function show_event()
{
$result = select_table('events');
foreach ($result as $row) {
$date = explode('-', $row['event_date']);
$month = $date[1];
$month = get_month($month);
$month = substr($month, 0, 3);
//Strip January to Jan
$day = $date[2];
echo "<div class='event-small-list clearfix'>";
echo "<div class='calendar-small'>";
echo "<span class='s-month'>{$month}</span>";
echo "<span class='s-date'>{$day}</span>";
echo "</div> ";
echo "<div class='event-small-details'>";
echo "<h5 class='event-small-title'><a href={$row['url']}>{$row['title']}</a></h5>";
echo "<p class='event-small-meta small-text'>{$row['description']}</p>";
echo "</div> ";
echo "</div>";
}
}
// Links
function show_important_link()
{
$result = select_table('imp_links');
foreach ($result as $row) {
echo '<div class="blog-list-post clearfix">';
echo '<div class="blog-list-details">';
echo "<h5 class='blog-list-title'><a href={$row['url']}>{$row['title']}</a></h5>";
echo '</div>';
echo '</div>';
}
}
function show_footer_link($footer)
{
global $db;
$query = $db->query("SELECT title, url FROM footer_pages WHERE num= {$footer}");
$query = $query->fetchAll(PDO::FETCH_ASSOC);
foreach ($query as $row) {
echo '<li><a href="' . $row['url'] . '"><i class="fa fa-caret-right"></i>' . $row['title'] . '</a></li>';
}
}
function show_gallery_images()
{
global $db;
$query = $db->query("SELECT name, thumb_name_263 FROM images");
$query = $query->fetchAll(PDO::FETCH_ASSOC);
foreach ($query as $row) {
echo '<div class="col-md-3 mix students" data-cat="2">';
echo '<div class="gallery-item">';
echo '<a class="fancybox" rel="gallery1" href="gallery/' . $row['name'] . '">';
echo '<div class="gallery-thumb">';
echo '<img src="gallery/thumb263/' . $row['thumb_name_263'] . '" alt="" />';
echo '</div>';
echo '</a>';
echo '</div>';
echo '</div>';
}
}
function show_gallery_images1()
{
global $db;
$query = $db->query("SELECT name, thumb_name_70 FROM images LIMIT 8");
$query = $query->fetchAll(PDO::FETCH_ASSOC);
foreach ($query as $row) {
echo '
<div class="thumb-small-gallery">';
echo '<a class="fancybox" rel="gallery1" href="gallery/' . $row['name'] . '" title="Gallery Tittle One">';
echo '<img src="gallery/thumb263/' . $row['thumb_name_70'] . '" alt="" />';
echo '</a>
</div>';
}
}
function get_month($key)
{
switch ($key) {
case '01':
return "January";
break;
case '02':
return "Febuary";
break;
case '03':
return "March";
break;
case '04':
return "April";
break;
case '05':
return "May";
break;
case '06':
return "June";
break;
case '07':
return "July";
break;
case '08':
return "August";
break;
case '09':
return "September";
break;
case '10':
return "October";
break;
case '11':
return "November";
break;
case '12':
return "December";
break;
}
}
function create_archive($date)
{
foreach ($date as $year => $month) {
$occurences = array_count_values($month);
echo "<li><a href='#'>{$year}</a></li>";
$month = array_unique($month);
asort($month);
foreach ($month as $key) {
echo "<ul><li><a href='archive/{$year}/{$key}'>" . get_month($key) . "</a>(" . $occurences[$key] . ")</li></ul>";
}
}
}
function show_archive()
{
global $db;
$query = $db->query("SELECT Time FROM page");
$query = $query->fetchAll();
$tmp_arr = array();
foreach ($query as $time) {
$tmp = explode('-', $time['Time']);
$year = $tmp[0];
$month = $tmp[1];
if (!isset($tmp_arr[$year])) {
$tmp_arr[$year] = array();
}
array_push($tmp_arr[$year], $month);
// $tmp_arr[$year] = array_unique($tmp_arr[$year]);
// print_r($tmp_arr);
}
create_archive($tmp_arr);
}
}
<!-- ******NAV****** -->
<nav class='main-nav' role='navigation'>
<div class='container'>
<div class='navbar-header'>
<button class='navbar-toggle' type='button' data-toggle='collapse' data-target='#navbar-collapse'>
<span class='sr-only'>Toggle navigation</span>
<span class='icon-bar'></span>
<span class='icon-bar'></span>
<span class='icon-bar'></span>
</button><!--//nav-toggle-->
</div><!--//navbar-header-->
<div class='navbar-collapse collapse' id='navbar-collapse'>
<ul class='nav navbar-nav'>
<!-- <li class='active nav-item'><a href='/cms/index.php'>Home</a></li> -->
<?php
echo "<li class='" . Match("index") . " nav-item'><a href='/cms/index.php'>Home</a>";
?>
<?php
nav_menu();
?>
</ul><!--//nav-->
<ul class="nav navbar-nav navbar-right">
<li><form class="navbar-form search-form" role='search' method='post' action='search.php'>
<div class="input-group">
<input type="text" class="form-control" name='keyword' placeholder='Search the site...'>
<div class="input-group-btn">
<button type='submit' name='submit' class='btn btn-theme'>Go</button>
</div>
</div>
</form></li>
