little help with this simple one

mistercash60000

I have an upload form:

when it has done his upload it gives what the filename was that is uploaded.

Now I want to store the filename in my database.

I want to do this with a variable

like:
$filename= http_post_files['file']['name'];
and then insert into tbl (files) values ('$filename');
But this gives an error does somebody know how to do this
I think this is something very simple but not for me héhé

Thanks in advance

artisticre

post the error you are getting. I could be anything but without there error, it is hard to direct you in the right direction

mistercash60000

This is the error:
Parse error: parse error in /data/members/free/tripod/nl/m/i/s/mistercash600000/htdocs/temp/addmovie.php on line 32

my code:

<html>
<head>
<title>Insert Movies</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#999999" text="#FFCC33" link="#FFCC33" vlink="#FFCC33" alink="#FF0000">
<div align="center"><strong><font size="7">Add a Movie </font></strong><font size="7"></font> 
</div>
<?php
if($submit)
{
	$path = "image/";
	$max_size = 40000;

if (!isset($HTTP_POST_FILES['Cover'])) exit;

if (is_uploaded_file($HTTP_POST_FILES['Cover']['tmp_name'])) {

if ($HTTP_POST_FILES['Cover']['size']>$max_size) { echo "The file is too big<br>\n"; exit; }
if (($HTTP_POST_FILES['Cover']['type']=="image/gif") || ($HTTP_POST_FILES['Cover']['type']=="image/pjpeg") || ($HTTP_POST_FILES['Cover']['type']=="image/jpeg")) {


if (file_exists($path . $HTTP_POST_FILES['Cover']['name'])) { echo "The file already exists<br>\n"; exit; }
$res= copy($HTTP_POST_FILES['Cover']['tmp_name'], $path .
$HTTP_POST_FILES['Cover']['name']);
if (!$res) { echo "upload failed!<br>\n"; exit; } else { echo "upload sucessful<br>\n"; }

echo "File Name: ".$HTTP_POST_FILES['Cover']['name']."<br>\n";
echo "File Size: ".$HTTP_POST_FILES['Cover']['size']." bytes<br>\n";
echo "File Type: ".$HTTP_POST_FILES['Cover']['type']."<br>\n";
$Cover2 = . HTTP_POST_FILES['Cover']['name'];<=======This is line 32!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
} else { echo "Wrong file type<br>\n"; exit; }

}
$OwnerID=1;

$db = mysql_connect("localhost", "xxxx","");
mysql_select_db("xxxx",$db);
$sql = "insert into tblmovies (Mediatype,Rating,Title,Director,Producer,Country,Category,Year,Length,Actors,Url,Description,Comments,Videoformat,Videobitrate,Audioformat,Audiobitrate,Language,Subtitle,Disks,OwnerID,Cover) VALUES ('$Mediatype','$Rating','$Title','$Director','$Producer','$Country','$Category','$Year','$Length','$Actors','$Url','$Description','$Comments','$Videoformat','$Videobitrate','$Audioformat','$Audiobitrate','$Language','$Subtitle','$Disks','$OwnerID',$Cover2)";
$result = mysql_query($sql,$db) or
	die(mysql_error());
echo "Thank you! Information entered.\n";
}
?>





<form action="<?php echo $PHP_SELF?>" enctype="multipart/form-data" method="POST">
<table width="100%">
	<tr>
		<td colspan="3"><div align="center"><font size="5"><strong>Title</strong></font>&nbsp;<input name="Title" type="text" size="90"></div></td>
	</tr>
</table>
<img src="../images/line.gif" width="100%">
<table width="100%">
	<tr>

  <td rowspan="9" colspan="2" align="center" valign="middle"><strong>Upload 
    Cover:&nbsp; 
    <input name="Cover" type="file" size="60">
	</strong></td>		
	<td colspan="2"><div align="center"><font size="5"><strong>Movie Info</strong></font></div></td>
