CODEWITHSUNDEEP
phpjavascriptjquerymysql
user2025469
user2025469

Reputation: 1571

How to pass php values to javascript then to ajax?

I am echoing data into a table with values from my database. It looks like this:

<?php
  //mysqli_num_rows function
  while($row=mysqli_fetch_array //I know this may be wrong, but that's not the point
  echo "<tr><td>".$somedata."</td></tr>";
?>

So the value of this table row will be displayed based on how much data is in the database. I want to asynchronously update the page, for example the user wants to delete this from the DB. How can I pass this value to javascript with an onClick function? Or is there another way? If I have a link to delete in the table like:

<td><a onClick="delete(ThisValueOfThisTableRow)">Delete</a></td>

And in javascript or jQuery I want to find this value and set it to a variable, then pass it as:

var some_value = //get this value
.ajax{
  url: "somephpfile.php"
  data:{some_value:value}
}

I think this would be helpful to anyone if they a responsive member page. Please help out!

Upvotes: 0

Views: 306

Answers (2)

Jared
Jared

Reputation: 12524

PHP

while ( $row = mysql_fetch_array( $result ) ) {
    echo '<tr><td><a onclick="delete_row(' . $row['id'] . ')">delete row</a></td></tr>';
}

Javascript

function delete_row( id ) {
    alert( id ); //To show you are getting the id remove this for production

    //ajax goes here
}

Upvotes: 0

John Blythe
John Blythe

Reputation: 603

maybe something like this:

<?php
  //mysqli_num_rows function
  while($row=mysqli_fetch_array) {
?>
<tr>
<td><?=$somedata;?></td>
<td><a href='#' class='delete-btn' id='row-<?=$someID;?>'>Delete</a></td>
</tr>
<?
}//end while
?>

and then for the js event

$('.delete-btn').click(function() {
  var id = $(this).attr("id");
  id = id.split("-");
  data = { "id" : id[1] }
  //your ajax here, pass in your data obj
});

best of luck-

Upvotes: 1

Related Questions