aman179 — 2009-05-01T04:10:15-04:00 — #1
thanks to all SP members/staff for providing me valuable suggestion/help to complete my first PHP-MySql Based CMS. The CMS is working perfectly. :):) . Now to expand my knowledge about PHP & MySql, I want to start a new CMS (Invoicing System). I hope I will get help from all SP member to complete my this CMS also. So I need suggestion about the table structure, features & all other things. I have created four tables named.
Please post your valuable suggestion so I can learn & programme this CMS.:)
supremewebdesign — 2009-05-01T06:29:57-04:00 — #2
I always start by listing what information I will need to store, then break it up into tables and see what crossovers I have.
I will usually then plan the CMS and research similar systems to see if I am missing something out.
For the system you are writing if it is commercial you may wish to include a backup feature. A settings file or table is also a good idea to input company name address etc, this will be useful when creating print friendly pages and emails that require the company details to be displayed.
aman179 — 2009-05-01T08:01:11-04:00 — #3
thanks brother for your suggestion. I will add a table (like Company) to store information about company.
I need some more suggestion about the topics below :-
- How to prevent from Sql Injection (Googling about it & learning)
- Should I use template engine (Like Smarty)
supremewebdesign — 2009-05-01T20:11:11-04:00 — #4
Depends on your knowledge of smarty and the complexity of the invoicing system. If it is a paid job is the money worth the added work?
I do like smarty and would use it on a large cms or something I am going to reuse. Smaller projects I just tend to stick to CSS.
aman179 — 2009-05-02T00:50:25-04:00 — #5
No, its not a paid job. Actually I am starting this project to learn more about php & mysql. Because I am new in this field so I dont know much about smarty. Simple things I can do. But when it comes to use arrays & functions in Smarty I find it difficult to solve. So I am going to start it without any template engine.
toddw — 2009-05-02T18:55:31-04:00 — #6
I would learn more about arrays before I started to design an entire invoice system. The PHP docs go into good detail about arrays.
Sql Injection- This is a good start.
Make sure register globals are off, and to be extra safe... don't use the same vars in your query/function as you do on your url. IE: sample.com?name=bob
Do not use $name in your code.
aman179 — 2009-05-04T06:32:01-04:00 — #7
thanks for ur suggestions bro...