DB_Sqlite_Tools
[ class tree: DB_Sqlite_Tools ] [ index: DB_Sqlite_Tools ] [ all elements ]
Packages:
DB_Sqlite_Tools


Classes:
DB_Sqlite_Tools
DB_Sqlite_Tools_ArcFour
DB_Sqlite_Tools_DBC
DB_Sqlite_Tools_LogObject
DB_Sqlite_Tools_XMLParser
Files:
ArcFour.php
DBC.php
generate_package_xml.php
Tools.php
XMLParser.php

Class: DB_Sqlite_Tools_DBC

Source Location: /DB_Sqlite_Tools-0.1.7/DB/Sqlite/Tools/DBC.php

Class Overview




This class, part of DB_Sqlite_Tools allows to insert on an sqlite database




Author(s):






                
          
      

Version:


    
  
  • Release: 0.1.7
    • 




Copyright:


    
  
  • Copyright (c) 2004-2006 David Costa
    • 







Variables






Methods
















Inherited Variables





Inherited Methods














Class Details



[line 85]

This class, part of DB_Sqlite_Tools allows to insert on an sqlite database
securely encrypted data and retrieve and decript on the fly the encrypted  data. Since Sqlite might be seen as voulnerable, encrypted database will  ensure the data integrity. It doesn't require PHP to be compiled with MCrypt  but it uses Crypt_ArcFour, embedded (ported to PHP 5 the original PEAR  package).









[ Top ]







Class Variables



	
	

	
$debug =  false

	
[line 108]

  Whether turn on debug mode or not.


    

  • Access: public
    • 





  

	

  

    

      Type:  
      bool
    

      

	



	
[ Top ]


	
	

	
$key = 

	
[line 122]

  An encryption key.


    

  • Access: public
    • 





  

	

  

    

      Type:  
      string
    

      

	



	
[ Top ]


	
	

	
$matrix = 

	
[line 115]

  ArcFour crypt object.


    

  • Access: public
    • 





  

	

  

    

      Type:  
      object
    

      

	



	
[ Top ]


	
	

	
$result = 

	
[line 101]

  The results object.


    

  • Access: public
    • 





  

	

  

    

      Type:  
      object
    

      

	



	
[ Top ]










Method Detail



	
	
__construct (Constructor)   [line 148]

	

    

    

		DB_Sqlite_Tools_DBC __construct(
)
    

    


	
		Constructor.


    

  • Access: public
    • 








        
[ Top ]

  

  
  
	
	
__destruct (Destructor)   [line 502]

	

    

    

		void __destruct(
)
    

    


	
		Destructor.


    

  • Access: public
    • 








        
[ Top ]

  

  
  
	
	
liteAll   [line 414]

	

    

    

		object Result liteAll(
string
$sql, [string
$crypt = true])
    

    


	
		Executes the query and return the decrypted results ALL the objects  in an array.








        
Parameters:

    

    

          

        string  
        $sql  
        — 
        SQL to execute.
      

          

        string  
        $crypt  
        — 
        Default true, decrypts the result.
      

        

    


        
[ Top ]

  

  
  
	
	
liteautoExec   [line 170]

	

    

    

		mixed liteautoExec(
[string
$tableName = null], [string
$tableFields = null], [
$dataValues = null], [
$queryType = self::DB_AUTOQUERY_INSERT], [string
$crypt = true], [string
$whereString = null], string
$tableValues, string
$querytype)
    

    


	
		Auto Execute an insert or update query.


    

  • Throws: PEAR_Exception
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        string  
        $tableName  
        — 
        DB table name
      

          

        string  
        $tableFields  
        — 
        DB fields name
      

          

        string  
        $tableValues  
        — 
        DB table value
      

          

        string  
        $querytype  
        — 
        Type of query, insert by default
      

          

        string  
        $crypt  
        — 
        Crypt with ArcFour before inserting the data, default true
      

          

        string  
        $whereString  
        — 
        Necessary for UPDATE, default null
      

          

          
        $dataValues  
        — 
        
      

          

          
        $queryType  
        — 
        
      

        

    


        
[ Top ]

  

  
  
	
	
liteAutoFetch   [line 369]

	

    

    

		object Result liteAutoFetch(
string
$sql, [string
$crypt = true])
    

    


	
		Executes the query and return the decrypted results single object  if available.








        
Parameters:

    

    

          

        string  
        $sql  
        — 
        SQL to execute.
      

          

        string  
        $crypt  
        — 
        Default true, decrypts the result.
      

        

    


        
[ Top ]

  

  
  
	
	
liteConnect   [line 312]

	

    

    

		bool liteConnect(
string
$db)
    

    


	
		Connects to the Sqlite DB.


    

  • Return: TRUE on succeed.
    • 

  • Throws: PEAR_Exception
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        string  
        $db  
        — 
        The database name.
      

        

    


        
[ Top ]

  

  
  
	
	
liteLastError   [line 457]

	

    

    

		string liteLastError(
[string
$queryString = ''])
    

    


	
		returns the last DB error string.


    

  • Access: public
    • 








        
Parameters:

    

    

          

        string  
        $queryString  
        — 
        The query string.
      

        

    


        
[ Top ]

  

  
  
	
	
liteLastID   [line 471]

	

    

    

		int liteLastID(
)
    

    


	
		Returns the last inserted row id.


    

  • Access: public
    • 








        
[ Top ]

  

  
  
	
	
liteQuery   [line 340]

	

    

    

		true liteQuery(
string
$sql)
    

    


	
		Executes the query and return the results objects if available.


    

  • Access: public
    • 








        
Parameters:

    

    

          

        string  
        $sql  
        — 
        Query to execute.
      

        

    


        
[ Top ]

  

  
  
	
	
safeQuote   [line 287]

	

    

    

		mixed safeQuote(
mixed
$mixedVar)
    

    


	
		Safety value(s) for query execution.


    

  • Return: Result
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        mixed  
        $mixedVar  
        — 
        A string value or an associative array contain                         list of values.
      

        

    


        
[ Top ]

  

  
  



        

		    

		    Documentation generated on Mon, 11 Mar 2019 15:39:04 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright ©  PHP Group 2004.