mysqli - How to get a single value from a query result in php -

i trying single value db single query. mean featched values in 1 query need 1 column value.

$connection = mysqli_connect($servername, $username, $password, $dbname);             $query = mysqli_query( $connection,"select * register password='$log_in_password' , username='$log_in_username'");             var_dump($query);             $table = mysqli_fetch_all($query,mysqli_assoc);             var_dump($table); 

assume columns ' userid useremail username password name '

from php var_dump($query) gives this..

object(mysqli_result)[2]   public 'current_field' => null   public 'field_count' => null   public 'lengths' => null   public 'num_rows' => null   public 'type' => null 

var_dump($table) gives this

 array (size=1)   0 =>      array (size=5)       'userid' => string '7' (length=1)       'useremail' => string 'demo@gmail.com' (length=16)       'username' => string 'demousername' (length=7)       'password' => string 'demopassword' (length=5)       'name' => string 'demoname' (length=6) 

so me out fetching 1 column value's record (example insselect * select userid)

your variable $table array, if want userid, have use

$table[0]['userid'] 

if want query userid change query :

$query = mysqli_query( $connection,"select userid register password='$log_in_password' , username='$log_in_username'"); $table = mysqli_fetch_all($query,mysqli_assoc); 

and result of $table :

array (size=1)   0 =>      array (size=1)       'userid' => string '7' (length=1) 

$table array, , acces userid have use again

$table[0]['userid']