Experts: Magento, Joomla, Wordpress, Oscommerce, Drupal, htaccess, PHP, Javascript, JQuery,Ajax

Javascript Auto Counter

2010-12-28T01:57:00.000-08:00

<script language="Javascript">
var countdown_number= 0 ;
function countdown_trigger() {  
countdown_number++;
document.getElementById('countdown_text').innerHTML = countdown_number;
countdown = setTimeout('countdown_trigger()', 1000);
}
setTimeout('countdown_trigger()', 1000);
</script>
<div id="countdown_text">0</div>

PHP: How to get directory path

2010-12-28T01:50:00.001-08:00

echo dirname(__FILE__);

Javascript: Compare two dates

2010-12-28T01:46:00.000-08:00

Using following function we can compare the two dates in javscript:

function getDateObject(dateString,dateSeperator)
{
//This function return a date object after accepting
//a date string ans dateseparator as arguments
var curValue=dateString;
var sepChar=dateSeperator;
var curPos=0;
var cDate,cMonth,cYear;

//extract day portion
curPos=dateString.indexOf(sepChar);
cDate=dateString.substring(0,curPos);

//extract month portion
endPos=dateString.indexOf(sepChar,curPos+1); 
cMonth=dateString.substring(curPos+1,endPos);

//extract year portion
curPos=endPos;
endPos=curPos+5;
cYear=curValue.substring(curPos+1,endPos);

//Create Date Object
dtObject=new Date(cYear,cMonth,cDate);
return dtObject;
}
var selectDate = getDateObject('15-02-2011',"-");
var startDate = getDateObject('10-02-2011',"-");
var endDate = getDateObject('15-02-2011',"-");

if((selectDate >= startDate) && (selectDate<=endDate))
{
alert("startDate is less than endDate");
}

Magento: Delete Order Code in Magento Admin

2010-11-30T06:21:00.000-08:00

Delete the orders from admin in magento site:

File: /app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php

Add following code in function _prepareMassaction()

if (Mage::getSingleton('admin/session')->isAllowed('sales/order/actions/delete')) {
            $this->getMassactionBlock()->addItem('delete_order', array(
                 'label'=> Mage::helper('sales')->__('Delete'),
                 'url'  => $this->getUrl('*/sales_order/massDelete'),
            ));
        }

 File: /app/code/core/Mage/Adminhtml/controllers/Sales/OrderController.php

 public function massDeleteAction()
    {
        $orderIds = $this->getRequest()->getPost('order_ids', array());
        $countCancelOrder = 0;
        $countNonCancelOrder = 0;
        foreach ($orderIds as $orderId) {
            $order = Mage::getModel('sales/order')->load($orderId);
            if ($order->delete()) {
               
                $countCancelOrder++;
            } else {
                $countNonCancelOrder++;
            }
        }
        if ($countNonCancelOrder) {
            if ($countCancelOrder) {
                $this->_getSession()->addError($this->__('%s order(s) cannot be deleted', $countNonCancelOrder));
            } else {
                $this->_getSession()->addError($this->__('The order(s) cannot be deleted'));
            }
        }
        if ($countCancelOrder) {
            $this->_getSession()->addSuccess($this->__('%s order(s) have been deleted.', $countCancelOrder));
        }
        $this->_redirect('*/*/');
    }

Magento: Delete Test Order in Magento

2010-11-30T06:16:00.000-08:00

You got a Magento project to develop, you created a Magento theme, you placed initial products and categories and you also placed some test orders to see if Shipping and Payment methods work as expected. Everything seems to be cool and the client wishes to launch the site. You launch it. When you enter the administration for the first time after the launch, you will see all your test orders there. You know those should be deleted. But how?

If you try to delete orders in the backend, you will find out that you can only set the status to “cancelled” and the order is still there. Unfortunately, Magento doesn’t enable us to delete those via administration, so you will not see any “Delete order” button. This can be quite frustrating both to developers and the merchants. People coming from an SAP world find the inability to delete to have some merit but there should be a status that removes the sales count from the reports i.e. sales, inventory, etc.
So, what to do?
You need to go to MySQL admin client and run this query:

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE `sales_order`;
TRUNCATE `sales_order_datetime`;
TRUNCATE `sales_order_decimal`;
TRUNCATE `sales_order_entity`;
TRUNCATE `sales_order_entity_datetime`;
TRUNCATE `sales_order_entity_decimal`;
TRUNCATE `sales_order_entity_int`;
TRUNCATE `sales_order_entity_text`;
TRUNCATE `sales_order_entity_varchar`;
TRUNCATE `sales_order_int`;
TRUNCATE `sales_order_text`;
TRUNCATE `sales_order_varchar`;
TRUNCATE `sales_flat_quote`;
TRUNCATE `sales_flat_quote_address`;
TRUNCATE `sales_flat_quote_address_item`;
TRUNCATE `sales_flat_quote_item`;
TRUNCATE `sales_flat_quote_item_option`;
TRUNCATE `sales_flat_order_item`;
TRUNCATE `sendfriend_log`;
TRUNCATE `tag`;
TRUNCATE `tag_relation`;
TRUNCATE `tag_summary`;
TRUNCATE `wishlist`;
TRUNCATE `log_quote`;
TRUNCATE `report_event`;

ALTER TABLE `sales_order` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_datetime` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_decimal` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_datetime` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_decimal` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_int` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_text` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_varchar` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_int` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_text` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_varchar` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1;
ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1;
ALTER TABLE `tag` AUTO_INCREMENT=1;
ALTER TABLE `tag_relation` AUTO_INCREMENT=1;
ALTER TABLE `tag_summary` AUTO_INCREMENT=1;
ALTER TABLE `wishlist` AUTO_INCREMENT=1;
ALTER TABLE `log_quote` AUTO_INCREMENT=1;
ALTER TABLE `report_event` AUTO_INCREMENT=1;

-- reset customers
TRUNCATE `customer_address_entity`;
TRUNCATE `customer_address_entity_datetime`;
TRUNCATE `customer_address_entity_decimal`;
TRUNCATE `customer_address_entity_int`;
TRUNCATE `customer_address_entity_text`;
TRUNCATE `customer_address_entity_varchar`;
TRUNCATE `customer_entity`;
TRUNCATE `customer_entity_datetime`;
TRUNCATE `customer_entity_decimal`;
TRUNCATE `customer_entity_int`;
TRUNCATE `customer_entity_text`;
TRUNCATE `customer_entity_varchar`;
TRUNCATE `log_customer`;
TRUNCATE `log_visitor`;
TRUNCATE `log_visitor_info`;

ALTER TABLE `customer_address_entity` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_datetime` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_decimal` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_int` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_text` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_varchar` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_datetime` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_decimal` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_int` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_text` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_varchar` AUTO_INCREMENT=1;
ALTER TABLE `log_customer` AUTO_INCREMENT=1;
ALTER TABLE `log_visitor` AUTO_INCREMENT=1;
ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1;

-- Reset all ID counters
TRUNCATE `eav_entity_store`;
ALTER TABLE  `eav_entity_store` AUTO_INCREMENT=1;

SET FOREIGN_KEY_CHECKS=1;

Magento: Getting product attributes values and labels

2010-10-07T03:44:00.000-07:00

I have found that it is very useful to be able to get attributes from the system and use them in places other than a products category page. I always forget the exact syntax to use so, this is going to be my unofficial cheat sheet. This is how to get a drop down lists options. I don’t think it will work for a mulit-select attribute. I stick the value/label pairs into an array to use how I please.

$attribute = Mage::getModel('eav/config')->getAttribute('catalog_product', 'attribute_id');
foreach ( $attribute->getSource()->getAllOptions(true, true) as $option){
$attrubuteArray[$option['value']] = $option['label'];
}

Magento: How to add product to magento programmatically

2010-07-30T04:44:00.000-07:00

$product = Mage::getModel('catalog/product');
$product->setWebsiteIds(array('1'));
$product->setAttributeSetId(4);
$product->setSku(time());
$product->setType('Simple Product');
$product->setTypeId('simple'); 
$product->setName('ranjeet test product'.time());
$product->setDescription('description');
$product->setShortDescription('[short_description]');
$product->setPrice('12.00');
$product->setWeight('11');
$product->setStatus(1);
$product->setTaxClassId(2);
$product->setCategoryIds('2');
$product->setVisibility(3);
$product->setCreatedAt(strtotime('now'));
//get stock 
$stockData = $product->getStockData();
$stockData['qty'] = 10;
$stockData['is_in_stock'] = 1;
$stockData['manage_stock'] = 1;
$stockData['use_config_manage_stock'] = 0;
$product->setStockData($stockData);


$imagePath=Mage::getBaseDir('media') . DS . 'import' ."/alyssia_02-2.jpg";
$product->addImageToMediaGallery($imagePath, 
array('image','small_image','thumbnail'), false, false);

Joomla: How to use external database connection in joomla

2010-06-06T21:45:00.001-07:00

If you need to access tables within the same database as your Joomla! installation then you can simply use the JFactory->getDBO method. This uses the already established connection that Joomla! uses to connect to the database. For example:

<? $db = JFactory::getDBO(); ?>

$db is now an object of type JDatabase and you can perform database operations on it using the usual methods. But what if you want to connect to a completely different database from the one used by Joomla!?.This might be a different database on the same machine as your Joomla! site or it might be on a different host and perhaps even require a different database driver. Well, you can do this using the JDatabase->getInstance method.

<?php
$option = array(); //prevent problems
 
$option['driver']   = 'mysql';            // Database driver name
$option['host']     = 'db.myhost.com';    // Database host name
$option['user']     = 'fredbloggs';       // User for database authentication
$option['password'] = 's9(39s£h[%dkFd';   // Password for database authentication
$option['database'] = 'bigdatabase';      // Database name
$option['prefix']   = 'abc_';             // Database prefix (may be empty)
 
$db = & JDatabase::getInstance( $option );
?>

$db is now an object of type JDatabase and you can perform database operations on it using the usual methods. Note that if the database uses a non-standard port number then this can be specified by adding it to the end of the host name. For example, you might have your MySQL database running on port 3307 (the default is port 3306), in which case your host name might be 'db.myhost.com:3307'. One feature of using JDatabase->getInstance is that if another call is made with the same parameters it will return the previously created object rather than creating a fresh one. Note, however, that the parameters must match exactly for this to happen. For example, if two calls were made to a MySQL database using JDatabase->getInstance, with the first using a host name of 'db.myhost.com' and the second using 'db.myhost.com:3306', then two separate connections would be made, even though port 3306 is the default port for MySQL and so the parameters are logically the same.

Magento: How to get customer information

2010-05-29T02:11:00.001-07:00

You can get logged customer account information easily using following code

$customer =  Mage::getSingleton('customer/session')->getCustomer();
$customer->getId();

Magento: How to get current currency code

2010-05-29T02:09:00.000-07:00

Gets current currency code using in magento site

$currency_code = Mage::app()->getStore()->getCurrentCurrencyCode();

Magento: How to get product for specific category

2010-05-19T02:45:00.000-07:00

<?php
$cat_id = 8; // set desired category id
$category = Mage::getModel('catalog/category')->load($cat_id);
$products = $category->getProductCollection()->addCategoryFilter($category
->addAttributeToSelect('*');
 foreach ( $products as $_product ): ?>
    <a href="<?php echo $_product->getProductUrl() ?>">
<img src="<?php echo $this->helper('catalog/image')->init($_product,
 'small_image')->resize(135, 135); ?>" width="135" height="135" 
title="<?php echo $_product->getName() ?>"
 alt="<?php echo $_product->getName() ?>" /></a>
<?php endforeach; ?>

Magento: How to get category URL by ID

2010-05-19T02:42:00.000-07:00

<?php echo Mage::getModel("catalog/category")->load(5)->getUrl() ?>

Magento: How to use site URL in Magento CMS pages

2010-05-18T05:43:00.000-07:00

You may be familiar with some of the template directives you can use in the Magento CMS pages and blocks. Their syntax is distinguished by the double curly braces that enclose the directive
The url paramter generates a URL using the Magento routing. This means it will take anything you pass to the store url directive append it to the store base URL and append a ‘/’. So for example, you can create a URL to the contact us page like so:

href="{{store url=""}}"

If you need to create a URL to a category or product, you can use the direct_url parameter. In that case, whatever you pass to the store directive will simply be appended to the base URL. For example, if your settings are that .html is added to your links, a link to a category can be created like so:

href="{{store direct_url="privacy"}}:

If you need to generate URLs with query parameters, there are two ways Using the _query parameter, you can add an arbitrary query string to the URL like so:

href="{{store direct_url="category/subcategory.html" 
_query="a=param_a&b=param_b"}}"

Or you can use the second parameter syntax where you define the query parameter name with the parameter itself:

href="{{store direct_url="category/subcategory.html" 
_query_a="param_a" _query_b="param_b"}}"

Magento: How to add images in CMS Pages and Blocks

2010-05-18T05:33:00.000-07:00

Its not a hard code just use the following path to get the images from skin folder

src="{{skin url=’images/dog-playing.jpg’}}"

Magento: Add Static Block to CMS Page

2010-05-18T05:30:00.000-07:00

There is definitely nothing complicated about doing this. Static blocks are a great way to divide up different types of data blocks to make updating content easier.
There are just two simple steps to adding a static block to a cms page. First, create your static block. You will use the identifier to call it on the cms page. Let’s say, for this example, we call the identifier “home-page-promo”.
Once your static block is created, edit whatever cms page you would like this block to appear on, and simply put this code in right where you want it to show up:

{{block type="cms/block" block_id="home-page-promo"}}

Magento: How to get content of static block in magento

2010-05-18T05:27:00.000-07:00

There are some small code to get content or other info of static block which you created on admin panel.

<?php echo $this->getLayout()->createBlock('cms/block')
->setBlockId('yourBlockName')->toHtml() ?>

Magento: How to update the invoice output PDF font style and size

2010-04-16T03:00:00.001-07:00

In magento it is very simple to change the font type and font size for invoice PDF output. There are 2 files where some code will change. Please look below:

1. In app/code/core/Mage/Sales/Model/Order/Pdf/Abstract.php file

line number : 564
 $font = Zend_Pdf_Font::fontWithPath(Mage::getBaseDir() .
  '/lib/LinLibertineFont/LinLibertineC_Re-2.8.0.ttf');
 
 2. In app/code/core/Mage/Sales/Model/Order/Pdf/items/Abstract.php file
 line number : 262
  $font = Zend_Pdf_Font::fontWithPath(Mage::getBaseDir() .
   '/lib/LinLibertineFont/LinLibertineC_Re-2.8.0.ttf');

In magento default font for PDF output is LinLibertineC_Re-2.8.0.ttf. You can easly change the font. Please upload any font file (.ttf) in 'lib' directory and use the path in upper lines

