vendredi 23 décembre 2016

Checkbox Array, Jquery, PHP

I have a main.php page with some checkboxes and a textbox, what I am trying to achieve is on selecting of "Select All or any of the checkboxes the values should be passed".The checkbox change function should trigger and post the data to ajaxData.php. The Ajaxdata.php should return the respective team members name back to the main.php page and display the fname values in a textbox.

The problem right now is nothing happens on click on any of the checkboxes

My main.php page is below

Select All <input type="checkbox" name="select_all" id="select_all" value="1">

Pythons<input type="checkbox" name="select[]" id="team" value="Pythons">
Wipers <input type="checkbox" name="select[]" id="team" value="Wipers">
<input type="textbox" name="first_name" value="">
<script>

$("#select_all").change(function() {
   var select_all = $(this).val();
 alert('1');
    if(select_all){
        $.ajax({
            type:'POST',
            url:'ajaxData.php',
            data:'select_all='+select_all,
            success:function(html){
                $('#first_name').html(html);

            }
        }); 
    }else{
        //$('#carrier').html('<option value="">Select State First</option>');

    }

</script>

ajaxData.php code looks like the following

if(isset($_POST["select_all"]) && !empty($_POST["select_all"])){

$select_sql="SELECT * FROM member WHERE team_id = ".$_POST['select_all']." ORDER BY name ASC";
 $result=mysqli_query($con,$select_sql);
 $cnt=mysqli_num_rows($result);
 if($cnt > 0)
 {
        while($results=mysqli_fetch_assoc($result))
            {

            if($results['id'] !=0 )
                {
                 echo $results['fname']                               
            }
}




Aucun commentaire:

Enregistrer un commentaire