PHP没有插入表格

I'm having trouble getting a practice signup form to submit data to my database ...

<!DOCTYPE HTML> 
<html>
<head>
</head>
<body> 

<?php
$name = $email = $password = "";
?>

<form method="post"> 
Name: <input type="text" name="name">
<br><br>
E-mail: <input type="text" name="email">
<br><br>
Password: <input type="text" name="password">
<br><br>
<input type="submit" value="Submit" name="submit">
</form>

<?php
if(isset($_POST['submit'])){
    $name = fix_input($_POST["name"]);
    $email = fix_input($_POST["email"]);
    $password = fix_input($_POST["password"]);
    mysqli_connect("localhost","username","password","dbname") or                 die(mysql_error()); 
    mysql_query("INSERT INTO ('username','password') VALUES ('$name', md5('$password'))"); 
    Print "You've been signed up successfully"; } 


function fix_input($data)
{   
    $data = trim($data);
    $data = stripslashes($data);
    $data = htmlspecialchars($data);
    return $data;
}
?>

</body>
</html>

展开全部

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

4条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
douwei9759 2014-01-12 17:11
关注
In addition to Ugur's answer, you are mismatching mysqli commands and mysql commands. Here's how to do this in an object oriented fashion:

// create mysqli database object $mysqli = new mysqli_connect("localhost","username","password","database"); // store your query in a variable. question marks are filled by variables $sql = "INSERT INTO table_name ('username','password') VALUES (?,?)"; // prepare command uses $sql variable as query $stmt = mysqli->prepare($sql); // "ss" means your 2 variables are strings, then you pass your two variables. $stmt->bind_param("ss",$name,md5($password)); // execute does as it seems, executes the query. $stmt->execute(); // then print your success message here.

Using prepared statements removes the need to sanitize user input, as harmful input is not substituted into the query directly. For more reading:

http://www.php.net/manual/en/mysqli.quickstart.prepared-statements.php

There are some good tips for using prepared statements in many different scenarios, as well as towards the bottom, there is an explanation on how prepared statements prevent SQL injection.
本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报
编辑

预览
轻敲空格完成输入
显示为

卡片

标题

链接
评论

按下Enter换行，Ctrl+Enter发表内容

查看更多回答(3条)

编辑

预览

报告相同问题？

关注问题

如何用php追加HTML表格？ html jquery php
2017-05-08 19:29

回答 4 已采纳 Remove the function barcodeenter() and replace with document.getElementById("pos_data").reset();
PHP简单插入表格数据到数据库不工作[关闭] mysql php sql
2013-11-03 09:50

回答 2 已采纳 First off, you've not escaped any of your data. If I were to post to your form "Let's have a party
从PHP中发布数据并插入表格[关闭] php
2012-03-21 22:44

回答 2 已采纳 I think your query statement will be like this $query = "INSERT into AppointmentDataSync (P
PHPWord在文档中插入表格
2022-10-19 01:18

最帅的李bb的博客 phpword插入表格
为什么不能插入mysql的表格？ mysql php
2022-10-09 08:50

回答 3 已采纳中文括号吧
如何在php中将动态表单值插入数据库 php
2018-07-22 23:36

回答 1 已采纳 You need to loop through the arrays. You can use the menu id as the key as it is sequential e.g. t
PHP MySQLi在表中插入了太多行 html php
2017-11-18 06:51

回答 4 已采纳 mysqli_stmt_execute return true or false, assign the returned value to a var (more info http://php
phpword模板替换并插入表格
2021-03-03 07:05

weixin_44056947的博客 //use PhpOffice\PhpWord\Element\Table; //use PhpOffice\PhpWord\SimpleType\TblWidth; //use PhpOffice\PhpWord\TemplateProcessor; //——————————————————————————————————...
特殊条件不满意时如何插入表格 mysql php
2016-09-17 01:56

回答 1 已采纳 Because shp_postmeta has an auto_increment PK you can execute: INSERT INTO shp_postmeta SELECT
获取下拉值然后将其插入表格内的文本框，但不会更改第二行 javascript mysql php
2018-10-23 00:57

回答 1 已采纳 My suspicion is that you are only targeting a specific id in your javascript, and that you might b
信息未插入表格 database mysql php
2015-08-30 10:51

回答 2 已采纳 //change your database name put this code and check it <?php // define variables and set to
php中插入表格标签,列表，表格，添加表单及标签用法-2019.9.1
2021-04-12 12:24

Dr.Blaine的博客 3.列表与表格的区别与联系?什么时候用列表,什么时候用表格,为什么?4.编程实现,用列表制作你的工作计划,要求使用三种类型全部实现一次:5.编程实现一张商品清单,使用表格实现,要求有行与列的合并,用到colspan,rowspan6...
php生成PDF电子合同签名
2022-03-15 08:16

3. **插入签名**：使用FPDI库，将生成的签名图像插入到PDF合同的适当位置。这可以通过设置坐标和大小来完成。 4. **保存和加密**：完成签名后，PDF文档需要被保存，并可以选择性地进行加密，以确保文件的安全性和...
最新PHPword整合，优化添加导出表格，表格内部换行，合并单元格
2018-09-04 08:43

这个最新的PHPword整合主要关注了表格的处理，包括添加表格、行内换行以及单元格的合并，这些都是在处理复杂文档时非常重要的功能。下面将详细介绍这些知识点。首先，`PHPWord` 是一个用PHP编写的开源库，它允许...
php+tcpdf+表格,php 绘制 pdf表格
2021-03-25 03:07

weixin_42138139的博客 require_once('tcpdf/config/lang/eng.php');require_once('tcpdf/tcpdf.php');// create new PDF document$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);// set docum...
没有解决我的问题, 去提问

PHP没有插入表格

4条回答 默认 最新

4条回答默认最新