<?php
$add = false;
$update = false;
$delete = false;
// Connecting to the Db
$servername = "localhost";
$username = "root";
$password = "";
$database = "form";
//create connection
$conn = mysqli_connect($servername, $username, $password, $database);
if(!$conn){
die('Connection fail!!'.mysqli_connect_error());
}
else{
//echo "Connection was successful";
}
// echo $_POST['snoEdit'];
// echo $_GET['update'];
// exit();
if(isset($_GET['delete'])){
$sno = $_GET['delete'];
$delete = true;
$sql = "DELETE FROM `nodes` WHERE `sno` = '$sno' ";
$result = mysqli_query($conn, $sql);
//redirection
header('refresh:1;url=http://localhost:3000/Create-some-new.php');
}
if ($_SERVER['REQUEST_METHOD'] == 'POST'){
if (isset($_POST['snoEdit'])){
//Update the record
$sno = $_POST['snoEdit'];
$name = $_POST['nameEdit'];
$title = $_POST['titleEdit'];
$desc = $_POST['descEdit'];
$sql = "UPDATE `nodes` SET `name` = '$name' , `title` = '$title' , `desc` = '$desc' WHERE `sno` = '$sno' ";
$result = mysqli_query($conn, $sql);
if($result){
// echo "<br>Record updated successfully";
$update = true;
}
// else{
// echo "<br>Record could not update";
// }
}
else{
$name = $_POST['name'];
$title = $_POST['title'];
$desc = $_POST['desc'];
$sql = "INSERT INTO `nodes` (`name`, `title`, `desc`) VALUES ('$name', '$title', '$desc')";
$result = mysqli_query($conn, $sql);
if($result){
$add = true;
}
}
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.4.1/dist/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">
<link rel="stylesheet" href="https://cdn.datatables.net/2.0.1/css/dataTables.dataTables.min.css">
<title>Add Points/Tasks/Information</title>
</head>
<body>
<div class="modal" id="editModal" tabindex="-1" role="dialog">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title">Update your Data</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<form action="" method="POST">
<div class="modal-body">
<input type="hidden" name="snoEdit" id="snoEdit">
<div class="form-group mt-3">
<label for="name">Name</label>
<input type="text" class="form-control" id="nameEdit" name = "nameEdit" aria-describedby="emailHelp" placeholder="Enter your name" >
</div>
<div class="form-group">
<label for="title">Title</label>
<input type="text" class="form-control" id="titleEdit" name = "titleEdit" aria-describedby="emailHelp" placeholder="Enter your title" >
<!-- <small id="emailHelp" class="form-text text-muted">We'll never share your email with anyone else.</small> -->
</div>
<div class="form-group">
<label for="desc">Desc</label>
<textarea rows="5" class="form-control" name = "descEdit" id="descEdit" placeholder="Enter your desc" ></textarea>
</div>
<!-- <div class="form-group form-check">
<input type="checkbox" class="form-check-input" id="exampleCheck1">
<label class="form-check-label" for="exampleCheck1">Check me out</label>
</div> -->
<!-- <button type="submit" class="btn btn-primary">Update</button> -->
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
<button type="submit" class="btn btn-primary">Save changes</button>
</div>
</form>
</div>
</div>
</div>
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
<a class="navbar-brand" href="">SabkaCode</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarSupportedContent">
<ul class="navbar-nav mr-auto">
<li class="nav-item active">
<a class="nav-link" href="">Home <span class="sr-only">(current)</span></a>
</li>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
More
</a>
<div class="dropdown-menu" aria-labelledby="navbarDropdown">
<a class="dropdown-item" href="http://htmlify.artizote.com">HTMLify</a>
<!--<a class="dropdown-item" href="#"></a>-->
<div class="dropdown-divider"></div>
<a class="dropdown-item" href="#">Feedback</a>
</div>
</li>
<li class="nav-item">
<a class="nav-link" href="https://github.com/upraity">Github</a>
</li>
<li class="nav-item">
<!--<a class="nav-link disabled" href="#" tabindex="-1" aria-disabled="true">Disabled</a>-->
</li>
</ul>
<form class="form-inline my-2 my-lg-0">
<input class="form-control mr-sm-2" type="search" placeholder="Search" aria-label="Search">
<button class="btn btn-outline-success my-2 my-sm-0" type="submit">Search</button>
</form>
</div>
</nav>
<?php
if($add){
echo '
<div class="alert alert-success alert-success fade show" role="alert">
<strong>Success!!</strong> Your data have been inserted successfully.
<button type="button" class="close" data-dismiss="alert" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
';
}
if($update){
echo '
<div class="alert alert-success alert-success fade show" role="alert">
<strong>Success!!</strong> Your data have been updated successfully.
<button type="button" class="close" data-dismiss="alert" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
';
}
if($delete){
echo '
<div class="alert alert-success alert-dismissible fade show" role="alert">
<strong>Success!</strong> Your data have been deleted successfully .
<button type="button" class="close" data-dismiss="alert" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
';
}
?>
<div class="container mt-3">
<form action="" method="POST">
<h2>Add your Data</h2>
<div class="form-group mt-3">
<label for="exampleInputEmail1">Name</label>
<input type="text" class="form-control" id="exampleInputEmail1" name = "name" aria-describedby="emailHelp" placeholder="Enter your name" >
</div>
<div class="form-group">
<label for="exampleInputEmail1">Title</label>
<input type="text" class="form-control" id="exampleInputEmail1" name = "title" aria-describedby="emailHelp" placeholder="Enter your title" >
<!-- <small id="emailHelp" class="form-text text-muted">We'll never share your email with anyone else.</small> -->
</div>
<div class="form-group">
<label for="exampleInputPassword1">Desc</label>
<textarea rows="5" class="form-control" name = "desc" id="exampleInputPassword1" placeholder="Enter your desc" ></textarea>
</div>
<!-- <div class="form-group form-check">
<input type="checkbox" class="form-check-input" id="exampleCheck1">
<label class="form-check-label" for="exampleCheck1">Check me out</label>
</div> -->
<button type="submit" class="btn btn-primary">Add</button>
</form>
<table style="width:100%;" class="table mt-5" id="myTable">
<thead>
<tr>
<th scope="col">Sno</th>
<th scope="col">Name</th>
<th scope="col">Title</th>
<th scope="col">Description</th>
<th scope="col">Date Time</th>
<th scope="col">Action</th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM `nodes` ";
$result = mysqli_query($conn, $sql);
$sno = 0;
while($row = mysqli_fetch_assoc($result)){
$sno++;
echo '
<tr>
<th scope="row">'.$sno.'</th>
<td>'.$row['name'].'</td>
<td>'.$row["title"].'</td>
<td>'.$row["desc"].'</td>
<td>'.$row["data-time"].'</td>
<td><button id='.$row['sno'].' class="edit btn btn-sn btn-primary">Edit</button>
<button id=d'.$row['sno'].' class="delete btn btn-sn btn-primary">Delete</button></td>
</tr>
';
}
?>
</tbody>
</table>
</div>
<hr>
<!-- <script
src="https://code.jquery.com/jquery-3.7.1.min.js"
integrity="sha256-/JqT3SQfawRcv/BIHPThkBvs0OEvtFFmqPF/lYI/Cxo="
crossorigin="anonymous">
</script> -->
<script src="https://code.jquery.com/jquery-3.4.1.slim.min.js" integrity="sha384-J6qa4849blE2+poT4WnyKhv5vZF5SrPo0iEjwBvKU7imGFAV0wwj1yYfoRSJoZ+n" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.4.1/dist/js/bootstrap.min.js" integrity="sha384-wfSDF2E50Y2D1uUdj0O3uMBJnjuUD4Ih7YwaYd1iqfktj0Uod8GCExl3Og8ifwB6" crossorigin="anonymous"></script>
<script src="//cdn.datatables.net/2.0.0/js/dataTables.min.js"></script>
<script>
// $(document).ready( function () {
// $('#myTable').DataTable();
// })
let table = new DataTable('#myTable');
</script>
<script>
edit = document.getElementsByClassName('edit');
Array.from(edit).forEach((element)=>{
element.addEventListener("click", (e)=>{
console.log("edit ", );
tr = e.target.parentNode.parentNode;
name = tr.getElementsByTagName("td")[0].innerText;
title = tr.getElementsByTagName("td")[1].innerText;
desc = tr.getElementsByTagName("td")[2].innerText;
console.log(name, title, desc);
nameEdit.value = name;
titleEdit.value = title;
descEdit.value = desc;
snoEdit.value = e.target.id;
console.log(e.target.id);
$('#editModal').modal('toggle');
})
})
delet = document.getElementsByClassName('delete');
Array.from(delet).forEach((element)=>{
element.addEventListener("click", (e)=>{
console.log("edit ", );
sno = e.target.id.substr(1,)
// tr = e.target.parentNode.parentNode;
// name = tr.getElementsByTagName("td")[0].innerText;
// title = tr.getElementsByTagName("td")[1].innerText;
// desc = tr.getElementsByTagName("td")[2].innerText;
if(confirm("Are you sure you want to delete this data!")){
console.log("yes");
window.location = `?delete=${sno}`;
}
else{
console.log("no");
}
// console.log(name, title, desc);
// nameEdit.value = name;
// titleEdit.value = title;
// descEdit.value = desc;
// snoEdit.value = e.target.id;
// console.log(e.target.id);
// $('#editModal').modal('toggle');
})
})
</script>
</body>
</html>