Insert data by form | PhpMyAdmin
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Let's Programming</title>
<style>
.in{
width:200px;
border-radius:20px
}
</style>
<!-- This is the bootstrap-->
<link href="css/bootstrap.css" rel="stylesheet" type="text/css">
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
</head>
<body>
<div style="background-color:#77B6BB; margin-right:600px; margin-left:600px; border-radius:20px" >
<center>
<form action="form.php" method="POST">
<h2><b>Sign up</b></h2>
<h3>Please sign up it for free</h3>
<input class="in" type="text" placeholder=" Name" required name="userName">
<br>
<br>
<input class="in" type="password" placeholder=" password" required max="8" name="pass">
<br>
<br>
<input class="in" type="email" placeholder=" E-mail" required name="email">
<br>
<br>
<label>Gender: </label>
He<input type="radio" name="Gen" required value="he" >
She<input type="radio" name="Gen" required value="she">
<br>
<br>
<input class="in" type="datetime" placeholder=" Date" name="dateNtime">
<br>
<br>
<input type="submit" value="Sign up" style="border-radius:50px" name="signUp">
<br>
<br>
</form>
</center>
</div>
<br>
<?php
// get the value from form to variables
$userName=$_POST['userName'];
$passWord=$_POST['pass'];
$eMail=$_POST['email'];
$gender=$_POST['Gen'];
$dateNtime=$_POST['dateNtime'];
// display the values got by form on console
echo"The Name:"."<b>$userName</b><br>";
echo"The password:"."<b>$passWord</b>><br>";
echo"The e-mail:"."<b>$eMail</b>";
if($gender=="he")
echo"<br><b>You are male</b>";
else
echo"<br><b>You are female</b>";
echo"<br>The Time and date:"."<b>$dateNtime</b><br>";
// algorithm for password must be combination of alphaNumaric
if($passWord>=0 && $passWord <=9 && $passWord>="a" && $passWord<="z")
echo("<br><b>Valid Password</b>");
else
echo("<br><b>The password is invalid</b>");
if($eMail>=0 && $eMail <=9 && $eMail>="a" && $eMail<="z")
echo("<br><b>Valid E-mail</b>");
else
echo("<br><b>The E-mail is invalid</b>");
// for database connectivity
$user="root";
$pass="";
$db="HU";
$conn=mysql_connect("localhost",$user,$pass,$db) or die ("unable to connect");
// for create table in database
/*
$sql="CREATE TABLE HU.signUp (name varchar(20), pass varchar(20),eMail varchar(20), gender boolean, date varchar(20), about varchar(20));";
*/
// data enter into database by manual method
/*
$sql = "INSERt INTO hu.signUp (name, pass ,eMail, gender ,date , about) VALUES (\"ali\",\"pass\",\"e\",true,\"1222\",\"about\")";
*/
// for insert data by variable in the database
$sql = "INSERT INTO hu.signUp (name, pass ,eMail, gender ,date , about)
VALUES (\"".$userName."\",\"".$passWord."\",\"".$eMail."\",\"".$gender."\",\"".$dateNtime."\",\"about\")";
// show thw query enter
echo("Enter query: "."<b>".$sql."</b>");
// whether query is executed or not
if(mysql_query($sql))
echo "<br><b>New record is entered</b>";
else
echo"<b>Error in enter data</b>";
// connection closed
mysql_close($conn);
?>
</body>
</html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Let's Programming</title>
<style>
.in{
width:200px;
border-radius:20px
}
</style>
<!-- This is the bootstrap-->
<link href="css/bootstrap.css" rel="stylesheet" type="text/css">
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
</head>
<body>
<div style="background-color:#77B6BB; margin-right:600px; margin-left:600px; border-radius:20px" >
<center>
<form action="form.php" method="POST">
<h2><b>Sign up</b></h2>
<h3>Please sign up it for free</h3>
<input class="in" type="text" placeholder=" Name" required name="userName">
<br>
<br>
<input class="in" type="password" placeholder=" password" required max="8" name="pass">
<br>
<br>
<input class="in" type="email" placeholder=" E-mail" required name="email">
<br>
<br>
<label>Gender: </label>
He<input type="radio" name="Gen" required value="he" >
She<input type="radio" name="Gen" required value="she">
<br>
<br>
<input class="in" type="datetime" placeholder=" Date" name="dateNtime">
<br>
<br>
<input type="submit" value="Sign up" style="border-radius:50px" name="signUp">
<br>
<br>
</form>
</center>
</div>
<br>
<?php
// get the value from form to variables
$userName=$_POST['userName'];
$passWord=$_POST['pass'];
$eMail=$_POST['email'];
$gender=$_POST['Gen'];
$dateNtime=$_POST['dateNtime'];
// display the values got by form on console
echo"The Name:"."<b>$userName</b><br>";
echo"The password:"."<b>$passWord</b>><br>";
echo"The e-mail:"."<b>$eMail</b>";
if($gender=="he")
echo"<br><b>You are male</b>";
else
echo"<br><b>You are female</b>";
echo"<br>The Time and date:"."<b>$dateNtime</b><br>";
// algorithm for password must be combination of alphaNumaric
if($passWord>=0 && $passWord <=9 && $passWord>="a" && $passWord<="z")
echo("<br><b>Valid Password</b>");
else
echo("<br><b>The password is invalid</b>");
if($eMail>=0 && $eMail <=9 && $eMail>="a" && $eMail<="z")
echo("<br><b>Valid E-mail</b>");
else
echo("<br><b>The E-mail is invalid</b>");
// for database connectivity
$user="root";
$pass="";
$db="HU";
$conn=mysql_connect("localhost",$user,$pass,$db) or die ("unable to connect");
// for create table in database
/*
$sql="CREATE TABLE HU.signUp (name varchar(20), pass varchar(20),eMail varchar(20), gender boolean, date varchar(20), about varchar(20));";
*/
// data enter into database by manual method
/*
$sql = "INSERt INTO hu.signUp (name, pass ,eMail, gender ,date , about) VALUES (\"ali\",\"pass\",\"e\",true,\"1222\",\"about\")";
*/
// for insert data by variable in the database
$sql = "INSERT INTO hu.signUp (name, pass ,eMail, gender ,date , about)
VALUES (\"".$userName."\",\"".$passWord."\",\"".$eMail."\",\"".$gender."\",\"".$dateNtime."\",\"about\")";
// show thw query enter
echo("Enter query: "."<b>".$sql."</b>");
// whether query is executed or not
if(mysql_query($sql))
echo "<br><b>New record is entered</b>";
else
echo"<b>Error in enter data</b>";
// connection closed
mysql_close($conn);
?>
</body>
</html>
Comments
Post a Comment