The LEFT JOIN is sometimes called as LEFT OUTER JOIN and is performed on two database tables – the first table (on the left side) is referred as LEFT TABLE and and the second (on the right side) one as RIGHT TABLE. The LEFT JOIN returns all the rows from the LEFT TABLE along with […]
The count_all() method returns the number of rows in a table satisfying the criteria specified in the WHERE clause. It sets the number of rows or non NULL column values. Permits you to determine the number of rows in a particular table. Submit the table name in the first parameter.
The PHP hex2bin() function is used to decode a hexadecimally encoded binary string. In other words, you can use this function to convert a string of hexadecimal values to ASCII characters. You may also like PHP convert_uuencode() Function and How to count same value in array using php. Example Output
The array_intersect_key() is used to create an array containing keys and values of the first array whose keys (i.e. from the first array) are present in all other arrays. This function compares the keys of two or more arrays, and return an array that contains the entries from array1 that are present in array2, array3, […]
The array_merge_recursive() function is used to merge the elements of one or more arrays together. The elements of one are appended to the end of the previous one. The difference between this function and the array_merge() function is when two or more array elements have the same key. Instead of override the keys, the array_merge_recursive() function makes […]
The uksort() function sorts an array by keys using a user-defined comparison function. TRUE on success. FALSE on failure Tip: Use the uasort() function to sort an array by values using a user-defined comparison function. Parameter Description array Required. Specifies the array to sort myfunction Optional. A string that define a callable comparison function. The comparison function […]
How to remove index.php in codeigniter https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-4880246846967300&output=html&h=60&slotname=6239393533&adk=2806349338&adf=1336720979&pi=t.ma~as.6239393533&w=468&lmt=1620970666&psa=1&format=468×60&url=https%3A%2F%2Fscripts.guru%2Fhtaccess-file-in-codeigniter%2F&flash=0&wgl=1&uach=WyJXaW5kb3dzIiwiMTAuMCIsIng4NiIsIiIsIjkwLjAuNDQzMC4yMTIiLFtdXQ..&dt=1620970665878&bpp=5&bdt=7079&idt=164&shv=r20210511&cbv=%2Fr20190131&ptt=9&saldr=aa&abxe=1&cookie=ID%3Dae88d6ef60dfeb51-220624c824c80065%3AT%3D1620881451%3ART%3D1620881451%3AS%3DALNI_MbziyJ-Hxj_TMPSW5tsSHH0KW2DEA&prev_fmts=728×90&correlator=4634344007240&frm=20&pv=1&ga_vid=1477556874.1620554064&ga_sid=1620970666&ga_hid=1897154395&ga_fc=0&u_tz=330&u_his=1&u_java=0&u_h=864&u_w=1536&u_ah=864&u_aw=1536&u_cd=24&u_nplug=3&u_nmime=4&adx=340&ady=482&biw=1519&bih=792&scr_x=0&scr_y=0&oid=3&pvsid=3821632313478264&pem=494&eae=0&fc=640&brdim=0%2C0%2C0%2C0%2C1536%2C0%2C1536%2C864%2C1536%2C792&vis=2&rsz=%7C%7CoeEr%7C&abl=CS&pfx=0&fu=0&bc=31&ifi=2&uci=a!2&fsb=1&xpc=aVgNPPK1XF&p=https%3A//scripts.guru&dtd=194 In this tutorial we are going to learn how to remove index.php from URL using .htaccess file in CodeIgniter. htaccess is the shortened used for Hypertext Access. using this file you can do many things with your website. it is very helpful file. you can also do url […]
The chr() function is used to get a single character string from the specified ASCII value. Return values: A one-character string containing the character specified by ascii _code Example Outout
The shuffle() function is used to randomize the order of the elements in the array. The function assigns new keys to the elements in array. Note: The function uses a pseudo-random number generator that is not suitable for cryptographic purposes. Returns TRUE on success or FALSE on failure Parameter Description array Required. Specifies the array […]
Sometimes you need to bind multiple queries then you can use union in laravel. If you use union then laravel query builder provide union method for mysql union. When you are doing big project or ERP level project then mostly you require using union for getting data from database with multiple tables. Tips: The unionAll […]