CodeIgniter Forums
Database Interface - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Database Interface (/showthread.php?tid=7741)



Database Interface - El Forum - 04-21-2008

[eluser]T-kuz[/eluser]
Ehm, I wanna ask about database. If I ever want to edit add or erase my table or its contents with gui like in the scaffolding feature, but can have many tables to edit. Can I have some example of the source code with the explanation? I know..It's sound silly. But I'm a new user at php and CI anyway. So I've still got many things to learn.


Database Interface - El Forum - 04-21-2008

[eluser]gtech[/eluser]
If using mysql you can download phpMyAdmin which will allows you to do exactly what you require. This comes already installed with xampp(an apache mysql distribution) on http://localhost/phpmyadmin/.


Database Interface - El Forum - 04-21-2008

[eluser]T-kuz[/eluser]
What if I want to embed it on my webpage? Can I embed phpMyAdmin on my webpage? My real intention is to make other admin in other location can edit the database freely. How's that?


Database Interface - El Forum - 04-21-2008

[eluser]Tom Glover[/eluser]
You could but what is the point when there is something powerful out there for free, like PMA. You could integrated PMA into your app.


Database Interface - El Forum - 04-21-2008

[eluser]jkevinburton[/eluser]
PMA (phpMyAdmin) is a web based application that you can access via the internet. - ANYWHERE. My suggestion is that you at least protect it against the public, otherwise anyone would have access to it.


Database Interface - El Forum - 04-21-2008

[eluser]T-kuz[/eluser]
Thanks for the replies. Yea, I thought so too..But however..in my project it's necessary to be able to edit the database from other location than server. Hmm, how do you suggest?


Database Interface - El Forum - 04-21-2008

[eluser]Tom Glover[/eluser]
If you want to let people have your Database user and pass then I would suggest using PMA, but if you don't want to let that information, then you will have to code the creates and edits yourself.