Introduction This document will cover various database administration activities using phpMyAdmin (PMA for short). This covers three levels of administration; database level, table level, and row (data) level. PMA is a database front end for the popular database language/architecture MySQL. PMA itself is written in the equally popular server-side language PHP. You can also download a PDF [...]
Browsing the archives for the MySQL tag
http://renownedmedia.com/blog/database-administration-using-phpmyadmin/
This is a database dump of all countries, along with their 2 digit country code. There are 246 countries total, sorted alphabetically. The database dump has three columns, the first is a primary numeric key set to autoincrement. The second is the two character abbreviation of the country. The third column is the name of [...]
http://renownedmedia.com/blog/free-mysql-database-of-all-countries/
Today, we have released RenownedDatabase, an easily integrated MySQL Database manager. Please click here for a live demo, no authentication required. RenownedDatabase is an easy to integrate database manager. What this means is you, as a developer, can simplify the creation of your sites admin panel by simply installing RenownedDatabase in the backend. RenownedDatabase handles all your [...]
http://renownedmedia.com/blog/renowneddatabase-released-mysql-database-manager/
RenownedLyrics is a fully featured lyrics web application. For a demo of a live website running this script, check out spiderlyrics.com. Download does not include a database of lyrics. The included layout differs slightly from the demo URL as the stock photos in the header were removed. Features:
SEO URLs (e.g. lyrics-rammstein-du_hast.htm) Simple forums for music buffs Code is [...]
http://renownedmedia.com/blog/renownedlyrics-lyric-database-web-application/
Today, we’ve released RenownedLinks, the same application which runs the popular URL shortening service ezlink.info. RenownedLinks is a shorter URL web application written in PHP and MySQL. With the help of the included PDF manual, you can easily install this on your web host with little knowledge of web servers. Why would someone want to use [...]
http://renownedmedia.com/blog/renownedlinks-url-shortening-application/
Today we have released RenownedQuotes for sale, the same application which powers ObsceneArt.net, a popular funny quote website. This download is basically an entire working website. Everything is easily configured using the master config.php file, along with documentation provided in a three page PDF document. Also included is the Photoshop PSD file for the layout used in [...]
http://renownedmedia.com/blog/renownedquotes-quote-voting-web-application/
Today, Renowned Media has released a website visitor statistics application called RenownedStats. This application is much more than just a page counter, keep reading for more details. This application allows you to keep a close eye on the visitors to your website, including what websites are referring people to you, what people are searching for in [...]
http://renownedmedia.com/blog/renownedstats-web-analyzer-page-counter-statistic/
I’ve recently began building databases which require multilingual support. What this means is that the default MySQL Collation of “latin1_swedish_ci” just isn’t cutting it anymore. What I needed to do is enable Unicode support in my text tables (not to mention language management, but that’s a whole different story). Here is what you do to change [...]
http://renownedmedia.com/blog/changing-mysql-default-character-sets/
