how to check wordpress custom table is empty or not

Question

This question about wordpress cutom table.. I am creating a plugin I want to check a table named wp_school_post table empty or not.

See my code below which throws the following error

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\getwp\wp-content\plugins\getwp_P\schools_post_function.php on line 7

**filled**

My code:

function schools_post_function()
{
//  echo "Sachool POST function";
    global $wpdb;
    $result = $wpdb->get_results("SELECT postid from wp_school_post WHERE `postid` IS NOT NULL");
    if(mysql_num_rows($result=='0'))
    {
        echo "not filled";
    }
    else
    {
        echo "filled";

    }
}

@Shell please read the questions code before mark as duplicate thank you — Savan Paun, Sep 18 '14 at 11:40
Agree with you why stackoverflows other user direct mark as duplicate without read does they have answer ? — vivek, Sep 18 '14 at 11:41
#Gerald Schneider tell me how this question duplicate ? this is wp question not mysql question — Savan Paun, Sep 18 '14 at 11:48

score 8 · Accepted Answer · answered Sep 18 '14 at 06:40

8

Try this :)

<?php
function schools_post_function()
{
    global $wpdb;
    $result = $wpdb->get_results("SELECT postid from wp_school_post WHERE `postid` IS NOT NULL");
    if(count($result) == 0)
    {
        echo "not filled";
    }
    else
    {
        echo "filled";

    }
}
?>

answered Sep 18 '14 at 06:40

vivek

316
1
4
15

1

_Try this_ answers are low-value here. Please explain all answers that you post. – mickmackusa Mar 09 '19 at 12:38

score 3 · Answer 2 · answered Sep 18 '14 at 06:39

3

You could simplify your code and save resources using get_var instead to obtain the row count:

$count = $wpdb->get_var("SELECT COUNT(*)
    FROM {$wpdb->prefix}school_post WHERE postid IS NOT NULL");

if($count == 0)
{
    // No rows.
}

answered Sep 18 '14 at 06:39

Marty

39,033
19
93
162

score 1 · Answer 3 · answered Sep 18 '14 at 06:36

1

Using wordpress's WPDB class get_results() method will give you the data in form of object/array, you just need to check the count for $result which holds the result from get_results()

if(count($result) == 0){
// your code
}

See WPDB usage details

answered Sep 18 '14 at 06:36

M Khalid Junaid

63,861
10
90
118

how to check wordpress custom table is empty or not

3 Answers3

Linked

Related