Html PHP表单不写入SQL DB [英] Html PHP form not writing to SQL DB

问题描述

您好



我创建了一个链接到某些PHP代码的HTML表单，以便将字段写入SQL DB，但它不起作用？任何人都可以查看我的代码并让我知道你是否能找到任何原因导致它不起作用？



HTML表格

Hi There

I have created an HTML form linked to some PHP code to write fields to a SQL DB but it does'nt work ? Can anyone have a look at my code and let me know if you can find any reason why it would not work ?

HTML FORM

<h1>Create Your Account</h1>
      
      <div class="namef">
      Name: <br><br> </div>
      <div class="surnamef">
      Surname: <br><br></div>
      <div class="emailf">
      Email: <br><br> </div>
      <div class="passwordf">
      Password: <br><br></div>

PHP代码

PHP Code

<?php

define('DB_NAME','Mydbname');
define('DB_USER','Myusername');
define('DB_PASSWORD','Mpassword');
define('DB_HOST','Myhost');

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

$db_selected = mysql_select_db (DB_NAME, $link) ;

$Name = $_POST['Name'];
$Surname = $_POST['Surname'];
$Email = $_POST['Email'];
$Password = $_POST['Password'];

$sql = "INSERT INTO Users (Name,Surname,Email,Password) VALUES ('".$Name."','".$Surname."',
'".$Email."','".$Password."')";

$link->query($sql);

mysql_close($link)

?>

我尝试过：



请参阅问题描述部分中的代码。这就是我试过的。

What I have tried:

Please see my code in problem descriptions section. This is what i have tried.

推荐答案

link = mysql_connect（DB_HOST，DB_USER，DB_PASSWORD）;

link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

db_selected = mysql_select_db（ DB_NAME，

db_selected = mysql_select_db (DB_NAME,

link）;

这篇关于Html PHP表单不写入SQL DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！