Message: Return type of CI_Session_files_driver::open($save_path, $name) should either be compatible with SessionHandlerInterface::open(string $path, string $name): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Message: Return type of CI_Session_files_driver::close() should either be compatible with SessionHandlerInterface::close(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Message: Return type of CI_Session_files_driver::read($session_id) should either be compatible with SessionHandlerInterface::read(string $id): string|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Message: Return type of CI_Session_files_driver::write($session_id, $session_data) should either be compatible with SessionHandlerInterface::write(string $id, string $data): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Message: Return type of CI_Session_files_driver::destroy($session_id) should either be compatible with SessionHandlerInterface::destroy(string $id): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Message: Return type of CI_Session_files_driver::gc($maxlifetime) should either be compatible with SessionHandlerInterface::gc(int $max_lifetime): int|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Message: Cannot modify header information - headers already sent by (output started at /home/palugada/domains/envato.palugada.top/public_html/system/core/Exceptions.php:271)
tag:envato.palugada.top/codecanyon:/feeds/new-php-scripts-slash-database-abstractions-itemsCodecanyon new Database Abstractions items2025-12-18 05:03:34tag:codecanyon:Item/198327662017-05-01 00:57:062017-05-01 00:57:06Installer for Codeigniter Application (Database Abstractions) <p><img src="http://swot.co.in/envato/installer_promo2.jpg" alt="Special Offer Price" /> <br /><br />
Codeigniter Application Installer is an eloquent module that makes your codeigniter application installation so easy as breeze. It makes the necessary changes of your config/config, config/database & config/email files, database upload – all things in a single click. You can use this installation for all of your codeigniter applications, particularly for your selling applications with this easy installer. <br />
</p><h3 id="item-description__just-extract-the-source-code-in-your-codeigniter-parent-folder-and-run-the">Just extract the source code in your Codeigniter Parent folder and Run the Installer!</h3>
<img src="http://swot.co.in/envato/ci_installer.jpg" alt="codeigniter installer" />
<br />
<h2 id="item-description__software-features">Software Features</h2>
<ul>
<li>Single Click Installation</li>
<li>Instant Database File Uploader</li>
<li>Application Config File Updater</li>
<li>Database Config File Updater</li>
<li>Email Config File Updater</li>
<li>Can use it multiple Codeigniter applications</li>
<li>Easy to use Bootstrap UI</li>
<li>Clear Documentation</li>
</ul>
<h2 id="item-description__change-log">Change Log</h2>
<ul>
<li><strong>Version 1.0 (28.04.2017)</strong>
<ul>
<li>First Release</li>
</ul>
</li>
</ul>
<a href="http://codecanyon.net/downloads"><img src="http://swot.co.in/envato/rating.jpg?ver=2" alt="Rate Us" /></a> <br /><br />
<a href="http://swotsolutions.in/support/" rel="nofollow"><img src="http://swot.co.in/envato/support.jpg" alt="SWOT Support Ticket System" /></a>nkm_swottag:codecanyon:Item/196098642017-04-05 23:32:542017-04-05 23:32:54Rapidata - A Simple Test Data Filler for MySQL (Database Abstractions) <h2 id="item-description__rapidata-a-simple-test-data-filler-for-mysql">Rapidata – A Simple Test Data Filler for MySQL</h2>
<p>Rapidata is a PHP application that helps application owners to rapidly populate there database with random real life data for sufficient testing purposes.</p>
<p>Remember that time your application is almost ready but you discover a bug because you had not tested with sufficient data?
Or that time you want to showcase your app but oops, there is no data to make the application look alive!
Its all right! As you know entering enough amounts of test data is timeconsuming. With this app, not any more. You will save a lot of time using this app to automatically generate random, suitable real life data for your application.Better still,if you dont have much time to tell the app details about your database it will smart guess the best suitable kind of data for your tables. This app will also help you prepare a nice demonstrate of your app with such kind of data. Its a great way to visualize your application from beginning of development to the end.</p>
<h3 id="item-description__features">Features</h3>
<ul>
<li> Quickly automatically generate and fill data- With only 3 clicks</li>
<li> Real life data like. people names, addresses, towns , countries etc</li>
<li> Smart guessing the suitable data using table and column names.</li>
<li> Orders the tables in a way the foreign key dependencies do not collide.</li>
<li> Run the insert queries inside the app</li>
<li> Download generated data in sql file</li>
<li> Takes care of primary keys, auto_increment, unique keys and foreign keys.</li>
<li> Preview the data- you can edit it too</li>
<li> Saves project progress data.</li>
<li> Learns your database naming with time</li>
</ul>
<h3 id="item-description__installation">Installation</h3>
<h4 id="item-description__requirements">Requirements</h4>
<ol>
<li> PHP v5.0 or above</li>
<li> Apache server</li>
<li> MySQL</li>
<li> A computer of course</li>
</ol>
<h4 id="item-description__how-to">H<a href="http://dsdas.com" rel="nofollow"></a>ow to?</h4>
Simple…Copy the code into your htdocs folder and run it in your browser.
<h3 id="item-description__demo">Demo</h3>
<a href="http://rapidata.onion.co.ke" rel="nofollow">http://rapidata.onion.co.ke</a>
<p>Login credentials already provided in the demo.</p>Mist-Teamtag:codecanyon:Item/195279232017-03-17 01:38:562017-03-17 01:38:56Super Datagrid - jQuery Datagrid for Laravel & Codeigniter (Database Abstractions) <p>Looking for a fast datagrid system for your app?</p>
<p><b>Super Datagrid</b> can be your choice, this plugin is quite light and has many features that will speed up your application development process. This plugin helps you to display data from server without thinking about the basic features of the datagrid such as paging, sorting or searching.</p>
<p>In addition, this plugin comes with complex features that we usually encounter when trying to process the data in the datagrid such as selecting the data en masse to edit or delete process, inline editing data, or displaying datagrid details. We also provide PHP classes to facilitate you to integrate the Datagrid with Laravel and Codeigniter framework. Of course you can still change the backend part with other language or framework. The example application contains CRUD system in Laravel, CodeIgniter, and Lumen framework.</p>
<h3 id="item-description__features">Features</h3>
<ul>
<li>Basic Datagrid features such as sort, filter, pagination.</li>
<li>Inline editable</li>
<li>Custom filter</li>
<li>Multiple row selection</li>
<li>Merge cells</li>
<li>Custom row data</li>
<li>Form loader</li>
<li>Datagrid details</li>
<li>PHP class for Laravel and Codeigniter</li>
<li>CRUD example</li>
<li>Well documented</li>
<li>Full customer support</li>
</ul>
<h3 id="item-description__demo-and-documentation">Demo and Documentation</h3>
<ul>
<li><a href="http://native-theme.com/superdatagrid/" rel="nofollow">Demo</a></li>
<li><a href="http://native-theme.com/superdatagrid/docs" rel="nofollow">Documentation</a></li>
</ul>
<h3 id="item-description__requirements">Requirements</h3>
<ul>
<li>Apache web server for running php</li>
<li>Mysql database server</li>
</ul>Native-Themetag:codecanyon:Item/93292632014-10-30 20:01:012016-10-26 00:20:17SWOT DB - Database & Spreadsheet App (Database Abstractions) <p><strong>SWOT DB</strong> is an awesome database management system that can be used as <strong>Online Database Management Tool</strong>, <strong>Spreadsheet Application</strong> or <strong>Full Featured Web Application</strong>. Current 1.2 version comes with <strong>Spreadsheet Playground</strong> which is great feature for spreadsheet lovers whom need to analyze the database in excel or spreadsheet applications. <br /><br />
<strong>SWOT DB</strong> built with Codeigniter PHP Framework and its comes with full featured 16 Built-in Themes, Multiple Languages with Localization Plugin, Import data from .csv, Export Data, Database Operations and also <strong>One Click Quick Installer </strong> (detailed instructions for installation given in support manual).
<br />
<br />
<img src="http://swot.co.in/envato/swotdb-banner.jpg" alt="Database Software" />
<br />
<br />
</p><h3 id="item-description__software-features">Software Features</h3>
<ul>
<li>Spreadsheet with Functions<sup>New</sup></li>
<li>Fully Responsive UI built with Bootstrap</li>
<li>Easy to Use GUI.</li>
<li>Multi Language Support.</li>
<li>Export to Excel, PDF, CSV is possible.</li>
<li>Single Click Report Generation with advanced filters.</li>
<li>Built-in Themes</li>
<li>User Management with Roles & Permissions</li>
<li>Import Data from .csv & .sql</li>
<li>Database Operations
<ul>
<li>Optimize Database</li>
<li>Repair Database</li>
<li>and much more…. </li>
</ul></li>
</ul>
<blockquote>
<h3 id="item-description__live-demo-updated">Live Demo (Updated)</h3>
User: admin<br />
Password: admin<br /><br />
<strong><u>Live Demo restricted for some secured sections.</u></strong>
</blockquote>
<h3 id="item-description__updates-and-change-log">Updates And Change Log</h3>
<pre>
10/25/2016 – Version 1.2
------------------------------------------------------
Add Spreadsheet Feature
Important Bug Fixes
UI Improvement
Code Quality Improvement
Update Instructions
------------------------------------------------------
Replace the controller file under the application/controllers/core.php
Replace the model file under the application/models/core_model.php
Replace the Assets Folder
Replace the Application/Views Folder
Make sure the files under projectfolder/assets has 655 permission.
Replace the documentation file swot.html under projectfolder/assets/document/swot.html.
Change the mail_lang.php file under the application/language/english/mail_lang.php.
Replace the index.php file under the application/views/core/index.php
01/02/2015 - Version 1.1
------------------------------------------------------
Important Bug Fixes
Improved Import & Export functionality
Update Instructions
------------------------------------------------------
Replace the model file under the application/models/core_model.php
Make sure the files under projectfolder/assets has 655 permission.
Replace the documentation file swot.html under projectfolder/assets/document/swot.html.
Change the mail_lang.php file under the application/language/english/mail_lang.php.
Replace the index.php file under the application/views/core/index.php
10/17/2014 - Version 1.0
------------------------------------------------------
First release of SWOT DB
</pre>
<a href="http://codecanyon.net/downloads"><img src="http://swot.co.in/envato/rating.jpg?ver=2" alt="Rate Us" /></a> <br /><br />
<a href="http://swotsolutions.in/support/" rel="nofollow"><img src="http://swot.co.in/envato/support.jpg" alt="SWOT Support Ticket System" /></a>nkm_swottag:codecanyon:Item/53878232013-08-19 07:47:502013-10-05 00:56:24Mysql CRUD - Data Management System (Database Abstractions) <h2 id="item-description__description">Description</h2>
Mysql CRUD – Data Management System is a powerful Create-Read-Update-Delete (CRUD) generator application.
You can intergrate it with your application and saved the development time. Mysql CRUD – Data Management System is very easy to use.
<h2 id="item-description__how-this-is-different-from-my-other-items">How this is different from my other items?</h2>
PHP offers three different APIs to connect to MySQL.
<ul>
<li>mysql (Original MySQL API)</li>
<li>mysqli (MySQL Improved Extension)</li>
<li>PDO extensions</li>
</ul>
So, I create three version of CRUD with APIs above.
<ul>
<li><a href="/item/mysql-crud-data-management-system/5387823" rel="nofollow">Mysql CRUD – Data Management System</a> use mysql API for connect to mysql server.</li>
<li><a href="/item/mysqli-crud-data-management-system/5332659" rel="nofollow">Mysqli CRUD – Data Management System</a> use mysqli API for connect to mysql server.</li>
<li><a href="/item/pdo-crud-data-management-system/5293990" rel="nofollow">PDO CRUD – Data Management System</a> use PDO API for connect to mysql server.</li>
</ul>
<h2 id="item-description__features">Features</h2>
<ul>
<li>Form elements support: Textbox, Date,Datetime, Autocomplete, Textarea, Editor, Checkbox, Radio, Selectbox, tag, file</li>
<li>Auto detect mysql field type (date, datetime, timestamp, time….)</li>
<li>Join table support</li>
<li>Anti sql inections</li>
<li>Anti-XSS</li>
<li>Anti-CSRF</li>
<li>Upload file and image </li>
<li>Theme support</li>
<li>CKEditor support</li>
<li>Date and Datetime picker support</li>
<li>Auto sortable columns</li>
<li>Auto Pagination</li>
<li>SubQuery support</li>
<li>Callback function support</li>
<li>Easy definition validate</li>
</ul>
<h2 id="item-description__requirements">Requirements</h2>
<ul>
<li>PHP5+</li>
<li>MySQL5+</li>
<li>Mysql extension</li>
<li>gd extension</li>
</ul>
<h2 id="item-description__changelog">Changelog</h2>
<pre>
2013-08-15 - Version 1.0
- Initial release.
</pre>vudoanthangtag:codecanyon:Item/35888892012-12-07 02:23:032015-04-13 15:27:34Advanced Mysql Exporter/Importer (Database Abstractions) <h2 id="item-description__advanced-mysql-exporter-importer">Advanced Mysql Exporter/Importer</h2>
<br />
Advanced Mysql Exporter/Importer is a simple web application allow users to export or import any tables from or to CSV, Excel, PDF files.<br />
No special installation needed, the admin Login/Password is stored in configuration file and protected with .htaccess file<br /><br />
Advanced Mysql Exporter/Importer able to :<br />
<ul>
<li>Export Import CSV</li>
<li>Export Import Excel (xlsx, xls), Export PDF</li>
<li>Export to CSV, Excel and PDF with custom queries</li>
<li>Enable update queries</li>
<li>Console command line to export/import huge databases</li>
</ul>
Advanced Mysql Exporter/Importer using :
<ul>
<li>Bootstrap style + reponsive version</li>
<li>Simple MCV Application</li>
<li>Easy Installation</li>
</ul>
<p>You can customise the import or export function to be applied for each recored, you don’t want to use it put them to `none`.<br />
By default they are in config/parameters.ini : <br />
export_encode_function=”utf8_encode”<br />
import_encode_function=”utf8_decode”<br /><br /></p>
<p>For some databases, you need to setup the option database_default_charset in config/parameters.yml, example : `database_default_charset: “utf8”`<br /></p>
<h2 id="item-description__requires">Requires</h2>
<ul>
<li>PHP 5.x</li>
<li>Mod_rewrite enabled</li>
<li> Enable the .htaccess rewrites in your vhost
<pre>
DocumentRoot /var/www/project
<Directory /var/www/project>
AllowOverride All
Order allow,deny
Allow from All
</Directory>
</pre>
</li>
</ul>
<h2 id="item-description__installation">Installation</h2>
This is the 2.0 version.
<ul>
<li>Put the whole application where you want</li>
<li>Change the admin login/password in config/parameters.yml</li>
<li>Change the url in config/parameters.yml</li>
<li>Enjoy !</li>
</ul>
<h2 id="item-description__console-commande">Console Commande</h2>
<ul>
<li>To import huge databases open file config/console.yml, in import settings section configure table name and import options, next just run : `php bin/console import`</li>
<li>To export huge databases open file config/console.yml, in export settings section configure table name and export options, next just run : `php bin/console export`</li>
<li>Enjoy !</li>
</ul>
<strong>Update : Version 2.1 :</strong>
<ul>
<li>Moving from mysql adapter to mysqli</li>
</ul>
<strong>Update : Version 2.0 :</strong>
<ul>
<li>Command line to export/import huge databases</li>
<li>Enable update queries</li>
<li>Using yml files for application configuration instead of ini</li>
<li>Add database_default_charset option in parameters.yml</li>
<li>Improve performances</li>
<li>Fix minor bugs</li>
</ul>
<strong>Update : Version 1.1 :</strong>
<ul>
<li>Fix minor bugs</li>
<li>Allowing execution with previous version of PHP 5 (like PHP 5.2)</li>
</ul>
<p>Advanced Mysql Exporter/Importer need PHP5 to work.
<br />
<a href="http://sadokferjani.me/Advanced_Mysql_Exporter_Importer" rel="nofollow">Live Demo</a>
<br />
If you like this script please take a minute and rate it <img src="/images/smileys/happy.png" alt=":)" title=":)" /></p>sadok-ftag:codecanyon:Item/35436672012-12-02 02:44:102013-08-07 20:08:46PDO CRUD Class (Database Abstractions) <p>This small class will save you time by providing CRUD methods for quickly building SQL query statements. This can be used and integrated into any existing project with ease. Also, it is great at handling exceptions when SQL errors are produced.</p>
<h3 id="item-description__system-requirements">System Requirements</h3>
<ul>
<li>PHP 5</li>
<li>PDO Extension</li>
<li>Supported PDO Driver(s) – PDO_SQLITE, PDO_MYSQL, PDO_PGSQL</li>
</ul>
<h3 id="item-description__usage">Usage</h3>
<pre>
require('class.db.php');
// Create
$bind = array( ":id" => $_POST['user_id'], ":user" => $_POST['username']);
db::inst()->insert( "users", array(":id", ":user"), 'user_id, username', $bind );
// Read
db::inst()->init( "SELECT * FROM users ORDER BY last_name" );
// Update
$bind = array( ":signature" => $_POST['signature'] );
db::inst()->update( 'users', array('signature' => ":signature"), array('username',$_SESSION['username']), $bind );
// Delete
$bind = array(":id" => $_POST['pID']);
db::inst()->delete( "posts", "postID = :id", $bind );
</pre>
<h3 id="item-description__changelog">Changelog</h3>
<ul>
<li>
(08.07.2013) <strong>v1.1</strong>
<ul><li>Emulation set to false for true PDO</li>
<li>Fixed issue when error reporting set to E_ALL</li>
<li>Added DSN_PREFIX instead of hardcoding the prefix for more flexibility</li>
<li>No need to double quote bind parameters anymore</li>
<li>Updated for PHP 5.4.x</li>
<li>Fixed query method to use bind parameters when not false</li>
<li>Updated documentation to reflect changes</li>
</ul>
</li>
</ul>parkerjtag:codecanyon:Item/914952010-03-12 03:03:132012-03-02 21:01:54Pagination Class 3.0 (Database Abstractions) ONLINE DOCS
<a href="http://www.websource.ro/pagination/ajax/docs/" rel="nofollow">http://www.websource.ro/pagination/ajax/docs/</a>
ONLINE DEMO
<a href="http://www.websource.ro/pagination/ajax/demo.php" rel="nofollow">http://www.websource.ro/pagination/ajax/demo.php</a> – ajax version
<a href="http://www.websource.ro/pagination/ajax/demo2.php" rel="nofollow">http://www.websource.ro/pagination/ajax/demo2.php</a> – refresh model
UPDATE : 22.02.2012
<ul>
<li>correction of a small bug in 7_code.php file</li>
</ul>
UPDATE : 14.02.2012
<ul>
<li>1 minor update to class_pagination.php – a variable replaced.</li>
<li>1 new navigation model – numbers with refresh and ”...” between them, like 1 2 3…7 8 9…12 13 14 – settings can be made.</li>
<li>1 minor change to all refresh navigation models – the page variable “p” from the _code.php file is no more in the nav file but where the class is called, in antelink variable, now you can change the variable name easily if you need another variable in URL </li>
<li>1 new css class added</li>
</ul>
<p>About</p>
<p>This is a php class made for split into pages content from mysql tables.</p>
<p>You have the two methods of paging content with refresh and with ajax, 3 navigation systems and several template files for displaying items in the database.</p>
<p>You can make settings in three ways:</p>
<pre><code>from the settings file - set default - by admin
when you add your class - overwrite the default - by admin
through the navigation properties bar from browser - by user</code></pre>
<p>How it works?</p>
<p>This class make a query into mysql in the specified table with some requests made in “where” field and then display content using a template, like this:</p>
<pre><code>The class is called after you set 4 attributes: table, where field, template to display, page number
It is checked if other attributes are set when the class is called. if attributes are set, class initializes the variables with these values, if attributes are not set, it initializes the variables with values from settings file
Select rows from database
Calculate how many pages are displayed and write information from the database using the selected template
Import the type and style of navigation system</code></pre>
<p>Ajax version makes the above steps first time, when it displays the first page. After that, the remaining pages are displayed dynamically using JavaScript and XML generated by php.</p>
<p>If you need more articles in the same row you have to set float:left to the template class.
Number of articles in the same row is set in the settings file.</p>
<p>This class has 4 required attributes:</p>
<pre><code>table name
where - that can be 1 for select all rows
name of the template file
current page number</code></pre>
<p>The other attributes are optional:</p>
<pre><code>sortby - sort rows by this field from mysql table
nav - name of the file for the navigation model, select it from nav folder
show - set number of articles from mysql per page
arrange - sort rows "asc" or "desc"</code></pre>
<pre><code>//only for non ajax system
antelink - part of url that need to be placed in front of the page number e.g. index.php?id=1&page=
postlink - part of url that need to be placed after page number e.g. &sid=1&title=something</code></pre>
<p>Settings
You can set some default values for</p>
<pre><code>nav - navigation system model
sortby - field name
arrange - asc or desc
page - start page number - default is 1
show - number of rows per page
item_in_row</code></pre>
ONLINE DOCS
<a href="http://www.websource.ro/pagination/ajax/docs/" rel="nofollow">http://www.websource.ro/pagination/ajax/docs/</a>
ONLINE DEMO
<a href="http://www.websource.ro/pagination/ajax/demo.php" rel="nofollow">http://www.websource.ro/pagination/ajax/demo.php</a> – ajax version
<a href="http://www.websource.ro/pagination/ajax/demo2.php" rel="nofollow">http://www.websource.ro/pagination/ajax/demo2.php</a> – refresh modelwebsource