通过PHP发送html格式数据到sql数据库(使用mysqli) [英] Send html form data to sql database via php (using mysqli)
问题描述
我想将输入的数据以html格式发送到我的sql数据库,即创建一个将某些值赋予特定列的新行。我知道有类似的问题,我读了答案,但似乎没有任何工作。
I want to send the data inputted into an html form to my sql database, i.e., create a new row attributing certain values to certain columns. I know there are similar questions, I read the answers but nothing seems to work.
send_post.php
send_post.php
<?php
//Connecting to sql db.
$connect = mysqli_connect("my host","my user","my passwrod","my db");
//Sending form data to sql db.
mysqli_query($connect,"INSERT INTO posts (category, title, contents, tags)
VALUES ('$_POST[post_category]', '$_POST[post_title]', '$_POST[post_contents]', '$_POST[post_tags]')";
?>
html#form
post.html#form
<form onSubmit="send_post.php" method="post">
<h3>Category:</h3>
<input type="text" name="post_category">
<h3>Post title:</h3>
<input type="text" name="post_title">
<h3>Post tags (a,b,c...):</h3>
<input type="text" name="post_tags">
<h3>Post (use html):</h3>
<textarea rows="20" cols="50" name="post_contents"></textarea>
<input type="submit">
</form>
my dbposts表colums:
my db "posts" table colums:
pid
title
contents
tags
category
pid
has auto_increment
on
将值发送到所有分支,包括 pid
,并以正确的顺序发送。
I have already tried sending values to all colunes, including pid
, and in the "right" order.
mysqli_connect
部分不是问题,因为我从我的另一个.php文件复制它。
The mysqli_connect
part isn't the issue since I copied it from a different .php file of mine that works.
服务器php-sql兼容性也不是问题,因为我成功地有一个不同的.php文件从数据库中检索数据(手动插入数据)。
Server php-sql compatibility isn't the issue either, since I successfully had a different .php file retrieve data from the db (data which was manually inserted).
推荐答案
改变这个
<form onSubmit="send_post.php" method="post">
至
<form action="send_post.php" method="post">
这篇关于通过PHP发送html格式数据到sql数据库(使用mysqli)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!