Geek asks and answers

PHP structures that are not closely related to the database and work with stored procedures?

It recently appeared at work, and Google was ... well, minimally useful.

We use Yii, but the policy of the company is that all access to the database should be done through MySQL stored procedures, which “breaks” quite a lot of Yii and makes some of its attempts to make life easier, well, irrelevant. (To be clear, the decision to require only SP was made after Yii was implemented.)

Are there any PHP frameworks that will work better under this restriction? We use YiiBooster, so any other infrastructure must be compatible with Bootstrap, or the UI / UX department will start to scream.

TL Version; DR:

My first impression of Googling and searching here is that any other PHP framework will have the same limitations. Is it correct?

+5
source share
3 answers

You're right. Any other structure will also have this limitation.

This is due to the fact that the platform itself is an abstraction from the main language. The framework abstracts the PHP code, and orm the abstract of the repository, for example. MySQL

What you want is another level of abstraction between ORM and the database manager. I'm afraid, but you will need to write your own orm or extend and orm to complete this task.

+6
source

"", , SP- .

0

Yii is extensible in nature and does not require a database connection to run at all.

I suggest writing your own DataProvider class, look at CArrayDataProvider http://www.yiiframework.com/doc/api/1.1/CArrayDataProvider as a transition point.

0
source

More articles:


All Articles