Count and Display query

[SkyRanger]

Is it possible to count query rows and display query, tried a number of things but can't get row count:

$rowhsr = $wpdb->get_results( "SELECT * FROM locations where stname like '%" . $houseaddy ."%'");
       
       $hauntcount = $rowhsr->num_rows;
       echo 'Number of entries found:' . $hauntcount;
      
       foreach ( $rowhsr as $rowhsr )

         { echo $rowhsr->stname } 

[Ch0cu3r]

Thar wordpress query function returns the results in an array. So you can use count

 echo 'Number of entries found:' . count($hauntcount);

[SkyRanger]

Thanks Ch0cu3r but not sure what the issue is:

 

When somebody puts in for example: My Address

 

In the database is 123 My Address Street

 

houseaddy = My Address

stname = 123 My Address Street

 

count is coming up = 0

[Barand]

Try doing

var_dump($housedddy);

to see if its size and content are as expected

[SkyRanger]

This is the result   string(17) "my address"   which is what was searched for and the proper information is displayed from the search

Edited July 19, 2015 by SkyRanger

[Barand]

There would appear to 10 printable and 7 non-printable characters in that string

[SkyRanger]

Tried another search and got same result

 

string(17) "121 mount whatley"

[ginerjm]

No. You got a better result. This time you show a string that apparently contains 17 printable chars, as the var_dump told you. As Barand pointed out, your previous test showed only 10 printable (visible) chars, yet var_dump said there were 17 actual chars in the content.

 

So - why are you getting non-printable chars in your input?

[SkyRanger]

ok, got a new error:

Notice: Trying to get property of non-object in \www\wp-content\plugins\addysearch\index.php on line 101
string(12) "815 pembroke" We found 0 results.

Line 100: $rowhsr = $wpdb->get_results( "SELECT * FROM locations where stname like '%" . $houseaddy ."%'");

Line 101: $hauntcount = $rowhsr->num_rows;


Line 102:  var_dump($houseaddy);

[ginerjm]

Sounds like your query failed to produce the resulting object you expect. Why do the dump before you run the query?

[SkyRanger]

trying to see what the result is

[ginerjm]

I meant 'why NOT do the dump before the query'.

[SkyRanger]

doesn't matter if it is before or after the query, still getting the same result

[ginerjm]

And is it WHAT YOU EXPECT TO SEE? Might be nice to let us know what you are getting if you want us to continue to help you.

 

Show us your current code and what you are getting for output please. Please read this last twice so that you can be sure to give me the help I am asking for.

[SkyRanger]

stupid me figured out the problem.  I had count($hauntcount) when it was suppose to be count($rowhsr)