Search In
If the length of results is greater then the value if the max_allowed_packet system variable then the String-valued functions will return NULL
The first position of a string (for those functions which operate on string), is numbered 1.
Non-integer
Environment is the most important part of set in any framework.its indicates stores various contextual data used by the ORM method . For example you can see below code in you .py file .
@api.multi
... @api.returns('self')
... def demo_method(self):
Auto-increment is used to allow a unique number when a new record inserted into a table. Generally we use Auto-increment to create value for primary key field automatically when a new record is inserted into a table.
Syntax:
The below statement cr
Hello friends,
If you want to change the array keys in either upper case or lower case then you can use a predefined array function of PHP which is "array_change_key_case()". array_change_key_case returns an array with all keys from array lower or u
TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str), TRIM([remstr FROM] str)
TRIM mysql function is used for trimming a given character even left or right and if not given then both side. If trimming character is not passed with this function then
SUBSTRING(str,pos), SUBSTRING(str FROM pos), SUBSTRING(str,pos,len), SUBSTRING(str FROM pos FOR len)
SUBSTRING mysql function returns substring from a string. You can use this function with some above types.
If you pass only one argument with string
You can use YouTube video related information using YouTube API, using this API you can retrieve details such as video thumbnails, caption, description, statistics and more. You just need to obtain the YouTube key and create a videos: list request:
To get directory list in PHP we have define a function get_dirlist() in which we are passing a parameter which is the name of the directory. Inside this function we are executing the ls command with the help of exec() function. Using this we will get
Hello Readers,
Default user class in joomla has not provided salted MD5 to hash the password. So In joomla 3.2.1 The bind function of the User class now provides the facility to calls JUserHelper::hashPassword($array['password']) to encrypt the pas
To delete records of more than one table we can use joins. Joins are used to combine two table. Here, we will use join to delete the records from more than one table.
Syntax:
DELETE T1, T2 FROM T1 INNER JOIN T2 ON T1.key = T2.key WHERE condition
