Tech.Bitez

If you are facing problems sharing sessions across subdomains, use the following code before session_start().

ini_set ( 'session.cookie_domain', '.mysite.com' );

Replace mysite.com with your domain name.

The last release of PHP 4 is now available for download on 7th of August 2008. PHP 4 has been serving the web sites since 2000.

It is a common requirement to count number of words in a column of a MySQL database table. But MySQL does not have any built in function to count number of words as it usually has for number of purposes.

But you can do it without it with a simple trick e.g. you have a column name and want to count number of words in it. This query will return number of words separated with space in a column

SELECT SUM( LENGTH(name) - LENGTH(REPLACE(name, ' ', ''))+1)
FROM table

If you want to count number of words separated by some other string for example comma (,) or semicolon (;), simply replace space with your required character.

I am creating a list of MySQL GUI tools. I hope you will contribute this list.

A wide variety of MySQL GUI tools are available in the market. Most of them are free but some are paid as well. We can divide GUIs in 2 categories i.e. desktop and web based applications. Here is the list of popular MySQL GUI tools I have heard of

1. Desktop Application
   • Official MySQL GUI Tools (Linux, Windows, Mac OSX)
   • HeidiSQL
   • Navicat (Linux, Windows, Mac OS X)
   • SQLyog
   • CocoaMySQL (Mac OS X)
   • SQL-Front
   • Toad for MySQL
   • ACDB sql client - Supports MySQL and Oracle
   • Aqua Data Studio (Linux, Windows, Mac OS X, Solaris)
   • DreamCoder (Windows)
   • DBACentral (Windows)
   • SQL Manager (http://www.sqlmanager.net/de/products/mysql/manager)
   • DatabaseSpy
2. Web Based Application
   • phpMyAdmin
   • MySQL Quick Admin

If you know any good GUI Tool, please let me know.

I came across this discussion today on pros and cons of using template engines in PHP.

Today I found that Apache on my server was very slow and a lot of child pid xxxx exit signal File size limit exceeded (25) errors in error_log.

I simply searched for large (2gb) log files and deleted them. Everything became normal.

There are different options to increase file upload limit in PHP. First is changing PHP configuration file (php.ini) and restarting webserver or overwriting the php.ini value in .htacces (this option is available if you are running Apache).

There are 2 directives which affect upload limit i.e. upload_max_filesize and post_max_size.

Now we look at the first method. First you have to find out where the php.ini is. To find out the location, make a .php file containing only this code and place it in your webroot and point your browser to this file.

<?php phpinfo(); ?>

In the page output you can find Configuration File Path. Open this file and change the values for upload_max_filesize and post_max_size according to your requirement e.g. to set 10MB upload limit, the values will be
upload_max_filesize = 10M
post_max_size = 10M

Read the rest of this entry »

People have different opinions on saving images in database. Some says, "Why bother database if we can handle this by saving images to disk". I am agree with this;).

Most of the requirements can be fulfilled by saving the images to disk. This reduces the unnecessary load on MySQL.

Here is the small code to save the image in MySQL with the help of PHP.
Read the rest of this entry »

This is a very simple example to download data in csv format using PHP and MySQL. I have used a table with two columns i.e. id and name.

The main point to download file is a proper use of header(). It has said many times in many places but I repeat here, "Make sure there must not be any sort of output (including whitespaces) before header()". We can also set a default file name for the file.

Here is the PHP code
Read the rest of this entry »

It is strongly recommended that you do not turn on the register_globals. But if you still want to turn on register_globals then follow these steps

Make a .php file containing only this code

<?php phpinfo(); ?>

And upload this file to your new server and open in the browser. In the page output find the value for 'register_globals'. If it is off, then you can solve this problem in the following ways

Read the rest of this entry »