Font family (HTML)

2010-04-14T02:05:00.000-07:00

In HTML and XHTML, a font face or font family is the typeface that will be applied by a web browser to some text. The font is relevant for the display of text on the screen, on a printer or another device.
A font family and other presentational attribute of a font may be applied in HTML code in either cascading style sheets (CSS) or the deprecated HTML font element.
In CSS, a font-family (or face in HTML) in fact consists of a set of related fonts, grouped as font families. For example, the Times family includes different font sizes, styles (like roman and italic) and weight (like regular and bold). The web browser will only be able to apply a font if it is available to it, which is not always the case. HTML code writers may list in preferential order font families to use when rendering text. The font list is separated by commas (as shown above). To avoid unexpected results, the last font family on the font list will be one of the five generic families which are by default always available in HTML and CSS. In the absence of a font being found, the web browser will use its default font, which may be a user defined one. Depending on the web browser, a user can in fact override the font defined by the code writer. This may be for personal taste reasons, but may also be because of some physical limitation of the user - such as the need for a larger font size, or the avoiding of certain colours.

Font	Example (dependent on installed fonts)
Times New Roman	Expert: Magento Joomla Wordpress Drupal
Roman	Expert: Magento Joomla Wordpress Drupal
Arial	Expert: Magento Joomla Wordpress Drupal
Garamond	Expert: Magento Joomla Wordpress Drupal
Palatino	Expert: Magento Joomla Wordpress Drupal
Antiqua	Expert: Magento Joomla Wordpress Drupal
Minion	Expert: Magento Joomla Wordpress Drupal
Helvetica	Expert: Magento Joomla Wordpress Drupal
Swiss	Expert: Magento Joomla Wordpress Drupal
Impact	Expert: Magento Joomla Wordpress Drupal
Script	Expert: Magento Joomla Wordpress Drupal
Decorative	Expert: Magento Joomla Wordpress Drupal
Blackletter	Expert: Magento Joomla Wordpress Drupal
Fraktur	Expert: Magento Joomla Wordpress Drupal
Comic Sans	Expert: Magento Joomla Wordpress Drupal
Modern	Expert: Magento Joomla Wordpress Drupal
Courier	Expert: Magento Joomla Wordpress Drupal
Calibri	Expert: Magento Joomla Wordpress Drupal
Verdana	Expert: Magento Joomla Wordpress Drupal
Frosty	Expert: Magento Joomla Wordpress Drupal
Georgia	Expert: Magento Joomla Wordpress Drupal
Avqest	Expert: Magento Joomla Wordpress Drupal

Magento: How to get order shipping address details by order id

2010-04-06T04:59:00.001-07:00

Here is the code you can use to get the order shipping address/ billing address details

$incrementid ="100000004";
$_order = Mage::getModel('sales/order')->loadByIncrementId($incrementid);

OR
$order_id ="4";
$_order = Mage::getModel('sales/order')->load($order_id);

$_shippingAddress = $_order->getShippingAddress();
echo $_shippingAddress->getFirstname() . '
';
echo $_shippingAddress->getLastname() . '
';
echo $_shippingAddress->getCompany() . '
';
echo $_shippingAddress->getStreetFull() . '
';
echo $_shippingAddress->getRegion() . '
';
echo $_shippingAddress->getCity() . '
';
echo $_shippingAddress->getPostcode() . '
';
echo $_shippingAddress->getTelephone() . '
';
echo $_shippingAddress->getCountry_id() . '
';
echo $_order->getCustomerId();

Magento: How to use magento database connection, classes, functions outside.

2010-04-05T22:33:00.001-07:00

I need to make a page(like ajax page) outside from magento , but i need magento database connection there. I searched my code by then i find following code to call all classes , function outside from magento site Here is code:-

include("./app/Mage.php");
Mage::app('default');

Magento localhost site problem with firefox browser

2010-04-05T03:21:00.001-07:00

I faced major problem with magento on localhost with firefox browser. No login for frontend and admin works. Add to cart also not works.
Firefox does not set cookies for http://localhost
For some reason Firefox is "blocking" localhost or any hostname without dot.
I have empty cookie exceptions list on my Firefox preferences. Adding "localhost" and setting it as "enable" (always accept) does not work.

I solved problem.
Please use You system ip at the place of localhost like
http://localhost/magento to http://192.168.1.88/magento it will works 100%

PHPBB Forum login from outside in magento site

2010-03-14T23:35:00.000-07:00

In one my magento project client want to integrate the phpbb forum with magento. Client want the common login for both magento and phpbb. After some research i make a following code for phpbb. Its help for successful login from outside for forum.

define('IN_PHPBB', true);
define('IN_LOGIN', true);
$phpbb_root_path = "forum/";     
$phpEx = "php";
require($phpbb_root_path . 'common.php');
$username = $_REQUEST['username'];
$user_password  = $_REQUEST['password'];
$user->session_begin();
$result = $auth->login( $username, $user_password );
   
if ( $result[ "status" ] == LOGIN_SUCCESS )
{
if ( defined( "IN_CHECK_BAN" ) &&
 $result[ "user_row" ][ "user_type" ] != USER_FOUNDER )
{
return;
}
$successurl = $_GET[ "successurl" ];
if ( $successurl == "" )
{
$successurl = "./customer/account/";
}
$successurl = reapply_sid( $successurl );
$successurl = str_replace( "&", "&", $successurl );
header( "Location: $successurl" );
exit( 0 );
}
else
{
die( $result[ "error_msg" ] );
}

Joomla site / root path

2010-03-05T23:01:00.000-08:00

Joomla important paths:

Site Root Path:
echo JURI::root(); // http://sitename.com/  

Site Directory Path   
echo JPATH_BASE; //   /var/www/sitefolder/

How open rar file or Extract rar files under ubantu

2010-02-22T20:18:00.000-08:00

How do I open rar archive files under Linux / UNIX operating systems? RAR is a proprietary file format for data compression and archiving, developed by Eugene Roshal. Under Linux and UNIX, use command called unrar. By default unrar is not being installed on Linux, FreeBSD or UNIX oses. You can install unrar command with the help of apt-get or yum command. Install unrar command

sudo apt-get install unrar //for ubantu/Debian Linux

Magento: How to overload a core controller in Magneto

2010-02-20T02:31:00.000-08:00

In my one magneto project i want the bridge between magento and phpbb. So i need a to edit the user login class without effect the core code. I need to overload the controller "Mage_Customer_AccountController". I try many code but no luck. Then i find one code i want to discuss with all. Make own extention add code in etc/module.XML following

  
<rewrite>
  <Mage_Customer>
 <from>#^/account/create/#</from>
    <to>Bridge_Magentophpbb_Controllers_Account</to>
  </Mage_Customer>
</rewrite>

require_once 'Mage/Customer/controllers/AccountController.php';

class Newmodule_Name_AccountController extends Mage_Customer_AccountController
{
you code here
}

PHP: Days diffrence between two dates in PHP

2010-02-18T21:05:00.000-08:00

It is very simple to find the day difference between two dates. Here is simple PHP function to find difference.

function dateDiff($dformat, $endDate, $beginDate)
{
$date_parts1=explode($dformat, $beginDate);
$date_parts2=explode($dformat, $endDate);
$start_date=gregoriantojd($date_parts1[1],
 $date_parts1[2], $date_parts1[0]);
$end_date=gregoriantojd($date_parts2[1],
 $date_parts2[2], $date_parts2[0]);
return $end_date - $start_date;
}
$enddate= "2010-09-30";
$startdate= "2010-01-30";
echo dateDiff("-", $enddate, $startdate);

How to highlight the search result with search keywords using javascript and css

2010-02-14T21:14:00.000-08:00

Highlight search result keywords using JavaScript and CSS.
You see it in Google search results and a lot of other sites that have good search functionality. When you perform a search, your words or phrases are highlighted in the search results making it easy for you to find the most relevant content.

