C R U D E

 REGISTER.PHP

<?php

include "conn.php";

if(isset($_POST['save']))

{

$name=$_POST['name'];

$email=$_POST['email'];

$password=$_POST['password'];

$contact=$_POST['contact'];

$hobbies=$_POST['hobbies'];

$finalhobb=implode(',',$hobbies);

$gender=$_POST['gender'];

$sql="INSERT INTO pg(`name`,`email`,`password`,`contact`,`hobbies`,`gender`)

VALUES('$name','$email','$password','$contact','$finalhobb','$gender')";

if (mysqli_query($db,$sql)) {

header("location:login.php"); 

exit;

}else{

echo "Error:" . $sql . "" . mysqli_error($db);

}

mysqli_close($db);

}

?>

<html>

<head>

<title>Register Now</title>

<body>

<h1>REGISTER FORM</h1>

<form action="" method="post">

Name:<span style="color:red">*</span><input type="text" id="name" name="name"

placeholder="Enter Name" Required>

<span id="nameerror" style="color:red"></span>

<br><br>

Email:<span style="color:red">*</span><input type="email" id="email"

name="email" placeholder="Enter Email" Required>

<span id="emailerror" style="color:red"></span>

<br><br>

Password:<span style="color:red">*</span><input type="password" id="password"

name="password" placeholder="Enter Password" Required>

<span id="passworderror" style="color:red"></span><br><br>

Conform Password:<span style="color:red">*</span><input type="password"

id="conformpassword" name="conformpassword" placeholder="Enter Conform 

Password" Required>

<span id="conformpassworderror" style="color:red"></span>

<br><br>

Contact:<span style="color:red">*</span><input type="number" id="contact"

name="contact" placeholder="Enter Contact" Required>

<span id="contacterror" style="color:red"></span>

<br><br>

Hobbies:<span style="color:red">*</span><select name ='hobbies[]' id="hobbies"

multiple size = 3>

<option value = 'blogging'>Blogging</option>

<option value = 'readingbooks'> Reading books</option>

<option value = 'dancing'>Dancing</option>

<option value = 'singing'>Singing</option>

<option value = 'listening to music'>Listening to music</option>

<option value = 'playing musical instrument'>Playing musical 

instruments</option>

<option value = 'learning new language'>Learning new language</option>

<option value = 'shopping'>Shopping</option>

</select><span id="hobbieserror" style="color:red"></span>

<br><br>

Gender:<span style="color:red">*</span>

<input type="radio" id="female" name="gender" value="female">Female

<input type="radio" id="male" name="gender" value="male">Male

<span id="gendererror" style="color:red"></span>

<br><br>

<input type="submit" onclick="return validation()" name="save">

</form>

</body>

</html>

<script

src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></scrip

t>

<script>

function validation() { 

var temp=0;

var name=$('#name').val();

if (name=="") {

$('#nameerror').html('Please enter a name');

temp++;

}else{

$('#nameerror').html('');

}

var name=$('#email').val();

if (name=="") {

$('#emailerror').html('Please enter a email');

temp++;

}else{

$('#emailerror').html('');

}

var name=$('#password').val();

if (name=="") {

$('#passworderror').html('Please enter a password');

temp++;

}else{

$('#passworderror').html('');

}

var name=$('#conformpassword').val();

if (name=="") {

$('#conformpassworderror').html('Please enter a conform password');

temp++;

}else{

$('#conformpassworderror').html('');

}

var name=$('#contact').val();

if (name=="") {

$('#contacterror').html('Please enter a contact');

temp++;

}else{

$('#contacterror').html('');

}

var name=$('#hobbies').val();

if (name=="") {

$('#hobbieserror').html('Please enter a hobbies');

temp++;

}else{

$('#hobbieserror').html('');

}

if ($('input[name="gender"]:checked').length == 0) {

$('#gendererror').html('Please enter a gender');

temp++;

}else{

$('#gendererror').html('');

}

if(temp==0){

return true;

}else{

return false;

}

}

</script>




CONN.PHP

<?php

$db= mysqli_connect("localhost","root","","gokul");

if(!$db)

{

die("Connection Failed:".mysqli_connect_error());

}

?>




LIST.PHP

<?php

session_start();

?>

<!DOCTYPE html>

<html>

<head>

<title>Data List</title>

</head>

<body>

<?php echo "<h1>Welcome " . $_SESSION['username'] . "</h1>"; ?>

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/fontawesome/4.7.0/css/font-awesome.min.css">

<h1>DATA LIST</h1>

<a href ="register.php"><i class="fa fa-pencil" aria-hidden="true"></i></i>Add 

New</a><br><br>

