Skip to main content

dropdown with checkbox and insert multiple checkbox

works only in bootstrap

<div class="button-group"> <button type="button" class="btn btn-default btn-sm dropdown-toggle form-control" data-toggle="dropdown"> Select Country <span class="caret"></span> </button> <ul class="dropdown-menu form-control" style="height:160px; overflow-x: hidden;"> <? $sql="SELECT * from country"; $result=mysqli_query($con,$sql); if(mysqli_num_rows($result)>0) { while($row=mysqli_fetch_assoc($result)) { ?> <li class="form-control"> <input type="checkbox" value="<? echo $row['country_name'];?>" name ="chk[]"/>&nbsp;<? echo $row['country_name'];?></li> <?} }?> </ul> </div>

without bootstrap

use script
<script>
var options = [];

$( '.dropdown-menu a' ).on( 'click', function( event ) {

   var $target = $( event.currentTarget ),
       val = $target.attr( 'data-value' ),
       $inp = $target.find( 'input' ),
       idx;

   if ( ( idx = options.indexOf( val ) ) > -1 ) {
      options.splice( idx, 1 );
      setTimeout( function() { $inp.prop( 'checked', false ) }, 0);
   } else {
      options.push( val );
      setTimeout( function() { $inp.prop( 'checked', true ) }, 0);
   }

   $( event.target ).blur();
     
   console.log( options );
   return false;
});
</script>

<?


$chk =$_POST['chk'];


foreach( $chk as $key=>$value )
{

 $sql= "INSERT INTO company_login (country,company_name,email,password,signup_time,signup_date) VALUES ('$value','$cname','$cemail','$cpass','$ctime','$cdate')";

if(mysqli_query($con,$sql))
{
header("Location:a_company.php");
}
else
{
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}

}

Comments

Popular posts from this blog

bootstrap slider back to top

<script src = "//ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js" > </script> <link rel = "stylesheet" id = "font-awesome-css" href = "//netdna.bootstrapcdn.com/font-awesome/4.0.3/css/font-awesome.css" type = "text/css" media = "screen" > copy anywhere in your page <div class="scroll-top-wrapper "> <span class="scroll-top-inner"> <i class="fa fa-2x fa-arrow-circle-up"></i> </span> </div> <style> .scroll-top-wrapper {     position: fixed; opacity: 0; visibility: hidden; overflow: hidden; text-align: center; z-index: 99999999;     background-color: #2E9BDC; color: #eeeeee; width: 50px; height: 48px; line-height: 48px; right: 30px; bottom: 30px; padding-top: 2px; border-top-left-radius: 10px; border-top-right-radius: 10px; border-bottom-right-rad...

embed play youtube video just from url

<? $videolink='https://www.youtube.com/watch?v=6SDlG8T2KRE'; $ytarray=explode("/", $videolink); $ytendstring=end($ytarray); $ytendarray=explode("?v=", $ytendstring); $ytendstring=end($ytendarray); $ytendarray=explode("&", $ytendstring); $ytcode=$ytendarray[0]; echo "<iframe width=\"420\" height=\"315\" src=\"http://www.youtube.com/embed/$ytcode\" frameborder=\"0\" allowfullscreen></iframe>"; ?>