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
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.