Fusion of Thoughts - Its your fusion.

Fusion of Thoughts Blog

March 30, 2018

Codeigniter insert if not exist and update if not

First you need to check whether the user or data is exits or not. then you can perform the update and insert operation.

$this->db->where('user_id',$id);
$q = $this->db->get('profile');
if ( $q->num_rows() > 0 )
{
$this->db->where('user_id',$id);
$this->db->update('profile',$data);
} else {
$this->db->set('user_id', $id);
$this->db->insert('profile',$data);
}

$this->db->where('user_id',$id);

$q = $this->db->get('profile');

if ( $q->num_rows() > 0 )

{

$this->db->where('user_id',$id);

$this->db->update('profile',$data);

} else {

$this->db->set('user_id', $id);

$this->db->insert('profile',$data);

}

There is one more way by using mysql query...

How to download multiple files at once – in single command

php

October 11, 2017

How to download multiple files at once – in single command

Suppose you have approx 1000 image files for download, then here is a command to download all them. Create a text file named it urls.txt enter all urls each url in a new line...

php

August 10, 2017

CakePHP in a subdirectory using nginx

CakePHP in a subdirectory using nginx cakephp subdirectory nginx I was facing many issues in setup cakephp3 in subfolder on nginx server. I was doing changes in new server config while we have to...

codility brackets opening and closing solution

php

March 20, 2017

codility brackets opening and closing solution

Codility brackets opening closing. codility brackets opening closing. codility you are given a string s consisting of n brackets opening problem solution.

function isBalanced($str){
$count = 0;
$ocount = 0;
$ccount = 0;
$length = strlen($str);
for($i = 0; $i &lt; $length; $i++){
if($str[$i] == '(')
$ocount += 1;
else if($str[$i] == ')')
$ccount += 1;
if($ccount == $ocount){
$count = $ocount;
}else{
$count = $ccount;
}
}
return $count;
}
echo isBalanced("))");

function isBalanced($str){

$count = 0;

$ocount = 0;

$ccount = 0;

$length = strlen($str);

for($i = 0; $i < $length; $i++){

if($str[$i] == '(')

$ocount += 1;

else if($str[$i] == ')')

$ccount += 1;

if($ccount == $ocount){

$count = $ocount;

}else{

$count = $ccount;

}

return $count;

}

echo isBalanced("))");

php

February 15, 2017

Push notification Android Php

Hey, Today we learn how to send push notification for android in php. First create a class with following code

&lt;?php
class Pusher{
const GOOGLE_GCM_URL = 'https://android.googleapis.com/gcm/send';
private $apiKey;
private $proxy;
private $output;
public function __construct($apiKey, $proxy = null)
{
$this-&gt;apiKey = 'your_key';
$this-&gt;proxy  = $proxy;
}
/**
* @param string|array $regIds
* @param string $data
* @throws Exception
*/
public function notify($regIds, $data)
{
//        pr($data);
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, self::GOOGLE_GCM_URL);
if (!is_null($this-&gt;proxy)) {
curl_setopt($ch, CURLOPT_PROXY, $this-&gt;proxy);
}
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, $this-&gt;getHeaders());
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_POSTFIELDS, $this-&gt;getPostFields($regIds, $data));
$result = curl_exec($ch);
if ($result === false) {
throw new Exception(curl_error($ch));
}
curl_close($ch);
//        pr($result); die;
$this-&gt;output = $result;
return $result;
}
/**
* @return array
*/
public function getOutputAsArray()
{
return json_decode($this-&gt;output, true);
}
/**
* @return object
*/
public function getOutputAsObject()
{
return json_decode($this-&gt;output);
}
private function getHeaders(){
return [
'Authorization: key=' . $this-&gt;apiKey,
'Content-Type: application/json'
];
}
private function getPostFields($regIds, $data){
$fields = [
'registration_ids' =&gt; is_string($regIds) ? [$regIds] : $regIds,
'data'             =&gt; is_string($data) ? ['message' =&gt; $data] : $data,
];
return json_encode($fields, JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_QUOT | JSON_HEX_AMP | JSON_UNESCAPED_UNICODE);
}
}