<a href="logout.php"><i class="fa fa-sign-out" ariahidden="true"></i>Logout</a><br><br>

<table border='5'>

<tr>

<td>#</td>

<td>Name</td>

<td>Email</td>

<td>Password</td>

<td>Contact</td>

<td>Hobbies</td>

<td>Gender</td>

<td>Edit</td>

<td>Delete</td>

</tr>

<?php

include "conn.php";

$id=$_SESSION['id'];

$records = mysqli_query($db,"select * from pg where id !=".$id." AND `status`=

1 ORDER BY id DESC;"); // fetch data from database

while($data = mysqli_fetch_array($records))

{

?>

<tr>

<td><?php echo $data['id']; ?></td>

<td><?php echo $data['name']; ?></td>

<td><?php echo $data['email']; ?></td>

<td><?php echo $data['password']; ?></td>

<td><?php echo $data['contact']; ?></td>

<td><?php echo $data['hobbies']; ?></td>

<td><?php echo $data['gender']; ?></td>

<td><a href="edit.php?id=<?php echo $data['id']; ?>"><i class="fa fa-edit"

style="font-size:24px"></i></a></td>

<td><a href="delete.php?id=<?php echo $data['id']; ?>"><i class="fa fa-trasho" style="font-size:24px"></i></a></td>

</tr>

<?php

}

?>

</table>

</body>

</html>




EDIT.PHP

<?php

include "conn.php";

$id=$_GET['id'];

$qry=mysqli_query($db,"SELECT*FROM pg WHERE id='$id'");

$data=mysqli_fetch_array($qry);

if(isset($_POST['update']))

{

$name=$_POST['name'];

$email=$_POST['email'];

$password=$_POST['password'];

$contact=$_POST['contact'];

$hobbies=$_POST['hobbies'];

$finalhobb=implode(',',$hobbies);

$gender=$_POST['gender'];

$edit = mysqli_query($db,"UPDATE pg SET name='$name', email='$email', 

password='$password', contact='$contact', hobbies='$finalhobb', 

gender='$gender' WHERE id='$id'");

}

if($edit)

{

header("location:list.php");

exit;

}

else

{

echo mysqli_error($db);

}

?>

<html>

<head>

<title>Edit Data Now</title>

<body>

<h1>EDIT DATA</h1>

<form action="" method="post">

Name:<span style="color:red">*</span><input type="text" id="name" name="name"

value="<?php echo $data['name']?>" placeholder="Enter Name" Required>

<span id="nameerror" style="color:red"></span>

<br><br>

Email:<span style="color:red">*</span><input type="email" id="email"

name="email" value="<?php echo $data['email']?>" placeholder="Enter Email"

Required>

<span id="emailerror" style="color:red"></span>

<br><br>

Password:<span style="color:red">*</span><input type="password" id="password"

name="password" value="<?php echo $data['password']?>" placeholder="Enter 

Password" Required>

<span id="passworderror" style="color:red"></span><br><br>

Contact:<span style="color:red">*</span><input type="number" id="contact"

name="contact" value="<?php echo $data['contact']?>" placeholder="Enter 

Contact" Required>

<span id="contacterror" style="color:red"></span>

<br><br>

Hobbies:<span style="color:red">*</span><select name ='hobbies[]' id="hobbies"

multiple size = 3>

<option value = 'blogging'>Blogging</option>

<option value = 'readingbooks'> Reading books</option>

<option value = 'dancing'>Dancing</option>

<option value = 'singing'>Singing</option>

<option value = 'listening to music'>Listening to music</option>

<option value = 'playing musical instrument'>Playing musical 

instruments</option>

<option value = 'learning new language'>Learning new language</option>

<option value = 'shopping'>Shopping</option>

</select><span id="hobbieserror" style="color:red"></span>

<br><br>

Gender:<span style="color:red">*</span>

<input type="radio" <?php if($data['gender']=='female'){ echo

"checked"; } ?> id="female" name="gender" value="female">Female

<input type="radio" <?php if($data['gender']=='male'){ echo "checked"; 

} ?> id="male" name="gender" value="male">Male

<span id="gendererror" style="color:red"></span>

<br><br>

<input type="submit" onclick="return validation()" name="update">

</form>

</body>

</html>

<script

src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>

<script>

function validation() { 

var temp=0;

var name=$('#name').val();

if (name=="") {

$('#nameerror').html('Please enter a name');

temp++;

}else{

$('#nameerror').html('');

}

var name=$('#email').val();

if (name=="") {

$('#emailerror').html('Please enter a email');

temp++;

}else{

$('#emailerror').html('');

}

var name=$('#password').val();

if (name=="") {

$('#passworderror').html('Please enter a password');

temp++;

}else{

$('#passworderror').html('');

}

var name=$('#contact').val();

if (name=="") {

$('#contacterror').html('Please enter a contact');

temp++;

}else{

$('#contacterror').html('');

}

var name=$('#hobbies').val();

if (name=="") {

$('#hobbieserror').html('Please enter a hobbies');

temp++;

}else{

$('#hobbieserror').html('');

}

if ($('input[name="gender"]:checked').length == 0) {

$('#gendererror').html('Please enter a gender');

temp++;

}else{

$('#gendererror').html('');

}

if(temp==0){

return true;

}else{

return false;

}

}

</script>




DELETE.PHP

<?php

include "conn.php"; 

$id = $_GET['id'];

$del = mysqli_query($db,"delete from pg where id = '$id'");

if($del)

{

mysqli_close($db);

header("location:list.php");

exit; 

}

else

{

echo "Error deleting record";

}

?>




LOGIN.PHP

<?php

include "conn.php";

session_start();

if (isset($_SESSION['username'])) {

header("Location: list.php");

}

if(isset($_POST['login'])){

$email = $_POST['email'];

$password = $_POST['password'];

$sql = "SELECT * FROM pg WHERE email='$email' AND `password`='$password'";

$result = mysqli_query($db,$sql);

if (mysqli_num_rows($result) > 0) {

$row = mysqli_fetch_assoc($result);

$_SESSION['id'] = $row['id'];

$_SESSION['username'] = $row['name'];

header("Location: list.php");

}

}

?>

<html>

<head>

<title>Login Page</title>

</head>

<body>

<h1>LOGIN HERE</h1>

<form action="" method="post">

Email:<span style="color:red">*</span><input type="email" id="email"

name="email" placeholder="Enter Email" Required>

<span id="emailerror" style="color:red"></span>

<br><br>

Password:<span style="color:red">*</span><input type="password" id="password"

name="password" placeholder="Enter Password" Required>

<span id="passworderror" style="color:red"></span><br><br>

<input type="submit" name="login" onclick="return validation()"

value="login"><br><br>

<p> Don't have an account? <a href="register.php">Register Here</a>.</p>

</form>

</body>

</html>

<script

src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></scrip

t>

<script>

function validation() { 

var temp=0;

var name=$('#email').val();

if (name=="") {

$('#emailerror').html('Please enter a email');

temp++;

}else{

$('#emailerror').html('');

}

var name=$('#password').val();

if (name=="") {

$('#passworderror').html('Please enter a password');

temp++;

}else{

$('#passworderror').html('');

}

if(temp==0){

return true;

}else{

return false;

}

}

</script>




LOGOUT.PHP

<?php

session_start();

session_destroy();

header("Location: login.php");

?>

Comments

Post a Comment

Popular posts from this blog

TO DO LIST (PHP)

INDEX.PHP <!DOCTYPE html > <html lang = "en" >     <head>         <link rel = "stylesheet" type = "text/css" href = "css/bootstrap.css" />         <meta charset = "UTF-8" name = "viewport" content = "width=device-width, initial-scale=1" />     </head> <body>     <nav class = "navbar navbar-default" >         <div class = "container-fluid" >                     </div>     </nav>     <div class = "col-md-3" ></div>     <div class = "col-md-6 well" >         <h3 class = "text-primary" > PHP - Simple To Do List App </h3>         <hr style = " border-top:1px dotted #ccc; " />         <div class = "col-md-2" ></div>       ...
Read more

LOGIN PAGE

 LOGIN.PHP <?php   include   'conn.php' ; session_start(); if  (isset($_SESSION[ 'username' ])) {     header( "Location: list.php" ); } if  (isset($_POST[ 'submit' ])) {     $email = $_POST[ 'email' ];     $password = $_POST[ 'password' ];     $sql =  " SELECT   *   FROM  ab  WHERE  email_id = '$email'  AND  `password` = '$password' " ;     $result = mysqli_query($db,$sql);      if  (mysqli_num_rows($result) >  0 ) {         $row = mysqli_fetch_assoc($result);         $_SESSION[ 'username' ] = $row[ 'fullname' ];         header( "Location: list.php" );     }  else...
Read more

FETCH DATA BY ID IN TEXTBOX FROM DATABASE IN PHP MYSQL (SEARCH)

INDEX.PHP <! DOCTYPE   html > < html   lang = "en" > < 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 > Funda of Web IT </ title >      < link   href = "https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/css/bootstrap.min.css"   rel = "stylesheet" > </ head > < body >           < div   class = "container" >          < div   class = "row justify-content-center" >              < div   class = "col-md-7" >    ...
Read more