php使用insert语句添加到数据库

Question

我有一个简单的插入语句，应该使用包含我的连接字符串的 $GLOBALS。问题是它不插入数据。我这样做正确吗？

插入.php

<?php
require 'core/init.php';

$Name = $_REQUEST["Name"];
$Venue = $_REQUEST["Venue"];
$Category = $_REQUEST["Category"];

$query = "INSERT INTO bands (Name, Venue, Category)
          VALUES ('$Name', '$Venue', '$Category')";
mysql_query ($query,$GLOBALS)
    or die ("could not add to database");

echo("You have added: <br />");
$result = mysql_query("SELECT * FROM bands ORDER  BY  Band_id DESC LIMIT 1");

while($row = mysql_fetch_array($result))
{
    echo $row['Name']. "" . $row['Venue']. "" . $row['Category'];
    echo "<br />";
}
?>

Answer 1

您需要使用mysql_connect()函数连接mysql，然后使用mysql_select_db()函数选择数据库，然后您可以调用mysql_query函数

您无法使用查询字符串参数执行查询，您需要先执行该连接查询，然后选择您的数据库

And i suggest you to use mysqli instead of mysql cuz mysql methods will be deprecated soon