Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sign-up.html
- <!DOCTYPE HTML>
- <html>
- <head>
- <title>Sign-Up</title>
- </head>
- <body id="body-color">
- <div id="Sign-Up">
- <fieldset style="width:30%"><legend>Registration Form</legend>
- <table border="0">
- <tr>
- <form method="POST" action="connectivity-sign-up.php">
- <td>Name</td><td> <input type="text" name="name"></td>
- </tr>
- <tr>
- <td>Email</td><td> <input type="text" name="email"></td>
- </tr>
- <tr>
- <td>UserName</td><td> <input type="text" name="user"></td>
- </tr>
- <tr>
- <td>Password</td><td> <input type="password" name="pass"></td>
- </tr>
- <tr>
- <td>Confirm Password </td><td><input type="password" name="cpass"></td>
- </tr>
- <tr>
- <td><input id="button" type="submit" name="submit" value="Sign-Up"></td>
- </tr>
- </form>
- </table>
- </fieldset>
- </div>
- </body>
- </html>
- style.css
- /*CSS File For Sign-Up webpage*/
- #body-color{
- background-color:#6699CC;
- }
- #Sign-Up{
- background-image:url('sign-up.png');
- background-size:500px 500px;
- background-repeat:no-repeat;
- background-attachment:fixed;
- background-position:center;
- margin-top:150px;
- margin-bottom:150px;
- margin-right:150px;
- margin-left:450px;
- padding:9px 35px;
- }
- #button{
- border-radius:10px;
- width:100px;
- height:40px;
- background:#FF00FF;
- font-weight:bold;
- font-size:20px;
- }
- Query for table in MySQL
- CREATE TABLE WebsiteUsers
- (
- userID int(9) NOT NULL auto_increment,
- fullname VARCHAR(50) NOT NULL,
- userName VARCHAR(40) NOT NULL,
- email VARCHAR(40) NOT NULL,
- pass VARCHAR(40) NOT NULL,
- PRIMARY KEY(userID)
- );
- Database connection
- <?php
- define('DB_HOST', 'localhost');
- define('DB_NAME', 'practice');
- define('DB_USER','root');
- define('DB_PASSWORD','');
- $con=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " . mysql_error());
- $db=mysql_select_db(DB_NAME,$con) or die("Failed to connect to MySQL: " . mysql_error());
- ?>
- checking the connection of database connectivity
- <?php
- define('DB_HOST', 'localhost');
- define('DB_NAME', 'practice');
- define('DB_USER','root');
- define('DB_PASSWORD','');
- $con=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " . mysql_error());
- $db=mysql_select_db(DB_NAME,$con) or die("Failed to connect to MySQL: " . mysql_error());
- if (mysqli_connect_errno($con))
- {
- echo "Failed to connect to MySQL: " . mysqli_connect_error();
- }
- else
- {
- echo “Successfully connected to your database…”;
- }
- ?>
- connectivity-sign-up.php
- <?php
- define('DB_HOST', 'localhost');
- define('DB_NAME', 'practice');
- define('DB_USER','root');
- define('DB_PASSWORD','');
- $con=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " . mysql_error());
- $db=mysql_select_db(DB_NAME,$con) or die("Failed to connect to MySQL: " . mysql_error());
- function NewUser()
- {
- $fullname = $_POST['name'];
- $userName = $_POST['user'];
- $email = $_POST['email'];
- $password = $_POST['pass'];
- $query = "INSERT INTO websiteusers (fullname,userName,email,pass) VALUES ('$fullname','$userName','$email','$password')";
- $data = mysql_query ($query)or die(mysql_error());
- if($data)
- {
- echo "YOUR REGISTRATION IS COMPLETED...";
- }
- }
- function SignUp()
- {
- if(!empty($_POST['user'])) //checking the 'user' name which is from Sign-Up.html, is it empty or have some text
- {
- $query = mysql_query("SELECT * FROM websiteusers WHERE userName = '$_POST[user]' AND pass = '$_POST[pass]'") or die(mysql_error());
- if(!$row = mysql_fetch_array($query) or die(mysql_error()))
- {
- newuser();
- }
- else
- {
- echo "SORRY...YOU ARE ALREADY REGISTERED USER...";
- }
- }
- }
- if(isset($_POST['submit']))
- {
- SignUp();
- }
- ?>
Add Comment
Please, Sign In to add comment