UTF8 Unicode PHP MySQL for International Characters
- Category: Personal Home Page
- Hits: 24787
- Joomla works fine with international characters
- A Module Extension I wrote for Joomla! displayed funny characters.
- The Joomla! articles were displaying the correct characters for that language set.
- I needed to make my extension read data from a MySQL database and display the caracters as intended with UTF8.
I tried enough extensions and forum solutions, and although these changes would have an effect on the module (such as take away accents and convert to ASCII), they weren't what we were looking for.
The quick solution was to make the script run a MySQL command at the start:
SET NAMES 'utf8'Now I need to run this command from within a Joomla! extension using the mysql Joomla! classes, here's how I've used in this script pulling IDs and titles from the a sample table:
Is it a scam? Gumtree.com's warning signs
- Category: IT Support
- Hits: 36400
This list used to be on Gumtree's website but I can't find it anymore. This is quite a thorough list though it still needs some work.
Yesterday's time in PHP
- Category: Personal Home Page
- Hits: 7189
$today=date("Y-m-d"); $yesterday = date('Y-m-d', mktime(0, 0, 0, date("m") , date("d") - 1, date("Y")));
MySQL Oracle equivalents
- Category: Databases
- Hits: 26611
The Sandpit
- Category: Graphic Design
- Hits: 34942
I saw this on BBC News Click and was really impressed. It's an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is.
As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks like the same effect for the intro credits :c)
This is "a day in the life of New York City".
More Information can be found at http://aerofilm.blogspot.com/2010/02/sandpit-short-film-by-aero-director-sam.html
Personally I can sit there watching it without sound.
Change the login link in MediaWiki
- Category: MediaWiki
- Hits: 39555
- We have an internal wiki knowledge base using MediaWiki version 1.14.
- Some articles are available for public, some are restricted to staff and different localgroups.
- When users click on the 'Login' link, we want the system to automatically prompt them for their username/password. (Kerberos authenticated, as opposed to NTLM authenticated).
- Note: This article is displaying how to change the link and not how to setup these authentication methods.
Comparing two mediawiki sites
- Category: MediaWiki
- Hits: 10638
In this particular case, I'm comparing my Live and Dev versions of the same MediaWiki site. I want to add the SQL queries I used to this article but I'm in the middle of carrying out this process and it's due in two hours.
- Checking both MediaWiki have the same article content:
- Print Special:AllPages from both sites and do an eye-check (I basically highlighted articles found in one but not the other - we had over 2000 articles... I guess I'm a bit geekly like that)
- This doesn't show modified date and content size differences but I can run this SQL query to show me these.
Frontpage Item Ordering
- Category: Joomla
- Hits: 14946
Having trouble ordering your frontpage articles? After re-ordering articles wondering where it was taking the order it puts the articles in the front page (or landing page) was confusing me. The quick answer is that it is within the menu manager > main menu > menu item section of your Joomla! Admin Panel.
Certain Advanced Parameters in your Menu Item called "Home" must be set correctly for the article ordering you set in your Front Page Manager to take effect.
Page 63 of 74
Credit where Credit is Due:
Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.
Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.
Thank you for visiting and, as always, we hope this website was of some use to you!
Kind Regards,
Joel Lipman
www.joellipman.com
Latest Articles
Accreditation



Donate & Support


