<!DOCTYPE html>
<html lang="en">
<head>
    
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.5.3/dist/css/bootstrap.min.css" integrity="sha384-TX8t27EcRE3e/ihU7zmQxVncDAy5uIKz4rEkgIXeMed4M0jlfIDPvg6uqKI2xXr2" crossorigin="anonymous">
    <link rel="stylesheet" href="https://cdn.datatables.net/1.10.22/css/dataTables.bootstrap4.min.css">
    <link href="css/styles.css" rel="stylesheet" />
    <script src="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.1/js/all.min.js" crossorigin="anonymous"></script>
    <script src="https://www.google.com/recaptcha/api.js" async defer></script>
 <script src="https://cdn.datatables.net/1.10.22/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.10.22/js/dataTables.bootstrap4.min.js"></script>
    <style>
        td,th{
            font-size:12px !important;
        }
    </style>
</head>
<body class="sb-nav-fixed">
    
    
        <main>
            <div id="layoutSidenav_content">
                <div class="modal fade" id="editmodal" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
                    <div class="modal-dialog">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title" id="exampleModalLabel">Edit Data</h5>
                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                            <form id="my_edit_form" action="dashboard_files/db_connect/updatecode.php" method="post" enctype="multipart/form-data" accept-charset="utf-8">
                                <div class="modal-body">
                                    <div class="form-group">
                                        <label> ID</label>
                                        <input readonly name="id" id="id" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                       
                                        <input type="hidden" name="userid" id="userid" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                     <label> Name</label>
                                        <input type="input" name="name" id="name" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                        <label>Email</label>
                                        <input type="text" name="emailaddress" id="email" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                        <label>First Name</label>
                                        <input type="text" name="firstname" id="firstname" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                        <label>Last Name</label>
                                        <input type="text" name="lastname" id="lastname" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                        <label>Profile seeking for </label>
                                           <select name="profileseekingfor" id="profileseekingfor" placeholder="" class="form-control">
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>Self</option>
                        <option>Son</option>
                        <option>Daughter</option>
                        <option>Brother</option>
                        <option>Sister</option>
                        <option>Friend</option>
                        <option>Relative</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Gender</label>
                                  
                                            <select name="gender" id="gender" class="form-control">
                        <option value="" label="Select" selected="selected" placeholder="">Select</option>
                        <option>Male</option>
                        <option>Female</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Date of Birth</label>
                                
                                        <input type="date" name="dob" id="dob" class="form-control" >
                                    </div>
                                    
                                    <div class="form-group">
                                        <label>Age</label>
                                        <input type="text" name="age" id="age" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                        <label>Religion</label>
    
                                    <select  name="religion" id="religion" class="form-control">
                                        <option value="" label="Select" selected="selected">Select</option>
                                        <option>Hindu</option>
                                        <option>Muslim</option>
                                        <option>Christian</option>
                                        <option>Buddhist</option>
                                        <option>Other</option>
                                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Language</label>
                            
                                              <select name="language" id="language" class="form-control">
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>Tamil</option>
                        <option>Sinhala</option>
                        <option>Malay</option>
                        <option>English</option>
                        <option>Other</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Complextion</label>
                                     
                                                 <select  name="complextion" id="complextion" class="form-control">
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>Fair</option>
                        <option>Wheatish</option>
                        <option>Wheatish Medium</option>
                        <option>Wheatish Brown</option>
                        <option>Dark</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Caste</label>
                            
                                                    <select name="caste" id="caste" class="form-control" >
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>Pure jaffna vellalar</option>
                        <option>Mixed jaffna vellalar</option>
                        <option>Other vellalar </option>
                        <option>Visvakulam</option>
                        <option>Mukkulathor</option>
                        <option>Kurukulam (Karayar)</option>
                        <option>Koviyar</option>
                        <option>Bhramin</option>
                        <option>Others</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Height</label>
                                    
                                                   <select name="height" id="height" class="form-control" >
                               <option value="" label="Select" selected="selected">Select</option>
                        <option>4&#8216;-121cm</option>
                        <option>4&#8216;1&#8221;-124cm</option>
                        <option>4&#8216;2&#8221;-127cm</option>
                        <option>4&#8216;3&#8221;-129cm</option>
                        <option>4&#8216;4&#8221;-132cm</option>
                        <option>4&#8216;5&#8221;-134cm</option>
                        <option>4&#8216;6&#8221;-137cm</option>
                        <option>4&#8216;7&#8221;-139cm</option>
                        <option>4&#8216;8&#8221;-142cm</option>
                        <option>4&#8216;9&#8221;-144cm</option>
                        <option>4&#8216;10&#8221;-147cm</option>
                        <option>4&#8216;11&#8221;-149cm</option>
                        <option>5&#8216;-152cm</option>
                        <option>5&#8216;1&#8221;-155cm</option>
                        <option>5&#8216;2&#8221;-157cm</option>
                        <option>5&#8216;3&#8221;-160cm</option>
                        <option>5&#8216;4&#8221;-162cm</option>
                        <option>5&#8216;5&#8221;-165cm</option>
                        <option>5&#8216;6&#8221;-167cm</option>
                        <option>5&#8216;7&#8221;-170cm</option>
                        <option>5&#8216;8&#8221;-172cm</option>
                        <option>5&#8216;9&#8221;-175cm</option>
                        <option>5&#8216;10&#8221;-177cm</option>
                        <option>5&#8216;11&#8221;-180cm</option>
                        <option>6&#8216;-182cm</option>
                        <option>6&#8216;1&#8221;-185cm</option>
                        <option>6&#8216;2&#8221;-188cm</option>
                        <option>6&#8216;3&#8221;-190cm</option>
                        <option>6&#8216;4&#8221;-193cm</option>
                        <option>6&#8216;5&#8221;-195cm</option>
                        <option>6&#8216;6&#8221;-198cm</option>
                        <option>6&#8216;7&#8221;-200cm</option>
                        <option>6&#8216;8&#8221;-203cm</option>
                        <option>6&#8216;9&#8221;-205cm</option>
                        <option>6&#8216;10&#8221;-208cm</option>
                        <option>6&#8216;11&#8221;-210cm</option>
                        <option>7&#8216;-213cm</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Weight</label>
                                        <input type="text" name="weight" id="weight" class="form-control" placeholder="">
                                        <select name="weight" id="weight" class="form-control" >
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>36Kg</option>
                        <option>39Kg</option>
                        <option>41Kg</option>
                        <option>43Kg</option>
                        <option>45Kg</option>
                        <option>48Kg</option>
                        <option>50Kg</option>
                        <option>52Kg</option>
                        <option>54Kg</option>
                        <option>57Kg</option>
                        <option>59Kg</option>
                        <option>61Kg</option>
                        <option>63Kg</option>
                        <option>66Kg</option>
                        <option>68Kg</option>
                        <option>70Kg</option>
                        <option>73Kg</option>
                        <option>75Kg</option>
                        <option>77Kg</option>
                        <option>79Kg</option>
                        <option>82Kg</option>
                        <option>84Kg</option>
                        <option>86Kg</option>
                        <option>89Kg</option>
                        <option>91Kg</option>
                        <option>89Kg</option>
                        <option>86Kg</option>
                        <option>89Kg</option>
                        <option>86Kg</option>
                        <option>89Kg</option>
                        <option>91Kg</option>
                        <option>93Kg</option>
                        <option>95Kg</option>
                        <option>97Kg</option>
                        <option>100Kg</option>
                        <option>102Kg</option>
                        <option>104Kg</option>
                        <option>107Kg</option>
                        <option>109Kg</option>
                        <option>111Kg</option>
                        <option>113Kg</option>
                        <option>116Kg</option>
                        <option>118Kg</option>
                        <option>120Kg</option>
                        <option>122Kg</option>
                        <option>125Kg</option>
                        <option>127Kg</option>
                        <option>129Kg</option>
                        <option>131Kg</option>
                        <option>134Kg</option>
                        <option>136Kg</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Star</label>
                                    
                                         <select name="star" id="star" class="form-control" >
                        <option value="" label="Select" selected="selected">Select</option>
     <option>Ashwini</option>
                         <option>Ayiliyam</option>
                         <option>Anusham</option>
                         <option>Avitam</option>
                         <option>Barani</option>
                         <option>Chithirai</option>
                         <option>Hastham</option>
                         <option>Karthigai</option>
                         <option>Kettai</option>
                         <option>Mirugasirisham</option>
                         <option>Maham</option>
                         <option>Moolam</option>
                         <option>Punarpoosam</option>
                         <option>Poosam</option>
                         <option>Puram</option>
                         <option>Puradam</option>
                         <option>Puraddathi</option>
                         <option>Revathi</option>
                         <option>Rohini</option>
                         <option>Swathi</option>
                         <option>Sathayam</option>
                         <option>Thiruvaathirai</option>
                         <option>Thiruvonam</option>
                         <option>Uthram</option>
                         <option>Uthraddathi</option>
                         <option>Uthiradam</option>
                         <option>Visakam </option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Rasi</label>
                                  
                                                <select name="rasi" id="rasi" class="form-control" >
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>Dhanus</option>
                        <option>Kanni</option>
                        <option>Katakam</option>
                        <option>Kumbham</option>
                        <option>Makaram</option>
                        <option>Makaram</option>
                        <option>Meenam</option>
                        <option>Mesham</option>
                        <option>Mithunam</option>
                        <option>Rishaham</option>
                        <option>Simmam</option>
                        <option>Thula</option>
                        <option>Vrishchikam</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Native of father</label>
                                        <input type="text" name="nativeoffather" id="nativeoffather" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                        <label>Father's caste</label>
                                    
                                                          <select name="fathercaste" id="fathercaste" class="form-control">
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>Pure jaffna vellalar</option>
                        <option>Mixed jaffna vellalar</option>
                        <option>Other vellalar </option>
                        <option>Visvakulam</option>
                        <option>Mukkulathor</option>
                        <option>Kurukulam (Karayar)</option>
                        <option>Koviyar</option>
                        <option>Bhramin</option>
                        <option>Others</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Native of Mother</label>
                                        <input type="text" name="nativeofmother" id="nativeofmother" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                        <label>Mother's Caste</label>
                                
                                                 <select name="mothercaste" id="mothercaste" class="form-control">
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>Pure jaffna vellalar</option>
                        <option>Mixed jaffna vellalar</option>
                        <option>Other vellalar </option>
                        <option>Visvakulam</option>
                        <option>Mukkulathor</option>
                        <option>Kurukulam (Karayar)</option>
                        <option>Koviyar</option>
                        <option>Bhramin</option>
                        <option>Others</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Marital Status</label>
                                                <select name="marital" id="maritalstatus" class="form-control">
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>Unmarried</option>
                        <option>Divorce</option>
                        <option>Widow(er)</option>
                        <option>Nullified</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Children</label>
                                                     <select name="children" id="numberofchildren" class="form-control">
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>1</option>
                        <option>2</option>
                        <option>3</option>
                        <option>4</option>
                        <option>5</option>
                        <option>6</option>
                        <option>7</option>
                        <option>8</option>
                        <option>9</option>
                        <option>10</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Education</label>
                                        <input type="text" name="education" id="education" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                        <label>Occupation</label>
                                        <input type="text" name="occupation" id="occupation" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                        <label>Country of birth</label>
                                
                                         <select name="countryofbirth" id="countryofbirth" class="form-control">
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>Afghanistan</option>
                        <option>Albania</option>
                        <option>Algeria</option>
                        <option>Andorra</option>
                        <option>Angola</option>
                        <option>Antigua and Barbuda</option>
                        <option>Argentina</option>
                        <option>Armenia</option>
                        <option>Australia</option>
                        <option>Austria</option>
                        <option>Austrian Empire</option>
                        <option>Azerbaijan</option>
                        <option>Baden</option>
                        <option>Bahamas, The</option>
                        <option>Bahrain</option>
                        <option>Bangladesh</option>
                        <option>Barbados</option>
                        <option>Belarus</option>
                        <option>Bavaria</option>
                        <option>Belgium</option>
                        <option>Belize</option>
                        <option>Benin (Dahomey)</option>
                        <option>Bolivia</option>
                        <option>Bosnia and Herzegovina</option>
                        <option>Botswana</option>
                        <option>Brazil</option>
                        <option>Brunei</option>
                        <option>ABrunswick and Lüneburg</option>
                        <option>Bulgaria</option>
                        <option>Burkina Faso (Upper Volta)</option>
                        <option>Burma</option>
                        <option>Burundi</option>
                        <option>Cabo Verde</option>
                        <option>Cambodia</option>
                        <option>Cameroon</option>
                        <option>Canada</option>
                        <option>Cayman Islands, The</option>
                        <option>Central African Republic</option>
                        <option>Central American Federation</option>
                        <option>Chile</option>
                        <option>China</option>
                        <option>Colombia</option>
                        <option>Comoros</option>
                        <option>Congo Free State, The</option>
                        <option>Costa Rica</option>
                        <option>Croatia</option>
                        <option>Cuba</option>
                        <option>Cyprus</option>
                        <option>Czechoslovakia</option>
                        <option>Democratic Republic of the Congo</option>
                        <option>Denmark</option>
                        <option>Djibouti</option>
                        <option>Dominica</option>
                        <option>Dominican Republic</option>
                        <option>Duchy of Parma, The</option>
                        <option>East Germany (German Democratic Republic)</option>
                        <option>Ecuador</option>
                        <option>Egypt</option>
                        <option>El Salvador</option>
                        <option>Equatorial Guinea</option>
                        <option>Eritrea</option>
                        <option>Estonia</option>
                        <option>Eswatini</option>
                        <option>Ethiopia</option>
                        <option>Federal Government of Germany</option>
                        <option>Fiji</option>
                        <option>Finland</option>
                        <option>France</option>
                        <option>Gabon</option>
                        <option>Gambia, The</option>
                        <option>Georgia</option>
                        <option>Germany</option>
                        <option>Ghana</option>
                        <option>Grand Duchy of Tuscany</option>
                        <option>Greece</option>
                        <option>Grenada</option>
                        <option>Guatemala</option>
                        <option>Guinea</option>
                        <option>Guyana</option>
                        <option>Haiti</option>
                        <option>Hanover</option>
                        <option>Hawaii</option>
                        <option>Hesse</option>
                        <option>Holy See</option>
                        <option>Honduras</option>
                        <option>Hungary</option>
                        <option>Iceland</option>
                        <option>India</option>
                        <option>Indonesia</option>
                        <option>Iran</option>
                        <option>Iraq</option>
                        <option>Israel</option>
                        <option>Ireland</option>
                        <option>Israel</option>
                        <option>Italy</option>
                        <option>Jamaica</option>
                        <option>Japan</option>
                        <option>Jordan</option>
                        <option>Kazakhstan</option>
                        <option>Kenya</option>
                        <option>Kingdom of Serbia/Yugoslavia</option>
                        <option>Korea</option>
                        <option>Kosovo</option>
                        <option>Kuwait</option>
                        <option>Kyrgyzstan</option>
                        <option>Laos</option>
                        <option>Latvia</option>
                        <option>Lebanon</option>
                        <option>Lesotho</option>
                        <option>Liberia</option>
                        <option>Libya</option>
                        <option>Liechtenstein</option>
                        <option>Lithuania</option>
                        <option>Luxembourg</option>
                        <option>Madagascar</option>
                        <option>Malawi</option>
                        <option>Malaysia</option>
                        <option>Maldives</option>
                        <option>Mali</option>
                        <option>Malta</option>
                        <option>Marshall Islands</option>
                        <option>Mauritius</option>
                        <option>Mexico</option>
                        <option>Moldova</option>
                        <option>Monaco</option>
                        <option>Mongolia</option>
                        <option>Montenegro</option>
                        <option>Morocco</option>
                        <option>Namibia</option>
                        <option>Netherland</option>
                        <option>Nepal</option>
                        <option>New Zealand</option>
                        <option>Niger</option>
                        <option>Nigeria</option>
                        <option>North German Confederation</option>
                        <option>North German Union</option>
                        <option>North Macedonia</option>
                        <option>Norway</option>
                        <option>Oman</option>
                        <option>akistan</option>
                        <option>Panama</option>
                        <option>Papal States</option>
                        <option>Paraguay</option>
                        <option>Peru</option>
                        <option>Philippines</option>
                        <option>Poland</option>
                        <option>Portugal</option>
                        <option>Qatar</option>
                        <option>Republic of Korea (South Korea)</option>
                        <option>Republic of the Congo</option>
                        <option>Romania</option>
                        <option>Russia</option>
                        <option>Rwanda</option>
                        <option>Saint Kitts and Nevis</option>
                        <option>Saint Lucia</option>
                        <option>Saint Vincent and the Grenadines</option>
                        <option>Samoa</option>
                        <option>Saudi Arabia</option>
                        <option>Serbia</option>
                        <option>Senegal</option>
                        <option>Serbia</option>
                        <option>Singapore</option>
                        <option>Slovakia</option>
                        <option>Slovenia</option>
                        <option>Solomon Islands, The</option>
                        <option>South Africa</option>
                        <option>South Sudan</option>
                        <option>Spain</option>
                        <option>Sri Lanka</option>
                        <option>Sudan</option>
                        <option>Sweden</option>
                        <option>Switzerland</option>
                        <option>Syria</option>
                        <option>Tanzania</option>
                        <option>Texas</option>
                        <option>Thailand</option>
                        <option>Tonga</option>
                        <option>Turkey</option>
                        <option>Turkmenistan</option>
                        <option>Uganda</option>
                        <option>Ukraine</option>
                        <option>United Arab Emirates</option>
                        <option>United Kingdom</option>
                        <option>USA</option>
                        <option>Uruguay</option>
                        <option>Venezuela</option>
                        <option>Vietnam</option>
                        <option>Württemberg</option>
                        <option>Yemen</option>
                        <option>Zambia</option>
                        <option>Zimbabwe</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Country of Resident</label>
                                        <select name="countryofresident" id="countryofresident" class="form-control">
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>Afghanistan</option>
                        <option>Albania</option>
                        <option>Algeria</option>
                        <option>Andorra</option>
                        <option>Angola</option>
                        <option>Antigua and Barbuda</option>
                        <option>Argentina</option>
                        <option>Armenia</option>
                        <option>Australia</option>
                        <option>Austria</option>
                        <option>Austrian Empire</option>
                        <option>Azerbaijan</option>
                        <option>Baden</option>
                        <option>Bahamas, The</option>
                        <option>Bahrain</option>
                        <option>Bangladesh</option>
                        <option>Barbados</option>
                        <option>Belarus</option>
                        <option>Bavaria</option>
                        <option>Belgium</option>
                        <option>Belize</option>
                        <option>Benin (Dahomey)</option>
                        <option>Bolivia</option>
                        <option>Bosnia and Herzegovina</option>
                        <option>Botswana</option>
                        <option>Brazil</option>
                        <option>Brunei</option>
                        <option>ABrunswick and Lüneburg</option>
                        <option>Bulgaria</option>
                        <option>Burkina Faso (Upper Volta)</option>
                        <option>Burma</option>
                        <option>Burundi</option>
                        <option>Cabo Verde</option>
                        <option>Cambodia</option>
                        <option>Cameroon</option>
                        <option>Canada</option>
                        <option>Cayman Islands, The</option>
                        <option>Central African Republic</option>
                        <option>Central American Federation</option>
                        <option>Chile</option>
                        <option>China</option>
                        <option>Colombia</option>
                        <option>Comoros</option>
                        <option>Congo Free State, The</option>
                        <option>Costa Rica</option>
                        <option>Croatia</option>
                        <option>Cuba</option>
                        <option>Cyprus</option>
                        <option>Czechoslovakia</option>
                        <option>Democratic Republic of the Congo</option>
                        <option>Denmark</option>
                        <option>Djibouti</option>
                        <option>Dominica</option>
                        <option>Dominican Republic</option>
                        <option>Duchy of Parma, The</option>
                        <option>East Germany (German Democratic Republic)</option>
                        <option>Ecuador</option>
                        <option>Egypt</option>
                        <option>El Salvador</option>
                        <option>Equatorial Guinea</option>
                        <option>Eritrea</option>
                        <option>Estonia</option>
                        <option>Eswatini</option>
                        <option>Ethiopia</option>
                        <option>Federal Government of Germany</option>
                        <option>Fiji</option>
                        <option>Finland</option>
                        <option>France</option>
                        <option>Gabon</option>
                        <option>Gambia, The</option>
                        <option>Georgia</option>
                        <option>Germany</option>
                        <option>Ghana</option>
                        <option>Grand Duchy of Tuscany</option>
                        <option>Greece</option>
                        <option>Grenada</option>
                        <option>Guatemala</option>
                        <option>Guinea</option>
                        <option>Guyana</option>
                        <option>Haiti</option>
                        <option>Hanover</option>
                        <option>Hawaii</option>
                        <option>Hesse</option>
                        <option>Holy See</option>
                        <option>Honduras</option>
                        <option>Hungary</option>
                        <option>Iceland</option>
                        <option>India</option>
                        <option>Indonesia</option>
                        <option>Iran</option>
                        <option>Iraq</option>
                        <option>Israel</option>
                        <option>Ireland</option>
                        <option>Israel</option>
                        <option>Italy</option>
                        <option>Jamaica</option>
                        <option>Japan</option>
                        <option>Jordan</option>
                        <option>Kazakhstan</option>
                        <option>Kenya</option>
                        <option>Kingdom of Serbia/Yugoslavia</option>
                        <option>Korea</option>
                        <option>Kosovo</option>
                        <option>Kuwait</option>
                        <option>Kyrgyzstan</option>
                        <option>Laos</option>
                        <option>Latvia</option>
                        <option>Lebanon</option>
                        <option>Lesotho</option>
                        <option>Liberia</option>
                        <option>Libya</option>
                        <option>Liechtenstein</option>
                        <option>Lithuania</option>
                        <option>Luxembourg</option>
                        <option>Madagascar</option>
                        <option>Malawi</option>
                        <option>Malaysia</option>
                        <option>Maldives</option>
                        <option>Mali</option>
                        <option>Malta</option>
                        <option>Marshall Islands</option>
                        <option>Mauritius</option>
                        <option>Mexico</option>
                        <option>Moldova</option>
                        <option>Monaco</option>
                        <option>Mongolia</option>
                        <option>Montenegro</option>
                        <option>Morocco</option>
                        <option>Namibia</option>
                        <option>Nepal</option>
                        <option>Netherland</option>
                        <option>New Zealand</option>
                        <option>Niger</option>
                        <option>Nigeria</option>
                        <option>North German Confederation</option>
                        <option>North German Union</option>
                        <option>North Macedonia</option>
                        <option>Norway</option>
                        <option>Oman</option>
                        <option>akistan</option>
                        <option>Panama</option>
                        <option>Papal States</option>
                        <option>Paraguay</option>
                        <option>Peru</option>
                        <option>Philippines</option>
                        <option>Poland</option>
                        <option>Portugal</option>
                        <option>Qatar</option>
                        <option>Republic of Korea (South Korea)</option>
                        <option>Republic of the Congo</option>
                        <option>Romania</option>
                        <option>Russia</option>
                        <option>Rwanda</option>
                        <option>Saint Kitts and Nevis</option>
                        <option>Saint Lucia</option>
                        <option>Saint Vincent and the Grenadines</option>
                        <option>Samoa</option>
                        <option>Saudi Arabia</option>
                        <option>Serbia</option>
                        <option>Senegal</option>
                        <option>Serbia</option>
                        <option>Singapore</option>
                        <option>Slovakia</option>
                        <option>Slovenia</option>
                        <option>Solomon Islands, The</option>
                        <option>South Africa</option>
                        <option>South Sudan</option>
                        <option>Spain</option>
                        <option>Sri Lanka</option>
                        <option>Sudan</option>
                        <option>Sweden</option>
                        <option>Switzerland</option>
                        <option>Syria</option>
                        <option>Tanzania</option>
                        <option>Texas</option>
                        <option>Thailand</option>
                        <option>Tonga</option>
                        <option>Turkey</option>
                        <option>Turkmenistan</option>
                        <option>Uganda</option>
                        <option>Ukraine</option>
                        <option>United Arab Emirates</option>
                        <option>United Kingdom</option>
                        <option>USA</option>
                        <option>Uruguay</option>
                        <option>Venezuela</option>
                        <option>Vietnam</option>
                        <option>Württemberg</option>
                        <option>Yemen</option>
                        <option>Zambia</option>
                        <option>Zimbabwe</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>City</label>
                                        <input type="text" name="city" id="city" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                        <label>Phone Number</label>
                                        <input type="text" name="phonenumber" id="phonenumber" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                        <label>Address</label>
                                        <input type="text" name="address" id="address" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                        <label>Hobbies</label>
                                        <input type="text" name="hobbies" id="hobbies" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                        <label>Smoking</label>
                                     
                                                        <select name="smoking" id="smoking" class="form-control" >
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>non-smoker</option>
                        <option>occasionally</option>
                        <option>regularly</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Drinking</label>
                                                   <select name="drinking" id="drinking" class="form-control">
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>never drink</option>
                        <option>occasionally</option>
                        <option>frequently</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Eating habits</label>
                                             <select name="eatinghabits" id="eatinghabits" class="form-control">
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>vegetarian</option>
                        <option>non-vegetarian</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Description</label>
                                        <input type="text" name="description" id="description" class="form-control" placeholder="">
                                    </div>
                                    <div class="form-group">
                                        <label>Horoscope</label>
                                        <input type="file" name="Horoscope" id="horoscope" class="form-control">
                                      <img id="hor_img" style="border:5px solid;" width="100%">
                                        
                                          
                                    </div>
                                    <div class="form-group">
                                        <label>Image 1</label>
                                        <input type="file" name="image1" id="image1" class="form-control">
                                      <img id="img1" style="border:5px solid;" width="100%">
                                        
                                    </div>
                                    <div class="form-group">
                                        <label>Image 2</label>
                                        <input type="file" name="image2" id="image2" class="form-control">
                                           <img id="img2" style="border:5px solid;" width="100%">
                                    </div>
                                    <div class="form-group">
                                        <label>Sevvai dhosa paavam</label>
                                        <input type="text" name="sevvaidhosapaavam" id="sevvaidhosapaavam" class="form-control" placeholder="">
                                        <select name="sevvaidhosapaavam" id="sevvaidhosapaavam" class="form-control">
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>1</option>
                        <option>2</option>
                        <option>3</option>
                        <option>4</option>
                        <option>5</option>
                        <option>6</option>
                        <option>7</option>
                        <option>8</option>
                        <option>9</option>
                        <option>10</option>
                        <option>11</option>
                        <option>12</option>
                        <option>13</option>
                        <option>14</option>
                        <option>15</option>
                        <option>16</option>
                        <option>17</option>
                        <option>18</option>
                        <option>19</option>
                        <option>20</option>
                        <option>21</option>
                        <option>22</option>
                        <option>23</option>
                        <option>24</option>
                        <option>25</option>
                        <option>26</option>
                        <option>27</option>
                        <option>28</option>
                        <option>29</option>
                        <option>30</option>
                        <option>31</option>
                        <option>32</option>
                        <option>33</option>
                        <option>34</option>
                        <option>35</option>
                        <option>36</option>
                        <option>37</option>
                        <option>38</option>
                        <option>39</option>
                        <option>40</option>
                        <option>41</option>
                        <option>42</option>
                        <option>43</option>
                        <option>44</option>
                        <option>45</option>
                        <option>46</option>
                        <option>47</option>
                        <option>48</option>
                        <option>49</option>
                        <option>50</option>
                        <option>51</option>
                        <option>52</option>
                        <option>53</option>
                        <option>54</option>
                        <option>55</option>
                        <option>56</option>
                        <option>57</option>
                        <option>58</option>
                        <option>59</option>
                        <option>60</option>
                        <option>61</option>
                        <option>62</option>
                        <option>63</option>
                        <option>64</option>
                        <option>65</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Total kiraga paavam </label>
                                        <select name="totalkiragapaavam" id="totalkiragapaavam" class="form-control" >
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>1</option>
                        <option>2</option>
                        <option>3</option>
                        <option>4</option>
                        <option>5</option>
                        <option>6</option>
                        <option>7</option>
                        <option>8</option>
                        <option>9</option>
                        <option>10</option>
                        <option>11</option>
                        <option>12</option>
                        <option>13</option>
                        <option>14</option>
                        <option>15</option>
                        <option>16</option>
                        <option>17</option>
                        <option>18</option>
                        <option>19</option>
                        <option>20</option>
                        <option>21</option>
                        <option>22</option>
                        <option>23</option>
                        <option>24</option>
                        <option>25</option>
                        <option>26</option>
                        <option>27</option>
                        <option>28</option>
                        <option>29</option>
                        <option>30</option>
                        <option>31</option>
                        <option>32</option>
                        <option>33</option>
                        <option>34</option>
                        <option>35</option>
                        <option>36</option>
                        <option>37</option>
                        <option>38</option>
                        <option>39</option>
                        <option>40</option>
                        <option>41</option>
                        <option>42</option>
                        <option>43</option>
                        <option>44</option>
                        <option>45</option>
                        <option>46</option>
                        <option>47</option>
                        <option>48</option>
                        <option>49</option>
                        <option>50</option>
                        <option>51</option>
                        <option>52</option>
                        <option>53</option>
                        <option>54</option>
                        <option>55</option>
                        <option>56</option>
                        <option>57</option>
                        <option>58</option>
                        <option>59</option>
                        <option>60</option>
                        <option>61</option>
                        <option>62</option>
                        <option>63</option>
                        <option>64</option>
                        <option>65</option>
                        <option>66</option>
                        <option>67</option>
                        <option>68</option>
                        <option>69</option>
                        <option>70</option>
                        <option>71</option>
                        <option>72</option>
                        <option>73</option>
                        <option>74</option>
                        <option>75</option>
                        <option>76</option>
                        <option>77</option>
                        <option>78</option>
                        <option>79</option>
                        <option>80</option>
                        <option>81</option>
                        <option>82</option>
                        <option>83</option>
                        <option>84</option>
                        <option>85</option>
                        <option>86</option>
                        <option>87</option>
                        <option>88</option>
                        <option>89</option>
                        <option>90</option>
                        <option>91</option>
                        <option>92</option>
                        <option>93</option>
                        <option>94</option>
                        <option>95</option>
                        <option>96</option>
                        <option>97</option>
                        <option>98</option>
                        <option>99</option>
                        <option>100</option>
                        <option>101</option>
                        <option>102</option>
                        <option>103</option>
                        <option>104</option>
                        <option>105</option>
                        <option>106</option>
                        <option>107</option>
                        <option>108</option>
                        <option>109</option>
                        <option>110</option>
                        <option>111</option>
                        <option>112</option>
                        <option>113</option>
                        <option>114</option>
                        <option>115</option>
                        <option>116</option>
                        <option>117</option>
                        <option>118</option>
                        <option>119</option>
                        <option>120</option>
                        <option>121</option>
                        <option>122</option>
                        <option>123</option>
                        <option>124</option>
                        <option>125</option>
                        <option>126</option>
                        <option>127</option>
                        <option>128</option>
                        <option>129</option>
                        <option>130</option>
                        <option>131</option>
                        <option>132</option>
                        <option>133</option>
                        <option>134</option>
                        <option>135</option>
                        <option>136</option>
                        <option>137</option>
                        <option>138</option>
                        <option>139</option>
                        <option>140</option>
                        <option>141</option>
                        <option>142</option>
                        <option>143</option>
                        <option>144</option>
                        <option>113</option>
                        <option>114</option>
                        <option>115</option>
                        <option>116</option>
                        <option>117</option>
                        <option>118</option>
                        <option>119</option>
                        <option>120</option>
                        <option>121</option>
                        <option>122</option>
                        <option>123</option>
                        <option>124</option>
                        <option>125</option>
                        <option>126</option>
                        <option>127</option>
                        <option>128</option>
                        <option>129</option>
                        <option>130</option>
                        <option>131</option>
                        <option>132</option>
                        <option>133</option>
                        <option>134</option>
                        <option>135</option>
                        <option>136</option>
                        <option>137</option>
                        <option>138</option>
                        <option>139</option>
                        <option>140</option>
                        <option>141</option>
                        <option>142</option>
                        <option>143</option>
                        <option>144</option>
                        <option>145</option>
                        <option>146</option>
                        <option>147</option>
                        <option>148</option>
                        <option>149</option>
                        <option>150</option>
                    </select>
                                    </div>
                                    <div class="form-group">
                                        <label>Sevvai dhosa for lakna </label>
                                     
                                                  <select name="sevvaidhosaforlakna" id="sevvaidhosaforlakna" class="form-control">
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>nill</option>
                        <option>in 2-4-12</option>
                        <option>in 1-7-8</option>
                    </select>
                                    </div>
                                    
                                    <div class="form-group">
                                        <label>Resident Status</label>
                                                  <select name="resident_status" id="resident_status" class="form-control">
                        <option value="" label="Select" selected="selected">Select</option>
                        <option>Citizen</option>
                        <option>Permanent Resident</option>
                        <option>Work Permit</option>
                        <option>Student Visa</option>
                        <option>Refugee</option>
                        <option>Other</option>
                    </select>
                                    </div>
                                    
                                    <div class="form-group">
                                        <label>Active? </label>
                                          <input id='testNameHidden' type='hidden' value='0' name='isactive'>
                                        <input type="checkbox" name="isactive" id="isactive" class="form-control" value="0" placeholder="">
                                      
                                    </div>
 <!--
                                     <button type="submit" class="btn btn-primary">Submit</button>
                                   
                                    <div class="g-recaptcha" data-sitekey="6LdCO_oZAAAAAMJoyTzNT2mdV4eAmY7j_VE5M1-Q"></div> 
                                -->
                                </div>
                                <div class="modal-footer">
                                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                                    <button type="submit" name="updatedata" class="btn btn-primary">Update Data</button>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
                <!-- --------------------------------------------------------------------- end edit data ---------------------------------------- -->
                <!-- --------------------------------------------------------------------- start delete data ---------------------------------------- -->
                <div class="modal fade" id="deletemodal" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
                    <div class="modal-dialog">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title" id="exampleModalLabel">Delete Data</h5>
                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                            <form action="dashboard_files/db_connect/deletecode.php" method="post" enctype="multipart/form-data">
                                <div class="modal-body">
                                    <div class="form-group">
                                        <label> ID </label>
                                    
                                        
                                        <input name="delete_id" id="delete_id" readonly>
                                        <h4>Do you want to delete this ID?</h4>
                                    </div>
                                    <!-- <button type="submit" class="btn btn-primary">Submit</button> -->
                                </div>
                                <div class="modal-footer">
                                    <button type="button" class="btn btn-secondary" data-dismiss="modal">No</button>
                                    <button type="sumbit" name="deletedata" class="btn btn-primary">Yes !! Delete it.</button>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
                <!-- -------------------------------------------------------------------- end delete data ---------------------------------------- -->
                <!-- -----------------------------------------------------fetch data----------------------------------------------------------------------------------------------- -->
                <div class="">
                    <div class="">
                        <div class="table-responsive">
                            <table id="datatableid" class="table" style="background-color:black;color:white;table-layout: fixed;">
                                <thead>
                                    <tr style="font-size:16px;line-height:15px;">
                                        <th scope="col" style="width:10px;">ID</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">userID</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">name</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">Email</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">First Name</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">Last Name</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">profile seeking for</th>
                                        <th scope="col" style="width:100px;">Gender</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">date of birth</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">age</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">religion</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">language</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">complextion</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">caste</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">height</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">weight</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">your star</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">rasi</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">native of father</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">father caste</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">native of mother</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">mother caste</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">marital status</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">children</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">education</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">occupation</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">country of birth</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">country of resident</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">city</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">phone number</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">address</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">hobbies</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">smoking</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">drinking</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">eating habits</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">description</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">horoscope</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">image 01</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">image 02</th> 
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">sevvai dhosa paavam</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">total kiraga paavam</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">sevvai dhosa lakna</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">Resident Status</th>
                                        <th scope="col" style="visibility: hidden;overflow: hidden;">is active</th>
                                        <th scope="col" style="width:100px;">Horoscope</th>
                                        <th scope="col" style="width:100px;">Image 01</th>
                                        <th scope="col"style="width:100px;" >Image 02</th>  
                                        <th scope="col"style="width:100px;" >Active?</th>
                    
                                        <th scope="col" style="width:100px;">DELETE </th>
                                    </tr>
                                </thead>
                                <tbody>
                              
 
                                    <tr style="font-size:16px;">
                                        <td style="width:10px;">  <?php echo $row ['id']; ?></td>
                                        <td  style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['userID']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;"> <?php echo $row ['name']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;"> <?php echo $row ['email']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;"> <?php echo $row ['firstname']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;"> <?php echo $row ['lastname']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['profileseekingfor']; ?></td>
                                        <td style="width:100px;">
                                                  <button type="button" class="btn btn-success editbtn"> <?php echo trim($row ['gender']); ?></button>
                                        </td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['dob']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['age']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['religion']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['language']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['complextion']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['caste']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['height']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['weight']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['star']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['rasi']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['nativeoffather']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['fathercaste']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['nativeofmother']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['mothercaste']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['maritalstatus']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['numberofchildren']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['education']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['occupation']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['countryofbirth']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['countryofresident']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['city']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['phonenumber']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['address']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['hobbies']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['smoking']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['drinking']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['eatinghabits']; ?></td>
                                        <td style="visibility: hidden;overflow: hidden;height:0px !important;font-size:1px !important;"> <?php echo $row ['description']; ?></td>
                                        <td style="overflow: hidden;height:0px !important;font-size:1px !important;">
                                            <?php if($row['horoscope'] != ""): ?>
                                                        <?php echo $row['horoscope']; ?>
                                            <?php else: ?>
                                           
                                                          <?php echo 'images/default.png' ?>
                                            
                                            <?php endif; ?>
                                        </td>
                                        <td style="overflow: hidden;height:0px !important;font-size:1px !important;">
                                                 <?php if($row['image1'] != ""): ?>
                                                        <?php echo $row['image1']; ?>
                                            <?php else: ?>
                                           
                                                          <?php echo 'images/default.png' ?>
                                            
                                            <?php endif; ?>
                                        </td>
                                        <td style="overflow: hidden;height:0px !important;font-size:1px !important;">
                                         
                                            
                                                 <?php if($row['image2'] != ""): ?>
                                                        <?php echo $row['image2']; ?>
                                            <?php else: ?>
                                           
                                                          <?php echo 'images/default.png' ?>
                                            
                                            <?php endif; ?>
                                        </td>
                                        <td style="overflow: hidden;height:0px !important;font-size:1px !important;"><?php echo $row ['sevvaidhosapaavam']; ?></td>
                                        <td style="overflow: hidden;height:0px !important;font-size:1px !important;"><?php echo $row ['totalkiragapaavam']; ?></td>
                                        <td style="overflow: hidden;height:0px !important;font-size:1px !important;"><?php echo $row ['sevvaidhosaforlakna']; ?></td>
                                        <td style="overflow: hidden;height:0px !important;font-size:1px !important;"><?php echo $row ['resident_status']; ?></td>
                                              <td style="overflow: hidden;height:0px !important;font-size:1px !important;"><?php echo $row ['is_active']; ?></td>
                                        
                                        
                                          <td style="text-align:center; margin-top:10px; word-break:break-all; width:100px; line-height:100px;">
                                            <?php if($row['horoscope'] != ""): ?>
                                            <img src="uploads/<?php echo $row['horoscope']; ?>" width="100px" style="border:1px solid #333333;">
                                            <?php elseif($row['horoscope'] == "34efec1ef5db41395f06abdac9077ccd."): ?>
                                            <img src="images/default.jpeg" width="100px" style="border:1px solid #333333;">
                                            <?php endif; ?>
                                        </td>
                                        <td style="text-align:center; margin-top:10px; word-break:break-all; width:100px; line-height:100px;">
                                            <?php if($row['image1'] != ""): ?>
                                            <img src="uploads/<?php echo $row['image1']; ?>" width="100px"style="border:1px solid #333333;">
                                             <?php elseif($row['image1'] == "34efec1ef5db41395f06abdac9077ccd."): ?>
                                            <img src="images/default.jpeg" width="100px" style="border:1px solid #333333;">
                                            <?php endif; ?>
                                        </td>
                                        <td style="text-align:center; margin-top:10px; word-break:break-all; width:100px; line-height:100px;">
                                            <?php if($row['image2'] != ""): ?>
                                            <img src="uploads/<?php echo $row['image2']; ?>" width="100px" style="border:1px solid #333333;">
                                             <?php elseif($row['image2'] == "34efec1ef5db41395f06abdac9077ccd."): ?>
                                            <img src="images/default.jpeg" width="100px" style="border:1px solid #333333;">
                                            <?php endif; ?>
                                        </td>
                                        <td style="width:100px;">
                                            <?php 
                                    echo ($row['is_active']==1) ? "Active":"Deactive";
                                           
                                            ?>
                                        </td>
                                        <td style="width:100px;">
                                            <button type="button" class="btn btn-danger  deletebtn">DELETE</button>
                                        </td>
                                    </tr>
                                    <?php } ?>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </main>
    </div>
    <script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@4.5.3/dist/js/bootstrap.bundle.min.js" crossorigin="anonymous"></script>
    <script src="js/scripts.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.min.js" crossorigin="anonymous"></script>
    <script src="assets/demo/chart-area-demo.js"></script>
    <script src="assets/demo/chart-bar-demo.js"></script>
    <script src="assets/demo/chart-pie-demo.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@4.5.3/dist/js/bootstrap.bundle.min.js" integrity="sha384-ho+j7jyWK8fNQe+A12Hb8AhRq26LrZ/JpcUGGOn+Y7RsweNrtN/tE3MoK7ZeZDyx" crossorigin="anonymous"></script>
    <script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.1/dist/umd/popper.min.js" integrity="sha384-9/reFTGAW83EW2RDu2S0VKaIzap3H66lZH81PoYlFhbGU+6BZp6G7niu735Sk7lN" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@4.5.3/dist/js/bootstrap.min.js" integrity="sha384-w1Q4orYjBQndcko6MimVbzY0tgp4pWB4lZ7lr30WKz0vr/aWKhXdBNmNb5D92v7s" crossorigin="anonymous"></script>
    <script src="https://cdn.datatables.net/1.10.22/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.10.22/js/dataTables.bootstrap4.min.js"></script>
    <script>
        $(document).ready(function() {
             $(':input[type="submit"]').prop('disabled', true); 
            $('#datatableid').DataTable({
                // "pagingType": "full_numbers",
                // "lengthMenu" : [
                //[2,100,15s0,-1],
                // [2,100,150] 
                //[2,25,50,-1],
                // [2,25,50,"All"] 
              columnDefs: [
                {
                  targets: [1,2,3,4,5,6],
                  visible: false
                }
              ],
               "pageLength": 15,
                "paging": true,
                "ordering": false,
                "info": false,
                "deferRender": true
                //],
                // responsive: true,
                // language: {
                //search: "_INPUT_",
                //searchPlaceholder:"search your data here",
                // } 
            });
        });
    </script>
    <script>
 
