<?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 unlikeItem($userID, $itemID) { $data = new DataAccess('photo'); $sql = "SELECT like_count FROM items WHERE item_id={$itemID}"; $resultset = $data->getResultSet($sql); $row = $data->getRow($resultset); $newitemtotal = $row['like_count'] - 1; $sql = "SELECT like_count FROM users WHERE fbid='{$userID}'"; $resultset = $data->getResultSet($sql); $row = $data->getRow($resultset); $newusertotal = $row['like_count'] - 1; $newtime = getCurrentDateTime(); $sql = "UPDATE items SET like_count={$newitemtotal} WHERE item_id={$itemID}"; $data->executeQuery($sql); $sql = "UPDATE users SET like_count={$newusertotal} WHERE fbid='{$userID}'"; $data->executeQuery($sql); $sql = "DELETE FROM users_likes WHERE fbid='{$userID}' AND item_id={$itemID}"; $data->executeQuery($sql); $data->dispose(); }