Skip to content

Instantly share code, notes, and snippets.

Delete stuff:
try{
$statement = $db->prepare('TRUNCATE tablename'); //tablename er navnet på det table der indeholder wordpress stuff
$statement->execute();
}
catch(PDOException $e) {
echo 'ERROR: '.$e->getMessage();
}
step 1:
Connect to db:
$dsn = 'mysql:dbname=Database_Name;host=IP_Address';
$user = 'Username';
$pass = 'Password';
try {
$db = new PDO($dsn, $user, $pass);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}

Keybase proof

I hereby claim:

  • I am asselberghs on github.
  • I am asselberghs (https://keybase.io/asselberghs) on keybase.
  • I have a public key whose fingerprint is 4583 6B8C 6443 900C EDE5 6FFD 5F52 CA01 6DBD BD3D

To claim this, I am signing this object:

@Asselberghs
Asselberghs / connect.php
Created August 4, 2015 10:16
Connecting to a MySQL Database Using PDO.
<?php
$dsn = 'mysql:dbname=Database_Name;host=IP_Address';
$user = 'Username';
$pass = 'Password';
try {
$db = new PDO($dsn, $user, $pass);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e) {
die('Could not connect to database:<br />' . $e->getMessage());
<?php
//Wrap your executes in
try {
$stmt->execute();
}
catch(PDOException $e) {
echo "Error: " .$e->getMessage()
}
?>