DATABASE


13

Apr 2016

SQL ORDER BY Keyword

SQL ORDER BY Keyword The ORDER BY keyword is used to sort the result-set. The SQL ORDER BY Keyword The ORDER BY keyword is used to sort the result-set by one or more columns. The ORDER BY keyword sorts the records in ascending order by default. To sort the records in a descending order, you can use the DESC keyword. SQL ORDER BY Syntax Demo...

Read More


15

Aug 2015

PDO (PHP Data Object)

PDO(PHP Data Object)  : PDO is a PHP extension for accessing databases in PHP. Advantages: 1) Security : In MYSQL connection we manually sanitise using mysql_real_escape_string() functions in order to avoid SQL injections. But with PDO this is all taken care for us and means we no longer have to worry about SQL injection. 2) Performance : PDO uses PHP 5′s OOP characteristics (Object Oriented Programming) so it...

Read More