如何在PHP中使用HTML表单中的变量？

I just want to receive the input from a HTML form in PHP. I did research for almost 2 hours trying every code I got, but it doesn't work. Here's my code:

HTML:

<!DOCTYPE html>
<html>
<head>
<title>Form site</title>
</head>
<body>
    <table width="300" border="0" align="center" cellpadding="0" cellspacing="1">
        <tr>
           <td>
              <form name="form1" method="post" action="connect.php">
              <table width="100%" border="0" cellspacing="1" cellpadding="3">
                 <tr>
                    <td colspan="3">Insert Data Into mySQL Database </td>
                 </tr>
                 <tr>
                    <td width="71">Name</td>
                    <td width="6">:</td>
                    <td width="301"><input name="name" type="text" id="name"></td>
                 </tr>
                 <tr>
                    <td>Lastname</td>
                    <td>:</td>
                    <td><input name="lastname" type="text" id="lastname"></td>
                 </tr>
                 <tr>
                    <td>Email</td>
                    <td>:</td>
                    <td><input name="email" type="text" id="email"></td>
                 </tr>
                 <tr>
                    <td colspan="3" align="center"><input type="submit" name="Submit" value="Submit"></td>
                 </tr>
              </table>
              </form>
           </td>
        </tr>
     </table></body>
</html>

PHP:

<?php
$mysqli = new mysqli("localhost", "root", "", "test");

