Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming content is required, the following 88 results were found.

  1. UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/cms/website-development/php/utf8-unicode-php-mysql-for-international-characters.html

    $sql_utf8 = "set names 'utf8'"; $db->setQuery( $sql_utf8 ); $temp_result = $db->query(); $sql = 'SELECT '.$modulescancontentsql.' FROM #__content WHERE state=1'; $db->setQuery( $sql ); $rows = $db->loadObjectList(); foreach( $rows as $row ) { $id =...

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

  2. Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    has started using international country and region names which include foreign characters. When we copy and paste their content into our website, our webpages display a question mark inside a diamond shape instead of the foreign character. How does it...

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

  3. Accessing Apimo WebService APIhttps://www.joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

    // specify your assigned key here $apimo_sha = sha1($apimo_key.$my_timestamp); // receive content $output = file_get_contents( $apimo_url. '?provider='.$my_provider_id. '×tamp='.$my_timestamp. '&sha1='.$apimo_sha. '&method='.$apimo_method....

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *

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

    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: *

  5. JComments errors in PHP 7: plgContentJComments and JCommentsACLhttps://www.joellipman.com/articles/cms/joomla/jcomments-errors-in-php-7.html

    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: *

  6. Joomla CMS: Register to Read Morehttps://www.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

    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: *

  7. MySQL Commands to display all columnshttps://www.joellipman.com/articles/else/database/mysql/mysql-commands-to-display-all-columns.html

    extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the structure of all the columns in all the...

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

  8. Strip HTML in MySQLhttps://www.joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html

    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
Results 81 - 88 of 88