Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Database ProgrammingDatabase Programming
Typology: Exercises
1 / 88
This page cannot be seen from the preview
Don't miss anything!
Scalar Data Types & Compound Data Types Scalar Data Types: Integer , float or double ( 1.23/ 10.2e3), boolean, string,unicode(sequence of unicode characters), binary Compound Data Types Array, Objects Special Data Types Null, resource
str_replace(“I ", “I MCA", $my_str, $count); Count- to know how many times the string replacements was performed strrev() - function reverses a string. strpos() - to search for a string or character within a string. If a match is found in the string, this function will return the position of the first match. If no match is found, it will return FALSE. Ex:
Strstr(“string”,”search string”) Find the first occurrence of “search string" inside “string" and return the rest of the string: Ex:
o/p – World! strstr( _string,search,before_search_ ) _before_search -_ Optional. A boolean value whose default is "false". If set to "true", it returns the part of the string before the first occurrence of the _search_ parameter. Ex: O/p:- Hello**
** Max, min Pi() - echo(pi()) Pow(x,y) Round(number, optional) round(3.4) 3 round(3.5)- > 4 Round(1.9562,2)-> 1.
Date Functions
