What's new
Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

Php crud help

N

nox101

Amateur
Advanced Member
Messages
123
Reaction score
0
Points
26
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
 
Try mo to sir ....

News.php

1.) Paltan mo yung TABLE mo neto

<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><button data-toggle="modal" data-target="#myModal" data-id="<?php echo $row['ID']; ?>" data-name="<?php echo $row['Name']; ?>" data-position="<?php echo $row['Position']; ?>" data-office="<?php echo $row['Office']; ?>">EDIT RECORD</button></td>
</tr>
<?php } ?>
</tbody>
</table>

2.) Paltan mo naman yung UPDATE MODAL mo neto

<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">
<input type="hidden" class="form-control" id="id" name="id" />
<label>Name</label>  
<input type="text" class="form-control" id="name" name="name" />
<label>Position</label>  
<input type="text" class="form-control" id="position" name="position" />
<label>Office</label>  
<input type="text" class="form-control" id="office" name="office" />
<br>
<div align="right">
<input type="submit" class="btn btn-info" value="UPDATE" name="update">
</div>
</form>
</div>
<div class="modal-footer">
<button class="btn btn-default" type="button" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>

3.) Idagdag mo naman eto after ng declaration mo ng JAVASCRIPT SCRIPT mo ng BOOTSTRAP

<script>
$('#myModal').on('show.bs.modal', function (event) {
var button = $(event.relatedTarget)
$('#myModal #id').val(button.data('id'));
$('#myModal #name').val(button.data('name'));
$('#myModal #position').val(button.data('position'));
$('#myModal #office').val(button.data('office'));
})
</script>


crud.php

1.) Paltan mo yung CODE FOR DATA UPDATE nito

/* code for data update */

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'],$_POST['id']);
$SQL->execute();
header("Location: index.php");
}
/* code for data update */

Feedback na lang kung working. Goodluck :)
 
lars19 said:
Try mo to sir ....

News.php

1.) Paltan mo yung TABLE mo neto

<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><button data-toggle="modal" data-target="#myModal" data-id="<?php echo $row['ID']; ?>" data-name="<?php echo $row['Name']; ?>" data-position="<?php echo $row['Position']; ?>" data-office="<?php echo $row['Office']; ?>">EDIT RECORD</button></td>
</tr>
<?php } ?>
</tbody>
</table>

2.) Paltan mo naman yung UPDATE MODAL mo neto

<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">
<input type="hidden" class="form-control" id="id" name="id" />
<label>Name</label> ?
<input type="text" class="form-control" id="name" name="name" />
<label>Position</label> ?
<input type="text" class="form-control" id="position" name="position" />
<label>Office</label> ?
<input type="text" class="form-control" id="office" name="office" />
<br>
<div align="right">
<input type="submit" class="btn btn-info" value="UPDATE" name="update">
</div>
</form>
</div>
<div class="modal-footer">
<button class="btn btn-default" type="button" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>

3.) Idagdag mo naman eto after ng declaration mo ng JAVASCRIPT SCRIPT mo ng BOOTSTRAP

<script>
$('#myModal').on('show.bs.modal', function (event) {
var button = $(event.relatedTarget)
$('#myModal #id').val(button.data('id'));
$('#myModal #name').val(button.data('name'));
$('#myModal #position').val(button.data('position'));
$('#myModal #office').val(button.data('office'));
})
</script>


crud.php

1.) Paltan mo yung CODE FOR DATA UPDATE nito

/* code for data update */

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'],$_POST['id']);
$SQL->execute();
header("Location: index.php");
}
/* code for data update */

Feedback na lang kung working. Goodluck :)
Click to expand...
Maraming salmat po sir. Nagsisimula palang po kac sa web dev sir. vb.net plng gamay ko.hehe. Maraming salamat sir
 
You must log in or register to reply here.

Similar threads

N
CallBack function in Ajax PHP
Replies
3
Views
423
nebuchadnezar
N
C
Please help PHP not inserting in the database
Replies
4
Views
438
jskhulitz
J
Soichiro Jin
[PHP] Warning: Cannot modify header information - headers
Replies
3
Views
533
laudeniold
laudeniold
God love us
For Excel VBA expert only
Replies
0
Views
605
God love us
God love us
dadadaxtr
Php - bootstrap form validation and submit function help!
Replies
5
Views
650
godwars777
godwars777
Back
Top Bottom