如何将 PDO fetchAll 的结果转换为字符串？

Question

如何将fetchAll()结果转换为字符串？就像迭代我的 fetch all 返回的数组的内容并尝试回显它们给我一个“数组到字符串转换”错误。我想回显数组的每个值。

$pdo = new PDO($dsn, $user, $password);

    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $stmt = $pdo->prepare("SELECT company_name, job_name, job_description, job_location, contact_email FROM joblist");

    $stmt->execute();

    $result = $stmt->fetchAll();

    print_r($result);

    // echo $result[0];

    foreach ($result as $key => $value) {

        echo $value;

    }

我的结果如下所示：

Array (

    [company_name] => alex

    [0] => alex

    [job_name] => driver

    [1] => driver

    [job_description] => drive a truck with goods

    [2] => drive a truck with goods

    [job_location] => america

    [3] => america

    [contact_email] => [e-mail]

    [4] => [e-mail]

)

C:\xampp\htdocs\jobs-app\postjob.php注意：第 23 行中的数组到字符串的转换

Answer 1

$value 是数组格式。所以你不能回显数组。foreach ($result as $key => $value) {   echo $value['job_name'];}

Answer 2

你在一个数组中有一个数组，像这样回显它应该可以foreach ($result as $key => $value) {    echo $value[0];}如果你想让它更精确，你应该这样做foreach ($result as $key => $value) {    echo $value['company_name'];}

Answer 3

您 foreach 中的 $value 是数组。尝试这个。foreach ($result as $key => $value) {   echo $value['company_name'];}