GitHub - Tschoffelen/p

Skip to content Dismiss alert {{ message }} This repository was archived by the owner on Mar 28, 2020. It is now read-only. tschoffelen / db.php Public archive

• Notifications You must be signed in to change notification settings
• Fork 59
• Star 104

• Code
• Issues 2
• Pull requests
• Actions
• Projects
• Wiki
• Security
• Insights

Additional navigation options

 masterBranchesTagsGo to fileCodeOpen more actions menu

Folders and files

Name		Name	Last commit message	Last commit date
Latest commit   History 35 Commits35 Commits
src		src
tests		tests
.gitignore		.gitignore
.travis.yml		.travis.yml
README.md		README.md
composer.json		composer.json
composer.lock		composer.lock
phpunit.xml		phpunit.xml
View all files

Repository files navigation

• README

Database.php

Database.php is a simple PHP class for doing standard MySQL actions, such as selecting, inserting, updating and deleting database rows. It also includes some nice functionality, like auto-escaping to protect your database from malicious code and automatic serializing of arrays.

Usage

Initiating

Initiate a database connection using by creating a new Database() object.

require_once('Database.php'); $db = new Database($database_name, $username, $password, $host); // $host is optional and defaults to 'localhost'

Select

Select rows from a database table

Usage:

$db->select($table, $where, $limit, $order, $where_mode, $select_fields)

Arguments:

• string $table - name of the table to select from
• array/string $where - array or string holding the filters/'WHERE' clause for the query
• int/string $limit - integer or string holding the 'LIMIT' clause
• string $order - string holding the 'ORDER BY' clause
• string $where_mode - whether to add an 'AND' or 'OR' after each item in the $where array, defaults to AND
• string $select_fields - the fields to select (SELECT <$select_fields> FROM ...), defaults to *

Example:

// get the first 10 candy bars that are sweet, and order them by amount $db->select('candy', ['sweet' => 1, 'spicy' => 0], 10, 'amount DESC'); // get the ids 1, 2,5,9 from products $db->select('products', ['id' => 'in (1,2,5,9)'], false, false,'OR');

Reading results

Reading the results can be done with the following functions:

• $db->count() returns the number of selected rows, equal to mysql_num_rows()

• $db->result() returns all matches rows as an array containing row objects

• $db->row() returns the first row that matches the query as an object

• $db->result_array() returns all matches rows as an array containing row arrays

• $db->row_array() returns the first row that matches the query as an array

Please note that you can call any of these functions also directly after the $db->select() call, like shown below:

echo $db->select('candy', ['sweet' => 1], 10)->count();

There are a few other methods available for queries that might come in handy:

• $db->sql() returns the sql query that was last executed

Insert

Insert data into a database table

Usage:

$db->insert($table, $fields=[])

Example:

$db->insert( 'candy', [ 'name' => 'Kitkat original', 'sweet' => 1, 'spicey' => 0, 'brand' => 'Kitkat', 'amount_per_pack' => 4 ] );

Tip! You can call $db->id() immeadiately after a $db->insert() call to get the ID of the last inserted row.

Update

Update one or more rows of a database table

Usage:

$db->update($table, $fields=[], $where=[])

Example:

// set amount per pack to 5 for all Kitkats $db->update( 'candy', [ // fields to be updated 'amount_per_pack' => 5 ], [ // 'WHERE' clause 'brand' => 'Kitkat' ] );

Delete

Remove one or more rows from a database table

Usage:

$db->delete($table, $where=[])

Example:

// delete all Kitkat candy $db->delete( 'candy', [ // 'WHERE' clause 'brand' => 'Kitkat' ] );

Singleton

Access the database instance outside the global scope after initializing it

Usage:

$my_db = Database::instance();

Example:

// Global scope $db = new Database($database_name, $username, $password, $host); // Function scope function something() { // We could simply use `global $db;`, but using globals is bad. Instead we can do this: $db = Database::instance(); // And now we have access to $db inside the function }

About

🍎 Simple PHP class for doing standard MySQL actions, such as select, insert, update and delete rows.

Resources

Readme

Uh oh!

There was an error while loading. Please reload this page.

Activity

Stars

104 stars

Watchers

9 watching

Forks

59 forks Report repository

Releases 3

1.1.1: Merge pull request #9 from PierreG89/PierreG89-patch-1 Latest Oct 16, 2018 + 2 releases

Packages

Uh oh!

There was an error while loading. Please reload this page.

Uh oh!

There was an error while loading. Please reload this page.

Contributors

Uh oh!

There was an error while loading. Please reload this page.

Languages

• PHP 100.0%

You can’t perform that action at this time.