use php to change records in mysql

Discussion in 'PHP' started by mbaldwin, Nov 12, 2008.

0
  1. #1
    Hi,

    In my member's area, members will be able to add url's in to the site. The number of url's will depend on the level of membership. I want them to be able to see a list of the url's they have added, and next to that url I want buttons for different things, like edit, delete, view stats.

    What is the best way to do this. I know how to get the url's that each member has added from the MySQL database, I am not sure on getting the link for the different options to show up for each url.

    If you need more clarification, let me know, thanks.
    Michael
     
    mbaldwin, Nov 12, 2008 IP
  2. rene7705

    rene7705 Peon

    Messages:
    233
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    if you want php examples to do what you need, provide us the sql table structures please.
    If you want it to happen without page refresh you'll need a javascript base-lib. I recommend jQuery but dont know the other ones..
     
    rene7705, Nov 12, 2008 IP
  3. mbaldwin

    mbaldwin Active Member

    Messages:
    215
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    95
    #3
    Okay, I hope this info helps.

    I do not need to do it with no page refresh.
    The tables that will be involved are:

    Members table
    Which has a id, user_name, fname, lname, acct_level (the level of their membership, that is stored in a table), password, ip, and if they have verified (to make sure they verified the email address).

    Url table
    Has id, member_id, url, pause (the member can pause or un pause the url), active, (if the url has been approved), banned, action-date, start-date (when to start the promotion of there url), end-date, daily_limit, daily_show, monthly_limit, monthly_show, total_shows.

    Then a tracking table with id, url_id, action_date, ip, browser, and refferal_site(the site the website was viewed from).

    Okay got that? Now different membership levels will have different options available to them. So a level 1 option, well scratch that, 1 will be for admins, a level 2 member might only be allowed to display 1 url, then level 3 might be able to display 3 urls, and be able to change the start and end date of there promotion period, so they can have the website in the system and ready to go for a specific launch date.

    So lets say a member clicks on the "manage url's" in their members area, I want them to see a grid of their website weather it be 1, 3, 5, or whatever their membership level entitles them to, along with the daily_show, monthly_shows, and total_shows. With links by the urls, for each one, to delete, edit, or view detailed stats. If they click on delete it can just bring up a popup, or a different page to confirm the delete, edit I want to take them to a different page where they can edit the url info based on their membership level, and view detailed stats will bring them to a page that shows basically the info from the tracking table for the url they clicked on the link by.

    So, it is how to get that first grid to show up, I think I can get the other things.
    Thanks,
    Michael
     
    mbaldwin, Nov 12, 2008 IP