Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New Coder
    Join Date
    Feb 2007
    Posts
    24
    Thanks
    1
    Thanked 0 Times in 0 Posts

    How do they do it?

    Hi, just wanted someone to explain this to me. I am pretty new to php and mysql so excuse me if it's a silly question.
    Ok well i know how to set up a database using php and mysql so a user can look at a variety of products. At the moment I only do this with a few products so it is quite simple. What is i had 1000s of products? Do i have to sit and enter all this data into a database?! How do big websites (such as amazon) go about keeping there stock levels up to date?
    Thanks

  • #2
    Regular Coder
    Join Date
    Jun 2004
    Posts
    194
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Keep in mind that while MySQL is a very good database system, professional companies that store client data tend to go with more corporate solutions like Oracle, Access or perhaps MSSQL and probably do database integration with other hardware devices.

    For example think of online banking, you go to an ATM and withdraw some cash, you check your online banking to see that money has left your account because the client data will either be accessed by multiple devices or they'll have some form of synchronisation going on.

    Although even if they updated these manully through an admin interface keep in mind that Amazon probably employs a lot of people for this task.

  • #3
    Senior Coder
    Join Date
    Jun 2002
    Location
    The Netherlands, Baarn, Ut.
    Posts
    4,252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Entering

    Do i have to sit and enter all this data into a database?!
    Er... basically, yes. Any data that is to be pulled from a table to be shown dynamically on a page has to be present in that table in the first place.

    As Acid indictated, large companies that have numerous entries in their databases employ lots of people to maintain the data, likely supported by applications to make their lives a bit easier.
    Regards,
    Ronald.
    ronaldvanderwijden.com

  • #4
    Senior Coder CFMaBiSmAd's Avatar
    Join Date
    Oct 2006
    Location
    Denver, Colorado USA
    Posts
    3,109
    Thanks
    2
    Thanked 326 Times in 318 Posts
    How do big websites (such as amazon) go about keeping there stock levels up to date?
    When stock is received, it is scanned (barcode/RFID) into the database and when items are pulled to be shipped, they are scanned again to subtract the quantity from the database. However, as we all know humans are not perfect and you also need to regularly (frequency dependent on how critical an absolute accurate count is) perform an inventory count to reconcile actual stock on hand with the quantity indicated in the database.
    If you are learning PHP, developing PHP code, or debugging PHP code, do yourself a favor and check your web server log for errors and/or turn on full PHP error reporting in php.ini or in a .htaccess file to get PHP to help you.

  • #5
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts
    Quote Originally Posted by Acid View Post
    Keep in mind that while MySQL is a very good database system, professional companies that store client data tend to go with more corporate solutions like Oracle, Access or perhaps MSSQL and probably do database integration with other hardware devices.
    I wouldn't quite put Access in the same regards as the other two because compared to those products, its substantially inferior. And while MySQL can be used by anyone for free, it is still an enterprise product. Just look at all the big organizations that use it: http://www.mysql.com/customers/
    OracleGuy

  • #6
    Regular Coder
    Join Date
    Jun 2004
    Posts
    194
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Oh yeah granted, I just used Access as another example because ive noticed it being used for corporate solutions whereas MySQL doesn't seem to be quite as common even though IMO it was way better than Access.


  •  

    Posting Permissions

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