John Davidson

Message:

How to use an if statement in mySql for example
I have this code

INSERT INTO covidtest ( covidTestResult ,CovidTestDate, Idnumber ) VALUES (?,?,? )

this will insert user's covidTest
I want to use an if statement if user has tested in 14 days

It shouldn't insert it again

thanks in advance

---

My Answer:
You can achieve this by first checking if the user has already tested within the last 14 days before inserting a new record. You can do this by running a SELECT query to check if there is already a record for the user within the last 14 days.

Here is an example of how you can achieve this:

php
// Assuming $conn is your database connection

// Check if user has tested in the last 14 days
$checkQuery = "SELECT * FROM covidtest WHERE Idnumber = ? AND CovidTestDate >= DATE_SUB(NOW(), INTERVAL 14 DAY)";
$stmt = $conn->prepare($checkQuery);
$stmt->bind_param("s", $Idnumber);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows > 0) {
// User has already tested in the last 14 days
echo "User has already tested in the last 14 days";
} else {
// User has not tested in the last 14 days, insert new record
$insertQuery = "INSERT INTO covidtest (covidTestResult, CovidTestDate, Idnumber) VALUES (?, ?, ?)";
$stmt = $conn->prepare($insertQuery);
$stmt->bind_param("sss", $covidTestResult, $CovidTestDate, $Idnumber);

// Assign values to $covidTestResult, $CovidTestDate, $Idnumber before executing the query

$stmt->execute();
echo "Covid test inserted successfully";
}

$stmt->close();
$conn->close();


In this code snippet, we first check if there is already a record for the user within the last 14 days using a SELECT query. If a record is found, we display a message indicating that the user has already tested in the last 14 days. If no record is found, we proceed to insert a new record using an INSERT query.

Make sure to replace placeholders like `$Idnumber`, `$covidTestResult`, and `$CovidTestDate` with actual values before executing the queries.