MySQL Query always returns only '1' in azure app service + azure database server

Question

Currently, I am coding using azure app service and azure database server for mysql.

When the 'select' statement is executed, only '1' is returned.

I don't think it's a connection problem because 'insert' statement works fine.

This is my php code running on azure app service.

error_reporting(E_ALL); 
ini_set('display_errors',1); 
include('dbconnectr.php'); 

$id = $_GET['id'];
$stmt = $con->prepare('select * from contents where id='.$id);
$stmt->execute();
$result = $stmt->fetch();
echo $result;

What is the problem?

If this is mysqli, `fetch()` returns a boolean, and you need to use `$stmt->bind_result()` to specify variables that receive the selected columns. — Barmar, Mar 19 '21 at 15:55
What are you expecting to echo instead? In PDO, `fetch()` returns an array, you can't echo that. — Barmar, Mar 19 '21 at 15:58

score 0 · Accepted Answer · answered Mar 19 '21 at 16:20

This script will help you

error_reporting(E_ALL); 
ini_set('display_errors',1); 
include('dbconnectr.php'); 

$id = $_GET['id'];

$stmt = $con->prepare("select * from contents where id=?");

/* bind parameters */
$stmt->bind_param("i", $id);

/* execute query */
$stmt->execute();

/* bind result variables */
$stmt->bind_result($result);

/* fetch value */
$stmt->fetch();

print_r($result);

I use the bind for protecting myself from sql injection.
So I use bind_param to bind the param, then use execute for execute the command and then bind the result in the bind_result and after that use the fetch and fill the result variable and Done

MySQL Query always returns only '1' in azure app service + azure database server

1 Answers1