<?php

class Pusher{

const GOOGLE_GCM_URL = 'https://android.googleapis.com/gcm/send';

private $apiKey;

private $proxy;

private $output;

public function __construct($apiKey, $proxy = null)

{

$this->apiKey = 'your_key';

$this->proxy = $proxy;

}

/**

* @param string|array $regIds

* @param string $data

* @throws Exception

public function notify($regIds, $data)

{

// pr($data);

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL, self::GOOGLE_GCM_URL);

if (!is_null($this->proxy)) {

curl_setopt($ch, CURLOPT_PROXY, $this->proxy);

}

curl_setopt($ch, CURLOPT_POST, true);

curl_setopt($ch, CURLOPT_HTTPHEADER, $this->getHeaders());

curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);

curl_setopt($ch, CURLOPT_POSTFIELDS, $this->getPostFields($regIds, $data));

$result = curl_exec($ch);

if ($result === false) {

throw new Exception(curl_error($ch));

}

curl_close($ch);

// pr($result); die;

$this->output = $result;

return $result;

}

/**

* @return array

public function getOutputAsArray()

{

return json_decode($this->output, true);

}

/**

* @return object

public function getOutputAsObject()

{

return json_decode($this->output);

}

private function getHeaders(){

return [

'Authorization: key=' . $this->apiKey,

'Content-Type: application/json'

];

}

private function getPostFields($regIds, $data){

$fields = [

'registration_ids' => is_string($regIds) ? [$regIds] : $regIds,

'data' => is_string($data) ? ['message' => $data] : $data,

];

return json_encode($fields, JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_QUOT | JSON_HEX_AMP | JSON_UNESCAPED_UNICODE);

}

now call your notify function by creating a object of pusher class....

Iphone / php

February 13, 2017

Push notification IOS

&lt;?php
// authentication
$host = "localhost";
$user = "user";
$pass = "pass";
$dbname = "DB";
// create connection with database
$con = mysql_connect($host, $user, $pass);
// check whether database connection is successful
if (!$con) {
// if connection not successful then stop the script and show the error
die('Could not connect to database: ' . mysql_error());
} else {
// if database connection successful then select the database
mysql_select_db($dbname, $con);
}
// get the id, token from database
$query = "SELECT `notifications`.`id` as pid, `notifications`.`by_userid`, `notifications`.`userid`, `notifications`.`messege`, `notifications`.`is_read`,  `users`.`id`, `users`.`name`, `users`.`email`, `users`.`dob`, `users`.`gender`,  `users`.`profile_pic`, `users`.`device_id` FROM `table`.`notifications` AS `notifications`  INNER JOIN `table2`.`users` AS `users` ON (`notifications`.`userid` = `users`.`id`) WHERE `notifications`.`is_read` = '0' ";
$result = mysql_query($query);
$data = mysql_fetch_array($result);
$count = count($data);
//Setup notification message
$body = array();
$body['aps'] = array('alert' =&gt; $data['messege']);
$body['aps']['notifurl'] = 'yourwebsite.com/push_new.php';
$body['aps']['badge'] = $count;
$body['aps']['messege'] = $data['messege'];
$body['aps']['id'] = $data['pid'];
$id = $data['pid'];
//Setup stream (connect to Apple Push Server)
$ctx = stream_context_create();
stream_context_set_option($ctx, 'ssl', 'passphrase', '123456');
stream_context_set_option($ctx, 'ssl', 'local_cert', 'certificate.pem'); // add your .pem file
$fp = stream_socket_client('ssl://gateway.sandbox.push.apple.com:2195', $err, $errstr, 60, STREAM_CLIENT_CONNECT, $ctx);
stream_set_blocking($fp, 0);
// This allows fread() to return right away when there are no errors. But it can also miss errors during
//  last  seconds of sending, as there is a delay before error is returned. Workaround is to pause briefly
// AFTER sending last notification, and then do one more fread() to see if anything else is there.
if (!$fp) {
//ERROR
echo "Failed to connect (stream_socket_client): $err $errstrn";
} else {
// Keep push alive (waiting for delivery) for 90 days
$apple_expiry = time() + (90 * 24 * 60 * 60);
// Loop thru tokens from database
while ($row = mysql_fetch_array($result)) {
$apple_identifier = $row["id"];
$deviceToken = $row['device_id'];
$payload = json_encode($body);
// Enhanced Notification
$msg = pack("C", 1) . pack("N", $apple_identifier) . pack("N", $apple_expiry) . pack("n", 32) . pack('H*', str_replace(' ', '', $deviceToken)) . pack("n", strlen($payload)) . $payload;
// SEND PUSH
fwrite($fp, $msg);
// We can check if an error has been returned while we are sending, but we also need to
// check once more after we are done sending in case there was a delay with error response.
checkAppleErrorResponse($fp);
}
// Workaround to check if there were any errors during the last seconds of sending.
// Pause for half a second.
// Note I tested this with up to a 5 minute pause, and the error message was still available to be retrieved
usleep(500000);
checkAppleErrorResponse($fp);
echo 'Completed';
$query = "UPDATE `notifications` SET `is_read` = 1 WHERE id = $id ";
$results = mysql_query($query);
mysql_close($con);
fclose($fp);
}
// FUNCTION to check if there is an error response from Apple
// Returns TRUE if there was and FALSE if there was not
function checkAppleErrorResponse($fp) {
//byte1=always 8, byte2=StatusCode, bytes3,4,5,6=identifier(rowID).
// Should return nothing if OK.
//NOTE: Make sure you set stream_set_blocking($fp, 0) or else fread will pause your script and wait
// forever when there is no response to be sent.
$apple_error_response = fread($fp, 6);
if ($apple_error_response) {
// unpack the error response (first byte 'command" should always be 8)
$error_response = unpack('Ccommand/Cstatus_code/Nidentifier', $apple_error_response);
if ($error_response['status_code'] == '0') {
$error_response['status_code'] = '0-No errors encountered';
} else if ($error_response['status_code'] == '1') {
$error_response['status_code'] = '1-Processing error';
} else if ($error_response['status_code'] == '2') {
$error_response['status_code'] = '2-Missing device token';
} else if ($error_response['status_code'] == '3') {
$error_response['status_code'] = '3-Missing topic';
} else if ($error_response['status_code'] == '4') {
$error_response['status_code'] = '4-Missing payload';
} else if ($error_response['status_code'] == '5') {
$error_response['status_code'] = '5-Invalid token size';
} else if ($error_response['status_code'] == '6') {
$error_response['status_code'] = '6-Invalid topic size';
} else if ($error_response['status_code'] == '7') {
$error_response['status_code'] = '7-Invalid payload size';
} else if ($error_response['status_code'] == '8') {
$error_response['status_code'] = '8-Invalid token';
} else if ($error_response['status_code'] == '255') {
$error_response['status_code'] = '255-None (unknown)';
} else {
$error_response['status_code'] = $error_response['status_code'] . '-Not listed';
}
echo '&lt;br&gt;&lt;b&gt;+ + + + + + ERROR&lt;/b&gt; Response Command:&lt;b&gt;' . $error_response['command'] . '&lt;/b&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;Identifier:&lt;b&gt;' . $error_response['identifier'] . '&lt;/b&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;Status:&lt;b&gt;' . $error_response['status_code'] . '&lt;/b&gt;&lt;br&gt;';
echo 'Identifier is the rowID (index) in the database that caused the problem, and Apple will disconnect you from server. To continue sending Push Notifications, just start at the next rowID after this Identifier.&lt;br&gt;';
return true;
}
return false;
}
?&gt;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

<?php

// authentication

$host = "localhost";

$user = "user";

$pass = "pass";

$dbname = "DB";

// create connection with database

$con = mysql_connect($host, $user, $pass);

// check whether database connection is successful

if (!$con) {

// if connection not successful then stop the script and show the error

die('Could not connect to database: ' . mysql_error());

} else {

// if database connection successful then select the database

mysql_select_db($dbname, $con);

}

// get the id, token from database

$query = "SELECT `notifications`.`id` as pid, `notifications`.`by_userid`, `notifications`.`userid`, `notifications`.`messege`, `notifications`.`is_read`, `users`.`id`, `users`.`name`, `users`.`email`, `users`.`dob`, `users`.`gender`, `users`.`profile_pic`, `users`.`device_id` FROM `table`.`notifications` AS `notifications` INNER JOIN `table2`.`users` AS `users` ON (`notifications`.`userid` = `users`.`id`) WHERE `notifications`.`is_read` = '0' ";

$result = mysql_query($query);

$data = mysql_fetch_array($result);

$count = count($data);

//Setup notification message

$body = array();

$body['aps'] = array('alert' => $data['messege']);

$body['aps']['notifurl'] = 'yourwebsite.com/push_new.php';

$body['aps']['badge'] = $count;

$body['aps']['messege'] = $data['messege'];

$body['aps']['id'] = $data['pid'];

$id = $data['pid'];

//Setup stream (connect to Apple Push Server)

$ctx = stream_context_create();

stream_context_set_option($ctx, 'ssl', 'passphrase', '123456');

stream_context_set_option($ctx, 'ssl', 'local_cert', 'certificate.pem'); // add your .pem file

$fp = stream_socket_client('ssl://gateway.sandbox.push.apple.com:2195', $err, $errstr, 60, STREAM_CLIENT_CONNECT, $ctx);

stream_set_blocking($fp, 0);

// This allows fread() to return right away when there are no errors. But it can also miss errors during

// last seconds of sending, as there is a delay before error is returned. Workaround is to pause briefly

// AFTER sending last notification, and then do one more fread() to see if anything else is there.

if (!$fp) {

//ERROR

echo "Failed to connect (stream_socket_client): $err $errstrn";

} else {

// Keep push alive (waiting for delivery) for 90 days

$apple_expiry = time() + (90 * 24 * 60 * 60);

// Loop thru tokens from database

while ($row = mysql_fetch_array($result)) {

$apple_identifier = $row["id"];

$deviceToken = $row['device_id'];

$payload = json_encode($body);

// Enhanced Notification

$msg = pack("C", 1) . pack("N", $apple_identifier) . pack("N", $apple_expiry) . pack("n", 32) . pack('H*', str_replace(' ', '', $deviceToken)) . pack("n", strlen($payload)) . $payload;

// SEND PUSH

fwrite($fp, $msg);

// We can check if an error has been returned while we are sending, but we also need to

// check once more after we are done sending in case there was a delay with error response.

checkAppleErrorResponse($fp);

}

// Workaround to check if there were any errors during the last seconds of sending.

// Pause for half a second.

// Note I tested this with up to a 5 minute pause, and the error message was still available to be retrieved

usleep(500000);

checkAppleErrorResponse($fp);

echo 'Completed';

$query = "UPDATE `notifications` SET `is_read` = 1 WHERE id = $id ";

$results = mysql_query($query);

mysql_close($con);

fclose($fp);

}

// FUNCTION to check if there is an error response from Apple

// Returns TRUE if there was and FALSE if there was not

function checkAppleErrorResponse($fp) {

//byte1=always 8, byte2=StatusCode, bytes3,4,5,6=identifier(rowID).

// Should return nothing if OK.

//NOTE: Make sure you set stream_set_blocking($fp, 0) or else fread will pause your script and wait

// forever when there is no response to be sent.

$apple_error_response = fread($fp, 6);

if ($apple_error_response) {

// unpack the error response (first byte 'command" should always be 8)

$error_response = unpack('Ccommand/Cstatus_code/Nidentifier', $apple_error_response);

if ($error_response['status_code'] == '0') {

$error_response['status_code'] = '0-No errors encountered';

} else if ($error_response['status_code'] == '1') {

$error_response['status_code'] = '1-Processing error';

} else if ($error_response['status_code'] == '2') {

$error_response['status_code'] = '2-Missing device token';

} else if ($error_response['status_code'] == '3') {

$error_response['status_code'] = '3-Missing topic';

} else if ($error_response['status_code'] == '4') {

$error_response['status_code'] = '4-Missing payload';

} else if ($error_response['status_code'] == '5') {

$error_response['status_code'] = '5-Invalid token size';

} else if ($error_response['status_code'] == '6') {

$error_response['status_code'] = '6-Invalid topic size';

} else if ($error_response['status_code'] == '7') {

$error_response['status_code'] = '7-Invalid payload size';

} else if ($error_response['status_code'] == '8') {

$error_response['status_code'] = '8-Invalid token';

} else if ($error_response['status_code'] == '255') {

$error_response['status_code'] = '255-None (unknown)';

} else {

$error_response['status_code'] = $error_response['status_code'] . '-Not listed';

}

echo ' + + + + + + ERROR Response Command:' . $error_response['command'] . '&nbsp;&nbsp;&nbsp;Identifier:' . $error_response['identifier'] . '&nbsp;&nbsp;&nbsp;Status:' . $error_response['status_code'] . ' ';

echo 'Identifier is the rowID (index) in the database that caused the problem, and Apple will disconnect you from server. To continue sending Push Notifications, just start at the next rowID after this Identifier. ';

return true;

}

return false;

}

Uncategorized

January 13, 2017

Email template optimization tools

Here is the list of email templates optimization tools. Remember to exclude media query if you have for responsive design. They will not work properly if inline. Some time might face a problem...

Configure ejabberd xmpp on ubuntu server part-2

php

April 21, 2016

Configure ejabberd xmpp on ubuntu server part-2

configure ejabberd xmpp ubuntu server part 2 In First Tutorial we have configure ejabberd XMPP with default menisa database . now in this tutorial i will explain how to configure ejabberd with MySql ....

Configure ejabberd xmpp on ubuntu server Part-1

php

April 18, 2016

Configure ejabberd xmpp on ubuntu server Part-1

Configure ejabberd xmpp ubuntu server After facing so many issues and investing so many hours I write below steps for configure ejabberd. In first tourial we learn how to configure ejabbere on...

mysql / php

December 30, 2015

export database table by php

export database table php Sometime there is need to export database table by php code. There is a very simple approach to do this.

/*******EDIT LINES 3-8*******/
$DB_Server = "localhost"; //MySQL Server    
$DB_Username = ""; //MySQL Username     
$DB_Password = "";             //MySQL Password     
$DB_DBName = "";         //MySQL Database Name  
$DB_TBLName = "tablename"; //MySQL Table Name   
$filename = "Student_export-".time();         //File Name
/*******YOU DO NOT NEED TO EDIT ANYTHING BELOW THIS LINE*******/    
//create MySQL connection   
$sql = "SELECT * FROM  ".$DB_TBLName ;
$Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die("Couldn't connect to MySQL:&lt;br&gt;" . mysql_error() . "&lt;br&gt;" . mysql_errno());
//select database   
$Db = @mysql_select_db($DB_DBName, $Connect) or die("Couldn't select database:&lt;br&gt;" . mysql_error(). "&lt;br&gt;" . mysql_errno());   
//execute query
$result = @mysql_query($sql,$Connect) or die("Couldn't execute query:&lt;br&gt;" . mysql_error(). "&lt;br&gt;" . mysql_errno());    
$file_ending = "xls";
//header info for browser
header("Content-Type: application/xls");    
header("Content-Disposition: attachment; filename=$filename.xls");  
header("Pragma: no-cache");
header("Expires: 0");
/*******Start of Formatting for Excel*******/   
//define separator (defines columns in excel &amp; tabs in word)
$sep = "\t"; //tabbed character
//start of printing column names as names of MySQL fields
for ($i = 0; $i &lt; mysql_num_fields($result); $i++) {
echo mysql_field_name($result,$i) . "\t";
}
print("\n");    
//end of printing column names  
//start while loop to get data
while($row = mysql_fetch_row($result))
{
$schema_insert = "";
for($j=0; $j&lt;mysql_num_fields($result);$j++)
{
if(!isset($row[$j]))
$schema_insert .= "NULL".$sep;
elseif ($row[$j] != "")
$schema_insert .= "$row[$j]".$sep;
else
$schema_insert .= "".$sep;
}
$schema_insert = str_replace($sep."$", "", $schema_insert);
$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);
$schema_insert .= "\t";
print(trim($schema_insert));
print "\n";
}  
die;

