Originally Posted by
Call-911
Hey guys, this seems like it should be really easy to do. Any tutorials or information on how to do this would be great!
I need a user-login that will then display information specific to that user.
So I need a database with the following information
User name is: johndoe
Password is: password
Address: 123 ABC Street
Phone: (123) 456-7890
Account Balance: $54.00
So I have all this information in an excel spreadsheet, I need to get it into a mySQL database, and then set up on my website a spot where:
johndoe can login, and then be directed to a page where it shows him his information, AND ONLY his information, not anyone else in the database.
Is this easy to do? Can someone show me a way to or software to do this. Thanks!!!
Well, I don't think it's as easy as you think, if it's a customised job. You would need to export your excel sheet (not an expert on this so won't go into much detail) into a .csv or .xml file or something. You could then create your MySQL database and write a script to import all the details into the DB. You could store the user's id in a session variable to access his data on a certain page. I know this is very vague but if you ask something more specific I'll help ya out.
“The best thing about a boolean is even if you are wrong, you are only off by a bit.”