Inserting checkboxes inside php code

Question

I'm trying to use checkboxes to update information in a MySQL database.

The 'Sent' column is a Boolean.

Is there a way to put a checkbox inside my php code,tbody so, instead of <td>".$infoItems['Sent']."</td> there's a checkbox instead of zeroes.

<table class="scroll">
  <thead>
    <tr>
      <th>Schools Name</th>
      <th>Schools Email</th>
      <th>Sent</th>
    </tr>
  </thead>

  <tbody>
      <?php

      $execItems = $conn->query("SELECT Name,SchoolMail,Sent FROM Schools");

      while($infoItems = $execItems->fetch_array())
      {
        echo    "
                <tr>
                    <td>".$infoItems['Name']."</td>
                    <td>".$infoItems['SchoolMail']."</td>

                    <td>".$infoItems['Sent']."</td>
                    /* ^Insert a checkbox here instead of this ^ */
                </tr>
            ";
        }
    ?>
    </tbody>
</table>
</body>

</html>

what checkboxes and what update? Didn't you try anything?

Funk Forty Niner
– Funk Forty Niner

2018-01-31 16:50:33 +00:00
Commented Jan 31, 2018 at 16:50 — Funk Forty Niner
– Funk Forty Niner, Commented Jan 31, 2018 at 16:50
Is this two different questions... ?

IncredibleHat
– IncredibleHat

2018-01-31 17:00:01 +00:00
Commented Jan 31, 2018 at 17:00 — IncredibleHat
– IncredibleHat, Commented Jan 31, 2018 at 17:00
<input type=checkbox...> and so on?

tadman
– tadman

2018-01-31 17:01:26 +00:00
Commented Jan 31, 2018 at 17:01 — tadman
– tadman, Commented Jan 31, 2018 at 17:01

Syscall · Accepted Answer · 2018-01-31 17:20:28Z

1

You could try something like this

echo '<tr>
    <td>'.$infoItems['Name'].'</td>
    <td>'.$infoItems['SchoolMail'].'</td>
    <td>
        <input type="checkbox"'.($infoItems['Sent']?' checked':'').'
               data-mail="'.$infoItems['SchoolMail'].'"
               data-name="'.$infoItems['Name'].'"
               onchange="ajax_call_function(this)"
               />
    </td>
</tr>' ;

It will call a javascript function :

<script type="text/javascript">
    function ajax_call_function(element) {
        console.log(element.getAttribute("data-name"));
        console.log(element.getAttribute("data-mail"));

        // make your AJAX call to a server-side script 
        // that updates your database with these informations.
        //
        // OR
        //
        // Update some hidden fields in a form and submit it. 

    }
</script>

edited Jan 31, 2018 at 17:20

answered Jan 31, 2018 at 16:54

Syscall

19.8k10 gold badges44 silver badges60 bronze badges

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

7 Comments

Federico klez Culloca Over a year ago

Yes, but OP also talks about updating information on the database.

Felmorne Over a year ago

Thanks for the input! That helped with the checkboxes, but how do I make it so when I insert the SchoolMail and send the email, the checkbox gets updated?

tadman Over a year ago

Tip: Instead of fighting the quotes, either omit them, as you can for most HTML tag attributes with single word values, or use the other kind. For example: <input type=checkbox> or <input type='checkbox'> both work.

Syscall Over a year ago

@Felmorne I've updated my anwser... But there are so many way to do this.

Felmorne Over a year ago

@Syscall Sorry if I'm being intrusive but is there a way that we can communicate directly, if you're available of course

|

Collectives™ on Stack Overflow

Inserting checkboxes inside php code

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related