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

09 March 2011 ",", $term); $out[] = $term; } return $out; } # prepare for MySQL regular expressions function search_escape_rlike($string){ return preg_replace("/([.\[\]*^\$])/", '\\\$1', $string); } # function to list terms into list of regular expressions # eg....

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

Error 1065: Query was Emptyhttps://www.joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 carriage returns and tab characters are entered in the data. Those who are security-conscious will also make their system escape apostrophes (') and double-quotes ("). But who can honestly build a system that thinks of everything from day one? How?...

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

Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 if (!mysqli_connect_errno()) { $query='SELECT COUNT(*) as ArticleCount FROM `'.$db_prefix.'content` WHERE id='.mysqli_real_escape_string($db_connect, $_GET['id']); if ($result = mysqli_query($db_connect, $query, MYSQLI_USE_RESULT)) { while($obj =...

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

Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 twice then 2000pts) // + 60 pts if in introtext // + 40 pts if in fulltext $sql_keyword = strtolower(trim($db->Quote($db->escape($text, true), false))); $query->select(' (1000*((LENGTH(TRIM(a.title)) - LENGTH(REPLACE(LOWER(TRIM(a.title)),...

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

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 For example, the regular expression: ^(.*)\1$ matches a line consisting of two adjacent appearances of the same string. Escape Character Use the escape character '\' to search for a character that is normally treated as a metacharacter. For example to...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 World 123"; v_MyFormattedString = v_MyString.replaceAll("[^0-9]",""); // yields 123 The following is used in searches to escape special characters with a backslash: v_MyString = "Joe's \"Amazing\" Skill & Sidekick (1)"; v_FormattedString =...

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

Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 quick way of extracting a SELECT list in someone else's form. How? So, let's copy the HTML select into a text editor, then escape the double-quotes, then prepend with a list declaration and append with a end of list suffix; loop through removing HTML...

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

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 CRM" or "Latest CRM" in their Campaign_Name fields. When you use parentheses or comma in the value for a criteria, you must escape them using a backslash. Further, you must encode the value. Example: Consider the search term:...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = $0C Const VK_RETURN = $0D Const VK_SHIFT = $10 Const VK_CONTROL = $11 Const VK_MENU = $12 Const VK_CAPITAL = $14 Const VK_ESCAPE = $1B Const VK_SPACE = $20 Const VK_PRIOR = $21 Const VK_NEXT = $22 Const VK_END = $23 Const VK_HOME = $24 Const VK_LEFT =...

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

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 - Custom Service - on account server COM https://deluge.zoho.com/delugeauth/callback Problem: Split a string with the escape character/backslash character Trying to split a string into a list by the backslash character: v_File =...

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

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 3. The Deluge Code - Uses the EU datacenter Note that using this method, you don't have to escape parentheses characters (): // initialize v_MatchedCount = 0; v_MatchedAccountID = 0; v_SearchName = "Father & Sons (Incorporated)"; // // replace...

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

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 v_QuoteTotalStr = v_QuoteTotal.toDecimal().round(2).toString().replaceAll("(?" + v_QuoteRef + ""; // don't forget to escape quote name with CDATA in case of XML banned characters v_RelatedListXML = v_RelatedListXML + ""; v_RelatedListXML =...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 ").getPrefix("+").toString(v_TimeFormat),"-"); // // generate XML related list response // don't forget to escape quote name with CDATA in case of XML banned characters v_RelatedListXML = v_RelatedListXML + ""; v_RelatedListXML = v_RelatedListXML + "";...

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