如何在html中查看数据库值

How to see database values in html

本文关键字：数据库 html      更新时间：2023-09-26

我试图可视化sql数据库。最后，我希望看到一些图表，但我不能转换值从php到js和html。在我的数据库是从同一形式的两个条目。第一个文件是php文件命名为"read。php"

<?php
$con=mysqli_connect("localhost","root","password","databasename");
// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$result = mysqli_query($con,"SELECT * FROM tablename");

while($row = mysqli_fetch_array($result)) {
    $data[] = array(
            'join_date' => $row['join_date'],
            'column1' => $row['column1'],
            'column2' => $row['column2'],
            'column3' => $row['column3'],
            'column4' => $row['column4']
          );
        echo json_encode($data);    
}
mysqli_close($con);
?>

当我打开这个文件时，我看到它是json。我想在html文件中看到这些列，所以我制作了"readjson.html":

<!DOCTYPE html>
<html>
<body>
<h2> Database in html</h2>
One: <p1 id="origname1"></p1><br>  
two: <span id="origname2"></span><br>  
<script type="text/javascript" > 
var baza = "<?php ($data )[http://localhost/read.php]; ?>";
document.getElementById("origname1").innerHTML=baza[0].join_date + ", " + baza[1].column1 + ", " + baza[0].column2 + ", " + baza[0].column3 + ", " + baza[0].column4;
document.getElementById("origname2").innerHTML=baza[1].join_date + ", " + baza[1].column1 + ", " + baza[1].column2 + ", " + baza[1].column3 + ", " + baza[1].column4;
</script>
</body>
</html>

当我打开readjson.html时，我看到:

数据库在html一:未定义，未定义，未定义，未定义，未定义，未定义二:未定义、未定义、未定义、未定义

而不是undefined我想看到数据库条目。请帮助。

首先，我想知道你是怎么想到这个的:

"<?php ($data )[http://localhost/read.php]; ?>";

这不是PHP语法。您想要的是包含该文件，并且在read.php中不打印json_encode 

<?php
$con=mysqli_connect("localhost","root","password","databasename");
// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$result = mysqli_query($con,"SELECT * FROM tablename");
$data = array();
while($row = mysqli_fetch_array($result)) {
    $data[] = array(
            'join_date' => $row['join_date'],
            'column1' => $row['column1'],
            'column2' => $row['column2'],
            'column3' => $row['column3'],
            'column4' => $row['column4']
          );
}
mysqli_close($con);
?>

然后包含它:

<?php
include 'read.php';
?>
<!DOCTYPE html>
<html>
<body>
<h2> Database in html</h2>
One: <p1 id="origname1"></p1><br>  
two: <span id="origname2"></span><br>  
<script type="text/javascript" > 
var baza = JSON.parse(<?php echo '"' . json_encode($data) . '"'; ?>);
document.getElementById("origname1").innerHTML=baza[0].join_date + ", " + baza[1].column1 + ", " + baza[0].column2 + ", " + baza[0].column3 + ", " + baza[0].column4;
document.getElementById("origname2").innerHTML=baza[1].join_date + ", " + baza[1].column1 + ", " + baza[1].column2 + ", " + baza[1].column3 + ", " + baza[1].column4;
</script>
</body>
</html>

我不能向你保证这将工作，但请尝试一下!

相关文章：