[SOLVED] Upload script

[forumnz]

Could someone please tell me what is wrong with my script. It won't connect.

 

Cheers,

 

Sam.

 

<?php
require("config.php");
$path = "uploads/";
if (!isset($HTTP_POST_FILES['userfile'])){ echo "
<FORM ENCTYPE=multipart/form-data ACTION=?page=Upload METHOD=POST>

  <p>The file:<br>
    <INPUT TYPE=file NAME=userfile style='border: 1px solid #222222; background-color: #111111; color: #888888'>
  </p>
  Name: <br><input type=text name=name size=25 style='border: 1px solid #222222; background-color: #111111; color: #888888'>
  <p>
  Descritption:<br> <textarea cols=25 name=description style='border: 1px solid #222222; background-color: #111111; color: #888888'></textarea>
  </p>

  <p>
    <INPUT TYPE=submit VALUE=Upload style='border: 1px solid #222222; background-color: #111111; color: #888888'>
  </p>
</FORM>
"; }else{
if($name==NULL){ echo "<font color=red>Error!</font>: Please give you image a name<br><FORM ENCTYPE=multipart/form-data ACTION=?page=Upload METHOD=POST>


  <p>The file:<br>
    <INPUT TYPE=file NAME=userfile style='border: 1px solid #222222; background-color: #111111; color: #888888'>
  </p>
  Name: <br><input type=text name=name size=25 style='border: 1px solid #222222; background-color: #111111; color: #888888'>
  <p>
  Descritption:<br> <textarea cols=25' name=description style='border: 1px solid #222222; background-color: #111111; color: #888888'></textarea>
  </p>

  <p>
    <INPUT TYPE=submit VALUE=Upload style='border: 1px solid #222222; background-color: #111111; color: #888888'>
  </p>
</FORM>"; }else{
if (is_uploaded_file($HTTP_POST_FILES['userfile']['tmp_name'])) {
if (($HTTP_POST_FILES['userfile']['type']=="image/gif") || ($HTTP_POST_FILES['userfile']['type']=="image/pjpeg") || ($HTTP_POST_FILES['userfile']['type']=="image/jpeg")) {
if (file_exists($path . $HTTP_POST_FILES['userfile']['name'])) { echo "The file already exists, try calling your file a different name.<br>"; }else{
$res = copy($HTTP_POST_FILES['userfile']['tmp_name'], $path .
$HTTP_POST_FILES['userfile']['name']);
if (!$res) { echo "upload failed!<br>"; exit; } else { echo "upload sucessful<br><br>"; }
echo "File Name: ".$HTTP_POST_FILES['userfile']['name']."<br>";
echo "File Path: <a href=uploads/".$HTTP_POST_FILES['userfile']['name']." TARGET=_BLANK>uploads/".$HTTP_POST_FILES['userfile']['name']."</a><br>";
echo "File Size: ".$HTTP_POST_FILES['userfile']['size']." bytes<br>";
echo "File Type: ".$HTTP_POST_FILES['userfile']['type']."<br>";
echo "<img src=uploads/".$HTTP_POST_FILES['userfile']['name']."><br>";
//edit this for your database
mysql_connect (localhost, designervi_pho, *****);
mysql_select_db(designervi_pho) or die('Could not connect to the Database');
mysql_query("INSERT INTO table(`sender`, `type`, `name`, `description`, `url`) VALUES('$user','img','$name','$description','uploads/".$HTTP_POST_FILES[userfile][name]."')");

}}}}}


?>

[trq]

Try...

 

mysql_connect ("localhost", "designervi_pho", "*****");
mysql_select_db("designervi_pho") or die('Could not connect to the Database');

 

Also, be aware that $HTTP_POST_FILES has long been deprecated in favor of $_FILES.