Does anyone see anything wrong with this code?

[jlknauff]

Does anyone see anything wrong with this code?

<?php

    $mysqli = new mysqli("localhost", "db", "pw", "user");
    $query = "SELECT ID FROM wp_posts WHERE post_title = 'some post'";
        $id = mysqli_query($mysqli, $query);
    echo var_dump($id);

?>

It returns:

object(mysqli_result)#2 (0) { }

In this case, the value in the DB is 993 and the field type is bigint

 

[alias420]

That code is returning a result object which still needs to be processed by another function.


PHP: mysqli::query - Manual

PHP: Manual Quick Reference

 

[memaily]

$mysqli = new mysqli("localhost", "db", "pw", "user");
$query = "SELECT ID FROM wp_posts WHERE post_title = 'some post'";
$result = mysqli_query($mysqli, $query);

$row = mysql_fetch_assoc($result);
$id = $row['ID'];

 

[emp]

I see the code highlighting in this forum still need to be tweaked...aaaaaargh.

::emp::