MAINHACK

Viewing / Editing File: ajax_check.php

<?php

session_start();
ob_start();
include 'inc/database.php';
include 'inc/db.php';
include 'inc/oops.php';
$database = new Db();
$db = $database->getConnection();
$show=new Oops($db);
if(isset($_POST["userid"]))  
 { 
$table='product_img';
$stmt=$show->readwithdata($table,'id',$_POST['userid']);
$row = $stmt->fetch(PDO::FETCH_ASSOC);  
echo json_encode($row);  
 }
 
if(isset($_POST['fli'])){
$request =trim($_POST["fli"]);
$query2="SELECT * FROM client WHERE client_id like '$request%' || company_name like '$request%' || contact_person1 like '$request%' || phone1 like '$request%'  ";
$stmt=$con->prepare($query2);
$stmt->execute();
$r=$stmt->rowCount();
if($r){
echo "<ul>";
while($row=$stmt->fetch(PDO::FETCH_ASSOC)){
{

<li class='show' align='left' onclick='fill("<?php echo $row['client_id'];?>","<?php echo $row['company_name'];?>","<?php echo $row['contact_person1'];?>","<?php echo $row['phone1'];?>")'><?php echo $row['client_id']; ?> | <?php echo $row['company_name']; ?> | <?php echo $row['contact_person1'];?> | <?php echo $row['phone1'];?></li>
<?php

}

}
}
} 
if(isset($_POST['category'])){
$show=new Oops($db);
?>
	
<?php  
$table='job';
$stmt=$show->readwithdata($table,'job_id',$_POST['category']);
$num=$stmt->rowCount();
if($num>0){
while($row=$stmt->fetch(PDO::FETCH_ASSOC)){

echo $row['description'];
}
}else{
    echo"";
}

<?php 
}
if(isset($_POST['project_id'])){
$request =trim($_POST["project_id"]);
$query2="SELECT * FROM project WHERE project_id like '$request%' || project_name like '$request%' || name like '$request%' || phone like '$request%'  ";
$stmt=$con->prepare($query2);
$stmt->execute();
$r=$stmt->rowCount();
if($r){
echo "<ul>";
while($row=$stmt->fetch(PDO::FETCH_ASSOC)){
{

<li class='show' align='left' onclick='fill("<?php echo $row['project_id'];?>","<?php echo $row['project_name'];?>","<?php echo $row['client_id'];?>","<?php echo $row['name'];?>","<?php echo $row['phone'];?>","<?php echo $row['start_date'];?>","<?php echo $row['end_date'];?>","<?php echo $row['cost'];?>","<?php echo $row['status'];?>","<?php echo $row['due'];?>","<?php echo $row['gst'];?>","<?php echo $row['total'];?>")'><?php echo $row['project_id']; ?> | <?php echo $row['project_name']; ?> | <?php echo $row['client_id']; ?> | <?php echo $row['name'];?> | <?php echo $row['phone'];?></li>
<?php

}

}
}
} 
if(isset($_POST['project_id_show'])){
$show=new Oops($db);
?>
 <table class="table table-hover table-striped" id='example'>
                                        <thead>
                                            <th>ID</th>
                                            <th>Entry Date</th>
                                            <th>Payment Date</th>
                                            <th>Amount</th>
                                            <th>Gst</th>
                                            <th>Total</th>
                                            <th>Remark</th>
                                            
                                            
                                        </thead>
                                        <tbody>
		
<?php
$count=1;
$stmt =$show->readwithdata('payment','project_id',$_POST['project_id_show']);
$num = $stmt->rowCount();
     
     if($num>0){
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];     
    
        echo "<tr>
	        <td>$count</td>
			<td>".date('d-m-Y',strtotime($row['entry_date']))."</td>
			<td>".date('d-m-Y',strtotime($row['date']))."</td>
		    <td>".$row['amount']."</td>
		    <td>".$row['gst']."</td>
		    <td>".$row['total']."</td>
		    <td>".$row['remarks']."</td>
		   
           
        </tr>";
        ++$count;
        }
        }?>
       </tbody>
                                   
                                    </table>

<?php
    
}
 ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: ajax_check.php

Server Info

System Features

User Info