ผมใช้ bootrap แล้วเกิดปัญหาในการเรียกข้อมูลจากdynamic table มาเเสดงในmodalครับ
โดย dynamic table จะถูกเรียกข้อมูลมาเก็บไว้แล้วเเสดงทีละ 10 entrie มีปุ่มให้ next ดูreccord ชุดถัดไปได้ ครับCode Code (PHP) <div class="adv-table editable-table ">
<div class="clearfix">
<div class="btn-group">
<a class="btn btn-compose" data-toggle="modal" href="#myModal">
<i class="icon-plus"></i> AddNew
</a>
<!-- Modal -->
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title">AddNew</h4>
</div>
<div class="modal-body">
<form class="form-horizontal" role="form">
<div class="form-group">
<label class="col-lg-2 control-label">ชื่อบริษัท</label>
<div class="col-lg-10">
<input type="text" class="form-control" id="Txt_Out_Name" placeholder="">
<input type="hidden" id="Txt_Out_ID" >
</div>
</div>
<div class="form-group">
<label class="col-lg-2 control-label">ประเภท</label>
<div class="col-lg-10">
<select id="Cbo_Type" class="Cbo_Type">
<option selected="selected">--Select Type--</option>
<?php
$sql=mysql_query("SELECT * FROM ms_outsource_type order by Out_Type_ID",$con);
while($row = mysql_fetch_array($sql))
{
$Out_Type_ID=$row['Out_Type_ID'];
$Out_Type_Name = $row['Out_Type_Name'];
echo '<option value="'.$Out_Type_ID.'">'.$Out_Type_Name.'</option>';
}
?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-lg-2 control-label">ที่อยู่</label>
<div class="col-lg-10">
<input type="text" class="form-control" id="Txt_Address" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-lg-2 control-label">จังหวัด</label>
<div class="col-lg-10">
<select id="Cbo_PROVINCE" class="Cbo_PROVINCE">
<option selected="selected">--Select PROVINCE--</option>
<?php
$sql=mysql_query("SELECT DISTINCT PROVINCE_ID,PROVINCE_NAME FROM province order by PROVINCE_ID",$con);
while($row = mysql_fetch_array($sql))
{
$PROVINCE_ID=$row['PROVINCE_ID'];
$PROVINCE_NAME = $row['PROVINCE_NAME'];
echo '<option value="'.$PROVINCE_ID.'">'.$PROVINCE_NAME.'</option>';
}
?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-lg-2 control-label">เขต</label>
<div class="col-lg-10">
<select disabled id="Cbo_AMPHUR">
<option selected="selected">--Select AMPHUR--</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-lg-2 control-label">แขวง</label>
<div class="col-lg-10">
<select disabled id="Cbo_DISTRICT">
<option selected="selected">--Select DISTRICT--</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-lg-2 control-label">ภาค</label>
<div class="col-lg-10">
<input type="text" class="form-control" id="Txt_Geo" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-lg-2 control-label">รหัสไปรษณีย์</label>
<div class="col-lg-10">
<input type="text" class="form-control" id="Txt_ZipCode" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-lg-2 control-label">โทรศัพท์</label>
<div class="col-lg-10">
<input type="text" class="form-control" id="Txt_Tel" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-lg-2 control-label">มือถือ</label>
<div class="col-lg-10">
<input type="text" class="form-control" id="Txt_Phone" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-lg-2 control-label">Fax</label>
<div class="col-lg-10">
<input type="text" class="form-control" id="Txt_Fax" placeholder="">
</div>
</div>
<div class="form-group">
<div class="col-lg-offset-2 col-lg-10">
<button type="button" id="BtnAddNew" class="btn btn-send">Save</button>
</div>
</div>
</form>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
</div>
<div class="btn-group pull-right">
<button class="btn dropdown-toggle" data-toggle="dropdown">Tools <i class="icon-angle-down"></i>
</button>
<ul class="dropdown-menu pull-right">
<li><a href="#">Print</a></li>
<li><a href="#">Save as PDF</a></li>
<li><a href="#">Export to Excel</a></li>
</ul>
</div>
</div>
<div class="space15"></div>
<table class="table table-striped table-hover table-bordered" id="editable-sample">
<thead>
<tr>
<th width="351">ชื่อผู้รับเหมา</th>
<th width="115" class="hidden-phone">โทรศัพท์</th>
<th width="109" class="hidden-phone">โทรสาร</th>
<th width="79" class="hidden-phone">ประเภท</th>
<th width="109" class="hidden-phone">ประเภทงาน</th>
<th width="79" class="center hidden-phone">สถานะ</th>
<th width="128" class="hidden-phone">Action</th>
</tr>
</thead>
<tbody>
<?php
$sql=mysql_query("SELECT * FROM outsource order by Out_ID",$con);
while($row = mysql_fetch_array($sql))
{
?>
<tr class="">
<td><a href="data_suboutsource.php" title="ดูรายละเอียดข้อมูล"><?=$row['Out_Name']?></a></td>
<td class="hidden-phone"><?=$row['Tel']?></td>
<td class="hidden-phone"><?=$row['Fax']?></td>
<td class="hidden-phone"><?=$row['Out_Name']?></td>
<td class="hidden-phone"><?=$row['Out_Name']?></td>
<td class="center hidden-phone"><span class="label label-success">Approved</span></td>
<td class="hidden-phone">
<a data-toggle="modal" href="#myModal"><button value="<?=$row['Out_ID']?>" type="button" class="btn btn-primary btn-xs" onClick="javascript:editers();" >Edit</button></a>
<button type="button" class="btn btn-danger btn-xs">Delete</button>
</td>
</tr>
<?
}
?>
</tbody>
</table>
</div>
Code (JavaScript)
jq191('.btn-primary').click(function() {
var bid = jq191(this).attr("value");
alert(bid);
jq191.getJSON("jsondata/selectmsdata.php", {Out_ID: bid}, function(data){
jq191('#Txt_Out_ID').val(data['Out_ID']);
jq191('#Cbo_Type').val(data['Out_Type_ID']);
jq191('#Txt_Out_Name').val(data['Out_Name']);
jq191('#Txt_Address').val(data['Address']);
jq191('#Cbo_PROVINCE').val(data['PROVINCE_ID']);
jq191('#Cbo_AMPHUR').val(data['AMPHUR_ID']);
jq191('#Cbo_DISTRICT').val(data['DISTRICT_ID']);
jq191('#Txt_ZipCode').val(data['Zipcode']);
jq191('#Txt_Tel').val(data['Tel']);
jq191('#Txt_Phone').val(data['Phone']);
jq191('#Txt_Fax').val(data['Fax']);
});
});
Tag PHP, MySQL, HTML/CSS, JavaScript, jQuery, Windows
ประวัติการแก้ไข
Date :
2013-12-06 07:28:06By :
sagonView :
862Reply :
3
ทำ modal ให้ id ไม่ซ้ำกันสิครับ แล้วเอามันไปยัดใส่ function ไว้
Date :
2013-12-06 09:13:18By :
mangkunzo
ขอบคุณ คุณmangkunzo มากครับ
Date :
2013-12-06 21:16:21By :
sagon
ไม่มีท่านอื่นทราบคำตอบเลยรึครับ หรือ ชี้แนะ ว่าควรไปหาข้อมูลที่ไหนได้อะครับ
Date :
2013-12-08 21:13:33By :
sagon
Server 05
Load balance : Server 05
