help on a login

[bigray]

ok im making a login for a company and they want whenever someone signs up they can login and check out how their site is being worked on cuz the company creates sites for people and people wanna see how their site is coming along so they log in and see how it is coming along.........
so would i have to create all the user names and passwords in a txt file and tell php to open it or something what can i do can someone help me?????? plz

[barand]

IMHO it is easier to use a database table than a text file. It makes it easier to update - eg. if the user wants to change their password. Also, I would advise holding the encrypted password rather than the plain text version.

You could also hold the URL of their site so that, when they log in, you can jump straight to it.

[bigray]

can u please tell me how i would do it in phpmyadmin and what i would have to code in php so i can hold their site and etc just a quick example so i can get the paste plz thanks so much man

[barand]

Create a table, say "client"

create table client (username varchar(10) not null primary key,
password char(32),
siteurl varchar(60)
);

You will need

1. a form for you to populate the table with your existing clients

2. a login form for clients

3. a change-password form for clients
   [/list=1]

   In the client login form they enter username and password.
   Query the file selecting password and site by username, check the password and redirect to to their site if valid.

[bigray]

so my form is like this

<form name="form" method="post" action="">
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td width="76" class="fieldTitle">Username</td>
<td width="709">
<input name="username" type="text" class="textField" id="username" value="" maxlength="8">
</td>
</tr>
<tr>
<td width="76" class="fieldTitle">Password</td>
<td>
<input name="password" type="password" class="textField" id="password" maxlength="6">
</td>
</tr>
</table>

and how would i do it in php can u give me a example would i use if else statements or sessions?

and for phpmyadmin how would i add the user name and passwords for the people and how would i redirect them in php thats all i need man and ill be happy

[barand]

To add current clients - put the actual values you want to store in the values(...) bit. (password function encrypts)

mysql> insert into client (username,password, siteurl) values ("username", password("pwd"), "url");

To check valid password and transfer to site

$sql = "select * from client where client.username = $fm_username and ".
"client.password = password($fm_password))";
$result = mysql_query($sql);
if ($row = mysql_fetch_array($result)) {
  $url = $row["siteurl"];
  header("location: $url");
  exit();
} else {
  header("location: "login.html");
  exit();
}

[bigray]

so i make the usernames in phpmyadmin and it will work if i use that code i dont have to create no register form for new users or anything?

[bigray]

i dont have to use no db_connect to?

[Darth_Cow]

No, of course you need to use mysql_connect(). And yes, you could do creating users through phpMyAdmin, but seriously, how difficult is it to make a registration page? A simple query like the one barand mentions would do the trick.

What exactly are you doing though creating this website for a client if you can't even get started programing it yourself? You can't expect someone to give you the code for your entire site. I'd recommend reading the PHP manual's section on mysql functions, and the mysql manual itself for a start. Actually, I'd recommend creating a dynamic site powered by mysql for yourself and looking at the code of others before you sell you non-existant skills to anyone.

[klansman]

maybe you can find somewhere a script which already does just that. there are tons of them out there!

but, like darth cow says: how hard can it be??

[]