????JFIF??x?x????'
Server IP : 79.136.114.73 / Your IP : 18.119.0.35 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); ?>