PHP MySQL不插入任何数据。 没有错误[重复]

Question

This question already has an answer here:

• When to use single quotes, double quotes, and backticks in MySQL 12 answers

I'm not sure why it's not inserting any data. No errors are returned.

I'm new in the mysql scene so i might be doing something wrong..

Do you guys mind pointing me towards the right direction?

$link = mysqli_connect("localhost", "root", "", "testdatabase");

    if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}


else if ($command == 'create-key'){

  $keys = $_GET['nkey'];

    if (empty($_GET['nkey'])){
      print('Error: No key specified to create!');
      die();
    }

    print ('Key '. $_GET['nkey'] .' has been created.');

    $sql = ("INSERT INTO `keys` (`key`, `status`) VALUES ('. $keys .', 0)");

}

SQL Code:

CREATE TABLE `keys` (
  `key` varchar(15) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

</div>

Answer 1

There is no need of ()

Change Query From

$sql = ("INSERT INTO `keys` (`key`, `status`) VALUES ('. $keys .', 0)");

To

$sql = "INSERT INTO `keys` (`key`, `status`) VALUES ('$keys', 0)";

And then Execute this Query