jQuery('#ppvList').jqGrid({
        url: '/tv_schedules/get_ppv_list',
        mtype: 'POST',
        datatype: 'json',
	    // This determines the order of columns.  It MUST match the colModel
		postData: {colOrder: 'title,genre,rating,price'},        
		colModel: [
					{label: 'Title', name: 'title', index: 'title', sortable:true}, 
					{label: 'Genre', name: 'genre', index: 'genre', sortable:true , width: '50'}, 
					{label: 'Rating', name: 'rating',index: 'rating', sortable:true , width: '50'}, 
					{label: 'Price', name: 'price', index: 'price', sortable:true, width: '25', align: 'right'}
				],
        pager: jQuery('#pager'),
        rowNum: 10,
        rowList: [10, 20, 30],
        sortname: 'title',
        sortorder: 'asc',
        viewrecords: true,
		autowidth: true,
		height: 'auto'
 
    });

class DataPrepComponent extends Object
{
 
	/*
	 * This method converts an array in the following format to an object that can be
	 * JSON encoded and passed to jqGrid
	 * 
	 *  Array
		(
		    [0] => Array
		        (
		            [ModelName] => Array
		                (
		                    [id] => 83
		                    [field1] => value1
		                    [field2] => value2
		                    [field3] => value3
		                    [field4] => value4
		                    [field5] => value5
		                )
		    [1] => Array
		        (
		            [ModelName] => Array
		                (
		                    [id] => 84
		                    [field1] => value1
		                    [field2] => value2
		                    [field3] => value3
		                    [field4] => value4
		                    [field5] => value5
		                )
 
 
		)
 
		This array will be converted to the following for jQgrid.
 
		object(stdClass)
		  public 'total' => int
		  public 'page' => int
		  public 'records' => int
		  public 'rows' => 
		    array
		      0 => 
		        object(stdClass)[20]
		          public 'id' => string
		          public 'cell' => 
		            array
		              0 => string 
		              1 => string 
		              2 => string 
		              3 => string 
		              4 => string 
		      1 => 
		        object(stdClass)
		          public 'id' => string 
		          public 'cell' => 
		            array
		              0 => string 
		              1 => string 
		              2 => string 
		              3 => string 
		              4 => string 
 
 
	 */
	public function prep_jqgrid(Array $data, StdClass $pager, Array $col_order)
	{
		//$this->log($data, LOG_DEBUG);
		/*
			THESE ARE THE PARAMETERS SENT BY JQGRID FOR THE PAGER
 
			total	total pages for the query
			page	current page of the query
			records	total number of records for the query
			rows	an array that contains the actual data
				id	the unique id of the row
				cell	an array that contains the data for a row
		*/
		$jqgrid_data = new StdClass();		
		$jqgrid_data->total = $pager->total;
		$jqgrid_data->page = $pager->page;
		$jqgrid_data->records = $pager->records;
		$jqgrid_data->rows = array();
 
		foreach($data as $model)
		{
			$row = new stdClass();
			foreach($model as $model_name => $db_row)
			{
				$row->id = $db_row['id'];
				unset($db_row['id']);
				foreach($col_order as $col)
				{
					$row->cell[] = $db_row[$col];
				}
			}
			$jqgrid_data->rows[] = $row;
		}
		return $jqgrid_data;
	}
}

	function get_ppv_list()
	{
       //	Configure::write('debug', 0);
	    $this->pageTitle = 'Order PPV/VOD';
		$this->loadModel('TvSchedule');
 
		$order = 'TvSchedule.title DESC';
        if (isset($this->params['form']['sidx']))
        {
            $order = 'TvSchedule.' . strtolower($this->params['form']['sidx']) . ' ' . $this->params['form']['sord'];
        }
 
        $params = array (
        //'conditions'=> array ('Model.field'=>$thisValue), //array of conditions
        //'recursive'=>1, //int
        'fields'=> array ('TvSchedule.id', 'TvSchedule.title', 'TvSchedule.genre', 'TvSchedule.rating', 'TvSchedule.price'), //array of field names
        'order'=> array ($order), //string or array defining order
        //'group'=> array ('Model.field'), //fields to GROUP BY
        'limit'=> $this->params['form']['rows'], //int
        'page'=> $this->params['form']['page'] //int
        //'callbacks'=>true //other possible values are false, 'before', 'after'
        );
 
		$record_total = $this->TvSchedule->find('count');
 
		$pager->total = ceil($record_total/$this->params['form']['rows']);
		$pager->page = $this->params['form']['page'];
		$pager->records = $record_total;
 
		$this->set('PPVdata', json_encode($this->DataPrep->prep_jqgrid($this->TvSchedule->find('all', $params), $pager, split(',', $this->params['form']['colOrder']))));
		$this->render('ppv_list', 'ajax');
	}

