Tuesday, August 4, 2009

pdo exceptions.

Question: When connecting to a database using PDO, what must be done to ensure that database credentials are not compromised if the connection were to fail?

Answer:

1. wrap the PDO DSN in a try/catch block to catch any connection exception
2. Use constants in the PDO DSN
3. Place the login credentials in the php.ini file
4. Disable E_STRICT and E_NOTICE error reporting levels
See the book OpenCart 1.4 Template Design Cookbook.
See the book Joomla Mobile Development Beginners Guide




List of my works:

Opencart Extensions:

  1. Product Based Quantity Wise Shipping: Find it here.
  2. OpenSSLCOMMERZ: integrate SSLCOMMERZ with opencart: Find it here.
  3. Fine Search v.1.0 - Improves Opencart search feature to find relevant: Find it here.
  4. Opensweetcaptcha - An easy way to generate attractive captcha for your system!: Find it here.
  5. Custom Field Product - add unlimited custom fields to the product form: Find it here.
  6. Formcaptcha - add captcha on the register page: Find it here.

My Books:

  1. OpenCart 1.4 Template Design Cookbook.
  2. Joomla Mobile Development Beginners Guide

No comments: