How to put database value in array

Question

I want something like this?

$sql = mysql_query("SELECT lid, ip FROM lua where uid='$uid'"); 
$rows = mysql_fetch_array($sql);
$ip = $rows['ip'];
$res = array('value 1 of $ip from datebase','value 2 of $ip from datebase','value 3 of $ip        from datebase.......');
?>

Is it possible? help related this...thnxx..

Yes. Learn programming and then use a loop structure, such as `while()` which is already suggested in the manual on [`mysql_fetch_array()`](http://www.php.net/mysql_fetch_array) — kero, Feb 25 '14 at 17:00

score 1 · Answer 1 · edited May 23 '17 at 12:20

1

$arr = array();
while ($rows = mysql_fetch_array($sql)) {
    array_push($arr,$rows['ip']); // and so on if you willing other values to be in your array
}
var_dump($arr); // test your array

NOTE: Though it's deprecated to use mysql, use mysqli or pdo extensions instead. See this post about this issue

edited May 23 '17 at 12:20

Community

1
1

answered Feb 25 '14 at 17:01

nanobash

5,419
7
38
56

score 1 · Answer 2 · answered Feb 25 '14 at 17:02

1

try this:

$arrResult = array();
while ($row = mysql_fetch_array($sql)) {
    $arrResult[] = $row['ip'];
}

answered Feb 25 '14 at 17:02

Awlad Liton

9,366
2
27
53

score 0 · Answer 3 · answered Feb 25 '14 at 17:14

0

$result = mysql_query("SELECT ip FROM lua where uid='$uid'"); 
$ip = array();  
while ($ip[] = mysql_fetch_field($result));
$ip = array_filter($ip);

answered Feb 25 '14 at 17:14

evalarezo

1,134
7
13

How to put database value in array

3 Answers3