# gzip -d openssl.tar.gz
# tar -xvf openssl.tar
# cd openssl
# ./configure -fPIC os/compiler:gcc
# make
# make test
# make install

# ./configure --enable-ssl=shared --with-ssl=/usr/local/ssl/ --enable-rewrite=shared --enable-setenvif --enable-so
# make
# make install

# openssl genrsa -out hostname.key 1024
# openssl req -new -key hostname.key -out hostname.csr
# openssl x509 -req -days 365 -in hostname.csr -signkey hostname.key -out hostname.crt

Include conf/extra/httpd-ssl.conf

SSLCertificateFile "/usr/local/apache2/conf/certs/hostname.crt"
SSLCertificateKeyFile "/usr/local/apache2/conf/certs/hostname.key"

# apachectl -k restart

# apachectl -k stop

#  ./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql --with-curl --enable-soap --with-openssl=/usr/local/ssl
# make
# make test
# make install

# whereis openssl

# cp php.ini-dist /usr/local/lib/php.ini

          SetHandler application/x-httpd-php

LoadModule ssl_module modules/mod_ssl.so
LoadModule rewrite_module modules/mod_rewrite.so
LoadModule php5_module        modules/libphp5.so

define('SOAP_URL', 'https:<URL>?wsdl');
define('SOAP_ORGNAME', 'ORG1002');
define('SOAP_API_VERSION', '3.2');
define('SOAP_WAIT', '0');
define('SSL_CERT_PATH', '/usr/local/apache2/certs/triad.pem');

 
        try
        {
            $this->client = new SoapClient(
	            SOAP_URL,
		            array (
		            "trace"=>true
		            , "exceptions"=>true
		            , 'features'=>SOAP_SINGLE_ELEMENT_ARRAYS
					, 'local_cert' => SSL_CERT_PATH
		            )
            );
        }
        catch(SoapFault $f)
        {
            throw new Exception($f->getMessage());
        }

#wget

#gzip -d  
#tar xvf

#./configure ./configure --enable-so
#make
#make install

#/usr/local/apache2/bin/apachectl -k [start | stop]

#./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql --with-curl --enable-soap
#make
#make install

#cp php.ini-dist /usr/local/lib/php.ini

    SetHandler application/x-httpd-php

#/usr/local/apache2/bin/apxs -i -a -c mod_rewrite.c

function __load_class($classname, $dir)
{
	$file = $dir . '/' . $classname . '.php';
	if (file_exists($file))
	{
		require_once ($file);
		return true;
	}
	return false;
}
 
function __autoload($classname)
{
	$inc[] = '../fwork';
	$inc[] = '../fwork/controllers';
	$inc[] = '../fwork/models';
	$inc[] = '../app';
	$inc[] = '../app/controllers';
	$inc[] = '../app/models';
 
	foreach ($inc as $dir)
	{
		if (__load_class($classname, $dir))
		{
			if(DEBUG_LEVEL == 2)
			{
				echo 'Loading class(' . $classname . ")<br>";
			}
			return;
		}
	}
}

RewriteEngine on
RewriteCond %{REQUEST_URI} !\.(php|css|js|gif|png|jpe?g)$
RewriteRule (.*)$ /index.php [L]

$request_uri = explode('/', $_SERVER['REQUEST_URI']);
$controller = htmlentities($request_uri[1]);
$action = htmlentities($request_uri[2]);
if($action == '') {$action = 'index'; }
$param = htmlentities($request_uri[3]);
if($param == '') {$param = ''; }

http://recipemanager/ingredient_type/update/5

<?php
error_reporting(E_ALL|E_STRICT);
ini_set('display_errors', 1);
date_default_timezone_set('Europe/London');
 
include('../helpers/print_var.php');
include('../helpers/MyIterator.php');
 
 
// directory setup and class loading
set_include_path('.' . PATH_SEPARATOR . '../library/'
. PATH_SEPARATOR . '../application/models'
. PATH_SEPARATOR . get_include_path());
 
include "Zend/Loader.php";
Zend_Loader::registerAutoload();
 
// load configuration
$config = new Zend_Config_Ini('../application/config.ini', 'general');
$registry = Zend_Registry::getInstance();
$registry->set('config', $config);
 
// setup database
$db = Zend_Db::factory($config->db);
Zend_Db_Table::setDefaultAdapter($db);
 
