The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
Will check out details which look great and let you know how I progress.
Excellent examples!
Combined with the MySQL posts it should get you on the way.
Also, please don't take this the wrong way but if you don't know where to start with PHP then 'PHP For Dummies' was a big help when I started learning database driven sites.
Also, also, I use a really neat free program called 'HeidiSQL' to manage my MySQL databases from my desktop. A quick search should find the site to download it from.
JTD
I normally use Microsoft Web Expression 4 to build most websites and in the past Front Page. Can I still do this? Even with PHP?
Yes Expression Web 4 supports PHP.
[s]Hmmm...[/s]
How do I link best PHP to my normal HTML coding?
Apologies for these silly simple questions however again I think I am missing a crucial and possibly very simple first step?
This might be very useful so read and inwardly digest :¬)
I will start working along the lines you describe.
Great examples again!
Another question though:
I normally use Microsoft Web Expression 4 to build most websites and in the past Front Page. Can I still do this? Even with PHP?
Or should I use another web program?
Or will everything I need be within Freeola setup software?
How do I link best PHP to my normal HTML coding?
Apologies for these silly simple questions however again I think I am missing a crucial and possibly very simple first step?
Thanks again for all your valued help.
Any further comments most welcome.
Thanks JTD
Will this be hidden from users as they should only see their own part of the database? Assuming so as it is PHP code?
Yes, your connection details are hidden. Anything between the
I like to put my connection details in a separate file and 'include_once' it in any pages I load which needs to connect.
and
Also I am correct in thinking I can setup a table for users which can contain a username and password for each?
yes, that is correct too.
Set up a new table called 'users' for example and include fields for Name, username and password, along with any other details you need to collect (email address is always a good one in case you need to validate/send a forgot password email).
Then you need to create a page with a form, then either write a php script (or find one on-line) to validate the submitted username/password details against the database.
It's also advisable to check for 'hacking' code in the username and password submissions. Use something like this when getting the submitted details:
$username = mysql_escape_string($_REQUEST['username']);
..to remove the basic hacking strategies.
I also store passwords as an MD5 hash to keep them safe in case the db is compromised.
So.. to summarise:
- create a user table.
- create a landing web page.
- add a user validation form to that web page.
- upon submission of the form valid the user credentials against the user table (using escape_string).
- if a record is matched then do something, otherwise do something else.
- consider adding functions to add, update, delete accounts.
- consider adding password username reminder page too.
The examples are excellent however still have a question?
I wish to set up the database so that users can access with username and password securely. I see that initially the Freeola username and password are in the PHP coding to allow website to start and function. Will this be hidden from users as they should only see their own part of the database? Assuming so as it is PHP code?
Also I am correct in thinking I can setup a table for users which can contain a username and password for each?
Many thanks again for help to date.
Any comments welcomed.
I tried to set up a very simple database as a test for example create a file with 3 fields and add say 5 records.
Ideally I wished to use PHP to introduce the Database Creation by a few echo strings describing the Title and Fields.
I did try VIP and SQL with Freeola however it did not seem to work?
Possibly I am missing a very simple first step!!
Any ideas on how and where to put this simple code (I think) would be gratefully received.
Many thanks in anticipation.