<?php
/**
*
* Test file for the access "layer"
*
* THIS DOES NOT WORK
*
* We need to specify the database type which should be
* used with odbc, like odbc_mssql, odbc_db2, etc.
* The ways for fetching field names, getting the insert id, etc
* is to different for each type.
*
* @package Yadal
*/
include '../class.Yadal.php';
// the test table (can be any table)
$table = "Customers";
echo "<pre>";
// create a new connection
$db = newYadal("Northwind", "odbc");
$db->connect('ODBCTEST', '', '');
print_var($db->getFieldNames($table));
// start the test secuence
//include( 'test.php' );
/**
* dbFormHandler::setConnectionResource()
*
* Use an already opened connection instead of opening a new one.
*
* @param resource $conn:
* @param string $table: The table which should be used to save the data in
* @param string type: The type of database you are using
* @return void
* @access public
* @author Teye Heimans
*/
function setConnectionResource($conn, $table = null, $type = null)
{
require_once FH_YADAL_DIR . 'class.Yadal.php';
// if no db-type is given, set the default
if (is_null($type)) {
$type = FH_DEFAULT_DB_TYPE;
}
// make this function backwards compatible ( $table, $conn, $type as arguments )
if (is_string($conn) && is_resource($table)) {
$tmp = $table;
unset($table);
$table = $conn;
unset($conn);
$conn = $tmp;
unset($tmp);
}
// save the table name
$this->_table = $table;
// create the yadal object
$this->_db = newYadal(null, $type);
// set the sql resource which we should use
$this->_db->setConnectionResource($conn);
// try to fetch the database data already
if ($this->edit) {
$this->_loadDbData();
}
}
<?php
/**
* Test file for the access "layer"
*
* @package Yadal
*/
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
include '../class.Yadal.php';
// the test table (can be any table)
$table = "Employee";
echo "<pre>";
// create a new connection
$db = newYadal(realpath('.') . "/employees.mdb", "access");
$conn = $db->connect();
// start the test secuence
include 'test.php';
<?php
/**
* Test file for the mssql "layer"
*
* @package Yadal
*/
include '../class.Yadal.php';
// the test table (can be any table)
$table = "orders";
echo "<pre>";
// create a new connection
$db = newYadal("Northwind", "mssql");
$db->connect('TEYELAPTOP', '', '');
// start the test secuence
include 'test.php';
<?php
/**
* Test file for the mysql "layer"
*
* @package Yadal
*/
include '../class.Yadal.php';
// the test table (can be any table)
$table = "criteria";
echo "<pre>";
// create a new connection
$db = newYadal("assessment", "mysql");
$db->connect('localhost', 'root', '');
// start the test secuence
include 'test.php';
<?php
/**
* Test file for the postgreSQL "layer"
*
* @package Yadal
*/
include '../class.Yadal.php';
// the test table (can be any table)
$table = "persoon";
echo "<pre>";
// create a new connection
$db = newYadal('assessment', 'postgresql');
$db->connect('localhost', 'root', 'development');
// start the test secuence
include 'test.php';
