README

SQLManager is a small script that lets you easily interact with your mysql database.

Features

• Easy to use
• Secure (SQL Injection prevention)
• Simple and fast

Installation

1. Download the latest release with composer or from the releases page.

composer require ratingthomas/sqlmanager

1. Put the script somewhere in your project.
2. Add the following code:

<?php
  include 'path/to/SQLManager.php';
  use Ratingthomas\SQLManager\SQL;
  $sql = new SQL\SQL();
?>

How to use

Here i will explain how you can use the script.

Connect to Database

$sql->connect("db_name", "db_username", "db_password", "db_name");

Get data from the dabatase

Example 1

$result = $sql->query("SELECT * FROM users WHERE userid = ? AND user_type = ?", ['1', 'superadmin'], true);
print_r($result);

Example 2

$result = $sql->query("SELECT * FROM users", []);
print_r($result);

Get the connection info.

$sql->displayconnection()