Manoj Ninave Blog (Magento,PHP,Mysql..etc)

PHP Birthday

2010-06-17T02:46:00.000-07:00

This information took from http://www.sitepoint.com/

PHP was released by Rasmus Lerdorf on June 8, 1995. His original usenet post is still available online if you want to examine a computing artefact from the dawn of the web. Many of us owe our careers to the language, so here’s a brief history of PHP…

PHP originally stood for “Personal Home Page” and Rasmus started the project in 1994. PHP was written in C and was intended to replace several Perl scripts he was using on his homepage. Few people will be ancient enough to remember CGI programming in Perl, but it wasn’t much fun. You could not embed code within HTML and development was slow and clunky.

Rasmus added his own Form Interpreter and other C libraries including database connectivity engines. PHP 2.0 was born on this day 15 years ago. PHP had a modest following until the launch of version 3.0 in June 1998. The parser was completely re-written by Andi Gutmans and Zeev Suraski; they also changed the name to the recursive “PHP: Hypertext Preprocessor”.

Critics argue that PHP 3.0 was insecure, had a messy syntax, and didn’t offer standard coding conventions such as object-orientated programming. Some will quote the same arguments today. However, while PHP lacked elegance it made web development significantly easier. Programming novices could add snippets of code to their HTML pages and experts could develop full web applications using an open source technology which became widely installed by web hosts.

PHP 4.0 was released on May 22, 2000. It provided rudimentary object-orientation and addressed several security issues such as disabling register_globals. Scripts broke, but it was relatively easy to adapt applications for the new platform. PHP 4.0 was an instant success and you’ll still find it offered by web hosts today. Popular systems such as WordPress and Drupal still run on PHP 4.0 even though platform development has ceased.

Finally, we come to PHP 5.0 which was released on July 13, 2004. The language featured more robust object-orientated programming plus security and performance enhancements. The uptake has been more sedate owing to the success of PHP 4.0 and the introduction of competing frameworks such as ASP.NET, Ruby and Python.

PHP has its inconsistencies and syntactical messiness, but it’s rare you’ll encounter a language which can be installed on almost any OS, is provided by the majority of web hosts, and offers a similar level of productivity and community assistance. Whatever your opinion of the language, PHP has provided a solid foundation for server-side programming and web application development for the past 15 years. Long may it continue.

Thanks & Regards
Manoj Ninave

Import Customers by csv file in Magento

2010-04-06T00:12:00.000-07:00

Import Customers by csv file in Magento
here i developed script to import customers in magento by csv file.
csv file have following columns
########customerid (unique key) accesskey (customer type) emailaddress password firstname lastname companyname billingaddress1 city state postalcode country phonenumber faxnumber
###########

here i didn't use any magento's core file.

code is given below,i hope it will help you :)
set_time_limit(36000);
error_reporting(0);
/**
* @Use Script to import customer's data in Magento Database
* @createDate Mar 2010
* @author Manoj Ninave (manojninave@gmail.com)
**/

define("DB_HOST","localhost",TRUE); // database server name
define("DB_USER","root",TRUE); // database user
define("DB_PASS","",TRUE); // database user's password
define("DB_NAME","dbname",TRUE); // database name
require_once('db.class.php');

if( !isset($db_obj) ) {
$db_obj = new db;
}

$db_conect = $db_obj->connect();
//function to take country code from magento
//if the countr code are already in your csv file then //don't use this function.
function getCountryCode($countryName)
{
$xml = simplexml_load_file("territories.xml");
foreach($xml as $a => $b)
{
if($b == $countryName)
{
foreach($b->attributes() as $c)
{
return $c ;
}
}
}
}
echo "*******************Customer Import Module********************";
$file_handle = fopen("customers.csv", "r");
$i=0;