/*******EDIT LINES 3-8*******/

$DB_Server = "localhost"; //MySQL Server

$DB_Username = ""; //MySQL Username

$DB_Password = ""; //MySQL Password

$DB_DBName = ""; //MySQL Database Name

$DB_TBLName = "tablename"; //MySQL Table Name

$filename = "Student_export-".time(); //File Name

/*******YOU DO NOT NEED TO EDIT ANYTHING BELOW THIS LINE*******/

//create MySQL connection

$sql = "SELECT * FROM ".$DB_TBLName ;

$Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die("Couldn't connect to MySQL: " . mysql_error() . " " . mysql_errno());

//select database

$Db = @mysql_select_db($DB_DBName, $Connect) or die("Couldn't select database: " . mysql_error(). " " . mysql_errno());

//execute query

$result = @mysql_query($sql,$Connect) or die("Couldn't execute query: " . mysql_error(). " " . mysql_errno());

$file_ending = "xls";

//header info for browser

header("Content-Type: application/xls");

header("Content-Disposition: attachment; filename=$filename.xls");

header("Pragma: no-cache");

header("Expires: 0");

/*******Start of Formatting for Excel*******/

//define separator (defines columns in excel & tabs in word)

$sep = "\t"; //tabbed character

//start of printing column names as names of MySQL fields

