C R U D E (WITH BOOTSTRAP)


---//REGISTER.PHP//---



<?php

include "conn.php";
if(isset($_POST['save']))
{
 $name=$_POST['name'];
 $email=$_POST['email'];
 $password=$_POST['password'];


$sql="INSERT INTO bot(`name`,`email`,`password`)
      VALUES('$name','$email','$password')";

      if (mysqli_query($db,$sql)) {
        header("location:login.php");
        exit;

      }else{
          echo "Error:" . $sql . "" . mysqli_error($db);
      }
      mysqli_close($db);
      }
?>

<!DOCTYPE html>
<html lang="en">
<head>
  <title>Register</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
</head>
<body>

<div class="container">
  <h2>REGISTER HERE</h2>
  <form action="" method="post">
  <div class="form-group">
  <span style="color:red">*</span><label for="name">Name:</label>
      <input type="name" class="form-control" id="name" placeholder="Enter name" name="name" Required>
      <span id="nameerror" style="color:red"></span>
    </div>
    <div class="form-group">
    <span style="color:red">*</span><label for="email">Email:</label>
      <input type="email" class="form-control" id="email" placeholder="Enter email" name="email" Required>
      <span id="emailerror" style="color:red"></span>
    </div>
    <div class="form-group">
    <span style="color:red">*</span><label for="password">Password:</label>
      <input type="password" class="form-control" id="password" placeholder="Enter password" name="password" Required>
      <span id="passworderror" style="color:red"></span>
    </div>
    <button type="submit" name="save" value="submit" onclick="return validation()" class="btn btn-success">Submit</button></button>
  </form>
</div>

</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 name');
        temp++;
    }else{
        $('#nameerror').html('');
    }


    var name=$('#email').val();
    if (name=="") {
        $('#emailerror').html('Please enter email');
        temp++;
    }else{
        $('#emailerror').html('');
    }


    var name=$('#password').val();
    if (name=="") {
        $('#passworderror').html('Please enter password');
        temp++;
    }else{
        $('#passworderror').html('');
    }


    if(temp==0){
        return true;
       }else{
        return false;
       }
       
   }
   </script>




---//CONN.PHP//---


<?php

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

 if(!$db)
 {
     die("Connection Failed:".mysqli_connect_error());
 }
?>




---//LIST.PHP//---


<?php
session_start();
if (empty($_SESSION['username'] )) {
  header("location:login.php");
}
?>

<!DOCTYPE html>
<html>
<head>
<title>Data List</title>
</head>
<body>
<h1>DATA LIST</h1>

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

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">

<a href ="register.php"> <button type="button" class="btn btn-success">Add New</button></a><br><br>
<a href="logout.php"><button type="button" class="btn btn-danger">Logout</button></a><br><br>

<table border="5">
<tr>
<td><b>#</b></td>
<td><b>Name</b></td>
<td><b>Email</b></td>
<td><b>Password</b></td>
<td><b>Edit</b></td>
<td><b>Delete</b></td>
</tr>

<?php
include "conn.php";
$id=$_SESSION['id'];
$records = mysqli_query($db,"select * from bot 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><a href="edit.php?id=<?php echo $data['id']; ?>"><span class="glyphicon glyphicon-edit" style="color:blue"></span></a></td>
<td><a href="delete.php?id=<?php echo $data['id']; ?>"><span class="glyphicon glyphicon-trash" style="color:red"></span></a></td>
</tr>

<?php
}
?>

</table>
</body>
</html>





---//EDIT.PHP//---


<?php

session_start();
if (empty($_SESSION['username'] )) {
  header("location:login.php");
}

include "conn.php";
$id=$_GET['id'];
$qry=mysqli_query($db,"SELECT*FROM bot WHERE id='$id'");

$data=mysqli_fetch_array($qry);

if(isset($_POST['update']))
{
 $name=$_POST['name'];
 $email=$_POST['email'];
 $password=$_POST['password'];

$edit = mysqli_query($db,"UPDATE bot SET name='$name', email='$email', password='$password' WHERE id='$id'");
}
if($edit)
{
     header("location:list.php");
     exit;
}
else
{
    echo mysqli_error($db);
}
?>


<!DOCTYPE html>
<html lang="en">
<head>
  <title>Update</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
</head>
<body>

<div class="container">
  <h2>UPDATE DATA</h2>
  <form action="" method="post">
  <div class="form-group">
  <span style="color:red">*</span><label for="name">Name:</label>
      <input type="name" class="form-control" id="name" value="<?php echo $data['name']?>" placeholder="Enter name" name="name" Required>
      <span id="nameerror" style="color:red"></span>
    </div>
    <div class="form-group">
    <span style="color:red">*</span><label for="email">Email:</label>
      <input type="email" class="form-control" id="email" value="<?php echo $data['email']?>" placeholder="Enter email" name="email" Required>
      <span id="emailerror" style="color:red"></span>
    </div>
    <div class="form-group">
    <span style="color:red">*</span><label for="password">Password:</label>
      <input type="password" class="form-control" id="password" value="<?php echo $data['password']?>" placeholder="Enter password" name="password" Required>
      <span id="passworderror" style="color:red"></span>
    </div>
    <button type="submit" name="update" value="submit" onclick="return validation()" class="btn btn-success">Update</button></button>
  </form>
</div>

</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 name');
        temp++;
    }else{
        $('#nameerror').html('');
    }


    var name=$('#email').val();
    if (name=="") {
        $('#emailerror').html('Please enter email');
        temp++;
    }else{
        $('#emailerror').html('');
    }


    var name=$('#password').val();
    if (name=="") {
        $('#passworderror').html('Please enter password');
        temp++;
    }else{
        $('#passworderror').html('');
    }


    if(temp==0){
        return true;
       }else{
        return false;
       }
       
   }
   </script>




---//DELETE.PHP//---


<?php

session_start();
if (empty($_SESSION['username'] )) {
  header("location:login.php");
}

include "conn.php";

$id = $_GET['id'];

$del = mysqli_query($db,"delete from bot 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 bot 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");
}
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
  <title>Login</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
</head>
<body>

<div class="container">
  <h2>LOGIN HERE</h2>
  <form action="" method="post">
    <div class="form-group">
    <span style="color:red">*</span><label for="email">Email:</label>
      <input type="email" class="form-control" id="email" placeholder="Enter email" name="email" Required>
      <span id="emailerror" style="color:red"></span>
    </div>
    <div class="form-group">
    <span style="color:red">*</span><label for="password">Password:</label>
      <input type="password" class="form-control" id="password" placeholder="Enter password" name="password" Required>
      <span id="passworderror" style="color:red"></span>
    </div>
    <button type="submit" name="login" value="submit" onclick="return validation()" class="btn btn-success">Login</button></button>
  </form>
</div>

</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=$('#email').val();
    if (name=="") {
        $('#emailerror').html('Please enter email');
        temp++;
    }else{
        $('#emailerror').html('');
    }


    var name=$('#password').val();
    if (name=="") {
        $('#passworderror').html('Please enter 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

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

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