PHP & MySQL Search Enginehttps://joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 = preg_replace("/\"(.*?)\"/e", "search_transform_term('\$1')", $terms); $terms = preg_split("/\s+|,/", $terms); $out = array(); foreach($terms as $term){ $term = preg_replace("/\{WHITESPACE-([0-9]+)\}/e", "chr(\$1)", $term); $term =...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Import Excel CSV file as JavaScript arrayhttps://joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and convert to a JavaScript array of objects var my_object_array = [ { my_col1_val: 'item1a', my_col2_val: 'item2a' }, { my_col1_val: 'item1b', my_col2_val: 'item2b' },...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

JDatabase: using the Joomla database with exampleshttps://joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 // Create a new query object. $query = $db->getQuery(true); // build the SQL query $query->select($db->quoteName(array('p.user_id', 'u.username', 'u.real_name'))); $query->from($db->quoteName('#__user_profiles p')); $query->join('INNER',...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Sort an associative array by values in Javascripthttps://joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an...

• Type: Article
• Author: Joel Lipman
• Category: JavaScript
• Language: *

Convert Past Date to Time Ago in PHPhttps://joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 { // get seconds ago $v_Seconds = strtotime('now') - strtotime($p_Date); // set unit labels $a_UnitLabels = array('year','month','week','day','hour','minute','second'); // set unit values $a_UnitValues = array( floor($v_Seconds / 31536000),...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Converting SQL date in PHP to European date format and vice-versahttps://joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 my_date_field FROM my_table WHERE my_id='$this_id'"), 0, "my_date_field"); $this_date_array=explode("-", trim(substr($this_date, 0, strpos($this_date, " ")))); $this_time=trim(substr($this_date, strpos($this_date, " ")+1));...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 This is an article documenting how to send a Zoho Deluge Map request to an API which is expecting nested/2d/multi-dimensonal arrays. In the example below, we are posting to a PHP script for testing but I have since sent something similar to an API...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Creating a Top 10 chart with less codehttps://joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 (for sorting purposes - eg. so 10 is not before 2) Store both the formatted count and the value of column1.table in the next array entry Reverse this array Display the first 10 rows of this array (if we are doing a top ten) My new method is: SELECT...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 { try { // Check type for all string properties if (object.ReferenceEquals(p.PropertyType, typeof(string))) { // declare two arrays string[] exceptionArray_this; string[] exceptionArray_that; // get the value we want to transform string ValueToConvert =...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

htaccess Rewrites SEF URL and submits to PHPhttps://joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 '', $site_structure_string); var $site_structure_item = $_GET['myFiles']; var $site_structure_array = explode('/', $site_structure_string); // yields $site_structure_array[0] = 'blog' $site_structure_array[1] = 'videos' $site_structure_array[2] = '2010'...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 curl_setopt($ch1, CURLOPT_RETURNTRANSFER, true); // set authorization header curl_setopt($ch1, CURLOPT_HTTPHEADER, array('Content-Type: '.$mime_type, 'Content-Length: ' . filesize($file), 'Authorization: Bearer ' . $access_token) ); // execute cURL...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 // optional m_Data= Map(); m_Data.put("data",m_RecordData.toJSONList()); // NOTE: convert this to a JSON Array r_RecordUpdate = invokeUrl [ url :v_EndPoint type :PUT headers: m_Header parameters:m_Data.toString() ]; // NOTE: convert parameters variable...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho CRM: Manage a subform using Client Scripthttps://joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 subform management // ***************************************** // declare the new row and JSON argument var json_Row = new Array(); var json_Arg = new Object(); // get some values beforehand which allows us to compare to the rows already present in the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Counting the occurence of a word within a string: Benchmarkhttps://joellipman.com/articles/web-development/php/counting-the-occurence-of-a-word-within-a-string-benchmark.html

06 September 2009 Count By str_ireplace took : 0.39766597747803 Seconds Count By Explode+Count took : 0.25045800209045 Seconds Count By Array Functions took : 1.1077101230621 Seconds Count By preg_split+Count took : 0.30741000175476 Seconds Count By substr_count took :...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 with cURL isn't a problem, but I want to convert it to JSON and I usually use a PHP function to load the data into an XML array and use the built-in PHP function: "json_encode". How? So here's what I tried and ended up with: If your XML is UTF-8 This is...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

PHP - Remove newlines and spaces from StyleSheethttps://joellipman.com/articles/web-development/php/php-remove-newlines-and-spaces-from-stylesheet.html

03 January 2020 5px 5px 0px rgba(51, 51, 51, 0.3); }"; $v_AppStyleFormatted = preg_replace('/\s+/', ' ', $v_AppStyle); and a few str_replace arrays: // exceptions $a_ReplaceFrom1 = array("px ", "0 ", " a"); $a_ReplaceTo1 = array("px?", "0?", "?a"); $v_AppStyleFormatted...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Anti-Spam override for all submitted datahttps://joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 it's in /* lines */ which means these are comments. The quick solution is: $_REQUEST['tmpl'] = 'component'; $offensive_words=array("viagra","cialis","[url=","porn","pfizer"); if (is_array($_GET)) $GotVars.=implode(",", $_GET).","; if (is_array($_POST))...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 section of the code to go through the logic and highlight any changes you may need to make. 1. First: the variables are in arrays Well mostly. Simply because we'll be working with JSON data and this encodes/decodes easily into PHP arrays. I can also...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

PHP: First name and Initial of Surnamehttps://joellipman.com/articles/web-development/php/php-first-name-and-initial-of-surname.html

27 March 2014 lot of repetition so lets reduce that a touch: // default $author_name_disp=$author_name; // check and transform $delimiters=array(' ', '.'); foreach($delimiters as $word_index=>$delimiter) { if (strpos($author_name, $delimiter)!==false) {...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Deluge - Get Full Day Namehttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-full-day-name.html

08 November 2018 is working: My_Date = today; Day_Name = My_Date.toString("EEEE"); // returns "Monday" Method #1: We're going to populate two arrays / lists; retrieve the index value; and use this in the second array as follows: // lists Day_Names =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *