Skip to content

Instantly share code, notes, and snippets.

View chukShirley's full-sized avatar

Chuk Shirley chukShirley

16 followers · 5 following
  • Sure Consulting LLC
  • Alabama
View GitHub Profile
@chukShirley
chukShirley / gist:7155530
Last active December 26, 2015 12:59
ZF2 Zend\Db nested select/subquery for pagination
/*
*
* Trying to produce the following sql string
*
* SELECT *
* FROM (SELECT ROWNUM() OVER(ORDER BY GAACCT) as rn, GAACCT as id, GADESC as name, GATYPE as type FROM ACCTSMST)
* WHERE rn between ? and ?
*
*/
@chukShirley
chukShirley / Autoloader.php
Last active August 29, 2015 13:57
Simple Front Controller with Namespaces
<?php
namespace Sabel\Scrap\Loader;
class Autoloader
{
private $_fileExtension = '.php';
private $_namespace;
private $_includePath;
private $_namespaceSeparator = '\\';
@chukShirley
chukShirley / Product.php
Created April 21, 2014 14:21
Calculation best practice
class Product
{
protected $unitPrice;
protected $discount;
protected $finalPrice;
public function __construct($unitPrice, $discount)
{
$this->setUnitPrice($unitPrice);
$this->setDiscount($discount);
@chukShirley
chukShirley / inline.js
Last active August 29, 2015 14:02
jQuery manually hydrate form
$.ajax({
url:'script.php',
dataType:'json',
type:'GET',
}).done(function(response){
$('#name').val(response.name);
$('#address').val(response.address);
$('#city').val(response.city);
$('#state').val(response.state);
//...and so on...
@chukShirley
chukShirley / database.local.php
Created August 15, 2014 20:50
ZF2 DB configuration for IBM DB2
return array(
'db' => array(
'driver' => 'IbmDb2',
'platform' => 'IbmDb2',
'platform_options' => array('quote_identifiers' => false),
'database' => '', // IBM i serial number or db directory entry name goes here
'username' => '', // user id goes here
'password' => '', // password goes here
'driver_options' => array(
'i5_naming' => DB2_I5_NAMING_ON,
@chukShirley
chukShirley / gist:24c3c3086690f1a47cfe
Last active August 29, 2015 14:05 — forked from kingharrison/gist:a799f85bd0b5bcb07267
'service_manager' => array (
'invokables' => array (
'AuthorizationIbmi' => 'authorization.php',
),
'factories' => array(
'dbadapter' => function($sm) {
// DB adapter config
},
'tkconn' => function ($sm) {
$dbAdapter = $sm->get('dbadapter');
@chukShirley
chukShirley / gist:f67f1b56f78036ee08cf
Created October 8, 2014 13:11
Using PHP Toolkit for IBM i to call CL program
// Instantiate toolkit object
try{
$ToolkitServiceObj = ToolkitService::getInstance($db, $namingMode);
}
catch (Exception $e) {
echo $e->getMessage(), "\n";
exit();
}
$ToolkitServiceObj->setToolkitServiceParams(array('InternalKey'=>"/tmp/$user",
@chukShirley
chukShirley / delete.html
Last active August 29, 2015 14:07
AJAX delete supplier
<html>
<body>
<!-- Can be any kind of input as long as id is "supplierId" -->
<input type="hidden" id="supplierId">
<button class="btn btn-default" id="supplier_deleteButton">Delete Supplier</button>
</body>
</html>
@chukShirley
chukShirley / index.html
Last active August 29, 2015 14:07
Submit HTML Bootstrap form via AJAX
<div class="row">
<div class="col-xs-12">
<form class="form-horizontal" role="form" id="myForm">
<div class="alert alert-danger hidden" id="formError"></div>
<div class="form-group" id="fieldContainer">
<label for="field" class="col-sm-2 control-label">My Field</label>
<div class="col-sm-3">
<input class="form-control" id="myField" name="myField" type="text" />
@chukShirley
chukShirley / index.html
Last active August 29, 2015 14:08
Append params to form before submit
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
</head>
<body>
<form name="real" id="real" method="POST" action="submit.php">
<input type="submit" value="submit real form">
</form>