lvlasked Posted December 18, 2015 Share Posted December 18, 2015 hello im new to this and hopping you guys can help and i can learn, what i want to be able todo hope i explaine this right, i would like for people to sign up to the website and they can store there data/info, my questions are how do i do it so each user has there own data show up, and can edit add or delete things, something like this site pigeondb.com Link to comment Share on other sites More sharing options...
davej Posted December 18, 2015 Share Posted December 18, 2015 This is not something you can do yourself without first learning quite a bit about web design. You might be better off searching for an available free service that allows shared online storage. https://duckduckgo.com/?q=shared+online+storage Link to comment Share on other sites More sharing options...
lvlasked Posted December 18, 2015 Author Share Posted December 18, 2015 i no a bit about php and sql work im in no rush just a project to do over the months Link to comment Share on other sites More sharing options...
davej Posted December 18, 2015 Share Posted December 18, 2015 Okay, but your question is simply too broad. If you know Php and SQL and HTML and CSS then what more specific questions do you have? We're not here to write long and relatively pointless essays for you Link to comment Share on other sites More sharing options...
justsomeguy Posted December 18, 2015 Share Posted December 18, 2015 In general, you need to associate the data with the user. Most of the time that's accomplished in the database by having a field for each record that holds the user ID associated with that record. If multiple users can have access to the same records then you need to use another table to hold the relationships between the data and the users. All of that is part of relational database design. Link to comment Share on other sites More sharing options...
lvlasked Posted December 18, 2015 Author Share Posted December 18, 2015 cheers ill google around and have alook Link to comment Share on other sites More sharing options...
lvlasked Posted December 19, 2015 Author Share Posted December 19, 2015 i have googled things like " how do i show the content of that user when they log in" but i couldnt find anything help was just showing how to make a sign up page and sign in page, any help to point me in the right direction would be greatful Link to comment Share on other sites More sharing options...
davej Posted December 20, 2015 Share Posted December 20, 2015 Look at this thread for some simplified ideas... http://w3schools.invisionzone.com/index.php?showtopic=54439&hl= Link to comment Share on other sites More sharing options...
justsomeguy Posted January 4, 2016 Share Posted January 4, 2016 This is a question about database design. Like I said, you put a column in the database table that holds the user ID that the record belongs to. If you have a "posts" table, one of those columns will be the user ID who created that post. That is how you associate a record with a single user, or how you represent any one-to-one or one-to-many relationship in a relational database. What you should be researching is relational database design rather than asking Google a question based on your specific situation. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now