problem in insert file name at the db

[like_php]

hello for all

I want make uploading center and save the file information at the database

but the db doesnt accept the file info:

this is my code:

$file_name=$_FILES['lie_file']['name'];
$file_type=$_FILES['lie_file']['type'];
$file_tmp=$_FILES['lie_file']['tmp_name'];
$file_size=$_FILES['lie_file']['size'];
mysql_query("INSERT INTO table_name  			  VALUES('','$lie_subject','$lie_text','$file_name','$file_size','$lie_writer')") 

its work very good with the $POST method but in $FILES dont work

hope can help

[bradgrafelman]

Are there any PHP errors? Are there any MySQL errors? Have you tried echo'ing out the query?

[like_php]

no there are not any php or mysql error but i trued echo the $file_name=$_FILES['lie_file']['name']; variable and didt give me anything

thanks and regards

[bradgrafelman]

What is the value of display_errors and error_reporting (found in phpinfo()) ?

Also, can you show us the HTML source of the form that uploads the file?

[Weedpacket]

And did you try echoing out the value of $_FILES['lie_file']['error'] to see if that had recorded anything?

[like_php]

this my html code:

<form method="post" action="lie_inserting.php" name="lie_form">
				<table style="width: 100%" class="content">
					<tr>
						<td style="width: 87px" class="title">
						<span lang="en-us">article subject</span><span lang="ar-jo">:</span></td>
						<td>&nbsp;<input name="lie_subject" type="text" size="30" class="content"></td>
					</tr>
					<tr>
						<td style="width: 87px">
						<span lang="en-us"><span class="title">article text</span></span><span lang="ar-jo" class="title">:</span>&nbsp;</td>
						<td>&nbsp;<textarea name="lie_text" style="width: 433px; height: 126px" class="content"></textarea></td>
					</tr>
					<tr>
						<td style="width: 87px" class="title">
						<span lang="en-us">article writer</span><span lang="ar-jo">:</span></td>
						<td>
						<input name="lie_writer" type="text" size="30" class="content"></td>
					</tr>
					<tr>
						<td style="width: 87px"><span lang="en-us">fle:</span></td>
						<td>
						<input name="lie_file" type="file" size="30" style="height: 22px" onkeypress="file_onclick()" class="content">&nbsp;</td>
					</tr>
				</table>
				<input name="Button1" type="submit" value="submit"><br>
			</form>

I try echoing $_FILES[''lie_file']['error'] but didn't give me anything.

about display_errors and error_reporting() didnt know how should the function wrote.

thanks and regards

[scross]

Change your form tag from:

<form method="post" action="lie_inserting.php" name="lie_form">

to:

<form enctype="multipart/form-data" method="post" action="lie_inserting.php" name="lie_form">

and before your file input add:

<input type="hidden" name="MAX_FILE_SIZE" value="30000" />

The value is in bytes so you can change it as you desire. You can find the php manual page on file uploads here: http://www.php.net/features.file-upload