Need to get values in textbox from database on button click in PHP

Question

I need to get values of database in text boxes on button click using PHP and Javascript. For instance, I get values in an HTML table from a database table. I need to get the respective values in the text boxes when the user clicks on the add0 button.

Here is my code:

<form method="post" action="">
  <input type="text" name="tb1" />
  <input type="text" name="tb2" />
  <input type="submit" name="btn" value="Find" />
</form>
<?php
  include "conn.php";
  $show = "SELECT * FROM data";
  $rs = mysql_query($show) or die(mysql_error());
  $add_to_textbox = "<input type='button' name='btn' value='add0' />";
  #****results in Grid****
  echo "<table width='360px' border='1' cellpadding='2'>";
  while($row = mysql_fetch_array($rs)) {
    echo "<tr>";
    echo "<td width='130px'>$row[Name]</td>";
    echo "<td width='230px'><a href = '$row[Link]'>$row[Link]</a></td>";
    echo "<td width='130px'>$add_to_textbox</td>";
    echo "</tr>";
  }
  echo "</table>";
  #**********************
  mysql_free_result($rs);
?>

I need further code on button click.

you need to start using mysqli or pdo..also you can use onclick edit on your td tags using ajax.. — 000
– 000, Commented Nov 22, 2012 at 11:47
Collect the row id-s for example on button click and than you will know what has been selected to add to cart. You can create multiple forms for each row and on submit collect the id or you can have checkboxes for each row and one submit button — v0d1ch
– v0d1ch, Commented Nov 22, 2012 at 11:51
If you have $row[Link] than I guess that there is also id in same table. Just put $row[id] in <input type='hidden' name='id' value='<?php echo $row[id];?>' /> You can use $_SESSION to store quantity and id-s of products while the user is on ine page and then process data and save it in db if the user is finished with the shopping — v0d1ch
– v0d1ch, Commented Nov 22, 2012 at 12:23
@vodich yeah i have id in my table. I guess u think i'm working on shopping cart... it isn't right. i'm just making a php form to save links to websites but as per my needs i have to add, edit and delete the records from my database — Bkay
– Bkay, Commented Nov 22, 2012 at 12:34

000 · Accepted Answer · 2012-11-24 11:57:09Z

1

~~imho you can use Inline edit using Ajax in Jquery~~

~~Here is it's demo~~

~~It will let you edit your displayed contents in the table itself..~~

Update:

<form method="post" action="">
  <input type="text" name="tb1" id="tb1" />
  <input type="text" name="tb2" id ="tb2" />
  <input type="submit" name="btn" value="Find" />
</form>
<?php
  include "conn.php";
  $show = "SELECT * FROM data";
  $rs = mysql_query($show) or die(mysql_error());
  $add_to_textbox = "<input type='button' name='btn' value='add0' />";
  #****results in Grid****
  echo "<table width='360px' border='1' cellpadding='2'>";
  $rowID=1;
  while($row = mysql_fetch_array($rs)) {
    echo "<tr>";
    echo "<td width='130px' id='name".$rowID."'>$row[Name]</td>";
    echo "<td width='230px' id='link".$rowID."'><a href = '$row[Link]'>$row[Link]</a></td>";
    echo "<td width='130px' onclick='txtValDisp($rowID);'>$add_to_textbox</td>";
    echo "</tr>";
    $rowID++;
  }
  echo "</table>";
  #**********************
  mysql_free_result($rs);
?>
<script type="text/javascript">
function txtValDisp(rowID){
    var linkVal = document.getElementById('link'+rowID+'').innerHTML.replace(/<\/?[^>]+(>|$)/g, "\n");
    document.getElementById("tb1").value = document.getElementById('name'+rowID+'').innerHTML;
    document.getElementById("tb2").value = linkVal; 
    }
</script>

edited Nov 24, 2012 at 11:57

answered Nov 22, 2012 at 11:55

000

3,9404 gold badges27 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Bkay Over a year ago

I don't need to edit any value, I just need to get values in my textboxes when i click on tne button.

Bkay Over a year ago

can you plz explain this line for me? var link Val = document.getElementById('link'+rowID+'').innerHTML.replace(/<\/?[^>]+(>|$)/g, "\n");

000 Over a year ago

it strips out the anchor tag from link td and assigns the rest to var linkVal..in case you won't use it then tb2 will also display the anchor tag along with link td value..

Bkay Over a year ago

Okay I got it now thanks so much for your help and time. I really Appreciate it. thanks again.

Bkay Over a year ago

i have one more question that is still unanswered can you please help me for that?

|

BioSP · Accepted Answer · 2012-11-22 13:10:53Z

Recreate your form with default values taken from the database.

<form method="post" action="">
<input type="text" name="tb1" />
<input type="text" name="tb2" />
<input type="submit" name="btn" value="Find" />
</form>
<?php
 include "conn.php";
 $show = "SELECT * FROM data";
 $rs = mysql_query($show) or die(mysql_error());
 $add_to_textbox = "<input type='button' name='btn' value='add0' />";
  #****results in Grid****
 echo "<table width='360px' border='1' cellpadding='2'>";
 while($row = mysql_fetch_array($rs)) {
echo "<tr>";
echo "<td><input name ='INSERT_HERE' type=text value='"$row[Name]"'></td>";
echo "</tr>";
}
echo "</table>";
#**********************
mysql_free_result($rs);
?>

You just need to change the name of the object based on whatever counter of something...

Collectives™ on Stack Overflow

Need to get values in textbox from database on button click in PHP

2 Answers 2

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related