public static PhpArray FetchArray(PhpResource resultHandle, QueryResultKeys resultType)
{
PhpSqlDbResult result = PhpSqlDbResult.ValidResult(resultHandle);
if (result == null)
{
return(null);
}
switch (resultType)
{
case QueryResultKeys.ColumnNames: return(result.FetchArray(false, true));
case QueryResultKeys.Numbers: return(result.FetchArray(true, false));
case QueryResultKeys.Both: return(result.FetchArray(true, true));
}
return(null);
}
public static PhpArray mysql_fetch_array(PhpResource resultHandle, QueryResultKeys resultType = QueryResultKeys.Both)
{
var result = MySqlResultResource.ValidResult(resultHandle);
if (result == null)
{
return(null);
}
switch (resultType)
{
case QueryResultKeys.ColumnNames: return(result.FetchArray(false, true));
case QueryResultKeys.Numbers: return(result.FetchArray(true, false));
case QueryResultKeys.Both: return(result.FetchArray(true, true));
}
return(null);
}
public static PhpResource Query(object arg1, object arg2, QueryResultKeys result_type, PhpReference error_msg)
{
PhpSQLiteDbConnection connection = PhpSQLiteDbConnection.ValidConnection(arg1 as PhpResource);
string query;
if (connection == null)
{
connection = PhpSQLiteDbConnection.ValidConnection(arg2 as PhpResource);
query = PHP.Core.Convert.ObjectToString(arg1);
}
else
{
query = PHP.Core.Convert.ObjectToString(arg2);
}
if (query == null || connection == null)
{
return(null);
}
try
{
var result = connection.ExecuteQuery(query, true);
if (error_msg != null)
{
error_msg.Value = null;
}
return(result);
}
catch (Exception ex)
{
if (error_msg != null)
{
error_msg.Value = ex.Message;
}
return(null);
}
}
public static PhpResource Query(object arg1, object arg2, QueryResultKeys result_type)
{
return(Query(arg1, arg2, result_type, null));
}
public static PhpResource Query(object arg1, object arg2, QueryResultKeys result_type)
{
return Query(arg1, arg2, result_type, null);
}
public static PhpResource Query(object arg1, object arg2, QueryResultKeys result_type, PhpReference error_msg)
{
PhpSQLiteDbConnection connection = PhpSQLiteDbConnection.ValidConnection(arg1 as PhpResource);
string query;
if (connection == null)
{
connection = PhpSQLiteDbConnection.ValidConnection(arg2 as PhpResource);
query = PHP.Core.Convert.ObjectToString(arg1);
}
else
{
query = PHP.Core.Convert.ObjectToString(arg2);
}
if (query == null || connection == null)
return null;
try
{
var result = connection.ExecuteQuery(query, true);
if (error_msg != null)
{
error_msg.Value = null;
}
return result;
}
catch (Exception ex)
{
if (error_msg != null)
{
error_msg.Value = ex.Message;
}
return null;
}
}
public static PhpArray FetchArray(PhpResource resultHandle, QueryResultKeys resultType)
{
PhpSqlDbResult result = PhpSqlDbResult.ValidResult(resultHandle);
if (result == null) return null;
switch (resultType)
{
case QueryResultKeys.ColumnNames: return result.FetchArray(false, true);
case QueryResultKeys.Numbers: return result.FetchArray(true, false);
case QueryResultKeys.Both: return result.FetchArray(true, true);
}
return null;
}
