How to get data from table database? i forget

[smansakra]

i forget how to get data from table database :'(
below is my table

options (in table options, i have 2 rows named with 'NAME' and 'VALUE' )
+--------------------------------
| NAME | VALUE
|--------------------------------
| site_name | Just My site
| site_email | my@somedomain.com
| site_description | no description here :)
| site_owner | smansakra girl
+--------------------------------------------

i want to return the result to an array


$site_details = array();
//here will be the code to get data
foreach( i forget what i should write here){
//and i don't know how to use array_merge
}

actually i want the final result is like below
$site_details = array(
'site_name' => 'Just My site',
'site_email' => 'my@somedomain.com',
'site_description' => 'no description here :)',
'site_owner' => 'smansakra girl'
);

HELP, thanks

[xtiano77]

Is this what you are looking for?



$query = "SELECT
site_name,
site_email,
site_description,
site_owner
FROM
database.table
WHERE
refine = :criteria
ORDER BY site_name ASC";
$statement = $db -> prepare($query);
$statement -> bindParam(":criteria", $parameter);
$statement -> execute();
$site_details = array();
foreach($statement -> fetch(PDO::FETCH_ASSOC) as $key => $value){
$site_details[$key] = $value;
}

[smansakra]

Thanks for reply, unfortunately

site_name,
site_email,
site_description,
site_owner

are dynamic, so when i use a form to add name and value, the name rows will be add.
so, i think it better use:

SELECT *
FROM
database.table

but then i don't know what to write. :'(

[Brillig]

Your column names are dynamic?

You sure about that?

[djr33]

I don't understand this either. I think you should read through a MySQL tutorial to remember all of the basics and then look at the problem again.

[smansakra]

:'(
oKE, i will repeat it to make it more clear

1.) i have a database table like below
+--------------------------------
| NAME | VALUE
|--------------------------------
| site_name | Just My site
| site_email | my@somedomain.com
| site_description | no description here
| site_owner | smansakra girl
+--------------------------------------------

2. i have an system administration to submit a name and a value for it (look at the table, there are NAME and VALUE row)

3. for example, on my admin page, i submit 'site_keyword' as NAME and 'reni, smansakra, indonesia' as VALUE
so, the table will change like below
+--------------------------------
| NAME | VALUE
|--------------------------------
| site_name | Just My site
| site_email | my@somedomain.com
| site_description | no description here
| site_owner | smansakra girl
| site_keyword | reni, smansakra, indonesia
+--------------------------------------------

4. then i have an array, and i want each of the content of the table above become key and value,
like below

$site_details = array(
'site_name' => 'Just My site',
'site_email' => 'my@somedomain.com',
'site_description' => 'no description here :)',
'site_owner' => 'smansakra girl',
'site_keyword' => 'reni, smansakra, indonesia',
'site_anotherifadded' => 'valuethatadded'
);


5. anybody help?? :'(

[smansakra]

function get_from_options(){
$table_name = array();
$table_content = array();

$this->load->database();
$query = $this->db->query("SELECT * FROM `options`");
$row = $query->row_array();
foreach ($query->result_array() as $row)
{
array_push($table_name, $row['name']);
array_push($table_content, $row['content']);
}
return array_combine($table_name, $table_content);
}

for now, just the poor code above that i can create (using codeigniter)
:(

that code can result like what i want


$site_details = get_from_options()
/*
will result like below
$site_details = array(
'site_name' => 'Just My site',
'site_email' => 'my@somedomain.com',
'site_description' => 'no description here :)',
'site_owner' => 'smansakra girl',
'site_keyword' => 'reni, smansakra, indonesia',
'site_anotherifadded' => 'valuethatadded'
);
*/