Our Blog

How to get and display wordpress comment details.

With wordpress sometimes we might like to output details to a seperate page or even outside of our wordpress folder. The following code is an example of how to grab the details for your comment details. I recently learned this to use it in my personal dashboard so that I could see new comments without

How to create a new database with PHP & PDO

Creating a new databse with PHP and PDO : <?php // Hosting details $host=”localhost”; $root=”root”; $root_password=”rootpass”; // New database user, password & database name $user=’newuser’; $pass=’newpass’; $db=”newdb”; // Create database connnection try { $dbh = new PDO(“mysql:host=$host”, $root, $root_password); // Exectute $dbh->exec(“CREATE DATABASE `$db`; CREATE USER ‘$user’@’localhost’ IDENTIFIED BY ‘$pass’; GRANT ALL ON `$db`.* TO

PDO code to show all databases

Showing a list of all the databases using PHP and PDO. <?php $user = ‘root’; $pass = ‘password’; $server = ‘localhost’; $dbh = new PDO( “mysql:host=$server”, $user, $pass ); $dbs = $dbh->query( ‘SHOW DATABASES’ ); while( ( $db = $dbs->fetchColumn( 0 ) ) !== false ) { echo $db.’ ‘; } ?> Will out a

Stripping linux weezy raspbian Part 2

This is part 2 of Stripping linux weezy raspian Lets strip some more stuff out. 🙂 sudo apt-get remove -purge xdg-utils sudo apt-get remove -purge x11.* sudo apt-get remove -purge scratch sudo apt-get remove -purge xserver.* sudo apt-get remove -purge xarchiver sudo apt-get remove -purge xinit sudo apt-get remove -purge lightdm sudo apt-get remove -purge

Stripping linux weezy raspbian

I came across a post about stripping down a raspberry pi version of linux :  Stripping Linux Raspbian so I wonder how far can you go in your stripping before it breaks ? 🙂 lets find out shall we .. Lets go to work shrinking that further and cleaning some stuff up .. sudo apt-get