Friday, 23 December 2016

post on facebook via php

<?php
include('src/Facebook/autoload.php');

$fb = new Facebook\Facebook([
  'app_id' => 'app_id',
  'app_secret' => 'app_secret',
  'default_graph_version' => 'v2.8',
  ]);

$accesstoken = "accesstoken";

$linkData = [
  'link' => 'http://www.webbymj.com',
  'message' => 'User provided message',
  ];

try {
  // Returns a `Facebook\FacebookResponse` object
  $response = $fb->post('/me/feed', $linkData, $accesstoken);
} catch(Facebook\Exceptions\FacebookResponseException $e) {
  echo 'Graph returned an error: ' . $e->getMessage();
  exit;
} catch(Facebook\Exceptions\FacebookSDKException $e) {
  echo 'Facebook SDK returned an error: ' . $e->getMessage();
  exit;
}

$graphNode = $response->getGraphNode();

echo 'Posted with id: ' . $graphNode['id'];


?>

Thursday, 22 December 2016

Get mail from gmail with php

<?php
error_reporting('E_ALL');
/* connect to gmail */
$hostname = '{imap.gmail.com:993/imap/ssl}INBOX';
//$hostname = '{imap.secureserver.net:993/imap/ssl}INBOX';
$username = 'EMIAL@gmail.com';
$password = 'PASSWORD';

/* try to connect */
$inbox = imap_open($hostname,$username,$password) or die('Cannot connect to Gmail: ' . imap_last_error());

//print_r($inbox);
//exit();
/* grab emails */
//$emails = imap_search($inbox,'ALL');
$emails = imap_search($inbox,'SUBJECT "new requirement"');

/* if emails are returned, cycle through each... */
if($emails) {

/* begin output var */
$output = '';

/* put the newest emails on top */
rsort($emails);

/* for every email... */
foreach($emails as $email_number) {

/* get information specific to this email */
$overview = imap_fetch_overview($inbox,$email_number,0);
$message = imap_fetchbody($inbox,$email_number,2);

/* output the email header information */
$output.= '<div class="toggler '.($overview[0]->seen ? 'read' : 'unread').'">';
$output.= '<span class="subject">'.$overview[0]->subject.'</span> ';
$output.= '<span class="from">'.$overview[0]->from.'</span>';
$output.= '<span class="date">on '.$overview[0]->date.'</span>';
$output.= '</div>';

/* output the email body */
$output.= '<div class="body">'.$message.'</div>';
}

echo $output;
}

/* close the connection */
imap_close($inbox);

?>

Thursday, 1 December 2016

php to excel (download mysql data in ecxel via php)

$output = "";
if(isset($_POST['submit']))
{
$qry = mysql_query("SELECT * FROM ch_countries");
if(mysql_num_rows($qry)>0)
{
$output.= '<table class="table" border="1">
<tr>
<th>ID</th>
<th>Country Code</th>
<th>Country Name</th>
</tr> ';
while($row= mysql_fetch_array($qry))
{
$output .= '
<tr>
<td>'.$row["id"].'</td>
<td>'.$row["country_code"].'</td>
<td>'.$row["country_name"].'</td>
</tr>
';
}
$output .= '</table>';
//important part
header("Conten-Type: application/xls");
header("Content-Disposition: attachment; filename = download.xls");
echo $output;
}

}