Query not being executed
- by user2385241
I'm trying to create a script that allows me to upload an image, grab the details sent through inputs (a description and chosen project number) and insert this information into a table. I currently have this function:
public function NewEntry() {
$connect = new dbconnect;
$_SESSION['rnd'] = substr(number_format(time() * rand(),0,'',''),0,15);
$allowedExts = array("gif", "jpeg", "jpg", "png");
$size = $_FILES["file"]["size"];
$path = $_FILES["file"]["name"];
$extension = pathinfo($path, PATHINFO_EXTENSION);
$pr = $_POST['project'];
$cl = $_POST['changelog'];
$file = $_SESSION['rnd'] . "." . $extension;
if (in_array($extension, $allowedExts) && $size < 200000000) {
if ($_FILES["file"]["error"] == 0) {
if (!file_exists("../uploads/" . $_SESSION['rnd'])) {
move_uploaded_file($_FILES["file"]["tmp_name"], "../uploads/" . $_SESSION['rnd'] . "." . $extension);
}
}
} else {
echo "File validation failed.";
}
$row = $connect->queryExecute("INSERT INTO entries(project,file,changelog)VALUES($pr,$file,$cl)");
header('location:http://www.example.com/admin');
}
When the form is posted the function runs, the image uploads but the query isn't executed.
The dbconnect class isn't at fault as it's untampered and has been used in past projects. The error logs don't give any output and no MySQL errors show. Any ideas?