Suco Posted July 28, 2009 Share Posted July 28, 2009 Hello, i am working on a project that has an edit form for a customer and i need to display the value i have already saved in the database in it. I can connect to the database just fine and pull it into the variable. Just don't know how to print it. $n holds the value i want from php that closes just before the form starts. <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> <title>Customer Edit Page</title> </head> <body> <h1 style="text-align: center;">Customer Information</h1> <div style="text-align: center;"> </div> <hr style="width: 100%; height: 2px; margin-left: auto; margin-right: auto;"> <div style="text-align: center;"> <?php $id = $_REQUEST["id"]; $db_name="";//Database name $tb_name="CUSTOMERS"; //table name //connect to server and select database mysql_connect(')or die(mysql_error()); mysql_select_db("$db_name")or die(mysql_error()); $sql = "SELECT * FROM $tb_name WHERE CUST_ID = '$id'"; $result=mysql_query($sql); $name=mysql_fetch_array($result); var_dump($name); ?> <form method="post" action="editcust.php"> <p>First Name: <input name="custFirstname" id="custFirstname" size="20" text="" value="<?php=$n;?>" type="text"> Last Name: <input name="custLastname" id="custLastname" size="20" text="" value=<? $name[1] ?> type="text"> </p> <p>Street Address1: <input name="custStreet1" id="custStreet1" size="25" type="text">Street Address2: <input name="custStreet2" id="custStreet2" size="25" type="text"> City: <input name="custCity" id="custCity" size="25" type="text"></p> <p>Select State: <select name="custState" id="custState"> <option value="AL" selected="selected">Alabama</option> <option value="AK">Alaska</option> <option value="AZ">Arizona</option> <option value="AR">Arkansas</option> <option value="CA">California</option> <option value="CO">Colorado</option> <option value="CT">Connecticut</option> <option value="DE">Delaware</option> <option value="FL">Florida</option> <option value="GA">Georgia</option> <option value="HI">Hawaii</option> <option value="ID">Idaho</option> <option value="IL">Illinois</option> <option value="IN">Indiana</option> <option value="IA">Iowa</option> <option value="KS">Kansas</option> <option value="KY">Kentucky</option> <option value="LA">Louisiana</option> <option value="ME">Maine</option> <option value="MD">Maryland</option> <option value="MA">Massachusetts</option> <option value="MI">Michigan</option> <option value="MN">Minnesota</option> <option value="MS">Mississippi</option> <option value="MO">Missouri</option> <option value="MT">Montana</option> <option value="NE">Nebraska</option> <option value="NV">Nevada</option> <option value="NH">New Hampsire</option> <option value="NJ">New Jersey</option> <option value="NM">New Mexico</option> <option value="NY">New York</option> <option value="NC">North Carolina</option> <option value="ND">North Dakota</option> <option value="OH">Ohio</option> <option value="OK">Oklahoma</option> <option value="OR">Oregon</option> <option value="PA">Pennsylvania</option> <option value="RI">Rhode Island</option> <option value="SC">South Carolina</option> <option value="SD">South Dakota</option> <option value="TN">Tennessee</option> <option value="TX">Texas</option> <option value="UT">Utah</option> <option value="VT">Vermont</option> <option value="VA">Virginia</option> <option value="WA">Washington</option> <option value="WV">West Virginia</option> <option value="WI">Wisconsin</option> <option value="WY">Wyoming</option> </select> Zip: <input name="custZip" id="custZip" size="6"></p> <p> Phone Number: (XXXXXXXXXX) <input name="custPhone" id="custPhone" size="10"> Email:<input name="custEmail" id="custEmail" size="30"></p> <hr style="width: 100%; height: 2px;"> <p><input value="Reset" type="reset"> <input value="Submit" type="submit"></p> </form> <a href="file:index.html"> </a><a href="customerpage.php">Customer Home</a><br> </div> </body> </html> Link to comment https://forums.phpfreaks.com/topic/167725-html-form-box-default-value-problem/ Share on other sites More sharing options...
lonewolf217 Posted July 28, 2009 Share Posted July 28, 2009 you have a random quote here, not sure if its just a copy/paste error, but this code wont parse mysql_connect(')or die(mysql_error()); as for your question, <p>First Name: <input name="custFirstname" id="custFirstname" size="20" text="" value="<?php echo $n;?>" type="text"> Link to comment https://forums.phpfreaks.com/topic/167725-html-form-box-default-value-problem/#findComment-884499 Share on other sites More sharing options...
haku Posted July 28, 2009 Share Posted July 28, 2009 $n holds the value i want from php that closes just before the form starts. You have to create the variable $n before you can print it. Link to comment https://forums.phpfreaks.com/topic/167725-html-form-box-default-value-problem/#findComment-884539 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.