lcloss/php-sql

Simple SQL class to use with PHP

php-sql

A simple Class to work with SQL in PHP, _(*1)

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., _(*2)

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, _(*3)

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., _(*4)

Installing

Installation with Git:, _(*5)

git clone https://github.com/lcloss/php-sql.git

Instalação com o Composer:, _(*6)

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., _(*7)

With your data, write:, _(*8)

### 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., _(*9)

Versioning

We use GitHub for versioning. For the versions available, see the tags on this repository., _(*10)

Authors

• Luciano Closs - Initial work - LCloss

See also the list of contributors who participated in this project., _(*11)

License

This project is licensed under the MIT License - see the LICENSE.md file for details, _(*12)

Acknowledgments

• This project was inspired by the Curso Completo de PHP 7 from HCode
• This README.md was build from PurpleBooth README Template