0

I have a php file that shows all the user details in table form. On click of edit, I am want to set something from DB to local storage using javascript.

So to show a table of users I am doing the following:

<table cellspacing="0">
      <tr>
         <th>ID</th>
         <th>Name</th>
         <th>View</th>
         <th>Edit</th>
      </tr>

        <?php
        $count=1;
        $sel_query="Select * from user_details ORDER BY id desc;";
        $result = mysqli_query($con,$sel_query);
        while($row = mysqli_fetch_assoc($result)) { 

        ?>

      <tr>
         <td align="center"><?php echo $count; ?>
         <td align="center"><?php echo $row["docname"]; ?>
         <td align="center"><a href="view.php?id=<?php echo $row["id"]; ?>">View</a></td>
         <td align="center"><a href="edit.php?id=<?php echo $row["id"]; ?>" onclick="handleLinkClick(event);">Edit</a></td>
      </tr>

<?php $count++; } ?>

   </table>

The above shows the records in the table perfectly.

Now when edit is clicked, I call a javascript function. (This is called before I click on edit? I am not sure why?)

<script type="text/javascript">

    function handleLinkClick (e) {
        e.preventDefault (); 
        var id = e.target.href.split ("?").pop ();
        var key = <?php echo add(id);?>

        console.log(key);
        localStorage.setItem ("myKey", key);
        //window.location.href = e.target.href;
        }

</script>

Now from javascript function, I am trying to call a PHP function a variable is sent from javascript to PHP function to fetch corresponding records details and return that data to javascript, below is the PHP function:

function add($id){

    $sel_query="select * from user_details where id=$id";
    $result = mysqli_query($con,$sel_query);
    while($row = mysqli_fetch_assoc($result)) 
    { 
        $key = $row["rawText"];
        echo $key;
    }

     return $key;
}
?>

I don't see any results. I am not sure why I am not getting any results? Can some give me the right syntax or correct me?

Thanks!

3

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.