1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

PHP/mySql help?

Discussion in 'Off Topic' started by Paul, Mar 24, 2012.

  1. Paul

    Paul Well-Known Member

    Hi guys,

    I'm looking for someone to code a nice simple (Well, Very simple) php page for my website. It's not Xenforo related...
    It basically allows a DB to be held with pre-filled info (manufacturers etc), and with the manual updates being final listing prices from Ebay, and then displayed on the site - max/min/lists etc

    Anyone know of anyone that might be interested, or might be able to point me in the direction of someone that could help knock this up? I'll pay the going rate obviously.... to be fair for someone that knows what they are doing it'll probably only take an hour or two...

    Cheers
    Paul
     
  2. Floris

    Floris Guest

    Perhaps use the money to invest in a e-commerse script?
     
  3. Paul

    Paul Well-Known Member

    Floris,

    I must be on a different planet, since i cant see how that relates to my original request in the slightest???

    Cheers
    Paul
     
    mrGTB likes this.
  4. Floris

    Floris Guest

    What I mean is, that if you get a script that allows you to add products, and list them on the site .. You can just remove the element of 'buy this now' and link to the ebay listing? Using the existing functionality of a script make to handle input / output of data such as what you seem to request. Of course, writing it from scratch is also an option. I am just thinking out loud to help you perhaps save time and money.

    [edit] btw, I am trying to throw something together for you - maybe it will help you get started.
     
  5. Floris

    Floris Guest

    I am done with a part of the script, but don't have enough time unfortn. to work on this any further at the moment. Hopefully this video gives you an impression of what's possible, and you can comment if this is completely (not) what you're looking for. Or at the least, which fields you'd like to have?


    Alt download : the original 13mb .mov
     
  6. DRE

    DRE Well-Known Member

    CodeCanyon has a good forum request for this stuff. http://codecanyon.net/forums/topic/item-requests/67
     
  7. Paul

    Paul Well-Known Member

    Floris,

    That was Ace!! Many thanks. It's close to what i'm after - i'll drop you a PM as to what isnt quite right - however it's close :D

    Thanks again
    Paul
     
    Floris likes this.
  8. Floris

    Floris Guest

    Glad to hear we're on the right path.
     
    Paul likes this.
  9. Paul

    Paul Well-Known Member

    Ok, so the existing database i have populated is attached... if i've exported it correctly (just the raw tables)...

    Basically What i'm after is this...

    Backend - Manually the ability to select a game from the list (this would also pull the other info from the DB!), and put in the latest Ebay end price. This would be stored. Then the next one that came up, maybe for the same machine, i would need to the the same.

    Front end - Display similar to this : http://www.bostonpinball.biz/ebay1111.htm . Maybe this will explain a little more as to the outcome and explain what i'm trying to achieve.... (Clear as mud i know!) - basically a minimum, maximum and average prices of specific machines over a period of time :)

    I mean, ideally it would be great to end up like this : http://www.pinpedia.com/prices with the average/max.min prices as per the other one... However i'm relaistic to believe that thats FAR too much work, and too far outta my price range :D

    Many thanks for going to the effort that you did Floris :) It's greatly appreciated :D Thank You

    Paul
     

    Attached Files:

  10. Floris

    Floris Guest

    That pinball db is causing major slowdowns on my host for some reason.
     
  11. Floris

    Floris Guest

    It's using your db now, though limited to 10 entries of course, since it's just under dev anyway.
    You can see there are a few issues, one being that varchar() type fields for XName (had to rename it from Name) that are numeric with double quotes, like: "1 2 3" can be listed, but won't show up in an input field.

    But, I have a few visitors over now, dinner time, etc, .. I will try to pick this up later tonight or tomorrow.
    Screen Shot 2012-03-24 at 8.45.46 PM.png
     
  12. Floris

    Floris Guest

    Quick question, how are you handling listing 5000+ entries? Are they supposed to be on one page?
     
  13. Paul

    Paul Well-Known Member

    Floris,

    Nahh - Paginated i guess - i hadnt thought that far ahead.. maybe display the most recent 10 by default, however as i say - hadnt really though about it! :D

    That DB shouldnt have caused any problems really - 5k lines long, 5 tables... Strange!!

    Oh and the fields are probably wrong anyhow - i just imported them from (euugh) excel, so no field formatting/adjustments have taken place :D

    Thanks again Floris - Have a Great evening :D

    Paul
     
  14. Floris

    Floris Guest

    Sent you a PC with live demo to play with in the meantime. Front-end / back-end

    front with some basic css & jQuery table.sorter
    (latest 10 id's from db, sorted desc.) (click headers will sort that table asc, click again: desc)
    Screen Shot 2012-03-24 at 8.46.57 PM.png

    back, same css, but table.sorter not included.
    (latest "20" (unless chosen otherwise) (and option to click 100, 500, all)
    It used to be 3 sections, it's now just 1 section. Next should be 1 submit button to cover all changes at once (using while / foreach, etc)
    Screen Shot 2012-03-25 at 6.13.48 AM.png

    [edit] updated screenshots; time for bed.
     

Share This Page