PHP - Auto Updating Form Text Fields

Hello All:

Trying to work with PHP on a contact form with a jQuery Validation to make certain that the visitors fill out the required information. I'll try to show everything that I have, and then the error I am getting when the visitor hits "submit."

I don't know PHP all that well, and trying to learn my way through it. I used a couple of tutorials to add the features I needed and did my own styling on the live site.  Here is the PHP that is currently in the header of my markup:


<?php
//If the form is submitted
if(isset($_POST['submit'])) {

//Check to make sure that the First name field is not empty
if(trim($_POST['firstname']) == '') {
$hasError = true;
} else {
$firstname = trim($_POST['firstname']);
}
    
    //Check to make sure that the Last name field is not empty
if(trim($_POST['lastname']) == '') {
$hasError = true;
} else {
$lastname = trim($_POST['lastname']);
}
    
    //Check to make sure that the Street Address 01 field is not empty
if(trim($_POST['street01']) == '') {
$hasError = true;
} else {
$street01 = trim($_POST['street01']);
}
    
    //If Street02 is filled out, give it a value
    
    $street02  = $_POST['street02'];
    
    //Check to make sure that the City field is not empty
if(trim($_POST['city']) == '') {
$hasError = true;
} else {
$city = trim($_POST['city']);
}
    
    //Check to make sure that the State field is not empty
if(trim($_POST['state']) == '') {
$hasError = true;
} else {
$state = trim($_POST['state']);
}
    
    //Check to make sure that the Zip field is not empty
if(trim($_POST['zip']) == '') {
$hasError = true;
} else {
$zip = trim($_POST['zip']);
}
    
    //If Email is filled out, give it a value 
    
    $email  = $_POST['email'];
    
    //If Telephone is filled out, give it a value 
    
    $telephone  = $_POST['telephone'];
    
    //Default Subject Value 
    
    $subject  = "VMC Inquiry";
    
    //Check checkboxes 
    foreach($_POST['check']  as  $value)  {

$check_msg = "Checked: $value\n";

} 

    //If Message is filled out, give it a value 
    
    $comment  = $_POST['comment'];


//If there is no error, send the email
if(!isset($hasError)) {
$emailTo = 'xxxx.xxxx@gmail.com'; //Put your own email address here
$body = "Name: $firstname $lastname \n\nStreet Address: $street01 \n\nStreet Address*: $street02 \n\nCity: $city \n\nState: $state \n\nZip: $zip \n\nEmail*: $email \n\nTelephone*: $telephone \n\nCheck Box: $check_msg \n\nMessage:\n $comment";
$headers = 'From: XXXXX <'.$emailTo.'>' . "\r\n" . 'Reply-To: ' . $email;

mail($emailTo, $subject, $body, $headers);
$emailSent = true;
}
}
?>

So basically I am using classes to say whether or not something is required, which ties into the jQuery validation. If it isn't required, whatever the visitor types into the box is put into something like "$telephone" which is then printed in the e-mail.

The markup for the forms in the body is the following:

Code: [Select]
<p class="contact-text-right">For more information, or to have a list of our properties mailed to you, please fill out the form below.</p>
    <div id="contact-wrapper">
            <?php if(isset($hasError)) { //If errors are found ?>
        <p class="error">Please check if you've filled all the fields with valid information. Thank you.</p>
            <?php } ?>
            <?php if(isset($emailSent) && $emailSent == true) { //If email is sent ?>
            <p class="accept"><strong><?php echo $firstname;?>,Your Email Successfully Sent!</strong></p> <?php } ?>
    <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" id="contactform">
        <div id="names">
            <label for="firstname"><strong>First Name:</strong></label>
            <input type="text" name="firstname" id="firstname" value="" class="required" />
            <label for="lastname"><strong>Last Name:</strong></label>
            <input type="text" name="lastname" id="lastname" value="" class="required" />
        </div>
        <div id="address01">
            <label for="street01"><strong>Street Address:</strong></label>
            <input type="text" name="street01" id="street01" value="" class="required" />
        </div>
        <div id="address02">
            <label for="street02"><strong>Street Address*:</strong></label>
            <input type="text" name="street02" id="street02" value="" />
        </div>
        <div id="city">
            <label for="city"><strong>City:</strong></label>
            <input type="text" name="city" id="city" value="" class="required city" />
            <label for="state"><strong>State:</strong></label>
            <input type="text" name="state" id="state" value="" class="required state" />
            <label for="zip"><strong>Zip Code:</strong></label>
            <input type="text" name="zip" id="zip" value="" class="required zip" />
        </div>
        <div id="email">
            <label for="email"><strong>E-mail*:</strong></label>
            <input type="text" name="email" id="email" value="" class="email"/>
            <label for="telephone"><strong>Telephone*:</strong></label>
            <input type="text" name="telephone" id="telephone" value="" class="telephone" />
            <p class="bottom">*Optional fields.</p>
        </div>
        <div class="checkbox">
            <p><input  type="checkbox"  name="check[]"  value="properties">XXX</p> 
            <p><input  type="checkbox"  name="check[]"  value="contact-regarding">XXXX</p>
            <p class="indent">(Please list properties or ask specific questions in the space below.)</p>       
        </div>
        <div id="comment">
            <label for="comment"></label>
            <textarea name="comment" id="comment" ></textarea>
        </div>
        <div id="button">
        <input type="submit" value="Send Message" name="submit" />
        </div>
    </form>

All seems well until I hit submit on the live site. I think get this error returned to me:

Warning: Invalid argument supplied for foreach() in ......./html/development/contact.php on line 64

The e-mail goes through, with all the information, no problems! I just can't get this error message to go away.
Line 64 of contact.php is where the checkbox coding is:


    //Check checkboxes 
    foreach($_POST['check']  as  $value)  {

$check_msg = "Checked: $value\n";

} 


I know I've submitted a lot of code here, and tried to narrow you down to the exact spot I think the problem is, but hopefully some of you PHP gurus can pick out the flaw in a heartbeat.