</tr>
<tr>

  <td width="28%"><strong>Rating:</strong>&nbsp; 
    <select name="Rating">
      <option value="0" selected>Not Yet Seen</option>
      <option value="1">1</option>
      <option value="2">2</option>
      <option value="3">3</option>
      <option value="4">4</option>
      <option value="5">5</option>
      <option value="6">6</option>
      <option value="7">7</option>
      <option value="8">8</option>
      <option value="9">9</option>
      <option value="10">Very good movie</option>
    </select></td>

  <td width="25%"><strong># CD's:</strong>&nbsp; 
    <select name="Disks">
      <option value="1" selected>1</option>
      <option value="2">2</option>
      <option value="3">3</option>
      <option value="4">4</option>
      <option value="5">5</option>
      <option value="6">More...</option>
    </select>
	</td>
</tr>
<tr><td colspan="2"><strong>Producer:&nbsp;<input name="Producer" type="text" size="60"></strong></td></tr>
<tr><td colspan="2"><strong>Director:&nbsp;&nbsp;<input name="Director" type="text" size="60"></strong></td></tr>
<tr><td colspan="2"><strong>Category:&nbsp;<input type="text" name="Category" size="60"></strong></td><td width="1%"></td></tr>
<tr><td colspan="2"><strong>Country:&nbsp;<input type="text" name="Country" size="60"></strong></td></td></tr>
<tr><td colspan="2"><strong>Year:&nbsp;<input type="text" name="Year"></strong></td></tr>
<tr><td colspan="2"><strong><div align="top">Actors:</div>
    <textarea name="Actors" cols="60" rows="5"></textarea>
    </strong></td></tr>
<tr><td colspan="2"><strong>URL:&nbsp;<input name="Url" type="text" size="60"></strong></td></tr>
<tr><td colspan="4"><strong><div align="top">Description:&nbsp;</div>
    <textarea name="Description" cols="120" rows="5"></textarea>
    </strong></td></td></tr>
<tr><td colspan="4"><strong><div align="top">Comments:&nbsp;</div>
	<textarea name="Comments" cols="120" rows="5"></textarea>
	</strong></td></tr>
<tr><td colspan="4"><div align="left"><strong><font size="5">Technical Info</font></strong></div></td></tr>
<tr><td colspan="4">&nbsp;</td></tr>
<tr>
	<td colspan="2"><strong>Videoformat:&nbsp;
	<select name="Videoformat">
		<option value="ASF">ASF</option>
		<option value="AVI">AVI</option>
		<option value="DivX" selected>DivX</option>
		<option value="DivX 3">DivX 3</option>
		<option value="DivX 4">DivX 4</option>
		<option value="DivX 5">DivX 5</option>
		<Option value="DVD">DVD</Option>
		<option value="DVD Zone 1">DVD Zone 1</option>
		<option value="DVD Zone 2">DVD Zone 2</option>
		<option value="DVD Zone 3">DVD Zone 3</option>
		<option value="DVD Zone 4">DVD Zone 4</option>
		<option value="DVD Zone 5">DVD Zone 5</option>
		<option value="DVD Zone 6">DVD Zone 6</option>
		<option value="MPEG1">MPEG1</option>
		<option value="MPEG1/VideoCD">MPEG1/VideoCD</option>
		<option value="MPEG2">MPEG2</option>
		<option value="MPEG2/DVD">MPEG2/DVD</option>
		<option value="MPEG2/SuperVideoCD">MPEG2/SuperVideoCD</option>
		<option value="MPEG4">MPEG4</option>
		<option value="QuickTime">QuickTime</option>
		<option value="Real">Real</option>
		<option value="SVHS">SVHS</option>
		<option value="VHS">VHS</option>
		<option value="VHS NTSC">VHS NTSC</option>
		<option value="VHS PAL">VHS PAL</option>
		<option value="VHS Secam">VHS Secam</option>
		<option value="VHS-C">VHS-C</option>
		<option value="Video8">Video8</option>
		<option value="WindowMedia">WindowMedia</option>
		<option value="XviD">XviD</option>
	</select></strong></td>
	<td><strong>Bitrate of:&nbsp;<input type="text" name="Videobitrate"></strong></td>
	<td><strong>Length:&nbsp;<input name="Length" type="text" size="15">
    Mins</strong></td>
