php - 无法将数据保存到具有复合主键的新表中

Question

代码

require_once 'detect/detect.php';
date_default_timezone_set('Asia/Kuala_Lumpur');

$fb_id = $_POST['id'];
$full_name = $_POST['name'];
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$email = $_POST['email'];
$date_time = date('Y-m-d H:i:s');
$shared = null;
$redeemed = null;

$connection = mysqli_connect("server", "username", "password", "db");

$sql = "INSERT IGNORE INTO ABC_CAFE (fb_id, full_name, first_name, last_name, email, date_time, shared, redeemed) VALUES ('$fb_id','$full_name','$first_name','$last_name','$email','$date_time','$shared','$redeemed')";

mysqli_close($connection);

我的表创建时没有数据。主键是(fb_id,date_time)，它没有出现在结构中。

Answer 1

干净的方法:

$mysqli = new mysqli("server", "username", "password", "db");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connectiuon Error: %s\n", mysqli_connect_error());
    exit();
}

$stmt = $mysqli->prepare("INSERT IGNORE INTO ABC_CAFE (fb_id, full_name, first_name, last_name, email, date_time, shared, redeemed)  VALUES (?, ?, ?, ?, ?, ?, ?, ?)");

$stmt->bind_param('isssssss', $fb_id, $full_name, $first_name, $last_name, $email, $date_time, $shared, $redeemed);

/* execute prepared statement */
$stmt->execute();

$mysqli->close();