临时Access数据库的位置(Location for temporary Access databases)

 首先，该表名带有连字符; MySQL数字你想在这里做数学。 
 
$sql = "INSERT INTO o18-reg
 
 转换为o18 减去 reg 
 
 所以把它包裹在刻度线中 
 
$sql = "INSERT INTO `o18-reg` ...
 
 或将其重命名为下划线。 
 
 那么你将面临另一个问题，价值。 你有什么似乎是字符串，所以你需要引用这些。 
 
 即 
 
VALUES ('$title', '$firstname', '$surname' ...
 
 并对其余的字符串执行相同的操作。 
 
 然后你面临着一个SQL注入。 
 
 使用准备好的声明： 
 
 
 
 https://en.wikipedia.org/wiki/Prepared_statement 
 
 
 http://php.net/manual/en/pdo.prepared-statements.php 
 
 
 编辑： 
 
 我只注意到，你有21列，但使用20个变量，没有进行必要的调整来弥补。 您可能会收到有关列不匹配的其他错误，这会产生以下影响： 
 
 
 
 致命错误：带有消息的未捕获异常'PDOException'。 插入值列表与列表列表不匹配：1136列计数与第1行的值计数不匹配 
 
 
 如果id是AI，则需要在查询中稍做调整，方法是在“ 
 
VALUES ('', '$title', '$firstname' ...
 
 如果为它预留了一个变量（在您发布的代码中似乎不存在），则添加它。 但是，如果id列是AI，则使用上面的'' 。 
 
 
 洞察力： 
 
 确保您的表单确实使用POST方法，并且所有输入都带有名称属性，并且没有拼写错误。 
 
 
 
 他们似乎正确填充，但这也是未来访问者的问题。 
 
 
 将错误报告添加到文件的顶部，这将有助于查找错误。 
 
<?php 
error_reporting(E_ALL);
ini_set('display_errors', 1);

// rest of your code
 
 旁注：显示错误只能在分阶段进行，而不能进行生产。 

Firstly, that table name with the hyphen; MySQL figures you want to do math here.
 
$sql = "INSERT INTO o18-reg
 
Which translates to o18 minus reg
 
so wrap it in ticks
 
$sql = "INSERT INTO `o18-reg` ...
 
or rename it to be an underscore.
 
Then you'll be faced with another problem, the VALUES. You have what seems to be strings, so you'll need to quote those.
 
I.e.
 
VALUES ('$title', '$firstname', '$surname' ...
 
and do the same for the rest of the strings.
 
Then you're faced with an SQL injection.
 
Use a prepared statement:
 
 
 
https://en.wikipedia.org/wiki/Prepared_statement
 
 
http://php.net/manual/en/pdo.prepared-statements.php
 
 
Edit:
 
I just noticed, you have 21 columns, but using 20 variables without making the necessary adjustement to compensate. You would have received an additional error about columns do not match, something to the effect of:
 
 
 
Fatal error: Uncaught exception 'PDOException' with message. Insert value list does not match column list: 1136 Column count doesn't match value count at row 1
 
 
If id is an AI, you will need to make a slight adjustment in your query, by adding '' in:
 
VALUES ('', '$title', '$firstname' ...
 
If there is a variable set aside for it (which doesn't seem to be present in your posted code), then add it. However, if the id column is an AI, then use the '' above.
 
 
An insight:
 
Make sure that your form does use a POST method and that all inputs bear the name attributes, and with no typos.
 
 
 
They seem to be populating correctly, but this is also for future visitors to the question.
 
 
Add error reporting to the top of your file(s) which will help find errors.
 
<?php 
error_reporting(E_ALL);
ini_set('display_errors', 1);

// rest of your code
 
Sidenote: Displaying errors should only be done in staging, and never production.