Skip to content

Instantly share code, notes, and snippets.

View sanjaybhowmick's full-sized avatar

Sanjay Bhowmick sanjaybhowmick

View GitHub Profile
@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({
@sanjaybhowmick
sanjaybhowmick / functions.php
Created September 10, 2015 02:53
Setting up responsive image in WordPress
<?php
add_filter( 'post_thumbnail_html', 'remove_thumbnail_dimensions', 10 );
add_filter( 'image_send_to_editor', 'remove_thumbnail_dimensions', 10 );
function remove_thumbnail_dimensions( $html )
{
$html = preg_replace( '/(width|height)="d*"s/', "", $html );
return $html;
}
?>
@sanjaybhowmick
sanjaybhowmick / remove.php
Created September 9, 2015 18:26
Destroy all the files in a directory
<?php
$dir = getcwd() . '/';
define('PATH', $dir);
function destroy($dir) {
$mydir = opendir($dir);
while(false !== ($file = readdir($mydir))) {
if($file != "." && $file != "..") {
chmod($dir.$file, 0777);
if(is_dir($dir.$file)) {
chdir('.');