Jinsi ya Kuhakiki Posts Kwenye MySQL Database

Kama posts kwenye website yako zinaonekana kupungua, hatua ya kwanza ni kuhakiki moja kwa moja kwenye MySQL database. Hii itakusaidia kutofautisha kati ya posts zilizofutwa na posts ambazo zimefichwa na pagination, search au category filter.

Hatua ya Kwanza: Fungua phpMyAdmin

Ingia kwenye hosting panel yako, kisha:

1. Fungua phpMyAdmin.
2. Chagua database ya website yako.
3. Bonyeza sehemu ya SQL.
4. Bandika query unayotaka kutekeleza.
5. Bonyeza Go.

Kuhesabu Posts Zote

Tumia query hii:

SELECT COUNT(*) AS total_posts
FROM posts;

Matokeo yataonyesha jumla halisi ya posts zilizohifadhiwa kwenye table ya posts.

Mfano:

total_posts: 150

Refresh website, kisha tekeleza query tena. Ikiwa namba bado ni 150, posts hazijafutwa—page inaonyesha chache kwa sababu ya pagination au filter.

Kuangalia Post ID ya Kwanza na ya Mwisho

SELECT
    COUNT(*) AS total_posts,
    MIN(id) AS first_post_id,
    MAX(id) AS last_post_id
FROM posts;

Query hii inaonyesha:

• Jumla ya posts.
• ID ya post ya kwanza.
• ID ya post ya mwisho.

Kumbuka kuwa MAX(id) si lazima ilingane na jumla ya posts. IDs zinaweza kuwa na mapengo kama post iliwahi kufutwa.

Kuonyesha Posts za Mwisho

SELECT id, title, user_id, created_at
FROM posts
ORDER BY id DESC
LIMIT 50;

Hii inaonyesha posts 50 za mwisho pamoja na:

• Post ID.
• Kichwa cha post.
• User aliyechapisha.
• Tarehe ya kuchapishwa.

Kutafuta Post kwa Kichwa

SELECT id, title, created_at
FROM posts
WHERE title LIKE '%PHP%';

Badilisha PHP na neno lililopo kwenye title unayotafuta.

Mfano:

SELECT id, title, created_at
FROM posts
WHERE title LIKE '%Database%';

Kukagua Posts Zenye user_id Tupu

SELECT COUNT(*) AS posts_without_user
FROM posts
WHERE user_id IS NULL;

Kuonyesha posts hizo:

SELECT id, title, created_at
FROM posts
WHERE user_id IS NULL
ORDER BY id DESC;

Post yenye user_id ya NULL haimaanishi imeharibika. Inaweza kuwa post iliyochapishwa na mfumo ambao haukuhifadhi user ID.

Kukagua Posts kwa Kila User

SELECT
    user_id,
    COUNT(*) AS total_posts
FROM posts
GROUP BY user_id
ORDER BY total_posts DESC;

Hii inakusaidia kujua posts ngapi zinahusishwa na kila user.

Kulinganisha Idadi Kabla na Baada ya Refresh

Tekeleza:

SELECT COUNT(*) AS total_before_refresh
FROM posts;

Andika matokeo, kisha refresh page ya website. Baada ya refresh, tekeleza:

SELECT COUNT(*) AS total_after_refresh
FROM posts;

Ikiwa namba imepungua, posts zinafutwa kweli. Chunguza:

SHOW TRIGGERS;
SHOW EVENTS;

Pia tafuta kwenye PHP code:

DELETE FROM posts

TRUNCATE TABLE posts

DELETE FROM users

Kukagua Table Sahihi

Database inaweza kuwa na table zaidi ya moja ya posts. Tumia:

SHOW TABLES LIKE '%post%';

Baada ya hapo, hakikisha PHP code yako na phpMyAdmin vinatumia table ileile.

Tengeneza Backup

Kabla ya kubadilisha database:

1. Fungua Export kwenye phpMyAdmin.
2. Chagua Custom.
3. Chagua Structure and data.
4. Chagua format ya SQL.
5. Pakua backup.

Hitimisho

Njia sahihi ya kujua kama posts zimefutwa ni kutumia SELECT COUNT(*) FROM posts. Usihesabu cards zinazoonekana kwenye page pekee, kwa sababu pagination, featured post, search na category filter zinaweza kuonyesha posts chache bila kufuta records kwenye database.