problem uploading a file to database

irishgirl2004

Hi,
I am trying to copy a file into a database, i am using the following code

echo $_FILES['cv']['size'];
$file = addslashes(fread(fopen($_FILES['cv']['tmp_name'],"r"), $_FILES['cv']['size']));
$file = base64_encode($file);

mysql_connect(localhost,"***","***");
@mysql_select_db("xxxx") or die( "Unable to select database");
$query = "INSERT INTO employees VALUES ('',$sal ,$fullname, $address1,$address2, $jobtype, $other,$email, $commnets,'cv',$username,$password)";
$query = "INSERT INTO employees VALUES ('','$sal' ,'$name','$address1','$address2', '$jobtype', '$other','$email' ,'$phone', '$comments','$file','$username','$password')";

[code=php]


but i get the following message


Warning: fopen(smtp1.zip): failed to open stream: No such file or directory in /home/httpd/vhosts/httpdocs/php/register2.php3 on line 38

Warning: fread(): supplied argument is not a valid stream resource in /home/httpd/vhosts/httpdocs/php/register2.php3 on line 38
done


am i doing something very silly?


thanks

halojoy

php can not find that temp file in that temp directory
the second error comes from this ( can not read a non existent file )
what is the reason for this, I do not know
http://php.net/features.file-upload

Can it be that 'cv' is not the name of file in submit form?
Here is a sample of form from manual:

<!-- The data encoding type, enctype, MUST be specified as below --> 
<form enctype="multipart/form-data" action="__URL__" method="POST">
     <!-- MAX_FILE_SIZE must precede the file input field -->
     <input type="hidden" name="MAX_FILE_SIZE" value="30000" />
     <!-- Name of input element determines name in $_FILES array -->
     Send this file: <input name="userfile" type="file" />
     <input type="submit" value="Send File" /> 
</form>

irishgirl2004

CV is in the html, i can view the file name by putting in the following line

echo echo $_FILES['cv']['name'];

strange?

halojoy

there is a special FILE error, you could try display

/***
Since PHP 4.2.0, PHP returns an appropriate error code along with the file array. 
The error code can be found in the error segment of the file array that is created during the file upload by PHP. 
In other words, the error might be found in 
$_FILES['userfile']['error'].
***/

you have a number of small errors in your mysql query
but error comes before this, so shouldn't matter for now

so what does you upload <form> look like?

irishgirl2004

here is the html the revelvant html....i think its ok?

<form enctype="multipart/form-data" action="register2.php3" method="POST"> 
<table>
<tr>
<td class="oneforty">
<p class="raligntxt">Name</p></td>
<td>
<select name="sal">
<option value="Mr">Mr</option>
<option value="Mrs">Mrs</option>
<option value="Ms">Ms</option>
</select>
<input name="fullname" type="text" class="twohundred">
</td>
</tr>
<tr>
<td><p class="raligntxt">Address</p></td>
<td><input name="address1" type="text" class="twohundred"></td>
</tr>
<tr>
<td></td>
<td><input name="address2" type="text" class="twohundred"></td>
</tr>
<tr>
<td><p class="raligntxt">Required Position</p></td>
<td><select name="jobtype">
<option value="Chief Operations Manager">Chief Operations Manager</option>
<option value="The Guy Who Counts The Pills">The Guy Who Counts The Pills</option>
</select></td>
</tr>
<tr>
<td><p class="raligntxt">Other</p></td>
<td><input name="other" type="text" class="twohundred"></td>
</tr>
<tr>
<td><p class="raligntxt">Phone Number</p></td>
<td><input name="phone" type="text" class="twohundred"></td>
</tr>
<tr>
<td><p class="raligntxt">Email Address</p></td>
<td><input name="email" type="text" class="twohundred"></td>
</tr>
<tr>
<td><p class="raligntxt">Comments</p></td>
<td><textarea name="comments" rows="5" cols="24" class="commentbox"></textarea></td>
</tr>
<tr>
<td><p class="raligntxt">Attach your C.V</p></td>
<td>
   <input type="file" name="cv"> 
      </td>
</tr>
<tr>
<td><p class="raligntxt">Select Username*</p></td>
<td><input name="username" type="text" class="twohundred"></td>
</tr>
<tr>
<td><p class="raligntxt">Select Password*</p></td>
<td><input name="password" type="password" class="twohundred"></td>
</tr>
<tr>
<td><p class="raligntxt">Retype Password*</p></td>
<td><input name="password2" type="password" class="twohundred"></td>
</tr>
<tr>
<td></td>
<td><p class="tinytext">*Username and password used must be 6 characters or more</p></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="Proceed" name="submit" /></td>
</tr>
</table>
</form>
<h1>Members Login</h1>
<p>Already a PharmacyOne Employee member? Simply <a href="http://www.mushatts.com/pharmacy/members.shtml" class="redlink">login here</a> to proceed.</p>


<!--#include virtual="footer.shtml"--></div>
<div id="rightcol"><!--#include virtual="rightcol.txt"--></div>
</div>

</body>
</html>

[code=php]

halojoy

Yeah,
I say like you: 'Strange'.
We have to wait to someone else solves this case 🙂

paulnaj

Hi,

This is just a guess ... but can fopen() be used on zip files directly? I'd be pretty amazed if fopen() could do the decompression ... but I'm not sure.

Paul 🙂

halojoy

think I found problem
tmp_name is not same as filename, including path
you might have to add path to upload_tmp_dir
this is a setting in php.ini -> see with phpinfo()
I think, you should open this file for reading

$filename = get_cfg_var( 'upload_tmp_dir' ) . '/' 
. $_FILES[ 'cv' ][ 'tmp_name' ];

Hope I am right
😕