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

Free Space:

32.43 GB

🔧 Quick Actions

✏️ Editing: search_by_all_data.php

<?php

include 'Database.php';

$crud = new Database();

if(@$_POST['name']) {

$name=$_POST['name'];

$town=$_POST['town'];

$sql="select * from member_info as i join member as m on i.member_id=m.id where i.name like '%$name%' and m.town='$town'" ;

$result = $crud->getAllData($sql);

$i = 1;

foreach($result as $row){

$sql1="select * from member where id='".$row['member_id']."'";

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

<button type="button" style="padding-right: 17px;

padding-left: 23px;" class="btn btn-custom btn-custom-secondary">view Detail</button>

</a>

</div>

</div>

<div class="address"><b>Address :</b><?php echo $result1['address']; ?></div>

</div>

<li>

<p>

<b>Age : </b><?php

# object oriented

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

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

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

<b>Blood Group : </b><?php echo $row['blood_group']; ?>

</p>

</li>

</ul>

</div>

<?php $i++; }

}

if(@$_POST['temple'])

{

$name=$_POST['temple'];

$town=$_POST['town'];

$sql="select * from member_info as i join member as m on i.member_id=m.id where m.relation_temple='$name' and i.relation='self' and m.town='$town'" ;

$result = $crud->getAllData($sql);

$i = 1;

foreach($result as $row){

$sql1="select * from member where id='".$row['member_id']."'";

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

<button type="button" style="padding-right: 17px;

padding-left: 23px;" class="btn btn-custom btn-custom-secondary">view Detail</button>

</a>

</div>

</div>

<div class="address"><b>Address :</b><?php echo $result1['address']; ?></div>

</div>

<li>

<p>

<b>Age : </b><?php

# object oriented

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

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

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

<b>Blood Group : </b><?php echo $row['blood_group']; ?>

</p>

</li>

</ul>

</div>

<?php $i++; }

}

if(@$_POST['profession'])

{

$name=$_POST['profession'];

$town=$_POST['town'];

$sql="select * from member_info as i join member as m on i.member_id=m.id where i.profession='$name' and m.town='$town'" ;

$result = $crud->getAllData($sql);

$i = 1;

foreach($result as $row){

$sql1="select * from member where id='".$row['member_id']."'";

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

<button type="button" style="padding-right: 17px;

padding-left: 23px;" class="btn btn-custom btn-custom-secondary">view Detail</button>

</a>

</div>

</div>

<div class="address"><b>Address :</b><?php echo $result1['address']; ?></div>

</div>

<li>

<p>

<b>Age : </b><?php

# object oriented

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

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

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

<b>Blood Group : </b><?php echo $row['blood_group']; ?>

</p>

</li>

</ul>

</div>

<?php $i++; }

}

if(@$_POST['income'])

{

$name=$_POST['income'];

$town=$_POST['town'];

$sql="select * from member_info as i join member as m on i.member_id=m.id where m.income='$name' and m.town='$town' and i.relation='self'";

$result = $crud->getAllData($sql);

$i = 1;

foreach($result as $row){

$sql1="select * from member where id='".$row['member_id']."'";

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

<button type="button" style="padding-right: 17px;

padding-left: 23px;" class="btn btn-custom btn-custom-secondary">view Detail</button>

</a>

</div>

</div>

<div class="address"><b>Address :</b><?php echo $result1['address']; ?></div>

</div>

<li>

<p>

<b>Age : </b><?php

# object oriented

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

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

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

<b>Blood Group : </b><?php echo $row['blood_group']; ?>

</p>

</li>

</ul>

</div>

<?php $i++; }

}

if(@$_POST['blood_group'])

{

$name=$_POST['blood_group'];

$town=$_POST['town'];

$sql="select * from member_info as i join member as m on i.member_id=m.id where i.blood_group='$name' and m.town='$town'";

$result = $crud->getAllData($sql);

$i = 1;

foreach($result as $row){

$sql1="select * from member where id='".$row['member_id']."'";

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

<button type="button" style="padding-right: 17px;

padding-left: 23px;" class="btn btn-custom btn-custom-secondary">view Detail</button>

</a>

</div>

</div>

<div class="address"><b>Address :</b><?php echo $result1['address']; ?></div>

</div>

<li>

<p>

<b>Age : </b><?php

# object oriented

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

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

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

<b>Blood Group : </b><?php echo $row['blood_group']; ?>

</p>

</li>

</ul>

</div>

<?php $i++; }

}

if(@$_POST['zone'])

{

$name=$_POST['zone'];

$town=$_POST['town'];

$sql="select * from member_info as i join member as m on i.member_id=m.id where m.zone='$name' and i.relation='self' and m.town='$town'" ;

$result = $crud->getAllData($sql);

$i = 1;

foreach($result as $row){

$sql1="select * from member where id='".$row['member_id']."'";

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

<button type="button" style="padding-right: 17px;

padding-left: 23px;" class="btn btn-custom btn-custom-secondary">view Detail</button>

</a>

</div>

</div>

<div class="address"><b>Address :</b><?php echo $result1['address']; ?></div>

</div>

<li>

<p>

<b>Age : </b><?php

# object oriented

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

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

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

<b>Blood Group : </b><?php echo $row['blood_group']; ?>

</p>

</li>

</ul>

</div>

<?php $i++; }

}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: search_by_all_data.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation