Skip to content

Instantly share code, notes, and snippets.

View PintuKumarPal's full-sized avatar

Pintu Kumar PintuKumarPal

  • MessageBroadcast
  • Ghaziabad
View GitHub Profile
@PintuKumarPal
PintuKumarPal / map.php
Created September 16, 2014 20:45
<!DOCTYPE html>
<html>
<head>
<title>Place Autocomplete Address Form</title>
<meta name="viewport" content="initial-scale=1.0, user-scalable=no">
@PintuKumarPal
PintuKumarPal / createtextbox.cfm
Created April 8, 2014 16:37
<style>
.hideMe{
display:none;
}
.btn-small {
@PintuKumarPal
PintuKumarPal / playerimage.cfm
Created February 2, 2014 13:54
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7/jquery.js"></script>
<script>
$(document).ready(function(e)
{
<!---************Start: Image Upload Function On select browse Image--->
@PintuKumarPal
PintuKumarPal / queryalteration.cfm
Created January 15, 2014 10:31
<!---Start: Original Query Output--->
<cfquery name="GetAnswerDetails" datasource="10.26.0.40">
SELECT t1.batchId_int,t1.quesId_int,upper(t2.input_vch) as input_vch,t1.type,t1.optionCount_int,t1.text_vch,count(*) as TotalAnswer
FROM ymsReport.BatchQuestions t1
join ymsReport.UsersReply t2
on t1.batchId_int = t2.batchId_bi
and t1.quesId_int = t2.pId_int
and t1.text_vch <> ''
where `type` in ('SHORTANSWER','ONESELECTION')
group by t1.batchId_int,t1.quesId_int,t2.input_vch,t1.type,t1.optionCount_int,t1.text_vch limit 0,29;
@PintuKumarPal
PintuKumarPal / act_deleteguest.php
Created January 15, 2014 09:54
<?php
$sql = "delete from GUEST_EVENT
where
GUEST_ID=$_REQUEST[guestID]";
$dbCards=mysqli_connect("127.0.0.1","root","pinturp1","mycardco_marriage");
@PintuKumarPal
PintuKumarPal / cfspreadsheet.cfm
Created January 7, 2014 14:13
<cfsetting showdebugoutput="false">
<cfsetting requesttimeout="3600">
<cfquery name="GetUsers" datasource="TestDB">
SELECT * FROM shema_users
</cfquery>
<cfset q= queryNew("UserName,EmailID,Password,UserType,Status")>
<cfset filename = expandPath("ExcelFile.xls")>
@PintuKumarPal
PintuKumarPal / ajaxcall.cfc
Created December 2, 2013 20:45
<cfcomponent>
<cffunction name="GetMtDetails" access="remote" returnformat="plain">
<cfset sdate = "#dateformat(sdt,'yyyy/mm/dd')# 00:00:00" />
<cfset eDate = "#dateformat(edt,'yyyy/mm/dd')# 23:59:59" />
<cfquery name="TotalMessages" datasource="Test">
SELECT COUNT(*) as CountMessages FROM sms_Delivery
WHERE
DateSent_dt BETWEEN '#sdate#' AND '#eDate#'
</cfquery>
@PintuKumarPal
PintuKumarPal / uniquenameinphp.php
Created December 2, 2013 20:20
<?php
//****** Function for generate random character *****************************/
function randomGenerator($strlength)
{
$str="ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
$strshuf=str_shuffle($str);
$start=rand(0,strlen($str) - $strlength);
return substr(str_shuffle($strshuf),$start,$strlength);
}
@PintuKumarPal
PintuKumarPal / loginInformation.cfm
Created December 2, 2013 20:16
<cfoutput>
<cfset api_key = "408300609288755"/>
<cfset secret_key = "86f3386be0df8c40dab97c8af3c0d237"/>
<cfset appID = "408300609288755"/>
<cfhttp url="https://graph.facebook.com/oauth/access_token" result="GetAccessToken">
@PintuKumarPal
PintuKumarPal / authentication.cfm
Created December 2, 2013 20:13
where you want to place facebook login button
<cfoutput>
<!---You can fine app_key and secret_key by creating a account with facebook and make these by creating app for your website--->
<cfset api_key = "408300609288755"/>
<cfset secret_key = "86f3386be0df8c40dab97c8af3c0d237"/>
<cfset appID = "408300609288755"/>