PHPackages gangsterforms/sqledit - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. gangsterforms/sqledit ActiveProject[Database & ORM](/categories/database) gangsterforms/sqledit ===================== Generate web app to view, add and edit data in any MySQL table or Query in just 4 lines of code, with pagination auto generated as well, as are the media queries, to build a truly responsive app that is mobile friendly and works accross all platforms and screen sizes 04PHP Since Mar 12Pushed 7y ago1 watchersCompare [ Source](https://github.com/aviator001/sqlEdit)[ Packagist](https://packagist.org/packages/gangsterforms/sqledit)[ RSS](/packages/gangsterforms-sqledit/feed)WikiDiscussions master Synced 2mo ago READMEChangelogDependenciesVersions (1)Used By (0) Objective --------- [](#objective) Generate web app to view, add and edit data in any MySQL table or Query in just 4 lines of code, with pagination auto generated as well, as are the media queries, to build a truly responsive app that is mobile friendly and works accross all platforms and screen sizes. There are in fact 2 main functions, sqlEdit and sqlBrowse. As explained. sqlEdit has the ability ot add.modify data, however sqlBrowse can only generate view only apps. Quick Deploy and Use: --------------------- [](#quick-deploy-and-use) #### Deploy and use in under 2 minutes. Easy as 1-2-3: [](#deploy-and-use-in-under-2-minutes-easy-as-1-2-3) 1. Download to root or sub root folder using GIT or ZIP archive (ZIP will require unzipping) and navigate to 'sqlEdit' folder 2. Enter database credentials in settings.ini 3. Enter database and table name in sampleCode.php Practical Applications ---------------------- [](#practical-applications) #### 1.0 Rapid Development [](#10-rapid-development) #### 2.0 Ancillary Capacity to Primary Applications, such as: [](#20-ancillary-capacity-to-primary-applications-such-as) 2.1. Basic customer data management and admin tool 2.2. Fronted self help content editing tool for clients 2.3. Backend rporting tool for clients 2.4. Display daily billing summary 2.5. Display daily signup and customer traffic ..and so on... [](#) Requirements and Dependencies ----------------------------- [](#requirements-and-dependencies) ### PHP Classes [](#php-classes) - **sql.class.php**MySQLi Database abstraction and helper class, required in order for forms.class.php to work - **forms.class.php**Main class that implements all the functionality. Dependent on sql.class.php ### Server Operating Systen [](#server-operating-systen) - CentOS 7 64 Bit Server OS - Windows Server, Windows XP, Windows 7, Windows 8, Windows 10 OS - MacOS - MySQL sercer, MariaDB ### Server Operating Environment [](#server-operating-environment) - PHP > Ver 7.0 - MySQL - GD ### Development Languages [](#development-languages) PHP, MySQL Features ======== [](#features) 1.0 Data Manipulation --------------------- [](#10-data-manipulation) View, Browse, Edit, Add or Delete data from any MySQL table in an elegant and clean HTML table format #### 1.1 Browse MySQL Data [](#11-browse-mysql-data) Display data in any MySQL table in an elegant and clean HTML table format #### 1.2 Edit MySQL table in browser [](#12-edit-mysql-table-in-browser) Ajax edit data in any MySQL table in an elegant and clean HTML table Grid format #### 1.3 Add New Row [](#13-add-new-row) Add a new record to MySQL table that you are currently editing #### 1.4 Delete Row [](#14-delete-row) Delete record from MySQL table that you are currently editing 2.0 Data Presentation --------------------- [](#20-data-presentation) Provides multiple options, for best user experience #### 2.1 Auto detect mobile - 100% responsive [](#21-auto-detect-mobile---100-responsive) #### 2.2 Select View Mode: [](#22-select-view-mode) Switch easily between 2 display modes - Boxed format - Full width format #### 2.3 Select Data Presentation Format [](#23-select-data-presentation-format) Switch easily between 2 data formats - Grid View - Single record form mode 3.0 Pagination -------------- [](#30-pagination) The automatic pagination uses a truly unique approach to seemless handle datasets ranging from 10 rows to 2 million rows, all without any complicated juggling of page numbers or special case handling code - and what resulys is one of the cleanest pagination implementations that you will see, that handles 10 pages the same way it handles 2,000,000. See examples or screenshots for examples. Pagination may be turned off or on at any time by seeting the config values in the settings.ini file. 4.0 Auto Data Format -------------------- [](#40-auto-data-format) Easily switch back and forth between the 2 available views - Boxed layout or full width layout, used in order to ease cluttering and conjestion when working on tables with a large nuber of colums or fieldsets. There exists a trigger point, beyond which, if exceeded, the number of colums is exceeded, the display format switches automatically from the default 'grid view' to the row based 'fieldlist' mode, and each field is displayed on a new page row, and showing only one table record at a time. Subsequent rows are fetched upon the user requesting pages higher in number, using generated page links in the pagination area or by manipulating the page selctoe widget at the bottom of the screen. 5.0 Custom CSS -------------- [](#50-custom-css) User has full athority of look and feel etc and may set their own styles and class at the desgnated sections that handless css rules. 6.0 Flexibility and ease of Configuration ----------------------------------------- [](#60-flexibility-and-ease-of-configuration) Even though it is ridiculously simple to use, we still need to tell it where to find your databse/tables etc. This is done through the configuration file ('settings.ini'). It also has a bunch of other optional parameters, which if not set by you, have little impact on the proper functioning of the object. 7.0 User Experience. -------------------- [](#70-user-experience) Data is, without exception, loaded using the jquery ajax library, and as a rtesult, the user is never put through the experience of being constantly interrupted, while waiting for pages reloading over and over, and circumventing the creation of unnecessay high amount of stress externally in the network, and internally on the webserver filesystem i/o operations. Installation ------------ [](#installation) 2 step process. Get files, and configure. Done. You can get the source files in 2 ways. GIT or download a zip. ### Step 1 [](#step-1-) #### OPTION 1 [](#option-1) ``` git clone https://github.com/aviator001/sqlEdit.git ``` #### OPTION 2 [](#option-2) #### Download from link below:> [](#download-from-link-below) ``` https://gangsterforms.com/sqlEdit.zip ``` Once downloaded, unzip archive anywhere. ### Step 2 [](#step-2-) #### Configure settings.ini [](#configure-settingsini) Both options, GIT and Zip file download it will create a folder call sqlEdit. As part of the next an final step, you will configure your settings, by modifying the settings.ini file that is in the sqlEdit folder. Configure your settings.ini file with the information below and you mare done with configuration. Here is a full last of parameters that you can set in the settings.ini file.: - Database Server IP - Database Username - Database Password - Database Name And this is what settings.ini looks like ``` #Database user name db_user= #Database password db_pass= #Name of the database trying to connect to db_name= #Database Server IP Address without any quotes db_server= #Max number of items to be displayed per page items_per_page=5 #Max number of items to be displayed per page pagination=on ``` Running sqlEdit --------------- [](#running-sqledit) ### Step 1 [](#step-1) #### Edit sampleCode.php [](#edit-samplecodephp) Once settings.ini is configured, open up the sample code php file - and enter in values fro the database and table (first 2 lines as shown below.) ### Step 2 [](#step-2) #### Run sampleCode.php [](#run-samplecodephp) Open sampleCode.php in your browser, and you will be presented with the data from the table that you specified in editable format. Real World Code Samples ----------------------- [](#real-world-code-samples) ``` ``` /******************************************************************************* * Modify first 2 lines only! * $table: Enter the MySQL table that you want to edit data for, and, * $db_name: Enter the MySQL Database Name that has the table you want to edit *****************************************************************************/ $db_name="Enter database name"; $table="Enter name of table you want to edit"; parse_str(http_build_query($_GET)); include "class/utils.class.php"; $c=new utils; $c->connect(DB_SERVER,DB_USER,DB_PASS,$db_name); echo $c->SQLEdit($db_name,$table); include "paginate.php"; ``` ``` Quick User Guide ---------------- [](#quick-user-guide) Screenshots ----------- [](#screenshots) ### Health Score 18 — LowBetter than 8% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity3 Limited adoption so far Community7 Small or concentrated contributor base Maturity38 Early-stage or recently created project Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Community Maintainers ![](https://www.gravatar.com/avatar/0b93c38c37667d212722ce33e8c696734efe3421b990fb26bdf3670334f82be9?d=identicon)[aviator001](/maintainers/aviator001) --- Top Contributors [![aviator001](https://avatars.githubusercontent.com/u/12865879?v=4)](https://github.com/aviator001 "aviator001 (64 commits)") ### Embed Badge ![Health badge](/badges/gangsterforms-sqledit/health.svg) ``` [![Health](https://phpackages.com/badges/gangsterforms-sqledit/health.svg)](https://phpackages.com/packages/gangsterforms-sqledit) ``` ### Alternatives [doctrine/orm Object-Relational-Mapper for PHP 10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter a PHP SQL highlighting library 3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database The Illuminate Database package. 2.8k52.4M9.3k](/packages/illuminate-database)[mongodb/mongodb MongoDB driver library 1.6k64.0M545](/packages/mongodb-mongodb)[ramsey/uuid-doctrine Use ramsey/uuid as a Doctrine field type. 90340.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel Reliese Components for Laravel Framework code generation. 1.7k3.4M16](/packages/reliese-laravel) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)