Fetching values from database and storing in variable

Question

I want to get database column values in some variable. I dont want to use

mysql_fetch_assoc
mysql_fetch_row
mysql_fetch_array
mysql_fetch_object

anyone of this.

My table is:

+----------+-----------+
| ind_type | Index_val |
+----------+-----------+
| pcount   |       157 |
| ncount   |       210 |
+----------+-----------+

I want to get 157, 210 in some variable $x and $y. I am working in PHP. Can some one guide me.?

One can do $p= $mysqli->query('SELECT Index_val FROM view_name where ind_type=pcount'); and then iterate through all rows to fetch all values.

But I have only two rows and for my need I want to manually fetch the values of Index_val. IF someone can sort it out!

@Mihai: column could not be fetched. But elements could be with similar query I mentioned. But I dont know currect syntax. — user123
– user123, Commented Sep 30, 2013 at 16:26
@Mihai: In mysql select * from view_name where ind_type='pcount'; gives me 157. Same thing I wanted in php and store in some variable. Your reputation does not owe this sort of description! — user123
– user123, Commented Sep 30, 2013 at 16:35
So what prevents you from using mysql assoc and do $variable=$row['pcount'] and in your query you use WHERE column='value' or LIMIT 1 or instead of while do if? — Mihai
– Mihai, Commented Sep 30, 2013 at 16:38
Just a reminder, you should never use mysqli_* as it is outdated (and scheduled for removal in PHP6 I believe). — Benedict Lewis
– Benedict Lewis, Commented Sep 30, 2013 at 16:49

echo_Me · Accepted Answer · 2013-09-30 19:42:00Z

1

what about this ?

if ($p = $mysqli->prepare("SELECT max(CASE when ind_type= 'pcount' then Index_val end) as x , 
                                  max(CASE when ind_type= 'ncount' then Index_val end) as y
   FROM view_name ")){

    $p->execute(); 
    $p->store_result();
    $p->bind_result($x , $y);
    $p->fetch() ;
     }
    echo $x ."<br />". $y ;

where ind_type=pcount then in your table will get only 157 is it only matched value.

EDIT:

for both values . either you dont need a condition , fetch all or make an OR condition.

if ($p = $mysqli->prepare("SELECT Index_val FROM view_name where ind_type= ? OR ind_type= ? ")){
 $p->bind_param('ii', 'pcount' , 'ncount');

edited Sep 30, 2013 at 19:42

answered Sep 30, 2013 at 16:53

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

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

7 Comments

user123 Over a year ago

thanks a lot. Anyways for both pcount and ncount in my table $mysqli->prepare("SELECT Index_val FROM view_name where ind_type= ? ?") or what?

user123 Over a year ago

And also you recommended not to use mysqli-> that what is it's alternative? even you also have used it. Just for my info

echo_Me Over a year ago

for both values . either you dont need a condition , fetch all or make an OR condition like that where ind_type= ? OR where ind_type= ?

user123 Over a year ago

thanks a lot. And binding should be done like this $p->bind_result($Index_val1,$Index_val2); for both values right?

echo_Me Over a year ago

with that variable you can do what you like with it. to filter which value u need.

|

Collectives™ on Stack Overflow

Fetching values from database and storing in variable

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related