Forum Home
Press F1
 
Thread ID: 57848 2005-05-14 08:08:00 What are your Favourite MySQL / PHP Tools? CreightonBrown (5692) Press F1
Post ID Timestamp Content User
355032 2005-05-14 08:08:00 Comments welcome. CreightonBrown (5692)
355033 2005-05-14 08:16:00 A text editor that does regular expressions and my favourite MySQL tool is a Postgresql installer... gibler (49)
355034 2005-05-14 08:18:00 A text editor that does regular expressions and my favourite MySQL tool is a Postgresql installer...

Have you looked into automating code?
CreightonBrown (5692)
355035 2005-05-14 09:09:00 phpMyAdmin.

Heavenly.
Growly (6)
355036 2005-05-14 09:14:00 phpMyAdmin.

Heavenly.

PHPMyAdmin is quite nice, use it with www.iserve.co.nz (http://www.iserve.co.nz) they have a 2MB limit on uploads though. My solution for the future is to make a custom import for the SQL and access via the file system for large scripts.

What other tools do you know?
CreightonBrown (5692)
355037 2005-05-14 10:41:00 Have you looked into automating code?

I have had a good look at code generation stuff (or some nice classes) but haven't found anything that I liked the look of yet. I assume you are talking about PHP code to handle your basic CRUD database functions with forms.

One of things I didn't like about most of them is I can't easily use a templating system such as Smarty with them. There is no system like PhpMyadmin (or PhpPgadmin for postgresql) that I like that can be customised for the average user to use. PEAR at least makes some thing less painful to implement.

Maybe something like Plone is the way to go (although not useful in all cases).
MySQL and PHP are getting there..
gibler (49)
355038 2005-05-14 10:50:00 I have had a good look at code generation stuff (or some nice classes) but haven't found anything that I liked the look of yet. I assume you are talking about PHP code to handle your basic CRUD database functions with forms.

One of things I didn't like about most of them is I can't easily use a templating system such as Smarty with them. There is no system like PhpMyadmin (or PhpPgadmin for postgresql) that I like that can be customised for the average user to use. PEAR at least makes some thing less painful to implement.

Maybe something like Plone is the way to go (although not useful in all cases).
MySQL and PHP are getting there..

PHP Accelerator claims to be able to boost translation/Loads speed by 5-10x over smart, perhaps more applicable to high end.

Yeah i did Mean CRUD, but CRUD is only part of it i suppose. Ideally full searching would be possible.

It would also be nice if you could turn cols on/off or change from vertical/horizontal display.

Right now i just want to get my PHP Codegen to a similar spec as my ASP one.

Been researching whats available most of the night, looking for ideas and so forth.

It's not so much a technical issue and i should be able to do the ID references to another table easiysh as well as generate resolving tables without too much work.

Kind of like seeing whats out there more with PHP... it has some nicities but for codegens compared to say JSP it may be behind, but then it doesn't typically deal with 70% of 1mil+ projects
CreightonBrown (5692)
355039 2005-05-14 11:52:00 I like tools that can delete spurious threads. ninja (1671)
355040 2005-05-14 11:57:00 I like tools that can delete spurious threads.

You shouldn't post insults or similar.

spu•ri•ous adjective [LL & L; LL spurius false, fr. L, of illegitimate birth, fr. spurius, n., bastard
(1598)

1 : of illegitimate birth : bastard

2 : outwardly similar or corresponding to something without having its genuine qualities : false

3 a : of falsified or erroneously attributed origin : forged

b : of a deceitful nature or quality

spu•ri•ous•lyadverb

spu•ri•ous•ness nou
CreightonBrown (5692)
355041 2005-05-15 07:27:00 PHPMyAdmin is quite nice, use it with www.iserve.co.nz (http://www.iserve.co.nz) they have a 2MB limit on uploads though.

I think you will find that’s the case with most web hosts, as that’s the limits of PHP :(
stu161204 (123)
1 2