New web help

[buttgone]

I could really use a bit of help here, i have a site i'm working on and got a little lost with the php forms, not sure what the names are of what i need, it's all there for my use but i just don't have the knowhow yet, my host has all the stuff i need (tools) but not understanding how to use it all i ended up with dreamweaver cs4, now thats a cool deal there, lost with the forms i need,(example) when you register here, those forms from the first click on the register button to the final when you get the email notice, what is the names of those forms, or php scripts, and how would i set them up, also would i set those up using the a page with .html?oh and also how do i set up with securing site (meaning) peeps will have to log in to get to some pages ?basictly, i need a tutorial (persay), any volinteers?

buttgone Reviewed by buttgone on 9th Oct 2009. New web help I could really use a bit of help here, i have a site i'm working on and got a little lost with the php forms, not sure what the names are of what i need, it's all there for my use but i just don't have the knowhow yet, my host has all the stuff i need (tools) but not understanding how to use it all i ended up with dreamweaver cs4, now thats a cool deal there, lost with the forms i need,(example) when you register here, those forms from the first click on the register button to the final when Rating: 5

[buttgone]

just found some scripts, shows i got to make pages with /login.php, still i'm lost, what will go in front of the /login.php? or will anything go in front? and will i put the pages in the same file as those php's to get the log ins on them? guess what i need to know is if i got a page with downloadable games, and i need members only in there to get em, will that game page go in the same file with the .php files?

[Mr Happy]

You sound like your starting from scratch with little or no php or sql knowledge so I'll explain the basic idea of what you have to do and then you can view some tutorials.

You will have to have a database someplace, most likely an sql database, which will store the usernames and passwords. Basically a register.php file will check the information input by the visitor to check stuff like if the email is valid, if the usename already exists etc. If the info is ok then then the register.php file will save the data to the database. You will also have a login form which will be probably be login.php and this will check the info input by the visitor. If the info matches the info in the database the login.php file will redirect the visitor to whatever page you want. Usually it also starts a session. A session is a php command that remembers the visitor so they can view certain pages once they have loged. It's not essencial but I'd also suggest a logout page which kill's a session.

That's how it works in theory. Their's lots of stuff on google if you search but here's a basic simple start http://www.trap17.com/index.php/Phpm...ter_t9487.html
or here's a slightly better more advanced one but still basic and easy enough to follow http://www.devshed.com/c/a/MySQL/Cre...ogging-System/

[buttgone]

Thank you for those links, good basic guides, looks simple enough except, well i downloaded the scripts, made a folder in my dreamweaver where my site files are and still lost, do i configure these or just upload them, i did pull some up in my DW and it looks as thogh they can be modded a bit.

[Mr Happy]

ya you'll have to do basic edit's to them.

In simple English: You have to create an sql database where the information can be stored. To create this database you'll have to login to the control panel where your going to upload the files and create a sql database with the online guide their. Don't ask how to do that as it's different from host to host. You'll have to get help on that where your uploading the files. You'll have to create a database and give it a name. You'll also have to create a username and password to access the database for security. That information (database name, database username, database password) will have to be put into the code to allow it to connect to the database and add new members, check the passwords of existing members etc.

In the first tutorial example it just under

//Login to your database. Make the fields of course..

and you'll change user, pass and database but you should be ok in leaving localhost as it is. Just be careful not to remove any of the commas or ''

mysql_connect("localhost","user","pass");
mysql_select_db("database");

Hope that helps.

EDIT: once you've created the database go to the myphp admin bit and select the database you've created. Into that database you'll have to put the table where information is kept. That's the ''CREATE TABLE'' bit. All sql databases store information in tables making it organised and easier to find.

so it's like this
Step 1: Create Database, user, and pass.
Step 2: Create Table in Database
Step 3: edit register.php and insert database name, user and pass.
Step 4: upload files
Step 5: cross your finders.

[buttgone]

Step 2: Create Table in Database, here i got lost, on my server, or host, whatever it's called, has a cool setup, but i'm lost, with your help i am getting somewhere, now i did create, number 1, lost on two, how do i set up table?

[Mr Happy]

Ok easiest way is to copy the below into a txt file and save it as createtable.php or whatever. Then upload and run it :

<?php
// this part connects
$con = mysql_connect("localhost","user","pass");
if (!$con)
  {
  // if their's an error connecting it stops and tell's you the error
  die('Could not connect: ' . mysql_error());
  }

// Create table
mysql_select_db("database", $con);
$sql = "CREATE TABLE `table` (
  `id` int(5) NOT NULL auto_increment,
  `user` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `pass` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
)";

// Execute query
mysql_query($sql,$con);

// Close the command
mysql_close($con);
?>

remember to edit user and pass and replace with your own.
You also need to edit the database in the first line under Create Table and replace it with your own database name.

EDIT: NB this is for the first tutorial and won't work for the second!

[Chri5]

thanks mr happy

[litewarez]

if i was you dood id just bung sumbody 20$ to do it for you or learn you ow to do it lol

[buttgone]

Thank You mr. Happy, i'll do that, just found some more good reading on how to.
And thanks for the comment litewarez, Not a big brainer here but thinking i am trying to learn to do it. Hint for ya, and not beeing a smart tale here either, but we learn from others and thats why we have questions, to find answers?, Hmmm maybe? why do we need answers???? Hmmm, so we can learn... Well now my brain hurts...crap. oh, Mr happy, worked like a charm, thanks again.