SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2009
    Posts
    50
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Php Mysql Invoicing System

    Hi friends,
    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.

    1. Items
    2. Clients
    3. Users
    4. Invoices

    Please post your valuable suggestion so I can learn & programme this CMS.

    regards

  2. #2
    SitePoint Member supremewebdesign's Avatar
    Join Date
    Apr 2009
    Posts
    11
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.
    www.supremewebsolutions.com
    Aberdeen based web design.
    Hotel booking systems - Content management systems
    CMS - Search engine optimisation - SEO

  3. #3
    SitePoint Enthusiast
    Join Date
    Apr 2009
    Posts
    50
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by supremewebdesign View Post
    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.
    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 :-

    1. How to prevent from Sql Injection (Googling about it & learning)
    2. Should I use template engine (Like Smarty)

  4. #4
    SitePoint Member supremewebdesign's Avatar
    Join Date
    Apr 2009
    Posts
    11
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.
    www.supremewebsolutions.com
    Aberdeen based web design.
    Hotel booking systems - Content management systems
    CMS - Search engine optimisation - SEO

  5. #5
    SitePoint Enthusiast
    Join Date
    Apr 2009
    Posts
    50
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  6. #6
    Serial Site Creator ToddW's Avatar
    Join Date
    Feb 2004
    Posts
    791
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.
    http://www.php.net/manual/en/functio...ape-string.php

    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.

  7. #7
    SitePoint Enthusiast
    Join Date
    Apr 2009
    Posts
    50
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by ToddW View Post
    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.
    http://www.php.net/manual/en/functio...ape-string.php

    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.
    thanks for ur suggestions bro...


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •