 |
|
ผมลอง แบ่งหน้า ตามวิดีโอของอาจารย์เนี้ยครับ
แต่อยาก ค้นหน้าข้อมูลแบบแบ่งหน้าอะครับไม่ทราบว่าต้องทำยังไง
อันนี้ส่วนของ controllter ครับ
Code (PHP)
<?php
class Member extends CI_Controller
{
public function __construct()
{
parent::__Construct();
}
public function index()
{
$this->load->library('pagination');
$config['base_url']=base_url()."index.php/member/index";
$config['per_page']=5;
$config['total_rows']=$this->db->count_all("tb_member");
$this->pagination->initialize($config);
$data['rs']=$this->db->select("member_id,member_name,member_tel")
->from("tb_member")->limit($config['per_page'],$this->uri->segment(3))->get()->result_array();
$this->load->view("member/index",$data);
/* โค๊ดเดิม
$this->db->select("member_id,member_name,member_tel");
$this->db->from("tb_member");
$this->db->where($ar);
$rs = $this->db->get();
*/
/*chaining*/
/*$this->db->select("member_id,member_name,member_tel")->from("tb_member")->where($ar);
$rs = $this->db->get();
*/
/*chaining 2
$rs=$this->db->select("member_id,member_name,member_tel")->from("tb_member")->where($ar)->get();
$data['rs'] = $rs->result_array();
*/
/*chaining 3*/
}
public function add()
{
if($this->input->post("btsave")!=null)
{
$ar = array(
"member_name"=>$this->input->post("member_name"),
"member_tel"=>$this->input->post("member_tel"),
"member_address"=>$this->input->post("member_address")
);
$this->db->insert("tb_member",$ar);
redirect("member","refresh");
exit();
}
$this->load->view("member/add");
}
public function edit($member_id)
{
if($this->input->post("btsave")!=null)
{
$ar = array(
"member_name"=>$this->input->post("member_name"),
"member_tel"=>$this->input->post("member_tel"),
"member_address"=>$this->input->post("member_address")
);
$this->db->where("member_id",$member_id);
$this->db->update("tb_member",$ar);
redirect("member","refresh");
exit();
}
$sql = "Select * from tb_member where member_id = '$member_id'";
$rs = $this->db->query($sql);
if($rs->num_rows()==0)
{
$data['rs']=array();
}
else
{
$data['rs']=$rs->row_array();
}
$this->load->view("member/edit",$data);
}
public function del($member_id)
{
$this->db->delete("tb_member",array("member_id" => $member_id));
redirect("member","refresh");
exit();
}
}
?>
อันนี้ส่วน view ครับ
Code (PHP)
<!DOCTYPE HTML>
<head>
<meta charset="utf-8">
<title>MEMBER</title>
</head>
<body>
<h1>แสดงข้อมูล</h1>
<?php echo anchor("member/add","เพิ่มข้อมูล");?>
<table border="1">
<thead>
<tr>
<td>ลำดับ</td>
<td>ชื่อ นามสกุล</td>
<td>เบอร์โทรศัพท์</td>
<td>ปรับแต่ง</td>
</tr>
<tbody>
<?php
if(count($rs)==0)
{
echo "<tr><td colspan='4' aglin='center'> no data </td></tr>";
}
else
{
$no = $this->uri->segment(3)+1;
foreach($rs as $r)
{
echo "<tr>";
echo "<td align='center'> $no</td>";
echo "<td>".$r['member_name']."</td>";
echo "<td>".$r['member_tel']."</td>";
echo "<td align='center'>";
echo anchor("member/edit/".$r['member_id'],"แก้ไข")." ";
echo anchor("member/del/".$r['member_id'],"ลบ",
array("onclick"=>"javascript:return confirm('คุณต้องการลบหรือไม่?');"));
$no++;
echo "</td>";
echo "</tr>";
}
}
?>
</tbody>
</table>
<?php echo $this->pagination->create_links();?>
</body>
</html>
รบกวนด้วยนะครับ
Tag : PHP, CodeIgniter Framework
|
|
|
 |
 |
 |
 |
| Date :
2015-12-03 16:47:58 |
By :
sarun09945282xx |
View :
1776 |
Reply :
3 |
|
 |
 |
 |
 |
|
|
|
|
 |
