How to fetch multiple data from database and store in one variable?

Question

I want to fetch multiple row and store in one variable.Here is my function for fetch data.

I want to fetch all row which type is service. and display all data in php.

Get value function

public function getvalue() {
    $db = connectionstart();
    $sql = ("SELECT * FROM user_posts WHERE type='service' LIMIT 3");
    $result = mysql_evaluate($db, $sql);

    connectionclose($db);
    return $result;
}

mysql_evaluate function

function mysql_evaluate($db, $sql) {
    $result = mysql_query($sql, $db) or die(mysql_error());
    if (mysql_num_rows($result) == 0)
        return $default_value;
    else
        return mysql_result($result, 0);
}

Don't use mysql_* functions, they are deprecated as of PHP 5.5 and are removed altogether in PHP 7.0. Use mysqli or pdo instead. — Rajdeep Paul
– Rajdeep Paul, Commented Feb 10, 2016 at 7:07
I've also included the links in my comment. Click on them to read about these database extensions. — Rajdeep Paul
– Rajdeep Paul, Commented Feb 10, 2016 at 7:18

Ravi Hirani · Accepted Answer · 2016-02-10 08:37:41Z

1

Write your function as below:-

public function getvalue() {
    $db = connectionstart();
     // No need of bracket here
    $sql = "SELECT * FROM user_posts WHERE type='service' LIMIT 3";
    $result = mysql_query($sql);
    // declare an array
    $data = [];
    if($result){
        // loop
        while($row = mysql_fetch_array($result)) {
                 // store data in an array
                 $data[] = $row; 

         }    
    }

    return $data;
}

Hope it will help you :)

edited Feb 10, 2016 at 8:37

answered Feb 10, 2016 at 7:32

Ravi Hirani

6,5341 gold badge31 silver badges43 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:15:38Z

0

You should try with array store technique

//  First Store data in $data
$data = array();
$result = mysql_evaluate($db, $sql, $defaultvalue);
foreach ($result  as $row) {
    $data [] = $row;
}
// Your all data will be store in $data variable
print_r($data);

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Feb 10, 2016 at 7:05

Ayaz Ali Shah

3,5419 gold badges42 silver badges68 bronze badges

2 Comments

Kevin P Patel Over a year ago

Invalid argument supplied for foreach() give this typ of error @Php Developer

Ayaz Ali Shah Over a year ago

@KevinPPatel check this print_r($result) and let me know which kind array are you retrieving..

Félix Adriyel Gagnon-Grenier · Accepted Answer · 2016-02-10 08:06:06Z

0

Try this article on w3schools.com, especially the part with $row=$result->fetch_assoc()

edited Feb 10, 2016 at 8:06

Félix Adriyel Gagnon-Grenier

8,93510 gold badges58 silver badges69 bronze badges

answered Feb 10, 2016 at 7:31

Wilkoklak

898 bronze badges

Collectives™ on Stack Overflow

How to fetch multiple data from database and store in one variable?

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related