/*
        $('.deletebtn').on('click', function() {
                
                delete_id
                
                ['delete_id']
                $('#deletemodal').modal('show');
                $tr = $(this).closest('tr');
                var data = $tr.children("td").map(function() {
                    return $(this).text();
                }).get();
                console.log(data);
                $('#delete_id').val(data[0]);
            });
*/
            $('.deletebtn').on('click', function() {
                
         
               
                $tr = $(this).closest('tr');
                var data = $tr.children("td").map(function() {
                    return $(this).text();
                }).get();
                
                 //$('#delete_id_button').val(data[0].trim());
                 $('#delete_id').val(data[0]);
                    $('#deletemodal').modal('show');
                console.log(data);
               
            });
     
    </script>
    <script>
     
            $('.editbtn').on('click', function() {
                $('#editmodal').modal('show');
                $tr = $(this).closest('tr');
                var data = $tr.children("td").map(function() {
                    return $(this).text();
                }).get();
              //  console.log(data);
                $('#id').val(data[0].trim());
                $('#userid').val(data[1].trim());
                $('#name').val(data[2].trim());
                $('#email').val(data[3].trim());
                $('#firstname').val(data[4].trim());
                $('#lastname').val(data[5].trim());
    
               $('#profileseekingfor').val(data[6].trim()); // profileseekingfor
               
                $('#gender').val(data[7].trim());
                $('#dob').val(data[8].trim());
                $('#age').val(data[9].trim());
                $('#religion').val(data[10].trim());
                $('#language').val(data[11].trim());
                $('#complextion').val(data[12].trim());
                $('#caste').val(data[13].trim());
                $('#height').val(data[14].trim());
                $('#weight').val(data[15].trim());
                $('#star').val(data[16].trim());
                $('#rasi').val(data[17].trim());
                $('#nativeoffather').val(data[18].trim());
                $('#fathercaste').val(data[19].trim());
                $('#nativeofmother').val(data[20].trim());
                $('#mothercaste').val(data[21].trim());
                $('#maritalstatus').val(data[22].trim());
                $('#numberofchildren').val(data[23].trim());
                $('#education').val(data[24].trim());
                $('#occupation').val(data[25].trim());
                $('#countryofbirth').val(data[26].trim());
                $('#countryofresident').val(data[27].trim());
                $('#city').val(data[28].trim());
                $('#phonenumber').val(data[29].trim());
                $('#address').val(data[30].trim());
                $('#hobbies').val(data[31].trim());
                $('#smoking').val(data[32].trim());
                $('#drinking').val(data[33].trim());
                $('#eatinghabits').val(data[34].trim());
                $('#description').val(data[35].trim());
       
                
                                                
            
                
                $('#sevvaidhosapaavam').val(data[39].trim());
                $('#totalkiragapaavam').val(data[40].trim());
                $('#sevvaidhosaforlakna').val(data[41]);
                $('#resident_status').val(data[42]);
                
                                     
               // var img = document.querySelector("#fotoMb");
               // img.src = "uploads/"+data[36].trim();  
           
           // $("#fotoMb").attr("src","https://shashwa.com/uploads/"+data[36]);
                //$("#hor_img").attr("style","background-image:url(uploads/"+data[36].trim()+"); background-repeat: no-repeat; width:100%; height:100%;");
                $("#hor_img").attr("src","uploads/"+data[36].trim());
                $("#img1").attr("src","uploads/"+data[37].trim());
                $("#img2").attr("src","uploads/"+data[38].trim());
                
                
                    var isactive = data[43].trim();
             
                if (isactive === "1"){
                  
                        $("#isactive").prop("checked", true);
                      $("#isactive").val('1');
                 //$("#is_active").attr("value", "1").checkboxradio('refresh');
                    
                    //  $("#is_active").val('1').checkboxradio('refresh');
                }else if(isactive === "0"){
                   
                 //  $("#is_active").attr("value", "0");
                      $("#isactive").val('0');
                     $("#isactive").prop("checked", false);
                }
  
                
                
              //  var blobData = data[36];
         //   var url = window.URL || window.webkitURL;
          //  var src = url.createObjectURL(Blob(data[36]);
         //   $('#fotoMb').attr("src", src);
                
             var datee=   (data[8].trim()).split("-");
               
                    year=datee[0];
                    month=datee[1];
                    day=datee[2];
                
            var   agee = calculate_age(new Date(year, month, day));
                  $("#age").val(agee );
            });
$('#isactive').change(function(){
     if($('#isactive').is(':checked')){
          $('#isactive').val('1');
         // $("#is_active").attr("value", "1");
     }else{
          $('#isactive').val('0');
         // $("#is_active").attr("value", "0");
     }
});
        
        function calculate_age(dob) { 
    var diff_ms = Date.now() - dob.getTime();
    var age_dt = new Date(diff_ms); 
  
    return Math.abs(age_dt.getUTCFullYear() - 1970);
}
        
        $('#my_edit_form input').on( 'input', function() {
  //This would be called if any of the input element has got a change inside the form
           // alert("form changed");
            $(':input[type="submit"]').prop('disabled', false);
}); 
    </script>
</body>
</html>
Output

You can jump to the latest bin by adding /latest to your URL

Dismiss x
public
Bin info
anonymouspro
0viewers