Prepared statement execution returns binary data - we need Text data only

See more:

Perl

PHP

Dear All,

We are using prepared statement to retrieve data.

In MySql we receive proper result but same result is in very different format when we receive it on PHP page.


Please share some information how can we recieve result in text format on php side.

After reviewing various resources we have found that prepare statement returns binary data.. So please suggest how can we recieve text Data.


$stmt=$objConn->stmt_init();
if($stmt->prepare($query))
{

$stmt->bind_param();

$stmt->execute();

$result = $stmt->get_result();