<?php

$db = new myDb();


class myDb {

	var $con;
	var $db;


	function MyDb(){

			$this->con = mysql_connect("dbserver", "dbuser", "dbpass")
				or die ("Could not connect<BR>");
			//print ("Connected successfully<BR>");
			$this->db = "dbname";


		mysql_select_db($this->db)
			or die ("Could not select database<BR>");
	}

	function query($sql){
		return new dbResult(mysql_query($sql));
	}

	function listFields($tableName){
		return new dbResult(mysql_list_fields($this->db,$tableName,$this->con));
	}

	function errStr(){
		return mysql_error();
	}

	function firstRow($sql){

		if ($rh = $this->query($sql)){
			if ($temp = $rh->fetchHash()){
				return $temp;
			}
		}
		return "";

	}

	function firstOfFirst ($sql){

		if ($rh = $this->query($sql)){
			if ($temp = $rh->fetchArray()){
				return $temp[0];
			}
		}
		return "";
	}

	function columnArray($sql){

		$ret = Array();
		$result = $this->query($sql);
		while ($item = $result->fetchArray()){
			array_push($ret,$item[0]);
		}
		return $ret;

	}

	function lastID (){
		return mysql_insert_id($this->con);
	}

/*--------------------------------------
----mysql functions quick ref.


	resource mysql_query($queryString)
	resource mysql_list_fields($dbName, $tableName, $con)
	array mysql_fetch_row($res)
	array mysql_fetch_assoc($res)
	object mysql_fetch_field($res)
	int mysql_num_fields($res)
	string mysql_field_name($res,$fieldNum)
	string mysql_field_type($res,$fieldNum)
*/
}

class dbResult {

	var $res;

	function dbResult ($res){
		$this->res = $res;
	}

	function fetchArray(){
		//returns array
		return mysql_fetch_row($this->res);
	}
	function fetchHash(){
		//returns associative array
		return mysql_fetch_assoc($this->res);
	}
	function fetchField(){
		//returns unwrapped field object
		//but see the meta class.
		return mysql_fetch_field($this->res);
	}
	function numFields(){
		//returns int
		return mysql_num_fields($this->res);
	}
	function fieldName($fieldNum){
		//returns string
		return mysql_field_name($this->res,$fieldNum);
	}
	function fieldType($fieldNum){
		//returns string type (int, real,etc)
		return mysql_field_type($this->res,$fieldNum);
	}


}


//how to extract data from form?
function tableFromForm($tableName){
	global $db;
	$meta = new metaData($tableName);
	$fields = $meta->fieldList();
	foreach ($fields as $field){
		$ret[$field] = $GLOBALS[$field];
	}
	return $ret;

}

function dbForm($result){

	//could be called with info from a database
	//or just a table name (for an empty form)


	//if $result is a table name, get a table info list
	if (is_string($result)){

		global $db;
		$result = $db->listFields($result);
		$data = array();
	}
	else {
		$data = $result->fetchArray();
	}

	$columns = $result->numFields();
	for ($i = 0; $i < $columns; $i++) {
		$name = $result->fieldName($i);
		if (preg_match("/ID$/",$name)){
			print '<INPUT TYPE="hidden" NAME="' . $name . '" VALUE="' . $data[$i] . '">' . "\n\n\n";
		}
		else {
			print $name . ':<BR><INPUT TYPE="TEXT" NAME="' . $name . '" VALUE="' . $data[$i] . '"><BR><BR>' . "\n\n\n";
		}
	}

}

function makeOptions($sql,$valueField,$displayField,$selectedValue){

	$db = new myDb();
	$rs = $db->query($sql);
	while ($row = $rs->fetchHash()){
		$ret .= '<OPTION VALUE="' . $row[$valueField] . '"';
		if ($row[$valueField] == $selectedValue){
			$ret .= " SELECTED";
		}
		$ret .= '>';
		$ret .= $row[$displayField] . "\n";
	}

	return $ret;


}

class metaData {

	var $info;

	function metaData ($table){
		global $db;
		$result = $db->listFields($table);
		while ($field = $result->fetchField()){
			$this->info[$field->name] = array("type" => $field->type);
		}
	}

	function isQuoted($fieldName){
		if (($this->info[$fieldName]["type"] == "int")
			||($this->info[$fieldName]["type"] == "real")
			){
			return false;
		}
		return true;
	}

	function type($field){

		return $this->info[$field]["type"];

	}

