$stmt = $conn->prepare("
    INSERT INTO SNPs
    (
        rsname,
        gene,
        allel,
        citation,
        population,
        phenotype,
        fasta
    )
    VALUES
    (
        ?, ?, ?, ?, ?, ?, ?
    )
");

$stmt->bind_param(
    "sssiiss",
    $rsname,
    $gene,
    $allel,
    $citation,
    $population,
    $phenotype,
    $fasta
);

$stmt->execute();

$new_id = $conn->insert_id;

$stmt->close();