//use this code below the result
function highlightOnLoad() {
var keys = document.searchform.keywords.value;
//keywords is input type and searchform is form name
if (keys) { 
var searchString = getSearchString();
//content div used to show the result or result div
var textContainerNode = document.getElementById("content");
var searchTerms = searchString.split('|');
for (var i in searchTerms)  {
var regex = new RegExp(">([^<]*)?("+searchTerms[i]+")([^>]*)?<","ig");
highlightTextNodes(textContainerNode, regex, i);     
}
var searchTermDiv = document.createElement("H2");
searchTermDiv.className = 'searchterms';
searchTermDiv.innerHTML = searchInfo;
textContainerNode.insertBefore(searchTermDiv, textContainerNode.childNodes[0]);
}}
function getSearchString() {
var keys = document.searchform.keywords.value;
var rawSearchString = keys.replace(/[a-zA-Z0-9\?\&\=\%\#]+s\=(\w+)(\&.*)?/,"$1");
return rawSearchString.replace(/\%20|\+/g,"\|");
}
function highlightTextNodes(element, regex, termid) {
var tempinnerHTML = element.innerHTML;
element.innerHTML = tempinnerHTML.replace(regex,'>$1<span class="highlighted term'+termid+'">$2</span>$3<');
}

highlightOnLoad(); 

//css for result highlight
span.term0 {
  background-color: #161633;
}
span.term1 {
  background-color: #331616;
}
span.term2 {
  background-color: #163316;
}

PHP: Create thumbnail and add text on thumbnail

2010-02-12T04:44:00.000-08:00

It is very simple php class to create thumbnail and add the text or string on the thumbnail on the fly. My one client want the site name on all thumbnail. So i created this code for my client. Here is the code:

class Thumb_image {
var $save_to_file = true;
var $image_type = -1;
var $quality = 100;
var $cut_x = 0;
var $cut_y = 0;    
function SaveImage($im, $filename) { 
$res = null; 
// ImageGIF is not included into some GD2 releases, so it might not work
// output png if gifs are not supported
if(($this->image_type == 1)  && 
!function_exists('imagegif')) $this->image_type = 3;
switch ($this->image_type) {
case 1:
if ($this->save_to_file) {
$res = ImageGIF($im,$filename);
}
else {
header("Content-type: image/gif");
$res = ImageGIF($im);
}
break;
case 2:
if ($this->save_to_file) {
$res = ImageJPEG($im,$filename,$this->quality);
}
else {
header("Content-type: image/jpeg");
$res = ImageJPEG($im, NULL, $this->quality);
}
break;
case 3:
if (PHP_VERSION >= '5.1.2') {
// Convert to PNG quality.
// PNG quality: 0 (best quality, bigger file) to 9 (worst quality, smaller file)
$quality = 9 - min( round($this->quality / 10), 9 );
if ($this->save_to_file) {
$res = ImagePNG($im, $filename, $quality);
}
else {
header("Content-type: image/png");
$res = ImagePNG($im, NULL, $quality);
}
}
else {
if ($this->save_to_file) {
$res = ImagePNG($im, $filename);
}
else {
header("Content-type: image/png");
$res = ImagePNG($im);
}
}
break;
}    return $res; 
}

function ImageCreateFromType($type,$filename) {
$im = null;
switch ($type) {
case 1:
$im = ImageCreateFromGif($filename);
break;
case 2:
$im = ImageCreateFromJpeg($filename);
break;
case 3:
$im = ImageCreateFromPNG($filename);
break;
}
return $im;
}
// generate thumb from image and save it
function GenerateThumbFile($from_name, $to_name,$X,$Y,$textString) {
$this->max_x=$X;
$this->max_y=$Y;
// if src is URL then download file first
$temp = false;
if (substr($from_name,0,7) == 'http://') {
$tmpfname = tempnam("tmp/", "TmP-");
$temp = @fopen($tmpfname, "w");
if ($temp) {
@fwrite($temp, @file_get_contents($from_name)) or die("Cannot download image");
@fclose($temp);
$from_name = $tmpfname;
}
else {
die("Cannot create temp file");
}
}
// check if file exists
if (!file_exists($from_name)) die("Source image does not exist!");

// get source image size (width/height/type)
// orig_img_type 1 = GIF, 2 = JPG, 3 = PNG
list($orig_x, $orig_y, $orig_img_type, $img_sizes) = @GetImageSize($from_name);
if($this->max_x=="") { $this->max_x=$orig_x;}
if($this->max_y=="") { $this->max_y=$orig_y;}
// cut image if specified by user
if ($this->cut_x > 0) $orig_x = min($this->cut_x, $orig_x);
if ($this->cut_y > 0) $orig_y = min($this->cut_y, $orig_y); 
// should we override thumb image type?
$this->image_type = ($this->image_type != -1 ? $this->image_type : $orig_img_type); 
// check for allowed image types
if ($orig_img_type < 1 or $orig_img_type > 3) die("Image type not supported");

if ($orig_x > $this->max_x or $orig_y > $this->max_y) {   

// resize
$per_x = $orig_x / $this->max_x;
$per_y = $orig_y / $this->max_y;
if ($per_y > $per_x) {
$this->max_x = $orig_x / $per_y;
}
else {
$this->max_y = $orig_y / $per_x;
} 
}
else {
// keep original sizes, i.e. just copy
if ($this->save_to_file) {
@copy($from_name, $to_name);
}
else {
switch ($this->image_type) {
case 1:
header("Content-type: image/gif");
readfile($from_name);
break;
case 2:
header("Content-type: image/jpg");
readfile($from_name);
break;
case 3:
header("Content-type: image/png");
readfile($from_name);
break;
}
}
return;
}
if ($this->image_type == 1) {
// should use this function for gifs (gifs are palette images)
$ni = imagecreate($this->max_x, $this->max_y);
}
else {
// Create a new true color image
$ni = imagecreatetruecolor($this->max_x,$this->max_y);
} 
// Fill image with white background (255,255,255)
$white = imagecolorallocate($ni, 255, 255, 255);
imagefilledrectangle( $ni, 0, 0, $this->max_x, $this->max_y, $white);
// Create a new image from source file
$im = $this->ImageCreateFromType($orig_img_type,$from_name);

// Copy the palette from one image to another
imagepalettecopy($ni,$im);
// Copy and resize part of an image with resampling
imagecopyresampled(
$ni, $im,             // destination, source
0, 0, 0, 0,           // dstX, dstY, srcX, srcY
$this->max_x, $this->max_y,       // dstW, dstH
$orig_x, $orig_y);    // srcW, srcH

//place some text at the top left
//$textcolor = imagecolorallocate($im, 0, 0, 255);
//please download any gd font anf put name here
$font = imageloadfont('./04b.gdf'); 
imagestring($ni,$font, 0, 0, $textString, 0xFF0000);
// merge the two canvas
//set opacity to 50%
imagecopymerge($im, $ni, 0, 0, 0, 0, $this->max_x,  $this->max_y, 50);

// save thumb file
$this->SaveImage($ni, $to_name);

if($temp) {
unlink($tmpfname); // this removes the file
} }}
function generate_image($thumb,$source,$maxX,$maxY,$text)
{

$img = new Thumb_image; 
$save_to_file = true;
$image_quality = 100;
$image_type = -1;
$cut_x = 0;
$cut_y = 0;

$max_x = $maxX;
$max_y = $maxY; 

$img->cut_x        = $cut_x;
$img->cut_y        = $cut_y;
$img->quality      = $image_quality;
$img->save_to_file = $save_to_file;
$img->image_type   = $image_type;
$img->GenerateThumbFile($source, $thumb,$max_x,$max_y,$text);
}
$source ="1.jpg";
$thumb =time().".jpg";
$text="THUMB";
generate_image($thumb,$source,400,350,$text);

PHP: How to convert the wav file to mp3

2010-02-12T03:03:00.001-08:00

Using following one line code you can convert the any wav file to mp3 on the fly in PHP.

exec("sox $SourcePath -t wav -s -w - | lame -V 1  - $Destination");

PHP: How to unzip / extract the file in PHP

2010-02-11T23:31:00.000-08:00

It is very easy to unzip the zip archives file on the fly in PHP. In PHP there is a 'ZipArchive' and extract functions to unzip/extract the zip file. But be sure it's installed on the sever and work properly. This code is helpful to extract the backup zip on the server. Just upload the code on server and write the name of zip file in code and run the code in browser. This code will unzip or extract the zip file on the server. Here is the code:

$zip = new ZipArchive;
echo $base =dirname(__FILE__);
if ($zip->open($base.'/sample.zip') === TRUE) {
  echo $zip->extractTo($base."/");
  $zip->close();
 die('Extraction Completed');
} else {
    die('Unable to open Updates Package');
}

PHP: How to create ZIP file in PHP / Create ZIP backup of files on server using PHP

2010-02-11T22:58:00.000-08:00

How to create a zip archives file from folders on the fly.
It is very easy to create the zip archives file on the fly in PHP. In PHP there is a 'ZipArchive' function to create zip file. But be sure it's installed on the sever and work properly. This code is helpful to create the backup's on the server. Just upload the code on server and create on backup folder and run the code in browser. This code will create the one zip file. Here is the code:

global $names ;
$names = array();
function walkTree($src,$des,$flag=false,$dirs=0,$files=0){
global $names;
if(!is_readable($des) && $flag){
mkdir($des);
}
$hndl =  opendir($src);
while(!false == ($entry = readdir($hndl))){
if($entry != "updater" && 
$entry != "backup" && $entry != "." && $entry != ".."){
if(filetype($src."/".$entry) == "dir" ){
$dirs++;
$stats = walkTree($src."/".$entry,$des."/".$entry,$flag,$dirs,$files);
$dirs = $stats[0];
$files = $stats[1];
}
else if(filetype($src."/".$entry) == "file" ){
$files++;
$names[] = $src."/".$entry;
if($flag){
copy($src."/".$entry,$des."/".$entry);
}}}}
return array($dirs,$files);}
$dir = dirname(__FILE__);
$hndl =  opendir($dir);
$output = "";
$stat = walkTree($dir,$dir);
$zip = new ZipArchive;
if($fp = fopen($dir.'/backup/backup.zip',"w"))
fclose($fp);
else
die("no file");
echo $dir.'/backup/backup.zip';
$res = $zip->open($dir.'/backup/backup.zip',ZIPARCHIVE::CREATE);
if ($res === TRUE) {
foreach($names as $name){
echo "
".$zip->addFile($name,str_replace(dirname(__FILE__),'',$name));
echo str_replace(dirname(__FILE__),'',$name)."
";
}
$zip->close();
}
else
die("Unable to create zip file");
echo "Backup Complete";

PHP: How to Create Thumbnail Images using PHP, Simple Code

2010-02-10T01:55:00.000-08:00

This tutorial will describe how to create thumbnail images on the fly using PHP. Furthermore you will learn how to process a whole folder of images and create their thumbnails. Since this requires the GD library, you will need an installation of PHP with at least GD 2.0.1 enabled. Below we will create a PHP script that contains two functions. The first one scans a provided directory for any .JPG images and, for each one, creates a thumbnail in the specified folder using the GD image functions. The second function creates an HTML file in the same directory as the script, which contains all of the thumbnails with links to the original images. This could be the basis of advanced photo gallery software. The code below creates a function named createThumbs that will get three parameters. The first and the second is correspondingly the path to the directory that contains original images and the path to the directory in which thumbnails will be placed. The third parameter is the width you want for the thumbnail images.

function createThumbs( $Mainimage, $ThumbImage, $thumbWidth )
{
      $img = imagecreatefromjpeg( "{$Mainimage}" );
      $width = imagesx( $img );
      $height = imagesy( $img );
      // calculate thumbnail size
      $new_width = $thumbWidth;
      $new_height = floor( $height * ( $thumbWidth / $width ) );
      // create a new temporary image
      $tmp_img = imagecreatetruecolor( $new_width, $new_height );
      // copy and resize old image into new image
      imagecopyresized( $tmp_img, $img, 0, 0, 0, 0, $new_width,
 $new_height, $width, $height );
      // save thumbnail into a file
      imagejpeg( $tmp_img, "{$ThumbImage}" );

}

createThumbs("/var/www/ffmpeg/1265717192.jpg",
"/var/www/ffmpeg/thumb/test.jpg",100);

PHP: How to create thumbnail and convert flv from any video in php

2010-02-06T02:46:00.001-08:00

First of all ffmpeg libaray is needed to work this code. You need to install the ffmpeg library on the linux server.Otherwise this code can't works
Convert any video to flv:

function convertFlv($source,$destination)
{
 exec("ffmpeg -i {$source} -ar 22050 -ab 32 -f flv -s 320x240 {$destination}");
}

$source = "/var/www/project/abc/video/sample.mov";
$destination = "/var/www/project/abc/flvfiles/sample.flv";
convertFlv($source,$destination);

Convert thumbnail form video file:

function getthumbnail($source, $image)
{
exec("ffmpeg -i {$source} -deinterlace -an -ss 1 
-t 00:00:01 -r 1 -y -vcodec mjpeg -f mjpeg {$image} 2>&1"); 
}
$source = "/var/www/project/abc/video/sample.mov";
$image = "/var/www/project/abc/image/sample.jpg";
getthumbnail($source, $image);

Installing PHP5 and Apache on Ubuntu

2010-02-06T02:38:00.000-08:00

If you are doing any kind of PHP development, you’ll almost always be using Apache along with it. Here’s the quick and easy way to get PHP up and running on your Ubuntu box
From a command shell, you will run the following commands:

    sudo apt-get install apache2
    sudo apt-get install php5
    sudo apt-get install libapache2-mod-php5
    sudo /etc/init.d/apache2 restart //restart server

   How to install FFMPEG library on ubantu
   sudo apt-get install php5-dev
  
   sudo apt-get install ffmpeg
 
   apt-get install libavcodec-dev

   sudo apt-get install mencoder

   How to install curl ssl on ubantu:    
   sudo apt-get install curl-ssl

Ubuntu – Enable mod_rewrite in Apache server

2010-02-06T02:32:00.000-08:00

At first I should define, what is mod_rewrite?
mod_rewrite is a part of Apache server that can rewrite requested urls on the fly.

To enable mod_rewrite in Ubuntu, you just need to write this command in terminal

sudo a2enmod rewrite

After enabling mod_rewrite you can write .htaccess file for your web application.

So what is .htaccess?
.htaccess file provides a way to make configuration changes on a per directory basis. It is a file contains configuration directives is placed in a particular document directory and the directives apply to that directory and all subdirectories thereof.
Some example:
Nice looking URLs (no querying) with pagination:
Suppose your url is: domain.com/article.php?name=title&page=5
You want to change: domain.com/articles/title/5/
Then write in .htaccess file:
RewriteRule ^articles/(A-Za-z0-9-]+)/([0-9]+)/?$ article.php?name=$1&page=$2 [L]
The rule is defined in regular expression. Here [L] means Last Rule. It’s called RewriteRule Flags.
Another example:
Suppose your site has permanently moved to a new domain.
RewriteCond %{HTTP_HOST} ^www.domain.com$ [NC]
RewriteRule ^(.*)$ http://www.domain2.com/$1 [R=301, L]

PHP: Date / Time Functions

2010-02-04T21:36:00.000-08:00

$today = date("F j, Y, g:i a");                 // March 10, 2010, 5:16 pm
$today = date("m.d.y");                         // 03.10.01
$today = date("j, n, Y");                       // 10, 3, 2010
$today = date("Ymd");                           // 20100310
$today = date('h-i-s, j-m-y, it is w Day');     // 05-16-18, 10-03-10, 1631 1618 6 Satpm01
$today = date('\i\t \i\s \t\h\e jS \d\a\y.');   // it is the 10th day.
$today = date("D M j G:i:s T Y");               // Sat Mar 10 17:16:18 MST 2010
$today = date('H:m:s \m \i\s\ \m\o\n\t\h');     // 17:03:18 m is month
$today = date("H:i:s"); 

Add 1 day in time
1 hour = 60 min * 60 sec
i day =  24 hrs * 60 min * 60 sec
$nextday = time() + (24 * 60 * 60);
$prevday = time() - (24 * 60 * 60);

echo date('l',time()); //Current day

$tomorrow  = mktime(0, 0, 0, date("m")  , date("d")+1, date("Y"));
$lastmonth = mktime(0, 0, 0, date("m")-1, date("d"),   date("Y"));
$nextyear  = mktime(0, 0, 0, date("m"),   date("d"),   date("Y")+1);

$nextWeek = time() + (7 * 24 * 60 * 60);
                   // 7 days; 24 hours; 60 mins; 60secs
echo 'Now:       '. date('Y-m-d') ."\n";
echo 'Next Week: '. date('Y-m-d', $nextWeek) ."\n";
// or using strtotime():
echo 'Next Week: '. date('Y-m-d', strtotime('+1 week')) ."\n";

PHP: Using SOAP with PHP

2010-02-04T21:19:00.000-08:00

Ho to use the soapclient in PHP
SOAP, the Simple Object Access Protocol, is the powerhouse of web services. It’s a highly adaptable, object-oriented protocol that exists in over 80 implementations on every popular platform, including AppleScript, JavaScript, and Cocoa. It provides a flexible communication layer between applications, regardless of platform and location. As long as they both speak SOAP, a PHP-based web application can ask a C++ database application on another continent to look up the price of a book and have the answer right away. Another Internet Developer article shows how to use SOAP with AppleScript and Perl. SOAP was created collaboratively as an open protocol. Early in its development, XML-RPC was spun off, and now enjoys its own popularity as a simpler alternative to SOAP. Both encode messages as XML, and both use HTTP to transport those messages. SOAP, however, can use other transport protocols, offers a number of high-end features, and is developing rapidly. (For more about SOAP and web services, try XML.com’s helpful demystification.) A SOAP transaction begins with an application making a call to a remote procedure. The SOAP client script then encodes the procedure request as an XML payload and sends it over the transport protocol to a server script. The server parses the request and passes it to a local method, which returns a response. The response is encoded as XML by the server and returned as a response to the client, which parses the response and passes the result to the original function. There are a number of different implementations of SOAP under PHP. It’s a shifting landscape: new ones appear, and old ones aren’t maintained or simply vanish. As of this writing, the most viable PHP implementation of SOAP seems to be Dietrich Ayala’s SOAPx4, also known as NuSOAP. This implementation is the most commonly used and appears to be the most fully developed and actively maintained, and it shows every sign of continuing to be a robust and popular solution. It’s not complete—a number of features, including full documentation, are still in the works—but it’s still a highly viable and easy-to-use SOAP solution.
There are many function to use the SOAP in PHP

$client = new SoapClient("http://www.sitename.com/soap/soap.class.api2.php?wsdl");
var_dump($client->__getTypes()); //it help to get all function running in soap xml

$data = array("API_KEY"=>'37383838',"USERNAME"=>'demouser');
$result = $client ->__soapCall(functions, array ('data'=>$data));

/* Methods */
public mixed __call ( string $function_name , string $arguments )
SoapClient ( mixed $wsdl [, array $options ] )
public string __doRequest ( string $request , string $location , string $action , int $version [, int $one_way = 0 ] )
public array __getFunctions ( void )
public string __getLastRequest ( void )
public string __getLastRequestHeaders ( void )
public string __getLastResponse ( void )
public string __getLastResponseHeaders ( void )
public array __getTypes ( void )
public void __setCookie ( string $name [, string $value ] )
public string __setLocation ([ string $new_location ] )
public bool __setSoapHeaders ([ mixed $soapheaders ] )
public mixed __soapCall ( string $function_name , array $arguments [, array $options [, mixed $input_headers [, array &$output_headers ]]] )
SoapClient ( mixed $wsdl [, array $options ] )

PHP: How to get data from XML file or API XML in PHP

2010-02-04T21:07:00.000-08:00

We have 2 methods to get the data from XML file. First one is simple method and 2nd ont is DOM method. For simple load method we are using PHP 'simplexml_load_file' function , but on some server it is not works so in that case we can use 'DOM' method to get the data from XML file. It is mostly used in the API implementation.
Simple file load method

$xmlfile = "sample.xml"; or $xmlfile = "http://sitename.com/sample.xml";
if(simplexml_load_file($xmlfile))
        {
         $xml =  simplexml_load_file($xmlfile);
           print_r($xml );
        }

DOM Method

$xml="http://www.sitename.com/xmllog/citydetails.xml";
$doc = new DOMDocument();
$doc->load( $xml );
$cityArray=  $doc->getElementsByTagName('city_details_row');
foreach($cityArray as $value ) 
  { 
    $city_name = $value->getElementsByTagName("city_name"); 
    $city  = $city_name->item(0)->nodeValue; 

    $city_id = $value->getElementsByTagName("city_id"); 
    $cityid  = $city_id->item(0)->nodeValue;  
  }

Magento: How to set session and get session in magento

2010-02-02T21:00:00.000-08:00

Using following magento code you can set and get the session value in magento site:

 Mage::getSingleton('core/session')->setYourVariable('data');
$Data = Mage::getSingleton('core/session')->getYourVariable();

Drupal: Some useful path for drupal site

2010-02-01T02:13:00.000-08:00

Drupal useful paths:

Drupal Theme Path:

path_to_theme();

Drupal: How select query can be used in drupal, Drupal mysql select query

2010-01-31T23:02:00.000-08:00

Using following code you can get the data from drupal site database.

$result = db_query("SELECT title FROM tablename");
 while ($record = db_fetch_object($result)) {
echo $record->title;
}

Drupal: How can drupal database connection, function can use from outside

2010-01-27T20:38:00.000-08:00

I worked on Drupal project.For dynamic flash content come from one PHP generated XML. I faced one problem there. For XML i need to access the drupal database connection outside from drupal environment. I search a lot on Google, but no luck. then from drupal i find following code to use all drupal function and database connection outside. Here is the code:-

include_once './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);

Magento: How to use select, update, delete and insert queries in magento.

2010-01-20T22:17:00.000-08:00

It is very easy to select, insert, delete and update the record in magento site. following functions are helpful in magento site for database queries. You can also use this function outside magento environment with the help pf include "Mage.php" file form "app" folder like

 require_once '../../app/Mage.php';
Mage::app('default');
//Select query to get the value form table
$connection = Mage::getSingleton('core/resource')
->getConnection('core_read');
$select = $connection->select()
->from('tablename', array('*')) // select * from tablename or use array('id','name') selected values
->where('id=?',1)               // where id =1
->group('name');         // group by name
$rowsArray = $connection->fetchAll($select); // return all rows
$rowArray =$connection->fetchRow($select);   //return row

//insert query
$connection = Mage::getSingleton('core/resource')
->getConnection('core_write');
$connection->beginTransaction();
$fields = array(); 
$fields['name']= 'test';
$fields['age']='25';
$connection->insert('tablename', $fields);
$connection->commit();

//update query
$connection = Mage::getSingleton('core/resource')
->getConnection('core_write');
$connection->beginTransaction();
$fields = array();
$fields['name'] = 'jony';
$where = $connection->quoteInto('id =?', '1');
$connection->update('tablename', $fields, $where);
$connection->commit();


//delete query
$condition = array($connection->quoteInto('id=?', '1'));
$connection->delete('tablename', $condition);

Magento: How can access the magento classes, function, database from magento files

2010-01-20T21:40:00.000-08:00

It is very easy to access all magento classes, function and database connection from outside magento environment just include Mage.php file in the page

include("app/Mage.php");

Magento: How to upload file, image in magento

2010-01-20T21:27:00.000-08:00

Magento: How to upload file, image in magento.
With help of following simple magento you can upload any file or image in any magento site folder

if(isset($_FILES['filename']['name']) && $_FILES['filename']['name'] != '') {
try { 
/* Starting upload */ 
$uploader = new Varien_File_Uploader('filename');
// Any extention would work
$uploader->setAllowedExtensions(array('jpg','jpeg','gif','png'));
$uploader->setAllowRenameFiles(false);
// Set the file upload mode 
// false -> get the file directly in the specified folder
// true -> get the file in the product like folders 
// (file.jpg will go in something like /media/f/i/file.jpg)
$uploader->setFilesDispersion(false);
// We set media as the upload dir
$path = Mage::getBaseDir('media') . DS ;
$uploader->save($path, $_FILES['filename']['name'] );
} catch (Exception $e) {
}
$filename=$_FILES['filename']['name'];
}

Magento site url

2010-01-20T21:13:00.001-08:00

It is easy to get you magento site base url. Using following magento function you can get url.

Mage::getBaseUrl();

If you want ot get url in inner pages like http://sitename.com/index.php/test
Then use:  dirname(Mage::getBaseUrl()) code to get path
$path = dirname(Mage::getBaseUrl())."/media/";

PHP: Generate password / Create a random password

2010-01-18T02:42:00.000-08:00

PHP: Generate password / Create a random password

function createCode2()
{
  $Key="";
  while(strlen($Key)<=5)
 {
    srand((double)microtime()*1000000);
    $number = rand(50,150);
    if($number>=65 && $number<=78)
   $Key = $Key.chr($number);
    elseif($number>=80 && $number<=90)
   $Key = $Key.chr($number); 
    elseif($number>=49 && $number<=57)
   $Key = $Key.chr($number);
    }
  return trim($Key); 
}

htaccess url rewrite, how to write www before sitename

2010-01-17T23:08:00.000-08:00

Redirect to www (htaccess redirect) Create a .htaccess file with the below code, it will ensure that all requests coming in to domain.com will get redirected to www.domain.com The .htaccess file needs to be placed in the root directory of your old website (i.e the same directory where your index file is placed) Following htaccess code is helpful to convert the non www domain url to www url.

Options +FollowSymlinks
RewriteEngine on
rewritecond %{http_host} ^domain.com [nc]
rewriterule ^(.*)$ http://www.domain.com/$1 [r=301,nc]

PHP Breadcrumb Class

2010-01-15T03:30:00.000-08:00

There are many types of php breadcrumb classes but here following class simple and easy to use class. I have a lot of experience with this class it's works fine.

<?php
class Breadcrumb{
   var $output;
   var $crumbs = array();
   var $location;
   function Breadcrumb(){     
     if(isset($_SESSION['breadcrumb'])) {
   if ($_SESSION['breadcrumb'] != null){
         $this->crumbs = $_SESSION['breadcrumb'];
      }  
   }
   }  
   function add($label, $url, $level){
      $crumb = array();
      $crumb['label'] = $label;
      $crumb['url'] = $url; 
      if ($crumb['label'] != null  && isset($level)){                   
         while(count($this->crumbs) > $level){
            array_pop($this->crumbs); 

         }

         if (!isset($this->crumbs[0]) && $level > 0){ 
            $this->crumbs[0]['url'] = "/index.php";
            $this->crumbs[0]['label'] = "Home";
         }
         $this->crumbs[$level] = $crumb;                 
      }
        $_SESSION['breadcrumb'] = $this->crumbs; 
     
   }
   function output(){
      echo "<div id='breadcrumb'><ul>";
       $i=1;
      foreach ($this->crumbs as $crumb){ 
        if($i==1)
  {  if ($crumb['url'] != null){  
     echo "<li><a href='".$crumb['url']."' title='".$crumb['label']."'>".$crumb['label']."</a></li> ";  
     } else {  
     echo "<li>  ".$crumb['label']." > </li> ";  
    }
  }
  else
  {
    if ($crumb['url'] != null){  
     echo "<li> > <a href='".$crumb['url']."' title='".$crumb['label']."'>".$crumb['label']."</a> </li> ";  
     } else {  
     echo "<li> > ".$crumb['label']." </li> ";  
    }   
  }
  $i++;
      }

      echo "</ul></div>";
   }
}
?> 

//how to use
$bread = new Breadcrumb();
$bread->add('Home', './index.php', 0); //last page  
$bread->add('Account', $_SERVER['PHP_SELF'], 1);  
$bread->output();

PHP XML Read Function

2010-01-15T03:21:00.000-08:00

It's just a 10-12 line code to get the data from XML file.

$xmlfile="samplexmlfile.xml";
if(file_exists($xmlfile)) {
if(simplexml_load_file($xmlfile))
        {
         $xml =  simplexml_load_file($xmlfile);
        print_r($xml );        }
}
else
{
 die("no file");
}

Google AJAX Search API for Developers

2010-01-15T03:09:00.000-08:00

It's My favorites Google AJAX search API , helpful to search content, websites, images on your website with a simple JavaScript code. Click here to get code

Google AJAX Search Api for Developers

The Google AJAX Search API allows you to easily integrate some very powerful and diverse Google based search mechanisms or "controls" onto a Web page with relatively minimal coding. These includes:

Web Search on your website: This is a traditional search input field where, when a query is entered, a series of text search results appear on the page.
Local Search: With Local Search, a Google Map is mashed together with a search input field and the search results are based on a specific location.
Video/Image Search: The AJAX Video Search provides the ability to offer compelling video/Image search along with accompanying video based search results.

Example:

<script src="www.google.com/uds/api?file=uds.js&v=1.0
                &key=YOUR-KEY" type="text/javascript"></script>
   <script type="text/javascript">
   //<![CDATA[
   function onLoad() {
      // Create a search control
      var googleSearchControl = new GSearchControl();

      // Add in a full set of searchers
      var localSearch = new GlocalSearch();
      googleSearchControl.addSearcher(localSearch);
      googleSearchControl.addSearcher(new GwebSearch());
      googleSearchControl.addSearcher(new GvideoSearch());
      googleSearchControl.addSearcher(new GblogSearch());
      googleSearchControl.addSearcher(new GnewsSearch());
      googleSearchControl.addSearcher(new GbookSearch());

      // Set the Local Search center point
      localSearch.setCenterPoint("New York, NY");

      // tell the searcher to draw itself and tell it where to attach
      googleSearchControl.draw(document.getElementById("resultDiv"));

      // execute an inital search
      googleSearchControl.execute("google");
   }
   GSearch.setOnLoadCallback(onLoad);

   //]]>
</script>
<div id="resultDiv">Loading</div>

AJAX JavaScript Function

2010-01-15T02:49:00.000-08:00

Simple AJAX JavaScript function. That is the function which is called just like any other JavaScript function, passing in those two required parameters. The only other requirement is to make sure you have a div,span with the ID you are passing in the function call.

// JavaScript Document
function ajaxFunction(url,element){
  
  var xmlHttp;
  try
    {
    // Firefox, Opera 8.0+, Safari
    xmlHttp=new XMLHttpRequest();
    }
  catch (e)
    {
    // Internet Explorer
    try
      {
      xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
      }
    catch (e)
      {
      try
        {
        xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
        }
      catch (e)
        {
        alert("Your browser does not support AJAX!");
        return false;
        }
      }
    }
    xmlHttp.onreadystatechange=function()
      {
      if(xmlHttp.readyState==4)
        {
   if (xmlHttp.status == 200) {
    if(element != "")
    { //alert(xmlHttp.responseText);
     //alert(element) 
     if(document.getElementById(element))
     {
      document.getElementById(element).value = "";
     }

     document.getElementById(element).innerHTML=xmlHttp.responseText;
    }

         }
  }
  else
  {
   document.getElementById(element).innerHTML="Loading ....";
  }
      }
    xmlHttp.open("GET",url,true);
    xmlHttp.send(null);
  }

PHP: Database Connection Class with select , insert, delete, update functions

2010-01-15T02:25:00.000-08:00

To create our database connection class we will be using PHP's class structure. Following class is very simple class for PHP. This PHP Database Connection Class have functions for mysql select , insert, delete, update queries.

// Coding Standards : Todd Hoff and Fredrik Kristiansen
define('ERROR_QUERY','Error In Query');
define('ERROR_CONNECTION','Error In Connection');
class FwConnection 
{
 var  $mConnection;
 var  $mHost;
 var  $mDatabase;
 var  $mUser;
 var  $mError;
 var  $mData = array();
 var  $mQueryLog = array();
 var  $mErrorLog = array();
 var  $mDebug = array();
 var  $mIsLogQuery = true;
 var  $mIsLogError = true;
 var  $mIsDebug = true;
 var $bugtrackker; 

 function FwConnection($connectionHost,$connectionUser,$connectionPass,$connectionDb)
 {
  $connection = @mysql_pconnect($connectionHost,$connectionUser,$connectionPass);
  mysql_select_db($connectionDb,$connection);
  if (true == is_resource($connection))
  {
   $this->mConnection  = $connection;
   $this->mHost   = $connectionHost;
   $this->mDatabase  = $connectionDb;
   $this->mUser   = $connectionUser;
  }
  else
  {
   $this->LogError(ERROR_CONNECTION);
  } }
 /**
  * Executes the Query
  *
  * @param string(Query) $query
  * @return string(Message)
  */
 function MakeQuery($query)
 {
         //echo $query;
  $this_query = mysql_query($query,$this->mConnection);
  $this->LogQuery($query);
  $query_type = substr($query,0,6);
  if($query_type == 'select')
  {

   if (true == (is_resource($this_query)))
   {
    return $this_query;
   }
   else
   { $query = ''.$query.'';
    $this->LogError('
['.ERROR_QUERY .'] ' . $query);
    return false;
   }
  }
  elseif($query_type == 'show c')
  {
   return $this_query;
  }
  else
  {if ($this_query==1)

   { $aff_rows = ''.mysql_affected_rows($this->mConnection).'';
    return '
' . $query_type . " command successfully executed!. ($aff_rows) row(s) affected";
   }
   else 
   {$query = ''.$query.'';

   $this->LogError('
['.ERROR_QUERY .'] ' . $query . ''. mysql_error().'');
    return '
' . ''. mysql_error().'';
   }
  }
 }
 function LogError($error)
 {if (true == $this->mIsLogError)
  {   $this->mErrorLog[] = '
Error:
' . $error;

  } if (true == $this->mIsDebug)
  {
   $this->mDebug[] = '
Error:
' . $error;
  }
 }
 function LogDebug($msg,$title)
 {
  if (true == $this->mIsDebug)
  {
   $this->mDebug[] = '
'.$title.':' . $msg ;
  }
 }
 function LogQuery($query)
 {
  if (true == $this->mIsLogQuery)
  {
   $this->mQueryLog[] = '
Query:
' . $query;
  }
  if (true == $this->mIsDebug)
  {
   $this->mDebug[] = '
Query:
' .$query;
  }
 }

 function Selectwithjoin($query,$condition=1){
 if ($condition == '')
  {
   $condition = 1;
  }

 $select_query = "select $query where $condition ";
 $query_resource = $this->MakeQuery($select_query);
 $rows = array();
  while ($row = mysql_fetch_assoc($query_resource))
  {
   $rows[] = $row;
  }
  $this->mData = $rows; 
 }
 function SelectLogin($tblFields,$tblName,$log,$pass)
 {
  if ('' != $limit)
  {
   $limit = ' limit '.$limit;
  }
  else
  {
   $limit='';
  }
$qry = "select $tblFields from $tblName where userName='".$log."' and password='".$pass."'";
  $result=mysql_query($qry);
  return $result;
 }
 function Select($tblFields,$tblName,$condition=1,$otherParam,$limit)
 {
  $params="";
  if ($condition == '')
  {
   $condition = 1;
  }
  if (''!= $otherParam && is_array($otherParam))
  {
   foreach ($otherParam as $cond=>$val)
   {
    $params .= " $cond $val ";
   }
  }
  if ('' != $limit)
  {
   $limit = ' limit '.$limit;
  }

   $select_query = "select $tblFields from $tblName where $condition ".$params." $limit ";
   $this->bugtrackker = $select_query ;
   return $this->RawQuery($select_query);
 }
 function InsertInto($tblName,$tblFields)
 {
  $fields = $this->SeprateFields($tblFields,'=',',');
  $select_query = "insert into $tblName set $fields";
  return $this->RawQuery($select_query);
 } 

 function UpdatebyID($tblName,$tblFields,$tblId,$tblVal)
 {
  $fields = $this->SeprateFields($tblFields,'=',',');
  $select_query = "update $tblName set $fields where $tblId = '$tblVal'";
  return $this->RawQuery($select_query);
 }
 function Update($tblName,$tblFields,$cond)
 {
  $fields = $this->SeprateFields($tblFields,'=',',');
  //$cond = $this->SeprateFields($cond,'=',',');
  $select_query = "update $tblName set $fields where $cond";
  $this->RawQuery($select_query);
  if (mysql_affected_rows($this->mConnection)>=1)
  {
  return 1;
  }
  else
  {
  return 0;
  }
 }
 function getInsertID()
 {  return mysql_insert_id();
 }
 function Delete($tblName,$tblFields)
 {  

  $select_query = "delete from $tblName where $tblFields";
  return $this->RawQuery($select_query);
 }
 function SeprateFields($tblFields,$inSep,$outSep)
 {
  $string="";
  if (is_array($tblFields))
  {
   foreach($tblFields as $head=>$val)
   {
    if ($val == 'NOW()')
    {
    $string .= " $head  $inSep $val $outSep";
    }
    else
    {
    $string .= " $head  $inSep '$val' $outSep";
    }
   }
   $string = substr($string,0,strlen($string)-strlen($outSep));
  }
  return $string;
 }
 function RawQuery($query)
 {
  $query_resource = $this->MakeQuery($query);
  $query_type = substr($query,0,6);
  if($query_type == 'select'  || $query_type == 'show c' || $query_type == 'show t')
  { $rows= $this->IterateRows($query_resource);
   $this->LogDebug($rows,'Result');
  }
  elseif ($query_type == 'insert' || 'update' || 'delete')
  {
   $this->LogDebug($query_resource,'Result');
  }
  if ($query_resource)
  {
   return true;
  }
  else
  {
   return false;
  }
 }
 function GetRows()
 {
  return($this->mData);
 }
 function IterateElement(&$element)
 {
  if (!empty($element))
  {
   foreach($element as $debug)
   {
    $debug_info  .=  $debug . '\n';

   }
   return $debug_info;
  }
  else
  {
   return false;
  } }
 function IterateElementAndSubElements(&$element)
 {
  $Iteration="";
  $i="";
  if (!empty($element))
  {
   $Iteration .= '
';
   foreach($element as $head => $debug)
   {$Iteration .= ++$i . ') ';
    if (is_array($debug))
    {
     $Iteration .= $this->IterateElementAndSubElements($debug);
    }
    else
    {
     $Iteration .= "[$head] : " . $debug . ',';
    }
    $Iteration .= '
';
   }
   $Element = $Iteration;
   return $Element;
  }
  else 
  {
   return false;
  }
 }
 function IterateRows(&$query_resource)
 {
  $rows = array();
  while ($row = mysql_fetch_assoc($query_resource))
  {
   $rows[] = $row;
  }
  $this->mData = $rows;
  return ($this->IterateElementAndSubElements($this->mData)); }



 /**

  * Shows the Description of the Particular Connection including ConnectionId, Host, Database and User
  *
  * @return string

  */

 function ShowConnectionStatus()

 {
  $connection_status = 'Connection ID : ' . $this->mConnection .'
';
  $connection_status .= 'Host: ' . $this->mHost . '
';
  $connection_status .= 'Database: ' . $this->mDatabase . '
';
  $connection_status .= 'User: ' . $this->mUser. '
';
  return $connection_status;
 }
 function Show($element)
 {
  switch ($element)
  {
   case 'debug':
    $ele_cnd = &$this->mIsDebug;
    $ele = $this->mDebug;
    break;
   case 'error':
    $ele_cnd = &$this->mIsLogError;
    $ele = $this->mErrorLog;
    break;
   case 'query':
    $ele_cnd = &$this->mIsLogQuery;
    $ele = $this->mQueryLog;
    break;
  }
  if (true == $ele_cnd)
  {
   $this->FwJavaScript();
   $debug_string = $this->ShowConnectionStatus();
   $debug_string .= $this->IterateElement($ele);
   $this->AlertInDiv($debug_string);
  }
 }
     function CheckIfNotExists($galleryTable,$galleryInfo)
 {
   $this->Select("count(*)",$galleryTable,'fld_name = "' . $galleryInfo .'"','',1);
   $results = $this->GetRows();
   if (($results[0]['count(*)'])>=1)
   {
   return false;
   }
   else
   {return true;
   } 
 } 
 function NotExists($categoryTable,$categoryInfo)
 {
   $this->Select("count(*)",$categoryTable,'cate_name = "' . $categoryInfo .'"','',1);
    $results = $this->GetRows();
   if (($results[0]['count(*)'])>=1)
   {
   return false;
   }
   else
   {
   return true;
   } 
 }
 function GetLink()
 {
 return $this->mConnection;
 }
 }
$DbConnection = new FwConnection(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME);
//select
$DbConnection->Select("id,SubCat","tablename","where id=1","","");
$dataArray = $DbConnection->GetRows();
//update by id
$q= array("fieldname"=>'123');
$DbConnection->UpdatebyID("tablename",$q,"id",$_POST['id']);
//update
$q= array("fieldname"=>'123');
$DbConnection->Update("tablename",$q,"id = ".$_POST['id']);
//insert
$q= array("fieldname"=>'123');
$DbConnection->InsertInto("tablename",$q);
//delete
$DbConnection->Delete('tablename','id= "'.$_GET['id'].'"');

Special Characters in HTML

2010-01-14T02:01:00.001-08:00

HTML: Special Characters
HTML Entities and/or ISO Latin-1 codes can be placed in source code like any other alphanumeric characters to produce special characters and symbols that cannot be generated in HTML with normal keyboard commands.

left single quote		‘	‘
right single quote		’	’
single low-9 quote		&sbquo;	‚
left double quote		“	“
right double quote		”	”
double low-9 quote		&bdquo;	„
dagger		&dagger;	†
double dagger		&Dagger;	‡
per mill sign		&permil;	‰
single left-pointing angle quote		&lsaquo;	‹
single right-pointing angle quote		&rsaquo;	›
black spade suit		&spades;	♠
black club suit		&clubs;	♣
black heart suit		&hearts;	♥
black diamond suit		&diams;	♦
overline, = spacing overscore		&oline;	‾
leftward arrow		←	←
upward arrow		↑	↑
rightward arrow		→	→
downward arrow		↓	↓
trademark sign	™	™	™
unused	-
horizontal tab
line feed
unused
space
exclamation mark	!		!
double quotation mark	"	"	"
number sign	#		#
dollar sign	$		$
percent sign	%		%
ampersand	&	&	&
apostrophe	'		'
left parenthesis	(		(
right parenthesis	)		)
asterisk	*		*
plus sign	+		+
comma	,		,
hyphen	-		-
period	.		.
slash	/	&frasl;	/
digits 0-9	0- 9
colon	:		:
semicolon	;		;
less-than sign	<	<	<
equals sign	=		=
greater-than sign	>	>	>
question mark	?		?
at sign	@		@
uppercase letters A-Z	A- Z
left square bracket	[		[
backslash	\		\
right square bracket	]		]
caret	^		^
horizontal bar (underscore)	_		_
grave accent	`		`
lowercase letters a-z	a- z
left curly brace	{		{
vertical bar	\|		\|
right curly brace	}		}
tilde	~		~
unused	-
en dash		–	–
em dash		—	—
unused	-
nonbreaking space
inverted exclamation	¡	¡	¡
cent sign	¢	¢	¢
pound sterling	£	£	£
general currency sign	¤	¤	¤
yen sign	¥	¥	¥
broken vertical bar	¦	¦ or &brkbar;	¦
section sign	§	§	§
umlaut	¨	¨ or &die;	¨
copyright	©	©	©
feminine ordinal	ª	ª	ª
left angle quote	«	«	«
not sign	¬	¬	¬
soft hyphen
registered trademark	®	®	®
macron accent	¯	¯ or &hibar;	¯
degree sign	°	°	°
plus or minus	±	±	±
superscript two	²	²	²
superscript three	³	³	³
acute accent	´	´	´
micro sign	µ	µ	µ
paragraph sign	¶	¶	¶
middle dot	·	·	·
cedilla	¸	¸	¸
superscript one	¹	¹	¹
masculine ordinal	º	º	º
right angle quote	»	»	»
one-fourth	¼	¼	¼
one-half	½	½	½
three-fourths	¾	¾	¾
inverted question mark	¿	¿	¿
uppercase A, grave accent	À	À	À
uppercase A, acute accent	Á	Á	Á
uppercase A, circumflex accent	Â	Â	Â
uppercase A, tilde	Ã	Ã	Ã
uppercase A, umlaut	Ä	Ä	Ä
uppercase A, ring	Å	Å	Å
uppercase AE	Æ	Æ	Æ
uppercase C, cedilla	Ç	Ç	Ç
uppercase E, grave accent	È	È	È
uppercase E, acute accent	É	É	É
uppercase E, circumflex accent	Ê	Ê	Ê
uppercase E, umlaut	Ë	Ë	Ë
uppercase I, grave accent	Ì	Ì	Ì
uppercase I, acute accent	Í	Í	Í
uppercase I, circumflex accent	Î	Î	Î
uppercase I, umlaut	Ï	Ï	Ï
uppercase Eth, Icelandic	Ð	Ð	Ð
uppercase N, tilde	Ñ	Ñ	Ñ
uppercase O, grave accent	Ò	Ò	Ò
uppercase O, acute accent	Ó	Ó	Ó
uppercase O, circumflex accent	Ô	Ô	Ô
uppercase O, tilde	Õ	Õ	Õ
uppercase O, umlaut	Ö	Ö	Ö
multiplication sign	×	×	×
uppercase O, slash	Ø	Ø	Ø
uppercase U, grave accent	Ù	Ù	Ù
uppercase U, acute accent	Ú	Ú	Ú
uppercase U, circumflex accent	Û	Û	Û
uppercase U, umlaut	Ü	Ü	Ü
uppercase Y, acute accent	Ý	Ý	Ý
uppercase THORN, Icelandic	Þ	Þ	Þ
lowercase sharps, German	ß	ß	ß
lowercase a, grave accent	à	à	à
lowercase a, acute accent	á	á	á
lowercase a, circumflex accent	â	â	â
lowercase a, tilde	ã	ã	ã
lowercase a, umlaut	ä	ä	ä
lowercase a, ring	å	å	å
lowercase ae	æ	æ	æ
lowercase c, cedilla	ç	ç	ç
lowercase e, grave accent	è	è	è
lowercase e, acute accent	é	é	é
lowercase e, circumflex accent	ê	ê	ê
lowercase e, umlaut	ë	ë	ë
lowercase i, grave accent	ì	ì	ì
lowercase i, acute accent	í	í	í
lowercase i, circumflex accent	î	î	î
lowercase i, umlaut	ï	ï	ï
lowercase eth, Icelandic	ð	ð	ð
lowercase n, tilde	ñ	ñ	ñ
lowercase o, grave accent	ò	ò	ò
lowercase o, acute accent	ó	ó	ó
lowercase o, circumflex accent	ô	ô	ô
lowercase o, tilde	õ	õ	õ
lowercase o, umlaut	ö	ö	ö
division sign	÷	÷	÷
lowercase o, slash	ø	ø	ø
lowercase u, grave accent	ù	ù	ù
lowercase u, acute accent	ú	ú	ú
lowercase u, circumflex accent	û	û	û
lowercase u, umlaut	ü	ü	ü
lowercase y, acute accent	ý	ý	ý
lowercase thorn, Icelandic	þ	þ	þ
lowercase y, umlaut	ÿ	ÿ	ÿ
Alpha	Α		Α
alpha	α		α
Beta	Β		Β
beta	β		β
Gamma	Γ		Γ
gamma	γ		γ
Delta	Δ		Δ
delta	δ		δ
Epsilon	Ε		Ε
epsilon	ε		ε
Zeta	Ζ		Ζ
zeta	ζ		ζ
Eta	Η		Η
eta	η		η
Theta	Θ		Θ
theta	θ		θ
Iota	Ι		Ι
iota	ι		ι
Kappa	Κ		Κ
kappa	κ		κ
Lambda	Λ		Λ
lambda	λ		λ
Mu	Μ		Μ
mu	μ		μ
Nu	Ν		Ν
nu	ν		ν
Xi	Ξ		Ξ
xi	ξ		ξ
Omicron	Ο		Ο
omicron	ο		ο
Pi	Π		Π
pi	π		π
Rho	Ρ		Ρ
rho	ρ		ρ
Sigma	Σ		Σ
sigma	σ		σ
Tau	Τ		Τ
tau	τ		τ
Upsilon	Υ		Υ
upsilon	υ		υ
Phi	Φ		Φ
phi	φ		φ
Chi	Χ		Χ
chi	χ		χ
Psi	Ψ		Ψ
psi	ψ		ψ
Omega	Ω		Ω
omega	ω		ω
password dot	●		●
bullet	•		•

PHP Pagination Class

2010-01-14T01:27:00.000-08:00

PHP Pagination is a flexible and easy to implement PHP pagination
script which will help you split large result sets over multiple pages.
Main Features

Ease of integration with existing PHP applications
Easy to customize. The main class is just 200 code lines
Append custom parameters to pagination links
Flexibility in rendering pagination links

define("QS_VAR", "page"); 
define("NUM_ROWS",10); 
define("STR_FWD", "Next"); 
define("STR_BWD", "Previous"); 
define("IMG_FWD",  "next.gif");
define("IMG_BWD",  "prev.gif"); 
define("NUM_LINKS", 5);
class MyPagina { 
 var $sql;
 var $result;
 var $outstanding_rows = false; 
 var $get_var; var $rows_on_page;
 var $max_rows; 
 function MyPagina($rows = 0) {
  //$this->connect_db();
  $this->max_rows = $rows;
  $this->get_var = QS_VAR;
  $this->rows_on_page = NUM_ROWS;
 }
 function set_page() {
  $page = (isset($_REQUEST[$this->get_var]) && $_REQUEST[$this->get_var] != "") ? $_REQUEST[$this->get_var] : 0;
  return $page;
 }
 // gets the total number of records 
 function get_total_rows() {
  $tmp_result = mysql_query($this->sql);
  $all_rows = mysql_num_rows($tmp_result);
  if (!empty($this->max_rows) && $all_rows > $this->max_rows) {
   $all_rows = $this->max_rows;
   $this->outstanding_rows = true;
  }
  mysql_free_result($tmp_result);
  return $all_rows;
 }
 // database connection
 
 // get the totale number of result pages
 function get_num_pages() {
  $number_pages = ceil($this->get_total_rows() / $this->rows_on_page);
  return $number_pages;
 }
 // returns the records for the current page
 function get_page_result() {
  $start = $this->set_page() * $this->rows_on_page;
  $page_sql = sprintf("%s LIMIT %s, %s", $this->sql, $start, $this->rows_on_page);
  $this->result = mysql_query($page_sql);
  return $this->result;
 }
 // get the number of rows on the current page
 function get_page_num_rows() {
  $num_rows = mysql_num_rows($this->result);
  return $num_rows;
 }
 // free the database result
 function free_page_result() {
  mysql_free_result($this->result);
 }
 // function to handle other querystring than the page variable
 function rebuild_qs($curr_var) {
  if (!empty($_SERVER['QUERY_STRING'])) {
   $parts = explode("&", $_SERVER['QUERY_STRING']);
   $newParts = array();
   foreach ($parts as $val) {
    if (stristr($val, $curr_var) == false)  {
     array_push($newParts, $val);
    }
   }
   if (count($newParts) != 0) {
    $qs = "&".implode("&", $newParts);
   } else {
    return false;
   }
   return $qs; // this is your new created query string
  } else {
   return false;
  }
 } 
 
 // this method will return the navigation links for the conplete recordset
 function navigation($separator = " | ", $css_current = "", $back_forward = false, $use_images = false) {
  $max_links = NUM_LINKS;
  $curr_pages = $this->set_page(); 
  $all_pages = $this->get_num_pages() - 1;
  $totalrecords= $this->get_total_rows();
  $var = $this->get_var;
  $navi_string = "";
  if (!$back_forward) {
   $max_links = ($max_links < 2) ? 2 : $max_links;
  }
  if ($curr_pages <= $all_pages && $curr_pages >= 0) {
   if ($curr_pages > ceil($max_links/2)) {
    $start = ($curr_pages - ceil($max_links/2) > 0) ? $curr_pages - ceil($max_links/2) : 1;
    $end = $curr_pages + ceil($max_links/2);
    if ($end >= $all_pages) {
     $end = $all_pages + 1;
     $start = ($all_pages - ($max_links - 1) > 0) ? $all_pages  - ($max_links - 1) : 1;
    }
   } else {
    $start = 0;
    $end = ($all_pages >= $max_links) ? $max_links : $all_pages + 1;
   }
   if($all_pages >= 1) {
    $forward = $curr_pages + 1;
    $backward = $curr_pages - 1;
    // the text two labels are new sinds ver 1.02
    $lbl_forward = $this->build_back_or_forward("forward", $use_images);
    $lbl_backward = $this->build_back_or_forward("backward", $use_images);
    $navi_string .="Total Records: ".$totalrecords." | Go to Page ";
    if (!$back_forward) {
     for($a = $start + 1; $a <= $end; $a++){
      $theNext = $a - 1; // because a array start with 0
      
      if ($theNext != $curr_pages) {
       $navi_string .= "< a href=\"".$_SERVER['PHP_SELF']."?".$var."=".$theNext.$this->rebuild_qs($var)."\">";
       $navi_string .= $a."</a>";
       $navi_string .= ($theNext < ($end - 1)) ? $separator : "";
      } else {
       $navi_string .= ($css_current != "") ? "".$a."" : $a;
       $navi_string .= ($theNext < ($end - 1)) ? $separator : "";
      }
     }
    }
    $navi_string .="
";
    $navi_string .= ($curr_pages > 0) ? "< a href=\"".$_SERVER['PHP_SELF']."?".$var."=".$backward.$this->rebuild_qs($var)."\">".$lbl_backward."</a> " : $lbl_backward." ";
    $navi_string .= ($curr_pages < $all_pages) ? " <a href=\"".$_SERVER['PHP_SELF']."?".$var."=".$forward.$this->rebuild_qs($var)."\">".$lbl_forward."</a>" : " ".$lbl_forward;
    $navi_string .='
';
   }
  }
  return $navi_string;
 }
 // function to create the back/forward elements; $what = forward or backward
 // type = text or img
 function build_back_or_forward($what, $img = false) {
  $label['text']['forward'] = IMG_FWD;
  $label['text']['backward'] = IMG_BWD;
  $label['img']['forward'] = IMG_FWD;
  $label['img']['backward'] = IMG_BWD;
  if ($img) {
   $img_info = getimagesize($label['img'][$what]);
   $label = "<img src=\"".$label['img'][$what]."\" ".$img_info[3]." border=\"0\">";
  } else {
   $img_info = getimagesize($label['img'][$what]);
   $label = "<img src=\"".$label['img'][$what]."\" ".$img_info[3]." border=\"0\">";
  }
  return $label;
 }
 // this info will tell the visitor which number of records are shown on the current page
 function page_info($str = "Result: %d - %d of %d") {
  $first_rec_no = ($this->set_page() * $this->rows_on_page) + 1;
  $last_rec_no = $first_rec_no + $this->rows_on_page - 1;
  $last_rec_no = ($last_rec_no > $this->get_total_rows()) ? $this->get_total_rows() : $last_rec_no;
  $info = sprintf($str, $first_rec_no, $last_rec_no, $this->get_total_rows());
  return $info;
 }
 // simple method to show only the page back and forward link.
 function back_forward_link($images = false) {
  $simple_links = $this->navigation(" ", "", true, $images);
  return $simple_links;
 }
}

How to Create Thumbnail Images using PHP

2010-01-14T01:18:00.000-08:00

class Zubrag_image {
  var $save_to_file = true;
  var $image_type = -1;
  var $quality = 100;
  var $cut_x = 0;
  var $cut_y = 0; 
  function SaveImage($im, $filename) { 
    $res = null;
    // ImageGIF is not included into some GD2 releases, so it might not work
    // output png if gifs are not supported
    if(($this->image_type == 1)  && 
!function_exists('imagegif')) $this->image_type = 3;
    switch ($this->image_type) {
      case 1:
        if ($this->save_to_file) {
          $res = ImageGIF($im,$filename);
        }
        else {
          header("Content-type: image/gif");
          $res = ImageGIF($im);
        }
        break;
      case 2:
        if ($this->save_to_file) {
          $res = ImageJPEG($im,$filename,$this->quality);
        }
        else {
          header("Content-type: image/jpeg");
          $res = ImageJPEG($im, NULL, $this->quality);
        }
        break;
      case 3:
        if (PHP_VERSION >= '5.1.2') {
          $quality = 9 - min( round($this->quality / 10), 9 );
          if ($this->save_to_file) {
            $res = ImagePNG($im, $filename, $quality);
          }
          else {
            header("Content-type: image/png");
            $res = ImagePNG($im, NULL, $quality);
          }
        }
        else {
          if ($this->save_to_file) {
            $res = ImagePNG($im, $filename);
          }
          else {
            header("Content-type: image/png");
            $res = ImagePNG($im);
          }
        }
        break;    }
    return $res;
  }  function ImageCreateFromType($type,$filename) {
   $im = null;
   switch ($type) {
     case 1:
       $im = ImageCreateFromGif($filename);
       break;
     case 2:
       $im = ImageCreateFromJpeg($filename);
       break;
     case 3:
       $im = ImageCreateFromPNG($filename);
       break;
    }
    return $im;
  }
  function GenerateThumbFile($from_name, $to_name,$X,$Y) {
    $this->max_x=$X;
  $this->max_y=$Y;
    $temp = false;
    if (substr($from_name,0,7) == 'http://') {
      $tmpfname = tempnam("tmp/", "TmP-");
      $temp = @fopen($tmpfname, "w");
      if ($temp) {
        @fwrite($temp, @file_get_contents($from_name)) or 
         die("Cannot download image");
        @fclose($temp);
        $from_name = $tmpfname;
      }      else {
        die("Cannot create temp file");
      }    }
    // check if file exists
    if (!file_exists($from_name)) die("Source image does not exist!"); 
    list($orig_x, $orig_y, $orig_img_type, $img_sizes) = @GetImageSize($from_name);
 if($this->max_x=="") { $this->max_x=$orig_x;}
 if($this->max_y=="") { $this->max_y=$orig_y;}
    // cut image if specified by user
    if ($this->cut_x > 0) $orig_x = min($this->cut_x, $orig_x);
    if ($this->cut_y > 0) $orig_y = min($this->cut_y, $orig_y);
    // should we override thumb image type?
    $this->image_type = ($this->image_type != -1 ? $this->image_type : $orig_img_type);
    // check for allowed image types
    if ($orig_img_type < 1 or $orig_img_type > 3) die("Image type not supported");
    if ($orig_x > $this->max_x or $orig_y > $this->max_y) {
      // resize
     $per_x = $orig_x / $this->max_x;
      $per_y = $orig_y / $this->max_y;
      if ($per_y > $per_x) {
        $this->max_x = $orig_x / $per_y;   
   }      else {
        $this->max_y = $orig_y / $per_x;
      }    }    else {
      // keep original sizes, i.e. just copy
      if ($this->save_to_file) {
        @copy($from_name, $to_name);
      }      else {
        switch ($this->image_type) {
          case 1:
              header("Content-type: image/gif");
              readfile($from_name);
            break;
          case 2:
              header("Content-type: image/jpg");
              readfile($from_name);
            break;
          case 3:
              header("Content-type: image/png");
              readfile($from_name);
            break;
        }      }
      return;
    }
    if ($this->image_type == 1) {
      // should use this function for gifs (gifs are palette images)
      $ni = imagecreate($this->max_x, $this->max_y);    }
    else {
      // Create a new true color image
      $ni = imagecreatetruecolor($this->max_x,$this->max_y);
    }   // Fill image with white background (255,255,255)
    $white = imagecolorallocate($ni, 255, 255, 255);
 imagefilledrectangle( $ni, 0, 0, $this->max_x, $this->max_y, $white);
    // Create a new image from source file
    $im = $this->ImageCreateFromType($orig_img_type,$from_name);
    // Copy the palette from one image to another
    imagepalettecopy($ni,$im);
    imagecopyresampled(
      $ni, $im,             // destination, source
      0, 0, 0, 0,           // dstX, dstY, srcX, srcY
      $this->max_x, $this->max_y,       // dstW, dstH
      $orig_x, $orig_y);    // srcW, srcH
    // save thumb file
    $this->SaveImage($ni, $to_name);
    if($temp) {
      unlink($tmpfname); // this removes the file
    } }}
$img = new Zubrag_image; 
$image = "test.jpg";
$dirMain = "/var/www/projects/test/images/";
$dirThumb = "/var/www/projects/test/images/thumb"
$img->GenerateThumbFile($dirMain.$image, $dirThumb.$image,$imageHeight);


?>

Magento: How to get the products by category in magento

2010-01-08T01:03:00.000-08:00

Please use following code to get the all product for category in magento site.

$cat_id=19;
 //assign any category id
    $category = new Mage_Catalog_Model_Category();
    $category->load($cat_id);
    $collection = $category->getProductCollection();
    foreach ($collection as $product) {
        $result[] = $product->getId();
    }
Here $result is array of all products ids
$i=0;
foreach ($result as $_product_id){
    $i++;
    $_product = new Mage_Catalog_Model_Product();
    $_product->load($_product_id);
    //do something with the product here
   $productUrl = $_product->getProductUrl();
   $productTitle = $this->htmlEscape($_product->getName());
   $productImage = $this->helper('catalog/image')->
                    init($_product, 'small_image')->resize(80, 77);
}

How to display the products on your magento site home page

2010-01-06T23:32:00.000-08:00

There are numerous ways to put products on your home page, and we’ll compile a list of code snippets you can use on your own store here. Products on magento site home page:
All following code in admin section CMS >> Manage Pages >> home
You can also add the following code in General information section

{{block type="catalog/product_list" category_id="3"
 template="catalog/product/list.phtml"}}

htaccess tips and tricks

2009-12-22T23:04:00.000-08:00

Introduction to .htaccess This work in constant progress is some collected wisdom, stuff I've learned on the topic of .htaccess hacking, commands I've used successfully in the past, on a variety of server setups, and in most cases still do. You may have to tweak the examples some to get the desired result, though, and a reliable test server is a powerful ally, preferably one with a very similar setup to your "live" server.
.htaccess files are invisible
What are .htaccess files
Simply put, they are invisible plain text files where one can store server directives. Server directives are anything you might put in an Apache config file (httpd.conf) or even a php.ini**, but unlike those "master" directive files, these .htaccess directives apply only to the folder in which the .htaccess file resides, and all the folders inside.
This ability to plant .htaccess files in any directory of our site allows us to set up a finely-grained tree of server directives, each subfolder inheriting properties from its parent, whilst at the same time adding to, or over-riding certain directives with its own .htaccess file. For instance, you could use .htacces to enable indexes all over your site, and then deny indexing in only certain subdirectories, or deny index listings site-wide, and allow indexing in certain subdirectories. One line in the .htaccess file in your root and your whole site is altered. From here on, I'll probably refer to the main .htaccess in the root of your website as "the master .htaccess file", or "main" .htaccess file.
There's a small performance penalty for all this .htaccess file checking, but not noticeable, and you'll find most of the time it's just on and there's nothing you can do about it anyway, so let's make the most of it..
Is .htaccess enabled?
It's unusual, but possible that .htaccess is not enabled on your site. If you are hosting it yourself, it's easy enough to fix; open your httpd.conf in a text editor, and locate this

What can I do with .htaccess files?
Almost any directive that you can put inside an httpd.conf file will also function perfectly inside an .htaccess file. Unsurprisingly, the most common use of .htaccess
.htaccess URL writing tool
.htaccess Exapmles

First write following code to activate the rewrite url action
Options +FollowSymLinks
RewriteEngine on
http://sitename.com/event.php?id=1 to http://sitename.com/event/1.html 
RewriteRule ^event/([0-9]+)\.html$ event.php?eventid=$1

Options +FollowSymlinks
RewriteEngine on
rewritecond %{http_host} ^domain.com [nc]
rewriterule ^(.*)$ http://www.domain.com/$1 [r=301,nc]

Error Documents ErrorDocument 404 /errors/notfound.html This would cause any error code resulting in 404 to be forward to yoursite.com/errors/notfound.html Likewise with: ErrorDocument 500 /errors/internalerror.html You can name the pages anything you want (I'd recommend something that would prevent you from forgetting what the page is being used for), and you can place the error pages anywhere you want within your site, so long as they are web-accessible (through a URL). The initial slash in the directory location represents the root directory of your site, that being where your default page for your first-level domain is located. I typically prefer to keep them in a separate directory for maintenance purposes and in order to better control spiders indexing them through a ROBOTS.TXT file, but it is entirely up to you. If you were to use an error document handler for each of the error codes I mentioned, the htaccess file would look like the following (note each command is on its own line): ErrorDocument 400 /errors/badrequest.html ErrorDocument 401 /errors/authreqd.html ErrorDocument 403 /errors/forbid.html ErrorDocument 404 /errors/notfound.html ErrorDocument 500 /errors/serverr.html You can specify a full URL rather than a virtual URL in the ErrorDocument string (http://yoursite.com/errors/notfound.html vs. /errors/notfound.html). But this is not the preferred method by the server's happiness standards. Blocking users by IP Is there a pesky person perpetrating pain upon you? Stalking your site from the vastness of the electron void? Blockem! In your htaccess file, add the following code--changing the IPs to suit your needs--each command on one line each: order allow,deny deny from 123.45.6.7 deny from 012.34.5. allow from all You can deny access based upon IP address or an IP block. The above blocks access to the site from 123.45.6.7, and from any sub domain under the IP block 012.34.5. (012.34.5.1, 012.34.5.2, 012.34.5.3, etc.) I have yet to find a useful application of this, maybe if there is a site scraping your content you can block them, who knows.

Magento Module Creator

2009-12-21T03:57:00.000-08:00

This code is helpful to create a new magento extension. Click Here to Download Magento Module Creater

Php Captcha Security Image Font Based

2009-12-21T03:52:00.000-08:00

A CAPTCHA or Captcha is a type of challenge-response test used in computing to ensure that the response is not generated by a computer. The process usually involves one computer (a server) asking a user to complete a simple test which the computer is able to generate and grade. Because other computers are unable to solve the CAPTCHA, any user entering a correct solution is presumed to be human. Thus, it is sometimes described as a reverse Turing test, because it is administered by a machine and targeted to a human, in contrast to the standard Turing test that is typically administered by a human and targeted to a machine. A common type of CAPTCHA requires that the user type letters or digits from a distorted image that appears on the screen.

img src="./CaptchaSecurityImages.php?width=100&height=40&characters=5" 

File : CaptchaSecurityImages.php

class CaptchaSecurityImages {

 var $font = './font/monofont.ttf';

 function generateCode($characters) {
  $code = "";
  /* list all possible characters, similar looking characters and vowels have been removed */
  $possible = '23456789bcdfghjkmnpqrstvwxyz';
  $code = '';
  $i = 0;
  while ($i < $characters) { 
   $code .= substr($possible, mt_rand(0, strlen($possible)-1), 1);
   $i++;
  }
  return $code;
 }

 function CaptchaSecurityImages($width='120',$height='40',$characters='6') {
  $code = $this->generateCode($characters);
  $_SESSION['security_code'] = $code;
  /* font size will be 75% of the image height */
  $font_size = $height * 0.75;
  $image = @imagecreate($width, $height) or die('Cannot initialize new GD image stream');
  /* set the colours */
  $background_color = imagecolorallocate($image, 255, 255, 255);
  $text_color = imagecolorallocate($image, 20, 40, 100);
  $noise_color = imagecolorallocate($image, 100, 120, 180);
  /* generate random dots in background */
  for( $i=0; $i<($width*$height)/3; $i++ ) {
   imagefilledellipse($image, mt_rand(0,$width), mt_rand(0,$height), 1, 1, $noise_color);
  }
  /* generate random lines in background */
  for( $i=0; $i<($width*$height)/150; $i++ ) {
   imageline($image, mt_rand(0,$width), mt_rand(0,$height), mt_rand(0,$width), mt_rand(0,$height), $noise_color);
  }
  /* create textbox and add text */
  $textbox = imagettfbbox($font_size, 0, $this->font, $code) or die('Error in imagettfbbox function');
  $x = ($width - $textbox[4])/2;
  $y = ($height - $textbox[5])/2;
  imagettftext($image, $font_size, 0, $x, $y, $text_color, $this->font , $code) or die('Error in imagettftext function');
  /* output captcha image to browser */
  header('Content-Type: image/jpeg');
  imagejpeg($image);
  imagedestroy($image);
 }

}

$width = isset($_GET['width']) ? $_GET['width'] : '120';
$height = isset($_GET['height']) ? $_GET['height'] : '40';
$characters = isset($_GET['characters']) && $_GET['characters'] > 1 ? $_GET['characters'] : '6';

$captcha = new CaptchaSecurityImages($width,$height,$characters);

Jscolor : Color Picker

2009-12-15T22:21:00.000-08:00

jscolor is a simple & user-friendly color picker for your web forms. It extends all desired input fields of a smooth color selection dialog. You can pickerize these inputs in two easy steps: 1. set them to input class="color" 2. include script jscolor.js into your HTML page.

No framework needed (jQuery, MooTools, YUI, Dojo…)
Quick & easy installation
No popup windows
Wide cross-browser compatibility>
Customizable appearance and behavior

Click here to download

Magento eCommerce: How to save the product from front end

2009-12-15T22:15:00.000-08:00

You can save the product also from front site. I worked on site in which client want to create the product (Sticker/Banner) from front side by any user. So here is code to create the product from front site: $product = Mage::getModel('catalog/product'); $product->setWebsiteIds(array('1')); $product->setAttributeSetId(4); $product->setSku(time()); $product->setType('Simple Product'); $product->setTypeId('simple'); $product->setName('ranjeet test product'); $product->setDescription('[description]'); $product->setShortDescription('[short_description]'); $product->setPrice('12.00'); $product->setWeight('11'); $product->setStatus(1); $product->setTaxClassId(2); $product->setCategoryIds(',2'); $product->setVisibility(4); $product->setCreatedAt(strtotime('now')); //get stock $stockData = $product->getStockData(); $stockData['qty'] = 10; $stockData['is_in_stock'] = 1; $stockData['manage_stock'] = 1; $stockData['use_config_manage_stock'] = 0; $product->setStockData($stockData); //save product $product->save(); $productId = $product->getId(); //add to cart $cart = Mage::getModel('checkout/cart'); $cart->addProductsByIDs(array($productId)); $cart->save();

Add more inputbox, file using javascript

2009-11-05T02:15:00.000-08:00

Add more input boxes:

function addPointsInput() {
var d = document.createElement("div");
var file = document.createElement("input");
file.setAttribute("type", "text");
file.setAttribute("name", "points[]");
file.setAttribute("style", "width:350px");
file.setAttribute("class", "inputPopUp");
d.appendChild(file);
document.getElementById("morePoints").appendChild(d);
}

Use addPointsInput() function on onlick. Use id = morePoints for output ---------------------------------------------------------------------- Add more files upload:

function addFileInput() {
 var d = document.createElement("div");
 var file = document.createElement("input");
 file.setAttribute("type", "file");
 file.setAttribute("name", "images[]");
 d.appendChild(file);
 document.getElementById("moreUploads").appendChild(d);
}

Use addFileInput() function on onlick. Use id = moreUploads for output

Writing a mail client that handles attachments with PHP

2009-10-30T04:07:00.000-07:00

Now we've got a connection to the mailbox. To retrieve some content from a mailbox we now always use the object $mbox which has many features and almost any of these are more or less documented. You can always find information about it on www.php.net search in functions for imap. Now to an example on how to retrieve a list of all messages: Message list

   $ServerName = "{localhost/imap:143}INBOX"; // For a IMAP connection    (PORT 143)
   $ServerName = "{localhost/pop3:110}INBOX"; // For a POP3 connection    (PORT 110)   
   $UserName = "YOUR USERNAME";
   $PassWord = "YOUR PASSWORD";   
   $mbox = imap_open($ServerName, $UserName,$PassWord) or die("Could not open Mailbox - try again later!"); 
   $ServerName = "{localhost/imap:143}INBOX"; // For a IMAP connection    (PORT 143)
   //$ServerName = "{localhost/pop3:110}INBOX"; // For a POP3 connection    (PORT 110)   
   $UserName = "YOUR USERNAME";
   $PassWord = "YOUR PASSWORD";   
   $mbox = imap_open($ServerName, $UserName,$PassWord) or die("Could not open Mailbox - try again later!");   
   if ($hdr = imap_check($mbox)) {
	   echo "Num Messages " . $hdr->Nmsgs ."\n\n

";
   	$msgCount = $hdr->Nmsgs;
   } else {
   	echo "failed";
   }
   $MN=$msgCount;
   $overview=imap_fetch_overview($mbox,"1:$MN",0);
   $size=sizeof($overview);
   
   echo "";
   
   for($i=$size-1;$i>=0;$i--){
   	$val=$overview[$i];
		$msg=$val->msgno;
   	$from=$val->from;
  		$date=$val->date;
		$subj=$val->subject;
   	$seen=$val->seen;
   
	   $from = ereg_replace("\"","",$from);
   
	   // MAKE DANISH DATE DISPLAY
   	list($dayName,$day,$month,$year,$time) = split(" ",$date); 
		$time = substr($time,0,5);
   	$date = $day ." ". $month ." ". $year . " ". $time;
   
   	if ($bgColor == "#F0F0F0") {
   		$bgColor = "#FFFFFF";
   	} else {
			$bgColor = "#F0F0F0";
		}
   
		if (strlen($subj) > 60) {
   		$subj = substr($subj,0,59) ."...";
		}
   
   	echo "\n";
   }

	echo "$from $subj
   		 $date";
   imap_close($mbox);
?>

This produces a message list where you can read the subject and the date and time for arrival in you mailbox.
The main PHP function used is the imap_fetch_overview($mbox,"1:$MN",0); in this example it tells PHP to fetch message 1 to $MN ($msgCount = the last message from the connection $mbox).
For each message we retrieve in the main "for loop" some properties.
Thats made with:
$val=$overview[$i];
$msg=$val->msgno;
$from=$val->from;
$date=$val->date;
$subj=$val->subject;
$seen=$val->seen;
$msg is getting the message number that identifies a single message from the mailbox. The first one is 1
$from is getting the senders name
$date is getting the date and time of the arrival in your mailbox.
$subj is getting the subject of the message
$seen is either 0 or 1 if 1 the message body has been retrieved earlier.
Thats practically all we need to know for now to produce a list of all the messages.
The seen property is not used in my example but you could implement it easily with an if statement that writes a not seen message (with property of 0) in bold if you want an overview over new messages especially if you are connecting to a IMAP account.
Now we'll take a look on how to retrive the body of the message.
Body retrieval
To retrieve the body of a message I use a nice script posted in www.php.net I thank the author :-)
subtype) {
   	return $primary_mime_type[(int) $structure->type] . '/' .$structure->subtype;
   }
   	return "TEXT/PLAIN";
   }
   function get_part($stream, $msg_number, $mime_type, $structure = false,$part_number    = false) {
   
   	if(!$structure) {
   		$structure = imap_fetchstructure($stream, $msg_number);
   	}
   	if($structure) {
   		if($mime_type == get_mime_type($structure)) {
   			if(!$part_number) {
   				$part_number = "1";
   			}
   			$text = imap_fetchbody($stream, $msg_number, $part_number);
   			if($structure->encoding == 3) {
   				return imap_base64($text);
   			} else if($structure->encoding == 4) {
   				return imap_qprint($text);
   			} else {
   			return $text;
   		}   	}   
		if($structure->type == 1) /* multipart */ {
   		while(list($index, $sub_structure) = each($structure->parts)) {
   			if($part_number) {
   				$prefix = $part_number . '.';
   			}
   			$data = get_part($stream, $msg_number, $mime_type, $sub_structure,$prefix .    ($index + 1));
   			if($data) {
   				return $data;
   			}
   		} // END OF WHILE
   		} // END OF MULTIPART
   	} // END OF STRUTURE
   	return false;
   } // END OF FUNCTION   
?> 
The function get_part() needs 3 parameters.
1. Mailbox connection (e.g. $mbox from my connection example)
2. Message number to look up (e.g. $msg from my message list example)
3. A content type to check for
In my following example I'll check for the content types of TEXT/PLAIN and TEXT/HTML which are the common MIME of an email message body. However when it comes to attachments you simply don't know what MIME the attachment has. This gives us a problem we'll deal with in a very short time. - Hang on!
To get the message body we invoke the function get_part() like this:
 ",$dataTxt);
   	$mailformat = "text";   }
	// To out put the message body to the user simply print $msgBody like this.
?> 
To make the text-body more userfriendly in our browser we could make it more HTML-like if we would replace all URLs with an actual HYPERLINK on. And sometimes messages in HTML are sent with a character encoding that looks very weird because the HTML is posted raw from some email clients, we'll also change that.
To do that we use this replacement statements:
 function transformHTML($str) {
   if ((strpos($str,"\n";
   	if ((strpos($str,"";
   	} else {
   		$str = $makeHeader . $str ."\n";
   	}
   } else {
   	$str = "\n". $str;
   }
   	return $str;
 }
   
 if ($dataHtml != "") {
	$msgBody = transformHTML($dataHtml);
 } else {
   $msgBody = ereg_replace("\n","
",$dataTxt);
   $msgBody = preg_replace("/([^\w\/])(www\.[a-z0-9\-]+\.[a-z0-9\-]+)/i","$1http://$2",    $msgBody);
   $msgBody = preg_replace("/([\w]+:\/\/[\w-?&;#~=\.\/\@]+[\w\/])/i","$1", $msgBody);
   $msgBody = preg_replace("/([\w-?&;#~=\.\/]+\@(\[?)[a-zA-Z0-9\-\.]+\.([a-zA-Z]{2,3}|[0-9]{1,3})(\]?))/i","$1",$msgBody);
 }

With this replacement you'll see real hyperlinks in the text-body. And now comes the fuzzy part - attachmenthandling.
Attachment handling
Attachments are parts of a messagebody if the messagebody contains 2 or more parts there should be a file attached to the message. Though Outlook 2000 and Outlook Express have support for "Stationary" - embedded HTML layout with images and so. This is really painful to make visible in the HTML body. I've not made it work YET!

First we'll make a list of the attachments from a message.
In my example it's a FORM SELECT box.

parts);
   
   if ($contentParts >= 2) {
	   for ($i=2;$i<=$contentParts;$i++) {
   	$att[$i-2] = imap_bodystruct($mbox,$msgno,$i);
   	}
   	for ($k=0;$kparameters[0]->value == "us-ascii" || $att[$k]->parameters[0]->value    == "US-ASCII") {
   			if ($att[$k]->parameters[1]->value != "") {
   				$selectBoxDisplay[$k] = $att[$k]->parameters[1]->value;
   			}
   		} elseif ($att[$k]->parameters[0]->value != "iso-8859-1" &&    $att[$k]->parameters[0]->value != "ISO-8859-1") {
   			$selectBoxDisplay[$k] = $att[$k]->parameters[0]->value;
   		}
   	}
   }
   
   if (sizeof($selectBoxDisplay) > 0) {

   	echo "";
   	for ($j=0;$j". $selectBoxDisplay[$j]    ."";
   	}
   	echo "";/   }
?>
Now we've made a selectbox with the attached files listed.
The thing is now - well it's a beautiful list but we want to by able to download the files. To force download of HTML file instead of have it opened in the browser window we need to use a state of the art browser like Microsoft Internet Explorer 5.5 or later. This browser can make use of a Content-Disposition header which can hold an attachment so the browser will prompt with a Save file dialog box. But as I've seen on www.w3c.org this is going to be a standard. So we can only hope Netscape/Mozilla will support it soon. I don't know if Netscape 6 supports it in some way. I haven't made my example work in any other browser than MSIE 5.5 and 6. Now to the download file stuff.

The selectbox has a onChange eventhandler, if you click on a file in the selectbox the handleFile javascript function is triggered.
Here is the javascript:

   var b;
   browser = navigator.appName;
   if (browser == "Microsoft Internet Explorer") {
   	b = "ie";
   } else {
   	b = "other";
   }   
   function handleFile(nr) {
   	if (b != "ie") {
   		alert("This feature is currently only available for Microsoft Internet Explorer 5.5+ users\n\nWait for an update!");
   	} else {
   		check = confirm("Do you want to download the file ?");
   		if (check) {
   			setTimeout("this.location.reload()",8000);
   			location.href="gotodownload.php?download=1&file="+ nr +"&msgno=";
   		} else {
   			location.reload();
   		}   	}   }


The script asks you whether you want to download the file. If you click the OK button you'll be redirected to the file gotodownload.php. The redirect has 3 parameters in the querystring: download=1 to force a download, file="+ nr the attached file you clicked (selected) in the selectbox and finally the message number that identifies the message that holds the attached file.
The file gotodownload.php looks like this.
parameters[0]->value;
   	$strFileType = strrev(substr(strrev($strFileName),0,4));
   	$fileContent = imap_fetchbody($mbox,$msgno,$file+2);
   	downloadFile($strFileType,$strFileName,$fileContent);
   }   
   function downloadFile($strFileType,$strFileName,$fileContent) {
   	$ContentType = "application/octet-stream";
   
   	if ($strFileType == ".asf") 
   		$ContentType = "video/x-ms-asf";
   	if ($strFileType == ".avi")
   		$ContentType = "video/avi";
   	if ($strFileType == ".doc")
   		$ContentType = "application/msword";
   	if ($strFileType == ".zip")
   		$ContentType = "application/zip";
   	if ($strFileType == ".xls")
   		$ContentType = "application/vnd.ms-excel";
   	if ($strFileType == ".gif")
   		$ContentType = "image/gif";
   	if ($strFileType == ".jpg" || $strFileType == "jpeg")
   		$ContentType = "image/jpeg";
   	if ($strFileType == ".wav")
   		$ContentType = "audio/wav";
   	if ($strFileType == ".mp3")
   		$ContentType = "audio/mpeg3";
   	if ($strFileType == ".mpg" || $strFileType == "mpeg")
   		$ContentType = "video/mpeg";
   	if ($strFileType == ".rtf")
   		$ContentType = "application/rtf";
   	if ($strFileType == ".htm" || $strFileType == "html")
   		$ContentType = "text/html";
   	if ($strFileType == ".xml") 
   		$ContentType = "text/xml";
   	if ($strFileType == ".xsl") 
   		$ContentType = "text/xsl";
   	if ($strFileType == ".css") 
   		$ContentType = "text/css";
   	if ($strFileType == ".php") 
   		$ContentType = "text/php";
   	if ($strFileType == ".asp") 
   		$ContentType = "text/asp";
   	if ($strFileType == ".pdf")
   		$ContentType = "application/pdf";
   
	header ("Content-Type: $ContentType"); 
	header ("Content-Disposition: attachment; filename=$strFileName; size=$fileSize;"); 
	
	// Updated oktober 29. 2005
	if (substr($ContentType,0,4) == "text") {
	echo imap_qprint($fileContent);
	} else {
	echo imap_base64($fileContent);
	}
    }
?>

Php download files from browser without url address

2009-10-30T03:59:00.000-07:00


Use "Content-Type" for diffrent types of files: 

MP3   : audio/x-mp3
Video : video/mpeg
Text  : text/html
PDF   : application/pdf
Jpg   : image/jpeg
Gif   : image/gif

$file = '/path/folder/filename.mp3';

if (file_exists($file)) {
  header("Pragma: public");
  header("Expires: 0");
  header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
  header("Cache-Control: private", false);
  header("Content-Type: audio/x-mp3");
  header("Content-Disposition: attachment; filename=" . basename($file));
  header("Content-Transfer-Encoding: binary");
  header("Content-Length: " . filesize($file));
  header("Content-Description: File Transfer");

  readfile($file);

  exit;
}

Php script to save email attachments to server on system

2009-10-30T03:56:00.000-07:00


require_once("attachmentread.class.php");
$host="{my.mailserver.net:110/pop3}"; // pop3host
$login="user1"; //pop3 login
$password="passwd1"; //pop3 password
$savedirpath="" ; // attachement will save in same directory where scripts run othrwise give abs path
$jk=new readattachment(); // Creating instance of class####
$jk->getdata($host,$login,$password,$savedirpath); // calling member function



-- attachmentread.class.php --



            ######################################
           
            #Coded By Jijo Last Update Date[Jan/19/06]
           
            #####################################

   

           
            ##########################################################            


            ###################### Class readattachment ###############
class readattachment
{
   
        function getdecodevalue($message,$coding)
        {
        if ($coding == 0)
        {
           $message = imap_8bit($message);
        }
        elseif ($coding == 1)
        {
          $message = imap_8bit($message);
        }
        elseif ($coding == 2)
        {
           $message = imap_binary($message);
        }
        elseif ($coding == 3)
        {
       $message=imap_base64($message);
       }
        elseif ($coding == 4)
        {
           $message = imap_qprint($message);
        }
        elseif ($coding == 5)
        {
         $message = imap_base64($message);
        }
        return $message;
        }

            function getdata($host,$login,$password,$savedirpath)
            {
            $mbox = imap_open ($host,  $login, $password) or die("can't connect: " . imap_last_error());
            $message = array();
            $message["attachment"]["type"][0] = "text";
            $message["attachment"]["type"][1] = "multipart";
            $message["attachment"]["type"][2] = "message";
            $message["attachment"]["type"][3] = "application";
            $message["attachment"]["type"][4] = "audio";
            $message["attachment"]["type"][5] = "image";
            $message["attachment"]["type"][6] = "video";
            $message["attachment"]["type"][7] = "other";
           
            for ($jk = 1; $jk <= imap_num_msg($mbox); $jk++)
            {
            $structure = imap_fetchstructure($mbox, $jk , FT_UID);    
            $parts = $structure->parts;
            $fpos=2;
                    for($i = 1; $i < count($parts); $i++)
                       {
                        $message["pid"][$i] = ($i);
                        $part = $parts[$i];

                        if($part->disposition == "ATTACHMENT")
                            {
                           
                            $message["type"][$i] = $message["attachment"]["type"][$part->type] . "/" . strtolower($part->subtype);
                            $message["subtype"][$i] = strtolower($part->subtype);
                            $ext=$part->subtype;
                            $params = $part->dparameters;
                            $filename=$part->dparameters[0]->value;
                                                       
                                    $mege="";
                                    $data="";
                                      $mege = imap_fetchbody($mbox,$jk,$fpos);  
                                    $filename="$filename";
                                    $fp=fopen($filename,w);
                                    $data=$this->getdecodevalue($mege,$part->type);    
                                    fputs($fp,$data);
                                    fclose($fp);
                                    $fpos+=1;
                       
                               
               
                            }
           
                    }
//imap_delete tags a message for deletion
            //imap_delete($mbox,$jk);
       
            }
// imap_expunge deletes all tagged messages
            //imap_expunge($mbox);
            imap_close($mbox);
            }
}

PHP: Diffrence Between two Dates in PHP

2009-10-27T04:25:00.000-07:00

function dateDiffrence($date1)
{//current date.
$date2 = date("Y-m-d", time());
//calculate the difference in seconds.
$difference = abs(strtotime($date2) - strtotime($date1));
//calculate the number of days
return $days = round(((($difference/60)/60)/24)/365, 0);
}
echo dateDiffrence('1980-01-01');

Mootool Animation Menu

2009-10-21T03:00:00.000-07:00

Animation effect like flash file. I had used this menu for joomla side menu.
Menu Html

<ul id="menu">
<li><a href="#">Opcja 1</a></li>
<li><a href="#">Opcja 2</a></li>

<li><a href="#">Opcja 3</a></li>
<li><a href="#">Opcja 4</a></li>
<li><a href="#">Opcja 5</a></li>

</ul>

Javascript

window.addEvent("domready",function(){
$$("#menu li").each(function(element){
var efekt1=new Fx.Style(element,'background-color',
{duration:600, wait:false});
var efekt2=new Fx.Style($E('a',element),'color',
{duration:600, wait:false});

 element.addEvent('mouseenter', function(){
  efekt1.start('#FFF','#000');
  efekt2.start('#000','#FFF');
 });

 element.addEvent('mouseleave', function(){
  efekt1.start('#000','#FFF');
  efekt2.start('#FFF','#000');
 });
});
});

Problem with Javascript drop down menu and Flash Movie

2009-10-05T22:33:00.000-07:00

In this problem the menu is hidden by the flash movie

Issue

A Flash movie in a layer on a DHTML page containing several layers may display above all the layers, regardless of the stacking order ("z-index") of those layers.

Reason

By default, browsers place embedded plug-in content, such as a Flash movie or Java applet, on the topmost layer. In older browsers, attempts to place a DHTML layer on top of a Flash layer would fail. Newer browsers add the ability to layer Flash content with DHTML content and in some cases the ability to use transparent backgrounds in the Flash content (see below).

Solution

Use the WMODE parameter to allow layering of Flash content with DHTML layers. The WMODE parameter can be 'window' (default), 'opaque', or 'transparent'. Using a WMODE value of 'opaque' or 'transparent' will prevent a Flash movie from playing in the topmost layer and allow you to adjust the layering of the movie within other layers of the HTML document.

Note: The WMODE parameter is supported only on some browser/Flash Player version combinations. If the WMODE parameter is not supported, the Flash movie will always display on top. Refer to TechNote 14201 for details.

Ajax

2009-10-02T01:43:00.000-07:00

AJAX (shorthand for asynchronous JavaScript and XML) is a group of interrelated web development techniques used on the client-side to create interactive web applications or rich Internet applications. With AJAX, web applications can retrieve data from the server asynchronously in the background without interfering with the display and behavior of the existing page. The use of AJAX techniques has led to an increase in interactive or dynamic interfaces on web pages and better quality of Web services due to the asynchronous mode. Data is usually retrieved using the XMLHttpRequest object. Despite the name, the use of JavaScript and XML is not actually required, nor do the requests need to be asynchronous. Simple AJAX JavaScript function. That is the function which is called just like any other JavaScript function, passing in those two required parameters. The only other requirement is to make sure you have a div,span with the ID you are passing in the function call.

// JavaScript Document
function ajaxFunction(url,element){
  
  var xmlHttp;
  try
    {
    // Firefox, Opera 8.0+, Safari
    xmlHttp=new XMLHttpRequest();
    }
  catch (e)
    {
    // Internet Explorer
    try
      {
      xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
      }
    catch (e)
      {
      try
        {
        xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
        }
      catch (e)
        {
        alert("Your browser does not support AJAX!");
        return false;
        }
      }
    }
    xmlHttp.onreadystatechange=function()
      {
      if(xmlHttp.readyState==4)
        {
   if (xmlHttp.status == 200) {
    if(element != "")
    { //alert(xmlHttp.responseText);
     //alert(element) 
     if(document.getElementById(element))
     {
      document.getElementById(element).value = "";
     }

     document.getElementById(element).innerHTML=xmlHttp.responseText;
    }

         }
  }
  else
  {
   document.getElementById(element).innerHTML="Loading ....";
  }
      }
    xmlHttp.open("GET",url,true);
    xmlHttp.send(null);
  }

jQuery is a new kind of JavaScript Library.

2009-10-02T01:37:00.000-07:00

jQuery is a fast and concise JavaScript Library that simplifies HTML document traversing, event handling, animating, and Ajax interactions for rapid web development. jQuery is designed to change the way that you write JavaScript. jQuery is free, open source software Dual-licensed under the MIT License and the GNU General Public License. Microsoft and Nokia have announced plans to bundle jQuery on their platforms,[1] Microsoft adopting it initially within Visual Studio[2] for use within Microsoft's ASP.NET AJAX framework and ASP.NET MVC Framework whilst Nokia will integrate it into their Web Run-Time platform. Features jQuery contains the following features: * DOM element selections using the cross-browser open source selector engine Sizzle, a spin-off out of jQuery project[3] * DOM traversal and modification (including support for CSS 1-3 and basic XPath) * Events * CSS manipulation * Effects and animations * Ajax * Extensibility * Utilities - such as browser version and the each function. Download JQuery

Javascript Mootool

2009-10-01T02:01:00.000-07:00

Javascript Mootool

MooTools is a compact, modular, Object-Oriented JavaScript framework designed for the intermediate to advanced JavaScript developer. It allows you to write powerful, flexible, and cross-browser code with its elegant, well documented, and coherent API. Open Source License MooTools is released under the Open Source MIT license, which gives you the possibility to use it and modify it in every circumstance. Browser Compatibility MooTools is compatible and fully tested with Safari 2+, Internet Explorer 6+, Firefox 2+ (and browsers based on gecko), Opera 9+.

Download MooTools 1.2.3 Mootool animation menu Example: Click Here

Some Usefull mootool scripts: Click Here

PHP AJAX File Uploader, The AJAX Progress Bar using CGI pearl

2009-09-21T04:19:00.000-07:00

PHP AJAX File Uploader, is a script written in CGI perl which aims to simply upload files to server and show a real time progress bar using AJAX. The script is very useful to use, could be used to upload resources and inform about the progress specially if its uploading large files. Usually uploading large files like video, large size images take time and you don't have any information if the upload process is still working or stopped. With the help of this uploader bar you can watch the processing

Some help sites for PHP, Javscript, Ajax

2009-09-18T23:48:00.000-07:00

PHP 1. www.php.net 2. www.w3schools.com/PHP 3. www.zend.com 4. www.wampserver.com 5. www.phpclasses.org Javscript 1. Dynamic drive 2. http://javascript.internet.com/navigation/ 3. http://www.javascriptfreecode.com/ 4. http://www.javascriptbank.com/ 5. http://www.javascriptkit.com/

PHP Introduction

2009-09-18T23:21:00.000-07:00

PHP: Hypertext Preprocessor Server-side HTML embedded scripting language. It provides web developers with a full suite of tools for building dynamic websites. Its originally designed for web development. It can be embedded into HTMLand generally runs on a web server which needs to be configured to process PHP code and create we page content from it. It can be deployed on most web servers and on almost every operating system and platform free of charge. PHP Softwares: 1. PHP source code 2. XAMPP 3. Wamp Server