可以';t将类分配给用于sql选择/更新的表


can't assign a class to a table being used for a sql select/update

我正在运行一个查询,该查询输出到用于更新记录的表。由于我使用的边栏,该表对于我的页面来说太大了。我试着给它分配一个类,然后使用CSS来调整它的大小,使其适合我想要的位置,但我得到了这个错误:

分析错误:语法错误,意外的T_STRING,应为"、"或";"在…

我在网页的其他地方使用了类似的类,效果很好。如有任何帮助,我们将不胜感激。这是代码:

<!DOCTYPE HTML>
<html lang = "en">
  <head>
    <link rel="stylesheet" type="text/css" href="stylesheet.css">
    <title>Tech Order Department.html</title>
    <meta charset = "UTF-8" />
<style>
div {
    text-align: justify;
    }
.section {
     margin-left: auto;
     margin-right: auto;
     width: 70%;
    }
</style>

</head>
<body>
<nav>
    <h1>Yulista</h1>
<br>
    <h2>Explore</h2>
    <ul>
<br>
<form>
<INPUT Type="BUTTON" Value="Home Page" Onclick="window.location.href='http://www.oldgamer60.com/Project/sidebar.php'"> 
</form>
<form>
  <p><b>Project Status<br/></b>
      <select name="select" onChange="window.open(this.options[this.selectedIndex].value,'_self')">
      <option value="">Select one</option>
      <option value="http://www.oldgamer60.com/Project/CurrentProjects.php">Current Projects</option>
      <option value="http://www.oldgamer60.com/Project/ProjectsInFinalReview.php">In Final Review</option>
      <option value="http://www.oldgamer60.com/Project/DeliveredProjects.php">Delivered</option>
      <option value="http://www.oldgamer60.com/Project/CompletedProjects.php">Completed Projects</option>
    </select>
  </p>
</form>
<form>
  <p><b>Updates<br/></b>
      <select name="select" onChange="window.open(this.options[this.selectedIndex].value,'_self')">
      <option value="">Select one</option>
      <option value="http://www.oldgamer60.com/Project/ClientUpdates.php">Client Updates</option>
      <option value="http://www.oldgamer60.com/Project/mynewform.php">Project Updates</option>
      </select>
  </p>
</form>
<form>
  <p><b>New Business<br/></b>
      <select name="select" onChange="window.open(this.options[this.selectedIndex].value,'_self')">
      <option value="">Select one</option>
      <option value="http://www.oldgamer60.com/Project/NewProject.php">New Project</option>
      <option value="http://www.oldgamer60.com/Project/NewClients.php">New Clients</option>
      </select>
  </p>
</form>

<br>
</ul>
    </nav>
<h1>Logistics</h1>
<br>
<h2>Updates</h2>

<?php
$servername = "localhost";
$username = "oldga740_Tonymm";
$password = "JtAjDm#6";
$dbname = "oldga740_SeniorProject";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
     die("Connection failed: " . $conn->connect_error);
}
if (isset($_POST['update'])){
$UpdateQuery = "UPDATE Projects SET Project='$_POST[project]', Client='$_POST[client]', LastName='$_POST[lastname]', DateReceived='$_POST[datereceived]', FinalReviewDate='$_POST[finalreviewdate]', DateDelivered='$_POST[datedelivered]', DateAccepted='$_POST[dateaccepted]' WHERE Project='$_POST[hidden]'";
mysqli_query($conn, $UpdateQuery);
};
$sql = "SELECT * FROM Projects";
$result = $conn->query($sql);
echo "<table class="smaller">
<tr>
<th>Project</th>
<th>Client</th>
<th>Last Name</th>
<th>Date Received</th>
<th>Final Review Date</th>
<th>Date Delivered</th>
<th>Date Accepted</th>
</tr>";
while($record = mysqli_fetch_array($result))
{
if ($result->num_rows > 0){
echo "<form action='mynewform.php' method='post'>";
echo "<tr>"; 
echo "<td>" . "<input type='text' name='project' value='" . $record['Project'] . "' /></td>";
echo "<td>" . "<input type='text' name='client' value='" . $record['Client'] . "'/></td>";
echo "<td>" . "<input type='text' name='lastname' value='" . $record['LastName'] . "' /></td>";
echo "<td>" . "<input type='text' name='datereceived' value='" . $record['DateReceived'] . "' /></td>";
echo "<td>" . "<input type='text' name='finalreviewdate' value='" . $record['FinalReviewDate'] . "' /></td>";
echo "<td>" . "<input type='text' name='datedelivered' value='" . $record['DateDelivered'] . "' /></td>";
echo "<td>" . "<input type='text' name='dateaccepted' value='" . $record['DateAccepted'] . "' /></td>";
echo "<td>" . "<input type='hidden' name='hidden' value='" . $record['Project'] . "' /></td>";
echo "<td>" . "<input type='submit' name='update' value='update' /></td>";
echo "<td>" . "<input type='submit' name='delete' value='delete' /></td>";
echo "</tr>";
echo "</form>";
}
}
echo "</table>";

?>
<?php
    $conn->close();
?>

</body>
</html>

我的css:

table.smaller { width:80%; }

您的代码中有一个小语法错误。修复方法如下:

// your code
echo "<table class='"smaller'">
<tr>
<th>Project</th>
<th>Client</th>
<th>Last Name</th>
<th>Date Received</th>
<th>Final Review Date</th>
<th>Date Delivered</th>
<th>Date Accepted</th>
</tr>";
// your code

window.location.href='http://www.oldgamer60.com/Project/sidebar.php'-之后添加';'

<INPUT Type="BUTTON" Value="Home Page" Onclick="window.location.href='http://www.oldgamer60.com/Project/sidebar.php';">