I have a login and registration php files already done. I want to figure out how to provide a user created list of movies using php, in my user profile page. When I researched list functions, I only found results involving arrays. The problem with arrays is that it is not permanent.

What I'm looking for would be similar to a Netflix queue, or lists from the myanimelist website, but in this case users can create multiple lists. It would be similar to creating tables in MySql.

Currently, my login and register page will send the user created username and password to a MySql table called users. I am wondering if it's simpler to save the user movie list in a separate table, then show those results in my php page.

    I would probably use a database approach. It might be 2 or 3 tables: one that defines a list and associates it with a user ID, and another table for list items. Each row in the items table would include a foreign key to the list it is associated with. (Alternatively, a third table -- item-to-list -- might be called for if you want to associate list items with more than one list?)

      4 days later

      Currently, my login and register page will send the user created username and password to a MySql table called users. I am wondering if it's simpler to save the user movie list in a separate table, then show those results in my php page.

      [Bogus URL deleted by moderator]

        Write a Reply...