I am trying to create a form to handle information about a machine, as well as an option for adding and uploading a photo for the description. I know this should be easy, but I am new to php scripting and with a lot of study an effort, I’ve gotten the script to perform all the tasks except writing the file name for the $pic variable into the mysql database. Does anyone have any advice to help me get the uploaded file name to write into the database? Below is my code:
<?php include("settings.php"); // Connect to server and select database. mysql_connect("$hostname", "$username", "$password")or die("cannot connect"); mysql_select_db("$databasename")or die("cannot select DB"); $id = $_POST['id']; $name = $_POST['name']; $maker = $_POST['maker']; $year = $_POST['year']; $type = $_POST['type']; $serial = $_POST['serial']; $info = $_POST['info']; $sale = $_POST['sale']; $price = $_POST['price']; $history = $_POST['history']; $cond = $_POST['cond']; $pic = ($_FILES['pic']['name']); $target = "../uploads/"; $target = $target . basename( $_FILES['pic']['name']); // update data in mysql database $sql="UPDATE machines SET name='$name', maker='$maker', year='$year', type='$type', serial='$serial', info='$info', sale='$sale', price='$price', history='$history', cond='$cond', pic'$pic' WHERE id='$id'"; //echo $sql; $result=mysql_query($sql); if(move_uploaded_file($_FILES['pic']['tmp_name'], $target)) { echo "The file ". basename( $_FILES['pic']['name']). " has been uploaded"; } // if successfully updated. if($result){ header( 'Location: entry_finder.php' ) ; } else { echo "ERROR"; } ?>Missing the equal sign at the pic variable in the update