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

09 March 2011 with a single-space $str = str_replace(' ', ' ', $str); // replace any double-spaces with a single-space return $str; } # highlight terms within search results function search_highlight($text, $terms_rx){ $start = '(^|)'; $end = '($|)'; return...

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

Keyboard and mouse shortcuts in Google Chromehttps://joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 your input and open the resulting URL. Type a URL, then press Alt+Enter. Opens the URL in a new tab. F6 or Ctrl+L or Alt+D Highlights the URL. Ctrl+K or Ctrl+E Places a '?' in the address bar. Type a search term after the question mark to perform a...

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

Zoho Creator: Change Radio into Tabshttps://joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 == "eBay Preview") { show Tab_Section_7; v_SelectedTab = 7; } else { show Tab_Section_1; v_SelectedTab = 1; } // // highlight selected tab v_Css2 = ""; v_Css2 = v_Css2 + ".zc-Tabs-group .choice-table-row:nth-child(" + v_SelectedTab + ")...

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

Zoho Creator: Radio group into Calendar Carouselhttps://joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 I want to highlight the current selection so I'll make this a different color (hot pink): div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(3)[elname='radioEl_zc-Calendar_Day_Select_2'] span{background-color:#FF1493 !important;} Then I...

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

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 service user account... Especially one used by the scripts to access the database-driven website. How? I'm first going to highlight 2 methods which I found on the web and can be applied if you work somewhere that doesn't care about testing, about...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 Platform IAM Google Suite PHP v5.6.35 How? I'm going to go through each 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...

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

Zoho Analytics: Setup DataSource via FTP Connectionhttps://joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 first row are headers/column/field names. If necessary, specify the format of the data per column (in this example, I highlight the Date column, it then prompted me what format this is in, eg. dd/MM/yyyy): You will then be shown a summary of your...

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