	function fieldList(){
		return array_keys($this->info);
	}

}

function inserter ($table,$fieldNames,$data){

	$queryType = "insert";

	global $db;
	global $inserterPrintOnly;
	$meta = new metaData($table);

	if ($fieldNames){
		foreach ($fieldNames as $fieldName){
			if ($data[$fieldName]){
				if ($meta->isQuoted($fieldName)){
					$wheres[] = $fieldName . " = '" . $data[$fieldName] . "'";
				}
				else {
					$wheres[] = $fieldName . " = " . $data[$fieldName];
				}
			}
			else {
				//can't be an update unless all keys
				//have values.
				$wheres = array();
				break;
			}
		}
		if ($wheres){
			$where = " where " . join(" and ",$wheres);
			$sql = "select * from $table" . $where;
			//print "$sql <BR>";
			$result = $db->query($sql);
			if ($sth = $result->fetchHash()){
				$queryType = "update";
			}
		}
	}

	//now we know what type of query it is.

	if ($queryType == "insert"){

		foreach ($data as $fieldName => $value){

			//print "field is $fieldName value is $value<BR>";
			if ($meta->isQuoted($fieldName)){

				//if(($meta->type($fieldName) == "date")&&//(!$value)){
				//	continue;
				//}

				$values[] = "'$value'";
			}
			else {
				//print "not quotable, value is $value<BR>";
				//print "($value == 0) is " . ($value == "0");
				if (($value == "0")||($value)){
					//print "so it got added.<BR>";
					$values[] = $value;
				}
				else {
					//print "so it didnt.<BR>";
					continue;
				}
			}
			$fields[] = $fieldName;

		}

		$sql = "insert into $table (" . join(", ", $fields) . ") values (" . join(", ", $values) . ")";

	}
	else {
		foreach ($data as $fieldName => $value){
			if (isset($data[$fieldName])){
				if ($meta->isQuoted($fieldName)){
					$values[] = "$fieldName = '$value'";
				}
				else {
					if (($value == "0")||$value)
					$values[] = "$fieldName = $value";
				}
			}
		}

		$sql = "update $table set " . join(", ", $values) . $where;

	}

	if ($inserterPrintOnly){
		print $sql;
	}
	else {
		$db->query($sql);
	}
	if ($db->errStr()){
		print $db->errStr();
		print $sql;
	}

}


function verify ($table,$data){


	global $db;
	$meta = new metaData($table);
	$err = "";

	foreach ($data as $fieldName => $value){

		$type = $meta->type($fieldName);


		if ($value){
			//print "value is $value ";
			if ($type == "string"){
				//can be just about anything...
				//print "looks OK for string... ";
			}
			else if ($type == "real"){
				if (is_numeric($value)){
					//print "looks OK for real... ";
				}
				else {
					$err .= "Your entry: $value for the field: $fieldName is not a proper number.<BR>\n";
				}
			}
			else if ($type == "int"){
				//print "it's an int.<BR>";
				//print intval($value) . " ";
				//print $value . "<BR>";
				if ((intval($value) . "") == $value){
					//print "looks OK for int... ";
				}
				else {
					$err .= "Your entry: $value for the field: $fieldName is not an integer.<BR>\n";
				}
			}
			else if ($type == "date"){
				if (preg_match("/^[0-9]{4}-[0-9]{2}-[0-9]{2}$/",$value)){
					//print "looks OK for date... ";
				}
				else {
					$err .= "Your entry: $value for the field: $fieldName is not valid as a date (2002-1-15).<BR>\n";
				}
			}

		}
		else {
			//print "no value so skipping";
		}

	}
	return $err;
}

function mysqlDate($dateString){

	if (!$dateString){
		return "0000-00-00";
	}

	$timeValue = strtotime($dateString);
	return date("Y-m-d",$timeValue);

}

function shortDate($dateString){

	if ($dateString == "0000-00-00"){
		return "";
	}

	$timeValue = strtotime($dateString);
	return date("m/d/Y",$timeValue);

}
function veryShortDate($dateString){

	if ($dateString == "0000-00-00"){
		return "";
	}

	$timeValue = strtotime($dateString);

	$today = getdate();
	$then = getdate($timeValue);
	if ($today["year"] == $then['year']){
		return date("m/d",$timeValue);
	}
	else {
		return date("m/d/Y",$timeValue);
	}

}

?>