apidoc
[ class tree: apidoc ] [ index: apidoc ] [ all elements ]
Packages:
DB_Sqlite_Tools
Crypt
PEAR


Classes:
DB_Sqlite_Tools
   DB_Sqlite_Tools
   DB_Sqlite_Tools_DBC
   DB_Sqlite_Tools_LogObject
   DB_Sqlite_Tools_XMLParser

Class: DB_Sqlite_Tools_DBC

Source Location: /DB_Sqlite_Tools-0.1.2/Tools/DBC.php

Class Overview


















Variables






Methods
















Inherited Variables





Inherited Methods














Class Details



[line 57]






[ Top ]







Class Variables



	
	

	
$debug =  true

	
[line 60]

  


    

  • Access: public
    • 





  

	

  

    

      Type:  
      mixed
    

      

	



	
[ Top ]


	
	

	
$key = 

	
[line 62]

  


    

  • Access: public
    • 





  

	

  

    

      Type:  
      mixed
    

      

	



	
[ Top ]


	
	

	
$matrix = 

	
[line 61]

  


    

  • Access: public
    • 





  

	

  

    

      Type:  
      mixed
    

      

	



	
[ Top ]


	
	

	
$result = 

	
[line 59]

  


    

  • Access: public
    • 





  

	

  

    

      Type:  
      mixed
    

      

	



	
[ Top ]










Method Detail



	
	
__construct (Constructor)   [line 69]

	

    

    

		DB_Sqlite_Tools_DBC __construct(
)
    

    


	
		


    

  • Access: public
    • 








        
[ Top ]

  

  
  
	
	
__destruct (Destructor)   [line 309]

	

    

    

		void __destruct(
)
    

    


	
		



        
[ Top ]

  

  
  
	
	
liteAll   [line 258]

	

    

    

		$this->result liteAll(
string
$sql, [string
$crypt = true])
    

    


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


    

  • Return: object
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        string  
        $sql  
        — 
        sql to execute
      

          

        string  
        $crypt  
        — 
        default true, decrypts the result
      

        

    


        
[ Top ]

  

  
  
	
	
liteautoExec   [line 87]

	

    

    

		$mixedvar 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  I


    

  • Throws: DB_Sqlite_Tools_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 Xtea before inserting the data, default true
      

          

        string  
        $whereString  
        — 
        necessary for UPDATE, default null
      

          

          
        $dataValues  
        — 
        
      

          

          
        $queryType  
        — 
        
      

        

    


        
[ Top ]

  

  
  
	
	
liteAutoFetch   [line 226]

	

    

    

		$this->result liteAutoFetch(
string
$sql, [string
$crypt = true])
    

    


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


    

  • Return: object
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        string  
        $sql  
        — 
        sql to execute
      

          

        string  
        $crypt  
        — 
        default true, decrypts the result
      

        

    


        
[ Top ]

  

  
  
	
	
liteConnect   [line 177]

	

    

    

		true liteConnect(
string
$db)
    

    


	
		Connects to the Sqlite DB


    

  • Access: public
    • 








        
Parameters:

    

    

          

        string  
        $db  
        — 
        the db name
      

        

    


        
[ Top ]

  

  
  
	
	
liteLastError   [line 293]

	

    

    

		sqlite_error_string liteLastError(
[string
$queryString = ""])
    

    


	
		returns the last DB error string


    

  • Access: public
    • 








        
Parameters:

    

    

          

        string  
        $queryString  
        — 
        the query string
      

        

    


        
[ Top ]

  

  
  
	
	
liteLastID   [line 303]

	

    

    

		$this->dbobj->lastInsertRowid(); liteLastID(
)
    

    


	
		returns the last inserted row id


    

  • Access: public
    • 








        
[ Top ]

  

  
  
	
	
liteQuery   [line 201]

	

    

    

		true liteQuery(
string
$sql)
    

    


	
		Executes the query and return the results objects if available


    

  • Access: public
    • 








        
Parameters:

    

    

          

        string  
        $sql  
        — 
        sql to execute
      

        

    


        
[ Top ]

  

  
  
	
	
safeQuote   [line 156]

	

    

    

		void safeQuote(
[
$mixedVar = ""])
    

    


	
		


    

  • Access: public
    • 








        
Parameters:

    

    

          

          
        $mixedVar  
        — 
        
      

        

    


        
[ Top ]

  

  
  



        

		    

		    Documentation generated on Mon, 11 Mar 2019 13:55:48 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright ©  PHP Group 2004.