</tr>
<tr>
	<td colspan="2"><strong>Audioformat:&nbsp;
	<select name="Audioformat">
		<option value="AC3">AC3</option>
		<option value="DVD">DVD</option>
		<option value="DVD AC3">DVD AC3</option>
		<option value="DVD Dolby Digital 5.1">DVD Dolby Digital 5.1</option>
		<option value="DVD Dolby Prologic">DVD Dolby Prologic</option>
		<option value="DVD DTS">DVD DTS</option>
		<option value="DVD Mono">DVD Mono</option>
		<option value="DVD Stereo">DVD Stereo</option>
		<option value="MPEG Layer 3 (MP3)" selected>MPEG Layer 3 (MP3)</option>
		<option value="MPEG1/VideoCD">MPEG1/VideoCD</option>
		<option value="MPEG2/DVD">MPEG2/DVD</option>
		<option value="RealAudio">RealAudio</option>
		<option value="VHS">VHS</option>
		<option value="VHS Mono">VHS Mono</option>
		<option value="VHS Stereo">VHS Stereo</option>
		<option value="VHS Stereo-Nicam">VHS Stereo-Nicam</option>
		<option value="WMA">WMA</option>
	</select></strong></td>
	<td><strong>Bitrate of:&nbsp;<input type="text" name="Audiobitrate"></strong></td>
</tr>
<tr>
	<td colspan="2"><strong>Language:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<select name="Language">
		<option value="<NONE>"><NONE></option>
		<option value="Chinese">Chinese</option>
		<option value="Dutch">Dutch</option>
		<option value="English" selected>English</option>
		<option value="French">French</option>
		<option value="German">German</option>
		<option value="Japanese">Japanese</option>
		<option value="Other">Other Language</option>
	</select></strong></td>
	<td><strong>Subtitle:&nbsp;&nbsp;&nbsp;
	<select name:"Subtitle">
		<option value="<NONE>"><NONE></option>
		<option value="Chinese">Chinese</option>
		<option value="Dutch">Dutch</option>
		<option value="English" selected>English</option>
		<option value="French">French</option>
		<option value="German">German</option>
		<option value="Japanese">Japanese</option>
		<option value="Other">Other Language</option>
	</select></strong></td>
	<td><strong>MediaType:&nbsp;
	<select name="Mediatype">
		<option value="CD-ROM" selected>CD-ROM</option>
		<option value="DVD">DVD</option>
		<option value="Laserdisc">Laserdisc</option>
		<option value="Super Video CD">Super Video CD</option>
		<option value="VHS">VHS</option>
		<option value="Video CD">Video CD</option>
	</select></strong></td>
</tr>
<tr><td colspan="4">&nbsp;</td></tr>
<tr>
	<td colspan="2" align="right"><input type="submit" value="Add Movie to Database" name="submit"></td>
	<td colspan="2" align="left"><input type="reset" value="Reset everything"></td>
</tr>
</table>
</form>




</body>
</html>

I hope this helps

webdes03

I suppose you could try:

$Cover2 .= HTTP_POST_FILES['Cover']['name'];

Although it probably wouldn't make much of a difference. Is the line above that really broken in the middle? That could be the source of your problem if it is:

if  (is_uploaded_file($HTTP_POST_FILES['Cover']['tmp_n
ame'])) {

mistercash60000

no that isn't broken in my page,

It fully works when I don't use
$Cover2=.http_post_files['Cover']['name']

I get then no errors

I will try the one you said

----edit:----

Have tried that thing you have said but still the same error

Weedpacket

Don't you mean .=?

mistercash60000

It still doesn't work
thanks for helping mates

do you have another solution?

------EDIT:-------

The thing is solved.

I have used this:

$Cover2= $_FILES['Cover']['name'];