How can auto-incremented IDs be effectively utilized in PHP when storing recipe data?

When storing recipe data in a database, auto-incremented IDs can be effectively utilized to uniquely identify each recipe entry. This allows for easy retrieval and manipulation of specific recipes within the database. By using auto-incremented IDs, you can ensure that each recipe has a unique identifier, making it easier to manage and organize the data. 

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "recipes";

$conn = new mysqli($servername, $username, $password, $dbname);

// Insert a new recipe into the database
$title = "Spaghetti Carbonara";
$description = "A classic Italian pasta dish";
$instructions = "Cook spaghetti, mix with eggs, cheese, and pancetta";
$category = "Italian";

$sql = "INSERT INTO recipes (title, description, instructions, category) VALUES ('$title', '$description', '$instructions', '$category')";

if ($conn->query($sql) === TRUE) {
    $recipe_id = $conn->insert_id;
    echo "New recipe created successfully. Recipe ID is: " . $recipe_id;
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

// Close the database connection
$conn->close();

Keywords

auto-increment IDs PHP storing data recipe

Related Questions