Jump to content

Option

ecabrera

By ecabrera
in PHP Coding Help

 Share

Recommended Posts

ecabrera Advanced Member

ecabrera

Posted
Posted

how would i render this

 

<select name="state" value="<?php echo $state; ?>">
<option>Select a state</option>
<option value="AL">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="DC">District Of Columbia</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 Hampshire</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>

Link to comment
Share on other sites
ecabrera Advanced Member

ecabrera

Posted
  • Author
Posted

ok i making a user account so user can change there state if they ever move to other here

which means they can chose form different other states

 

<?php

require ("scripts/connect.php");

$query = mysql_query("SELECT * FROM users WHERE email='$email'");
	$numrows = mysql_num_rows($query);
	if ($numrows == 1){
		$row = mysql_fetch_assoc($query);
		$id = $row['id'];
		$first = $row['firstname'];
		$last = $row['lastname'];
		$email = $row['email'];
		$phone = $row['phone'];
		$address = $row['address'];
		$city = $row['city'];
		$state = $row['state'];
		$zip = $row['zip'];
	}
	else
		echo "An error occured while connecting to the database.";

?>

<div id="userid">
<center><h2><?php echo $first; ?> Account</h2></center>

<div id="useraccount">

<?php

require ("scripts/connect.php");

if($_POST['savebutton']){

$msg = "";

$first = $_POST['name'];
$last = $_POST['last'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$phone = preg_replace('#[^0-9]#i', '', $phone);
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$zip = $_POST['zip'];

if($first && $last && $email){

$update = mysql_query("UPDATE users SET firstname='$first',lastname='$last',email='$email',
phone='$phone',address='$address',city='$city',state='$state',zip='$zip' WHERE id='$id'");

$msg = "Changes Save";

}else
    $msg = "YOU MUST FILL IN ALL THREE";
}

mysql_close();

?>

<form action="useraccount.php" method="post">
<table>
<tr>
<td></td>
<td><?php echo $msg; ?></td>
</tr>
<tr>
<td>First Name</td>
<td><input type="text" name="name" value="<?php echo $first; ?>" /></td>
</tr>
<tr>
<td>Last Name</td>
<td><input type="text" name="last" value="<?php echo $last; ?>" /></td>
</tr>
<tr>
<td>Email:</td>
<td><input type="text" name="email" value="<?php echo $email; ?>" /></td>
</tr>
<tr>
<td>Phone:</td>
<td><input type="text" name="phone"  maxlength="10" value="<?php echo $phone; ?>" /></td>
</tr>
<tr>
<td>Address:</td>
<td><input type="text" name="address" value="<?php echo $address; ?>" /></td>
</tr>
<tr>
<td>City:</td>
<td><input type="text" name="city" value="<?php echo $city; ?>" /></td>
</tr>
<tr>
<td>State:</td>
<td>
<select name="state">
<option>Select a state</option>
<option value="<?php echo $state; ?>"><?php echo $state; ?></option>
<option value="AL">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="DC">District Of Columbia</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 Hampshire</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>
</td>
</tr>
<tr>
<td>Zip Code</td>
<td><input type="text" name="zip" maxlength="10" size="8" value="<?php echo $zip; ?>" /></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="savebutton" value="SAVE CHANGES" /></td>
</tr>
</table>
</form>
</div>

</div>

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.