Skip to content

Instantly share code, notes, and snippets.

@johnmorris
Created December 15, 2014 15:45
Show Gist options
  • Save johnmorris/2a24cab89a5f1f6875ad to your computer and use it in GitHub Desktop.
Save johnmorris/2a24cab89a5f1f6875ad to your computer and use it in GitHub Desktop.
DELETE data in a MySQL database with PHP using PDO and MySQLi
<?php
// Be sure to input YOUR database details below
// Watch the associated videos here: https://www.youtube.com/playlist?list=PLLs69n7Q4dCx5_7ZwnxTymH8X0iRP_2vw
$db_user = 'DB USERNAME HERE';
$db_pass = 'DB PASSWORD HERE';
$db_name = 'DB NAME HERE';
$db_host = 'localhost';
$query = "DELETE FROM objects
WHERE ID = 7";
// MySQLi
$mysqli = new mysqli($db_host, $db_user, $db_pass, $db_name);
if ($mysqli->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}
$result = $mysqli->query($query);
print_r($result);
// PDO
//try {
// $conn = new PDO("mysql:host={$db_host};dbname={$db_name}", $db_user, $db_pass);
// $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// $result = $conn->query($query);
//
// print_r($result);
//} catch(PDOException $e) {
// echo 'ERROR: ' . $e->getMessage();
//}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment