lcloss / php-sql
Simple SQL class to use with PHP
Requires
- php: >=7.0
This package is not auto-updated.
Last update: 2024-11-10 05:49:02 UTC
README
A simple Class to work with SQL in PHP
Getting Started
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.
Prerequisites
You will need a web server and PHP configured. Also, you need to use one of these databases systems:
- MariaDB or MySql
- SQL Server
- SQLite
This project is intended to be incorporated into another project, so the minimum prerequisite is the web server, PHP and a Database driver as mentioned above.
Installing
Installation with Git:
git clone https://github.com/lcloss/php-sql.git
Instalação com o Composer:
composer require lcloss/php-sql
Running the tests
Initial setup
If you are using MariaDb, MySQL or SQL Server, you need to create the database schema first.
With your data, write:
Returning Data
$sql = new Sql();
$results = $sql->query("SELECT * FROM table WHERE id = :id", [
':id' => 1
]);
if ( count($results) > 0 ) {
echo 'Found!';
} else {
echo 'Not Found...';
}
Executing SQL
Type the following code:
$sql = new Sql();
$sql->query("UPDATE table SET name = :name WHERE id = :id", [
':id' => 1,
':name' => 'New name',
]);
Built With
Contributing
Please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests to us.
Versioning
We use GitHub for versioning. For the versions available, see the tags on this repository.
Authors
- Luciano Closs - Initial work - LCloss
See also the list of contributors who participated in this project.
License
This project is licensed under the MIT License - see the LICENSE.md file for details
Acknowledgments
- This project was inspired by the Curso Completo de PHP 7 from HCode
- This README.md was build from PurpleBooth README Template