search filter on fields sa table(php;codeigniter)

[appphys_sa_usc]

---

pls. give some suggestions,,thanks,,=)

[appphys_sa_usc]

especially sa view ug controller nga side,,thanks=)

[ondoy]

e klaro daw bro, mrg mahirap sabton

[sLY26]

define what are your requirements TS, what is the purpose of making this search program? usually you can draw an idea from the table itself.

[emailroy2002]

butangi og

"select * from TABLE_NAME where FIELD_NAME = '$variable' || FIELD_NAME2 = '$variable2' ";

Ingana nga type nga search? ts?


if sa code igniter

kay

$this->db->where('FIELD_NAME', $variable1);
$this->db->where('FIELD_NAME2', $variable2);
$this->db->get('table_name');



or

$this->db->get_where('mytable', array('FIELD_NAME' => $id, 'FIELD_NAME2' => $variable2 ), $limit, $offset);



refer nalang sa active record sa CI ..


Active Record : CodeIgniter User Guide

[appphys_sa_usc]

butangi og

"select * from TABLE_NAME where FIELD_NAME = '$variable' || FIELD_NAME2 = '$variable2' ";

Ingana nga type nga search? ts?


if sa code igniter

kay

$this->db->where('FIELD_NAME', $variable1);
$this->db->where('FIELD_NAME2', $variable2);
$this->db->get('table_name');



or

$this->db->get_where('mytable', array('FIELD_NAME' => $id, 'FIELD_NAME2' => $variable2 ), $limit, $offset);



refer nalang sa active record sa CI ..


Active Record : CodeIgniter User Guide

salamat emailroy,,ok na imung g.ingon pero akong gnhan kay sa view/controller na part,,model mn na imung gbutang,,hehe,,ok rmn ko sa model,,sa view lng sa search/filter bar,,more on php/html,,hehe,,pero salamat,,!