Php mail script get offen error for special caractor we get solutions

php subject missing special character missing solved

$subject = "=?ISO-8859-15?Q?".imap_8bit("Deine Buchung für die Allgäuer Berufsoffensive")."?=";

Magento Mask product set attribute value

Magento Mask product set attribute value

select * from eav_attribute where entity_type_id = 4 and attribute_code = 'status' # ---> note the ID UPDATE catalog_product_entity_int SET value = 1 WHERE attribute_id = $id

States if India not displaying in dropdown list during checkout process in magento 1.7.0.2

States if India not displaying in dropdown list during checkout process in magento 1.7.0.2

INSERT INTO `directory_country_region` VALUES (NULL , "IN", "Andaman Nicobar","Andaman Nicobar"), (NULL , "IN", "Andhra Pradesh","Andhra Pradesh"), (NULL , "IN", "Arunachal Pradesh","Arunachal Pradesh"), (NULL , "IN", "Assam","Assam"), (NULL , "IN", "Bihar","Bihar"), (NULL , "IN", "Chandigarh","Chandigarh"), (NULL , "IN", "Chhattisgarh","Chhattisgarh"), (NULL , "IN", "Dadra Nagar Haveli","Dadra Nagar Haveli"), (NULL , "IN", "Daman Diu","Daman Diu"), (NULL , "IN", "Delhi","Delhi"), (NULL , "IN", "Goa","Goa"), (NULL , "IN", "Gujarat","Gujarat"), (NULL , "IN", "Haryana","Haryana"), (NULL , "IN", "Himachal Pradesh","Himachal Pradesh"), (NULL , "IN", "Jammu Kashmir","Jammu Kashmir"), (NULL , "IN", "Jharkhand","Jharkhand"), (NULL , "IN", "Karnataka","Karnataka"), (NULL , "IN", "Kerala","Kerala"), (NULL , "IN", "Lakshadweep","Lakshadweep"), (NULL , "IN", "Madhya Pradesh","Madhya Pradesh"), (NULL , "IN", "Maharashtra","Maharashtra"), (NULL , "IN", "Manipur","Manipur"), (NULL , "IN", "Meghalaya","Meghalaya"), (NULL , "IN", "Mizoram","Mizoram"), (NULL , "IN", "Nagaland","Nagaland"), (NULL , "IN", "Orissa","Orissa"), (NULL , "IN", "Pondicherry","Pondicherry"), (NULL , "IN", "Punjab","Punjab"), (NULL , "IN", "Rajasthan","Rajasthan"), (NULL , "IN", "Sikkim","Sikkim"), (NULL , "IN", "Tamil Nadu","Tamil Nadu"), (NULL , "IN", "Tripura","Tripura"), (NULL , "IN", "Uttar Pradesh","Uttar Pradesh"), (NULL , "IN", "Uttaranchal","Uttaranchal"), (NULL , "IN", "West Bengal","West Bengal"); INSERT INTO `directory_country_region_name` (`locale` ,`region_id` ,`name` ) SELECT 'en_US', tmp.region_id, tmp.default_name FROM `directory_country_region` AS tmp WHERE tmp.country_id='IN';

magento log clear query

TRUNCATE dataflow_batch_export; TRUNCATE dataflow_batch_import; TRUNCATE log_customer; TRUNCATE log_quote; TRUNCATE log_summary; TRUNCATE log_summary_type; TRUNCATE log_url; TRUNCATE log_url_info; TRUNCATE log_visitor; TRUNCATE log_visitor_info; TRUNCATE log_visitor_online; TRUNCATE report_viewed_product_index; TRUNCATE report_compared_product_index; TRUNCATE report_event; TRUNCATE index_event;

ruppee simbale code

<div> <span class="WebRupee">₹</span> 500</div>