Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --
- -- Insert sample
- --
- $sql = "INSERT INTO movies(filmName,
- filmDescription,
- filmImage,
- filmPrice,
- filmReview) VALUES (
- :filmName,
- :filmDescription,
- :filmImage,
- :filmPrice,
- :filmReview)";
- $stmt = $pdo->prepare($sql);
- $stmt->bindParam(':filmName', $_POST['filmName'], PDO::PARAM_STR);
- $stmt->bindParam(':filmDescription', $_POST['filmDescription'], PDO::PARAM_STR);
- $stmt->bindParam(':filmImage', $_POST['filmImage'], PDO::PARAM_STR);
- // use PARAM_STR although a number
- $stmt->bindParam(':filmPrice', $_POST['filmPrice'], PDO::PARAM_STR);
- $stmt->bindParam(':filmReview', $_POST['filmReview'], PDO::PARAM_STR);
- $stmt->execute();
- --
- -- Getting Auto Increment Key Values with lastInsertId()
- --
- $stmt->execute();
- $newId = $pdo->lastInsertId();
- --
- -- UPDATE
- --
- $sql = "UPDATE movies SET filmName = :filmName,
- filmDescription = :filmDescription,
- filmImage = :filmImage,
- filmPrice = :filmPrice,
- filmReview = :filmReview
- WHERE filmID = :filmID";
- $stmt = $pdo->prepare($sql);
- $stmt->bindParam(':filmName', $_POST['filmName'], PDO::PARAM_STR);
- $stmt->bindParam(':filmDescription', $_POST['$filmDescription'], PDO::PARAM_STR);
- $stmt->bindParam(':filmImage', $_POST['filmImage'], PDO::PARAM_STR);
- // use PARAM_STR although a number
- $stmt->bindParam(':filmPrice', $_POST['filmPrice'], PDO::PARAM_STR);
- $stmt->bindParam(':filmReview', $_POST['filmReview'], PDO::PARAM_STR);
- $stmt->bindParam(':filmID', $_POST['filmID'], PDO::PARAM_INT);
- $stmt->execute();
- --
- -- DELETE
- --
- $sql = "DELETE FROM movies WHERE filmID = :filmID";
- $stmt = $pdo->prepare($sql);
- $stmt->bindParam(':filmID', $_POST['filmID'], PDO::PARAM_INT);
- $stmt->execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement