* advice using $sqls frequently

[unistake]

Hi all,

 

I am developing a CMS sort of website and during the planning I can see that I will be using a lots of variations of $sql and $results in previous websites I have just re-typed the whole script on every PHP page where they were needed.

 

To keep the scripts a bit tidier this time, I was hoping to get some advice as to the best way to use/manage them.

 

E.g. Should I copy and paste the $sql codes in every PHP page?

      Should I create a functions.php page and include all the variations of $sql that I will be using all call for them when needed?

      Or Should I go about it another way!?

 

Thanks for any advice.

[Maq]

I would create a class to handle your SQL.  This way you can easily reuse your code.

 

Now, depending on how your code is already structured, it could be a bit of an overhaul, but worth it IMO.

[unistake]

I have not written a line of code yet.

 

Can you tell me moire about classes to handle SQL - never heard of this - I am an advanced beginner!

 

Thanks

[Maq]

I have not written a line of code yet.

 

Can you tell me moire about classes to handle SQL - never heard of this - I am an advanced beginner!

 

Thanks

 

If you Google for this topic (PHP sql database class) then you will find many examples.  If you have specific questions I will be more than happy to help.