Mga kasymbianize ok nmn po sa insert at view record. ang problema ko ay edit record po
using modal ng bootstrap
Ito po code ko sa bootstrap add,edit
<?php
/* code for connection and database selection */
$server = "localhost";
$user = "root";
$pass = "admin";
$dbname = "phpcrud";
$dbcon = new MySQLi("$server","$user","$pass","$dbname");
if($dbcon->connect_error)
{
echo "ERROR -> ".$dbcon->connect_error;
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Municipality</title>
<link rel="stylesheet" href="assets/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Cookie">
<link rel="stylesheet" href="assets/fonts/font-awesome.min.css">
<link rel="stylesheet" href="assets/css/styles.css">
<link rel="stylesheet" href="assets/css/Pretty-Footer.css">
</head>
<body>
<nav class="navbar navbar-default">
<div class="container-fluid">
<div class="navbar-header"><a class="navbar-brand navbar-link" href="#"><strong>MUNICIPALITY OF BANGUED</strong></a>
<button class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navcol-1"><span class="sr-only">Toggle navigation</span><span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span></button>
</div>
<div class="collapse navbar-collapse" id="navcol-1">
<ul class="nav navbar-nav navbar-right">
<li role="presentation"><a href="index.php">HOME </a></li>
<li class="active" role="presentation"><a href="News.php">EMPLOYEE </a></li>
<li role="presentation"><a href="History.php">HISTORY </a></li>
<li role="presentation"><a href="#">CONTACT US</a></li>
</ul>
</div>
</div>
</nav>
<div class="container">
<h1 class="text-center">EMPLOYEES</h1>
<div class="table-responsive">
<table class="table">
<thead>
<tr>
<th>ID </th>
<th>NAME </th>
<th>POSITION </th>
<th>OFFICE </th>
<th>ACTION </th>
</tr>
</thead>
<tbody>
<?php
$sql="SELECT *FROM tbl_employee";
$result=mysqli_query($dbcon,$sql);
while ($row=mysqli_fetch_array($result)){
?>
<tr>
<td><?php echo $row['ID']; ?></td>
<td><?php echo $row['Name']; ?></td>
<td><?php echo $row['Position']; ?></td>
<td><?php echo $row['Office']; ?></td>
<td> <a href="?edit=<?php echo $row['ID']; ?>" data-toggle="modal" data-target="#myModal">EDIT RECORD</a></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
<div class="container">
<button class="btn btn-default" type="button" data-toggle="modal" data-target="#myModal2">ADD RECORD</button>
<div class="modal fade" role="dialog" tabindex="-1" id="myModal2">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title">ADD NEW RECORD</h4></div>
<div class="modal-body">
<p align="Center">Registration Form</p>
<form action="crud.php" method="Post">
<label>Name</label>
<input type="text" class="form-control" id="name" name="name" required>
<label>Position</label>
<input type="text" class="form-control" id="position" name="position" required>
<label>Office</label>
<input type="text" class="form-control" id="office" name="office" required><br>
<div align="right">
<input type="submit" class="btn btn-info" value="save" name="save">
</div>
</form>
</div>
<div class="modal-footer">
<button class="btn btn-default" type="button" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
</div>
<div class="container">
<div class="modal fade" role="dialog" tabindex="-1" id="myModal">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title">UPDATE RECORD</h4></div>
<div class="modal-body">
<p align="Center">Update Form</p>
<form action="crud.php" method="Post">
<label>Name</label>
<input type="text" class="form-control" id="name" name="name" value="<?php if(isset($_GET['edit'])) echo $getROW['Name']; ?>" />
<label>Position</label>
<input type="text" class="form-control" id="position" name="position" value="<?php if(isset($_GET['edit'])) echo $getROW['Position']; ?>" />
<label>Office</label>
<input type="text" class="form-control" id="office" name="office" value="<?php if(isset($_GET['edit'])) echo $getROW['Office']; ?>" />
<br>
<div align="right">
<input type="submit" class="btn btn-info" value="UPDATE" name="edit">
</div>
</form>
</div>
<div class="modal-footer">
<button class="btn btn-default" type="button" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
</div>
<footer>
<footer>
<div class="row">
<div class="col-md-4 col-sm-6 footer-navigation">
<h3><a href="#">BANGUED ABRA</a></h3>
<p class="company-name">MunicipalityofBangued© 2017 </p>
</div>
<div class="col-md-4 col-sm-6 footer-contacts">
<div><span class="fa fa-map-marker footer-contacts-icon"> </span>
<p><span class="new-line-span">Zone 5, Banued Abra</span> Republic of Philippines</p>
</div>
<div><i class="fa fa-phone footer-contacts-icon"></i>
<p class="footer-center-info email text-left"> +1 555 123456</p>
</div>
<div><i class="fa fa-envelope footer-contacts-icon"></i>
<p> <a href="#" target="_blank">[email protected]</a></p>
</div>
</div>
<div class="clearfix visible-sm-block"></div>
<div class="col-md-4 footer-about">
<h4>Contact us</h4>
<div class="social-links social-icons"><a href="#"><i class="fa fa-facebook"></i></a><a href="#"><i class="fa fa-twitter"></i></a><a href="#"><i class="fa fa-linkedin"></i></a><a href="#"><i class="fa fa-github"></i></a></div>
</div>
</div>
</footer>
</footer>
<script src="assets/js/jquery.min.js"></script>
<script src="assets/bootstrap/js/bootstrap.min.js"></script>
</body>
</html>
Ito nmn po code ko sa php:
<?php
$server = "localhost";
$user = "root";
$pass = "admin";
$dbname = "phpcrud";
$dbcon = new MySQLi("$server","$user","$pass","$dbname");
if($dbcon->connect_error)
{
echo "ERROR -> ".$dbcon->connect_error;
}
/*save */
if(isset($_POST['save']))
{
$fn = $dbcon->real_escape_string($_POST['name']);
$ln = $dbcon->real_escape_string($_POST['position']);
$sn = $dbcon->real_escape_string($_POST['office']);
$SQL = $dbcon->prepare("INSERT INTO tbl_employee (Name,Position,Office) VALUES(?,?,?)");
$SQL->bind_param("sss",$fn,$ln,$sn);
$SQL->execute();
//command
if ($SQL){
header('Location:news.php');
die();
}
else{
echo $MySQLiconn->error;
die();
}
}
/* code for data update */
if(isset($_GET['edit']))
{
$SQL = $dbcon->query("SELECT * FROM tbl_employee WHERE ID=".$_GET['edit']);
$getROW = $SQL->fetch_array();
}
if(isset($_POST['update']))
{
$SQL = $dbcon->prepare("UPDATE tbl_employee SET Name=?, Position=?, Office=? WHERE ID=?");
$SQL->bind_param("sssi",$_POST['name'],$_POST['position'],$_POST['office'],$_GET['edit']);
$SQL->execute();
header("Location: news.php");
}
/* code for data update */
?>
Pahelp nmn po sa code ng edit sir na pag click ay lalabas si modal at dun na pwede edit at update record. salamat po
using modal ng bootstrap
Ito po code ko sa bootstrap add,edit
<?php
/* code for connection and database selection */
$server = "localhost";
$user = "root";
$pass = "admin";
$dbname = "phpcrud";
$dbcon = new MySQLi("$server","$user","$pass","$dbname");
if($dbcon->connect_error)
{
echo "ERROR -> ".$dbcon->connect_error;
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Municipality</title>
<link rel="stylesheet" href="assets/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Cookie">
<link rel="stylesheet" href="assets/fonts/font-awesome.min.css">
<link rel="stylesheet" href="assets/css/styles.css">
<link rel="stylesheet" href="assets/css/Pretty-Footer.css">
</head>
<body>
<nav class="navbar navbar-default">
<div class="container-fluid">
<div class="navbar-header"><a class="navbar-brand navbar-link" href="#"><strong>MUNICIPALITY OF BANGUED</strong></a>
<button class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navcol-1"><span class="sr-only">Toggle navigation</span><span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span></button>
</div>
<div class="collapse navbar-collapse" id="navcol-1">
<ul class="nav navbar-nav navbar-right">
<li role="presentation"><a href="index.php">HOME </a></li>
<li class="active" role="presentation"><a href="News.php">EMPLOYEE </a></li>
<li role="presentation"><a href="History.php">HISTORY </a></li>
<li role="presentation"><a href="#">CONTACT US</a></li>
</ul>
</div>
</div>
</nav>
<div class="container">
<h1 class="text-center">EMPLOYEES</h1>
<div class="table-responsive">
<table class="table">
<thead>
<tr>
<th>ID </th>
<th>NAME </th>
<th>POSITION </th>
<th>OFFICE </th>
<th>ACTION </th>
</tr>
</thead>
<tbody>
<?php
$sql="SELECT *FROM tbl_employee";
$result=mysqli_query($dbcon,$sql);
while ($row=mysqli_fetch_array($result)){
?>
<tr>
<td><?php echo $row['ID']; ?></td>
<td><?php echo $row['Name']; ?></td>
<td><?php echo $row['Position']; ?></td>
<td><?php echo $row['Office']; ?></td>
<td> <a href="?edit=<?php echo $row['ID']; ?>" data-toggle="modal" data-target="#myModal">EDIT RECORD</a></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
<div class="container">
<button class="btn btn-default" type="button" data-toggle="modal" data-target="#myModal2">ADD RECORD</button>
<div class="modal fade" role="dialog" tabindex="-1" id="myModal2">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title">ADD NEW RECORD</h4></div>
<div class="modal-body">
<p align="Center">Registration Form</p>
<form action="crud.php" method="Post">
<label>Name</label>
<input type="text" class="form-control" id="name" name="name" required>
<label>Position</label>
<input type="text" class="form-control" id="position" name="position" required>
<label>Office</label>
<input type="text" class="form-control" id="office" name="office" required><br>
<div align="right">
<input type="submit" class="btn btn-info" value="save" name="save">
</div>
</form>
</div>
<div class="modal-footer">
<button class="btn btn-default" type="button" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
</div>
<div class="container">
<div class="modal fade" role="dialog" tabindex="-1" id="myModal">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title">UPDATE RECORD</h4></div>
<div class="modal-body">
<p align="Center">Update Form</p>
<form action="crud.php" method="Post">
<label>Name</label>
<input type="text" class="form-control" id="name" name="name" value="<?php if(isset($_GET['edit'])) echo $getROW['Name']; ?>" />
<label>Position</label>
<input type="text" class="form-control" id="position" name="position" value="<?php if(isset($_GET['edit'])) echo $getROW['Position']; ?>" />
<label>Office</label>
<input type="text" class="form-control" id="office" name="office" value="<?php if(isset($_GET['edit'])) echo $getROW['Office']; ?>" />
<br>
<div align="right">
<input type="submit" class="btn btn-info" value="UPDATE" name="edit">
</div>
</form>
</div>
<div class="modal-footer">
<button class="btn btn-default" type="button" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
</div>
<footer>
<footer>
<div class="row">
<div class="col-md-4 col-sm-6 footer-navigation">
<h3><a href="#">BANGUED ABRA</a></h3>
<p class="company-name">MunicipalityofBangued© 2017 </p>
</div>
<div class="col-md-4 col-sm-6 footer-contacts">
<div><span class="fa fa-map-marker footer-contacts-icon"> </span>
<p><span class="new-line-span">Zone 5, Banued Abra</span> Republic of Philippines</p>
</div>
<div><i class="fa fa-phone footer-contacts-icon"></i>
<p class="footer-center-info email text-left"> +1 555 123456</p>
</div>
<div><i class="fa fa-envelope footer-contacts-icon"></i>
<p> <a href="#" target="_blank">[email protected]</a></p>
</div>
</div>
<div class="clearfix visible-sm-block"></div>
<div class="col-md-4 footer-about">
<h4>Contact us</h4>
<div class="social-links social-icons"><a href="#"><i class="fa fa-facebook"></i></a><a href="#"><i class="fa fa-twitter"></i></a><a href="#"><i class="fa fa-linkedin"></i></a><a href="#"><i class="fa fa-github"></i></a></div>
</div>
</div>
</footer>
</footer>
<script src="assets/js/jquery.min.js"></script>
<script src="assets/bootstrap/js/bootstrap.min.js"></script>
</body>
</html>
Ito nmn po code ko sa php:
<?php
$server = "localhost";
$user = "root";
$pass = "admin";
$dbname = "phpcrud";
$dbcon = new MySQLi("$server","$user","$pass","$dbname");
if($dbcon->connect_error)
{
echo "ERROR -> ".$dbcon->connect_error;
}
/*save */
if(isset($_POST['save']))
{
$fn = $dbcon->real_escape_string($_POST['name']);
$ln = $dbcon->real_escape_string($_POST['position']);
$sn = $dbcon->real_escape_string($_POST['office']);
$SQL = $dbcon->prepare("INSERT INTO tbl_employee (Name,Position,Office) VALUES(?,?,?)");
$SQL->bind_param("sss",$fn,$ln,$sn);
$SQL->execute();
//command
if ($SQL){
header('Location:news.php');
die();
}
else{
echo $MySQLiconn->error;
die();
}
}
/* code for data update */
if(isset($_GET['edit']))
{
$SQL = $dbcon->query("SELECT * FROM tbl_employee WHERE ID=".$_GET['edit']);
$getROW = $SQL->fetch_array();
}
if(isset($_POST['update']))
{
$SQL = $dbcon->prepare("UPDATE tbl_employee SET Name=?, Position=?, Office=? WHERE ID=?");
$SQL->bind_param("sssi",$_POST['name'],$_POST['position'],$_POST['office'],$_GET['edit']);
$SQL->execute();
header("Location: news.php");
}
/* code for data update */
?>
Pahelp nmn po sa code ng edit sir na pag click ay lalabas si modal at dun na pwede edit at update record. salamat po