Mysql Database Class

This php class is a simple oriented object mysql client base on pdo, it preventing from SQL injection and XSS attacks.

Init the database object

require 'class/database.class.php'

$GLOBALS['MYSQL'] = new Database(
	"localhost",
	"database",
	"username",
	"password"
);

Getting data from SQL tables

// returning an array of all the table content
$GLOBALS['MYSQL']->getContent("table");

// returning an array of all the table content where exemple_colum is equal to 30
$GLOBALS['MYSQL']->getContent("table", ["exemple_colum" => 30]);

Inserting data into database

// Inserting a new line to the table with exemple_colum equal to 30
$GLOBALS['MYSQL']->Insert("table", [
	"exemple_colum" => 30
]);

// Inserting a new line to the table with exemple_colum equal to 30 without the XSS filter
$GLOBALS['MYSQL']->Insert("table", [
	"exemple_colum" => 30
], false);

Updating data into database

// Put 60 in the column exemple_colum whre exemple_colum equal to 30
$GLOBALS['MYSQL']->update("table", [
	"exemple_colum" => 30
], [
	"exemple_colum" => 60
]);

// Put 60 in the column exemple_colum whre exemple_colum equal to 30 without the XSS filter
$GLOBALS['MYSQL']->update("table", [
	"exemple_colum" => 30
], [
	"exemple_colum" => 60
], false);

Delete a line

// Delete lines where exemple_colum equal to 60
$GLOBALS['MYSQL']->delete("table", [
	"exemple_colum" => 60
]);