while (!feof($file_handle) ) {

$line_of_text = fgetcsv($file_handle, 1024);

if($i > 0)
{
$customerid =addslashes($line_of_text[0]);
$accesskey =addslashes($line_of_text[1]);
$emailaddress =addslashes($line_of_text[2]);
$password =md5($line_of_text[3]);
$firstname =addslashes($line_of_text[4]);
$lastname =addslashes($line_of_text[5]);
$companyname =addslashes($line_of_text[6]);
$billingaddress1 =addslashes($line_of_text[7]);
$billingaddress2 =addslashes($line_of_text[8]);
$city =addslashes($line_of_text[9]);
$state =addslashes($line_of_text[10]);
$postalcode =addslashes($line_of_text[11]);
$country =addslashes($line_of_text[12]);
$phonenumber =addslashes($line_of_text[13]);
$faxnumber =addslashes($line_of_text[14]);
$paysstatetax =addslashes($line_of_text[15]);
$taxid =addslashes($line_of_text[16]);
$emailsubscriber =addslashes($line_of_text[17]);
$percentdiscount =addslashes($line_of_text[18]);
$websiteaddress =addslashes($line_of_text[19]);
$discountlevel =addslashes($line_of_text[20]);
$customer_isanonymous =addslashes($line_of_text[21]);
$issuperadmin =addslashes($line_of_text[22]);
$allow_access_to_private_sections =addslashes($line_of_text[23]);
$customer_notes =addslashes($line_of_text[24]);
$Today = date("Y-m-d H:i:s");
$country_code = getCountryCode($country);

$sql_email = $db_obj->query("SELECT email from customer_entity where email='".$emailaddress."'",$db_conect);
$num_email = $db_obj->num_rows($sql_email);

if(!$emailaddress=="" && $num_email<=0) { $db_obj->query("INSERT INTO customer_entity(entity_type_id,attribute_set_id,website_id,email,group_id,increment_id,store_id,created_at,updated_at,is_active) VALUES (1,0,1,'".$emailaddress."',1,'',1,'".$Today."','".$Today."',1)",$db_conect);
//$increament_id++;

$sql_parent_id = $db_obj->query("SELECT max(entity_id) as id from customer_entity",$db_conect);

$rs_parent_id = $db_obj->fetch_array($sql_parent_id);
$parentId = $rs_parent_id['id'];

$db_obj->query("UPDATE customer_entity SET increment_id='".$parentId."' WHERE entity_id='".$parentId."'",$db_conect);

$db_obj->query("INSERT INTO customer_address_entity(entity_type_id,attribute_set_id,parent_id,created_at,updated_at,is_active) VALUES (2,0,'".$parentId."','".$Today."','".$Today."',1)",$db_conect);

$sql_max_entity_id = $db_obj->query("SELECT max(entity_id) as id from customer_address_entity",$db_conect);

$rs_max_entity_id = $db_obj->fetch_array($sql_max_entity_id);
$maxentityId = $rs_max_entity_id['id'];

$db_obj->query("INSERT INTO customer_address_entity_text(entity_type_id,attribute_id,entity_id,value) VALUES (2,23,'".$maxentityId."','".$billingaddress1."')",$db_conect);

$db_obj->query("INSERT INTO customer_address_entity_varchar(entity_type_id,attribute_id,entity_id,value) VALUES
(2,18,'".$maxentityId."','".$firstname."'),
(2,20,'".$maxentityId."','".$lastname."'),
(2,22,'".$maxentityId."','".$companyname."'),
(2,29,'".$maxentityId."','".$phonenumber."'),
(2,30,'".$maxentityId."','".$faxnumber."'),
(2,24,'".$maxentityId."','".$city."'),
(2,26,'".$maxentityId."','".$state."'),
(2,28,'".$maxentityId."','".$postalcode."'),
(2,25,'".$maxentityId."','".$country_code."')",$db_conect);

$db_obj->query("INSERT INTO customer_entity_int(entity_type_id,attribute_id,entity_id,value) VALUES
(1,13,'".$parentId."','".$maxentityId."'),
(1,14,'".$parentId."','".$maxentityId."')",$db_conect);

$db_obj->query("INSERT INTO customer_entity_varchar(entity_type_id,attribute_id,entity_id,value) VALUES
(1,5,'".$parentId."','".$firstname."'),
(1,7,'".$parentId."','".$lastname."'),
(1,3,'".$parentId."','Default Store View'),
(1,12,'".$parentId."','".$password."')",$db_conect);
}
}
$i++;
}

fclose($file_handle);
echo "Customer Imported Successfully.";

Import images into Magento database without using Magento core files.

2010-02-12T03:52:00.000-08:00

here code is to import images into magento databse without using any core files.
this is for product's images. you can modify it for gallery images also.
here all the images took from media/import and copied to that perticular directory.

you can find here,how images created there directory structure.

if images name is example.gif,then will create directory structure like e/x/example.gif.
that is means this images will copy to media/catalog/product/e/x/example.gif
and the value /e/x/example.gif will insert into table catalog_product_entity_varchar.you can see this image at fronend to that perticular product.Actaully i did script to imaport product with catagory,attribute,images,description.... etc
it is nothing but a cron job.i took only import images part from my script.

$LargeProductImageURL=$LargeImageURL!=""?basename($allData[$key]->LargeImageURL):"";

$first_2_letter = substr("$LargeProductImageURL", 0,2);
$first_letter = substr("$first_2_letter", 0,1);
$second_letter = substr("$first_2_letter", -1);
$product_image ="/".$first_letter."/".$second_letter."/".$LargeProductImageURL;

$product_path=$media_path."".$slash."catalog\product";
$import_images=$media_path."".$slash."import".$slash."".$LargeProductImageURL;
$mypath1=$product_path."".$slash."".$first_letter;
if(!is_dir($mypath1))
{
mkdir($mypath1,0777,TRUE);
}
$mypath2=$product_path."".$slash."".$first_letter."".$slash."".$second_letter;
if(!is_dir($mypath2))
{
mkdir($mypath2,0777,TRUE);
}
//copy ( string $source , string $dest [, resource $context ] )
$Image_dest=$mypath2."".$slash."".$LargeProductImageURL;
@copy($import_images,$Image_dest);

#####check Is images are ready for copy or not
if (file_exists($import_images)) {
$product_image = $product_image;
}
else {
$product_image="no_selection";
}
#######
$UrlKey = strtolower(str_replace(" ","-",$PName));
$URL_path= $PName.".html";

/*if(empty($LargeProductImageURL))
{$product_image="no_selection";}*/

$db_obj->query("INSERT INTO catalog_product_entity_varchar(entity_type_id, attribute_id,store_id,entity_id,value) VALUES
('".$catalog_product."','56','0','".$entity_id."','".$PName."'),
('".$catalog_product."','82','0','".$entity_id."','".$UrlKey."'),
('".$catalog_product."','469','0','".$entity_id."','2'),
('".$catalog_product."','67','0','".$entity_id."','".$PName."'),
('".$catalog_product."','69','0','".$entity_id."','".$PName."'),
('".$catalog_product."','70','0','".$entity_id."','".$product_image."'),
('".$catalog_product."','71','0','".$entity_id."','".$product_image."'),
('".$catalog_product."','72','0','".$entity_id."','".$product_image."'),
('".$catalog_product."','86','0','".$entity_id."',''),
('".$catalog_product."','90','0','".$entity_id."',''),
('".$catalog_product."','92','0','".$entity_id."','container2'),
('".$catalog_product."','95','0','".$entity_id."',''),
('".$catalog_product."','96','0','".$entity_id."',''),
('".$catalog_product."','97','0','".$entity_id."',''),
('".$catalog_product."','83','0','".$entity_id."','".$URL_path."')", $db_conect);

regard
Manoj Ninave

Faith

2010-02-11T20:07:00.000-08:00

If God answer your Prayer, He is increasing Your Faith, If He Delay He is Increasing Your Patience, and If He Doesn’t Answer It means something is better for you. Believe In God. Always…….

How to get detail information about facebook user

2010-02-05T23:18:00.002-08:00

Solution to get Detailed information about facebook user.

1) First you need to log in to the Facebook Developer application:
Go to the Facebook Developer AppAfter following the link,
click “Allow” to let the Developer application access your profile.
2) Begin setting up a new application.
Go to the Developer application and click “Set Up New Application”.
Give your application a name, check to accept the Terms of Service,
then click Submit.
You’ll see some basic information about your application, including:

but for that you will need PHP client library
you can download “PHP client library” after clicking the above link.
for detail information see get started

* Your API key: this key identifies your application to Facebook.
You pass it with all your API calls.
* Your application secret:
Facebook uses this key to authenticate the requests you make.
As you can tell by its name,
you should never share this key with anyone.

code:

require_once ‘facebook.php’;
$appapikey = ‘Your API Key’;
$appsecret = ‘Your API Secrete Key’;
$facebook = new Facebook($appapikey, $appsecret);
$user_id = $facebook->require_login();

//to get detailed information about facebook user,you can use,

$userdetails=$facebook->api_client->users_getInfo($user_id,’last_name,

first_name,sex,about_me,birthday,email_hashes,hometown_location,pic,pic_big,pic_small,pic_square,movies,music,activities,hs_i

nfo,name’);

if you would like to get user’s name and city,
then you should write
foreach($userdetails as $k){

$user_name= $k['name'];
$City= $k['hometown_location']['city'];

echo $user_name;
}

save this code in index.php and test that,what you get.

Regard
Manoj Ninave

Loading web pages problem in Firefox and Crome browser?

2010-02-05T23:18:00.001-08:00

I faced problem to load some web page in Firefox and Crome browser
so i passed some code in .htaccess files.
code is given as follow:

php_value output_handler ob_gzhandler

simply copy and paste it to .htaccess file.

Also see that following lines are passed are not:

php_flag allow_call_time_pass_reference on
php_flag magic_quotes_runtime off
php_flag register_globals off
php_flag magic_quotes_gpc On
php_flag register_argc_argv on
php_value register_long_arrays on
php_value display_errors on
php_value allow_url_include on

to compress your files for faster loading
“php_value output_handler ob_gzhandler” is very useful.

Regard

Manoj Ninave

Magento Tables required to Import Products.

2010-02-05T23:17:00.001-08:00

Data inserted in following tables while importing products.

1)adminnotification_inbox
2)catalogindex_eav
3)catalogindex_price
4)cataloginventory_stock_item
5)cataloginventory_stock_status
6)catalogsearch_fulltext
7)catalog_category_product
8)catalog_category_product_index
9)catalog_product_enabled_index
10)catalog_product_entity
11)catalog_product_entity_datetime
12)catalog_product_entity_decimal
13)catalog_product_entity_int
14)catalog_product_entity_media_gallery
15)catalog_product_entity_media_gallery_value
16)catalog_product_entity_text
17)catalog_product_entity_varchar
18)catalog_product_link
19)catalog_product_link_attribute_int
20)catalog_product_website
21)core_url_rewrite

