繁花如伊
我首先将代码更改为 PDO，并且没有在没有任何反引号或“”的情况下插入数据库，而是按照注释部分中的建议，在将图像插入数据库时添加了反引号和“”。$conn->exec( "INSERT INTO car_detailss (car_name , imageOfcar) VALUES ('$carname', '$imagename')");现在我可以将图像插入到我的数据库中。我也在这里更新了我的代码。我的代码：<!doctype html><html> <head> <title>Test</title> </head> <body> <form method="post" enctype="multipart/form-data"> <input type="file" name="userfile[]" multiple="" /> <input type="submit" name="submit" value="upload" /> </form> <?php $servername="localhost"; $username="root"; $password = ""; $dbname="image_upload"; try { $conn = new PDO("mysql:host=$servername;dbname=$dbname",$username, $password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // begin the transaction $conn->beginTransaction(); $phpFileUploadErrors = array( 0 => "There is no error, the file uploaded with success", 1 => "The uploaded file exceeds the upload_max_filesize directive in php.ini", 2 => "The upload file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form", 3 => "The upload file was only partially uploaded", 4 => "No file was uploaded", 6 => "Missing a temporary folder", 7 => "Failed to write file to disk.", 8 => "A php extension stopped the file upload"); if(isset($_FILES['userfile'])) { $file_array = reArrayFiles($_FILES['userfile']); pre_r($file_array); for($i=0;$i<count($file_array);$i++) { $carname = $file_array[$i]["size"]; $tablename = "car_detailss"; $imagename = $file_array[$i]["name"]; $conn->exec( "INSERT INTO `car_detailss` (`car_name`, `imageOfcar`) VALUES ('$carname', '$imagename')"); } } $conn->commit(); echo "new records created succesfully"; } catch(PDOException $e) { // roll back the transaction if something failed $conn->rollback(); echo "Error: " . $e->getMessage(); } $conn = null; function reArrayFiles($file_post) { $file_ary = array(); $file_count = count($file_post['name']); $file_keys = array_keys($file_post); for ($i = 0; $i < $file_count; $i++){ foreach($file_keys as $key) { $file_ary[$i][$key] = $file_post[$key][$i]; } } return $file_ary;} function pre_r($array) { echo '<pre>'; print_r($array); echo '</pre>'; } ?> </body></html>