In this example, I am going to show to how you can connect your data model to table in database and do the basic database operations like Select, Insert, Update, Delete
I am using Zendframework3 skeleton application, you can see this artille if you are not familiar with how to install it
Where do you put your database setting?
To your config.autoload.global.php file, you can add the following code to commect to Mysql database in your localhost
|
1 2 3 4 5 6 |
"db" => [ 'driver' => 'Pdo_Mysql', 'dsn' => 'mysql:dbname=restapi;host=127.0.0.1', 'username' => 'root', 'password' => '' ]; |
Now you can create the Product.php at Module\Application\src\Model and add the following code to it
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
<?php namespace Application\Model; class Product{ public $name; public $price; public function exchangeArray($data) { $this->name = (!empty($data['name'])) ? $data['name'] : null; $this->price = (!empty($data['price'])) ? $data['price'] : null; } } |
You create the ProductTable.php at the same location and add the following code to do all database operations
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
<?php namespace Application\Model; use Zend\Db\TableGateway\TableGatewayInterface; class ProductTable { protected $tableGateway; public function __construct(TableGatewayInterface $tableGateway) { $this->tableGateway = $tableGateway; } public function fetchAll() { $resultSet = $this->tableGateway->select(); return $resultSet; } } |
What does TableGateway does in zendfraework?
TableGateway represents a table in a database. With the TableGateway interface you can do the most common table opretions like select,insert,update,delete
I can use the getServiceConfig() to load the factories. So you can add the following code to Module.php file loacted at Module\Application\src\
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
public function getServiceConfig(){ return [ 'factories'=>[ Model\ProductTable::class => function($container){ $tableGateway = $container->get(Model\ProductTableGateway::class); return new Model\ProductTable($tableGateway); }, Model\ProductTableGateway::class => function ($container) { $dbAdapter = $container->get(AdapterInterface::class); $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new Model\Product()); return new TableGateway('products', $dbAdapter, null, $resultSetPrototype); } ] ]; } |
Finally you can add another configuration to module.config.php located at module\Application\config
|
1 2 3 4 5 6 7 8 |
'controllers' => [ 'factories' => [ Controller\IndexController::class => InvokableFactory::class, Controller\ProductController::class => function($container) { return new Controller\ProductController($container->get(Model\ProductTable::class)); } ], ], |