Adding function in a javascript button [duplicate]

Question

I want my btn-post-announcement to have a function that is when I click the Post button the data's in the table will be inserted in the database.

<div id='donor_table'>

    <div style='height: 600px; width: 100%; overflow: scroll'>

        <table id='donor_tbl' border='5' cellpadding='10'>
            <thead>
            <th>#</th>
            <th>Announcements</th>
            <th>Date</th>
            <th>Time</th>
            <th>Post</th>
            </thead>
            <tbody>

            <?php
            include "connection.php";
            error_reporting(0);
            $searchannouncement = $_POST['searchannouncement'];
            $displayAnn = " SELECT annid,announcement,dateee,timeee FROM announcements_tbl WHERE annid LIKE '%" . $searchdonor . "%' OR announcement LIKE '%" . $searchdonor . "%' OR dateee LIKE '%" . $searchdonor . "%' OR timeee LIKE '%" . $searchdonor . "%' order by annid desc";

            $annData = mysql_query($displayAnn);
            while ($drecords = mysql_fetch_assoc($annData)) {
                echo "<tr><td>" . $drecords['annid'] . "</td>";
                echo "<td>" . $drecords['announcement'] . "</td>";
                echo "<td>" . $drecords['dateee'] . "</td>";
                echo "<td>" . $drecords['timeee'] . "</td>";
                echo "<td align='center'><input type='button' class='btn-post-announcement button' id=" . $drecords['annid'] . " value='Post'></td>";
            };
            ?>
            </tbody>
        </table>
    </div>
</div>
</body>
</html>
<div id="dlg">
    <div>
        <script type="text/javascript">
            $(function () {
                $("#dlg").dialog({
                    autoOpen: false,
                    height: 600,
                    width: 780,
                    modal: true
                });
                $(".btn-post-announcement").button();
                $(".btn-post-announcement").click(function () {
                })
                $("#donor_tbl").DataTable();
            });
        </script>

Siddhartha Chowdhury · Accepted Answer · 2016-02-07 21:59:00Z

0

You will need ajax to achieve this. I will use Jquery to do so:

JS

$(function(){
  $('.btn-post-announcement').click(function(){ // on button pressed
    var data = {};
    var count = 0;
   $('td').each(function(){        // for each td 
     data[count++] = $(this).text(); // collect the text inside it
   })
    $.post("url.php", data, function(resp){ // send the collected data to the PHP 
       console.log(response)
    })
  })
})

url.php

<?php
 var_dump($_POST);

answered Feb 7, 2016 at 21:59

Siddhartha Chowdhury

2,7241 gold badge31 silver badges50 bronze badges

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

2 Comments

Jojo Sugoran Over a year ago

Hello sir what will I actually do to make it work? I'm so new in Php and Mysql that's why I have a lots of question.

Siddhartha Chowdhury Over a year ago

Basically the JS will collect the data from the table and will send it to a php page, (I mentioned url.php) you can name it anything, make sure the path to the file is correct. var_dump($_POST); will display the data that is sent in form of array. Now when you will get the array of all the value, Iam sure you will find a way to store them in DB. There are tons of tutorials out there which shows how to store the values using PHP. Good luck friend.

Collectives™ on Stack Overflow

Adding function in a javascript button [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related