Skip to content

Instantly share code, notes, and snippets.

View sanjaybhowmick's full-sized avatar

Sanjay Bhowmick sanjaybhowmick

1 follower · 1 following
  • Kolkata, India
  • 16:24 (UTC +05:30)
View GitHub Profile
@sanjaybhowmick
sanjaybhowmick / inr-numeric-words.php
Created June 29, 2024 06:25
Indian currency numeric to words conversion
<?php
function convertToIndianCurrencyWords($number) {
$ones = array(
0 => '', 1 => 'One', 2 => 'Two', 3 => 'Three', 4 => 'Four',
5 => 'Five', 6 => 'Six', 7 => 'Seven', 8 => 'Eight', 9 => 'Nine'
);
$teens = array(
11 => 'Eleven', 12 => 'Twelve', 13 => 'Thirteen', 14 => 'Fourteen',
15 => 'Fifteen', 16 => 'Sixteen', 17 => 'Seventeen', 18 => 'Eighteen',
@sanjaybhowmick
sanjaybhowmick / html-table-changed-data.html
Created June 29, 2024 06:18
HTML table changed data comparision
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Highlight Changed Data</title>
<style>
.changed {
background-color: yellow;
}
@sanjaybhowmick
sanjaybhowmick / loop.php
Created June 9, 2017 08:54
WooCommerce Featured Products loop
<!-- Featured products loop -->
<?php
$args = array(
'posts_per_page' => -1,
'post_type' => 'product',
'post_status' => 'publish',
'tax_query' => array(
array(
'taxonomy' => 'product_visibility',
'field' => 'name',
@sanjaybhowmick
sanjaybhowmick / functions.php
Created April 26, 2016 06:40
Google Map Embed in WordPress Post / Page
<?php
// Google Map embed short code
// Usage: [googlemap src="you_url"]
function GoogleMapEmbed($atts, $content = null) {
extract(shortcode_atts(array(
"width" => '100%',
"height" => '480',
"src" => ''
), $atts));
return '<iframe width="'.$width.'" height="'.$height.'" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="'.$src.'" ></iframe>';
@sanjaybhowmick
sanjaybhowmick / database.sql
Last active June 6, 2022 08:34
PayPal IPN Integration - PHP & MySQL
CREATE TABLE IF NOT EXISTS `payments` (
`id` int(6) NOT NULL AUTO_INCREMENT,
`txnid` varchar(20) NOT NULL,
`payment_amount` decimal(7,2) NOT NULL,
`payment_status` varchar(25) NOT NULL,
`itemid` varchar(25) NOT NULL,
`createdtime` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
@sanjaybhowmick
sanjaybhowmick / cancel.php
Last active March 14, 2016 10:39
Simple PayPal Integration
<?php
echo "<h1>Welcome, Guest</h1>";
echo "<h1>Payment Canceled</h1>";
?>
@sanjaybhowmick
sanjaybhowmick / dbconversion.php
Created September 10, 2015 03:24
Convert MySQL collation from utf8mb4 to utf8
<?php
$dbname = 'your-database-name';
mysql_connect('your-database-hostname', 'your-database-username', 'your-database-password');
mysql_query("ALTER DATABASE `$dbname` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
$result = mysql_query("SHOW TABLES FROM `$dbname`");
while($row = mysql_fetch_row($result)) {
$query = "ALTER TABLE {$dbname}.`{$row[0]}` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci";
mysql_query($query);
$query = "ALTER TABLE {$dbname}.`{$row[0]}` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci";
mysql_query($query);
@sanjaybhowmick
sanjaybhowmick / search.php
Created September 10, 2015 03:10
Count your wordpress search results
<div>
<?php $allsearch = &new WP_Query("s=$s&showposts=-1"); $key = wp_specialchars($s, 1); $count = $allsearch->post_count; ?>
<form name="searchform" method="get" action="<?php bloginfo('home');?>">
<input name="s" type="text" value="<?php echo $key;?>" />
<input name="submit" type="submit" value="Search" />
</form>
<div></div>
</div>
<h2>Search Results</h2>
<h3><?php echo $count;?> items found on your search words '<?php echo $key;?>'</h3>
@sanjaybhowmick
sanjaybhowmick / postal_lang_long.php
Created September 10, 2015 03:04
Get Latitude and Longitude from your Postal Address
<?php
if ($_REQUEST[where]) {
$where = stripslashes($_REQUEST[where]);
$whereurl = urlencode($where);
// Note - Google key is domain specific!
$location = file("http://maps.google.com/maps/geo?q=$whereurl&output=csv&key=ABQIAAAAvp3__HwvT3VkixIIbsW0axQuKI_6t1bH2P0vC
I_Q8jfpn8qdNBQMnneljxh9czilkau_bYSCXteS_A");
// Sample - $location[0]="200,8,51.369318,-2.133457";
list ($stat,$acc,$north,$east) = explode(",",$location[0]);
$html = "Information for ".htmlspecialchars($where)."
@sanjaybhowmick
sanjaybhowmick / template.php
Created September 10, 2015 02:58
instagram image feed on your website
<div class="instram-container">
<?php
$user_id = "xxxxxxxxxx"; //userid
$num_to_display = "8"; //instagram limits to max 20, but you can do less for your layout.
$access_token = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"; // access token
?>
<div class="instagram-block"></div>
<script type="text/javascript">
$(function() {
$.ajax({