Regard

Manoj Ninave

Naming Conventions While Programming.

2010-02-05T23:08:00.000-08:00

1. All files names which will be represeted to site visitors should be in lower case

2. All other file names should follow - {first_character_capital} of each word in name. for example if file name is shoppingcart.php then it should be ShoppingCart.php

3. All local variable names should follow
a) {first_character_capital} of each word in name. for example if variable name is firstname then it should be FirstName
b) should have following prefixes
i - integer
b - boolean
s - string
c - character
f - float
d - date
obj - class object
iArr - integer array
bArr - boolean array
sArr - string array
cArr - character array
fArr - float array
dArr - date array
objArr - class object array

c) name should be meaningfull. like id should be Id, login id should be LoginId, loop counter should be Counter or ProdCounter

4. All function parameters and any public variable names should follow
a) {first_character_capital} of each word in name. for example if variable name is firstname then it should be FirstName
b) name should be meaningfull. like id should be Id, login id should be LoginId, loop counter should be Counter or ProductCounter

5. All function names should follow
a) first character of first word should be small. for example if function name is get_quantity then it should be getQuantity or get_email_id should be getEmailId

6. All variables should be declared before use

7. All variables should be destroyed immediately after its FINAL use

********* code formatting *******

8. For each function there should be comments above it which explains use of function, user of parameters and return type.

