johannmalmcom / database
A class that help you to handle the database
v1.0.1
2020-03-12 11:12 UTC
This package is auto-updated.
Last update: 2024-06-17 00:34:47 UTC
README
Database
require_once("./vendor/autoload.php"); use Database\MySQL; // Connection $database = new MySQL(); $database->setServer("127.0.0.1"); $database->setUsername("your_username"); $database->setPassword("your_password"); $database->setDatabase("your_dbname"); // Create table $database->createTable("users", [ $database->typeString("email"), $database->typeString("password", 40), $database->typeString("token", 40) ]); // Insert data $database->insertInto("users", [ "email" => "hej@johannmalm.com" ]); // Update data $database->update("users", [ "password" => sha1("1234") ], [ "id" => 1 ]); // Delete data $database->deleteFrom("users", 5); // Select data $database->selectFrom("users", [ "email" => "hej@johannmalm.com" ]); // Search data $database->searchFrom("users", [ "created_at" => "20" ]); // Handle responses if ($database->getError() !== null) { exit($database->getError()); } print_r($database->getResult());