private static PhpResource Open(string filename, int mode, PhpReference error, bool persistent)
{
if (persistent)
{
PhpException.FunctionNotSupported(PhpError.Notice);
}
SQLiteConnectionStringBuilder csb = new SQLiteConnectionStringBuilder();
csb.DataSource = filename;
csb.Version = 3;
try
{
PhpSQLiteDbConnection connection = new PhpSQLiteDbConnection(csb.ConnectionString);
if (error != null)
{
error.Value = null;
}
return(connection);
}
catch (Exception ex)
{
if (error != null)
{
error.Value = ex.Message;
}
return(null);
}
}
private static PhpResource Open(string filename, int mode, PhpReference error, bool persistent)
{
if (persistent) PhpException.FunctionNotSupported(PhpError.Notice);
SQLiteConnectionStringBuilder csb = new SQLiteConnectionStringBuilder();
csb.DataSource = filename;
csb.Version = 3;
try
{
PhpSQLiteDbConnection connection = new PhpSQLiteDbConnection(csb.ConnectionString);
if (error != null)
{
error.Value = null;
}
return connection;
}
catch (Exception ex)
{
if (error != null)
{
error.Value = ex.Message;
}
return null;
}
}
public static void Close(PhpResource linkIdentifier)
{
PhpSQLiteDbConnection connection = PhpSQLiteDbConnection.ValidConnection(linkIdentifier);
if (connection != null)
{
connection.Close();
}
}
public static void CreateFunction(PhpResource dbhandle, string function_name, object callback, int num_args)
{
PhpSQLiteDbConnection connection = PhpSQLiteDbConnection.ValidConnection(dbhandle);
PhpCallback cb = PHP.Core.Convert.ObjectToCallback(callback);
int paramCount = cb.TargetRoutine.PhpFunction.ArgFullInfo.GetParameters().Length;
Delegate d = null;
connection.Connection.RegisterFunction(function_name, paramCount, FunctionType.Scalar, d);
//SQLiteFunction.RegisterFunction()
}
public static bool Exec(object arg1, object arg2, PhpReference error_message)
{
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(false);
}
try
{
connection.ExecuteCommand(query, System.Data.CommandType.Text, true, null, true);
if (error_message != null)
{
error_message.Value = null;
}
return(true);
}
catch (Exception ex)
{
if (error_message != null)
{
error_message.Value = ex.Message;
}
return(false);
}
}
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);
}
}
