How to insert value to textfield in PHP?

For the code below,how can I insert $value into the textfiled respectively?And did there any code like setEditable=false in Java to disable editing of particular textfield?Thanks...

PHP Code:

---

<?php
include ('dbconn.cfg');// database configuration file
$connection = @mysql_connect("localhost", "root", "") or die("Cannot connect to server!");

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++)
        {
            // build table to display result
            print ("<h2><center>Member Profile</center></h2>");
            print ("<table border = '1'  cellpadding = '3' cellspacing = '2' style = 'background-color: #ADD8E6'>");
            print ("<tr>");
            print ("<th>Full Name</th>");
            print ("<th>Telephone</th>");
            print ("<th>Address</th>");
            print ("</tr>");
            print ("<tr>");

            foreach ($row as $key => $value)
                print ("<td><input type ='text'size = '30'></td>");

            print ("</tr>");
            print ("</table>");
        }
    }
}
?>

---

Try this for the inserting of the field.

Code:

---

<?php
include ('dbconn.cfg');// database configuration file
$connection = @mysql_connect("localhost", "root", "") or die("Cannot connect to server!");

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++)
        {
            // build table to display result
            print ("<h2><center>Member Profile</center></h2>");
            print ("<table border = '1'  cellpadding = '3' cellspacing = '2' style = 'background-color: #ADD8E6'>");
            print ("<tr>");
            print ("<th>Full Name</th>");
            print ("<th>Telephone</th>");
            print ("<th>Address</th>");
            print ("</tr>");
            print ("<tr>");

            foreach ($row as $key => $value)
                print ("<td><input type ='text' value='$value' size = '30'></td>");

            print ("</tr>");
            print ("</table>");
        }
    }
}
?>

---

As for the editing of only certain fields, you can append "readonly" to the field that you don't want editable. This would look something like the following:

Code:

---

<input type="text" name="blah" value="blah blah" readonly>

---

Hope this helps.

Quote:

---

Originally Posted by thetestingsite

Try this for the inserting of the field.

Code:

---

<?php
include ('dbconn.cfg');// database configuration file
$connection = @mysql_connect("localhost", "root", "") or die("Cannot connect to server!");

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++)
        {
            // build table to display result
            print ("<h2><center>Member Profile</center></h2>");
            print ("<table border = '1'  cellpadding = '3' cellspacing = '2' style = 'background-color: #ADD8E6'>");
            print ("<tr>");
            print ("<th>Full Name</th>");
            print ("<th>Telephone</th>");
            print ("<th>Address</th>");
            print ("</tr>");
            print ("<tr>");

            foreach ($row as $key => $value)
                print ("<td><input type ='text' value='$value' size = '30'></td>");

            print ("</tr>");
            print ("</table>");
        }
    }
}
?>

---

As for the editing of only certain fields, you can append "readonly" to the field that you don't want editable. This would look something like the following:

Code:

---

<input type="text" name="blah" value="blah blah" readonly>

---

Hope this helps.

---

oh..I don't realize existence of this feature,thanks...

If I change address field to textarea then how each $value being fixed to its location?The following code seems lost the textfield and textarea...thanks..

PHP Code:

---

foreach ($row as $key => $value)
                if($row == 0 && $row == 1)
                print ("<td><input type ='text' size = '30' value = '$value'readonly></td>");
                else if($row == 2)
                print("<td><textarea rows = '3' value = '$value'></textarea></td>"); 


---

For textareas, you place the default value (what you want displayed) in between the <textare> tags like so:

Code:

---

foreach ($row as $key => $value)
                if($row == 0 && $row == 1)
                print ("<td><input type ='text' size = '30' value = '$value' readonly></td>");
                else if($row == 2)
                print("<td><textarea rows = '3'>$value</textarea></td>");

---

Hope this helps.

Quote:

---

Originally Posted by thetestingsite

For textareas, you place the default value (what you want displayed) in between the <textare> tags like so:

Code:

---

foreach ($row as $key => $value)
                if($row == 0 && $row == 1)
                print ("<td><input type ='text' size = '30' value = '$value' readonly></td>");
                else if($row == 2)
                print("<td><textarea rows = '3'>$value</textarea></td>");

---

Hope this helps.

---

Unfortunately,y textarea and textfield still gone,this is the table structure:

PHP Code:

---

 print ("<h2><center>Member Profile</center></h2>");
            print ("<table border = '1'  cellpadding = '3' cellspacing = '2' style = 'background-color: #ADD8E6'>");
            print ("<tr>");
            print ("<th>Full Name</th>");
            print ("<th>Telephone</th>");
            print ("<th>Address</th>");
            print ("</tr>");
            print ("<tr>");

            foreach ($row as $key => $value)
                if($row == 0 && $row == 1)
                print ("<td><input type ='text' size = '30' value = '$value' readonly></td>");
                else if($row == 2)
                print("<td><textarea rows = '3'>$value</textarea></td>");
                
            print ("</tr>");
            print ("</table>");
            
            print ("<table>");
            print ("<tr>");
            print ("<td>&nbsp;</td>");
            print ("<td width='4%'>&nbsp;</td>");
            print ("<td></tr>");

            print ("<tr>");
            print ("<td>&nbsp;</td>");
            print ("<td width='4%'>&nbsp;</td>");
            print ("<td><input type='submit' name='submit' value='Upgrade'></td>");
            print ("</table>"); 


---

I would break out of PHP, first of all, for just HTML:

PHP Code:

---

<?php  ?>
<h2><center>Member Profile</center></h2>
<!-- rest of code before foreach statement
<?php 

            foreach ($row as $key => $value)
                if($row == 0 && $row == 1)
                print ("<td><input type ='text' size = '30' value = '$value' readonly></td>");
                else if($row == 2)
                print("<td><textarea rows = '3'>$value</textarea></td>"); 
?>

</tr>
</td>
<!-- rest of html here -->

---

Now, for the textarea, it's better to write the readonly like, readonly="readonly". What you have now will work, though you might want to replace it with something more valid.

I think I have confusing with html and php clauses...:confused:
What went wrong in my code?Thanks...

PHP 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 ($row == 0 && $row == 1)
                 print ("<td><input type ='text' size = '30' value = '$value' readonly></td>");
           else
              if ($row == 2)
                 print ("<td><textarea rows = '3'>$value</textarea></td>");
      }
    }
}
?>
 
             </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>

---

Quote:

---

Originally Posted by alexjewell

I would break out of PHP, first of all, for just HTML:

PHP Code:

---

<?php  ?>
<h2><center>Member Profile</center></h2>
<!-- rest of code before foreach statement
<?php 

            foreach ($row as $key => $value)
                if($row == 0 && $row == 1)
                print ("<td><input type ='text' size = '30' value = '$value' readonly></td>");
                else if($row == 2)
                print("<td><textarea rows = '3'>$value</textarea></td>"); 
?>

</tr>
</td>
<!-- rest of html here -->

---

Now, for the textarea, it's better to write the readonly like, readonly="readonly". What you have now will work, though you might want to replace it with something more valid.

---

Try this instead (my changes are highlighted):

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>

---

Hope this helps.

Thanks for your help.However it showed syntax error of unexpected T_ELSE in line of else statement.

Quote:

---

Originally Posted by thetestingsite

Try this instead (my changes are highlighted):

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>

---

Hope this helps.

---

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.

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

Quote:

---

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.

---

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...:confused: Thanks....:)

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"]):''?>>

---