model_advance

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 "";
        }
    }