PHP MySQLi Database Class Documentation

Note

This is not an official documentation. Official API documentation is available in the GitHub repo here.

• 1. Installation
• 2. Initialization
  • 2.1. Advanced initialization:
• 3. Insert Query
  • 3.1. Simple Example
  • 3.2. Insert with on duplicate key update
  • 3.3. Replace Query
• 4. Update Query
• 5. Select Query
• 6. Pagination
  • 6.1. Result transformation / map
  • 6.2. Defining a return type
• 7. Delete Query
• 8. Running raw SQL queries
  • 8.1. More advanced examples:
• 9. Query Keywords
• 10. Ordering method
• 11. Grouping method
• 12. Properties sharing
• 13. JOIN method
• 14. Subqueries
• 15. EXISTS / NOT EXISTS condition
• 16. Has method
• 17. Helper methods
• 18. Transaction helpers
• 19. Query exectution time benchmarking

Indices and tables

• Index
• Module Index
• Search Page