php - Struggling to get this to upload into my database -
// check status. if (!empty($_session[username])) { echo "hi, <b>$_session[username]</b>."; if ($_post['submit']) { //get file attributes $name = $_files['myfile']['name']; $tmp_name = $_files['myfile']['tmp_name']; if ($name) { //start upload process $location = "avatars/$name"; move_uploaded_file($tmp_name,$location); $query = mysql_query("update members set imagelocation='$location' username='$username'"); die("your image has been uploaded! <a href='dashboard.php'>back</a>"); } else die("please select file"); } echo "upload image: <form action='profile.php' method='post' enctype='multipart/formdata'> file: <input type='file' name='myfile'> <input type='submit' name='submit' value='upload'></form>"; }
its showing username fine, have correct tables , columns in db when hit upload nothing?
you can see logging in username: test password: test url: learning.iamdanbarrett.com
i think there problem in query
$query = mysql_query("update members set imagelocation='$location' username='$username'");
because not defining $username variable anywhere in script hence, query checking like
update members set imagelocation='$location' username ='';
Comments
Post a Comment