PHP Classes

File: table_fetch.php

Recommend this page to a friend!
  Classes of Mehmet Kidiman  >  Developbat PHP CRUD  >  table_fetch.php  >  Download  
File: table_fetch.php
Role: Example script
Content type: text/plain
Description: Example script
Class: Developbat PHP CRUD
Show pages to manage table records using Bootstrap
Author: By
Last change:
Date: 11 months ago
Size: 4,473 bytes
 

Contents

Class file image Download
<?php
header
("Content-type: application/json; charset=utf-8");
/*ini_set('display_startup_errors', 1);
ini_set('display_errors', 1);
error_reporting(-1);*/
include('config.php');
include(
'functions.php');


if(isset(
$_SESSION["selectedtable"])){
   
$tablePost = $_SESSION["selectedtable"];
}else{
   
$tablePost = $_POST['table'];
}

$relations = '';
$findRow = '';
$relatedTable = '';
$relatedRow = '';
$getRow = '';

if (isset(
$relationTable[$tablePost])) {
   
$isRelation = 1;
   
$relations = $relationTable[$tablePost];

   
$changedRow = $relations['changedRow'];
   
$secondTable = $relations['secondTable'];
   
$secondRow = $relations['secondRow'];
   
$findRow = $relations['findRow'];
}else {
   
$isRelation = 0;
}
if(isset(
$imageColums[$tablePost])){
   
$isImage = 1;
}else{
   
$isImage = 0;
}

function
cleanHard($string) {
   
$string = str_replace(' ', '-', $string); // Replaces all spaces with hyphens.

   
return preg_replace('/[^A-Za-z0-9\-]/', '', $string); // Removes special chars.
}
function
cleansoft($string) {
    return
$string = str_replace('\'', ' ', $string); // Replaces all spaces with hyphens.

   // return preg_replace('/[^A-Za-z0-9\-]/', '', $string); // Removes special chars.
}

function
clean($string)
{
   
//$string = str_replace(' ', '-', $string); // Replaces all spaces with hyphens.
   
$string = preg_replace('/[^A-Za-z0-9\-]/', ' ', $string); // Removes special chars.
    //$string = preg_replace("'", "", $string); // Removes ' chars.
    //$string = preg_replace("/(?<!\d)(\,|\.)(?!\d)/", "", $str);
   
return preg_replace('/-+/', ' - ', $string); // Replaces multiple hyphens with single one.
}

$columns = showColums($connect, $tablePost);
$columnCount = count($columns);

$query = "Select * from $tablePost ";

if (isset(
$_POST['order'])) {
   
$query .= 'ORDER BY ' . $_POST['order']['0']['column'] . ' ' . $_POST['order']['0']['dir'] . ' ';
}
//$query .=" LIMIT 1999";

$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$filtered_rows = $statement->rowCount();

$data = array();
$number =0;
foreach (
$result as $row) {

   
$sub_array = array();

    for (
$x = 0; $x < $columnCount; $x++) {


            if (
$isRelation == 1 &&$columns[$x][0] == $changedRow) {

               
$changeRow = getRelatedRow($connect, $secondTable, $secondRow, $row[$x], $findRow);
                if (isset(
$changeRow)) {
                   
$sub_array[] = '<b style="color:#006699;">' . $changeRow . '</b>';
                } else {
                   
$sub_array[] = '<b style="color:red;"> Relation Error ! </b>';
                }

            } else if (
$isImage == 1 && $imageColums[$tablePost] == $columns[$x][0]){

                   
$imgAray = json_decode($row[$x], true);
                   
// $imgArays = explode(",", $imgAray);
                   
$html = '';
                    if (
$imgAray) {
                         foreach (
$imgAray as $img){
                        
$html .=$img.'-';
                         }
                        
$htmlnospace = str_replace(' ', '/', $html);;
                       
$sub_array[] = '<button onclick="showFiles('.$number.')" class="btn btn-default"><i class="glyphicon glyphicon-file"></i><span class="badge badge-dark">'. count($imgAray).'</span></button>
                                                     <input type="hidden" value="'
.$htmlnospace.'" id = "'.$number.'"/>';
                    }else{
                       
$sub_array[] = $html;
                    }

                } else {
                  
// $sub_array[] = utf8_encode($row[$x]);
                   
$sub_array[] =$row[$x];
                }


    }




   
$sub_array[] = '<td><button class="edit" onclick="editTable(' . $row [0] . ');" id="e' . $row [0] . '" ><i class="glyphicon glyphicon-edit" ></i></button></td>';
   
$sub_array[] = '<td><button class="dell" onclick="dellTable(' . $row [0] . ');" id="d' . $row [0] . '" ><i class="glyphicon glyphicon-remove" ></i></button></td>';
   
$data[] = $sub_array;
   
$number++;
}
function
get_total_all_records($connect, $tablePost)
{

   
$statement = $connect->prepare("SELECT * FROM $tablePost ");
   
$statement->execute();
    return
$statement->rowCount();
}

$output = array(
   
// "draw" => intval($_POST["draw"]),
   
"recordsTotal" => $filtered_rows,
   
"recordsFiltered" => get_total_all_records($connect, $tablePost),
   
"data" => $data
);

echo
json_encode($output);


?>

For more information send a message to info at phpclasses dot org.