如何在PDO MySQL中回显字符串？

Question

I want php to echo string of text - a zone of the country from the database, but PDO does not want to spit out anything but arrays.

$sendToCountryCode = $_POST['sendToCountry'];

$sqlGetSendToCountryZone= "SELECT zone FROM table WHERE code = :country";
$stmtGetSendToCountryZone = $conn->prepare($sqlGetSendToCountryZone);
$stmtGetSendToCountryZone->bindParam(':country', $sendToCountryCode, PDO::PARAM_STR);
$stmtGetSendToCountryZone->execute(array(':country' => $sendToCountryCode));

$sendToCountryZone = $stmtGetSendToCountryZone->fetch();
var_dump($sendToCountryZone);
echo 'send to country code: ', $sendToCountryZone ,'<br>';

Google is not strong with me today

Notice: Array to string conversion in .... on line 10

Answer 1

Please use $sendToCountryZone = $stmtGetSendToCountryZone->fetch(PDO::FETCH_ASSOC); as it is recommended to use fetch () with the appropriate parameter since fetch () has several "fetching styles".

Read more about it here

Next please use $sendToCountryZone["zone"] as it will always return a string array.