// setup controller
$frontController = Zend_Controller_Front::getInstance();
$frontController->throwExceptions(true);
$frontController->setControllerDirectory('../application/controllers');
 
Zend_Layout::startMvc(array('layoutPath'=>'../application/layouts'));
 
// run!
$frontController->dispatch();

C:\Program Files\Apache Software Foundation\Apache2.2\conf\httpd.conf

# Virtual hosts
#Include conf/extra/httpd-vhosts.conf

# Virtual hosts
Include conf/extra/httpd-vhosts.conf

c:\WINDOWS\system32\drivers\etc\hosts

127.0.0.1       localhost

C:\Program Files\Apache Software Foundation\Apache2.2\conf\extra\httpd-vhosts.conf

<Directory c:/vhosts>
Options Indexes FollowSymLinks
AllowOverride All
Order Deny,Allow
Allow from all
</Directory>

<VirtualHost *:80>
DocumentRoot c:/htdocs
ServerName localhost
</VirtualHost>

<VirtualHost *:80>
DocumentRoot c:/vhosts/recipemanager/site
ServerName recipemanager
</VirtualHost>

<?php
 
	include('config.php');
	$employees = array();
	$assigned_employees = array();
 
 
	$query = "select * from employees";
	$result = mysql_query($query) or die('Query failed: ' . mysql_error());
	while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) 
	{
		$employees[$line['id']] = $line['first_name'];
	}	
 
	$query = "select * from assigned_employees";
	$result = mysql_query($query) or die('Query failed: ' . mysql_error());
	while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) 
	{
		$assigned_employees[$line['id']] = $line['first_name'];
	}
 
?>
 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
                    "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
	<script src="../javascript/jquery-latest.js"></script>
 	<link rel="stylesheet" href="../javascript/jquery.autocomplete.css" type="text/css" />
	<script type="text/javascript" src="../javascript/jquery.autocomplete.js"></script>
	<script>
		$(document).ready(function()
		{
			// var data = "Core Selectors Attributes Traversing Manipulation CSS Events Effects Ajax Utilities".split(" ");
			$("#first_name").autocomplete('autocomplete.php');
 
			$("#first_name").result(function() 
			{
				console.log(arguments);
			}
			);
		}
		);
  </script>
 
</head>
<body>
	<form action="insert.php" method="post">
		Assigned an employee: <input id="first_name" name="first_name" />
		<input type="submit" value="Submit" />
	</form>
 
	<h3>Employees</h3>
<?php
	foreach($employees as $employee)
	{
		echo "$employee <br>";
	}
?>	
 
<h3>Assigned Employees</h3>
<?php
	foreach($assigned_employees as $employee)
	{
		echo "$employee <br>";
	}
?>
 
<div>--------------------------------------------</div>
<a href="clear.php">Remove all assignments</a>
 
</body>
</html>

<?php
include('config.php');
 
$q = $_GET['q'];
 
// Performing SQL query
$query = "SELECT id, first_name FROM employees";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
 
 
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) 
{
	if (substr($line['first_name'], 0, strlen($q)) == $q) 
	{
		echo $line['first_name'] .'|'. $line['id'] . "\n";
	}
}
 
?>

<?php
include('config.php');
 
//get the first_name from the form
$first_name = $_POST['first_name'];
 
// see if we have it in the database. If so then grab the ID
$query = "SELECT id FROM employees WHERE first_name = '$first_name'";
 
//print "$query<br>";
 
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
 
if(!$row = mysql_fetch_assoc($result))
{
	// If not then insert it into the employees  table. Then get the ID of the new employee from the employees table.
	$query = "INSERT INTO employees(first_name) VALUES('$first_name')";
	//print "$query<br>";
	$result = mysql_query($query) or die('Query failed: ' . mysql_error());
 
	$id = mysql_insert_id();
}
else
{
	$id = $row['id'];
}
 
// Now insert into the ingredient list table.
 
$query = "INSERT INTO assigned_employees(id, first_name) VALUES($id, '$first_name')";
//print "$query<br>";
 
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
 
header( 'Location: http://localhost/lab/autocomplete/index.php' ) ;
 
?>

<?php
include('config.php');
 
$query = "delete FROM assigned_employees";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
header( 'Location: http://localhost/lab/autocomplete/index.php' );
?>

CREATE DATABASE /*!32312 IF NOT EXISTS*/`test` /*!40100 DEFAULT CHARACTER SET latin1 */;
 
USE `test`;
 
/*Table structure for table `assigned_employees` */
 
DROP TABLE IF EXISTS `assigned_employees`;
 