for ($i = 0; $i < mysql_num_fields($result); $i++) {

echo mysql_field_name($result,$i) . "\t";

}

print("\n");

//end of printing column names

//start while loop to get data

while($row = mysql_fetch_row($result))

{

$schema_insert = "";

for($j=0; $j<mysql_num_fields($result);$j++)

{

if(!isset($row[$j]))

$schema_insert .= "NULL".$sep;

elseif ($row[$j] != "")

$schema_insert .= "$row[$j]".$sep;

else

$schema_insert .= "".$sep;

}

$schema_insert = str_replace($sep."$", "", $schema_insert);

$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);

$schema_insert .= "\t";

print(trim($schema_insert));

print "\n";

}

die;

joomla / mysql / php / Uncategorized

April 10, 2015

Joomla Last Database Query

Joomla Last Database Query Joomla last database query.As we all know it is a bit difficult to find last executed query in CMS. because there are lots of internal trigger and threads...

Fusion of Thoughts Blog

Codeigniter insert if not exist and update if not

How to download multiple files at once – in single command

CakePHP in a subdirectory using nginx

codility brackets opening and closing solution

Push notification Android Php

Push notification IOS

Email template optimization tools

Configure ejabberd xmpp on ubuntu server part-2

Configure ejabberd xmpp on ubuntu server Part-1

export database table by php

Joomla Last Database Query

google custom search

Follow Blog via Email

Feed

Archives

Categories

Recent Comments

Top Posts & Pages

Recent Posts: Fusion of Thoughts

How to download multiple files at once – in single command

CakePHP in a subdirectory using nginx

codility brackets opening and closing solution

Push notification Android Php

Push notification IOS

Blog Stats

Facebook

Follow me on Twitter

urfusion

Fusion of Thoughts Blog

google custom search

Follow Blog via Email

Feed

Archives

Categories

Recent Comments

Top Posts & Pages

Recent Posts: Fusion of Thoughts

Tag Cloud

Blog Stats

Follow me on Twitter