pythonexec.php

<?php

$user = 'user';
$password = 'password';
$db = 'Database';
$host = 'localhost';
$port = 8889;

$link = mysql_connect(
   "$host:$port", 
   $user, 
   $password
);
$db_selected = mysql_select_db(
   $db, 
   $link
);

$target_dir = "cars/";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
$uploadOk = 1;
$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);
// Check if image file is a actual image or fake image
if(isset($_POST["submit"])) {
$check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);
$uploadOk = 1;
} else {
        echo "File is not an image.";
$uploadOk = 0;
}

// Check if file already exists
if (file_exists($target_file)) {
    echo "Sorry, file already exists.";
$uploadOk = 0;
}

// Allow certain file formats
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
&& $imageFileType != "gif" ) {
    echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
$uploadOk = 0;
}
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
    echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
    if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
        // echo "The file ". basename( $_FILES["fileToUpload"]["name"]). " has been uploaded.";
        echo " ";
} else {
        echo "Sorry, there was an error uploading your file.";
}
}
$target_file = "/Applications/MAMP/htdocs/" . $target_file;
$command = "python python_script.py";
$output = shell_exec($command ." ". $target_file);


if($output && $output != -1){
    $records = mysql_query("SELECT * FROM cars WHERE id = ".$output);
    
    while($row = mysql_fetch_array($records))
    {
        echo $row['Plate']."</br>";
        echo $row['Region']."</br>";
    }
} else if ($output == -1) {
    echo "Unable to connect to the database";
}
else {
    echo "output not working";
}
?>