[PHPVortex-Commit] phpvortex/test .htaccess,NONE,1.1 README.txt,NONE,1.1 vortex_test.php,NONE,1.1 vo

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/phpvortex/phpvortex/test
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19270/test

Added Files:
	.htaccess README.txt vortex_test.php vortex_test.sql 
Log Message:
Added some test files to show some basic functionality

--- NEW FILE: .htaccess ---
php_value include_path ".;.."
php_value auto_prepend_file "d_header.php"
php_value auto_append_file "d_footer.php"
--- NEW FILE: vortex_test.sql ---
CREATE DATABASE IF NOT EXISTS vortex_test;
USE vortex_test;
DROP TABLE IF EXISTS phones;
CREATE TABLE phones (
  ph_id int(3) unsigned NOT NULL auto_increment,
  ph_name varchar(250) NOT NULL default '',
  ph_phone varchar(250) NOT NULL default '',
  PRIMARY KEY  (ph_id)
) TYPE=MyISAM;

--- NEW FILE: vortex_test.php ---
<?php
require_once('../DB_MySQL.class.php');
require_once('../TB_Base.class.php');
require_once('../FT_Text.class.php');
?>
<html>
<head>
<title>Test PHP Vortex Functionality</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?php
class TB_Teste extends TB_Base {
	function TB_Teste(&$db) {
		$this->name = 'phones';
		$this->fields['ph_id'] =& new FT_Text($db, array('name' => 'ph_id', 'pkey' => TRUE, 'required' => TRUE));
		$this->fields['ph_name'] =& new FT_Text($db, array('name' => 'ph_name'));
		$this->fields['ph_phone'] =& new FT_Text($db, array('name' => 'ph_phone'));
		TB_Base::TB_Base($db);
	}
}

$db =& new DB_MySQL(array('server' => 'localhost', 'db' => 'vortex_test', 'user' => 'root', 'pw' => ''));
$db->Connect();
$tb =& new TB_Teste($db);
$id = $tb->Save(array('ph_id' => '-1', 'ph_name' => 'Test', 'ph_phone' => '555-5551')) or print('Error(Save): '.$tb->Error());
echo 'Added ID:'.$id.'<br>';
$tb->Seek(array('ph_name' => 'Test'), FALSE) or print('Error(Seek): '.$tb->Error());
echo 'Seek ID:'.$tb->data['ph_id'].'<br>';
d('Snapshot', $tb);
$tb->Delete() or print('Error(Delete): '.$tb->Error());
echo 'Deleted<br>';
$db->Close();
?>
</body>
</html>
--- NEW FILE: README.txt ---
Instructions for test setup:

 1 - Put PHP Vortex and all subfolders somewhere inside your htdocs folder.
 2 - Execute the vortex_test.sql in your database server (only MySQL supported for now).
     It will create a vortex_test database, and some test tables.
 3 - If your server does't use .htaccess files, configure it to set the PHP include directory to your PHP Vortex folder.
 4 - Change server and username/password to the database server in the test files if you use something more restricting than a 'root'/'' setup.
 5 - Open in your web browser the page test.php and see it working. (Use test.php?debug=3 for some cool debug info)
 6 - If something went wrong, send us a message with the problem and we will try to figure out what happened.

[PHPVortex-Commit] phpvortex/test .htaccess,NONE,1.1 README.txt,NONE,1.1 vortex_test.php,NONE,1.1 vo

[PHPVortex-Commit] phpvortex/test .htaccess,NONE,1.1 README.txt,NONE,1.1 vortex_test.php,NONE,1.1 vortex_test.sql,NONE,1.1