Skip to content
This repository
branch: master
Octocat-spinner-32 includes Added ibm-db2 initial scripts November 13, 2012
Octocat-spinner-32 setup Added ibm-db2 initial scripts November 13, 2012
Octocat-spinner-32 tmp Initial commit January 13, 2012
Octocat-spinner-32 .gitignore sqlite workings January 17, 2012
Octocat-spinner-32 README.md Updated README.md February 13, 2012
Octocat-spinner-32 bootstrap.dist.php Updated bootstrap February 25, 2012
Octocat-spinner-32 example-01.php Oracle additions September 25, 2012
Octocat-spinner-32 example-02.php Oracle additions September 25, 2012
Octocat-spinner-32 example-03.php Updated February 08, 2012
Octocat-spinner-32 example-04.php Updated February 08, 2012
Octocat-spinner-32 example-05.php Initial commit January 13, 2012
Octocat-spinner-32 example-06.php Fixed remaining examples to work with new dataset. April 12, 2012
Octocat-spinner-32 example-07.php Added postgres support and changes to examples August 07, 2012
Octocat-spinner-32 example-08.php Examples for insert(), update(), & delete() for TableGateway updated. February 03, 2012
Octocat-spinner-32 example-09.php Examples for insert(), update(), & delete() for TableGateway updated. February 03, 2012
Octocat-spinner-32 example-10.php Added postgres support and changes to examples August 07, 2012
Octocat-spinner-32 example-11.php Quick example of configuration through Di February 25, 2012
Octocat-spinner-32 example-12.php Added postgres support and changes to examples August 07, 2012
Octocat-spinner-32 example-13.php Script cleanup April 03, 2012
Octocat-spinner-32 example-14.php Fixed remaining examples to work with new dataset. April 12, 2012
Octocat-spinner-32 example-15.php Added postgres support and changes to examples August 07, 2012
Octocat-spinner-32 example-16.php Updated example, new double iteration (buffering) example August 27, 2012
Octocat-spinner-32 example-17.php Updated 17 and 16 May 21, 2012
Octocat-spinner-32 example-18.php Added postgres support and changes to examples August 07, 2012
Octocat-spinner-32 example-19.php Added whiteboard script, also added some subselect scripts August 07, 2012
Octocat-spinner-32 example-20.php Added whiteboard script, also added some subselect scripts August 07, 2012
Octocat-spinner-32 example-21.php Updated example, new double iteration (buffering) example August 27, 2012
Octocat-spinner-32 example-22.php Example 22 updated October 02, 2012
Octocat-spinner-32 whiteboard.php Added ibm-db2 initial scripts November 13, 2012
README.md

README

Introduction

This repository show's off Zend\Db's feature-set via a simple schema and simple tasks. The schema's are located in setup/vendor and are tailored to setup a scheme in a vendor specific way. So, the first thing you'll need to do is run the setup scripts. If you decide you want to run them against something other than Sqlite, first copy the bootstrap and setup the proper credentials.

Setup:

First, you'll need to

setup/up.php

If you want to run against something other than Sqlite, copy the bootstrap, then fill out the credentials in the appropriate section:

cp bootstrap.dist.php bootstrap.php
< < edit bootstrap.php > >

To destroy a schema

setup/down.php

Examples:

1 - 4. (working) SELECT, INSERT, UPDATE, DELETE through adapter using array based parameritized query. These scripts are utilizing the Adapter and Platform API's to produce vendor agnostic queries.

php example-01.php
php example-02.php
php example-03.php
php example-04.php

5. Demonstrate adapter exception handling (not working.)

n/a

6 - 9. TableGateway examples showing basic select(), insert(), update(), and delete().

php example-06.php
php example-07.php
php example-08.php
php example-09.php

Unpacking the Phar:

Currently, this master repository is using an up to date phar of just Zend_Db. To extract these files for usage, use the phar.phar utility:

phar.phar extract -f Zend_Db-2.0.0dev.phar

Linking to your checked out code:

cp bootstrap.dist.php bootstrap.php

edit bootstrap with:

// include 'Zend_Db-2.0.0dev.phar';
require_once '/path/to/ZF2/library/Zend/Loader/StandardAutoloader.php';
$autoloader = new Autoloader;
$autoloader->register();
Something went wrong with that request. Please try again.