将文件上载插入Access数据库中的附件字段

Question

I’m attempting to upload a file and then move it into an Access database. The filed is named ‘Attachment’ and has the Attachment property. It works fine in Access.
It uploads onto the server fide but I cannot get it to insert into the database.

 <?php
 if ($_FILES["file"]["error"] > 0)
 {
 echo "Return Code: " . $_FILES["file"]["error"] . "<br>";
 }
 else
 {
 echo "File name: " . $_FILES["file"]["name"] . "<br>";
 echo "Type: " . $_FILES["file"]["type"] . "<br>";
 echo "Size: " . ($_FILES["file"]["size"] / 1024) . " kB<br>";
 echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br>";

 move_uploaded_file($_FILES["file"]["tmp_name"], "C:/AccessBackEnds/LiveDesk/Uploads/" . $_FILES["file"]["name"]);
 echo "Stored in: LiveDesk/Uploads/";
 }

 $file = "C:/AccessBackEnds/LiveDesk/Uploads/" . $_FILES["file"]["name"];

 $db = realpath('C:\AccessBackEnds\LiveDesk\LiveDeskBackEnd.accdb');
 $conn = odbc_connect("Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=$db",'','') or die ("Unable to connect to server");

 $input="INSERT INTO CallTracker (Attachment)
 VALUES
 (file($file))";
 $rs=odbc_exec($conn,$input);

 if (!$rs)
 {
 die('Error: ' . mysql_error());
 }
 ?> 

The error is Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'file(C:/AccessBackEnds/LiveDesk/Uploads/CdpPacket.inf)'., SQL state 37000 in SQLExecDirect in C:\xampp\htdocs\test\upload_file.php on line 26

Any help is appreciated, thanks.

Answer 1

PHP uses a temporary filename to store uploads, which is NOT the name of the file on the client's machine.

$file = "C:/AccessBackEnds/LiveDesk/Uploads/" . $_FILES["file"]["name"];
                                                               ^^^^^^^^

that should be ['tmp_name'] instead.

As well... does Ms Access have a file() function? I can't find any indication that it does.