49 lines
1.2 KiB
PHP
49 lines
1.2 KiB
PHP
|
|
<div class="mainbody">
|
|
<?php
|
|
|
|
|
|
//Declaring server credentials for server connect function
|
|
if(empty($_POST["f_name"]) || empty($_POST["email_id"]) || empty($_POST["u_name"]) || empty($_POST["p_word"]))
|
|
{
|
|
echo "please enter all details";
|
|
}
|
|
else{
|
|
$servername="localhost";
|
|
$username="root";
|
|
$password="";
|
|
$dbname="sample";
|
|
//create connection
|
|
$conn=mysqli_connect($servername,$username,$password,$dbname);
|
|
//check connection
|
|
if(!$conn)
|
|
{
|
|
die("Connection Failed:" .mysqli_connect_error());
|
|
}
|
|
echo "<br>";
|
|
echo "Connection with database $dbname Successful ";
|
|
echo "<br>";
|
|
|
|
|
|
//define user data to local variables.
|
|
|
|
$fname=mysql_real_escape_string($_POST["f_name"]);
|
|
$email=mysql_real_escape_string($_POST["email_id"]);
|
|
$uname=mysql_real_escape_string($_POST["u_name"]);
|
|
$pword=mysql_real_escape_string($_POST["p_word"]);
|
|
//insert data into table "sam" in database "sample"
|
|
|
|
$query="INSERT INTO sam(fname,emailid,uname,password) VALUES('$fname','$email','$uname','$pword')";
|
|
|
|
if(mysqli_query($conn,$query)){
|
|
echo "Your Registration Done Sucessfully...!<br>";
|
|
echo "Please <a href='index.php?page=login'>Login...!<br>";
|
|
}
|
|
else{
|
|
echo "Error:".$query."<br>".mysqli_error($conn);
|
|
}
|
|
|
|
mysqli_close($conn);
|
|
}
|
|
?>
|
|
</div>
|