dropdown selected show when value exist in database.

<select class="membership_type_dropdown">
                             <option value="0" selected="selected" disabled>Membership Role</option>     
                             <?php
                                   $sql1="SELECT membership_type_id,membership_type FROM `membership_type`";
                                   $result1=mysqli_query($con,$sql1);
                                   $num_rows1=mysqli_num_rows($result1);
                                   if($num_rows1 > 0)
                                   {
                                      while($row1=mysqli_fetch_array($result1))
                                      {
                                  $selected = ($row1['membership_type_id'] == $row['membership_type_id']) ? 'selected="selected"' : '';
                               echo "<option value='".$row1['membership_type_id']."'" . $selected . ">" . $row1['membership_type'] . "</option>";
                                       //  echo '<option value="'.$row1['membership_type_id'].'">'.$row1['membership_type'].'</option>';
                                      }
                                   } 
                                  ?>
                                 
                                    </select>

Comments

Post a Comment

Popular posts from this blog

dynamic create multiple ckeditor onclick event using jquery

<!DOCTYPE html> <html> <head> <title>New Ckeditor Instance Dynamically</title> <script type="text/javascript" src="ckeditor_3.5/ckeditor/ckeditor.js"></script> <script type="text/javascript" src="scripts/jquery-1.4.4.js"></script> <script type="text/javascript" src="ckeditor_3.5/ckeditor/adapters/jquery.js"></script> <script type="text/javascript"> $(document).ready(function() { $('.jquery_ckeditor').ckeditor(); }); </script> <script> function newCkeditor(){ $('<div><textarea><\/textarea><\/div>') .appendTo('#body').find('textarea').ckeditor(); } function clicked(){ for ( instance in CKEDITOR.instances ){ alert("ckeditor values : " + CKEDITOR.instances[instance].getData()); } } </script> </head> <body...
Read more

get lat and long from city name using jquery

<html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>     <script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?sensor=false"></script> </head> <body>    <?php $city='indore'; ?>     <input id="btn" type="button" value="search for miami coordinates" />     <input type="hidden" class="cityName" name="cityName" value="<?php echo $city; ?>" />     <script> jQuery(document).ready(function($){ var cityName=$('.cityName').val();             var geocoder =  new google.maps.Geocoder();     geocoder.geocode( { 'address': cityName}, function(results, status) {           if (status == google.maps.GeocoderStatus.OK) {             alert("location : " + results[0].geometry.location.lat() +...
Read more

membership registration and login system in php

<?php include_once('header.php'); ?> <?php ob_start(); $message=''; $message1=''; $error=''; $firstnameError=''; $lastnameError=''; $usernameError=''; $emailError=''; $phoneError=''; $passwordError=''; $firstname = $lastname = $username =  $password = $phone = $email = ''; if(isset($_POST['membership_registration'])) { $status=0; $date_added = date('Y-m-d H:i:s'); if(!empty($_POST['membership_firstname']))   {     $firstname = mysqli_real_escape_string($con, $_POST['membership_firstname']);   }   else   {     $firstnameError='First Name is Required';   }   if(!empty($_POST['membership_lastname']))   {     $lastname = mysqli_real_escape_string($con, $_POST['membership_lastname']);   }   else   {     $lastnameError='Last Name is Required';   } if(!empty($_POST['membership_usern...
Read more