I have created code to import gmail contact.

[eluser]Unknown[/eluser]
Model: import_contact.php

<?php

class import_contact extends Model {
function __construct(){
parent::Model();
}

function insertEmail($username,$password) {
$sql = "INSERT INTO email_record (`email`,`password`) values(?,?) ";
$query = $this->db->query($sql, array($username,$password));
return $this->db->insert_id();
}

function insertContact($id,$name,$email) {
$sql = "INSERT INTO contact_list (`email`,`name`,`email_id`) values(?,?,?) ";
$query = $this->db->query($sql, array($email,$name,$id));
//return $query;
return $query;
}


function getContact($num, $offset) {
$query = $this->db->get('contact_list', $num, $offset);
//return $query;
return $query->result_array();
}
}

?>

Table Structure:

CREATE TABLE IF NOT EXISTS `contact_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`email_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `email_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



View: import_contact.php
<?php echo form_open('import/import_contact');?>
<div class="code">
Please enter only gmail username/password.
<div class="label">Username</div>
<div class="field">
&lt;?php $data = array(
'name' => 'username',
'id' => 'username',
'value' => set_value('username'),
'maxlength' => '100',
'size' => '50',
'style' => 'width:230px',
);
echo form_input($data);
?&gt;

</div>
<div style="clear:both;"></div>
<div class="label">Password</div><div class="field">&lt;?php $data = array(
'name' => 'password',
'id' => 'password',
'value' => '',
'maxlength' => '100',
'type' => 'password',
'size' => '50',
'style' => 'width:230px',
);
echo form_input($data);
?&gt; </div>
<div style="clear:both;"></div>
<div class="button">&lt;?php echo form_submit('import', 'Get Contact'); ?&gt;</div>
<div style="clear:both;"></div>

</div>
&lt;?php
$list="";
$list.="<div class='mainDiv'><div class='namehead'>Name</div><div class='emailhead'>Email</div><div style='clear:both'></div>";
if(count($emailLists)>0){
foreach($emailLists as $contactlist){

$name=empty($contactlist['fullName'])?$contactlist['name']:$contactlist['fullName'];
$email=empty($contactlist['email'])?$contactlist['email_3']:$contactlist['email'];
$list.="<div style='clear:both'></div><div class='name'>".(empty($name)?"-":$name)."</div><div class='emailvalue'>".$email."</div><div style='clear:both'></div>";
}
$list.='</div>';
echo $list;
echo '<div style="padding-top:10px;">
'.$this->pagination->create_links().'</div>';
}

?&gt;