How to insert value to textfield in PHP?

**thetestingsite** · 09-09-2007, 04:19 PM

Oops, sorry. Forgot some brackets there.

Code:

<?php
include ('dbconn.cfg');// database configuration file
$connection = @mysql_connect("localhost", "root", "") or die("Cannot connect to server!");
?>
            // build table to display result
            <html>
            <title></title>
            <head>
            <body>
            <h2><center>Member Profile</center></h2>
            <table border = '1'  cellpadding = '3' cellspacing = '2' style = 'background-color: #ADD8E6'>
            <tr>
            <th>Full Name</th>
            <th>Telephone</th>
            <th>Address</th>
            </tr>
            <tr>
            
            <?

if (isset($_SESSION['gmembername']))
{
    $tbl_name = "member";
    $sql = "SELECT name,telephone,address FROM $tbl_name";

    $result = @mysql_query($sql, $connection) or die("Cannot execute query.");
    $numrow = mysql_num_rows($result);
    
    if($numrow != 0)
    {// fetch each record in result set
        for ($counter = 0; $row = mysql_fetch_row($result); $counter++)
      {
              foreach ($row as $key => $value) {
                if ($key == 0 && $key == 1) {
?>
<td><input type="text" size="30" value="<?php echo $value;?>" readonly="readonly"></td>
<?php
         }
           else {
              if ($row == 2) {
?>
<td><textarea rows="3"> <?php echo $value; ?> </textarea></td>
<?php
               }
            }
         }
      }
    }
}
?>
 
             </tr>
            </table>
            <table>
            <tr>
            <td>&nbsp;</td>
            <td width='4&#37;'>&nbsp;</td>
            <td></tr>
            <tr>
            <td>&nbsp;</td>
            <td width='4%'>&nbsp;</td>
            <td><input type='submit' name='submit' value='Upgrade'></td>
            </table>
            </body>
            </head>
            </html>

That should work, but not tested.
Hope this helps.

**devil_vin** · 09-09-2007, 04:39 PM

So weird...the textfield and textarea still missing....

Originally Posted by thetestingsite

Oops, sorry. Forgot some brackets there.

Code:

<?php
include ('dbconn.cfg');// database configuration file
$connection = @mysql_connect("localhost", "root", "") or die("Cannot connect to server!");
?>
            // build table to display result
            <html>
            <title></title>
            <head>
            <body>
            <h2><center>Member Profile</center></h2>
            <table border = '1'  cellpadding = '3' cellspacing = '2' style = 'background-color: #ADD8E6'>
            <tr>
            <th>Full Name</th>
            <th>Telephone</th>
            <th>Address</th>
            </tr>
            <tr>
            
            <?

if (isset($_SESSION['gmembername']))
{
    $tbl_name = "member";
    $sql = "SELECT name,telephone,address FROM $tbl_name";

    $result = @mysql_query($sql, $connection) or die("Cannot execute query.");
    $numrow = mysql_num_rows($result);
    
    if($numrow != 0)
    {// fetch each record in result set
        for ($counter = 0; $row = mysql_fetch_row($result); $counter++)
      {
              foreach ($row as $key => $value) {
                if ($key == 0 && $key == 1) {
?>
<td><input type="text" size="30" value="<?php echo $value;?>" readonly="readonly"></td>
<?php
         }
           else {
              if ($row == 2) {
?>
<td><textarea rows="3"> <?php echo $value; ?> </textarea></td>
<?php
               }
            }
         }
      }
    }
}
?>
 
             </tr>
            </table>
            <table>
            <tr>
            <td>&nbsp;</td>
            <td width='4%'>&nbsp;</td>
            <td></tr>
            <tr>
            <td>&nbsp;</td>
            <td width='4%'>&nbsp;</td>
            <td><input type='submit' name='submit' value='Upgrade'></td>
            </table>
            </body>
            </head>
            </html>

That should work, but not tested.
Hope this helps.

**devil_vin** · 09-10-2007, 04:31 AM

Anyone know that what went wrong in my script?If I only use three textfields then fine,however I can't make any further specifications, so I mix with textarea by specifying it in foreach loop.But all textfields and textarea gone missing...

Thanks....

**DevilsPride** · 02-01-2008, 12:31 AM

Text fields can't have spaces in them. Text areas can. That's the problem. use string replace or remove them to get the value of a text field to write all then info from the $_REQUEST object.

Code:

<input type="text" name="name" size="30" value=<?=(isset($_POST['name']))?str_replace(' ',"&nbsp;",$_POST["name"]):''?>>

Thread: How to insert value to textfield in PHP?

Thread Tools

Search Thread

Bookmarks

Bookmarks

Posting Permissions