SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Evangelist
    Join Date
    Mar 2011
    Posts
    423
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Login to edit MySQL table with over 2,000 entries!!!

    Hi,

    I am designing a web site created using a MySQL Database with over 2,000 entries.

    If the quantity in stock (stock control) needs changing for 100 products a week, I am not sure the best method. I am considering creating a login at the web site but am unsure what to ask the user to do...

    ...enter a product code to change the quantity?
    ...select from a selection of drop down boxes (perhaps 200 products in each list; could be annoying to choose correct one)?
    ...or, can the database be viewed? Besides the issue with scrolling up and down and left to right to find the right entry could the quantity be changed in a cell in the table and then saved?
    ...I have heard Excel can be used; is this as simple as uploading and downloading an Excel file?

    Does anyone know what the common practice is?

    Matt.

  2. #2
    SitePoint Member
    Join Date
    Nov 2009
    Location
    North Carolina
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up

    I think some more questions need to be asked. Such as how does the user/customer normally reference the products? Do they normally use the product code. If so then that is what I would key off of since that is what they are familiar with. There are many ways to update the data in the database. They could use PHP Admin or you could write a simple front-end in PHP or some other language that would allow the user to input the product code and update the quantity. It's a matter of how easy you want it to be vs. how much time do you spend developing something.

    You could create a simple page that allows user to input the product code and then you show them the details of that record and allow for input of the new qty. and then just allow them to update it. Anyone with much PHP experience should be able to do this. Of course if you are working with some other platform (i.e. .net or java) you could do it there as well.

    I have not looked lately but there are probably some scripts out there already that might do what you need with just some configuring rather than writing something from scratch. If you have any questions let me know and I can try to help you narrow in on the right direction.
    If I have been of help to you please consider making a
    donation for my time via PayPal here.
    Get a GREAT domain for under $20 each day via my
    STEAL of the DAY page.


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
  •