Exemple #1
0
    $json = file_get_contents("http://maps.google.com/maps/api/geocode/json?address={$address}&sensor=false&region=USA");
    //echo "http://maps.google.com/maps/api/geocode/json?address=$address&sensor=false&region=USA";
    if ($json != "") {
        $json = json_decode($json);
        $lat = $json->{'results'}[0]->{'geometry'}->{'location'}->{'lat'};
        $lng = $json->{'results'}[0]->{'geometry'}->{'location'}->{'lng'};
        if ($lat == "" && $lng == "") {
            $lat = $json->{'results'}[0]->{'location'}->{'lat'};
            $lng = $json->{'results'}[0]->{'location'}->{'lng'};
        } else {
            if ($lat == "") {
                $lat = 'empty';
                $lng = 'empty';
            }
        }
    }
    //Generate UserName
    $userName = gUsername($fName, $lName);
    //Generate Password
    $pass = gPassword();
    /*if($Active == "true"){
    		$Active = 1;
    	} else {
    		$Active = 0;
    	}*/
    $query = "INSERT INTO drivers (dFirstName,dLastName, dPhoneNumber, dEmail, dLicenseNumber, dVehicleYear, dVehicleMake, dVehicleModel, dVehicleTag, dInsuranceCo, dInsurancePolicy, dUsername, dPassword, dActive, dStatusComment, dSchedule, lat, lng) \n\t\t\tVALUES ('{$fName}', '{$lName}', '{$phone}', '{$email}', '{$license}', '{$year}', '{$make}', '{$model}', '{$tag}', '{$insurance}', '{$policyNumber}', '{$userName}', '{$pass}', '{$Active}', '{$delNotes}', '{$schedule}', '{$lat}', '{$lng}')";
    //echo $query;
    $db->query($query);
    echo "<h2>Driver Added<h2>";
    echo "<h3>" . $userName . "</h3><h3> " . $pass . "</h3>";
}
Exemple #2
0
function gUsername($name, $last)
{
    include '../connection.php';
    if ($last == "recursive") {
        $userName = $name;
    } else {
        $userName = substr($name, 0, 1);
        $userName .= $last;
    }
    // Check if username is taken
    $query = 'SELECT * FROM drivers where dUsername = "******"';
    $sql = $db->query($query);
    $taken = $sql->num_rows;
    if ($taken > 0) {
        $number = rand(10, 999);
        $userName .= $number;
        return gUsername($userName, "recursive");
    } else {
        return $userName;
    }
}