PHP table pass to a var in javascript

Question

I have this PHP code and I am trying to alert a table that receives its values via sql. Here's my code:

    <script src="jquery.min.js">
    </script>
    <script>
    function bus(x){
        alert("Row index is: " + x.value);
    }
    </script> 
    $sql="SELECT  ID, NOME, CPF FROM cadastro WHERE NOME LIKE '%" . $name .  "%'"; 
    $result=mysqli_query($conn,$sql);
    while($row=mysqli_fetch_array($result)){
                $ID =$row['ID'];
                $NOME=$row['NOME'];
                $CPF=$row['CPF'];
    echo '<table style="width:100%">';
    echo "<tr>";
    echo "<th> ID </th>";
    echo "<th> NOME </th>";
    echo "<th> CPF </th>";
    echo "</tr>";
    echo '<tr style="cursor: pointer;">';
    echo "<td onclick='bus(" . $ID . ")' class='tab'>" . $ID . "</td>";
    echo "<td onclick='bus(" . $ID . ")' class='tab'>" . $NOME . "</td>";
    echo "<td onclick='bus(" . $ID . )' class='tab'>" . $CPF . "</td>";
    echo "</tr>";
    echo "</table>";

I need to get the value from the table and serve it to a javascript function.

Could you elleborate more on your question? what are you getting from this code, an error or what? — Anna Jeanine
– Anna Jeanine, Commented Nov 23, 2018 at 15:28

The fourth bird · Accepted Answer · 2018-11-23 15:38:39Z

1

If x is a Number, then x.value will give you undefined and you should just use:

alert("Row index is: " + x);

To get the value of the column, you could pass this to the function instead of the id and then get the innerHTML:

<td onclick="bus(this)" class="tab">column 1</td>

function bus(elm){
    alert(elm.innerHTML);
}

function bus(elm) {
  alert(elm.innerHTML);
}

<table>
  <tr>
    <td onclick="bus(this)" class="tab">column 1</td>
    <td onclick="bus(this)" class="tab">column 2</td>
    <td onclick="bus(this)" class="tab">column 3</td>
  </tr>
</table>

answered Nov 23, 2018 at 15:38

The fourth bird

165k16 gold badges61 silver badges75 bronze badges

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

Comments

Unamata Sanatarai · Accepted Answer · 2018-11-23 15:37:26Z

0

You only have one error. onclick is passing the ID, so the following code will do exactly what you need:

<script>
function bus(x){
    alert("Row index is: " + x);
}
</script>

I removed the .value from your javascript.

function bus(x){
alert("Value is " + x);
}

<table>
<tr>
<td onclick="bus(44)">44</td>
<td onclick="bus(44)">Lorem</td>
<td onclick="bus(44)">ipsum</td>
</tr>
</table>

edited Nov 23, 2018 at 15:37

answered Nov 23, 2018 at 15:29

Unamata Sanatarai

6,6293 gold badges32 silver badges52 bronze badges

1 Comment

Matheus Santos Over a year ago

I need the ID in alert, but i don't receive him. The alert shows "undefined"

Paulo Bueno · Accepted Answer · 2018-11-23 15:35:33Z

0

In this case x is not an object, just a plain value so:

alert("Row index is: " + x);

gl, pb

answered Nov 23, 2018 at 15:35

Paulo Bueno

2,5696 gold badges43 silver badges69 bronze badges

Collectives™ on Stack Overflow

PHP table pass to a var in javascript

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related