<?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); }