Home arrow PHP arrow Page 4 - Best PHP Practices

Get your Hands off MySQL! - PHP

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.

  1. Best PHP Practices
  2. Itís like Typing, only with a Pencil
  3. What You See isÖ Well, You Know
  4. Get your Hands off MySQL!
  5. PHP Time, YAA!
  6. Where Do I Start?
  7. Loose Ends
By: James Murray
Rating: starstarstarstarstar / 225
September 20, 2004

print this article



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.

>>> More PHP Articles          >>> More By James Murray

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Hackers Compromise PHP Sites to Launch Attac...
- Red Hat, Zend Form OpenShift PaaS Alliance
- PHP IDE News
- BCD, Zend Extend PHP Partnership
- PHP FAQ Highlight
- PHP Creator Didn't Set Out to Create a Langu...
- PHP Trends Revealed in Zend Study
- PHP: Best Methods for Running Scheduled Jobs
- PHP Array Functions: array_change_key_case
- PHP array_combine Function
- PHP array_chunk Function
- PHP Closures as View Helpers: Lazy-Loading F...
- Using PHP Closures as View Helpers
- PHP File and Operating System Program Execut...
- PHP: Effects of Wrapping Code in Class Const...

Developer Shed Affiliates


Dev Shed Tutorial Topics: