How to convert any value from sql table into string

Question

There is some data is stored in my sql table. I want to fetch the data in the form of string.

$sql= "SELECT hash FROM signupinfo WHERE fname = 'nikhil';";
$hashfix = mysqli_query($connection,$sql); 
echo $hashfix;

but the error coming

Catchable fatal error: Object of class mysqli_result could not be converted to string in C:\WampDeveloper\Websites\localhost\webroot\signup.php on line 48

Reuben Gomes · Answer 1 · 2016-08-06T16:13:32.390

0

var_dump($hashfix). If you want to read your array all Data fetched from a db come in the form of array

Its not a good idea to echo array...by that I mean you can't. What you can do in to make a string is. $a=implode(',',$hashfix)

There are 2 ways to print values you want

If its a single key array.
echo $hashfix[0]->ColumnName

Or run a foreach

edited Aug 06 '16 at 16:13

answered Aug 06 '16 at 16:06

Reuben Gomes

878
9
16

Updated check new content tell me if this is what you need – Reuben Gomes Aug 06 '16 at 16:11
this output the value in the form of object `object(mysqli_result)#2 (5) { ["current_field"]=> int(0) ["field_count"]=> int(1) ["lengths"]=> NULL ["num_rows"]=> int(1) ["type"]=> int(0) }` i want the value in string for example any name (like nikhil) or any hash value – Aug 06 '16 at 16:11
Your selecting hash – Reuben Gomes Aug 06 '16 at 16:14
If you want fname select fname. If you want all data. Then select * where fname =nikhil – Reuben Gomes Aug 06 '16 at 16:15
Print using echo $hashfix['fname'] – Reuben Gomes Aug 06 '16 at 16:16
i try `implode (',',$hashfix)` it says `Warning: implode(): Invalid arguments passed in C:\WampDeveloper\Websites\localhost\webroot\signup.php on line 49` – Aug 06 '16 at 16:17
Ohh and use mysqli_result() – Reuben Gomes Aug 06 '16 at 16:20
the sql query returns a recordset object, not an array so you can't simply `implode` – Professor Abronsius Aug 06 '16 at 16:20
mysqli_result($connection,$sql); – Reuben Gomes Aug 06 '16 at 16:21
please write full code how i can output any table field value as it is. – Aug 06 '16 at 16:22
Opps I meant explode(',',$hashfix); explode makes arrays string – Reuben Gomes Aug 06 '16 at 16:23
mysqli_store_result() or try this. – Reuben Gomes Aug 06 '16 at 16:30

score 0 · Answer 2 · answered Aug 06 '16 at 16:24

0

You could do something like this...

$sql= "SELECT `hash` FROM `signupinfo` WHERE `fname` = 'nikhil';";
$hashfix = mysqli_query( $connection, $sql ); 
if( $hashfix ){
    while( $rs=$connection->fetch_object( $hashfix ) ){
        echo $rs->hash;
    }
}

answered Aug 06 '16 at 16:24

Professor Abronsius

33,063
5
32
46

How to convert any value from sql table into string

2 Answers2