Muller Digital | Web Programming

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.

Secure Google search – encrypted search string and url

nick — Mon, 16 May 2011 19:03:58 +0000

https://encrypted.google.com/
If you want to search Google securely, over an encrypted connection, use the above link.
This prevents your search from being seen by anyone but you and Google, that includes your ISP.
Resources:

Remove .DS_Store from zip files

nick — Sat, 26 Mar 2011 20:47:29 +0000

Open Terminal (/Applications/Utilities/Terminal)
zip -d file.zip \*.DS_Store
That will remove all .DS_Store files from the zip archive.

Generate CSR file for GoDaddy SSL certificate in OSX, using terminal command line and openssl

nick — Thu, 20 Jan 2011 07:11:37 +0000

This works for generating CSR files required by GoDaddy SSL certificates. This will work with more than just GoDaddy SSL certificates, you can even sign your own certificates.
$ openssl genrsa -des3 -out domain.key 2048
You will now have to enter a passphrase
$ openssl req -new -key domain.key -out domain.csr
You will now have to re-enter your passphrase to confirm, and then you will be prompted to enter all your information.
Enter the domain name you are registering this certificate for when it prompts you:
Common Name (eg, YOUR name) []

You will now have the CSR file you need to send to the signing authority to issue you your certificate.

Here is the code to generate the CRT file ( if you’re not using GoDaddy and you want to sign your own )
openssl x509 -req -days 365 -in domain.csr -signkey domain.key -out domain.crt

Duplicate row in MySQL

nick — Wed, 08 Dec 2010 22:06:46 +0000

INSERT INTO `table` (`col1`, `col2`, `col3`, `col4`) SELECT `col1`, `col2`, `col3`, `col4` FROM `table` WHERE `id`=1;
`id` can be anything unique.