pipiscrew’s gists

pipiscrew / read_result_from_procedure.php

Last active August 29, 2015 14:00

[php+mysql] read result from procedure

	/*
	WARNING CANT BE USED ON BULK OPERATIONS, USE OUT PARAMETER!
	*/

	//procedure
	DELIMITER $$

	CREATE PROCEDURE ADD_CAUSECOMPANY (IN fb_idVAR varchar(50))
	BEGIN

pipiscrew / read_multiple_recordset_from_procedure.php

Created May 9, 2014 04:46

[php+mysql] read multiple recordset from procedure

	<?php
	//ref : http://stackoverflow.com/questions/8710238/fetch-multiple-recordset-using-mysqli-object


	//mysql
	DELIMITER $$
	CREATE PROCEDURE `multiple`()
	BEGIN
	SELECT * FROM account;
	SELECT * FROM admin;

pipiscrew / backup_mysql_database_to_file.php

Created May 9, 2014 06:29

[php+mysql] backup mysql database to file

	<?php

	//ref : http://davidwalsh.name/backup-mysql-database-php

	backup_tables('localhost','','','dbasename');

	/* backup the db OR just a table */
	function backup_tables($host,$user,$pass,$name,$tables = '*')
	{

pipiscrew / firebase_Transaction_update_multiple_fields.js

Last active August 29, 2015 14:01

[js] Firebase - Transaction update multiple fields

	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
	<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0" />

	<script type='text/javascript' src='jquery-1.10.2.min.js'></script>
	<!-- firebase -->
	<script type='text/javascript' src='https://cdn.firebase.com/v0/firebase.js'></script>
	<script type='text/javascript' src='https://cdn.firebase.com/v0/firebase-simple-login.js'></script>

pipiscrew / android_get_sign_hash_for_facebook.java

Created May 29, 2014 09:03

[android] get sign hash for facebook

	//verified is the same as OpenSSL

	public void btnSIGN_Click(View v) {
	try {
	packageInfo = getPackageManager().getPackageInfo("com.example.test2.test2.fb", PackageManager.GET_SIGNATURES);
	for (Signature signature : packageInfo.signatures) {
	MessageDigest md = MessageDigest.getInstance("SHA");
	md.update(signature.toByteArray());
	String key = new String(Base64.encode(md.digest(), 0));
	Toast.makeText(MainActivity.this, key + "\r\nsee LogCat", Toast.LENGTH_LONG).show();

pipiscrew / parse.com_-_query_data_browser_rows.php

Last active August 29, 2015 14:02

[php] parse.com - query data browser rows

	<?php
	//http://blog.parse.com/2013/03/19/implementing-scalable-search-on-a-nosql-backend/

	//10/4/2014-https://parse.com/questions/query-for-analytics-event-data

	//10/6/2014 even writes that supports event queries - tested and no working!
	//https://www.parse.com/docs/rest#analytics-custom

	$headers = array( "X-Parse-Application-Id: x" , "X-Parse-REST-API-Key: y", "Content-Type: application/json");

pipiscrew / flurry_read_event_variables.php

Last active August 29, 2015 14:02

[php] flurry read event variables

	<?php

	//used for defined array, used on functions
	class RECORD {
	public $date_rec;
	public $sessionID;
	public $event_name;
	public $app_version;
	public $app_platform;
	public $device;

pipiscrew / firebase_login_with_token.js

Created June 16, 2014 13:08

[js] firebase - login with token

	<script src="https://cdn.firebase.com/v0/firebase.js"></script>
	<script type='text/javascript' src="https://cdn.firebase.com/v0/firebase-token-generator.js"></script>

	var tokenGenerator = new FirebaseTokenGenerator("x");
	var token = tokenGenerator.createToken({isModerator: true});

	var dataRef = new Firebase("https://x.firebaseio.com/");

	dataRef.auth(token, function(error) {
	if(error) {

pipiscrew / sort_list_t.java

Created June 16, 2014 13:12

[android] Sort List<t>

	//at activity
	List<TestItem> rowItems = new ArrayList<TestItem>();

	TestItem rec;

	for (DataSnapshot snapshot : arg0.getChildren()) {
	rec = new TestItem();

	rec.setID(snapshot.getRef().getName());

pipiscrew / pass_PHP_mySQL_recordset_to_Javascript.js

Created June 23, 2014 12:07

[php+js] pass PHP mySQL recordset to Javascript