Simple PHP Database Manager: Build and run SQL queries with a fluent interface

Recommend this page to a friend!

Download .zip

Info

Example

View files (68)

Download .zip

Reputation

Support forum (1)

Blog

Links

Last Updated		Ratings				Unique User Downloads		Download Rankings
2024-06-15 (Yesterday)		51%				Total: 399 This week: 2		All time: 6,573 This week: 35

Version		License		PHP version		Categories
`db-manager` 1.17		GNU General Publi...		5.3		PHP 5, Databases

Description

Author

Vagner vinicius bispo cantuares

This class can build and run MySQL queries with a fluent interface.

It can compose SQL SELECT, INSERT, UPDATE and DELETE queries with a fluent interface of functions to define several parameters of the queries.

The functions can define the table fields, field values, query conditions, etc..

Vagner vinicius bispo ...

Performance

Level

Name:	Vagner vinicius bispo ... `<contact>`
Classes:	2 packages by Vagner vinicius bispo ...
Country:	Portugal

Level 2

Example


<?php

require_once 'db_manager.php';



$db = DB_Manager::get_instance();

$db->database();



$db->table = 'users';



# all results.

$result = $db->select('*')->getAll();

echo '<pre>';

    var_export($result);

echo '</pre>';



# one result.

$result = $db->select('*')->where('username', 'cantuares')->get();

echo '<pre>';

    var_export($result);

echo '</pre>';



# insert record.

$result = $db->values(array('username' => 'fulano', 'password' => '***'))->insert();

echo '<pre>';

    var_export($result);

echo '</pre>';



# update record.

$result = $db->set(array('username' => 'sicrano'))->where('username', 'fulano')->update();

echo '<pre>';

    var_export($result);

echo '</pre>';



# delete record.

$result = $db->where('username', 'sicrano')->delete();

echo '<pre>';

    var_export($result);

echo '</pre>';



?>

Details

PHP Database Manager

Small and simple class for MySQL database management.

Files

File	Role	Description
`config` (1 file)
`docs` (1 directory)
`composer.json`	Data	Auxiliary data
`db_manager.php`	Class	Class source
`example.php`	Example	Example script
`example_sql.sql`	Data	Auxiliary data
`LICENSE`	Data	Auxiliary data
`README.md`	Doc.	Auxiliary data

File	Role	Description
`classes` (1 file)
`css` (5 files, 1 directory)
`files` (2 files)
`font` (5 files)
`graphs` (1 file)
`images` (12 files, 1 directory)
`js` (10 files, 1 directory)
`namespaces` (1 file)
`phpdoc-cache-2e` (1 file)
`phpdoc-cache-ee` (1 file)
`reports` (3 files)
`.htaccess`	Data	Auxiliary data
`index.html`	Doc.	Documentation

File	Role	Description
`phpdocumentor-clean-icons` (3 files, 1 directory)
`bootstrap-combined.no-icons.min.css`	Data	Auxiliary data
`font-awesome.min.css`	Data	Auxiliary data
`jquery.iviewer.css`	Data	Auxiliary data
`prism.css`	Data	Auxiliary data
`template.css`	Data	Auxiliary data

File	Role	Description
`fonts` (5 files)
`lte-ie7.js`	Data	Auxiliary data
`Read Me.txt`	Doc.	Documentation
`style.css`	Data	Auxiliary data

File	Role	Description
`phpdocumentor-clean-icons.dev.svg`	Data	Auxiliary data
`phpdocumentor-clean-icons.eot`	Data	Auxiliary data
`phpdocumentor-clean-icons.svg`	Data	Auxiliary data
`phpdocumentor-clean-icons.ttf`	Data	Auxiliary data
`phpdocumentor-clean-icons.woff`	Data	Auxiliary data

File	Role	Description
`db_manager.html`	Doc.	Documentation
`db_manager.php.txt`	Doc.	Documentation

File	Role	Description
`fontawesome-webfont.eot`	Data	Auxiliary data
`fontawesome-webfont.svg`	Data	Auxiliary data
`fontawesome-webfont.ttf`	Data	Auxiliary data
`fontawesome-webfont.woff`	Data	Auxiliary data
`FontAwesome.otf`	Data	Auxiliary data

File	Role	Description
`iviewer` (8 files)
`apple-touch-icon-114x114.png`	Icon	Icon image
`apple-touch-icon-72x72.png`	Icon	Icon image
`apple-touch-icon.png`	Icon	Icon image
`custom-icons.svg`	Data	Auxiliary data
`favicon.ico`	Data	Auxiliary data
`hierarchy-item.png`	Icon	Icon image
`icon-class-13x13.png`	Icon	Icon image
`icon-class.svg`	Data	Auxiliary data
`icon-interface-13x13.png`	Icon	Icon image
`icon-interface.svg`	Data	Auxiliary data
`icon-trait-13x13.png`	Icon	Icon image
`icon-trait.svg`	Data	Auxiliary data

File	Role	Description
`grab.cur`	Data	Auxiliary data
`hand.cur`	Data	Auxiliary data
`iviewer.rotate_left.png`	Icon	Icon image
`iviewer.rotate_right.png`	Icon	Icon image
`iviewer.zoom_fit.png`	Icon	Icon image
`iviewer.zoom_in.png`	Icon	Icon image
`iviewer.zoom_out.png`	Icon	Icon image
`iviewer.zoom_zero.png`	Icon	Icon image

File	Role	Description
`ui` (1 directory)
`bootstrap.min.js`	Data	Auxiliary data
`html5.js`	Data	Auxiliary data
`jquery-1.11.0.min.js`	Data	Auxiliary data
`jquery.dotdotdot-1.5.9.js`	Data	Auxiliary data
`jquery.dotdotdot-1.5.9.min.js`	Data	Auxiliary data
`jquery.iviewer.js`	Data	Auxiliary data
`jquery.iviewer.min.js`	Data	Auxiliary data
`jquery.mousewheel.js`	Data	Auxiliary data
`jquery.smooth-scroll.js`	Data	Auxiliary data
`prism.min.js`	Data	Auxiliary data

File	Role	Description
`deprecated.html`	Doc.	Documentation
`errors.html`	Doc.	Documentation
`markers.html`	Doc.	Documentation

	db-manager-2024-06-15.zip 653KB
	db-manager-2024-06-15.tar.gz
	Install with Composer