 |
|
อ๋อเข้าใจละครับ สงสัยผมจะเขียนยากเอง
ดู code ผมนะ
เริ่มจากผมเรียกฟังชั่นนี้
Code (PHP)
function select_sizing()
{
//$this->checklogin->check();
$this->db->select('c.size_id,c.name,c.position,c.business_unit,u.reference_number,
i.d1,i.d2,i.d3,i.d4,i.d5,i.d6,i.d7,i.d8,i.d9,i.d10,
t.d1 as t1,t.d2 as t2,t.d3 as t3,t.d4 as t4,t.d5 as t5,
t.d6 as t6,t.d7 as t7,t.d8 as t8,t.d9 as t9,t.d10 as t10');
$this->db->from('size_chart_use u');
$this->db->join('size_chart c', 'u.`size_id`=c.`size_id`');
$this->db->join('size_chart_item i', 'i.`size_id`=c.`size_id`');
$this->db->join('size_chart_titel t', 't.`size_id`=c.`size_id`');
$this->db->where('u.reference_number', 'A3D/103L');
$query = $this->db->get();
$data['QrySiZing'] =$query;
$this->load->view('frmOrderFormSelectSizing.php',$data);
}
เสร็จแล้วมันก็ส่งข้อมูลมาฟอร์มนี้
Code (PHP)
<table width="778" border="0" cellspacing="1" cellpadding="1" bgcolor="#CCCCCC">
<? foreach ($QrySiZing->result_array() as $row){?>
<tr bgcolor="#FFFFFF">
<td colspan="10"><? echo 'Size name : '.$row['name'];?> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td><? echo $row['t1'];?> </td>
<td><? echo $row['t2'];?> </td>
<td><? echo $row['t3'];?> </td>
<td><? echo $row['t4'];?> </td>
<td><? echo $row['t5'];?> </td>
<td><? echo $row['t6'];?> </td>
<td><? echo $row['t7'];?> </td>
<td><? echo $row['t8'];?> </td>
<td><? echo $row['t9'];?> </td>
<td><? echo $row['t10'];?> </td>
</tr>
<tr onMouseOver="className="over""
onMouseOut="className="tr_even"" bgcolor="#FFFFFF">
<td><? echo $row['d1'];?></td>
<td><? echo $row['d2'];?></td>
<td><? echo $row['d3'];?></td>
<td><? echo $row['d4'];?></td>
<td><? echo $row['d5'];?></td>
<td><? echo $row['d6'];?></td>
<td><? echo $row['d7'];?></td>
<td><? echo $row['d8'];?></td>
<td><? echo $row['d9'];?></td>
<td><? echo $row['d10'];?></td>
</tr>
<? }?>
</table>
ยังไงก็ขอบคุณครับ ปล.สำหรับผมแล้วผมคิดว่าทุกคนในนี้คือ เทพๆ กันทั้งนั้น
|
 |
 |
 |
 |
Date :
2012-02-27 11:28:57 |
By :
suaingam |
|
 |
 |
 |
 |
|
|
 |