File "fetch_data.php"

Full Path: C:/wamp64/www/Identifica_Piku/Personal/fetch_data.php
File size: 2.13 KB
MIME-type: text/x-php
Charset: utf-8

<?php include('../connection.php');

$sql = "SELECT * FROM empleados ";
$query = mysqli_query($con, $sql);
$count_all_rows = mysqli_num_rows($query);
if (isset($_POST['search']['value'])) {
    $search_value = $_POST['search']['value'];
    $sql .= "WHERE cedula LIKE '%" . $search_value . "%' ";
    $sql .= "OR nombre LIKE '%" . $search_value . "%' ";
    $sql .= "OR apellido LIKE '%" . $search_value . "%' ";
    $sql .= "OR rh LIKE '%" . $search_value . "%' ";	
    $sql .= "OR ccosto LIKE '%" . $search_value . "%' ";	
    $sql .= "OR descripcion LIKE '%" . $search_value . "%' ";
    $sql .= "OR cargo LIKE '%" . $search_value . "%' ";
    $sql .= "OR rango LIKE '%" . $search_value . "%' ";
}

if (isset($_POST['order'])) {
    $column = $_POST['order'][0]['column'];
    $order = $_POST['order'][0]['dir'];
    $sql .= " ORDER BY '" . $column . "' " . $order;
} else {
    $sql .= " ORDER BY id ASC";
}

$length = (isset($_POST["length"])) ? $_POST["length"] : -1;
$start = (isset($_POST["start"])) ? $_POST["start"] : 0;
if ($_POST['length'] != -1) {

    $start = $_POST['start'];
    $length = $_POST['length'];
    $sql .= " LIMIT " . $start . ", " . $length;
}

$data = array();

$run_query = mysqli_query($con, $sql);
$filtered_rows = mysqli_num_rows($run_query);
while ($row = mysqli_fetch_assoc($run_query)) {
    $subarray = array();
    $subarray[] = $row['id'];
    $subarray[] = $row['cedula'];
    $subarray[] = $row['nombre'];
	$subarray[] = $row['apellido'];
	$subarray[] = $row['rh'];
    $subarray[] = $row['ccosto'];
    $subarray[] = $row['descripcion'];
    $subarray[] = $row['cargo'];
    $subarray[] = $row['rango'];
    $subarray[] = '<a href="javascript:void(0);" data-id="' . $row['id'] . '" class="btn btn-md btn-info p-2 m-2 editBtn ">Editar</a><a href="javascript:void(0);" data-id="' . $row['id'] . '" class="btn btn-md btn-danger p-2 m-2 btnDelete">Eliminar</a>';
    $data[] = $subarray;
}

$output = array(
    'data' => $data,
    'draw' => intval($_POST['draw']),
    'recordsTotal' => $count_all_rows,
    'recordsFiltered' => $filtered_rows,
);



print json_encode($output);