Muller Digital | Web Development

Spam all pending comments SQL statment

nick — Mon, 23 Apr 2012 17:55:30 +0000

SQL code to change all pending comments to spam:
UPDATE `wp_comments` SET `comment_approved`='spam' WHERE `comment_approved` = 0;

If you’re not using Akismet, and you’ve let your pending, most likely “spam” comments, pile-up; the above SQL code will help convert all pending comments to spam.

So comments like:

What an insightful idea has been written here. Truly sharing this will my friends website for trackback linkjuice ranking will be an amazing thank-you!!!

Will never see the light of day. ;)

Social Media Icons: RSS, Facebook, Twitter, Tumblr…

nick — Thu, 29 Mar 2012 18:57:17 +0000

Best collection of icons for Social Network services:
http://www.komodomedia.com/download/#social-network-icon-pack

Replace HTML tags with PHP

nick — Wed, 21 Mar 2012 20:46:55 +0000

preg_replace('@< (iframe|script|noscript)\b.*?>.*?@si', '', $string);
Removes iframe, script and noscript tags and contents from $string.
Performs an inverted version of strip_tags function.

Great set of fonts for free

nick — Thu, 01 Mar 2012 17:12:40 +0000

http://www.losttype.com/browse/

http://www.google.com/webfonts

MySQL remove duplicates

nick — Fri, 09 Dec 2011 17:27:48 +0000

DELETE n1 FROM table n1, table n2 WHERE n1.id > 10000 AND n1.id < 11000 AND n1.id > n2.id AND n1.EMAIL = n2.EMAIL;

The above MySQL query will delete duplicate email addresses between the id’s 10000 and 11000. Breaking the query into blocks of 1000 id’s will reduce strain the MySQL server.

MySQL find duplicates

nick — Fri, 09 Dec 2011 17:23:08 +0000

select EMAIL, count(EMAIL) as cnt from TABLE group by EMAIL having cnt > 1 ORDER BY `cnt` DESC

The above MySQL query will find and list the number of multiple duplicate emails in a table.

Search web by image

nick — Mon, 28 Nov 2011 15:45:30 +0000

http://www.tineye.com/ allows you to search the web for similar images to ones uploaded or on the web.

UPDATE: Google has this as well: http://www.google.com/insidesearch/searchbyimage.html

Generate / Create QRcode 2D barcodes ( primarily QRcodes ) in raster and vector formats

nick — Wed, 19 Oct 2011 06:16:21 +0000

www.qrstuff.com ? You can generate QR Codes (the most popular 2D barcode) for Website URL, YouTube Video, Google Maps Location, Social Media, iTunes Link, Plain Text, Telephone Number, SMS Message, Email Address, Email Message, Contact Details (VCARD), Event (VCALENDAR), Wifi Login (Android Only), Paypal Buy Now Link. With QRstuff.com you to change colour of the positive QR Code shapes (the dark part).
qrcode.littleidiot.be ? You can generate QR Codes for Regular text, Hyperlink, Phone number, Email address, meCard, vCard, WiFi settings. There is also the option to download the QR Code in multiple formats, particularly vector based formats. QR Stuff only does raster (bitmap) formats.

PHP imagick – website references, manuals and information

nick — Wed, 07 Sep 2011 18:10:45 +0000

imagick is a more advanced graphics library than the default GD for PHP, but the ImageMagick PHP library imagick is only documented on PHP.net comments, so using the library can be a bit challenging, but the sites above help in using the library.

Multiple MySQL query with PHP

nick — Tue, 31 May 2011 15:55:05 +0000

// Enter multiple query string $query_str = " -- Update table UPDATE t SET id = id + 1; -- Insert into table INSERT INTO example (name, age) VALUES('John Doe', '23' ); "; // Explode string into separate queries $query = explode(';',$query_str); // Loop through exploded queries and execute foreach($query as $index => $sql) { $result = mysql_query($sql,$conn2) or userDisplayMessage(mysql_error().' '.__FILE__.':'.__LINE__); }
Or, you can use mysqli (MySQL Improved extension), which has a mysqli_multi_query function.