roka/dbtable

PHP classes for database handling upon PDO

dev-master 2014-12-03 20:44 UTC

Requires

• php: >=5.4
• mos/cdatabase: dev-master
• mos/cform: 2.*@dev
• phpmvc/comment: dev-master

Requires (Dev)

• satooshi/php-coveralls: dev-master

MIT

• Göran Karlsson

• framework
• module
• mvc
• micro
• education

README

Use it to retrieve information of datatables in a Database. PHP classes for database handling upon PDO.

License

This software is free software and carries a MIT license.

History

v 2 Second Edition *Completed with testcases and changed localisation of source-files *See description below:

v 1 First edition *Based upon mos/database and mos/cform package. *The intention is to explore all datafiles in a database.

How to use Cdbtable

Copy the map Dbtables in vendor/roka/AnaxDbtable/Dbtable/src to your app/src map
and also the map Dbtables in vendor/roka/AnaxDbtable/Dbtable/view to your app/view map

Urgent Don't use the old src-map ! It is only intended for test-cases.

Use inside Anax: Insert to your Index-file in webroot

$di->set('DbtablesController', function() use ($di) { $controll = new \Roka\Dbtables\DbtablesController(); $controll->setDI($di); return $controll; });

You must have a database connection open ie like this

$di->setShared('db', function() { $db = new \Mos\Database\CDatabaseBasic(); // $db->setOptions(require ANAX_APP_PATH . 'config/config_mysql.php'); $db->setOptions(require ANAX_APP_PATH . 'config/config_sqlite.php'); $db->connect(); return $db; });

You can use it from the browsner like the link

/webroot/Dbtables/select

 .  
..:  Copyright (c) 2014 Göran Karlsson [e-mail]