Yes, using the following code:
Create Table/Database:
Code:
<?php
$con = mysql_connect("localhost","Username","Password");
if (!$con)
{
die(mysql_error());
}
// Create database
if (mysql_query("CREATE DATABASE WB",$con))
{
echo "Database Created!";
}
else
{
echo mysql_error();
}
// Create table in WB database
mysql_select_db("WB", $con);
$sql = "CREATE TABLE Users
(
ID int not null auto_increment,
Username text,
Password text,
primary key(ID)
)";
mysql_query($sql,$con);
mysql_close($con);
?>
Add New User (New.html):
Code:
<html>
<body>
<form action="New.php" method="post">
<h2>Add User</h2>
Username: <input type="text" name="Username" />
Password: <input type="text" name="Password" />
<input type="submit" />
</form>
</body>
</html>
Add New User (New.php):
Code:
<?php
$con = mysql_connect("localhost","Username","Password");
if (!$con)
{
die(mysql_error());
}
mysql_select_db("WB", $con);
$sql="INSERT INTO Users (Username, Password)
VALUES
('$_POST[Username]','$_POST[Password]')";
if (!mysql_query($sql,$con))
{
die(mysql_error());
}
echo $_POST[Username] . "'s Account Created Successfully!";
mysql_close($con)
?>
Now What?
Bookmarks