个人中心
文章发布
退出
作者热门文章
- html - 出于某种原因，IE8 对我的 Sass 文件中继承的 html5 CSS 不友好？
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景？
24
4
我正在创建在线测试。我已经正确设置了表格和所有内容，它很好地向管理员发送了一封电子邮件。但是我希望它这样做:
我需要脚本将结果与 MySQL 数据库中已有的数据进行比较，所以如果问题 1 是:“完成句子:We tok the dog for a __”然后他们用“走路”回答，然后它会在电子邮件中发送答案和天气是正确的，例如:1) 步行 - 正确
这是我的脚本(所有 a1、a2 等都是答案。):
<?php
$con=mysqli_connect("mywebsite.com","username","password","eiy_testResults");
if (mysqli_connect_errno($con))
{
echo "ERROR - Failed to connect to MySQL Server. Please contact an administrator: " . mysqli_connect_error();
}
$emailSubject = 'Online Test results';
$webMaster = 'name@email.com';
$name = $_POST['name'];
$email = $_POST['email'];
$date = $_POST['date'];
// Questions in order. Ad more changing the number (+1).
$a1 = $_POST['a1'];
$a2 = $_POST['a2'];
$a3 = $_POST['a3'];
$a4 = $_POST['a4'];
$a5 = $_POST['a5'];
$a6 = $_POST['a6'];
$a7 = $_POST['a7'];
$a8 = $_POST['a8'];
$a9 = $_POST['a9'];
$a10 = $_POST['a10'];
$a11 = $_POST['a11'];
$a12 = $_POST['a12'];
$a13 = $_POST['a13'];
$a14 = $_POST['a14'];
$a15 = $_POST['a15'];
$a16 = $_POST['a16'];
$a17 = $_POST['a17'];
$a18 = $_POST['a18'];
$a19 = $_POST['a19'];
$a20 = $_POST['a20'];
$a21 = $_POST['a21'];
$a22 = $_POST['a22'];
$a23 = $_POST['a23'];
$a24 = $_POST['a24'];
$a25 = $_POST['a25'];
$a26 = $_POST['a26'];
$a27 = $_POST['a27'];
$a28 = $_POST['a28'];
$a29 = $_POST['a29'];
$a30 = $_POST['a30'];
$a31 = $_POST['a31'];
$a32 = $_POST['a32'];
$a33 = $_POST['a33'];
$a34 = $_POST['a34'];
$a35 = $_POST['a35'];
$a36 = $_POST['a36'];
$a37 = $_POST['a37'];
$a38 = $_POST['a38'];
$a39 = $_POST['a39'];
$a40 = $_POST['a40'];
$a41 = $_POST['a41'];
$a42 = $_POST['a42'];
$a43 = $_POST['a43'];
$a44 = $_POST['a44'];
$a45 = $_POST['a45'];
$a46 = $_POST['a46'];
$a47 = $_POST['a47'];
$a48 = $_POST['a48'];
$a49 = $_POST['a49'];
$a50 = $_POST['a50'];
$body = <<<EOD
<br><hr><br>
<strong>Name</strong>: $name <br><br>
<strong>Email</strong>: $email <br><br>
<strong>Date submitted</strong>: $date <br><br>
<strong>Answers</strong>: <br />
$a1, <br />
$a2, <br />
$a3, <br />
$a4, <br />
$a5, <br />
$a6, <br />
$a7, <br />
$a8, <br />
$a9, <br />
$a10, <br />
$a11, <br />
$a12, <br />
$a13, <br />
$a14, <br />
$a15, <br />
$a16, <br />
$a17, <br />
$a18, <br />
$a19, <br />
$a20, <br />
$a21, <br />
$a22, <br />
$a23, <br />
$a24, <br />
$a25, <br />
$a26, <br />
$a27, <br />
$a28, <br />
$a29, <br />
$a30, <br />
$a31, <br />
$a32, <br />
$a33, <br />
$a34, <br />
$a35, <br />
$a36, <br />
$a37, <br />
$a38, <br />
$a39, <br />
$a40, <br />
$a41, <br />
$a42, <br />
$a43, <br />
$a44, <br />
$a45, <br />
$a46, <br />
$a47, <br />
$a48, <br />
$a49, <br />
$a50. <br />
EOD;
$headers = "From: $email\r\n";
$headers .= "Content-type: text/html\r\n";
$success = mail($webMaster, $emailSubject, $body,
$headers);
$theResults = <<<EOD
<!DOCTYPE HTML>
<html>
<head>
<title>English in York | Test</title>
<link href="style.css" rel="stylesheet"/>
</head>
<body>
<div class="container">
<br />
<div class="alert alert-success" style="margin-top: 50;"><div class="icon"></div>Thank you for completing the test! <a href="#">Return to the English In York Home Page</a><div class="triangle"></div></div>
</div>
</body>
</html>
EOD;
echo "$theResults";
?>
这是测试表单页面:
<!DOCKTYPE html>
<html>
<head>
<link href="style.css" rel="stylesheet">
<title>English in York | Test</title>
<style>
.container {
width: 75%;
margin: auto auto;
padding: 20px;
}
</style>
</head>
<body>
<div class="container">
<form name="form1" method="post" action="testSubmit.php" id="testSubmit">
<table class="table table-bordered" width="40%">
<tr>
<td><strong>Name:</strong></td>
<td><input type="text" name="name" id="name" placeholder="Mr John Doe" required></td>
</tr>
<tr>
<td><strong>Email:</strong></td>
<td><input type="email" name="email" id="email" placeholder="johnjoe@english-in-york.co.uk" required></td>
</tr>
<tr>
<td><strong>Date:</strong></td>
<td><input type="date" name="date" id="date" required></td>
</tr>
</table>
<br />
<h3>PART 1: USE OF ENGLISH</h3>
<strong>Look at these examples:</strong>
<table class="table table-bordered">
<tr>
<td width="5%" style="font-weight:bold;">(i)</td>
<td width="75%">My name ________ Nadine.</td>
<td><input type="text" value="Is" disabled></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">(ii)</td>
<td width="75%">I live _______ York.</td>
<td><input type="text" value="In" disabled></td>
</tr>
</table>
<br />
<strong>Now fill in the spaces with ONE word only:</strong>
<table class="table table-bordered">
<tr>
<td width="5%" style="font-weight:bold;">1</td>
<td width="75%">Where ________ you from? I'm from York.</td>
<td><input type="text" name="a1" id="a1" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">2</td>
<td width="75%">What does he _______? He's a doctor.</td>
<td><input type="text" name="a2" id="a2" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">3</td>
<td width="75%">Is she a student? No, she ________ . She's a teacher.</td>
<td><input type="text" name="a3" id="a3" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">4</td>
<td width="75%">How ________ is the ticket? £5.</td>
<td><input type="text" name="a4" id="a4" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">5</td>
<td width="75%">Do you come from France? No, I ________ . I come from Italy.</td>
<td><input type="text" name="a5" id="a5" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">6</td>
<td width="75%">________ do you go on holiday? In July.</td>
<td><input type="text" name="a6" id="a6" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">7</td>
<td width="75%">________ many languages do you speak? Two.</td>
<td><input type="text" name="a7" id="a7" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">8</td>
<td width="75%">________ is Sarah talking to? Her sister.</td>
<td><input type="text" name="a8" id="a8" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">9</td>
<td width="75%">Where ________ he work? He works in a bank.</td>
<td><input type="text" name="a9" id="a9" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">10</td>
<td width="75%">Where's Jane? She ________ watching TV in her room.</td>
<td><input type="text" name="a10" id="a10" required></td>
</tr>
<tr>
<td colspan="2" align="right" with="80%"><strong>Total</strong></td>
<td> </td>
</tr>
</table>
<br />
<table class="table table-bordered">
<tr>
<td width="5%" style="font-weight:bold;">11</td>
<td width="75%">Have you got ________ brothers or sisters?</td>
<td><input type="text" name="a11" id="a11" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">12</td>
<td width="75%">What ________ you do yesterday evening? I went to the cinema.</td>
<td><input type="text" name="a12" id="a12" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">13</td>
<td width="75%">Are they ________ to get married? No, they're not.</td>
<td><input type="text" name="a13" id="a13" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">14</td>
<td width="75%">Chewing gum ________ invented in Sweden.</td>
<td><input type="text" name="a14" id="a14" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">15</td>
<td width="75%">This is a lovely house. ________ room is yours?</td>
<td><input type="text" name="a15" id="a15" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">16</td>
<td width="75%">I'm not as tall as you, but I'm taller ________ Anna.</td>
<td><input type="text" name="a16" id="a16" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">17</td>
<td width="75%">How ________ have you known John? Six years.</td>
<td><input type="text" name="a17" id="a17" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">18</td>
<td width="75%">You ________ get wet if you don't take an umbrella.</td>
<td><input type="text" name="a18" id="a18" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">19</td>
<td width="75%">Have you ________ met the queen? No, never!</td>
<td><input type="text" name="a19" id="a19" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">20</td>
<td width="75%">I have been working here ________ 1998.</td>
<td><input type="text" name="a20" id="a20" required></td>
</tr>
<tr>
<td colspan="2" align="right" with="80%"><strong>Total</strong></td>
<td> </td>
</tr>
</table>
<br />
<table class="table table-bordered">
<tr>
<td width="5%" style="font-weight:bold;">21</td>
<td width="75%">How ________ is it from here to the airport? About 5 miles</td>
<td><input type="text" name="a21" id="a21" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">22</td>
<td width="75%">This time next week I'll ________ lying on a beach in Spain.</td>
<td><input type="text" name="a22" id="a22" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">23</td>
<td width="75%">If I knew the answer, I ________ tell you.</td>
<td><input type="text" name="a23" id="a23" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">24</td>
<td width="75%">I ________ to play tennis when I was young, but now I prefer golf.</td>
<td><input type="text" name="a24" id="a24" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">25</td>
<td width="75%">When we arrived home, Richard ________ gone to bed.</td>
<td><input type="text" name="a25" id="a25" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">26</td>
<td width="75%">I've lost my gloves. I ________ have left them on the bus.</td>
<td><input type="text" name="a26" id="a26" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">27</td>
<td width="75%">We aren't allowed to drink coffee in class... and we _______ chew gum either!</td>
<td><input type="text" name="a27" id="a27" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">28</td>
<td width="75%">If I ________ gone to the party, I would have met lots of new people.</td>
<td><input type="text" name="a28" id="a28" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">29</td>
<td width="75%">________ car is this? It's mine.</td>
<td><input type="text" name="a29" id="a29" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">30</td>
<td width="75%">My house is quite ________ long way from the station.</td>
<td><input type="text" name="a30" id="a30" required></td>
</tr>
<tr>
<td colspan="2" align="right" with="80%"><strong>Total</strong></td>
<td> </td>
</tr>
</table>
<br />
<table class="table table-bordered">
<tr>
<td width="5%" style="font-weight:bold;">31</td>
<td width="75%">I wish somebody ________ answer the phone.</td>
<td><input type="text" name="a31" id="a31" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">32</td>
<td width="75%">I ________ be driving to the conference... the car’s being serviced.</td>
<td><input type="text" name="a32" id="a32" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">33</td>
<td width="75%">It was ________ a good book that I couldn’t put it down.</td>
<td><input type="text" name="a33" id="a33" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">34</td>
<td width="75%">You ________ better take a taxi or you’ll miss the plane.</td>
<td><input type="text" name="a34" id="a34" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">35</td>
<td width="75%">If ________ I had a new car!</td>
<td><input type="text" name="a35" id="a35" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">36</td>
<td width="75%">He congratulated her ________ passing the exam.</td>
<td><input type="text" name="a36" id="a36" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">37</td>
<td width="75%">I'm just like my sister. I take ________ her in every way.</td>
<td><input type="text" name="a37" id="a37" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">38</td>
<td width="75%">The picnic ________ to be cancelled yesterday because of the bad weather.</td>
<td><input type="text" name="a38" id="a38" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">39</td>
<td width="75%">He eats nothing ________ hamburgers!</td>
<td><input type="text" name="a39" id="a39" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">40</td>
<td width="75%">We ________ have hurried to catch the train - we arrived much too early.</td>
<td><input type="text" name="a40" id="a40" required></td>
</tr>
<tr>
<td colspan="2" align="right" with="80%"><strong>Total</strong></td>
<td> </td>
</tr>
</table>
<br />
<table class="table table-bordered">
<tr>
<td width="5%" style="font-weight:bold;">41</td>
<td width="75%">Stevenson is an architect ________ designs have won international praise.</td>
<td><input type="text" name="a41" id="a41" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">42</td>
<td width="75%">________ he told you, he was wrong!</td>
<td><input type="text" name="a42" id="a42" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">43</td>
<td width="75%">On Saturdays, when I was a child, we ________ get up early and go swimming.</td>
<td><input type="text" name="a43" id="a43" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">44</td>
<td width="75%">I'd ________ stay at home than go to work!</td>
<td><input type="text" name="a44" id="a44" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">45</td>
<td width="75%">You can't travel on this train ________ you have a ticket.</td>
<td><input type="text" name="a45" id="a45" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">46</td>
<td width="75%">I had no ________ lit the barbecue than it started to rain.</td>
<td><input type="text" name="a46" id="a46" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">47</td>
<td width="75%">Paul was left £40,000 in his father's will, so he set himself ________ as a photographer.</td>
<td><input type="text" name="a47" id="a47" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">48</td>
<td width="75%">It looks ________ if it's going to rain.</td>
<td><input type="text" name="a48" id="a48" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">49</td>
<td width="75%">Thank you for your letter, ________ came yesterday.</td>
<td><input type="text" name="a49" id="a49" required></td>
</tr>
<tr>
<td width="5%" style="font-weight:bold;">50</td>
<td width="75%">He's the kind of friend who'll stand ________ you through thick and thin.</td>
<td><input type="text" name="a40" id="a50" required></td>
</tr>
<tr>
<td colspan="2" align="right" with="80%"><strong>Total</strong></td>
<td> </td>
</tr>
</table>
<div style="text-align:right;">
<input type="reset" value="Reset Test" class="btn btn-danger"/>
<a href="http://www.english-in-york.co.uk" class="btn btn-info">Help</a>
<input type="submit" name="submit" id="submit" value="Submit Test" class="btn btn-success"/>
</div>
</form>
<hr />
© www.english-in-york.co.uk 2013.
</div>
</body>
</html>
最佳答案
除了学习 MySQL，尽量减少使用数组和循环的代码。这是每个程序员的基础。
关于php - 将 PHP 用户输入与 mysqli 数据库进行比较，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/17041702/
24
4
0
我在 JavaScript 文件中运行 PHP，例如...... var = '';). 我需要使用 JavaScript 来扫描字符串中的 PHP 定界符(打开和关闭 PHP 的 )。 我已经知道使
我希望能够做这样的事情: php --determine-oldest-supported-php-version test.php 并得到这个输出: 7.2 也就是说，php 二进制检查 test.
我正在开发一个目前不使用任何框架的大型 php 站点。我的大问题是，随着时间的推移慢慢尝试将框架融入应用程序是否可取，例如在创建的新部件和更新的旧部件中？ 比如所有的页面都是直接通过url服务的，有几
下面是我的源代码，我想在同一页面顶部的另一个 php 脚本中使用位于底部 php 脚本的变量 $r1。我需要一个简单的解决方案来解决这个问题。我想在代码中存在的更新查询中使用该变量。 $name)
我正在制作一个网站，根据不同的情况进行大量 PHP 重定向。就像这样...... header("Location: somesite.com/redirectedpage.php"); 为了安全起见
我有一个旧网站，我的 php 标签从 因为短标签已经显示出安全问题，并且在未来的版本中将不被支持。 关于php - 如何避免在 php 文件中写入
我有一个用 PHP 编写的配置文件，如下所示， 所以我想用PHP开发一个接口(interface)，它可以编辑文件值，如$WEBPATH , $ACCOUNTPATH和 const值(value)观
我试图制作一个登录页面来学习基本的PHP，首先我希望我的独立PHP文件存储HTML文件的输入(带有表单)，但是当我按下按钮时(触发POST到PHP脚本) )我一直收到令人不愉快的错误。 我已经搜索了S
我正在寻找一种让 PHP 以一种形式打印任意数组的方法，我可以将该数组作为赋值包含在我的(测试)代码中。 print_r 产生例如: Array ( [0] => qsr-part:1285 [1]
这个问题已经有答案了: 已关闭11 年前。 Possible Duplicate: What is the max key size for an array in PHP? 正如标题所说，我想知道
我正在寻找一种让 PHP 以一种形式打印任意数组的方法，我可以将该数组作为赋值包含在我的(测试)代码中。 print_r 产生例如: Array ( [0] => qsr-part:1285 [1]
关闭。这个问题需要多问focused 。目前不接受答案。 想要改进此问题吗？更新问题，使其仅关注一个问题 editing this post . 已关闭 9 年前。 Improve this ques
我在 MySQL 数据库中有一个表，其中存储餐厅在每个工作日和时段提供的菜单。 表结构如下: i_type i_name i_cost i_day i_start i_
我有两页。 test1.php 和 test2.php。 我想做的就是在 test1.php 上点击提交，并将 test2.php 显示在 div 中。这实际上工作正常，但我需要向 test2.php
我得到了这个代码。我想通过textarea更新mysql。我在textarea中回显我的MySQL，但我不知道如何更新它，我应该把所有东西都放进去吗，因为_GET模式没有给我任何东西，我也尝试_GET
首先，我是 php 的新手，所以我仍在努力学习。我在 Wordpress 上创建了一个表单，我想将值插入一个表(data_test 表，我已经管理了)，然后从 data_test 表中获取所有列(id
我有以下函数可以清理用户或网址的输入: function SanitizeString($var) { $var=stripslashes($var); $va
我有一个 html 页面，它使用 php 文件查询数据库，然后让用户登录，否则拒绝访问。我遇到的问题是它只是重定向到 php 文件的 url，并且从不对发生的事情提供反馈。这是我第一次使用 html、
我有一个页面充满了指向 pdf 的链接，我想跟踪哪些链接被单击。我以为我可以做如下的事情，但遇到了问题: query($sql); if($result){
我正在使用 从外部文本文件加载 HTML/PHP 代码 $f = fopen($filename, "r"); while ($line = fgets($f, 4096)) { print $l
我是一名优秀的程序员,十分优秀！