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

09 March 2011 $parts = array(); foreach($terms_db as $term_db){ $parts[] = "PageTitle RLIKE '$term_db'"; } $parts1 = implode(' '.strtoupper($select_joiner).' ', $parts); $parts = array(); foreach($terms_db as $term_db){ $parts[] = "PageContent RLIKE '$term_db'"; }...

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

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

03 February 2010 = 'component'; $offensive_words=array("viagra","cialis","[url=","porn","pfizer"); if (is_array($_GET)) $GotVars.=implode(",", $_GET).","; if (is_array($_POST)) $GotVars.=implode(",", $_POST).","; for($i=0;$i

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

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 0, strpos($this_date, " ")))); $this_time=trim(substr($this_date, strpos($this_date, " ")+1)); $formatted_datetime=implode("/", array_reverse($this_date_array))." ".$this_time; Replace the variable names and the SQL column and table names as per your...

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

Invalid arguments passed in router.php on line 325https://joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 The issue was that I was building my first Joomla 1.5 component and getting the below error if I put in a menu: Warning: implode() [function.implode]: Invalid arguments passed in /home/.../public_html/includes/router.php on line 325 Where "..." is the...

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

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

27 January 2013 $query = $db->getQuery(true); $query->insert($db->quoteName('#__my_users')) ->columns(array('name', 'username')) ->values(implode(',', array($db->quote('Joe'), $db->quote('jlipman')) )); $db->setQuery($query); $result = $db->query(); -- retrieve last...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttps://joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 . 'auth?scope=%s&redirect_uri=%s&response_type=code&client_id=%s&approval_prompt=force&access_type=offline', urlencode(implode(' ', $SCOPES)), urlencode($REDIRECT_URI), urlencode($CLIENT_ID) ); header('Location:' . $url); } // request access token...

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

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 floor($s % 60), ); for($i=0;$i0 ? $a2[$i].' '.$a1[$i] : ''; $v .= $a2[$i]>1 ? 's' : ''; if($v!='') $a3[] = $v; } return implode(' and ', array_slice($a3,0,2)).' ago'; } When could I possibly want to do this? Well I've previously used this for password...

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