Single Value Mysqli [duplicate]

Question

I am trying to write a function that will check for a single value in the db using mysqli without having to place it in an array. What else can I do besides what I am already doing here?

function getval($query){     $mysqli = new mysqli();     $mysqli->connect(HOST, USER, PASS, DB);     $result = $mysqli->query($query);     $value = $mysqli->fetch_array;     $mysqli->close();     return $value; } 

Answer 1

How about

$name = $mysqli->query("SELECT name FROM contacts WHERE id = 5")->fetch_object()->name;  

Answer 2

The mysql extension could do this using mysql_result, but mysqli has no equivalent function as of today, afaik. It always returns an array.

If I didn't just create the record, I do it this way:

$getID = mysqli_fetch_assoc(mysqli_query($link, "SELECT userID FROM users WHERE something = 'unique'")); $userID = $getID['userID']; 

Or if I did just create the record and the userID column is AI, I do:

$userID = mysqli_insert_id($link);