Strip HTML in MySQLhttp://mail.joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? We are preparing to migrate old content to a new system. From a MediaWiki CMS to a SaaS called Service-Now. The previous interlinking between images could no longer be...

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

Joomla field types clear my htmlhttp://mail.joellipman.com/articles/cms/joomla/joomla-field-types-clear-my-html.html

09 August 2012 how to store HTML code when the save command is clicked (ie. submitted from a PHP form). This is for the Opensource Content Management System (CMS - phew what a mouthful) Joomla! version 1.6.x to 2.5.x; no wonder customers have difficulty following....

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

Link to a Joomla article from within another articlehttp://mail.joellipman.com/articles/cms/joomla/link-to-a-joomla-article-from-within-another-article.html

04 December 2012 - Direct Link (irrespective of SEF) http://www.joellipman.com/?option=com_content&view=article&id=449

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

SELECT COUNT(DISTINCT name) FROM tablehttp://mail.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT...

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

JComments errors in PHP 7: plgContentJComments and JCommentsACLhttp://mail.joellipman.com/articles/cms/joomla/jcomments-errors-in-php-7.html

13 March 2020 PHP version 7. This is a quick article to document what needed doing to fix the errors. How? First some errors: ERROR: plgContentJComments Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP;...

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

Joomla: Remove IDs from URLs for out-of-the-box SEFhttp://mail.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

14 March 2020 from your Joomla website addresses for search engine friendly URLs. // What I have www.joellipman.com/index.php?option=com_content&category_id=4&article_id=123-article-alias // With URL rewriting enabled...

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

Joomla CMS: Register to Read Morehttp://mail.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

11 April 2020 hacking away at the Joomla core. Why? Well a few hacks may be necessary because not only do we want to restrict read more content (full text) and just show intro texts to public but the default Joomla instructions do not include the search engine. I...

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