Re: Need some directions on how to build something like phpMyAdmin

It's probably a bad idea to implement this i cake.

It's possible to get a list of databases running on a specific MySQL
instance by issuing

"SHOW DATABASES" (can also be "SHOW DATABASES LIKE %", see the MySQL docs).

Can also be used in $model->query(), this yielded an array like this:

"Array
(
[0] => Array
(
[SCHEMATA] => Array
(
[Database] => information_schema
)

)

[.....]"

//mathias
2009/12/30 Arnold <arnoldchang@anocomputing.com>:
> Greeting,
>
> A traditional programmer who is starting to learn CakePHP and MVC
> design.  I have a pilot project to build a light version of something
> like PhpMyAdmin.
>
> Just trying to figure out how do I achieve this with this framework?
> Can I have a generic controller to map dynamically to a different
> database and a different table.  And how do I achieve something as
> simple as listing out all the databases of a specific server in the
> MVC model.
>
> I appreciate very much if someone can provide me some directions.
> Thanks in advance.
>
> Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.
>
> You received this message because you are subscribed to the Google Groups "CakePHP" group.
> To post to this group, send email to cake-php@googlegroups.com
> To unsubscribe from this group, send email to
> cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
>