Results 1 to 4 of 4

Thread: Building a PHP/MySQL Web App

  1. #1
    Join Date
    Apr 2006
    Posts
    584
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Building a PHP/MySQL Web App

    Hi all,

    Have just started learing PHP/MySQL and am hooked! But all the tutorials I have read discuss the technical side of using these languages. I wanted to know more the logisitics, say I want to try and build a small Project Management system. My question on this is the planning, do I need from the get go do have all my tables known? And also when building is it common to add dummy data? Just wanted opinions on how each of you would go about the process... Is there a general order you all use?

  2. #2
    Join Date
    Jul 2006
    Location
    Canada
    Posts
    2,581
    Thanks
    13
    Thanked 28 Times in 28 Posts

    Default

    Yes, you create your tables first with the CREATE TABLE ... command:
    Code:
    CREATE TABLE mytable (id int(6) auto_increment, values, PRIMARY KEY(id),UNIQUE ID(id),KEY id_2(id))
    Then you do the queries.
    - Mike

  3. #3
    Join Date
    Jul 2006
    Location
    just north of Boston, MA
    Posts
    1,806
    Thanks
    13
    Thanked 72 Times in 72 Posts

    Default

    Code:
    SELECT * FROM 'dbname';
    this code will print out everything located in the table "dbname"

  4. #4
    Join Date
    Apr 2007
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Hi tomy,

    Greetings,

    Yes. Project planning is part of project management, which relates to plan and subsequently report progress within the project environment.

    Before moving to technical side of the project, better make the plan for your project.

    Here is the link for reference

    http://en.wikipedia.org/wiki/Project_management

    Sure, while building the table you should try with dummy data. It would be much better, before storing real data.

    Hope this helps!!!

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
  •