• Increase font size
  • Default font size
  • Decrease font size
Home Joomla development joomla database class and Functions

joomla database class and Functions

Generic database connector class.

An instance of this class, called $database, is created using the current Joomla configuration variables when each page is loaded. Therefore you do not generally need to create new instance of this object.  If you need to access to $database within a function then remember to declare it as global.

Beginning with version 1.1, Joomla is being adapted to use the ADOdb database abstraction library (  Some new methods have been added and some minor changes to existing methods have been made in order to accommodate this and these changes have been documented appropriately.  Joomla versions prior to 1.1 support the MySQL database ( only.
Joomla version Unknown
Defined in


    Constructor for the database class.
    Performs an SQL EXPLAIN on the current SQL query string.
    Returns the most recent database error message.
    Returns the most recent database error code.

    Escapes characters with special meaning for the database.
    Returns the string to be used to represent a null date. This method was introduced in Joomla 1.1.
    Returns the number of rows returned by a database query.
    Returns the current database table prefix code. This method was introduced in Joomla 1.1.
    Returns the current value of the internal SQL query string.
    Creates one or more tables in the database.
    Returns a list of fields given a list of tables.
    Returns a list of all the tables in the database.
    Returns the unique record number of the last record to be inserted into a database table.
    Inserts an object into a database table.
    Loads an associative list of database rows.
    Loads an object with fields from the first row returned by the current SQL query.
    Returns an array of database objects using the current SQL query.
    Returns the first field of the first row returned by the database query.
    Returns an array containing a single field from all the rows returned by the database query.
    Returns the first row of the current query as an array.
    Returns an array of database rows with numeric column indexing.
    Quotes an identifier such as a database table name, field name, etc., using database-specific quote marks. This method was introduced in Joomla 1.1.
    Executes the current SQL query string.
    Executes the current SQL query string as a single transaction.
    Returns a quoted string with characters escaped.
    Sets the SQL query string for later execution.
    Updates the AXMLS schema. This method was introduced in Joomla 1.1.
    Returns the last database error message in a standard format.
    Updates a database table row using data contained in an object.

VirtueMart Shopping Cart

Your Cart is currently empty.



Virtuemart Quotation Component

VMQuote , the online Quotation / Invoice system assists the virtuemart shop in preparation, issue, and tracking of customer quotations.
VMQuote ?allows users to quickly and accurately prepare a customer quotation by accessing the products in virtuemart store. with the powerful component, you can create any quotations for any customers, even for unregister customers, it will create a new account for them when you finish creating the quotation, and email the customers the account and quotation with pdf format document. After the new customer login in your website and ?accept the quotation, it will create a new order automatically and wait for customer finishing the payment.
It also provide the invoice function, you can generate ?the invoice of pdf format at the backend, if? you want to track the quotations and analysis the statistic, you can export all kind of tables about quotation,invoices,unpaid order.
It is a Stardand joomla component for virtuemart, so don’t worry about the edition of your virtuemart, the installation is absolutely simple, the usage is absolutely easy.

Feature Summary

  • Integrate with all VM products listed on website.
  • Auto create new customer (registration) if not existing customer ( included login details in email with quotation)
  • Quotation – Send to customer in HTML email? with attached PDF
  • Quotation – Customer are able to accept or reject quotation in the frontend
  • Quotation –? If accepted auto generate purchase order , If rejected ask why
  • Export data to CSV
  • Statements with line item invoices marked paid or unpaid
  • help Service —Help clients use this tool correctly at first time