{"repo":"joomla-framework/database","free":true,"listed":false,"github":"https://github.com/joomla-framework/database","clone":"git clone https://github.com/joomla-framework/database.git","description":"Joomla Framework Database Package","language":"PHP","stars":31,"topics":["database","php","joomla","joomla-framework","mysql","postgresql","sqlite","sql-server"],"license":"GPL-2.0","category":"databases-storage","readme_excerpt":"The Database Package Introduction The Database package is designed to manage the operations of data management through the use of a generic database engine. Escaping Strings and Input Strings must be escaped before using them in queries (never trust any variable input, even if it comes from a previous database query from your own data source). This can be done using the escape and the quote method. The escape method will generally backslash unsafe characters (unually quote characters but it depends on the database engine). It also allows for optional escaping of additional characters (such as the underscore or percent when used in conjunction with a LIKE clause). The quote method will escape a string and wrap it in quotes, however, the escaping can be turned off which is desirable in some situations. The quote method will also accept an array of strings and return an array quoted and escaped (unless turned off) string. In the first case, the title variable is simply escaped and quoted. Any quote characters in the title string will be prepended with a backslash and the whole string will be wrapped in quotes. In the second case, the example shows how to treat a search string that will be used in a LIKE clause. In this case, the title variable is manually escaped using escape with a second argument of true . This will force other special characters to be escaped (otherwise you could set yourself up for serious performance problems if the user includes too many wildcards). Then, ","default_branch":null,"files":null,"tree":[],"storefront":"/r/joomla-framework","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/joomla-framework/database/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}