[binaryphp-cvs] binaryphp/functions/mysql mysql_connect.cpp,NONE,1.1 mysql_error.cpp,NONE,1.1 mysql_fetch_array.cpp,NONE,1.1 mysql_fetch_row.cpp,NONE,1.1 mysql_query.cpp,NONE,1.1 mysql_select_db.cpp,NONE,1.1

[<da...@us...>]

Update of /cvsroot/binaryphp/binaryphp/functions/mysql
In directory sc8-pr-cvs1:/tmp/cvs-serv23098/mysql

Added Files:
	mysql_connect.cpp mysql_error.cpp mysql_fetch_array.cpp 
	mysql_fetch_row.cpp mysql_query.cpp mysql_select_db.cpp 
Log Message:
Moved files into their proper subdirectories.

--- NEW FILE: mysql_connect.cpp ---
php_var mysql_connect(php_var host = "localhost:3306", php_var user = "", php_var passwd = "")
{
	MYSQL* mysql;
	mysql_init(mysql);
	unsigned int port = 3306;
	if(!mysql_real_connect(mysql, host, user.container.c_str(), passwd.container.c_str(), NULL, port, host_ext[1].container.c_str(), 0))
	{
		//handle errors
	}
	php_var ret;
	ret.res = (void*)mysql;
	ret.type = PHP_RESOURCE;
	global_mysql.res = (void*)mysql;
	global_mysql.type = PHP_RESOURCE;
	return ret;
}

--- NEW FILE: mysql_error.cpp ---
php_var mysql_error(php_var mysql = global_mysql)
{
	php_var ret = mysql_error(mysql);
	return ret;
}

--- NEW FILE: mysql_fetch_array.cpp ---
php_var mysql_fetch_array(php_var result, php_var result_type = MYSQL_BOTH)
{
	php_var ret;
	unsigned int num_fields;
	MYSQL_ROW row;
	MYSQL_FIELD* fields;
	if(row = mysql_fetch_row((MYSQL_RES*)result.res))
	{
		ret = array();
		num_fields = mysql_num_fields((MYSQL_RES*)result.res);
        fields = mysql_fetch_fields((MYSQL_RES*)result.res);
		int i;
		for(i = 0; i < num_fields; ++i)
		{
			if(result_type == MYSQL_NUM || result_type == MYSQL_BOTH)
				ret[i] = row[i];
			if(result_type == MYSQL_ASSOC || result_type == MYSQL_BOTH)
				ret[fields[i].name] = row[i];
		}
		free(fields);
		return ret;
	}
	else
		return((php_var)false);
}

--- NEW FILE: mysql_fetch_row.cpp ---
php_var mysql_fetch_row(php_var result)
{
	php_var ret;
	unsigned int num_fields;
	MYSQL_ROW row;
	if(row = mysql_fetch_row((MYSQL_RES*)result.res))
	{
		ret = array();
		num_fields = mysql_num_fields((MYSQL_RES*)result.res);
		int i;
		for(i = 0; i < num_fields; ++i)
			ret[i] = row[i];
		return ret;
	}
	else
		return((php_var)false);
}

--- NEW FILE: mysql_query.cpp ---
php_var mysql_query(php_var query, php_var mysql = global_mysql)
{
	MYSQL_RES* result = NULL;
	php_var ret;
	if(mysql_real_query((MYSQL*)mysql.res, query.container.c_str(),query.container.length()) != 0)
	{
		return (php_var) false;
	}
	else
	{
		result = mysql_store_result((MYSQL*) (mysql.res));
		if(result)
		{
			ret.type = PHP_RESOURCE;
			ret.res = (void*)result;
			return ret;
		}
		else
		{
			if(mysql_field_count((MYSQL *) mysql.res) == 0)
				return((php_var)true);
			else
				return((php_var)false);
		}
	}
}

--- NEW FILE: mysql_select_db.cpp ---
php_var mysql_select_db(php_var db, php_var mysql = global_mysql)
{
	if(mysql_select_db((MYSQL*)mysql.res, db.container.c_str()) == 0)
		return true;
	return false;
}