lonebyrd 0 Report post Posted March 30, 2009 Can someone tell me a good place to find registration/sign-in scripts. I'm looking for something relatively simple to use. I don't know a lot about programming languages, i sort of learn as I'm going. I am still learning MySQL, little by little, and know I'm going to need to use it to do a registration page. I just want something easy to understand so I can learn as I'm going and not need to know all of it right up front. I am a quick learner, I think, so please take that into consideration also. Any help would be appreciated. Share this post Link to post Share on other sites
jlhaslip 4 Report post Posted March 30, 2009 There are some decent scripts to be found in the Tutorial section here on the Xisto, of course. I would suggest you pick up one of those, but here is a link to a really decent log-in/Registration script for those like yourself who prefer to learn from the script as you are building it.http://forums.xisto.com/no_longer_exists/Written by a very knowledgeable member of the w3schools site. Quite well explained and easy to understand how and why it does what it does.Let me know if you run into any difficulties with it. I (or others) can assist you with the install or comprehension of the details. Share this post Link to post Share on other sites
Gaura Mohana 0 Report post Posted March 31, 2009 As usual, it depends on what type of script you are looking for. there are many, many free scripts for almost everything available on teh internet. But looking for them, is simply a ( expirince. so if send me what you are looking for, i might be able to find you the perfect script. Share this post Link to post Share on other sites
lonebyrd 0 Report post Posted April 5, 2009 There are some decent scripts to be found in the Tutorial section here on the Xisto, of course. I would suggest you pick up one of those, but here is a link to a really decent log-in/Registration script for those like yourself who prefer to learn from the script as you are building it.http://forums.xisto.com/no_longer_exists/Written by a very knowledgeable member of the w3schools site. Quite well explained and easy to understand how and why it does what it does.Let me know if you run into any difficulties with it. I (or others) can assist you with the install or comprehension of the details. I am using this script, it is very helpful. But me being new to this I have a few questions regarding my database. What do I need to name it? I used 'registration' but am not sure if that fits in with the script, though I think it does. I did not alter the script at all yet as I want to make sure I have it working and fully understand it. Also, when I made a database in PHP My Admin it has colllation. I do not know what this is. The default seems to be latin but I am American. The only things that looked familiar to me were ASCII and UTF8_unicode. What should I use for collation or should I just leave it empty. Also, with this script, how exactly do I connect to the database? I know I sound like a complete newbie but I've been up for 24 hours so I don't think that is helping any. Please help I am in dire straights. Share this post Link to post Share on other sites
jlhaslip 4 Report post Posted April 9, 2009 IWhat do I need to name it? I used 'registration' but am not sure if that fits in with the script, though I think it does.The DB name doesn't matter, really, since you need to add the name to the login configuration for opening the database.A name such as 'registration' is fine, but might be too long. Remember that the DB name on the Xisto prefixes the user-name, so try to keep the name under 8 characters and add the prefix. ie: in the config file, the dbname for me would become 'jlhaslip_login' if I called it 'login'. when I made a database in PHP My Admin it has collation. I do not know what this is. The default seems to be latin but I am American. The only things that looked familiar to me were ASCII and UTF8_unicode.The collation has to do with the nature of the stored data. The Default collation recognizes most of the Latin-based languages (English, Italian, etc) I would recommend using UTF-8 since it recognizes all the international characters. Say, for example, a member from Brazil wants to register, then UTF-8 would recognize their input from their Brazilian keyboard complete with accents. I just took a look and the SQL file for the tables is using latin1 for its collation. That would work fine. $con = mysql_connect('host', 'jlhaslip_user', password'); // host, username, password mysql_select_db('jlhaslip_jsg', $con); // db name with prefix This is the connection portion of the file named db.php. Complete the information using the above as a guideline. (no, it will not work on my actual account ) This file is 'required' each and everytime you access the database and caused the DB to be opened using the correct information. Hope this helps. Post back if you need anything more. Share this post Link to post Share on other sites
lonebyrd 0 Report post Posted April 10, 2009 This is the connection portion of the file named db.php. Complete the information using the above as a guideline. (no, it will not work on my actual account ) This file is 'required' each and everytime you access the database and caused the DB to be opened using the correct information.O.K. I have another question. My database name in phpmyadmin is the first six digits of my site name _users. But I made a database table in there called reg. In your example how do I use my registration database if I have to put say lonebyrd_users and not lonebyrd_reg? Or can I put the latter? Share this post Link to post Share on other sites
jlhaslip 4 Report post Posted April 10, 2009 The connection portion of the script uses the DB-name. The Query portion of the script uses a Table name.The Database contains Tables. Tables contain Rows. Rows contain columns.Is the "reg" a Database or a Table? Share this post Link to post Share on other sites
lonebyrd 0 Report post Posted April 10, 2009 well it says that my db name is suchandsuch_users and next to that it says table: reg. I'm not sure how to make a db that says reg they all seem to be going under the _users database. Am I doing something wrong or just not understanding phpmyadmin? Share this post Link to post Share on other sites
jlhaslip 4 Report post Posted April 10, 2009 On the Xisto Hosting system, Databases need to be created using the Mysql Wizard and THEN the database selected in phpmyadmin for creating the tables.Due to security on a Shared Hosting System, phpmyadmin is not able to actually create a Database as you would be allowed to on your own Server. It is a two step process.Create the Database in Mysql and then use the SQL file in phpmyadmin to build the tables, add rows, etc. The critical step is to create the DB in MYSQL first. Add the Tables using phpmyadmin or a Script. Share this post Link to post Share on other sites