I really appreciate all the help.

B

when i submit it, the only field that updates is the email field.

UserEdit.php file

<?
/**
 * UserEdit.php
 *
 * This page is for users to edit their account information
 * such as their password, email address, etc. Their
 * usernames can not be edited. When changing their
 * password, they must first confirm their current password.
 *
 */
include("include/session.php");
?>

<html>
<title>Edit Your Details</title>
<link rel="stylesheet" type="text/css" href="../assets/css/styles.css" />
<link rel="stylesheet" type="text/css" href="../assets/css/forms.css" />
<link rel="stylesheet" type="text/css" href="../assets/css/layout.css" />
<link rel="stylesheet" type="text/css" href="../assets/css/style.css" />
<style>
#form6 input{
margin:0;
width:250px;
border:1px solid #ddd;
padding:3px 5px 3px 25px;
}


input{
font:100% Trebuchet MS, Arial, Helvetica, Sans-Serif;
line-height:160%;
color:#FFF;
}
#form6 input{background:#000;
}
</style>
<body>

<?
/**
 * User has submitted form without errors and user's
 * account has been edited successfully.
 */
if(isset($_SESSION['useredit'])){
   unset($_SESSION['useredit']);
   
   echo "<h1>User Account Edit Success!</h1>";
   echo "<p><b>$session->username</b>, your account has been successfully updated. "
       ."<a href=\"index.php\">Main</a>.</p>";
}
else{
?>

<?
/**
 * If user is not logged in, then do not display anything.
 * If user is logged in, then display the form to edit
 * account information, with the current email address
 * already in the field.
 */
if($session->logged_in){
?>

<h2>User Account Edit : <? echo $session->firstname; ?></h2>
<?
if($form->num_errors > 0){
   echo "<td><font size=\"2\" color=\"#ff0000\">".$form->num_errors." error(s) found</font></td>";
}
?>
<form id="form6" action="process.php" method="POST">
<table align="left" border="0" cellspacing="0" cellpadding="3">
<tr>
<td>Email:</td>
<td><input type="text" name="email" maxlength="50" value="
<?
if($form->value("email") == ""){
   echo $session->userinfo['email'];
}else{
   echo $form->value("email");
}
?>">
</td>
<td><? echo $form->error("email"); ?></td>
</tr>
<tr>
<td>Phone:</td>
<td><input type="text" name="tel" maxlength="50" value="
<?
if($form->value("tel") == ""){
   echo $session->userinfo['tel'];
}else{
   echo $form->value("tel");
}
?>">
</td>
<td><? echo $form->error("tel"); ?></td>
</tr>
<tr>
<td>Address:</td>
<td>
<input type="text" name="address" maxlength="50" value="
<?
if($form->value("address") == ""){
   echo $session->userinfo['address'];
}else{
   echo $form->value("address");
}
?>" style="height: 138px">
</td>
<td><? echo $form->error("address"); ?></td>
</tr>
<tr>
<td>Company:</td>
<td><input type="text" name="company" maxlength="50" value="
<?
if($form->value("company") == ""){
   echo $session->userinfo['company'];
}else{
   echo $form->value("company");
}
?>">
</td>
<td><? echo $form->error("company"); ?></td>
</tr>
<tr><td colspan="2" align="right">
<input type="hidden" name="subedit" value="1">
<input type="submit" value="Edit Account"></td></tr>
<tr><td colspan="2" align="left"></td></tr>
</table>
</form>

<?
}
}

?>

</body>
</html>


sends to session.php
   /**
    * editAccount - Attempts to edit the user's account information
    * including the password, which it first makes sure is correct
    * if entered, if so and the new password is in the right
    * format, the change is made. All other fields are changed
    * automatically.
    */
   function editAccount($subcurpass, $subnewpass, $subemail, $subtel, $subaddress, $subcompany){
      global $database, $form;  //The database and form object

     /* New password entered */
      if($subnewpass){
         /* Current Password error checking */
         $field = "curpass";  //Use field name for current password
         if(!$subcurpass){
            $form->setError($field, "* Current Password not entered");
         }
         else{
            /* Check if password too short or is not alphanumeric */
            $subcurpass = stripslashes($subcurpass);
            if(strlen($subcurpass) < 4 ||
               !eregi("^([0-9a-z])+$", ($subcurpass = trim($subcurpass)))){
               $form->setError($field, "* Current Password incorrect");
            }
            /* Password entered is incorrect */
            if($database->confirmUserPass($this->username,md5($subcurpass)) != 0){
               $form->setError($field, "* Current Password incorrect");
            }
         }
         
         /* New Password error checking */
         $field = "newpass";  //Use field name for new password
         /* Spruce up password and check length*/
         $subpass = stripslashes($subnewpass);
         if(strlen($subnewpass) < 4){
            $form->setError($field, "* New Password too short");
         }
         /* Check if password is not alphanumeric */
         else if(!eregi("^([0-9a-z])+$", ($subnewpass = trim($subnewpass)))){
                     $form->setError($field, "* New Password not alphanumeric");
         }
      }
      /* Change password attempted */
      else if($subcurpass){
         /* New Password error reporting */
         $field = "newpass";  //Use field name for new password
         $form->setError($field, "* New Password not entered");
      }
      
      /* Email error checking */
      $field = "email";  //Use field name for email
      if($subemail && strlen($subemail = trim($subemail)) > 0){
         /* Check if valid email address */
         $regex = "^[_+a-z0-9-]+(\.[_+a-z0-9-]+)*"
                 ."@[a-z0-9-]+(\.[a-z0-9-]{1,})*"
                 ."\.([a-z]{2,}){1}$";
         if(!eregi($regex,$subemail)){
            $form->setError($field, "* Email invalid");
         }
         $subemail = stripslashes($subemail);
      }
      
      /* Errors exist, have user correct them */
      if($form->num_errors > 0){
         return false;  //Errors with form
      }
      
      /* Update password since there were no errors */
      if($subcurpass && $subnewpass){
         $database->updateUserField($this->username,"password",md5($subnewpass));
      }
      
      /* Change Email */
      if($subemail){
         $database->updateUserField($this->username,"email",$subemail);
      }
      /* Change Email */
      if($subtel){
         $database->updateUserField($this->username,"tel",$subtel);
      }
      /* Change Email */
      if($subaddress){
         $database->updateUserField($this->username,"address",$subaddress);
      }
      /* Change Email */
      if($subcompany){
         $database->updateUserField($this->username,"company",$subcompany);
      }
      
      /* Success! */
      return true;
   }


