How to make a database??

ofSHIZ

How can I make a Database that has A username and password thing..?

sgoku01

What do you want to do??
Creating a database where you store a username and password in??
Or do you want to create your own database, like mysql???

ofSHIZ

Mysql one.. to store pass and users name

sgoku01

Download phpmyadmin (search with google or something for it)...

dalecosp

If you want to create the database using mysql, you'll need to have a working MySQL installation and learn a little about the langugage in the online manual at www.mysql.com.

A real simple SQL script for this task:

DROP DATABASE IF EXISTS foo;

CREATE DATABASE foo;

USE foo;

DROP TABLE IF EXISTS auth_table;

CREATE TABLE auth_table (
  username    varchar(16) PRIMARY KEY,
  password    varchar(16) NOT NULL,
  full_name   text
);

Note that, like PHP, MySQL commands end with a semicolon (';')

You can feed the file above to the MySQL monitor (if you have appropriate permission) thusly:

mysql < foodatabasescript.sql

As you probably know, PHP has a built in library of commands for dealing with MySQL as well. In PHP:

$db=mysql_pconnect("hostname", "username", "password");

mysql_create_database("foo");

and so on...

I was pretty skeptical about my ability to learn MySQL, because, although I found PHP pretty easy, I had more trouble with JavaScript and I also couldn't find a book on MySQL that wasn't thicker than the St. Louis phone directory, but the online manual was helpful and easy to use.

HTH,

ofSHIZ

Thanks.. I never really tried javascript.. I never really wanted to.. the code i got for the login script looks like this.. can you tell me if its right..? (since you think php is easy..)
--Login Code---

<?
session_start();
session_register("log");
$log = "";
?>
<html>
<head>
<title></title>
</head>
<body>
<?
$conn = mysql_connect("localhost", "xxxxxxxx", "xxxxxxxxxxx") or die ("Could not connect to database!");
$db = mysql_select_db("xxxxxxxxxxxxx") or die ("Could not select database");
if (isset($signin)){
$log = $username;
$query = "select * from table where username='$username' and password=(password('$password'))";
$result = mysql_query($query) or die (mysql_error());
$isAuth = false;
while($row = mysql_fetch_array($result))
{
if($row['username'] == $username)
{
$isAuth = true;
}
}
if($isAuth)
{
?>
<br><br>
You are logged In!!
<?
}
else
{
?>            <br>
<h2><font color="red">Invalid username or password</font></h2>
<form name="login" action="login.php" method="post"><br>
Username: <input name="username" type="text"><BR>
Password: <input name="password" type="password"><BR>
<input type="submit" name="signin" value="Sign In">
<?
}
}
else
{
?>
<form name="login" action="login.php" method="post"><br>
<b>Login Area for Intranet</b><br><br>
Username: <input name="username" type="text"><BR>
Password: <input name="password" type="password"><BR>
<input type="submit" name="signin" value="Sign In"><br>
<?
}
?>
</form>
</body>
</html>

--Regisration Thingy--

<html>
<head>
<title></title>
<body>
<?
$conn = mysql_connect("localhost", "xxxxxxxxx", "xxxxxxxxxxxx") or die ("Could not connect to database!");
$db = mysql_select_db("xxxxxxxxxxxxxxx") or die ("Could not select database");

if (isset ($create))
{
$queryc = "select * from table where username = '$username';";
$resultc = mysql_query($queryc) or die ("Can not select user database");
$alfonse = false;
while ($rowc = mysql_fetch_array($resultc))
{
if ($uname == $rowc['uname'])
{
$alfonse = true;
}
else
{
}
}
if ($alfonse)
{
echo "<h3>Username already in use.<br>Please select another name.</h3>";
?>
<form name="create" method="POST" action="create.php">
Username <input type="text" name="username"><br>
Password <input type="password" name="password"><br>
<input type="submit" name="create" value="Create Account">
</form>
<?
}
else
{
$query = "insert into table (username,  password) values ('$username', password('$password'));";
$result = mysql_query($query) or die ("Could not add to user");
}
}
else
{
?>
<form name="create" method="POST" action="create.php">
Username <input type="text" name="username"><br>
Password <input type="password" name="password"><br>
<input type="submit" name="create" value="Create Account">
</form>
<?
}
?>
</body>
</html>

ofSHIZ

I also got a book too.. and this thing is awesome.. so I know a little about Mysql..

dalecosp

Looks right?

Well, style (indents, etc) might be better IMHO, but some of my code is pretty sloppy too...there's an article around here somewhere on that. The question is, does it work<?!> and you're probably better suited to answering that since it's on your box...

If it doesn't, then we can look at it further...

The only other thing I notice is that nowdays you don't need to session_register() stuff.

$_SESSION['log']="";

works just as well...

🙂

ofSHIZ

basically.. the problem is.. well.. i insereed the code.. everything works.. i go to the regisration thing.. i type in the username and pass i want.. i then check my MySQL.. nothing happened.. it didn't add anything.. 😕