Search - Joel Lipman .Com

41. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... URL: put our corporate website URL, this is for developers who need to query what this app belongs to or does. eg. "https://www.joellipman.com/" Authorized Redirect URIs: for this put in one of the following ...; Created on 12 August 2020
42. MySQL: Count occurrences of words in a column: / MySQL /; What? This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count ...; Created on 12 March 2020
43. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; ... = getUrl( v_Url ); // usage: v_TimeZone = v_Response.getJSON("timezone"); Returns something like: { "query": "147.188.254.175", "status": "success", "continent": "Europe", "continentCode": ...; Created on 03 June 2019
44. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($data)); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($ch); curl_close($ch); $output = json_decode($response, ...; Created on 02 February 2019
45. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
46. Make bootstrap carousel responsive to swipe: / Bootstrap /; ... You have to tap on the left and right symbols... How? Some will suggest to load the jQueryMobile library but that started messing up the template layouts for me. I really like the solution (and ...; Created on 14 December 2016
47. MySQL Transactions in PHP: / MySQL /; ... and add funds to another: $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'-1000000 WHERE 'user' = 'Bob'"); $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'+1000000 WHERE 'user' = 'Fred'"); What ...; Created on 14 December 2016
48. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; ... characters and Western languages): // insert after database connection and prior to database query (where $db_conn is your mysqli connection) mysqli_set_charset($db_conn,"utf8"); // decode and display ...; Created on 25 January 2016
49. Sort an associative array by values in Javascript: / JavaScript /; ... The original code is not my own either but that's not an excuse. I also found that examples across the web were only partial and thought I'd write a full example here. No jQuery and using the Google Chrome ...; Created on 29 September 2015
50. Joes Word Cloud (JWC) Download: / Downloads /; ... Latin language sets.- Date Uploaded: Thu, 16th May 2013 2.1.1 - Included ReadMe file (lost in v1.6.8) - Enhancement: Parameter: Display Debug Mode (was "display SQL query") - Enhancement: Debug Mode: ...; Created on 07 September 2015
51. Android: Function to let user take photo or choose existing: / AndroidOS /; ... = getContentResolver().query(selectedImage,filePathColumn, null, null, null); cursor.moveToFirst(); int columnIndex = cursor.getColumnIndex(filePathColumn[0]); String ...; Created on 04 November 2014
52. Homepage (default): Created on 10 January 2018
53. Testimonials: Created on 17 April 2017