<?php
require_once 'DataAccess.php';
require_once 'includes/functions.php';
$name = $_POST['name'];
//user info
$id = 1;
$userName = "******";
$email = "*****@*****.**";
$description = $_POST['description'];
$stars = $_POST['stars'];
$latitude = $_POST['latitude'];
$longitude = $_POST['longitude'];
$now = getCurrentDateTime();
$sql = "INSERT INTO problems VALUES (null,'{$name}', '{$id}', '{$userName}', '{$email}','{$description}',null, 'fn','{$now}', 0, '{$now}', 'Active','{$stars}','{$latitude}','{$longitude}')";
$data = new DataAccess('photo');
$result = $data->executeQuery($sql);
$pid = mysql_insert_id();
if (!$result) {
echo mysql_error();
return;
}
$data->dispose();
return $pid;
function getRankArray()
{
$data = new DataAccess('photo');
$sql = "SELECT place_id, vote_count FROM places ORDER BY vote_count DESC";
$resultset = $data->getResultSet($sql);
$i = 0;
$v = -1;
$placeID = array();
$rank = array();
while ($row = $data->getRow($resultset)) {
if ($v != $row['vote_count']) {
$i++;
$v = $row['vote_count'];
}
array_push($placeID, $row['place_id']);
array_push($rank, $i);
}
$data->dispose();
return array_combine($placeID, $rank);
}
