|
 |
| |
ขอสอบถามการ Insert ข้อมูลของแต่ละRow จากหน้าแสดงรายการข้อมูลค่ะ |
| |
 |
|
|
 |
 |
|
ใช้ Form ครอบแต่ละ <tr> ได้เลยครับ และส่งค่า parameter ไปตามปกติ
|
ประวัติการแก้ไข
2017-05-12 11:25:35
 |
 |
 |
 |
| Date :
2017-05-12 11:24:42 |
By :
dudesaranyu |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ลองทำตามที่แนะนำแล้วค่ะ แต่สามารถ Saveได้ แค่ row สุดท้ายที่ Selectมา แก้ไข row อื่นไม่ได้เลย
จากโค้ดต้องแก้ไขตรงไหนบ้างคะ
Code (PHP)
<?php include 'Connection.php'; ?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
//*** Update Condition ***//
if($_POST["hdnCmd"] == "Save"){
$strSQL = "UPDATE PRICING_HD SET StatusQuotation = '".$_POST["status"]."' WHERE PricingHDID = '".$_POST["pricing_id"]."' AND PricingHDRevision = '".$_POST["pricing_revision"]."' ";
$objQuery = sqlsrv_query($Conn,$strSQL) or die ("Error Update [".$strSQL."]");
} ?>
</head>
<body>
<form name="datalist" id="datalist" method="post" action="<?php echo $_SERVER["PHP_SELF"];?>" >
<input type="hidden" name="hdnCmd" value="">
<table class="display" id="datatable">
<thead>
<tr>
<th style="font-size: 14px; ">No.</th>
<th style="font-size: 14px; ">ID</th>
<th style="font-size: 14px; ">Status</th>
<th style="font-size: 14px; ">Save</th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM PRICING_HD ";
$query = sqlsrv_query($Conn,$sql) or die("error");
$i = 1;
while($row = sqlsrv_fetch_array($query)){
?>
<tr class="odd">
<td align="center" width="30"><font size="2"><?php echo $i ; ?></font></td>
<td align="center" width="80"><font size="2"><?php echo $row["PricingHDID"];?></font>
<input type="hidden" name="pricing_id" id="pricing_id" value="<?php echo $row["PricingHDID"];?>">
<input type="hidden" name="pricing_revision" id="pricing_revision" value="<?php echo $row["PricingHDRevision"];?>">
</td>
<td align="center" width="80">
<select name="status" id="status" style="width:130px;height:25px;float:left;padding:0px 0px 0 0px; background-color:#F4F6F7; border:1px #90A9B7 solid; color:#000;-moz-border-radius:4px;-webkit-border-radius:4px;border-radius:4px;" >
<option value="Draft" <?PHP if($row['StatusQuotation'] == "Draft") { echo "selected='selected'"; } ?>>Draft</option>
<option value="Approve" <?PHP if($row['StatusQuotation'] == "Approve") { echo "selected='selected'"; } ?>>Approve</option>
<option value="Submit to Customer" <?PHP if($row['StatusQuotation'] == "Submit to Customer") { echo "selected='selected'"; } ?>>Submit to Customer</option>
<option value="Final Version" <?PHP if($row['StatusQuotation'] == "Final Version") { echo "selected='selected'"; } ?>>Final Version</option>
</select>
</td>
<td align="center"><input type="image" name="submitStatus" src="images/save.png" alt="" title="Save Status" border="0" width="20" OnClick="datalist.hdnCmd.value='Save';datalist.submit();"/></button></td>
</tr>
<?php $i = $i+1; } ?>
</tbody>
</table>
</form>
</body>
</html>
ขอบคุณค่ะ
|
| |
|
|
| |
| Date :
2017-05-12 14:05:53 |
By :
watanya1951 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
อันนี้ฟอร์มหน้าโชว์ครับ
Code
<script>
$.fn.editable.defaults.mode = 'popup';//inline
$(document).ready(function() {
var currentYear = (new Date).getFullYear();
//alert(currentYear);
$('#dataTables1').dataTable({
responsive: true,
"order": [[ 1, "desc" ]],
"fnRowCallback": function (nRow, aData, iDisplayIndex, iDisplayIndexFull) {
$('#dataTables1 .topic a').editable({
type: 'text',
title: 'แก้ไข-หัวข้อ'
});
}
});
});
</script>
<div class="row">
<div class="col-lg-12">
<div class="row">
<div class="col-lg-12">
<div class="panel panel-default">
<div class="panel-heading"> รายละเอียด</div>
<?php
include("../config/thai_date.php");
include("db_connect.php"); // เรียกใช้งานไฟล์เชื่อมต่อกับฐานข้อมูล
$mysqli = connect(); // เชื่อมต่อกับฐานข้อมูล
$sql="SET CHARACTER SET UTF8";
query($sql);
//$sql="SELECT * FROM DATAW ORDER BY id DESC";
$sql="SELECT * FROM DATAW ORDER BY id DESC LIMIT 120";
$result = $mysqli->query($sql);
?>
<div class="panel-body">
<div class="dataTable_wrapper">
<table width="" class="table table-striped table-bordered table-hover" id="dataTables1">
<thead>
<tr>
<th width="14%">หัวข้อ</th>
</tr>
</thead>
<tbody>
<?php
while($rs=$result->fetch_object()){
?>
<tr>
<td class="topic">
<a href="#" id="topic<?php echo $rs->id ; ?>" data-url="edit-topic.php" data-pk="<?php echo $rs->id ; ?>" data-value="<?php echo $rs->topic; ?>" data-name="topic"><?php echo $rs->topic; ?></a>
</td>
<?php
}
?>
</tbody>
</table>
</div>
</div>
|
| |
|
|
| |
| Date :
2017-05-14 18:39:51 |
By :
HLEW |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 04
|
