6 replies to this topic

[the_code_charmer]

So i'm trying to make an event planner web site. is it necessary to use a database?

[WingedPanther]

No, but it will probably make your life much easier if you do.

[the_code_charmer]

that's what i figured...sigh...thanks!!

[WingedPanther]

Your reaction makes it sound like this is a bad thing. SQL and databases are great things.

[the_code_charmer]

yea MySQL is awesome! its PHP that i'm a novice in.

[gokuajmes]

Well as far as i can help you , it is a best practice to separate out your Data from the Front-end. The front end doesnot need to know what is happening in the back (which is your database), Try to make a Database connection class that exposes only methods and properties which will make database calls easily, To make my explanation clearer ,
here is a psedocode:
Data Access Layer

private DataTable runQuery(string strProcedureName,string strInput,boolean blnReturnAll)
{
....
}

PhpCode:

call runQuery('fixEvent','10/20/2010 12:12:00 AM',false);

the above is not php code but just giving you a idea. Php code will not have to know what is happening behind the scenes at all.It just makes a call to the method/function then sits there for a output.You can specify optional parameters like the boolean blnReturnAll if you dont know which table the result you want.

Happy Web Development Days :D

[bbqroast]

SQL and PHP aren't that bad.
I started not to long ago (I had read on PHP for ages but never done anything).
Once you start its actually quite fun scripting it.
How could you not use PHP (or some other SSI) and SQL.
Unless you wanted to mkae everyone email stuff to you and then you change the content manually.