CREATE TABLE `assigned_employees` (
  `id` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `first_name` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
 
/*Data for the table `assigned_employees` */
 
INSERT  INTO `assigned_employees`(`id`,`first_name`) VALUES (0000000002,'sam');
 
/*Table structure for table `employees` */
 
DROP TABLE IF EXISTS `employees`;
 
CREATE TABLE `employees` (
  `id` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `first_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
 
/*Data for the table `employees` */
 
INSERT  INTO `employees`(`id`,`first_name`) VALUES (0000000001,'steve'),(0000000002,'sam'),(0000000003,'heather'),(0000000004,'heath'),(0000000005,'shamus'),(0000000006,'jennifer'),(0000000007,'geronimo'),(0000000008,'gerald');
 
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

$('#add_ingredient_row').click(function()
{
	// Clone the last row of the table.
	var clonedRow = $("#ingredient_list tr:last").clone();
 
	// Generate an incremented index for the new row. -1 because there is a table header row
	var newIndex = (document.getElementById('ingredient_list').rows.length -1);
 
	// Set the ID of the row with the new index
	clonedRow[0].id = 'ingredient_' + newIndex;
 
 
	//console.log('ingredient_' + newIndex);
	// Loop through all of the inputs and select in the cloned row
	// Find the name and ID of the input/select element and find the number in it abd replace it with the
	// new index.
	$.each($('input, select', clonedRow), function(i, val)
	{
		//console.log(val);
 
		//console.log('Index -1: ' + (newIndex -1) + '. Index: ' + newIndex);
		val.name = val.name.replace((newIndex - 1), newIndex);
		val.id = val.id.replace((newIndex - 1), newIndex);
		val.value = '';
 
	});
	// put the row into the table
	$("#ingredient_list").append(clonedRow); 
}
);

<table id="ingredient_list">
<tr>
	<th>Amount</th>
 
	<th>Measurement Type</th>
	<th>Description</th>
	<th>Ingredient</th>
</tr>
	<tr id="ingredient_0">
		<td>
			<div class="input text"><input name="data[IngredientList][0][amount]" type="text" maxlength="5" value="" id="IngredientList0Amount" /></div><input type="hidden" name="data[IngredientList][0][id]" value="" id="IngredientList0Id" />		</td>
 
		<td>
			<select name="data[IngredientList][0][measurement_type_id]" id="IngredientList0MeasurementTypeId">
				<option value=""></option>
				<option value="0000000002">cup</option>
				<option value="0000000005">fluid ounce</option>
				<option value="0000000001">ounce</option>
				<option value="0000000004">tablespoon</option>
				<option value="0000000003">teaspoon</option>
			</select>		
		</td>
 
		<td>
			<div class="input text"><input name="data[IngredientList][0][description]" type="text" maxlength="255" value="" id="IngredientList0Description" /></div>		</td>
		<td>
			<select name="data[IngredientList][0][ingredient_id]" id="IngredientList0IngredientId">
				<option value=""></option>
				<option value="0000000006">broccoli</option>
				<option value="0000000008">garlic</option>
				<option value="0000000009">olive oil</option>
				<option value="0000000010">peanut oil</option>
 
				<option value="0000000012">red onion</option>
				<option value="0000000007">white onion</option>
				<option value="0000000011">yellow onion</option>
			</select>		
		</td>
	</tr>
</table>

 
$(document).ready(function()
{
	$('#add_recipe_row').click(function()
	{
		add_row('recipes_table', 'menu_item_');
	}); 
 
	$('#add_ingredient_row').click(function()
	{
		add_row('ingredient_list', 'ingredient_');
	}
	);
 
}); // ends document.ready
 
 
function add_row(tableID, rowIDprefix)
{
 
	// Clone the last row of the table.
	var clonedRow = $('#'+ tableID + ' tr:last').clone();
 
	// Generate an incremented index for the new row. -1 because there is a table header row
	var newIndex = (document.getElementById(tableID).rows.length -1);
 
	// Set the ID of the row with the new index
	clonedRow[0].id = rowIDprefix + newIndex;
 
 
	//console.log('ingredient_' + newIndex);
	// Loop through all of the inputs and select in the cloned row
	// Find the name and ID of the input/select element and find the number in it abd replace it with the
	// new index.
	$.each($('input, select', clonedRow), function(i, val)
	{
		//console.log(val);
 
		//console.log('Index -1: ' + (newIndex -1) + '. Index: ' + newIndex);
		val.name = val.name.replace((newIndex - 1), newIndex);
		val.id = val.id.replace((newIndex - 1), newIndex);
		val.value = '';
 
	});
	// put the row into the table
	$('#' + tableID).append(clonedRow);
}