sends to database.php
   /**
    * updateUserField - Updates a field, specified by the field
    * parameter, in the user's row of the database.
    */
   function updateUserField($username, $field, $value){
      $q = "UPDATE ".TBL_USERS." SET ".$field." = '$value' WHERE username = '$username'";
      return mysql_query($q, $this->connection);
   }


think thats all you should need?

I have the following PHP script to update two time/date fields in the database.

When i run this the fields are not updated.

Can anyone see where i m going wrong.

<?php
$con = mysql_connect("localhost","dbname","dbpassword");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

echo 'Connected successfully';

mysql_select_db("my_db", $con);

mysql_query("UPDATE msm_content SET created = '2011-01-02 00:00:00', modified = '2011-01-01 00:00:00'");

echo 'Query Updated successfully';

mysql_close($con);
?>

Your guidance is much appreciated.

Hey guys,

I am a webmaster for my church and I am fairly new to PHP. What am trying to is when a visitor goes to our radio ministry page and clicks a button which the message number is displayed in the read only textbox, it will go to my request CD page and auto populate the message number in that text field form the readonly text field from the previous page. I will show my code for both pages for you to review.



This is the Radio page (where I want to take the message number value from)
Code: [Select]
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="Living Word Community Church radio ministry" />
    <meta name="keywords" content="reformed radio fort worth, reformed radio dallas, biblical radio fort worth, biblical radio dfw"  />
    <title>In Light of Scripture-Radio Ministry</title>
    <link href="_css/Main.css" rel="stylesheet" type="text/css" />
    <script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>

    <link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
    </head>

    <body>

    <div class="container">
    <div class="header"><a href="index.php"><img src="_images/LWCCWeb.jpg" alt="Insert Logo Here" name="Insert_logo" width="960" height="200" id="Insert_logo" style="background: #D8BF78; display:block;" /></a>
       <?php include("_includes/header.php"); ?>
    <div class="sidebar1">
        <p></p>
         <table width="150" border="0" cellpadding="10" align="left">
      <tr>
        <td><a href="directions.php"><img src="_images/ChurchBox.png" width="150" height="125" alt="Directions" /></a></td>
      </tr>
      <tr>
        <td><img src="_images/Service Times.png" width="150" height="778" alt="Service Times" /></td>
      </tr>
    </table>

        <!-- end .sidebar1 --></div>
     
    <div class="content">
       <div id="radio"></div>
        <table width="600" border="0" cellpadding="10">
      <tr>
        <td><img src="_images/ILOS.png" width="600" height="111" alt="In Light of Scripture" /></td>
        </tr>
         <tr>
             <td style=" padding-top:25px"><p><font size="5"><b>In Light of Scripture</b> has been locally broadcast for more
             than 25 years.<br />
              This Sunday morning radio program features the expositional teaching of Pastor Stan McGehee Jr.
             </font><p/></td>
          </tr>
       
        </table>
       
        <div id="mediagraph"><a href="http://kdkr.org" target="_blank"><img src="_images/kdkr.jpg" width="300" height="200" alt="Braodcast on KDKR 91.3 Sunday   
           Mornings at 7:30" /></a></div>
           
            <br  /><br  />
            <font size="2"><p align="center"><b>The sermon featured this week on "In Light of Scipture" is</b></p></font>
            <font size="2"><p align="center" style="color:#711726"><b><i>Peace Despite Tribulation</i></b></p></font>
            <div id="messagenumber" align="center">
            <form action="" method="get" name="messagenumber">
            <input name="" type="text" value="JR-843" size="6" readonly="readonly" />
            <input name="GetMessage" type="button" value="Get Message" />
            </form>
            </div>
        <!-- end .content --></div></div>
      <div class="sidebar2">
        <table width="150" border="0" cellpadding="16" align="left">
          <tr>
            <td><a href="reformation.php"><img src="_images/MenuBox1.png" width="150" height="125" alt="What Do We Mean by Reformed?" /></a></td>
          </tr>
          <tr>
            <td><a href="ServiceTimesAndCal.php"><img src="_images/MenuBox2.png" width="150" height="125" alt="Worship Service Schedule and Calendar" /></a></td>
          </tr>
          <tr>
            <td><a href="radio.php"><img src="_images/MenuBox3.png" width="150" height="125" alt="In Light of Scripture Radio Ministry" /></a></td>
          </tr>
          <tr>
            <td><a href="cable.php"><img src="_images/MenuBox4.png" width="150" height="125" alt="Living Word Today Cable Program" /></a></td>
          </tr>
          <tr>
            <td><a href="Sermons.php"><img src="_images/MenuBox5.png" width="150" height="125" alt="Listen to Sermons Online" /></a></td>
          </tr>
           <tr>
              <td><a href="http://www.lwcchurch.org/blog/" target="_blank"><img src="_images/MenuBox6.png" width=
               "150" height="125" alt="Read our reformed blog" /></a></td>
          </tr>
        </table>
       
        <!-- end .sidebar2 --></div>
        <?php include("_includes/footer.php"); ?>
      <!-- end .container --></div>
      <script type="text/javascript">
    var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
    var MenuBar2 = new Spry.Widget.MenuBar("MenuBar2", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
    </script>
    </body>
    </html>

This is for the CD request form. I want it to populate the Message# text field

    Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="Order Living Word Community Church sermons and teachings on CD" />
    <meta name="keywords" content="Stan McGehee cd, Reformed teachings on cd, Biblical teachings on cd, LWCC cds"  />
    <title>Order CD's Online</title>
    <link href="_css/Main.css" rel="stylesheet" type="text/css" />
    <link href="js/jquery.datepick.css" rel="stylesheet" type="text/css" />
    <script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
    <script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
    <link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript" src="jquery/jquery-1.5.js"></script>
    <script type="text/javascript" src="js/jquery.datepick.js"></script>
    <script src="SpryAssets/SpryValidationSelect.js" type="text/javascript"></script>
    <script src="SpryAssets/SpryValidationRadio.js" type="text/javascript"></script>
    <link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript">
       $(function() {
       $('#popupDatepicker').datepick();
       $('#inlineDatepicker').datepick({onSelect: showDate});
    });

    function showDate(date) {
       
    }

       </script>



    <link href="SpryAssets/SpryValidationSelect.css" rel="stylesheet" type="text/css" />
    <link href="SpryAssets/SpryValidationRadio.css" rel="stylesheet" type="text/css" />
    </head>

    <body>

    <div class="container">
    <div class="header"><a href="index.php"><img src="_images/LWCCWeb2.png" alt="Insert Logo Here" name="Insert_logo" width="960" height="200" id="Insert_logo" style="background: #D8BF78; display:block;" /></a>
       <?php include("_includes/header.php"); ?>
       
    <div class="sidebar1">
        <p></p>
         <table width="150" border="0" cellpadding="10" align="left">
      <tr>
        <td><a href="directions.php"><img src="_images/ChurchBox.png" width="150" height="125" alt="Directions" /></a></td>
      </tr>
      <tr>
        <td><img src="_images/Service Times.png" width="150" height="890" alt="Service Times" /></td>
      </tr>
    </table>

        <!-- end .sidebar1 --></div>
     
    <div class="content">
       &nbsp;
       <h2 style="padding-left:50px"> Order messages on CD from LWCC</h2>
       <div id"form">
       
        <form action="FormToEmail2.php" method="post">

       


        <table width="550" border="0" cellpadding="10">
         <tr>
           <td><table width="550" border="0" cellpadding="10">
      <tr>
        <td width="190">First Name:</td>
        <td width="314"><span id="spryfirstname">
        <input name="firstname" type="text" id="firstname" maxlength="20" />
        <span class="textfieldMaxCharsMsg">Too many letters</span><span class="textfieldRequiredMsg">Enter first name </span></span></td>
      </tr>
      <tr>
        <td>Last Name:</td>
        <td><span id="sprylastname">
        <input name="lastname" type="text" id="lastname" maxlength="20" />
        <span class="textfieldRequiredMsg">Enter last name</span><span class="textfieldMaxCharsMsg">Too many letters</span></span></td>
      </tr>
      <tr>
       <td>Email<font size="2"> (So we can confirm if needed)</font>:</td>
        <td><span id="spryemail">
        <input name="email" type="text" id="email" maxlength="50" />
        <span class="textfieldRequiredMsg">Enter Email</span><span class="textfieldInvalidFormatMsg">Must be Email.</span><span class="textfieldMaxCharsMsg">Email too long</span></span></td>
      </tr>
      <tr>
       <td>Street:</td>
        <td><span id="sprystreet"><span id="sprystreet">
        <input name="street" type="text" id="street" maxlength="50" />
        <span class="textfieldRequiredMsg">Enter Street Address</span><span class="textfieldMaxCharsMsg">Exceeded maximum number of characters.</span></span></td>
      </tr>
      <tr>
       <td>City:</td>
        <td><span id="sprycity"><span id="sprytextfield5">
        <input name="City" type="text" id="city" maxlength="50" />
        <span class="textfieldRequiredMsg">Enter your city</span><span class="textfieldMaxCharsMsg">Exceeded maximum number of characters.</span></span><span class="textfieldRequiredMsg">Enter Email</span><span class="textfieldInvalidFormatMsg">Must be Email.</span><span class="textfieldMaxCharsMsg">Email too lon</span></span></td>
      </tr>
       <tr>
       <td>Apartment number:</td>
        <td><span id="aptnum">
        <input name="Apt number" type="text" id="aptnum" maxlength="6" width="80px" />
        <span class="textfieldRequiredMsg">Enter Email</span><span class="textfieldInvalidFormatMsg">Must be Email.</span><span class="textfieldMaxCharsMsg">Email too long</span></span></td>
      </tr>
      <tr>
       <td>State:</td>
        <td><span id="spryselect1">
          <select name="statelist">
            <option value="null"></option>
            <option value="Alabama">AL</option>
            <option value="Alaska">AK</option>
            <option value="Arkansas">AR</option>
            <option value="Arizona">AZ</option>
            <option value="California">CA</option>
            <option value="Colorado">CO</option>
            <option value="Connecticut">CT</option>
            <option value="Deleware">DE</option>
            <option value="District of Columbia">DC</option>
            <option value="Florida">FL</option>
            <option value="Georgia">GA</option>
            <option value="Hawaii">HI</option>
            <option value="Idaho">ID</option>
            <option value="Iowa">IA</option>
            <option value="Illinois">IL</option>
            <option value="Indiana">IN</option>
            <option value="Kansas">KS</option>
            <option value="Kentucky">KY</option>
            <option value="Louisiana">LA</option>
            <option value="Massachusetts">MA</option>
            <option value="Maryland">MD</option>
            <option value="Maine">ME</option>
            <option value="Michigan">MI</option>
            <option value="Minnesota">MN</option>
            <option value="Missouri">MO</option>
            <option value="Mississippi">MS</option>
            <option value="Montana">MT</option>
            <option value="Nebraska">NE</option>
            <option value="New Hampshire">NH</option>
            <option value="New Jersey">NJ</option>
            <option value="New Mexico">NM</option>
            <option value="Nevada">NV</option>
            <option value="New York">NY</option>
            <option value="North Carolina">NC</option>
            <option value="North Dakota">ND</option>
            <option value="Ohio">OH</option>
            <option value="Oklahoma">OK</option>
            <option value="Oregon">OR</option>
            <option value="Pennslyvania">PA</option>
            <option value="Rhode Island">RI</option>
            <option value="South Carolina">SC</option>
            <option value="Tennessee">TN</option>
            <option value="Texas">TX</option>
            <option value="Utah">UT</option>
            <option value="Vermont">VT</option>
            <option value="Virginia">VA</option>
            <option value="Washington">WA</option>
            <option value="Wisconsin">WI</option>
            <option value="West Virginia">WV</option>
            <option value="Wyoming">WY</option>
          </select>
          <span class="selectRequiredMsg">Please select state</span></span></td>
      </tr>
      <tr>
       <td>Zip Code:</td>
        <td><span id="spryzip"><span id="sprytextfield6">
        <input name="Zip Code" type="text" id="zip" maxlength="50" />
        <span class="textfieldRequiredMsg">Enter Zip Code</span><span class="textfieldInvalidFormatMsg">Zip Code is 5 numbers.</span></span><span class="textfieldRequiredMsg">Enter Email</span><span class="textfieldInvalidFormatMsg">Must be Email.</span><span class="textfieldMaxCharsMsg">Email too lo</span></span></td>
      </tr>
      <tr>
        <td>Which Pastor or Teacher?</td>
        <td>
          <div id="spryradio1">
            <table width="250">
              <tr>
                <td><label>
                  <input type="radio" name="Speaker" value="Pastor Stan McGehee" id="radiogroup_4" />
                  Pastor Stan McGehee Sr</label></td>
              </tr>
              <tr>
                <td><label>
                  <input type="radio" name="Speaker" value="Pastor Stan McGehee Jr" id="radiogroup_5" />
                  Pastor Stan McGehee Jr</label></td>
              </tr>
              <tr>
                <td><label>
                  <input type="radio" name="Speaker" value="Pastor Jack McFarland" id="radiogroup_6" />
                  Pastor Jack McFarland</label></td>
              </tr>
              <tr>
                <td><label>
                  <input type="radio" name="Speaker" value="Steve Bader" id="radiogroup_7" />
                  Steve Bader</label></td>
              </tr>
            </table>
            <span class="radioRequiredMsg">Please select speaker</span></div></td>
      </tr>
      <tr>
      <td>Where did you hear message?</td>
      <td>
         <div id="spryradio2">
           <table width="200">
             <tr>
               <td><label>
                 <input type="radio" name="How did you hear?" value="At LWCC" id="RadioGroup1_0" />
                 At our church</label></td>
             </tr>
             <tr>
               <td><label>
                 <input type="radio" name="How did you hear?" value="On the Radio" id="RadioGroup1_1" />
                 On the Radio</label></td>
             </tr>
             <tr>
               <td><label>
                 <input type="radio" name="How did you hear?" value="On Cable" id="RadioGroup1_2" />
                 On Cable</label></td>
             </tr>
           </table>
           <span class="radioRequiredMsg">Please make a selection</span></div></td>
      </tr>
      <tr>
       <td>What service?</td>
        <td><div id="spryradio3">
          <table width="248">
            <tr>
              <td width="240"><label>
                <input type="radio" name="When did you hear message?" value="Sunday AM" id="When did you hear message?_0" />
                Sunday AM</label></td>
            </tr>
            <tr>
              <td><label>
                <input type="radio" name="When did you hear message?" value="Sunday PM" id="When did you hear message?_1" />
                Sunday PM</label></td>
            </tr>
            <tr>
              <td><label>
                <input type="radio" name="When did you hear message?" value="Wednesday PM" id="When did you hear message?_2" />
                Wednesday PM</label></td>
            </tr>
            <tr>
              <td><label>
                <input type="radio" name="When did you hear message?" value="Adult Sunday School" id="When did you hear message?_3" />
                Adult Sunday School</label></td>
            </tr>
          </table>
          <span class="radioRequiredMsg">Please make a selection.</span></div></td>
        </tr>
      <tr>
        <td>Message Number <font size="2">(If known)</font>: </td>
        <td><input name="Message#" type="text" id="messagenumber" maxlength="50" /></td>
      </tr>
            </table>

    </td>
           </tr>
         <tr>
           <td><table width="550" border="0" cellpadding="10">
               <h3 style="padding-left:135px">Please pick date of message</h3>
                <div id="selectdate" align="center"><input id="inlineDatepicker" name="When Did You Hear?" type="text" /></div>
             
               

                <script type="text/javascript">

             var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
    document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
    </script>
    <script type="text/javascript">
    var pageTracker = _gat._getTracker("UA-4715900-1");
    pageTracker._initData();
    pageTracker._trackPageview();

    </script></table></td>

     
      <tr>
        <td style="padding-left:250px"><input name="submit" value="Submit" type="submit" />&nbsp;&nbsp;<input name="clearBtn" type="reset" /></td>
       
      </tr>
    </table>
    </td>
           </tr>
         </table>
       

        </form></div>
      <!-- end .content --></div></div>
      <div class="sidebar2">
        <table width="150" border="0" cellpadding="25" align="left">
          <tr>
            <td><a href="reformation.php"><img src="_images/MenuBox1.png" width="150" height="125" alt="What Do We Mean by Reformed?" /></a></td>
          </tr>
          <tr>
            <td><a href="ServiceTimesAndCal.php"><img src="_images/MenuBox2.png" width="150" height="125" alt="Worship Service Schedule and Calendar" /></a></td>
          </tr>
          <tr>
            <td><a href="radio.php"><img src="_images/MenuBox3.png" width="150" height="125" alt="In Light of Scripture Radio Ministry" /></a></td>
          </tr>
          <tr>
            <td><a href="cable.php"><img src="_images/MenuBox4.png" width="150" height="125" alt="Living Word Today Cable Program" /></a></td>
          </tr>
          <tr>
            <td><a href="Sermons.php"><img src="_images/MenuBox5.png" width="150" height="125" alt="Listen to Sermons Online" /></a></td>
          </tr>
           <tr>
              <td><a href="http://lwcchurch.blogspot.com" target="_blank"><img src="_images/MenuBox6.png" width="150" height="125" alt="Read our reformed blog" /></a></td>
          </tr>
        </table>
       
        <!-- end .sidebar2 --></div>
       <?php include("_includes/footer.php"); ?>
      <!-- end .container --></div>
    <script type="text/javascript">
    var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
    var MenuBar2 = new Spry.Widget.MenuBar("MenuBar2", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
    var sprytextfield1 = new Spry.Widget.ValidationTextField("spryfirstname", "none", {validateOn:["blur"], maxChars:20});
    var sprytextfield2 = new Spry.Widget.ValidationTextField("sprylastname", "none", {maxChars:20, validateOn:["blur"]});
    var sprytextfield3 = new Spry.Widget.ValidationTextField("spryemail", "email", {maxChars:50, validateOn:["blur"]});
    var sprytextfield4 = new Spry.Widget.ValidationTextField("sprystreet", "none", {validateOn:["blur"], maxChars:50});
    var sprytextfield5 = new Spry.Widget.ValidationTextField("sprytextfield5", "none", {maxChars:50, validateOn:["blur"]});
    var spryselect1 = new Spry.Widget.ValidationSelect("spryselect1", {validateOn:["blur"]});
    var sprytextfield6 = new Spry.Widget.ValidationTextField("sprytextfield6", "zip_code", {validateOn:["blur"]});
    var spryradio1 = new Spry.Widget.ValidationRadio("spryradio1");
    var spryradio2 = new Spry.Widget.ValidationRadio("spryradio2");
    var sprytextfield7 = new Spry.Widget.ValidationTextField("sprymessagenumber", "none", {isRequired:false});
    var spryradio3 = new Spry.Widget.ValidationRadio("spryradio3");
    </script>
    </body>
    </html>

Hello,
I want to create a custom user profile, by allowing admin to add them from admin panel then users can fill their values. How can I create such system ?

Thanks.

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=352528.0

Hi,
  I have a 125 X 156 jpeg image with some text underneath in the right column of my home page and the same image and text in the right column of 47 other pages. When I update the image and text in my home page I don't want to do the same 47 other times. So I have placed the image and text in a separate file. I am guessing I  have to insert preg_replace() function at the places where I want the updates to be made. My knowledge of PHP is not that great. So can anyone give me the exact function and parameters I have to use to replace the image and text. I would be very grateful.

Hey guys, im new hear so im not shore how things work.
Iv got a project where we are ment to alow users to record a bug fault in a computer, currently i have a page that looks like ths:
<?php
if (empty($_POST['bug_ID']))
   echo "<p>You must enter a BUG ID number</p>";
else {
   $bugID = addslashes($_POST['bug_ID']);
   $name = addslashes($_POST['bug_name']);   

   umask(0007);
   if (!file_exists("../../data/lab05"))
      mkdir("../../data/lab05", 02777);
      $lab05 = fopen("../../data/lab05/". "$bugID.txt", "a");
   
   if (is_writable("../../data/lab05/NewBug.txt"))
   {
      if (fwrite($lab05, $bugID . ", " . $name . "\n"))
         echo "<p>Thank you entering a new bug</p>";
      else
         echo "<p>Cannot add bug</p>";
   }
   else
      echo "<p>Cannot write to the file.</p>";
   fclose($lab05);
}
?>

this code runs fine however I also need to write a sperate page that allows for users to search and up date bugs recorded, I want them to search using the bug_ID field and we are ment to use the fgets method but am unshore, anyhelp would be much apricated.

thank you

I have read around and can't seem to find the right coding for what I need on this forum and some other other forums.

I have a contact form (as listed below) and I need 2 locations (Print Name and Title) fields to auto-populate on a separate form (can be a doc, pdf, etc. any form of document which is easiest) and this form can be totally back end and the individual using the form never is going to see the form.

It's going on a contract form, that we would like to auto-populate.

Also is there a simple attachment code so individuals can attach documents to the code?


<p style: align="center"><form action="mailtest.php" method="POST">
<?php
$ipi = getenv("REMOTE_ADDR");
$httprefi = getenv ("HTTP_REFERER");
$httpagenti = getenv ("HTTP_USER_AGENT");
?>

<input type="hidden" name="ip" value="<?php echo $ipi ?>" />
<input type="hidden" name="httpref" value="<?php echo $httprefi ?>" />
<input type="hidden" name="httpagent" value="<?php echo $httpagenti ?>" /> 
<div align="center">
<p class="style1">Name</p> 
<input type="text" name="name">
<p class="style1">Address</p> 
<input type="text" name="address">
<p class="style1">Email</p> 
<input type="text" name="email">
<p class="style1">Phone</p> 
<input type="text" name="phone">
<p class="style1">Debtor</p> 
<input type="text" name="debtor">
<p class="style1">Debtor Address</p> 
<input type="text" name="debtora">
<br />
<br />
<a href="authoforms.php" target="_blank" style="color:#ffcb00"  vlink="#ffcb00">Click here to view Assignment Agreement and Contract Agreement</a>

<p class="style1"><input type='checkbox' name='chk' value='I Have read and Agree to the terms.'> I have read and agree to the Assignment and Contract Agreement <br></p>
<p class="style1">Print Name</p> 
<input type="text" name="pname">
<p class="style1">Title</p> 
<input type="text" name="title">


<p class="style1">I hear by agree that the information I have provided is true, accurate and the information I am submitting is <br />
not fraudulent. Please click the agree button that you adhere to Commercial Recovery Authority Inc.'s terms:</p>
<select name="agree" size="1">
<option value="Agree">Agree</option>
<option value="Disagree">Disagree</option>
</select>
<br />
<br />
<p class="style1">Employee ID:</p> 
<input type="text" name="employee">

<br />

<input type="submit" value="Send"><input type="reset" value="Clear">
</div>
</form>
</p>


The mailtest php is this
?php
$ip = $_POST['ip'];
$httpref = $_POST['httpref'];
$httpagent = $_POST['httpagent'];
$name = $_POST['name'];
$address = $_POST['address'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$debtor = $_POST['debtor'];
$debtora = $_POST['debtora'];
$value = $_POST['chk'];
$pname = $_POST['pname'];
$title = $_POST['title'];
$agree = $_POST['agree'];
$employee = $_POST['employee'];
$formcontent=" From: $name \n Address: $address \n Email: $email \n Phone: $phone \n Debtor: $debtor \n Debtor's Address: $debtora \n 'Client' has read Assignment and Contract Agreement: $value \n Print Name: $pname \n Title: $title \n I hear by agree that the information I have provided is true, accurate and the information I am submitting is not fraudulent. Please click the agree button that you adhere to Commercial Recovery Authority Inc.'s terms: $agree \n \n  Employee ID: $employee \n IP: $ip";
$recipient = "mail@crapower.com";
$subject = "Online Authorization Form 33.3%";
$mailheader = "From: $email \r\n";
mail($recipient, $subject, $formcontent, $mailheader) or die("Error!");
echo "Thank You!" . " -" . "<a href='index.php' style='text-decoration:none;color:#ffcb00;'> Return Home</a>";
$ip = $_POST['visitoraddress']
?>

Hi-
the code below lets me upload a CSV file to my database if I have 1 field in my database and 1 column in my CSV.
I need to add to my db "player_id" from the CVS file and "event_name" and "event_type" from the form... any ideas???

here's the code:
Code: [Select]
<?php
$hoststring =""; 
$database = "";
$username = "";
$password = "";
$makeconnection = mysql_pconnect($hoststring, $username, $password);
?>
<?php
ob_start();
mysql_select_db($database, $makeconnection);
$sql_get_players="
SELECT * 
FROM tabel 
ORDER BY player_id ASC";
//
$get_players = mysql_query($sql_get_players, $makeconnection) or die(mysql_error());
$row_get_players = mysql_fetch_assoc($get_players);
//
$message = null;
$allowed_extensions = array('csv');
$upload_path = '.'; //same directory

if (!empty($_FILES['file'])) {

if ($_FILES['file']['error'] == 0) {
// check extension
$file = explode(".", $_FILES['file']['name']);
$extension = array_pop($file);

if (in_array($extension, $allowed_extensions)) {

if (move_uploaded_file($_FILES['file']['tmp_name'], $upload_path.'/'.$_FILES['file']['name'])) {

if (($handle = fopen($upload_path.'/'.$_FILES['file']['name'], "r")) !== false) {
$keys = array();
$out = array();
$insert = array();
$line = 1;

while (($row = fgetcsv($handle, 0, ',', '"')) !== FALSE) {

foreach($row as $key => $value) {    

if ($line === 1) {
$keys[$key] = $value;       
} else {       
$out[$line][$key] = $value;              
}       
}                
$line++;          
}        

fclose($handle);            

if (!empty($keys) && !empty($out)) {        
$db = new PDO(
'mysql:host=host;dbname=db', 
'user', 
'pw');   

$db->exec("SET CHARACTER SET utf8");        

foreach($out as $key => $value) {        
$sql  = "INSERT INTO `table` (`";
$sql .= implode("`player_id`", $keys);    
$sql .= "`) VALUES (";    
$sql .= implode(", ", array_fill(0, count($keys), "?"));    
$sql .= ")";    
$statement = $db->prepare($sql);    
$statement->execute($value);       
}      

$message = '<span>File has been uploaded successfully</span>';      
}
}
}
} else {
$message = '<span>Only .csv file format is allowed</span>';
}
} else {
$message = '<span>There was a problem with your file</span>';
}
}
ob_flush();?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>CSV File Upload</title>
</head>
<body>

<form class="form" action="" method="post" enctype="multipart/form-data">
<h3>Select Your File</h3>
<p><?php echo $message; ?></p>
<input type="file" name="file" id="file" size="30" />
<br/>
<label>Event Name:</label><input name="event_name" type="text" value="" />
<br/>
<label>Event Type:</label><input name="event_type" type="text" value="" />
<br/>
<input type="submit" id="btn" class="button" value="Submit" />
</form>

<br/>
<h3>Results:</h3>
<?php do { ?>
<p><?php echo $row_get_players['player_id'];?></p>
<?php } while ($row_get_players = mysql_fetch_assoc($get_players)); ?>
</body>
</html>

I can't get my form to update the database with user personal information. Any help greatly appreciated. Upon submitting the form, it just reloads the page, no information added to the DB. I used the update statement because I want the users to be able to update the info at a later date. Not sure if that was the right thing to do. thank you.


Code: [Select]
<?php 
ini_set ("display_errors", "1");
error_reporting(E_ALL);
include('bouncer.php');
$host = "";
$database  = "";
$username  = "";
$password  = "";
 
$tbl_name   = "users";

$conn = mysql_connect($host, $username, $password) or die("Could not connect: " . mysql_error());

if($conn)
{
mysql_select_db($database);
 
 } else {
  echo "failed to select database";
}



$currentUser = $_SESSION['myusername']; // get user from login and make it current user to use for update statement

echo "Login success!<br/>";
echo "Please fill out the form below to add your personal information to the database<br/>";
//////////////////////////////////////////////////////////////////////////////////////////////////
if(isset($_POST['submit'])) 

{
 


$firstname = mysql_real_escape_string( $_POST['first']);
$lastname = mysql_real_escape_string( $_POST['last']);
$dob = mysql_real_escape_string( $_POST['dob']);
$gender = mysql_real_escape_string( $_POST['gender']);

 


 

$result= mysql_query ( "UPDATE users SET firstname = '$firstname', lastname = '$lastname', dob = '$dob', gender='$gender' WHERE username='$currentUser'") or die(mysql_error());

 
if($result)
{
echo "your information was updated in the database and is as follows <br/>";
//put the results on the screen
echo "<br/> $firstname <br/>";
echo "<br/>$lastname <br/>";
echo "<br>$dob <br/> ";
echo ">$gender <br>";

} else {
echo "error, could not update your info to the database </br>";//end if result

}




}//end if sumbit post statement at top
?>
<html>
<body>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>

<form action="login_successERROR.php" method="post">
  <p>
    <input type="text" name="first" size="20" />
  First name<br />
    <input type="text" name="last" size="20" />
    Last name<br />
    <input name="dob" type="text" size="20" id="dob" />
    Date of Birth<br />
    <input type="text" name="gender" size="20" id="gender" />
  Gender <br />
 
    <input type="submit" value="Add personal information to database" />
    <input type="reset" value="Reset fields" />
  </p>
  </p>
</form> 

<p><a href="index.php">HOME</a></p>
<p>&nbsp;</p>
</body>
</html>

Hi there im going a little bit mad now.... i spent a while trying to work out why my form didnt update or redirect... After head scratching i remade a test form... That also doesnt update or redirect?? I must be missing something here?? So basically when the user clicks submit nothing happens, why??

Code: [Select]
<?php require_once('Connections/swb.php'); ?>
<?php
session_start();
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE player SET `Day`=%s WHERE PlayerName=%s",
                       GetSQLValueString($_POST['days'], "int"),
                       GetSQLValueString($_POST['playername'], "text"));

  mysql_select_db($database_swb, $swb);
  $Result1 = mysql_query($updateSQL, $swb) or die(mysql_error());

  $updateGoTo = "logout.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
}



?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>

<form action="<?php echo $editFormAction; ?>" id="form1" name="form1" method="POST">

<input type="button" value="End Turn" />


<input name="days" type="hidden" id="days" value="1"/>
<input name="playername" type="hidden" id="playername" value="<?php echo $_SESSION['MM_Username']; ?>">
<input type="hidden" name="MM_update" value="form1">
</form>

</body>
</html>
Thanks

hi,

I've looked around and not seen an answer that fits my situation, so here goes.

I've got a database and I have a script that displays the values from that database in editable fields and has an update button

this is that script:
<?php
session_start();
include("dbinfo.inc.php");
mysql_connect($servname,$dbusername,$dbpassword);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM ($newdbname) ";
$result=mysql_query($query);
$num=mysql_numrows($result); 
mysql_close();

$i=0;
while ($i < $num) {
$username=mysql_result($result,$i,"username");
$password=mysql_result($result,$i,"password");
//$real_name=mysql_result($result,$i,"real_name");
echo "$username, $password, $real_name";
?>

<form action="updated.php">
<input type="hidden" name="ud_id" value="<? echo "$id"; ?>">
Username: <input type="text" name="username" value="<? echo "$username"?>"><br>
Password: <input type="text" name="password" value="<? echo "$password"?>"><br>

<input type="Submit" value="Update">
</form>

<?php
++$i;
} 
?>

it passes the "updated" values to this script:
<?php
session_start();
include("dbinfo.inc.php");
mysql_connect($servname,$dbusername,$dbpassword);

$query="INSERT $newdbname SET username (user_id, username, password)='$ud_username', password= PASSWORD('$ud_password') WHERE id='$ud_id'";
@mysql_select_db($database) or die( "Unable to select database");
mysql_query($query);
echo "Record Updated";
mysql_close();
?>


I get no errors, and everything runs just fine.  except it doesn't update any thing.  I'm sure it's a simple thing I'm missing, stupid lack of experience hindering me.

any help would be greatly appreciated!

Hi,

when someone logs in to my page, i have a form displayed with names, address, etc...what i need to do is when i hit the update button for that information to go into the MYSQL table I have created and over write that information if a user updates...so how do i do that?

Code: [Select]
<?php
$host="xxxx"; // Host name 
$username="xxxx"; // Mysql username 
$password="xxxx"; // Mysql password 
$db_name="xxxx"; // Database name 
$tbl_name="xxxx"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// get value of id that sent from address bar
$model_id=$_GET['model_id'];


// Retrieve data from database 
$sql="SELECT model_id, model_name, location, email_1 FROM $tbl_name WHERE model_id='$model_id'";
$result=mysql_query($sql);

$rows=mysql_fetch_array($result);
?>

<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<form name="form1" method="post" action="updated.php">
<td>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>&nbsp;</td>
<td colspan="3"><strong>Update data in mysql</strong> </td>
</tr>
<tr>
<td align="center">&nbsp;</td>
<td align="center">&nbsp;</td>
<td align="center">&nbsp;</td>
<td align="center">&nbsp;</td>
</tr>
<tr>
<td align="center">&nbsp;</td>
<td align="center"><strong>Name</strong></td>
<td align="center"><strong>Location</strong></td>
<td align="center"><strong>Email</strong></td>
</tr>
<tr>
<td>&nbsp;</td>
<td align="center"><input name="name" type="text" id="name" value="<? echo $rows['model_name']; ?>"></td>
<td align="center"><input name="location" type="text" id="location" value="<? echo $rows['location']; ?>"></td>
<td><input name="email" type="text" id="email" value="<? echo $rows['email_1']; ?>"></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input name="id" type="hidden" id="id" value="<? echo $rows['model_id']; ?>"></td>
<td align="center"><input type="submit" name="Submit" value="Submit"></td>
<td>&nbsp;</td>
</tr>
</table>
</td>
</form>
</tr>
</table>

<?

// close connection
mysql_close();

?>
This is the part that isn't working

Code: [Select]
<td align="center"><input name="name" type="text" id="name" value="<? echo $rows['model_name']; ?>"></td>
<td align="center"><input name="location" type="text" id="location" value="<? echo $rows['location']; ?>"></td>
<td><input name="email" type="text" id="email" value="<? echo $rows['email_1']; ?>"></td>
The echo values aren't being fetched and left blank when I run the script. Any ideas?