S Database Explorer (SDE) is a simple and lightweight MySQL database explorer library based on PHP and PDO. It is a free and open-source database management library that helps you to manage your MySQL database.
- Requirements
- Features
- Change log
- Installation
- Usage
- License
- Security
- Future Plan
- Author
- Contributors
- About S Technologies
- Support
- Hire Us
- Contribute
- Privacy Policy
- Terms & Conditions
- Copyright
- PHP >= 7.4
- PDO PHP Extension
- JSON PHP Extension
- Create table
- Insert record
- Update record
- Delete record
- Select record
- Select all records
- Select records with where clause
- Select records with where clause and limit
- Select records with where clause, limit and offset
- Select records with where clause, limit, offset and order by
- Run custom query
- Fixed bugs.
- Added support for PHP 7.4 or higher.
- Replaced MySQLi with PDO.
- Renamed 'custom query' method to
run(). - Renamed 'last insert item' method to
last(). - Renamed 'number of rows count' method to
count(). - Added 'JSON output' method.
- Added 'sum' method.
- Added
CHANGELOG.mdfile. - Added
composersupport.
- Removed MySQL support and kept only MySQLi support.
- Initial release.
Please see CHANGELOG for more information on what has changed recently.
S Database Explorer (SDE) can be used directly using downloaded package or can be installed using composer:
composer require stechbd/sderequire_once __DIR__ . '/vendor/autoload.php';$sde = new STechBD\SDE('name', 'username', 'password', 'host', 'prefix');$sde->insert('users', 'name, email, password', ':name, :email, :password', [
'name' => 'John Doe',
'email' => '[email protected]',
'password' => '123456',
'salary' => '10000'
]);$sde->update('users', 'email = :email', 'id = :id' [
'email' => '[email protected]',
'id' => 1
]);$sde->remove('users', 'id = :id', [
'id' => 1
]);$sde->select('*', 'users');$sde->select('id, name, email', 'users');$sde->select('id, name, email', 'users', 'id = :id', false, false, [
'id' => 1
]);$sde->select('id, name, email', 'users', 'id = :id', 10, false, [
'id' => 1
]);$sde->select('id, name, email', 'users', 'id = :id', '10, 0', 'id DESC', [
'id' => 1
]);$sde->select('id, name, email', 'users', 'id = :id', '10', 'id DESC', '15', [
'id' => 1
]);$sde->run('SELECT * FROM users WHERE id = 1');$sde->json($result);$sde->last();$sde->count('users', 'id = :id', [
'id' => 1
]);$sde->sum('users', 'salary', 'id = :id', [
'id' => 1
]);S Database Engine (SDE) is open-sourced software licensed under the GPLv3 license.
If you discover any security-related issues, please email [email protected] instead of using the issue tracker.
- Create database
- Drop database
- Create table
- Alter table
- Drop table
- Truncate table
- Rename table
- Add column
- Rename column
- Drop column
- Add index
- Drop index
- Add foreign key
- Drop foreign key
- Add unique key
- Drop unique key
- Add primary key
- Drop primary key
- Add auto increment
- Drop auto increment
None yet.
S Technologies (STechBD.Net) is a research-based technology company in Bangladesh. It was founded in 2013. It provides services like domain registration, web hosting, web servers, software development, AI model development, software as a service (SasS), UI/UX design, SEO, business solutions, etc. S Technologies has been working in research of new technologies especially in artificial intelligence, and developing new products. You'll find an overview of all our open source products on our website.
If you are having general issues with this package, feel free to contact us on STechBD.Net/support.
If you believe you have found an issue, please report it using the GitHub issue tracker, or better yet, fork the repository and submit a pull request.
- Home Page
- Documentation
- GitHub Issues
- Composer Package
- Support Page
- Contact Form
- X (Twitter)
- YouTube
© 2013-24 S Technologies. All rights reserved.