Export Magento categories with ID using php script

Copy the code below into a new file "categorywithid.php" and place this file in your root folder

define('MAGENTO', realpath(dirname(__FILE__)));
require_once MAGENTO . '/app/Mage.php';
Mage::app();

$category = Mage::getModel ( 'catalog/category' );
$tree = $category->getTreeModel ();
$tree->load ();

$ids = $tree->getCollection ()->getAllIds ();

if ($ids) {
 $file = "var/export/catwithid.csv";
 file_put_contents($file,"catId, catName\n");
 foreach ( $ids as $id ) {
   $string = $id . ', ' .$category->load($id)->getName() . "\n";
  file_put_contents($file,$string,FILE_APPEND);
 }
}

Hit Your browser like www.YourDomain.com/categorywithid.php Thats it. You are done. Get the csv file under "var/export/catwithid.csv".

Magento mysql table install, create and upgrade scripts using custom module

Here is the code to create or update magento mysql table. This module helps to create new table.
"app/etc/modules/Company_Track.xml"

  
      
          true
          local
      
  

"app/code/local/Company/Track/etc/config.xml"

   
    
        0.1.0
   


    
       
            
                Company_Track
                Company_Track_Model_Mysql4_Setup
                
  
                    core_setup
                
        
    

"app/code/local/Company/Track/Model/Mysql/Setup.php"

class Company_Track_Model_Mysql4_Setup extends Mage_Catalog_Model_Resource_Eav_Mysql4_Setup
{
}

Here is the code to create table query.
"app/code/local/Company/Track/sql/track_setup/mysql4-install-0.1.0.php"

$installer = $this;
 
$installer->startSetup();
 
$installer->run("
 
-- DROP TABLE IF EXISTS {$this->getTable('customer_track')};
CREATE TABLE IF NOT EXISTS {$this->getTable('customer_track')} (
`id` INT UNSIGNED NOT NULL ,
`sku` varchar(64) NOT NULL ,
`customer_id` INT NOT NULL ,
`region` varchar(255) NOT NULL ,
`country_id` char(2) NOT NULL
) ;

"); 
$installer->endSetup();

If you want to update mysql table using update query you have to use the below coding. Here im going to remove last name required option to not required.
"app/code/local/Company/Track/sql/track_setup/mysql4-upgrade-0.1.0-0.1.1.php"

/* @var $eav Mage_Eav_Model_entity_Setup */
$eav = Mage::getModel('eav/entity_setup', 'core_setup');
$eav->updateAttribute('customer_address', 'lastname', 'is_required', false);

Custom Form Validation in Magento

List of validate class And error messages :

      Class => Error Message
      1. validate-select => Please select an option.
      2. required-entry => This is a required field.
      3. validate-number => Please enter a valid number in this field.
      4.validate-digits => Please use numbers only in this field. please avoid spaces or other characters such as dots or commas.
      5. validate-alpha => Please use letters only (a-z or A-Z) in this field.
      6. validate-code => Please use only letters (a-z), numbers (0-9) or underscore(_) in this field, first character should be a letter.
      7. validate-alphanum => Please use only letters (a-z or A-Z) or numbers (0-9) only in this field. No spaces or other characters are allowed.
      8. validate-street => Please use only letters (a-z or A-Z) or numbers (0-9) or spaces and # only in this field.
      9. validate-phoneStrict => Please enter a valid phone number. For example (123) 456-7890 or 123-456-7890.
      10. validate-phoneLax => Please enter a valid phone number. For example (123) 456-7890 or 123-456-7890.
      11. validate-fax => Please enter a valid fax number. For example (123) 456-7890 or 123-456-7890.
      12. validate-date => Please enter a valid date.
      13.validate-email => Please enter a valid email address. For example johndoe@domain.com.
      14. validate-emailSender => Please use only letters (a-z or A-Z), numbers (0-9) , underscore(_) or spaces in this field.
      15. validate-password => Please enter 6 or more characters. Leading or trailing spaces will be ignored.
      16. validate-admin-password => Please enter 7 or more characters. Password should contain both numeric and alphabetic characters.
      17. validate-cpassword => Please make sure your passwords match.
      18. validate-url => Please enter a valid URL. http:// is required
      19. validate-clean-url => Please enter a valid URL. For example http://www.example.com or http://www.example.com
      20. validate-identifier => Please enter a valid Identifier. For example example-page, example-page.html or anotherlevel/example-page
      21. validate-xml-identifier => Please enter a valid XML-identifier. For example something_1, block5, id-4
      22. validate-ssn => Please enter a valid social security number. For example 123-45-6789.
      23. validate-zip => Please enter a valid zip code. For example 90602 or 90602-1234.
      24. validate-date-au => Please use this date format: dd/mm/yyyy. For example 17/03/2006 for the 17th of March, 2006.
      25. validate-currency-dollar => Please enter a valid $ amount. For example $100.00.
      26. validate-one-required => Please select one of the above options.
      27. validate-one-required-by-name => Please select one of the options.
      28. validate-not-negative-number => Please enter a valid number in this field.
      29. validate-state => Please select State/Province.
      30. validate-new-password => Please enter 6 or more characters. Leading or trailing spaces will be ignored.
      31. validate-greater-than-zero => Please enter a number greater than 0 in this field.
      32. validate-zero-or-greater => Please enter a number 0 or greater in this field.
      33. validate-cc-number => Please enter a valid credit card number.
      34. validate-cc-type => Credit card number doesn\’t match credit card type
      35. validate-cc-type-select => Card type doesn\’t match credit card number
      36. validate-cc-exp => Incorrect credit card expiration date
      37. validate-cc-cvn => Please enter a valid credit card verification number.
      38. validate-data => Please use only letters (a-z or A-Z), numbers (0-9) or underscore(_) in this field, first character should be a letter.
      39. validate-css-length => Please input a valid CSS-length. For example 100px or 77pt or 20em or .5ex or 50%
      40. validate-length => Maximum length exceeded.