jQuery: Fetch Button Value.

Discussion in 'jQuery' started by cancer10, Sep 8, 2008.

0
  1. #1
    ok, Let me be as simple as I can with my question.

    I have an index.php page.

    
<HTML>
<head>
<TITLE>Welcome</TITLE>
<script type="text/javascript" src="jquery.js"></script> 
<script>
	$(document).ready(function(){
	$("#populate_tables").load("ajax.php?id=10");
	});
</script>	
</head>


<div id="populate_tables"></div>

</html>
    Code (markup):
    The index.php loads all the information in the <div id="populate_tables"></div> tag when the page loads. This part works fine.


    Now, Lets see the code for ajax.php

    
<?php $id =$_GET['id'];	 
$attachments = mysql_query("select * from tbl where id=$id order by id desc");
		 $num_rows = count($attachments);
		 ?>
		<table width="50%" border="1" cellspacing="0" cellpadding="3" class="border" style="border-collapse:collapse">
		<?php 
		if($num_rows>0){
			for($x=0;$x<$num_rows;$x++){?>
	  <tr>
		<td><input type="submit" id="att_del" name="att_del" value="<?php echo $attachments[$x]['id'];?>" /></td>
	  </tr>
	  <?php }//end for loop
	  }else{//ifelse condition
	  ?>
	  <tr>
	  <td align="center">No Attachments</td>
	  </tr>
	  <?php
	  }//end else
	  ?>
	</table>
    PHP:
    Everything works well so far.

    Lets go back to the index.php page :)

    When the list loads under the <div id="populate_tables"></div> tag, and when I click on the buttons (att_del), it should alert me with their button value.

    Please help.


    Thanx
     
    cancer10, Sep 8, 2008 IP
  2. zerxer

    zerxer Peon

    Messages:
    368
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Okay, a couple things about your script.

    1) You forgot the body tags in index.php
    2) You should really use addslashes() on your $id before putting it in a query like that, you want to avoid SQL injections.
    3) Doing $attachments = mysql_query() won't have it store the rows in $attachments; you have to do something like $sqlres = mysql_query(); $num_rows = mysql_num_rows(); and then for your loop do while($attachment = mysql_fetch_array($sqlres)){}
    4) Once you update to the above method, you'd do <?=$attachment['id']?> for your button's value (<?= ?> is a shorthand way of doing <?php echo ;?>).
    5) I don't even see any code that should make it alert you the button value when clicked unless you're actually asking us what you should do. I'd say something like onclick="alert($(this).value());" or another jQuery alternative, linking the alert function to the click event after loading the data.

    <HTML>
<head>
<TITLE>Welcome</TITLE>
<script type="text/javascript" src="jquery.js"></script> 
<script>
	$(document).ready(function(){
	$("#populate_tables").load("ajax.php?id=10", "", function(){
          $("#att_del").click(function(){alert($(this).value());});
         });
	});
</script>	
</head>
<body>
<div id="populate_tables"></div>
</body>
</html>
    HTML:
    <?php 
    $id = addslashes($_GET['id']);
    $sqlres = mysql_query("select * from tbl where id=$id order by id desc");
    $num_rows = mysql_num_rows();
?>
    <table width="50%" border="1" cellspacing="0" cellpadding="3" class="border" style="border-collapse:collapse">
<?php 
    if($num_rows>0) {
        while($attachment = mysql_fetch_array($sqlres)) { ?>
        <tr>
            <td><input type="submit" id="att_del" name="att_del" value="<?=$attachment['id']?>" /></td>
        </tr>
<?php
        } //end while loop
    } else { //ifelse condition
?>
        <tr>
            <td align="center">No Attachments</td>
        </tr>
<?php
    } //end else
?>
    </table>
    PHP:
    Hope that helped (and that I didn't make any errors :p).
     
    zerxer, Sep 10, 2008 IP