PHP Classes
elePHPant
Icontem

RA PHP MySQL CRUD class: Manipulate data in MySQL database tables

Recommend this page to a friend!
     
  Info   View files Example   View files View files (14)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2019-07-02 (10 hours ago) RSS 2.0 feedNot yet rated by the usersTotal: 210 This week: 2All time: 8,125 This week: 128Up
Version License PHP version Categories
ra-server_classtable 1.0.1Freely Distributable7PHP 5, Databases
Description Author

This package can manipulate data in MySQL database tables.

It can connect to a given MySQL database server and performs several types of operations to manipulate records in a given database table. Currently it can:

- Check if the table exists
- Retrieve the record data in the whole table with support to limit the number of records that are retrieved and sort in ascending or descending order
- Get the count of rows and columns in the table
- Get one record with a given id value
- Get the values of a column of the table
- Get the names of the table column
- Insert a record into the table
- Delete one record from table
- Query the table with a given condition
- Update a record of the table
  Performance   Level  
Name: Rafal Antczak <contact>
Classes: 2 packages by
Country: Poland Poland

Level 1 Star

Details
Class Table, typical CRUD class which allows add, edit, read and delete records/fields/tables of any MySQL database
2019, ra-server.pl
Licence: free to use and edit

Run index.php first and follow the instruction

Replace database connection parameters in db_params.php
  Files folder image Files  
File Role Description
Plain text file class.table.php Class Class source
Accessible without login Plain text file db_params.php Aux. Auxiliary script
Accessible without login Plain text file example_add_record.php Example Example script
Accessible without login Plain text file example_delete_record.php Example Example script
Accessible without login Plain text file example_get_column.php Example Example script
Accessible without login Plain text file example_get_row.php Example Example script
Accessible without login Plain text file example_get_table.php Example Example script
Accessible without login Plain text file example_get_table_fields.php Example Example script
Accessible without login Plain text file example_get_table_info.php Example Example script
Accessible without login Plain text file example_get_table_with_limit.php Example Example script
Accessible without login Plain text file example_get_table_with_query.php Example Example script
Accessible without login Plain text file example_update_record.php Example Example script
Accessible without login Plain text file index.php Aux. Auxiliary script
Accessible without login Plain text file readme.txt Doc. Documentation

Downloadra-server_classtable-2019-07-02.zip
Downloadra-server_classtable-2019-07-02.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:210
This week:2
All time:8,125
This week:128Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.