PHP
  Home arrow PHP arrow Page 4 - Best PHP Practices
Dev Shed Forums 
Administration  
AJAX  
Apache  
BrainDump  
DHTML  
Flash  
Java  
JavaScript  
Multimedia  
MySQL  
Oracle  
Perl  
PHP  
Practices  
Python  
Reviews  
Security  
Style-Sheets  
Web Services  
XML  
Zend  
Zope  
Forums Sitemap 
IBM® developerWorks 
Sun Developer Network 
E-Commerce Hosting 
Linux Web Hosting 
Managed Hosting 
Small Business Hosting 
Mobile Linux 
App Generation ROI 
VPS Hosting 
Weekly Newsletter

 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
PHP

Best PHP Practices
By: James Murray
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 3 stars3 stars3 stars3 stars3 stars / 219
    2004-09-20

    Table of Contents:
  • Best PHP Practices
  • It’s like Typing, only with a Pencil
  • What You See is… Well, You Know
  • Get your Hands off MySQL!
  • PHP Time, YAA!
  • Where Do I Start?
  • Loose Ends

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Best PHP Practices - Get your Hands off MySQL!


    (Page 4 of 7 )

    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


       · I was expecting this professional, anal retentive article and instead I get this...
       · Enough would be to say, that any pro project that gets started, first off lands on...
       · Your articles are almost always enjoyable to read and this one was probably one of...
       · I completely agree! this article was amazingly helpful.But who the heck is...
       · I disagree with your choice of PHP Editors, while you say Zend is a Good editor,...
       · I think there's an editor which is simple to the extreme but is very nice for php,...
       · What a waste of time this article was. Give me my money back!
       · Ok, here's your $0 back..
       · There are some good tips in this article but there is a lot more you can do to save...
       · I should have mentioned this in the 'Purity Balance.' Why not use HTML generated by...
       · I read it and thought, "wtf is this shit?" Dreamweaver/GoLive + MySQL GUI = PHP...
       · i agree on what you have said that the command line is still the best... but i guess...
       · In my opinion it had its good points. My biggest problem with it is the title of...
       · I developing Web applications in PHP since last two years, and i am VERY VERY...
       · I have heard this argument before regarding the apparent slowness of Zend Studio. I...
       · If the text does not need additional formatting, then block quote it with <PRE>...
       · I can code in Assembler; but why would I? Farmers could plant corn by hand; but why...
       · http://www.sextoyssexvideos.com
       · Thanks. Regardless of what people say it was useful. In a way it was a source of...
       · Regardless of what these other people are saying- thank you for helping n00bs like...
       · <a href="http://sextoyssexvideos.com/" title="Sex Toys">Sex Toys</a>
       · You compare a farmer using a WYSIWIG instead of his hands... The only comparable...
       · <a href="http://sextoyssexvideos.com/" title="Sex Toys">Sex...
       · 500 words about nothing.
       · 500 words about nothing.
       · [url=]http://www.sextoyssexvideos.com[/url]
       · [url=http://www.sextoyssexvideos.com/]sex toys[/url]
       · Crap article. What a waste of my time. The author has no idea what "best practices"...
       · I am not new to programming, but I haven't been in the game for about 5 years...
       · Me reading your reply to this article makes me wander a) if you are totaly ignorant...
       · I rarely post anything anywhere but I was so annoyed by this article so I had to...
       · The article wasn't bad, but has absolutely nothing to do with "PHP Best Practice."...
       · just surfin the web and got here with that nice-titled-article of yours. are you...
       · I have to say I was not impressed by this "Best PHP Practices" article at all. In...
     

       

    PHP ARTICLES

    - Authentication Scripts for a User Management...
    - Utilizing the Use Keyword for Namespaces in ...
    - Building a User Management Application
    - Working With Different Namespaces in PHP 5
    - User Management Explained: Overview
    - Using Namespaces in PHP 5
    - Database Security: Guarding Against SQL Inje...
    - Building a Modular Exception Class in PHP 5
    - Database and Password Security for Web Appli...
    - Handling MySQL Data Set Failures in PHP 5
    - Building Site Registration for Web Applicati...
    - Intercepting Customized Exceptions in PHP 5
    - Securing Your Web Application Against Attacks
    - Sub Classing Exceptions in PHP 5
    - Authentication for Web Application Security





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway
    Stay green...Green IT