Hello,
Total row(s) without search and Total row(s) of search
$total_rows = ceil(
intval(
current(
$this->db_connection->query("
SELECT COUNT(*) FROM zamanlanmisgorev.id,
zamanlanmisgorev.dosya_adi,
zamanlanmisgorev.gorev_adi,
zamanlanmisgorev.secilidb,
databaseregister.database_name,
databaseregister.database_id
FROM zamanlanmisgorev
INNER JOIN databaseregister ON zamanlanmisgorev.secilidb = databaseregister.database_id
WHERE zamanlanmisgorev.dosya_adi LIKE '%".$search_post."%' OR zamanlanmisgorev.gorev_adi LIKE '%".$search_post."%' OR zamanlanmisgorev.secilidb LIKE '%".$search_post."%'")->fetch_row()
)
)
);
1st. Table Name: zamanlanmisgorev
+--------------+--------------+----------+
|-dosya_adi- |-gorev_adi | secilidb |
+--------------+--------------+----------+
|aaaaaaaaa | bbbbbbbb |----5------|
+--------------+-------------+-----------+
2nd. Table Name: databaseregister
+---------------+--------------------+
|database_id |database_name |
+--------------+---------------------+
|-------5------ |------adem--------- |
+--------------+---------------------+
Can you help me?
Thank you in advance