Access PHPMyadmin with IP

1. call phpmyadmin with IP
http://192.168.0.103/phpmyadmin
2. choose user tab
192.168.0.103 _ 127.0.0.1 _ phpMyAdmin 4.0.4.1 - Google Chrome 2013-10-15 11.22.53
3. Add User
4. Fill username = root, host = %, password = root as defined in the database password
1
5. Check all Global privileges
2

Then database can be accessed by IP.

Advertisements

Data mapper pattern

The interface of an object conforming to this pattern would include functions such as Create, Read, Update, and Delete, that operate on objects that represent domain entity types in a data store.

A Data Mapper, is a Data Access Layer that performs bidirectional transfer of data between a persistent data store (often a relational database) and an in memory data representation (the domain layer). Goal is to keep the in memory representation and the persistent data store independent of each other and the data mapper itself. 

In PHP===> Doctrine2 Object Relational Mapper (ORM) and the Database Abstraction Layer