Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function cari_by_judul_db1($judul, $offset, $per_page) {
- $q = $this->db1->query("
- SELECT * FROM jurnal
- inner join
- relationship ON jurnal.jurnal_id = relationship.jurnal_id
- inner join
- kategori ON relationship.cat_id = kategori.cat_id
- inner join
- institusi ON jurnal.institusi_id = institusi.institusi_id
- inner join
- penulis ON institusi.institusi_id = penulis.institusi_id
- WHERE
- jurnal.jurnal_name LIKE '%$judul%'
- LIMIT $offset,$per_page");
- if ($q && $q->num_rows()) {
- return $q->result();
- } else {
- return "";
- }
- }
- function cari_by_judul_db2($judul, $offset, $per_page) {
- $q = $this->db2->query("
- SELECT * FROM jurnal
- inner join
- relationship ON jurnal.jurnal_id = relationship.jurnal_id
- inner join
- kategori ON relationship.cat_id = kategori.cat_id
- inner join
- institusi ON jurnal.institusi_id = institusi.institusi_id
- inner join
- penulis ON institusi.institusi_id = penulis.institusi_id
- WHERE
- jurnal.jurnal_name LIKE '%$judul%'
- LIMIT $offset,$per_page");
- if ($q && $q->num_rows()) {
- return $q->result();
- } else {
- return "";
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement