Pinterest
Today
Explore
When autocomplete results are available use up and down arrows to review and enter to select. Touch device users, explore by touch or with swipe gestures.
Log in
Sign up
Posts
156 Pins
2y
Collection by
Concatly
Share
Similar ideas popular now
Syntax
Delhi College
Space Character
Sql Server
Integers
Uppercase And Lowercase
Decoding
Php
Sorting
PHP decbin is an inbuilt Math Function in PHP. It converts an input decimal integer into its corresponding binary representation string.
PHP bindec is an inbuilt Math Function in PHP. It converts an input binary string into its corresponding decimal representation.
PHP substr_count is an inbuilt String Function in PHP. It calculates the number of occurrences of a substring in another string.
The SQL UNION operator combines the result of two or more SQL SELECT queries and returns the combined result of the queries as a union.
A Table
How To Memorize Things
Names
Posts
Big
Messages
SQL RIGHT JOIN statement returns all the records present in the right table and only the matched records from the left table.
SQL LEFT JOIN statement returns all the records present in the left table and only the matched records from the right table.
SQL INNER JOIN statement selects data present in both (or more) tables according to the common field between them.
PHP exit function is a very useful and important inbuilt function in PHP. It prints a message and exits the current running script.
PHP die function is a very useful and important inbuilt function in PHP. It prints a message and exits the current running script.
Aliases in SQL are temporary names you can give to a table or column for a particular SQL Query, useful when original names are very big or not readable.
The SQL IN Operator allows us to specify multiple values in the WHERE Condition. It removes the need for multiple OR conditions in queries.
SQL AVG is an inbuilt function in SQL Server. It returns the average of a particular field/column in the rows matching criteria.
SQL Count is an inbuilt function in SQL Server. It returns the count of the number of rows matching criteria. It can also return the number of rows.
SQL MAX is an inbuilt function in SQL Server. It returns the largest value of a column in a table.
PHP print is not exactly a function, but a language construct which prints a single string or variable or multiple concatenated strings in the output.
The DELETE Query in SQL deletes existing records in the table. You can delete a single as well as multiple records according to the condition.
The UPDATE Query in SQL updates existing records in the table. You can update a single as well as multiple columns using the query.
SQL INSERT INTO Query inserts new rows in a table in an SQL database. It adds new rows by specifying the column values for each row.
PHP str_rot13 is an inbuilt string function in PHP. It performs ROT13 transformation on a string by excluding numeric and non-alphanumeric characters.
PHP bin2hex is an inbuilt function in PHP. It converts strings to hexadecimal values byte-wise with the high-nibble first.
The SQL SELECT Query retrieves or fetches data from the database. We can fetch an entire table or a set of columns using the query.
A function is a block of code that can perform a specific task when called. PHP provides two major types of functions: built-in and user-defined.
PHP urlencode is an inbuilt function in PHP. It encodes a string so as to make it convenient to pass them as query parameters in the URL.