/**
* use of function
* @variable name - data type - use of variable - default value in case of optional - allowed values in case of fixed value options
* return - data type - explaination
**/

for example

/**
* validates passed user name and password and returns true or false
* @UserName - string - user name
* @Password - string - password
* return boolean - true / false
**/

function validatePassword(UserName, Password)
{
}

second example

/**
* constructor of class
* @CategoryId - int - category id to filter products - default 0
* @FetchAll - boolean - if true then fetches all records from database - false - true/false
**/

function Products(CategoryId = 0, FetchAll = false)

9. For each variable there should be comment for use of variable

for example

var $iCounter; // counter of products loop

10. Each inner block should be started with a tab
for example

Outer block
Inner block 1 statement 1
Inner block 1 statement 1
Inner block 1 statement 1
Inner block 2 statement 1
Inner block 2 statement 2
Inner block 1 statement 1
Inner block 3 statement 1
Inner block 4 statement 1

11. block bracket should start be on separate line
for example

block start
{
block statement 1
block statement 2
block statement 3
}

12. there should be space after and before any operator = > < ; + - * /

How to Unzip/Extract zip file into one directory.

2010-02-04T01:09:00.000-08:00

ini_set(’memory_limit’,'800M’);
set_time_limit(36000);
/**
* @Module to Extract folder in one directory
* @package general
* @Author: Mr. Manoj M.Ninave
**/
//create media/import directory in root dir
$dir = $_SERVER['DOCUMENT_ROOT'].”/media/import”;
$filename = $dir.”/ABC.zip”;//destination
$zip_file = “http://www.yourssite.com/ABC.zip”;//source
$contents = file_get_contents($zip_file);
//echo $contents;
$handle = fopen($filename, “w+”);
fwrite($handle,$contents);
fclose($handle);
$zip = zip_open($filename);
if ($zip)
{
while ($zip_entry = zip_read($zip))
{
$zipEntry = zip_entry_name($zip_entry);
$zipEntryFile = substr($zipEntry,strrpos($zipEntry,”/”)+1);
$dirFile = $zipEntryFile;//unzipped directory
$dirPath = $dir.”/”.$dirFile;
$fp = fopen($dirPath, “w+”);
if (!$fp)
continue;
if(zip_entry_open($zip,$zip_entry, “r”))
{
$buf = zip_entry_read($zip_entry, zip_entry_filesize($zip_entry));
fwrite($fp,$buf);
zip_entry_close($zip_entry);
fclose($fp);
}
}
zip_close($zip);
}
unlink($filename);
//unlink($dirPath);
echo “Unzipped successfully.”;
First it will copy zip file from source to destination.
All the files in subdirectory will extract in one directory i.e. in media/import directory.
Regard
Manoj Ninave
Software Engineer,