Please check this out:
<?
$dbhost = "localhost";
$dbuser = "designers_hub";
$dbpwd = "";
$dbname = "shoppinglist";
$database = mysql_connect($dbhost, $dbuser, $dbpwd) or die ("Could not connect to mysql");
mysql_select_db("$dbname",$database) or die ("Could not select databases");
$id = $_POST['id'];
$name = $_POST['name'];
$description = $_POST['description'];
$stock = $_POST['stock'];
$cost = $_POST['cost'];
$payment_to = $_POST['payment_to'];
$image_name = $_POST['image_name'];
$image = $_POST['image'];
copy ($image, "images/$image_name");
chmod ("images/$image_name", 777);
mysql_query("INSERT INTO `items` (`id`,`name`,`description`,`stock`,`cost`,`payment_to`,`image_name`) VALUES ('$id','$name','$description','$stock','$cost','$payment_to',`$image_name`)");
mysql_close();
?>
What this does it upload the selected file to a directory and make a record on a mysql database. For some reason it moves the file but doesn’t add a record. When I take out the $image_name and image_name in the mysql_query it works but then I can’t record on the database the file name. Can someone help>
