newbiehacker Posted August 2, 2006 Share Posted August 2, 2006 HI how can you fill a form from a database? I have textboxes and need to pull the data from the database into the textboxes. I know how to create the querys but cant seem to figure out how to get the data into those boxes. PLEASE HELP Quote Link to comment Share on other sites More sharing options...
legohead6 Posted August 2, 2006 Share Posted August 2, 2006 heres a simple editing datascript! just replace the wrong info and add remve boxes... Edit: MAde extremely basic[color=red][b]EDIT:2 added a } before the form[/b][/color][code]<?PHPsession_start();$user=$_SESSION['user'];$username="**********";$password="*******";$database="************";mysql_connect(localhost,$username,$password);@mysql_select_db($database) or die( "Unable to select database");$query2="SELECT * FROM listings WHERE id='$id'";$result2 = mysql_query($query2) or die ("Error in query: $query2. ".mysql_error());while($row = mysql_fetch_row($result2)){//All the field you want to show in text boxes$title=$row[1];$price=$row[2];$des=$row[3];}//the formecho "<form method=POST enctype='multipart/form-data'>Title<input type=text name=title value=$title><br><br>Price<input type=test name=price value=$price><br><br>$pic Description<br><textarea name=des>$des</textarea><br><input type=submit name=submit value=Update!></form>";//the acculy editing of databaseif(isset($_POST['submit'])){$tit=$_POST['title'];$pri=$_POST['price'];$desc=$_POST['des'];//the rows in the databse are case sensitive!$query="UPDATE listings SET title='$tit', price='$pri', description='$desc' WHERE id='$lid'";$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());echo "<p><b>Listing Successfully Updated!</b></p>";}?>[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.