这个问题在这里已经有答案了:
为什么我不应该在php中使用mysql函数(12个答案)
两年前关门了。
我在xampp中有一个小型网站主机。我使用的是最新版本的xampp。但是当我在web浏览器上输入url时,该php页面根本没有加载。其他页面加载时没有任何问题。以下是完整代码:
<!DOCTYPE HTML>
<!--
Industrious by TEMPLATED
templated.co @templatedco
Released for free under the Creative Commons Attribution 3.0 license (templated.co/license)
-->
<html>
<head>
<title>ARTIK Cloud based Smart Parking System</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no" />
<meta name="description" content="" />
<meta name="keywords" content="" />
<link rel="stylesheet" href="assets/css/main.css" />
<style>
rainbowParking {
display: block;
background-color: #dddddd;
padding: 30px;
font-size: 70px;
line-height: 60%;
margin-left: 40px;
margin-right: 40px;
border-style: groove;
}
indigoParking {
display: block;
background-color: #dddddd;
padding: 30px;
font-size: 70px;
line-height: 60%;
margin-left: 40px;
margin-right: 40px;
border-style: groove;
}
div.container {
margin: 15px;
}
div.left,
div.right {
float: left;
padding: 10px;
}
div.left {
background-color: white;
width: 900px;
height: 500px;
}
div.right {
background-color: #dddddd;
width: 360px;
height: 400px;
margin-top: 20px;
margin-bottom: 100px;
}
div.right-output {
background-color: #dddddd;
width: 360px;
height: 400px;
overflow-y: auto;
margin-top: 20px;
margin-bottom: 100px;
}
.myBox {
position:absolute;
left:471px;
top:94px;
width:204px;
height:183px;
filter:alpha(opacity=90);
opacity:0.90;
z-index:7;
}
.redBox {
background: red;
}
.greenBox {
background: green;
}
.square-box {
position: relative;
width: 20%;
overflow: hidden;
background: blue;
&:before {
content: "";
display: block;
padding-top: 100%;
}
}
.square-content {
position: absolute;
top: 0; left: 0; bottom: 0; right: 0;
color: white;
div {
display: table;
width: 100%;
height: 100%;
}
span {
display: table-cell;
text-align: center;
vertical-align: middle;
color: white
}
}
</style>
</head>
<body class="is-preload" >
<!-- Header -->
<header id="header">
<a class="logo" href="index.html">SmartPark</a>
<nav>
<a href="#menu">Menu</a>
</nav>
</header>
<!-- Nav -->
<nav id="menu">
<ul class="links">
<li>
<a href="index.html">Home</a>
</li>
<li>
<a href="websocket.html">Parking Lot Status</a>
</li>
<li>
<a href="generic.html">Parking Space Availability</a>
</li>
</ul>
</nav>
<!-- Heading -->
<div id="heading">
<h1>ARTIK Cloud based Smart Parking System</h1>
</div>
<!-- Main -->
<section id="main" class="wrapper">
<h2 style="color:green;text-align:center;font-size: 50px">Main Parking Status</h2>
<div class="container">
<?php
$user = 'root';
$password = '';
$db = 'smart_parking';
$host = 'localhost';
$port = 1234;
$link = mysqli_init();
$success = mysqli_real_connect(
$link,
$host,
$user,
$password,
$db,
$port
);
//List the Columns for the Report
echo "<table border='1'>
<tr>
<th>Sensor ID</th>
<th>Slot Status</th>
</tr>";
$result = mysql_query($success,"SELECT sensorId,slotStatus,time FROM arduino_ultrasonic au1 WHERE timestamp = (SELECT MAX(timestamp) FROM arduino_ultrasonic au2 WHERE au1.sensorId = au2.sensorId)");
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['sensorId'] . "</td>";
echo "<td>" . $row['slotStatus'] . "</td>";
if($row['sensorId']=='Ultra_sensor_01' && $row['slotStatus']=='Occupied') // [val1] can be 'approved'
echo "<td style='background-color: #FF0000;'>".$row['slotStatus']."</td>";
else if($row['sensorId']=='Ultra_sensor_01' && $row['slotStatus']=='Free')// [val2]can be 'rejected'
echo "<td style='background-color: #008000;'>".$row['slotStatus']."</td>";
else if($row['sensorId']=='Ultra_sensor_02' && $row['slotStatus']=='Occupied')// [val2]can be 'rejected'
echo "<td style='background-color: #FF0000;'>".$row['slotStatus']."</td>";
else if($row['sensorId']=='Ultra_sensor_02' && $row['slotStatus']=='Free')// [val2]can be 'rejected'
echo "<td style='background-color: #008000;'>".$row['slotStatus']."</td>";
else if($row['sensorId']=='Ultra_sensor_03' && $row['slotStatus']=='Occupied')// [val2]can be 'rejected'
echo "<td style='background-color: #FF0000;'>".$row['slotStatus']."</td>";
else if($row['sensorId']=='Ultra_sensor_03' && $row['slotStatus']=='Free')// [val2]can be 'rejected'
echo "<td style='background-color: #008000;'>".$row['slotStatus']."</td>";
echo "</tr>";
}
echo "</table>";
$mysqli->close();
?>
</div>
</section>
<!-- Footer -->
<footer id="footer">
<div class="inner">
<div class="content">
<section>
<h3>SHU Final Year Project</h3>
<p>This project is based on the IoT concept. I used Raspberry Pi, Arduino and Samsung Artik cloud service to create this project.
This a simple demonstrantion of upcoming smart parking.
</p>
</section>
<section>
<h4>Links</h4>
<ul class="alt">
<li>
<a href="https://raspberrypi.org">Raspberry Pi</a>
</li>
<li>
<a href="https://arduino.cc">Arduino</a>
</li>
<li>
<a href="https://www.artik.io/">Samsung Artik</a>
</li>
</ul>
</section>
<section>
<h4>Social Media Links</h4>
<ul class="plain">
<li>
<a href="www.twitter.com">
<i class="icon fa-twitter"> </i>Twitter</a>
</li>
<li>
<a href="www.facebook.com">
<i class="icon fa-facebook"> </i>Facebook</a>
</li>
<li>
<a href="www.instagram.com">
<i class="icon fa-instagram"> </i>Instagram</a>
</li>
<li>
<a href="www.github.com">
<i class="icon fa-github"> </i>Github</a>
</li>
</ul>
</section>
</div>
<div class="copyright">
© CheshanJ. Photos:
<a href="https://unsplash.co">Unsplash</a>, Video:
<a href="https://coverr.co">Coverr</a>.
</div>
</div>
</footer>
<!-- Scripts -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/browser.min.js"></script>
<script src="assets/js/breakpoints.min.js"></script>
<script src="assets/js/util.js"></script>
<script src="assets/js/main.js"></script>
</body>
</html>
我将mysqli用于sql部分。如果您想知道sql查询,那就是选择最新的记录。有谁能给我一些建议吗?如果有,请分享。谢谢。
p、 s:这个错误也发生在:
Fatal error: Uncaught Error: Call to undefined function mysql_query() in C:\xampp\htdocs\smartParking\slotstatus.php:192 Stack trace: #0 {main} thrown in C:\xampp\htdocs\smartParking\slotstatus.php on line 192
3条答案
按热度按时间pw136qt21#
错误消息表明您正在使用
mysql_query
mysql\u query在php5.5中已经被弃用。相反,尝试;2eafrhcq2#
您正在运行哪个版本的php?mysql已经贬值了。
在代码中从mysql改为mysqli
你的代码似乎还有mysql,检查!
qf9go6mv3#
使用mysqli_query()和mysqli_fetch_array(),新版本的php不支持“mysql”函数。