MySQLI Fetch Database Column

Question

I have database table options, where am using it as a dedicated table to store information. I have never heard of this type of table query and have never tried it. I saw on WordPress database so thought to try my own.

Here's database table

enter image description here

This is what am trying now

$sql = "SELECT * FROM options WHERE option_flag = 'settings'";
var_dump( $db->FETCH_FIELD($sql) );

This is inside my database class file $db

public function FETCH_FIELD($sql){
    $this->results = mysqli_query($this->link, $sql);       
$rows = mysqli_fetch_fields( $this->results );
    return $rows;
}

The Problem

When I var_dump the results, I don't see any database information.

enter image description here

Are you sure you want to use mysqli_fetch_fields -> php.net/manual/en/mysqli-result.fetch-fields.php and not mysqli_fetch_all -> php.net/manual/en/mysqli-result.fetch-all.php — Sean
– Sean, Commented Aug 31, 2014 at 13:15

Dharman · Accepted Answer · 2020-07-23 20:07:24Z

3

Since you want to get an array that shows the query results, I would try this:

<?php
$db = new mysqli(HOST, USERNAME, PASSWORD, DBNAME);
$stmt = $db->query("SELECT * FROM options WHERE option_flag = 'settings'");
$result = $stmt->fetch_all();
var_dump($result);

Of course, this works in procedural style, too:

<?php
$link = mysqli_connect(HOST, USERNAME, PASSWORD, DBNAME);
$stmt = mysqli_query($link, "SELECT * FROM options WHERE option_flag = 'settings'");
$result = mysqli_fetch_all($stmt);
var_dump($result);

Go to the php documentation to learn more about mysqli_result::fetch_all.

edited Jul 23, 2020 at 20:07

Dharman♦

34k27 gold badges106 silver badges157 bronze badges

answered Aug 31, 2014 at 13:20

Bluedayz

5996 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

MySQLI Fetch Database Column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related