Problem with get single value from db mysql

Question

I've a problem with get a single value from mysql and variable assignment. var_dump($val) looks ok:

object(stdClass)#5 (1) { ["min(ID_plants)"]=> string(1) "1" }

And i need this "1" assign to variable.

$first= "SELECT min(ID_plants) from Plants";
if (mysqli_query($link,$first)){
    $res = mysqli_query($link,$first);
    $val = mysqli_fetch_object($res);
}
//var_dump($val);
//$first_index$=($val->MIN(ID_plants));

use alias to fetch min(ID_plants), that would might help. Like this $first= "SELECT min(ID_plants) as minid from Plants"; /** rest of the code */ $first_index = $val->minid; echo $first_index; — Danish Hakim Khan
– Danish Hakim Khan, Commented Sep 4, 2019 at 8:12

ScaisEdge · Accepted Answer · 2019-09-04 08:13:07Z

2

you should use an alias for min(ID_plants)

$first= "SELECT min(ID_plants) my_min_id from Plants";
 if (mysqli_query($link,$first)){
     $res = mysqli_query($link,$first);
     $val = mysqli_fetch_object($res);
 }
 //var_dump($val);
 $first_index$=($val->my_min_id);

answered Sep 4, 2019 at 8:13

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rakesh Jakhar · Accepted Answer · 2019-09-04 08:14:26Z

0

You should use prepared statement instead of mysqli.

Change your query to

 SELECT min(ID_plants) As minPlants from Plants // Alias

After $val = mysqli_fetch_object($res); you can get the value by using $val->minPlants

answered Sep 4, 2019 at 8:14

Rakesh Jakhar

6,4082 gold badges13 silver badges20 bronze badges

Collectives™ on Stack Overflow

Problem with get single value from db mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related