????JFIF??x?x????'
| Server IP : 79.136.114.73 / Your IP : 216.73.217.84 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/appsrv.astacus.se/apps/school/www_old_temp/FoodForNeedy/ |
Upload File : |
<?php
require_once('connection.php');
$name = $_GET['Name'];
$latitude = $_GET['Latitude'];
$longitude = $_GET['Longitude'];
$noOfPlates = $_GET['NoOfPlates'];
$macAddress = $_GET['MacAddress'];
$phoneNo = $_GET['PhoneNo'];
$idRequester = $_GET['Id_Requester'];
$idDonor = $_GET['Id_Donor'];
date_default_timezone_set("Asia/Kolkata");
$currentDateTime = date("Y-m-d H:i:s");
$sql = "INSERT INTO tblVolunteer(Name, Latitude, Longitude, NoOfPlates, MacAddress, PhoneNo, Id_Requester, Id_Donor, AcceptedDate) VALUES($name, $latitude, $longitude, $noOfPlates, $macAddress, $phoneNo, $idRequester, $idDonor, '$currentDateTime')";
mysqli_query($connection, $sql);
updateTable("tblRequester", $noOfPlates, $idRequester, $connection);
updateTable("tblDonor", $noOfPlates, $idDonor, $connection);
function updateTable($tableName, $noOfPlates, $id, $connection)
{
//tblRequester Updation
$sql = "SELECT NoOfPlatesPending FROM $tableName WHERE Id=$id";
$result = mysqli_query($connection, $sql);
$noOfPlatesPendingDB = 0;
if ($result->num_rows > 0)
{
echo "updateTblRequester if";
while($row = mysqli_fetch_array($result))
{
$noOfPlatesPendingDB += $row['NoOfPlatesPending'];
}
$remainingNoOfPlatesPending = $noOfPlatesPendingDB - $noOfPlates;
$remainingNoOfPlatesPending = max(0, $remainingNoOfPlatesPending);
$status = 0;
if ($remainingNoOfPlatesPending <= 0)
{
$status = 1;
}
$sql = "UPDATE $tableName SET NoOfPlatesPending=$remainingNoOfPlatesPending, Status=$status WHERE Id=$id";
mysqli_query($connection, $sql);
}
else
{
echo "0 results";
}
}
mysqli_close($connection);
?>