Example : All-in-one Complete PHP Integrated Codes [ Part – I, With CSS ].
//File Saved as = Test2.php
<?php
// ------------------ Connectivity codes --------------------
error_reporting(E_ERROR | E_PARSE);
$conn = mysqli_connect("localhost","root","","registration");
if(!$conn)
{
die("Connection Failed : ".mysqli_connect_error());
}
$urslno3="";
$ursname3="";
$uraddr3="";
$urgen3="";
$uruname3="";
$urpasswd3="";
$urcpasswd3="";
$urdob3="";
$urmobno3="";
$uremail3="";
$ursecques3="";
$ursecans3="";
$urcricket3="";
$urdance3="";
$urmusic3="";
$urrem3="";
// ------------------ Save or Add new Records code --------------------
if(isset($_POST['BtnSave']))
{
$urslno3 = $_POST['urslno1'];
$ursname3 = $_POST['ursname1'];
$uraddr3 = $_POST['uraddr1'];
$urgen3 = $_POST['urgen1'];
$uruname3 = $_POST['uruname1'];
$urpasswd3 = $_POST['urpasswd1'];
$urcpasswd3 = $_POST['urcpasswd1'];
$urdob3 = $_POST['urdob1'];
$urmobno3 = $_POST['urmobno1'];
$uremail3 = $_POST['uremail1'];
$ursecques3 = $_POST['ursecques1'];
$ursecans3 = $_POST['ursecans1'];
$urcricket3 = isset($_POST['urcricket1']) ? $_POST['urcricket1'] : "";
$urdance3 = isset($_POST['urdance1']) ? $_POST['urdance1'] : "";
$urmusic3 = isset($_POST['urmusic1']) ? $_POST['urmusic1'] : "";
$urrem3 = $_POST['urrem1'];
if($urpasswd3 != $urcpasswd3)
{
echo "<script>
alert('Password and Confirm Password do not match');
</script>";
}
else
{
$query="INSERT INTO ureg
(
slno5,
sname5,
addr5,
gen5,
uname5,
password5,
cpassword5,
dob5,
mobno5,
email5,
secques5,
secans5,
cricket5,
dance5,
music5,
rem5
)
VALUES
(
'$urslno3',
'$ursname3',
'$uraddr3',
'$urgen3',
'$uruname3',
'$urpasswd3',
'$urcpasswd3',
'$urdob3',
'$urmobno3',
'$uremail3',
'$ursecques3',
'$ursecans3',
'$urcricket3',
'$urdance3',
'$urmusic3',
'$urrem3'
)";
if(mysqli_query($conn,$query))
{
echo "<script>
alert('Record Saved Successfully');
</script>";
}
else
{
echo "<script>
alert('Save Failed');
</script>";
echo mysqli_error($conn);
}
}
}
// ------------------ Search Existing Records code --------------------
if(isset($_POST['BtnSearch']))
{
$urslno3=$_POST['urslno1'];
$query="select * from ureg where slno5='$urslno3'";
$result=mysqli_query($conn,$query);
if(mysqli_num_rows($result)>0)
{
$male="";
$female="";
$other="";
$row=mysqli_fetch_array($result);
$urslno3=$row['slno5'];
$ursname3=$row['sname5'];
$uraddr3=$row['addr5'];
$urgen3=$row['gen5'];
$uruname3=$row['uname5'];
$urpasswd3=$row['password5'];
$urcpasswd3=$row['cpassword5'];
$urdob3=$row['dob5'];
$urmobno3=$row['mobno5'];
$uremail3=$row['email5'];
$ursecques3=$row['secques5'];
$ursecans3=$row['secans5'];
$urcricket3=$row['cricket5'];
$urdance3=$row['dance5'];
$urmusic3=$row['music5'];
$urrem3=$row['rem5'];
if($urgen3=="Male")
{
$male="checked";
}
elseif($urgen3=="Female")
{
$female="checked";
}
elseif($urgen3=="Other")
{
$other="checked";
}
echo "<script>alert('Record Found');</script>";
}
else
{
echo "<script>alert('Record Not Found');</script>";
}
}
// --------------- Delete or Remove Existing Record codes -----------------
if(isset($_POST['BtnDelete']))
{
$urslno3=$_POST['urslno1'];
$query="delete from ureg where slno5='$urslno3'";
if(mysqli_query($conn,$query))
{
echo "<script>
alert('Record Deleted Successfully');
</script>";
$urslno3="";
$ursname3="";
$uraddr3="";
$urgen3="";
$uruname3="";
$urpasswd3="";
$urcpasswd3="";
$urdob3="";
$urmobno3="";
$uremail3="";
$ursecques3="";
$ursecans3="";
$urcricket3="";
$urdance3="";
$urmusic3="";
$urrem3="";
}
else
{
echo "<script>
alert('Delete Failed');
</script>";
}
}
// -------- Edit/Modify/Update/Change Existing Record codes ---------
if(isset($_POST['BtnUpdate']))
{
$urslno3=$_POST['urslno1'];
$ursname3=$_POST['ursname1'];
$uraddr3=$_POST['uraddr1'];
$urgen3=$_POST['urgen1'];
$uruname3=$_POST['uruname1'];
$urpasswd3=$_POST['urpasswd1'];
$urcpasswd3=$_POST['urcpasswd1'];
$urdob3=$_POST['urdob1'];
$urmobno3=$_POST['urmobno1'];
$uremail3=$_POST['uremail1'];
$ursecques3=$_POST['ursecques1'];
$ursecans3=$_POST['ursecans1'];
$urcricket3=isset($_POST['urcricket1'])? $_POST['urcricket1']:"";
$urdance3=isset($_POST['urdance1'])? $_POST['urdance1']:"";
$urmusic3=isset($_POST['urmusic1'])? $_POST['urmusic1']:"";
$urrem3=$_POST['urrem1'];
$query=" update ureg set
sname5='$ursname3',
addr5='$uraddr3',
gen5='$urgen3',
uname5='$uruname3',
password5='$urpasswd3',
cpassword5='$urcpasswd3',
dob5='$urdob3',
mobno5='$urmobno3',
email5='$uremail3',
secques5='$ursecques3',
secans5='$ursecans3',
cricket5='$urcricket3',
dance5='$urdance3',
music5='$urmusic3',
rem5='$urrem3'
where slno5='$urslno3'
";
if(mysqli_query($conn,$query))
{
echo "<script>
alert('Record Updated Successfully');
</script>";
// clear with submission of page.
header("Location: Test2.php");
exit();
// OR clear with submission of page.
// echo "<script>
// alert('Record Updated Successfully');
// window.location.href='Test2.php';
// </script>";
// exit();
// OR clear without submission of page.
// $urslno3="";
// $ursname3="";
// $uraddr3="";
// $urgen3="";
// $uruname3="";
// $urpasswd3="";
// $urcpasswd3="";
// $urdob3="";
// $urmobno3="";
// $uremail3="";
// $ursecques3="";
// $ursecans3="";
// $urcricket3="";
// $urdance3="";
// $urmusic3="";
// $urrem3="";
}
else
{
echo "<script>
alert('Update Failed');
</script>";
}
}
?>
<! ------------------ HTML Design codes -------------------->
<!DOCTYPE html>
<html>
<head>
<title>User Registration Form</title>
<! ------------------ CSS codes -------------------->
<style>
body{
font-family: Arial;
background:#eef3ff;
}
.container{
width:650px;
margin:40px auto;
background:white;
padding:25px;
border-radius:12px;
box-shadow:0 0 10px gray;
}
h2{
text-align:center;
color:#003366;
}
table{
width:100%;
}
td{
padding:8px;
}
input, select, textarea{
width:95%;
padding:8px;
border:1px solid #aaa;
border-radius:5px;
}
.radio, .check{
width:auto;
}
textarea{
height:70px;
}
.btn{
width:110px;
padding:9px;
border:none;
color:white;
border-radius:5px;
cursor:pointer;
}
.save{background:green;}
.reset{background:red;}
.search{background:blue;}
.update{background:orange;}
.delete{background:black;}
</style>
</head>
<! ------------------ Major Body Design codes -------------------->
<body>
<div class="container">
<h2>User Registration Form</h2>
<form name="form1" id="form2" action="#" method="post">
<table>
<tr>
<td>Serial No</td>
<td><input type="number" name="urslno1" id="urslno2" value="<?php echo $urslno3; ?>"required></td>
</tr>
<tr>
<td>Student Name</td>
<td><input type="text" name="ursname1" id="ursname2" value="<?php echo $ursname3; ?>"required></td>
</tr>
<tr>
<td>Address</td>
<td><textarea name="uraddr1" id="uraddr2" required><?php echo $uraddr3; ?></textarea></td>
</tr>
<tr>
<td>Gender</td>
<td>
<input class="radio" type="radio" name="urgen1" id="urgen2" value="Male" <?php echo $male; ?> required> Male
<input class="radio" type="radio" name="urgen1" id="urgen3" value="Female" <?php echo $female; ?> > Female
<input class="radio" type="radio" name="urgen1" id="urgen4" value="Other" <?php echo $other; ?> > Other
</td>
</tr>
<tr>
<td>User Name</td>
<td><input type="text" name="uruname1" id="uruname2" value="<?php echo $uruname3; ?>" required></td>
</tr>
<tr>
<td>Password</td>
<td><input type="password" name="urpasswd1" id="urpasswd2" value="<?php echo $urpasswd3; ?>" required></td>
</tr>
<tr>
<td>Confirm Password</td>
<td><input type="password" name="urcpasswd1" id="urcpasswd2" value="<?php echo $urcpasswd3; ?>" required></td>
</tr>
<tr>
<td>Date of Birth</td>
<td><input type="date" name="urdob1" id="urdob2" value="<?php echo $urdob3; ?>" required></td>
</tr>
<tr>
<td>Mobile No</td>
<td><input type="text" name="urmobno1" id="urmobno2" maxlength="10" value="<?php echo $urmobno3; ?>" required></td>
</tr>
<tr>
<td>Email</td>
<td><input type="email" name="uremail1" id="uremail2" value="<?php echo $uremail3; ?>" required></td>
</tr>
<tr>
<td>Security Question</td>
<td>
<select name="ursecques1" id="ursecques2" required>
<option value="Choose One">Choose One</option>
<option value="What is Your Favourite Book" <?php if($ursecques3=="What is Your Favourite Book") echo "selected"; ?> >What is Your Favourite Book?</option>
<option value="What is Your Favourite Teacher" <?php if($ursecques3=="What is Your Favourite Teacher") echo "selected"; ?> >What is Your Favourite Teacher?</option>
<option value="What is Your Favourite Place" <?php if($ursecques3=="What is Your Favourite Place") echo "selected"; ?> >What is Your Favourite Place?</option>
<option value="What is Your Favourite Pet" <?php if($ursecques3=="What is Your Favourite Pet") echo "selected"; ?> >What is Your Favourite Pet?</option>
</select>
</td>
</tr>
<tr>
<td>Security Answer</td>
<td><input type="text" name="ursecans1" id="ursecans2" value="<?php echo $ursecans3; ?>" required></td>
</tr>
<tr>
<td>Hobbies</td>
<td>
<input class="check" type="checkbox" name="urcricket1" id="urcricket2" value="Cricket" <?php if($urcricket3=="Cricket") echo "checked"; ?> > Cricket
<input class="check" type="checkbox" name="urdance1" id="urdance2" value="Dance" <?php if($urdance3=="Dance") echo "checked"; ?> > Dance
<input class="check" type="checkbox" name="urmusic1" id="urmusic2" value="Music" <?php if($urmusic3=="Music") echo "checked"; ?> > Music
</td>
</tr>
<tr>
<td>Remarks</td>
<td><textarea name="urrem1" id="urrem2"><?php echo $urrem3; ?></textarea></td>
</tr>
<tr>
<td colspan="2" align="center">
<input class="btn save" type="submit" name="BtnSave" value="Save">
<input class="btn reset" type="reset" value="Reset" onclick="window.location.href='Test2.php';">
<!-- <input class="btn reset" type="submit" value="Refresh"> -->
<input class="btn search" type="submit" name="BtnSearch" value="Search" formnovalidate>
<input class="btn update" type="submit" name="BtnUpdate" value="Update" onclick="return confirm('Do you want to update this record ?');">
<input class="btn delete" type="submit" name="BtnDelete" value="Delete" onclick="return confirm('Do you want to delete this record ?');" formnovalidate>
</td>
</tr>
</table>
</form>
</div>
</body>
</html>
NB:
- use of 'formnovalidate' ignores 'required' compulsory fields on those button.Example : All-in-one Complete PHP Integrated Codes [ Part – II, Without CSS ].
0 Comments