Tag: programming
-
SQL : Searching a value in all columns of a table
To search for a value in a specific data field(column) of a database table using SQL, you can use the SELECT statement with a WHERE clause to filter the results based on your search condition. Here’s an example: But, when you need to search for a value in multiple data fields(columns) of a table you…
-
Understanding Basic PDO in PHP
PHP PDO (PHP Data Objects) is an easy to understand and use feature in PHP programming. To use PHP PDO in your local php-mysql installation or shared hosting based on CPanel, DirectAdmin or any other control panels, you need to follow these steps: Establish a Database Connection with your database manager(like mysql, oracle etc): Executing…