問題描述

我想將輸入到 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]')";
?>

post.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>

我的數據庫posts"表列:

my db "posts" table colums:

pid
title
contents
tags
category

pid 開啟了 auto_increment

我已經嘗試以正確"的順序向所有列發送值，包括 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)的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！