Shutdown a window system through RUN or Command Prompt
SHUTDOWN | A CLI command for Windows It's really cool to shutdown your computer through Run command or command prompt. Actually shutdown is a CLI (command line interface) command or function which is use to …
What do you mean by foreign key?
SQL | Foreign Key A foreign key is a key used to link two tables. A Primary key of a table is used as a foreign key for the other table. The primary key …
What is a view in SQL?
SQL | View View in SQL is a kind of virtual table. It does not physical exists in our database but have rows and column as there we have in a real database table. we …
What is the difference between primary key and unique constraints?
SQL | Difference between primary key and unique constraints There is only one primary key in a table. It creates the clustered index automatically and it cannot have NULL value whereas there can be multiple …
Write an SQL query to find names of employee start with 'A'?
SQL | LIKE operator The LIKE operator of SQL is used for such kind of operations. It is used to fetch filtered data by searching for a particular pattern in where clause. The Syntax for …
What is the difference between BETWEEN and IN operator in SQL?
SQL | difference between BETWEEN and IN operator The BETWEEN operator selects all records between the given range whereas IN operator selects all matching records given with the WHERE clause. BETWEEN operator The Between operator in …
How will you check if a file exists or not using PHP?
PHP | file_exists( ) Function The file's existence can be confirmed using the file_exist() function which takes the file name as an argument. file_exist("abc.jpg") The file_exists() function is an inbuilt function in PHP that …
How can you tell if a number is even or odd without using any condition or loop?
PHP | check whether a number is even or odd A trick to check whether a number is even or odd without using any condition or loop. <?php $arr=array("0"=>"Even","1"=>"Odd"); $check=13; echo "Your number is: ".$arr[$check%2]; …
What is the difference between a session and cookies in PHP?
Session V/S Cookies A cookie is an array of data stored by the browser on the client location and sent to the server with every request. It stores a limited amount of data about 4kb(i.e.: 4096 …
Write a example code showing the nested ternary conditional operator in PHP?
PHP | Nested ternary conditional operator An example code showing the nested ternary conditional operator in PHP. <?php $background_color = ($num == 0 ? 'blue' : ($num > 0 ? 'green' : 'red')); ?> Here …
Convert Object To Array in PHP
PHP | Convert Object To Array Converting an object to an array is a small thing that can be achieved by a single line of code. For this purpose, we need to use typecasting. Typecasting …
Converting array of objects to array in php
PHP | Converting array of objects to array Array of objects look like this: Array ( [0] => stdClass Object ( [id] => 1 [name] => Ram [roll] => 12 ) [1] => stdClass Object ( …
Sort an array of arrays by date in PHP
PHP | Sort an array of arrays by date in PHP Here a situation in which we have to sort an array of the array by date. An array of arrays is a multidimensional array in …
Export and import database using SSH
SSH | Export and Import Large Database OR Table Using SSH can be a good practice to manage the files and databases on your account. It is most important to use in the following circumstance …
How to find the length of a string in PHP?
PHP | Length of a string There is a string function called strlen() which is used to find the length of a string. It accepts a string that returns the length of the given string. …