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());