How to fetch records from database

Question

I wanted to know how can I fetch records from an array with different object keys in php?

Here is my array output result:

    Array
(
    [0] => Array
        (
            [0] => Alpha Project
            [name] => Alpha Project
        )

    [1] => Array
        (
            [0] => Bravo Project
            [name] => Bravo Project
        )

)

Please note that I am using ADODB database class in my project. This is the sample code of ADODB for populating results:

<?php

include('adodb/adodb.inc.php');

$server = 'localhost'; $user = 'root'; $password = ''; $database = 'some_database'; $driver = 'mysql';

$db = ADONewConnection($driver);
$db->debug = true;

$db->Connect($server, $user, $password, $database);

$result = $db->Execute('SELECT `name` FROM project;');

print "<pre>";
print_r($result->GetRows());
print "</pre>";

?>

This will help http://stackoverflow.com/questions/2245140/how-to-get-field-names-using-php-adodb — Samir Selia, Mar 21 '17 at 06:48
I just want to get the project names and display them in html — Saeed Nawaz, Mar 21 '17 at 06:52

score 0 · Answer 1 · 2017-03-21T07:14:54.867

0

Here is example:

$Results = $result->GetRows();
foreach ($Results as $key => $value) {
    // print_r($value['name'])  ;
    $option .= '<option value="'.$key.'">'.$value['name'].'</option>';
}

echo '<select>' . $option . '</select>';

edited Mar 21 '17 at 07:14

answered Mar 21 '17 at 07:06

Works in my example. – Mar 21 '17 at 07:15
Add this $Results = $result->GetRows(); – Mar 21 '17 at 07:19

How to fetch records from database

1 Answers1