PHP download

Download the PHP package stechbd/sde without Composer

On this page you can find all versions of the php package stechbd/sde. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download stechbd/sde
More information about stechbd/sde
Files in stechbd/sde

Vendor stechbd
Package sde
Short Description S Database Explorer (SDE) is a simple and lightweight MySQL database explorer library based on PHP and PDO.
License GPL-3.0
Homepage https://www.stechbd.net/project/SDE/

Keywords database php mysql pdo sde stechbd aashemul

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.

Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
To use Composer is sometimes complicated. Especially for beginners.
Composer needs much resources. Sometimes they are not available on a simple webspace.
If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.

Please rate this library. Is it a good library?

Example code of stechbd/sde

Informations about the package sde

S Database Explorer (SDE)

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

Requirements

PHP >= 7.4
PDO PHP Extension
JSON PHP Extension

Features

[x] Create table
[x] Insert record
[x] Update record
[x] Delete record
[x] Select record
[x] Select all records
[x] Select records with where clause
[x] Select records with where clause and limit
[x] Select records with where clause, limit and offset
[x] Select records with where clause, limit, offset and order by
[x] Run custom query

Change log

Version 3.0.1 (August 15, 2023)

Fixed bugs.

Version 3.0.0 (July 16, 2023)

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.md file.
Added composer support.

Version 2.0.0 (December 7, 2017)

Removed MySQL support and kept only MySQLi support.

Version 1.0.0 (August 14, 2015)

Initial release.

Please see CHANGELOG for more information on what has changed recently.

Installation

S Database Explorer (SDE) can be used directly using downloaded package or can be installed using composer:

Usage

Autoload the library

Connecting to a database

Inserting a record

Updating a record

Deleting a record

Selecting records

Selecting all column

Selecting specific columns

Selecting records with where clause

Selecting records with where and limit clause

Selecting records with where, limit, and order by clause

Selecting records with where, limit, order by, and offset clause

Running custom query

Getting JSON output

Getting last insert item

Getting number of rows

Getting sum of a column

License

S Database Engine (SDE) is open-sourced software licensed under the GPLv3 license.

Security

If you discover any security-related issues, please email [email protected] instead of using the issue tracker.

Future Plan

[ ] 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

Author

Md. Ashraful Alam Shemul

Contributors

None yet.

About S Technologies

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.

Support

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.

Hire Us

Contribute

GitHub

Copyright

All versions of sde with dependencies

PHP Build Version

Package Version

Version 3.0.1 Release 15. Aug 2023
create-project require 0 people chose require and
0 people chose create-project.

Download

Download latest version of sde from vendor stechbd

No informations.

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package stechbd/sde contains the following files

Loading the files please wait ....