bookmarks

[brauchi]

I have a nice little idea for a feature I would like to offer. We are a website for francophiles and people are using our site to plan trips to france. I would like to give them a bookmark page where they can store their favorite pages from our website so that they can easily go back and show the articles they found from a different computer.

I would think it should be possible to put a link on the website and this link will then store the link in a database. My problem is that I can only put one link into the database and i would like to guve them the choice of having an unlimited place for their links.

thank you in advance

andrea

[LordShryku]

Why can you only put one in the database?

[brauchi]

i see. you are doing this in an array. i totally for got about that.

[drawmack]

well they would have to be a member then you just create a table like this:

CREATE TABLE IF NOT EXISTS favorites (
    ID BIGINT NOT NULL auto_increment
    MemID BIGINT NOT NULL,
    URL VARCHAR(255) NOT NULL,
    PgTtl VARCHAR(255) NOT NULL,
    Stored TIMESTAMP NOT NULL,
    LastAccessed TIMESTAMP NOT NULL,
    PRIMARY KEY (ID),
    INDEX MemID (MemID),
    UNIQUE PgTtl (PgTtl),
    INDEX Stored (Stored),
    INDEX LastAccessed (LastAccessed)
)

Then just make a php script that will add entries to this and then redirect back to the referer.

Also put a little script on every page that will check if this user bookmarked this page and if so it will update their last accessed time.

This way the user can sort their links based on:
Title, When Bookmarked & Last Accessed.