if ($mysqli->connect_errno) {
    printf("Connect failed: %s
", $mysqli->connect_error);
    exit();
}
$tbl_name="employees"; // Table name

// Get values from form
$name = $_POST['name'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];


// if successfully insert data into database, displays message "Successful".
$sql = "INSERT INTO $tbl_name (name, lastname, email) VALUES ('$name', '$lastname', '$email')";
$mysqli->query($sql);
?>

So, when I run the HTML file in Chrome everything's normal, but if I then fill the form an click the Submit button Chrome says 'This page doesn't work'. The connection to the database works definitely. I read that it may help to set the AllowOverride option in the Apache config file (using XAMPP) to 'ALL'. It didn't. The filename specified in the HTML code matches the filename of the PHP file I'm actually using for this.

PHP is a server-side language, isn't it? So I suspect that I have to configure something to run the PHP file. PHP is already installed on my computer I checked the database connection using PHP in the command-line. Obviously I'm missing something. Does anyone have an idea?

Thanks in advance!

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

2条回答

普通网友 2019-08-07 14:26

关注

Solution: I used Apache as the webserver, but the HTML and PHP files were in another location, so PHP hadn't any webserver to run in.

Here's the working code: PHP:

?php
$mysqli = new mysqli("localhost", "root", "", "test");

if ($mysqli->connect_errno) {
    printf("Connect failed: %s
", $mysqli->connect_error);
    exit();
}
$tbl_name="employees"; // Table name

// Get values from form
$name = $_POST['name'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];

// if successfully insert data into database, displays message "Successful".
$sql = "INSERT INTO $tbl_name (name, lastname, email) VALUES (?, ?, ?)";
$statement = $mysqli->prepare($sql);
$statement->bind_param('sss', $name, $lastname, $email);

// $statement->execute();

if(!$statement->execute()) {
    echo "Query fehlgeschlagen: ".$statement->error;
}
else echo "All done!";

HTML:

<!DOCTYPE html>
<html>
<head>
<title>Form site</title>
</head>
<body>
    <table width="300" border="0" align="center" cellpadding="0" cellspacing="1">
       <tr>
       <td>
          <form name="form1" method="post" action="connect.php">
          <table width="100%" border="0" cellspacing="1" cellpadding="3">
             <tr>
                <td colspan="3">Insert Data Into mySQL Database </td>
             </tr>
             <tr>
                <td width="71">Name</td>
                <td width="6">:</td>
                <td width="301"><input name="name" type="text" id="name"></td>
             </tr>
             <tr>
                <td>Lastname</td>
                <td>:</td>
                <td><input name="lastname" type="text" id="lastname"></td>
             </tr>
             <tr>
                <td>Email</td>
                <td>:</td>
                <td><input name="email" type="text" id="email"></td>
             </tr>
             <tr>
                <td colspan="3" align="center"><input type="submit" name="Submit" value="Submit"></td>
             </tr>
           </table>
           </form>
        </td>
        </tr>
     </table></body>
</html>

本回答被题主选为最佳回答 , 对您是否有帮助呢?

查看更多回答(1条)

报告相同问题？

关注问题

如何在PHP中使用HTML表单中的变量？ html mysql php
2019-08-07 09:54

回答 2 已采纳 Solution: I used Apache as the webserver, but the HTML and PHP files were in another location, so
如何在echo php中的html表单中显示php变量详细信息？ html php
2018-07-19 07:16

回答 2 已采纳 <?php $var= "LOVE"; ?> <!DOCTYPE html> <html> <head> <title
如何使用php回显从文本框表单发布的变量？ html mysql php sql
2016-02-19 10:41

回答 3 已采纳 First, you are connecting to the database inside a foreach loop... this is bad, and will make your
js中如何获取php变量,js变量在PHP中怎么获取该变量？
2021-03-23 13:44

CRSTFNL的博客 JS是前端,PHP是后端,后端PHP要获取前端JS的变量,那前端JS可以通过AJAX传输数据给后端PHP.比如登录页面login.php:if (!defined('APP_ROOT')) define('APP_ROOT', './');require APP_ROOT.'include/common.php'; // ...
在简单的HTML PHP表单中从JQuery返回PHP变量 ajax jquery php
2019-02-11 18:32

回答 1 已采纳 So updating this in case someone stumbles upon similar. I managed using JQuery as following: get_
如何将会话变量传递到PHP中的表单？ php
2018-06-07 09:37

回答 1 已采纳 Just break out from the string and concatenate, like this: echo "<form method='POST' action='"
如何通过recaptcha检查HTML表单中的数据？ html javascript php
2019-06-03 10:30

回答 1 已采纳 I managed to solve this problem by changing server-side code like below, thanks to this Recaptcha
php中如何得到js中的变量,javascript-js变量在PHP中怎么获取该变量？
2021-04-26 13:17

女神会发光i的博客 (在一个页面)JS是前端,PHP是后端,后端PHP要获取前端JS的变量,那前端JS可以通过AJAX传输数据给后端PHP.比如登录页面login.php:js中通过post提交到后台:var data = {'param' : xxx};$.post(url,data,callba...
在PHP中获取HTML表单ID html php
2017-09-14 08:56

回答 2 已采纳 PHP can only access the values passed using POST/GET so you can't access the input IDs or form IDs
如何将html表单中的数组发送到php html5 php
2019-04-20 12:57

回答 2 已采纳 Input file elements never store in the $_POST array. You have to loop through the $_FILES array to
html表单下拉选项如何动态从mysql中获取 html mysql php
2022-07-07 13:02

回答 6 已采纳 1、修改 <!doctype html> <html> <head> <meta charset="utf-8" /> <titl
如何从一个php文件向另一个地址post数据，不用表单和隐藏的变量的
2021-01-21 15:33

可以使用以下函数来实现： <?php function posttohost($url, $data) { $url = parse_url($url); if (!$url) return “couldn’t parse url”; if (!isset($url[‘port’])) { $url[‘port’] = ...
在PHP / MySQL中使用下拉菜单预填充表单？ html5 mysql php
2016-10-30 04:28

回答 1 已采纳 I have managed to somewhat figure out the answer on my own. It's probably not the most ideal way o
web前端——HTML表单和PHP服务器端交互
2020-10-24 09:56

岁秋的博客 web交互---HTML表单和PHP程序1.表单介绍2.创建表单3.表单项1.提交按钮2.文本框3.密码框 1.表单介绍表单是一个包含表单元素的区域。表单的作用是搜集不同类型的用户输入，然后将用户信息提交给服务器。表单元素是...
PHP与Web页面交互 -PHP获取表单信息.ppt
2022-06-05 20:23

在PHP中，POST请求被封装到$_POST[]全局变量数组中，GET请求被封装到$_GET[]全局变量数组中，因此，$_POST[]、$_GET[]分别对应两种提交表单的方法。当表单以POST方法提交时，PHP脚本需要通过$_POST ["name" ]或$_...
没有解决我的问题, 去提问

悬赏问题

¥15 虚拟机打包apk出现错误
¥30 最小化遗憾贪心算法上界
¥15 用visual studi code完成html页面
¥15 聚类分析或者python进行数据分析
¥15 逻辑谓词和消解原理的运用
¥15 三菱伺服电机按启动按钮有使能但不动作
¥15 js，页面2返回页面1时定位进入的设备
¥50 导入文件到网吧的电脑并且在重启之后不会被恢复
¥15 （希望可以解决问题）ma和mb文件无法正常打开，打开后是空白，但是有正常内存占用，但可以在打开Maya应用程序后打开场景ma和mb格式。
¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝

码龄粉丝数原力等级 --

如何在PHP中使用HTML表单中的变量？

2条回答

码龄粉丝数原力等级 --

悬赏问题