Example #1
0
<?php

include_once '../db.php';
include_once 'includes/validation.php';
$parameters = array('trip_id', 'driver_id', 'wait_time', 'ride_time', 'coordinates', 'status');
$result = array();
$is_parameters_exists = is_post_parameters_exists($parameters);
if (!$is_parameters_exists) {
    extract($_POST);
    $extra_fare = 0;
    //getting trip details
    $sql = "SELECT * FROM trip_reg WHERE id = {$trip_id}";
    $statement = $dbh->prepare($sql);
    $statement->execute();
    $trip_details = $statement->fetch(PDO::FETCH_ASSOC);
    $car_type = $trip_details['cartype'];
    $package = $trip_details['package'];
    //getting package details
    $sql = "SELECT * FROM fare_chart WHERE category = '{$package}' and cartype = '{$car_type}'";
    $statement = $dbh->prepare($sql);
    $statement->execute();
    $package_details = $statement->fetch(PDO::FETCH_ASSOC);
    //minimum fare
    $minimum_fare = $package_details['min_bill'];
    //calculating  distance travelled
    $total_distance = getdistance($coordinates);
    if ($total_distance > $package_details['min_kms']) {
        $extra_distance_travelled = $total_distance - $package_details['min_kms'];
        $extra_fare = $extra_distance_travelled * $package_details['extra_kms'];
    }
    //converting minutes to seconds
Example #2
0
<?php

include '../includes/dbutil.php';
include 'includes/validation.php';
$parameters = array('cnv_upid', 'space_available_for', 'other_services', 'additional_services', 'convention_post_id');
$is_parameter_available = is_post_parameters_exists($parameters);
if ($is_parameter_available == 0) {
    extract($_POST);
    $query = mysql_query("select * from  convention_post_add where cnv_upid='" . $cnv_upid . "' and convention_post_id='" . $convention_post_id . "'");
    $count = mysql_num_rows($query);
    if ($count > 0) {
        /*$food1 =implode(",", $food);
        		$hall_suitable_for1 =implode(",", $hall_suitable_for);
        		$technical_equipment1 = implode(",", $technical_equipment);*/
        $usrData = array('space_available_for' => $space_available_for, 'other_services' => $other_services, 'additional_services' => $additional_services);
        update($usrData, 'convention_post_add', "WHERE convention_post_id=" . $convention_post_id . " and cnv_upid=" . $_SESSION['cnv_upid']);
        $result['status'] = "success";
        $result['convention_post_id'] = $convention_post_id;
        echo json_encode($result);
    } else {
        echo json_encode(array("status" => "failed"));
    }
} else {
    echo json_encode(array("status" => "failed"));
}