<?php
$db_conn = new PDO('mysql:host=localhost;dbname=recipes', 'root', 'pantel1s');
$pud = "Pudding";
try {
$db_conn->beginTransactio();
$SQL = 'UPDATE categories SET id=17 WHERE name=? ';
$stmt = $db_conn->prepare($SQL);
$stmt->bindParam(1, $pud);
$stmt->execute();
$lastID = $db_conn->lastInsertId();
$db_conn->commit();
} catch (PDOException $e) {
$db_conn->rollBack();
$error = $e->getMessage();
}
