Ad:

PHP Discussion Thread
Marked Solved
Views: 1317

Jun 11th, 2009

Display a dynamic page in textfield

Expand Post »

Hi,
Anyone can help me?..must be easy for most of you.

instead of just displaying data from the database in a table,
i want to make it varies..some in textbox, some in text area.
this is my code:

php Syntax (Toggle Plain Text)
<?php
   $query= mysql_query(" SELECT * FROM office
   					WHERE officeID='" . $_GET['officeID'] . "'");
 
      while($entry=mysql_fetch_array($query))
      {
 
      echo $entry['name'];
      echo $entry['location']; 
}
?>
<?php
   $query= mysql_query(" SELECT * FROM office
   					WHERE officeID='" . $_GET['officeID'] . "'");
   
      while($entry=mysql_fetch_array($query))
      {
	  
      echo $entry['name'];
      echo $entry['location']; 
}
?>

it dsplays correct data from the database in this format:
abc33bar avenue
which refer to (name abc, location 33bar avenue ).

how make it like this?
name : (here is the dynamic data -name- from database)
location : location

I have construct a textfield with inital value like this :
echo <input name="name" type="text" value="<?php echo $entry['name']; ?>"> ;

however it doesn't work.
thanks for your help

Last edited by peter_budo; Jun 11th, 2009 at 7:51 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Similar Threads

retrieve date from database to display on web page in PHP
display records page wise PHP code I got it in PHP
set a dynamic page size for gridview? in ASP.NET
Dynamic page set up in ASP.NET
Dynamic Page in PHP

tulipputih

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

107 posts
since May 2009

Permalink

Jun 11th, 2009

Re: Display a dynamic page in textfield

please check my thread i need help, updation there is a code for this

furqan219

Reputation Points: 2

Solved Threads: 4

Junior Poster in Training

Offline

89 posts
since Jun 2009

Permalink

Jun 11th, 2009

Re: Display a dynamic page in textfield

This is your 11th post and still you have no idea how to post source code?

Please read http://www.daniweb.com/forums/announcement17-4.html

You should paste your code in BB tags

PHP Syntax (Toggle Plain Text)
<?php
     $query= mysql_query(" SELECT * FROM office
                     WHERE officeID='" . $_GET['officeID'] . "'");
    while($entry=mysql_fetch_array($query))
            {
             echo  "<br/>Name : $entry[name]";
              echo "<br/>Location : $entry[location]";
             }
?>
<?php
     $query= mysql_query(" SELECT * FROM office
                     WHERE officeID='" . $_GET['officeID'] . "'");
    while($entry=mysql_fetch_array($query))
            {
             echo  "<br/>Name : $entry[name]";
              echo "<br/>Location : $entry[location]";
             }
?>

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

Jun 11th, 2009

Re: Display a dynamic page in textfield

try this and change according to u

php Syntax (Toggle Plain Text)
<?
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("new", $con);
 
$result = mysql_query("SELECT * FROM abc
WHERE SiteId='C-SIL-4441' "); // I just get one value at this time
 
 
while($row = mysql_fetch_array($result))
  {
  echo "<table cellpadding=2 cellspacing=2 width=100%>
<tr>
 
 
</tr>";
  echo "<tr>";
  echo "<th bgcolor=#5D9BCC >SiteID</th>";
  echo "<td bgcolor=#FEE9A9>" . $row['SiteId'] . "</td>";
  echo "<td bgcolor=#FEE9A9>" . $row['Name'] . "</td>";
  echo "<td bgcolor=#FEE9A9>" . $row['Address'] . "</td>";
  echo "<td bgcolor=#FEE9A9>" . $row['City'] . "</td>"; // show value in cell
 
 
 $b =$row['SiteId']; 
  $c =$row['Name'];
   $d =$row['Address'];
    $e =$row['City'];// store value in variabel
 
 
 
  echo "</tr>";
 
  }
echo "</table>";
 
 
mysql_close($con);
 
?>
<form action="update2.php" method="post">
<table>
<tr>
<td>name</td>
<td>
<input type="text" name="username" id="username" value="<?php echo $c; ?>" /> </td></tr>
<tr>
<td>Address</td>
<td>
<input type="text" name="address" id="address" value="<?php echo $d; ?>"></td></tr>
<tr>
<td>city</td>
<td>
<input type="text" id="city" name="city" value="<?php echo $e; ?>">
</td>
</tr>
<tr>
<td colspan="2">
<input type="submit" value="Update"/>
</td>
</tr>
<input type="text" value="<?php echo $b; ?>" name="siteid">
</table>
 
</body>
</html><?
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("new", $con);
 
$result = mysql_query("SELECT * FROM abc
WHERE SiteId='C-SIL-4441' "); // I just get one value at this time
 
 
while($row = mysql_fetch_array($result))
  {
  echo "<table cellpadding=2 cellspacing=2 width=100%>
<tr>
 
 
</tr>";
  echo "<tr>";
  echo "<th bgcolor=#5D9BCC >SiteID</th>";
  echo "<td bgcolor=#FEE9A9>" . $row['SiteId'] . "</td>";
  echo "<td bgcolor=#FEE9A9>" . $row['Name'] . "</td>";
  echo "<td bgcolor=#FEE9A9>" . $row['Address'] . "</td>";
  echo "<td bgcolor=#FEE9A9>" . $row['City'] . "</td>"; // show value in cell
 
 
 $b =$row['SiteId']; 
  $c =$row['Name'];
   $d =$row['Address'];
    $e =$row['City'];// store value in $b
 
 
 
 
 
 
 
 
  echo "</tr>";
 
  }
echo "</table>";
 
 
mysql_close($con);
 
?>
<form action="update2.php" method="post">
<table>
<tr>
<td>name</td>
<td>
<input type="text" name="username" id="username" value="<?php echo $c; ?>" /> </td></tr>
<tr>
<td>Address</td>
<td>
<input type="text" name="address" id="address" value="<?php echo $d; ?>"></td></tr>
<tr>
<td>city</td>
<td>
<input type="text" id="city" name="city" value="<?php echo $e; ?>">
</td>
</tr>
<tr>
<td colspan="2">
<input type="submit" value="Update"/>
</td>
</tr>
<input type="text" value="<?php echo $b; ?>" name="siteid">
</table>
 
</body>
</html>
<?
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("new", $con);

$result = mysql_query("SELECT * FROM abc
WHERE SiteId='C-SIL-4441' "); // I just get one value at this time


while($row = mysql_fetch_array($result))
  {
  echo "<table cellpadding=2 cellspacing=2 width=100%>
<tr>


</tr>";
  echo "<tr>";
  echo "<th bgcolor=#5D9BCC >SiteID</th>";
  echo "<td bgcolor=#FEE9A9>" . $row['SiteId'] . "</td>";
  echo "<td bgcolor=#FEE9A9>" . $row['Name'] . "</td>";
  echo "<td bgcolor=#FEE9A9>" . $row['Address'] . "</td>";
  echo "<td bgcolor=#FEE9A9>" . $row['City'] . "</td>"; // show value in cell

 
 $b =$row['SiteId']; 
  $c =$row['Name'];
   $d =$row['Address'];
    $e =$row['City'];// store value in variabel
 


  echo "</tr>";
 
  }
echo "</table>";


mysql_close($con);

?>
<form action="update2.php" method="post">
<table>
<tr>
<td>name</td>
<td>
<input type="text" name="username" id="username" value="<?php echo $c; ?>" /> </td></tr>
<tr>
<td>Address</td>
<td>
<input type="text" name="address" id="address" value="<?php echo $d; ?>"></td></tr>
<tr>
<td>city</td>
<td>
<input type="text" id="city" name="city" value="<?php echo $e; ?>">
</td>
</tr>
<tr>
<td colspan="2">
<input type="submit" value="Update"/>
</td>
</tr>
<input type="text" value="<?php echo $b; ?>" name="siteid">
</table>

</body>
</html><?
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("new", $con);

$result = mysql_query("SELECT * FROM abc
WHERE SiteId='C-SIL-4441' "); // I just get one value at this time


while($row = mysql_fetch_array($result))
  {
  echo "<table cellpadding=2 cellspacing=2 width=100%>
<tr>


</tr>";
  echo "<tr>";
  echo "<th bgcolor=#5D9BCC >SiteID</th>";
  echo "<td bgcolor=#FEE9A9>" . $row['SiteId'] . "</td>";
  echo "<td bgcolor=#FEE9A9>" . $row['Name'] . "</td>";
  echo "<td bgcolor=#FEE9A9>" . $row['Address'] . "</td>";
  echo "<td bgcolor=#FEE9A9>" . $row['City'] . "</td>"; // show value in cell

 
 $b =$row['SiteId']; 
  $c =$row['Name'];
   $d =$row['Address'];
    $e =$row['City'];// store value in $b
 



  
 
  

  echo "</tr>";
 
  }
echo "</table>";


mysql_close($con);

?>
<form action="update2.php" method="post">
<table>
<tr>
<td>name</td>
<td>
<input type="text" name="username" id="username" value="<?php echo $c; ?>" /> </td></tr>
<tr>
<td>Address</td>
<td>
<input type="text" name="address" id="address" value="<?php echo $d; ?>"></td></tr>
<tr>
<td>city</td>
<td>
<input type="text" id="city" name="city" value="<?php echo $e; ?>">
</td>
</tr>
<tr>
<td colspan="2">
<input type="submit" value="Update"/>
</td>
</tr>
<input type="text" value="<?php echo $b; ?>" name="siteid">
</table>

</body>
</html>

furqan219

Reputation Points: 2

Solved Threads: 4

Junior Poster in Training

Offline

89 posts
since Jun 2009

Permalink

Jun 11th, 2009

Re: Display a dynamic page in textfield

PHP Syntax (Toggle Plain Text)
   1.
      <?php
   2.
      $query= mysql_query(" SELECT * FROM office
   3.
      WHERE officeID='" . $_GET['officeID'] . "'");
   4.
 
   5.
      while($entry=mysql_fetch_array($query))
   6.
      {
   7.
 
   8.
      echo $entry['name'];
   9.
      echo $entry['location'];
  10.
      }
  11.?>
   1.
      <?php
   2.
      $query= mysql_query(" SELECT * FROM office
   3.
      WHERE officeID='" . $_GET['officeID'] . "'");
   4.
       
   5.
      while($entry=mysql_fetch_array($query))
   6.
      {
   7.
       
   8.
      echo $entry['name'];
   9.
      echo $entry['location'];
  10.
      }
  11.?>

according to me there will be no need of while loop here. bec. here only i row is coming from database according to your condition it should be like this:

PHP Syntax (Toggle Plain Text)
   <?php
 
      $query= mysql_query(" SELECT * FROM office
 
      WHERE officeID='" . $_GET['officeID'] . "'");
 
    $entry=mysql_fetch_array($query);
 
    $name= $entry['name'];
 
      $location= $entry['location'];
   <?php

      $query= mysql_query(" SELECT * FROM office

      WHERE officeID='" . $_GET['officeID'] . "'");
  
    $entry=mysql_fetch_array($query);

    $name= $entry['name'];

      $location= $entry['location'];

now result is in two variables $name and $location.

if you want to display data in the textfield then it will be like this
E.g:

PHP Syntax (Toggle Plain Text)
<input type="text" id="name" name="name" value="<?php echo $name; ?>">
<input type="text" id="name" name="name" value="<?php echo $name; ?>">

for text area it will be like this:

Quote ...

<textarea><?php echo $name; ?> </textarea>

same as with location.

i hope you understand.

Last edited by navi17; Jun 11th, 2009 at 8:36 am.

navi17

Reputation Points: 15

Solved Threads: 6

Junior Poster

Offline

118 posts
since Oct 2007

Permalink

Jun 11th, 2009

Re: Display a dynamic page in textfield

hi
I just edited your code
so you can find solution as you want

PHP Syntax (Toggle Plain Text)
 
      <?php
      $query= mysql_query(" SELECT * FROM office
      WHERE officeID='" . $_GET['officeID'] . "'");
     ?>      
    <table>
      while($entry=mysql_fetch_array($query))
   6.
      { ?>
   7. <tr>
      <td>Name</td>
       <td><?=$entry['name']?></td>
      </tr>
      <tr>
     <td>Location</td>
     <td><?= $entry['location']?></td>
    </tr>
     <?   
       } ?>
</table>
 <form method="post">
<input type="text" name"txt_name" id="txt_name" value='<?=$entry['name']?>'>
 </form>
      <?php
      $query= mysql_query(" SELECT * FROM office
      WHERE officeID='" . $_GET['officeID'] . "'");
     ?>      
    <table>
      while($entry=mysql_fetch_array($query))
   6.
      { ?>
   7. <tr>
      <td>Name</td>
       <td><?=$entry['name']?></td>
      </tr>
      <tr>
     <td>Location</td>
     <td><?= $entry['location']?></td>
    </tr>
     <?   
       } ?>
</table>
 <form method="post">
<input type="text" name"txt_name" id="txt_name" value='<?=$entry['name']?>'>
 </form>

like this you can do as per your requirement if you want fetch only one row that time no need of while loop ok
$entry=mysql_fetch_array($query);
Thanks

Tulsa

Reputation Points: 13

Solved Threads: 15

Junior Poster in Training

Offline

77 posts
since May 2009

Permalink

Jun 11th, 2009

Re: Display a dynamic page in textfield

Semantics aside, this is the most basic PHP-MySQL example you will get:

php Syntax (Toggle Plain Text)
<?php
// Connect to MySQL
mysql_connect("host", "user", "pwd") or die(mysql_error());
mysql_select_db("dbName") or die(mysql_error());
 
// Query some data from the MySQL database
$sql = "SELECT field1, field2 FROM myTable";
$result = mysql_query($sql) or die(mysql_error());
 
// Display the results of the query
while($row = mysql_fetch_assoc($result)) {
    echo $row['field1'], " - ";
    echo $row['field2'], "<br />";
}
?>
<?php
// Connect to MySQL
mysql_connect("host", "user", "pwd") or die(mysql_error());
mysql_select_db("dbName") or die(mysql_error());

// Query some data from the MySQL database
$sql = "SELECT field1, field2 FROM myTable";
$result = mysql_query($sql) or die(mysql_error());

// Display the results of the query
while($row = mysql_fetch_assoc($result)) {
    echo $row['field1'], " - ";
    echo $row['field2'], "<br />";
}
?>

If you want to put the fields in <input> or <textbox> tags, simply alter the echo statements on lines #12 and #13 to reflect what you want to print.
Like:

php Syntax (Toggle Plain Text)
echo '<input  name="file1" value="', $row['field1'] , '" /><br />';
echo '<textarea name="field2">', $row['field2'], '</textarea>';
echo '<input  name="file1" value="', $row['field1'] , '" /><br />';
echo '<textarea name="field2">', $row['field2'], '</textarea>';

Atli

Reputation Points: 93

Solved Threads: 70

Posting Pro

Offline

526 posts
since May 2007

Permalink

Jun 11th, 2009

Re: Display a dynamic page in textfield

Click to Expand / Collapse Quote originally posted by Atli ...

Semantics aside, this is the most basic PHP-MySQL example you will get:
php Syntax (Toggle Plain Text)
<?php
// Connect to MySQL
mysql_connect("host", "user", "pwd") or die(mysql_error());
mysql_select_db("dbName") or die(mysql_error());
 
// Query some data from the MySQL database
$sql = "SELECT field1, field2 FROM myTable";
$result = mysql_query($sql) or die(mysql_error());
 
// Display the results of the query
while($row = mysql_fetch_assoc($result)) {
    echo $row['field1'], " - ";
    echo $row['field2'], "<br />";
}
?>
<?php // Connect to MySQL mysql_connect("host", "user", "pwd") or die(mysql_error()); mysql_select_db("dbName") or die(mysql_error()); // Query some data from the MySQL database $sql = "SELECT field1, field2 FROM myTable"; $result = mysql_query($sql) or die(mysql_error()); // Display the results of the query while($row = mysql_fetch_assoc($result)) { echo $row['field1'], " - "; echo $row['field2'], "<br />"; } ?>
If you want to put the fields in <input> or <textbox> tags, simply alter the echo statements on lines #12 and #13 to reflect what you want to print.
Like:
Quote ...
php Syntax (Toggle Plain Text)
echo '<input  name="file1" value="', $row['field1'] , '" /><br />';
echo '<textarea name="field2">', $row['field2'], '</textarea>';
echo '<input name="file1" value="', $row['field1'] , '" /><br />'; echo '<textarea name="field2">', $row['field2'], '</textarea>';

Thanks Atli, You answered my question. I wanted to display the result in textbox or textarea. The dynamic data from the database was displayed before but not in proper textbox.

tulipputih

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

107 posts
since May 2009

Permalink

Jun 11th, 2009

Re: Display a dynamic page in textfield

I'm glad I could help

Atli

Reputation Points: 93

Solved Threads: 70

Posting Pro

Offline

526 posts
since May 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: help on php-mysql oop

Next Thread in PHP Forum Timeline: Problems with Ampersands and Google Website Optimizer in Joomla CMS

DaniWeb Message

Cancel Changes

User Name
Password