如何在 php 中运行 sql 查询? [英] How do I run an sql query in php?

问题描述

当我尝试运行查询时，结果为空白(不是 NULL，只是不打印值).如果我在我的数据库中运行我的查询，它会返回我正在寻找的值.

When I try and run my query it turns out blank (not NULL, just not printing a value). If I run my query in my database it returns the value Im looking for.

当我运行我的代码时，它会通知我连接成功.(我没有包含我的数据库变量信息来保护敏感信息，但它是正确的)

When I run my code it notifies me the connection was successful. (I didnt include my db variable info to protect the sensitive info but it is correct)

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
    echo "error";
} 
else{
    echo "conn successful";
}


$sql = "SELECT app_ref_person_submitted_by
            FROM vacancy_applications
            WHERE app_ref_vacancy = 306";


$result = $conn->query($sql);
echo $result;

$conn-> close();

推荐答案

试试下面的代码，

<?php
$conn = new mysqli('localhost', 'jaydeep_mor', 'jaydeep_mor', 'jaydeep_mor');

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
    echo "error";
} 
else{
    echo "conn successful";
}
$sql = "SELECT app_ref_person_submitted_by
        FROM vacancy_applications
        WHERE app_ref_vacancy = 306";

$result = $conn->query($sql);

while($row = $result->fetch_array()){
    echo $row['app_ref_person_submitted_by'];
}

$conn-> close();
?>

这篇关于如何在 php 中运行 sql 查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！