// use named placeholders
$sql = 'INSERT INTO images (filename, caption)
VALUES (:filename, :caption)';
$stmt = $conn->prepare($sql);
$stmt->bindParam(':filename', $names[0], PDO::PARAM_STR);
$stmt->bindParam(':caption', $_POST['caption'], PDO::PARAM_STR);
$stmt->execute();
// use rowCount() to get the number of affected rows
$imageOK = $stmt->rowCount();
}
// get the image's primary key or find out what went wrong
if ($imageOK) {
// lastInsertId() must be called on the PDO connection object
$image_id = $conn->lastInsertId();
} else {
$imageError = implode(' ', $loader->getMessages());
}
} elseif (isset($_POST['image_id']) && !empty($_POST['image_id'])) {
// get the primary key of a previously uploaded image
$image_id = $_POST['image_id'];
}
// don't insert blog details if the image failed to upload
if (!isset($imageError)) {
// create SQL
$sql = 'INSERT INTO blog (image_id, title, article)
VALUES(:image_id, :title, :article)';
// prepare the statement
$stmt = $conn->prepare($sql);
// bind the parameters
// if $image_id exists, use it
if (isset($image_id)) {
<?php
use PhpSolutions\File\Upload;
// set the maximum upload size in bytes
$max = 51200;
if (isset($_POST['upload'])) {
// define the path to the upload folder
$destination = 'C:/upload_test/';
require_once '../PhpSolutions/File/Upload.php';
try {
$loader = new Upload($destination);
$loader->upload();
$result = $loader->getMessages();
} catch (Exception $e) {
echo $e->getMessage();
}
}
?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<title>Upload File</title>
</head>
<body>
<?php
if (isset($result)) {
echo '<ul>';
foreach ($result as $message) {
echo "<li>{$message}</li>";
*/
// set the maximum upload size in bytes
use PhpSolutions\File\Upload;
// set the maximum upload size in bytes
$max = 60000 * 1024;
// 60 MB
if (isset($_FILES['uploadFile'])) {
// define the path to the upload folder
$destinationFile = 'uploads/file/';
try {
$loaderFile = new Upload($destinationFile, 'uploadFile');
$loaderFile->setMaxSize($max);
$loaderFile->allowAllTypes();
$loaderFile->upload();
$uploadFile1 = $loaderFile->getName();
$resultFile = $loaderFile->getMessages();
$_SESSION['uploadFile'] = $uploadFile1;
} catch (Exception $e) {
echo $e->getMessage();
}
if (!empty($uploadFile1)) {
$uploadsFile = $destinationFile . $uploadFile1;
} else {
$uploadsFile = "";
}
}
/*if (isset($_FILES['uploadBill'])) {
// define the path to the upload folder
$destinationBill = 'uploads/bill/';
try {
$loaderBill = new Upload($destinationBill, 'uploadBill');
