File "fetch_data.php"

Full Path: C:/wamp64/www/PERSONAL/Personal/fetch_data.php
File size: 2.36 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 area           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['area'];       // <-- nuevo campo
    $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);