One of the things I hear from people and my friends is questions about the best way to work with PHP. They always want to know how to get started on a project, what software to use, how to plan it successfully, and so on. In this article I plan on revealing the ďmagical secretsĒ about how I do my PHP programming so quickly with so few bugs.
Well, there are many, many MySQL front ends out there. Iíve used a bunch of them. The one I like the most is called MySQL front. Itís not very expensive at all and itís really a powerhouse of a MySQL GUI. However there are a lot of free ones out there. MySQL cc is a free one that is offered on MySQLís website.
Itís really important to have a front end for MySQL, because working with MySQL at the command line interface can take up a lot of time. One of the best things about using a front end is that some of them can generate your SQL statements for you. In fact thereís another one out there named MyDB Studio, which is just that. Itís a query generator. Itís the best Iíve seen so far, and nevertheless, its main focus is generating queries for PHP scripts. There are a few other generators like EMS MySQL Manager, but it isnít really geared toward PHP specifically like MyDB studio is, not to mention it may have a lot of nice features, but they donít really make EMS MySQL Manager as useful as MyDB Studio is. MyDB Studio will generate select, insert, update, and delete statements for you then even generate PHP that connects to the database and runs the query.
On the other hand, sometimes I find that with smaller, less complex queries itís easier to just code them by hand. Also itís really nice to have your own little SQL class in another PHP document that you can just include into your project, so that you can just call a class set some parameters and, BOOM, instant SQL connection. Iíve even seen a class available in forums that will build queries for you all you have to so is send the parameters to it.