http://www.simsekmert.com/wp Kişisel Web Blogu Sat, 24 Jul 2010 14:32:54 +0000 http://backend.userland.com/rss092 en Compression is a simple, effective way to save bandwidth and speed up your site. I hesitated when recommending gzip compression when speeding up your javascript because of problems in older browsers. But it’s the 21st century. Most of my traffic comes from modern browsers, and quite frankly, most of my ... http://www.simsekmert.com/wp/2010/07/how-to-optimize-your-site-with-gzip-compression/ PHP compression is an excellent method of conserving bandwidth and reducing client download times. We have already discussed an excellent method for CSS compression, and in this article we share a super-easy technique for compressing all PHP content without editing a single file. Using two PHP files and two ... http://www.simsekmert.com/wp/2010/07/fast-effective-php-compression/ PHP and SQL Server are a powerful combination, however sometimes data stored in a text type column is truncated for no apparent reason after 4096 characters. Here's how to fix the problem. PHP can work with a large number of database systems, most common of which is MySQL. However, SQL ... http://www.simsekmert.com/wp/2010/06/sql-server-php-and-truncating-text/ The tar (tape archive) command bundles a bunch of files together and creates an archive (commonly called a tar file or tarball) on a tape, disk drive, or floppy disk. The original files are not deleted after being copied to the tar file. To create an archive using tar, use ... http://www.simsekmert.com/wp/2010/06/the-tar-command-archiving-compression-encoding-and-encryption/ wget -m http://www.simsekmert.com/FOLDER_TO_DOWNLOAD/ -m, –mirror shortcut for -N -r -l inf –no-remove-listing. wget -H -r --level=1 -k -p http://www.simsekmert.com/FOLDER_TO_DOWNLOAD/ -r, –recursive Specify recursive download. -l, –level=NUMBER Maximum recursion depth (inf or 0 for infinite). -k, –convert-links Make links in downloaded HTML point to local files. ... http://www.simsekmert.com/wp/2010/06/download-entire-folder-using-wget-command-in-linux/ This example shows the MS-SQL (Microsoft SQL-Server) counterpiece for the limit command of MySQL. -- MS-SQL / SQL-Server 2005 SELECT TOP 15 * FROM ExampleTable WHERE Active = 1 ORDER BY Id DESC -- MySQL SELECT * FROM ExampleTable WHERE Active = 1 LIMIT 0,15 ORDER BY Id DESC http://www.simsekmert.com/wp/2010/04/ms-sql-limit-command/ There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax. Select a random row with MySQL: SELECT column FROM table ORDER BY RAND() LIMIT 1 Select ... http://www.simsekmert.com/wp/2010/03/sql-to-select-a-random-row-from-a-database-table/ Although the specification of the HTTP protocol does not specify any maximum length, practical limits are imposed by web browser and server software. Microsoft Internet Explorer (Browser) Microsoft states that the maximum length of a URL in Internet Explorer is 2,083 characters, with no more than 2,048 ... http://www.simsekmert.com/wp/2010/03/what-is-the-maximum-length-of-a-url/ To generate random numbers with JavaScript we employ the random() method of the Math object. It returns a floating-point number between 0.0 and 1.0. JavaScript Math object has several methods and we shall encounter three on this page - the first one being random(). var rand_no = Math.random(); alert(rand_no); In the code above, the ... http://www.simsekmert.com/wp/2009/08/generating-random-numbers-in-javascript/ A common task is to set up mail forwarding on your web or mail server so that you can have email addresses like me@mydomain.com ; however, managing email on your server sucks, especially if you get into the horrors of courier imap or hula, and then you have to ... http://www.simsekmert.com/wp/2009/06/how-to-setup-mail-forwarding-on-ubuntu/