Linux Apache MySql Php

Disadvantages of Creating Many Tables in the Same Database

2011-01-04T12:24:00.000+05:30

If we have many MyISAM tables in the same database directory, open, close, and create operations are slow. If we execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table that has to be opened, another must be closed. We can reduce this overhead by increasing the number of entries permitted in the table cache.

We can set the table_cache value in the my.cnf file by
set-variable = table_cache=8
Or
If we have the SUPER privilege then, use
set GLOBAL table_cache=8;

since the Variable 'table_cache' is a GLOBAL variable it should be set with SET GLOBAL

How to add a "Share on Facebook" button to a webpage?

2010-05-20T13:53:00.000+05:30

Copy the script for the style you'd like:

Copy and paste the following code blocks into your site and replace '<url>' with the link you want to Share.

Text link:

<script>function fbs_click() {u=location.href;t=document.title;window.open('http://www.facebook.com/sharer.php?u='+encodeURIComponent(u)+'&t='+encodeURIComponent(t),'sharer','toolbar=0,status=0,width=626,height=436');return false;}</script><a rel="nofollow" href="http://www.facebook.com/share.php?u=<;url>" onclick="return fbs_click()" target="_blank">Share on Facebook</a>

Small icon and text:

<script>function fbs_click() {u=location.href;t=document.title;window.open('http://www.facebook.com/sharer.php?u='+encodeURIComponent(u)+'&t='+encodeURIComponent(t),'sharer','toolbar=0,status=0,width=626,height=436');return false;}</script><style> html .fb_share_link { padding:2px 0 0 20px; height:16px; background:url(http://static.ak.facebook.com/images/share/facebook_share_icon.gif?6:26981) no-repeat top left; }</style><a rel="nofollow" href="http://www.facebook.com/share.php?u=<;url>" onclick="return fbs_click()" target="_blank" class="fb_share_link">Share on Facebook</a>

Icon only:

<script>function fbs_click() {u=location.href;t=document.title;window.open('http://www.facebook.com/sharer.php?u='+encodeURIComponent(u)+'&t='+encodeURIComponent(t),'sharer','toolbar=0,status=0,width=626,height=436');return false;}</script><style> html .fb_share_button { display: -moz-inline-block; display:inline-block; padding:1px 20px 0 5px; height:15px; border:1px solid #d8dfea; background:url(http://static.ak.facebook.com/images/share/facebook_share_icon.gif?6:26981) no-repeat top right; } html .fb_share_button:hover { color:#fff; border-color:#295582; background:#3b5998 url(http://static.ak.facebook.com/images/share/facebook_share_icon.gif?6:26981) no-repeat top right; text-decoration:none; } </style> <a rel="nofollow" href="http://www.facebook.com/share.php?u=<;url>" class="fb_share_button" onclick="return fbs_click()" target="_blank" style="text-decoration:none;">Share</a>

Sources: http://www.facebook.com/share_partners.php

How To Add Or Insert Orkut Post Share Button In Blogs

2010-04-20T23:46:00.000+05:30

Orkut allows a share button feature with which website owners can extend the functionality of sharing their content with visitor friends using Orkut. It is not difficult at all to add the share button. Just follow the following guidelines and you are done. Orkut Post Share Button.

Implenting Share Button In any Blog

There will be a header file or any common file in your application and you need to paste the following code

<script type="text/javascript" src="http://www.google.com/jsapi"></script>
<script type="text/javascript">
      google.load('orkut.share', '1');
      google.setOnLoadCallback(function() {
        var params = {};
        params[google.orkut.share.Field.TITLE] = 'Site title here';
        params[google.orkut.share.Field.DESTINATION_URL] = 'www.scriptscart.com';
        var connection = new google.orkut.share.Connection(params);
        document.getElementById('orkut-share').onclick =
          function(e) { connection.send('orkut.com', {}); };
      }, true);
    </script>

Now save the file and go to any other file or wherever you want to put this button and paste the following code there.

<span id="orkut-share" style="cursor:pointer; border:0px solid black">
<img src="http://3.bp.blogspot.com/_eEuHGVw5WLg/SwpFfy4rMqI/AAAAAAAAAAk/jdm-zBiDdv8/s320/share.gif" alt="Share Orkut" />
</span>

Save the file and you are ready for using the Share Button feature of ORKUT API.

Deprecated INI directives in php 5.3.x

2010-03-24T16:58:00.002+05:30

• define_syslog_variables
• register_globals
• register_long_arrays
• safe_mode
• magic_quotes_gpc
• magic_quotes_runtime
• magic_quotes_sybase
• Comments starting with '#' are now deprecated in .INI files.

Deprecated features in php 5.3.x

2010-03-24T16:57:00.002+05:30

• Assigning the return value of new by reference is now deprecated.
• Call-time pass-by-reference is now deprecated.
• The use of {} to access string offsets is deprecated. Use [] instead.

Deprecated functions in php 5.3.x

2010-03-24T16:56:00.000+05:30

• call_user_method() (use call_user_func() instead)
• call_user_method_array() (use call_user_func_array() instead)
• define_syslog_variables()
• dl()
• ereg() (use preg_match() instead)
• ereg_replace() (use preg_replace() instead)
• eregi() (use preg_match() with the 'i' modifier instead)
• eregi_replace() (use preg_replace() with the 'i' modifier instead)
• set_magic_quotes_runtime() and its alias, magic_quotes_runtime()
• session_register() (use the $_SESSION superglobal instead)
• session_unregister() (use the $_SESSION superglobal instead)
• session_is_registered() (use the $_SESSION superglobal instead)
• set_socket_blocking() (use stream_set_blocking() instead)
• split() (use preg_split() instead)
• spliti() (use preg_split() with the 'i' modifier instead)
• sql_regcase()
• mysql_db_query() (use mysql_select_db() and mysql_query() instead)
• mysql_escape_string() (use mysql_real_escape_string() instead)
• Passing locale category names as strings is now deprecated. Use the LC_* family of constants instead.
• The is_dst parameter to mktime(). Use the new timezone handling functions instead.

How can I turn off MySQL strict mode? or Solving Incorrect integer value problem with MySQL 5 strict-mode

2010-03-02T14:13:00.002+05:30

To turn off strict_mode in MySQL

This can be done in two ways...

Open your "my.ini" file within the MySQL installation directory, and look for the text "sql-mode".

Find:
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Replace with:

# Set the SQL mode to strict
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Or, you can run an SQL query within your database management tool, such as phpMyAdmin:

SET @global.sql_mode= '';

Function set_magic_quotes_runtime() is deprecated in PHP 5.3.0

2010-02-17T11:51:00.000+05:30

It's better to change the error_reporting line because there are a few other deprecated functions.

error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);

You need to wrap this in a test for PHP version 5.3 because E_DEPRECATED only became available as of 5.3.

Another method is

find:
set_magic_quotes_runtime(0);
and replace:
ini_set("magic_quotes_runtime", 0);

To view apache error log

2010-01-15T12:02:00.001+05:30

tail -f /usr/local/apache/logs/error_log | grep betaisc

What is the difference between AIM or SIM in Authorize.Net

2009-12-28T10:40:00.000+05:30

In SIM (Simple integration Method) customer credit card details are taken on the authorize.net site - no SSL required AIM (Advanced integration Method) Credit card details are taken over your site SSL required - please check setup instructions for more details http://www.ecommercetemplates.com/phphelp/ecommplus/authorizenet.asp

To view the exim mail log

2009-11-12T11:49:00.000+05:30

tail -f /var/log/exim_mainlog

Turn dynamic URLs into search engine friendly static URLs

2009-10-20T09:38:00.000+05:30

The original URL
------------------
http://www.scriptscart.com/shop.php?cmd=product&category=vehicles&product=bus

The rewritten URL
--------------------
http://www.scriptscart.com/product/vehicles/bus.html

Add the following lines to .htaccess:

RewriteEngine On
RewriteRule ^([^/]*)/([^/]*)/([^/]*)\.html$ /shop.php?cmd=$1&category=$2&product=$3 [L]

Please follow the instructions below to do it.

First you need to check if the file .htaccess exists in the root of your website.
If the file .htaccess exists, download it from your site, add the lines below to the end of the file, and upload the modified file back to your site. Please make a copy of the original file .htaccess. So if anything goes wrong, you may restore the original file.
If the file .htaccess does not exist, create a new file .htaccess and add the lines below to it. Then upload it to the root of your website. You may delete it if anything goes wrong.

Payment gateways test account

2009-08-06T13:05:00.000+05:30

Authorize.net

==========

You can use any of the following test credit card numbers. The expiration date must be set to the present date or later:

370000000000002 American Express Test Card
6011000000000012 Discover Test Card
4007000000027 Visa Test Card
4012888818888 second Visa Test Card
3088000000000017 JCB
38000000000006 Diners Club/ Carte Blanche

google checkout

===========

GoogleMerchant ID : 643760143118924

Google Merchant Key : jk0ACPM8RdntndpuFbqjew

How to find how much free space in Hard disk Linux

2009-07-01T10:29:00.001+05:30

"df -h"
du -sch *

How to run a crontab entry as "nobody"

2009-06-15T11:18:00.000+05:30

Assuming you are the root user on a Linux computer, here's a quick example of how to run a program on a Linux system through a crontab entry, with the program being executed as the user nobody.

Just put this entry in a crontab file (by issuing the "crontab -e" command, for example), and the program named myProgram.sh will be run at 1:30 a.m. using the Bourne shell, and will be run as the user nobody.

30 1 * * * su -c '/path/to/program/myProgram.sh' -s /bin/sh nobody

testing is always recommended, but this has worked for me.

How to create aliases (linux/unix)

2009-06-15T11:13:00.000+05:30

Creating aliases is very easy. You can either enter them at the command line as you're working, or more likely, you'll put them in one of your startup files, like your .bashrc file, so they will be available every time you log in.

I created the ll alias by entering the following command into my .bashrc file:

alias ll="ls -al"

/etc/bashrc

Restore a Mysql database from the server backup

2009-06-01T16:18:00.000+05:30

root@testserver [/var/lib/mysql]# mysql testsite_support < /backup/cpbackup/weekly/testsite/mysql/testsite_support.sql

.htaccess 301 redirection

2009-03-26T11:21:00.000+05:30

.htaccess 301 redirection

RewriteEngine On RewriteCond %{HTTP_HOST} ^example.com [NC]
RewriteRule ^(.*)$ http://www.example.com/$1 [L,R=301]

Alternate method is

ServerName www.example.com
ServerAdmin webmaster@example.com
DocumentRoot /home/username/public_html

ServerName example.com
RedirectMatch permanent ^/(.*) http://www.example.com/$1

For more details refer http://www.seobook.com/archives/001714.shtml

To increase memory limit using .htaccess

2009-03-25T17:14:00.000+05:30

To increase memory limit using .htaccess

Put a .htaccess file with the following code in the particular directory

php_value memory_limit 128M

To get the cpanel username

2009-03-25T11:19:00.000+05:30

To get the cpanel username

First login to the server as 'root' then

grep domainname.com /etc/userdomains

To get the file names only using grep

2009-03-20T11:47:00.000+05:30

To get the file names only using grep command

grep findword . -ir | cut -d: -f1

To search in the .php files only

find . -name "*.php" | grep findword -ir | cut -d: -f1

How to add a user in the freeBSD using a shell script?

2009-01-27T10:49:00.000+05:30

Adding a user in the FreeBSD using a shell script

touch useradd.txt
echo "$linux_login::::::::bash:" > useradd.txt

/usr/sbin/adduser -f useradd.txt -k $skeldir $linux_login -w no

sample useradd.txt file
-----------------------
test::::::::bash:

How to find the php.ini path?

2008-12-30T11:48:00.000+05:30

php -i | grep php.ini

Using suphp To Secure A Shared Server

2008-12-24T15:57:00.000+05:30

http://blog.stuartherbert.com/php/2008/01/18/using-suphp-to-secure-a-shared-server/

How do I set up mail forwarding for individual email addresses on a domain through Plesk?

2008-12-18T11:17:00.000+05:30

To set up mail forwarding for individual email addresses on a domain through Plesk:

Log in to Plesk as "admin"
Under General, select Domains.
Select the domain you want to forward mail for.
Under Services, select the Mail icon.
Under the Mail tab, select New Address. The Create mail name window displays.
Enter the name of the email address you want to forward to.
Deselect the Mailbox checkbox.
Click OK.

OR

To set up forwarder for an individual email like roshith@example.com

Fisrt we need the root access. After login in the shell edit following file

vi /var/qmail/mailnames/example.com/roshith/.qmail

Insert the following line in the .qmail
|/usr/bin/php -q /home/supportpro/public_html/folder/parser/parser.php

For more details refer

http://octeth.com/kb/oempro3/mailing-list-management/bounce-tracking-module-%E2%80%93-piping-installation-instructions/

http://octeth.com/data/downloads/manuals/oemPro_Piping_Setup.pdf

After setting restart qmail

How do I create a cronjob in Plesk?

2008-12-18T11:05:00.000+05:30

Open a web browser and connect to your Plesk Control Panel located at https://ip address:8443.
Login as the Administrator using the information sent to you in your setup email.
Click Server from the System menu.
Click Crontab under the Services section.
Click Add New Task under the Tools section.
Click Enable / Disable.
Enter the appropriate information:
Note: * indicates leaving the field empty
- Minute: 0 - 59 or *
- Hour: 0 - 23 or *
- Day of the Month: 1 - 31 or *
- Month: 1 - 12 or *
- Day of the Week: 0 - 6 (0 is Sunday) or *
- Command: enter the command that is to be executed
Click Ok.

To get the number of files in a directory

2008-10-22T11:13:00.000+05:30

ll | wc -l

cronjobs of user roshith

2008-10-15T14:24:00.000+05:30

After login to the server to get the cronjobs of user roshith

vi /var/spool/cron/roshith

or

crontab -e -u roshith

To get cron log
---------------

tail -f /var/log/cron

cat /var/log/cron | grep iscripts

To list the last run cron jobs
----------------------------

vi /var/log/cron

Find a file in the linux

2008-09-25T17:14:00.000+05:30

find . -name admindemo.tar.gz

find / -name admindemo.tar.gz

Repair mysql table

2008-09-25T15:58:00.000+05:30

root@servername [/var/lib/mysql/databasename]# myisamchk -r -S *.MYI

mysql> use ;
mysql> REPAIR TABLE `table1`,`table2`;

Change system date in Linux

2008-09-22T10:22:00.000+05:30

set new date to 22 Sept 2008 18:00:00, type the following command as root user:

# date -s "2 OCT 2006 18:00:00"

Restarting Apache

2008-09-06T14:37:00.000+05:30

/etc/init.d/httpd restart

Editing Samba

2008-08-12T14:25:00.000+05:30

Edit Samba
vi /etc/samba/smb.conf

Restarting Samba
/etc/init.d/smb restart

MySQL - Restoring a Single Table from a Huge mysqldump File

2008-07-28T12:34:00.001+05:30

http://blog.tsheets.com/2008/tips-tricks/mysql-restoring-a-single-table-from-a-huge-mysqldump-file.html

Restoring a single table in Mysql

2008-07-28T10:52:00.000+05:30

Take a backup of the table which your looking to restore using mysqldump.
mysqldump -u -p >

ex:mysqldump -usridhar -pthajes testdb usermas > /home/sridhar/mysqldump/tablebackup.txt

where we get only usermas table backup.

for restoring to another db. use
mysql < /home/sridhar/mysqldump/tablebackup.txt
ex: mysql restDB < /home/sridhar/mysqldump/tablebackup.txt .

Note: If restDB has already usermas table, pls drop before restoring.

Starting mysql

2008-07-12T23:19:00.001+05:30

/etc/init.d/mysqld start

Restarting a cronjob

2008-07-12T23:15:00.001+05:30

/etc/init.d/crond restart

How to do scp

2008-07-12T23:06:00.000+05:30

scp file.zip root@cxcxcc.com:/home/cxcxcc/public_html/data/cxcxccxc/