PHP Classes

Developbat PHP CRUD: Show pages to manage table records using Bootstrap

Recommend this page to a friend!
  Info   View files Documentation   Demos   View files View files (36)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2021-08-02 (10 months ago) RSS 2.0 feedNot yet rated by the usersTotal: 108 This week: 1All time: 9,482 This week: 159Up
Version License PHP version Categories
developbat 1.0.0Freely Distributable5HTML, PHP 5, Databases
Description Author

This package can show pages to manage table records using Bootstrap.

It can take a given list of database tables and relations between them to show pages to allow the users to perform several types of operations to manipulate the table records.

Currently, it can create, edit, delete and list the records of the specified database tables.

The package can also check table column types to determine the primary key, the fields that can be null, or the fields that can have enumerated values.

It also supports uploading files to store records, search for records checking multiple columns, save the listings in Excel or PDF formats.

Picture of Mehmet Kidiman
  Performance   Level  
Name: Mehmet Kidiman <contact>
Classes: 1 package by
Country: Turkey Turkey
Age: ???
All time rank: 432682 in Turkey Turkey
Week rank: 161 Up3 in Turkey Turkey Up

Details

DEVELOPBAT PHP CRUD SYSTEM

What is this?

It is php crud class with Bootsrap and Datatable features. DevelopbatCrud alow you create, edit, delete, and listing your database tables easily. it also check table columns types and feature to figurout is it primary or nullable or is it enum to deside right action to edit and create or listing data. it listed table with relation if it defined and allow to multiple image upload also if its defined column . Its allow multi clomn seacrh and it allows the results to be saved as an excel or pdf.

How to start ?

you have to edit config.php to add your database credentials. to show all table $showTables = array(); // show all tables mode

or you can show specific tables if you add names in array

$showTables = [

['depo'],
['kontak']

]; //show only in array tables

Relation between tables :

you can related tables column each other with added them on aray as $relationTable. it can change the value showing table value as related value.

define showing table name like 'depo' define in 'depo' wich column will change as changedRow define second table related with first one as secondTable define second table related column with first one as secondRow define second table column will shown as first table findRow

in the end changedRow will be shown as findRow

$relationTable = [

'depo' => [
     'changedRow' => "super_id",
     'secondTable' => "members",
     'secondRow' => "memberID",
     'findRow' =>"username"
    ],
'gelir_gider' => [
    'changedRow' => "uid",
    'secondTable' => "members",
    'secondRow' => "memberID",
    'findRow' =>"username"
]

];

Image Upload defination :

define table name as key and column as value . this configuration will make selected column to allow image upload and it will store image links on it. $imageColums = [

'depo' => "images"

];

example link https://developbat.com/testcrud/

  DevelopbatCrudExternal page  
  Files folder image Files  
File Role Description
Files folder image.idea (3 files)
Files folder imageclass (2 files)
Files folder imagecss (3 files)
Files folder imagejs (13 files)
Accessible without login Plain text file add_action.php Aux. Auxiliary script
Accessible without login Plain text file config.php Example Example script
Accessible without login Plain text file data_action.php Example Example script
Accessible without login Plain text file data_action_orj.php Example Example script
Accessible without login Plain text file footer.php Aux. Auxiliary script
Accessible without login Plain text file functions.php Example Example script
Accessible without login Plain text file header.php Aux. Auxiliary script
Accessible without login Plain text file index.php Aux. Auxiliary script
Accessible without login Plain text file killsession.php Aux. Auxiliary script
Accessible without login Plain text file README.md Doc. Documentation
Accessible without login Plain text file tables.php Aux. Auxiliary script
Accessible without login Plain text file table_fetch.php Example Example script
Accessible without login Plain text file test.php Aux. Auxiliary script
Accessible without login Plain text file update_action.php Example Example script
Accessible without login Plain text file upload.php Aux. Auxiliary script

  Files folder image Files  /  .idea  
File Role Description
  Accessible without login Plain text file .name Data Auxiliary data
  Accessible without login Plain text file modules.xml Data Auxiliary data
  Accessible without login Plain text file vcs.xml Data Auxiliary data

  Files folder image Files  /  class  
File Role Description
  Plain text file crudClass.php Class Class source
  Plain text file typeClass.php Class Class source

  Files folder image Files  /  css  
File Role Description
  Accessible without login Plain text file bootstrap.min.css Data Auxiliary data
  Accessible without login Plain text file dataTables.bootstrap.min.css Data Auxiliary data
  Accessible without login Plain text file datepicker.css Data Auxiliary data

  Files folder image Files  /  js  
File Role Description
  Accessible without login Plain text file bootstrap-datepicker1.js Data Auxiliary data
  Accessible without login Plain text file bootstrap.min.css Data Auxiliary data
  Accessible without login Plain text file bootstrap.min.js Data Auxiliary data
  Accessible without login Plain text file datalist.polyfill.js Data Auxiliary data
  Accessible without login Plain text file datalist.polyfill.min.js Data Auxiliary data
  Accessible without login Plain text file dataTables.bootstrap.min.js Data Auxiliary data
  Accessible without login Plain text file forecast_yandex.js Data Auxiliary data
  Accessible without login Plain text file jquery-1.10.2.min.js Data Auxiliary data
  Accessible without login Plain text file jquery-1.11.1.min.js Data Auxiliary data
  Accessible without login Plain text file jquery.dataTables.min.js Data Auxiliary data
  Accessible without login Plain text file jquery.js Data Auxiliary data
  Accessible without login Plain text file session.js Data Auxiliary data
  Accessible without login Plain text file session_count.js Data Auxiliary data

 Version Control Unique User Downloads Download Rankings  
 100%
Total:108
This week:1
All time:9,482
This week:159Up
For more information send a message to info at phpclasses dot org.