A NEW phpMyAdmin theme for 2011!

September 22, 2010 — Mike Hommé
Mike Hommé's picture

NOTE: I will not be updating the theme for versions of phpMyAdmin below 3.4 (the upcoming release). With the official release of PMA 3.4, pmahomme will be the new default theme.

phpMyAdmin has been on my list of must have applications for years. Sincerely I couldn't go a day without it.

It's a fantastic free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web.

As endearing as phpMyAdmin is, one of its features has bothered me for seven looong years... that is, the look and feel. The default theme is boring, old, and leaves much to the imagination. As a Web/UX developer, I couldn't just live with it, right?!

With that, I’ve taken some time to give back to my beloved phpMyAdmin and created a theme that not only puts a positive spin on the user experience but provides a new, modern look and feel for one of the best open source applications of all time.

I’ll continue to update and fix browser bugs if folks begin to adopt this theme.

Please have a look and if you’re interested, you can:

Download pmaHomme v1.0 from PHPMyAdmin.net:
http://www.phpmyadmin.net/home_page/themes.php

I hope you find it useful & tell your friends, enjoy!

Comments (30)

Guest's picture

Great theme!

Really great theme.
I would like to use it for my web site :-)

Mike Hommé's picture

Go for it!

Shouldn't be too hard to adapt most of the theme to a website. Just download the latest version of PHPMyAdmin and you'll have access to all the CSS and images. If you try it be sure to let us know how it turns out!

Guest's picture

tables list group

I really like this theme!

...except for one thing ;)
on the tables list, when you have many databases, gropups are not enough visualy separated from other tables (

  • ).
    In the classic theme it was easier to find table-groups.
  • Would it be posiible to fix it (maybe group title in bold, tables list more indented...)?

    Guest's picture

    tables list group

    ... <li class=group>

    Guest's picture

    Awesome

    Its always amazing to see people going out of their way to do something for the community. Great work, it looks fantastic. Thank you.

    Mike Hommé's picture

    No, awesome to all of you!

    It's really amazing to see all of the positive comments about the new theme; not only here, but on Twitter as well. I never thought the response would be so positive.

    I really appreciate all that have taken even a minute or two out their busy days to say "thanks" here on my blog.

    I've been keeping track of all of the positive and negative comments on Twitter, as well. (Please Follow me, I don't tweet much, but when I do... :)

    Anyway, thanks again everyone! I'll leave you with a final Nick Burns reference. (Your company's computer guy) "You're Welcome!"

    Guest's picture

    Display table list

    Hi,

    If you just need to add the table list to use this (finally) beautiful theme for PMA, here is the modification to do:

    change:
    div#left_tableList{
    display:none;
    }

    to:
    div#left_tableList{
    /*display:none;*/
    }

    thanks for the hard work.

    regards

    Thibault

    Mike Hommé's picture

    Thank you!

    Thibault, thanks for posting a fix!

    To all,

    Since my PMAHomme theme will now be packaged as the "default" theme with PHPMyAdmin 3.4 (coming soon (already RC2)), I've been focused only on bug/feature fixes for that version, and not on the SF project many of you are downloading. :( In-turn you're finding problems with it.

    I'll most likely remove this project from SF after official release of 3.4 since the download won't be needed. I'd also hope that you'd upgrade your PMA install to 3.4 when released, lots of awesomeness in the new version, check it out!

    However, soon you will have the theme as default, working in all environments, and most importantly, tested professionally by the PMA dev team!

    Guest's picture

    This theme is awesome. It

    This theme is awesome. It makes doing my job way more fun. I'm spreading the word to co workers. Thanks for your theme and congrats on getting it accepted as the default!

    Mike Hommé's picture

    Awes!!

    Thanks, Guest,

    Glad you're having more fun, at work. :)

    Guest's picture

    Thanks!

    Like you, I've used pma almost daily for years. Many thanks for contributing something that's a bit easier on the eyes. phpmyadmin is fun again!

    Mike Hommé's picture

    wow, thank you.

    That's the best compliment, ever! Software should be fun! :)

    Guest's picture

    Pmahomme phpMyAdmin

    Hi

    Gorgeous skin. THX
    I've noticed an error, do not display table to the left while editing the database.

    Greetings

    Mike Hommé's picture

    Thank you!

    Thank you!

    There's a new version of the skin coming soon which addresses this issue.

    Just curious, what OS/Browser/PMA versions are you using?

    Guest's picture

    Fixes

    Hi,

    Firstly thank you so much for creating a PMA theme that doesnt suck!

    Secondly I found a couple of errors on the login page so I fixed them, here is the updated version, I made the changes to a version I got straight from SF.

    http://db.tt/kkg3tjE

    Thanks Daniel

    Guest's picture

    Missing Image File

    Hi Mike.

    Your theme is awesome and I can't get why it isn't the default as the default looks like something from 1975.

    Anyway, just stopped by to let you know that 404 errors in my log show that "img/ajax_clock_small.gif" is missing from the package.

    Well done and thanks!

    BTW. My original attempt to post this failed as it seems you are using projecthoneypot or similar IP address checker which generally just inconvenience legitimate users. I bypassed it by reconnecting using a proxy.

    Guest's picture

    PS on Images

    b_firstpage.png is included twice as b_firstpage (2).png

    Cheers!

    Guest's picture

    Fix for theme problem

    Hi,
    I am Marc Delisle from phpMyAdmin project. In the version dated 2010-09-29 by Mike Hommé, there are extraneous blank lines at the end of info.inc.php which are causing the problem.

    Version 1.0b which will be available on http://phpmyadmin.net soon, will contain the fix.

    Greetings,
    Marc Delisle

    Mike Hommé's picture

    Marc, thank you very

    Marc, thank you very much!

    Guest's picture

    Awesome work!

    I just found and downloaded your theme and it is perfect. I totally agree with you about how outdated phpMyAdmin looks. I have been using it for years and you have finally did it right! Thanks for contributing to the open source world!

    Alvin
    http://www.alvinsng.com

    Guest's picture

    Hi Mike, pmaHomme 1.0 theme

    Hi Mike,

    pmaHomme 1.0 theme looks very promising but does not work properly for my installation, images just won't load.
    (IIS7, phpMyAdmin 3.3.7 & 3.3.8)

    Do you have an idea what can be wrong? it's supposed to be server independant right? something with premissions of phpMyAdmin config? I could give a screenshot if it helps. Please help.

    Guest's picture

    I have figured it out. It

    I have figured it out. It goes wrong when the path is not "\themes\pmahomme\...". I've called it \themes\pmahomme-1.0\..."

    Sorry for offtopic.

    Mike Hommé's picture

    Cool, glad you figured it

    Cool, glad you figured it out.

    Let me know if you have other issues!

    Guest's picture

    Likely having same problem

    I unpackaged your theme into my theme directory. Regular linux user so this wasn't anything complicated, but with the folder unpackaged in my theme dir it "broke" phpMyAdmin's CSS - there aren't any more styles applied. I can't select a different theme, if I try yours it just defaults back to Original, which still displays broken.

    Tried renaming folder to pmahomme (and even pmamhomme, as I can't figure out why your info.inc.php file has the theme_name "pmamhomme" - notice extra 'm' before the 'h') but to no avail, themes are still broken. I tried this on PMA 3.3.2 and the latest stable, 3.3.8.1. Any help you can provide?

    Guest's picture

    Same problem here

    Experiencing the same problem of broken CSS as soon as pmahomme is extracted in the theme directory.
    Using PMA 3.3.8.1
    Also it could be better not to include SVN's files in the package.
    Regards.

    Vince

    Mike Hommé's picture

    A "fix" to the problem!

    Hi everyone,

    Very sorry to hear you're having trouble, but I think I understand what's going on and I'm 99.4% sure the theme was not packaged correctly on the phpMyAdmin.net themes page. I downloaded it from there and it's broken for me too.

    To get it working, try downloading it from here:
    https://sourceforge.net/projects/pmahomme/

    NOT from here:
    http://www.phpmyadmin.net/home_page/themes.php

    I will work with the PMA team to get this fixed, in the meantime, the SourceForge download seems to be the way to go.

    If you still have trouble even after grabbing it from SourceForge please let me know!

    Thanks for keeping me in the loop and hope you can get it going with the SF download!

    Mike

    Guest's picture

    Possible fix

    There are two extraneous lines after the closing PHP tag in your info.inc.php which is causing any other following Content-Type headers to be ignored. I removed those lines and all output was fixed.

    (And yes, I checked your SF download.)

    (And yes², I was digging furiously through half of the PMA code until I stumbled upon this thanks to the headers_sent() function.)

    Guest's picture

    Great guess

    I had also problems with the theme making the CCS not to load, but your tip solved it. Thanks.
    Now I can tell, cool theme indeed.

    However, a question for Mike. After the login screen, and after DB selection, I get to the DB structure screen. However in the left pane, my tables are not displayed, whereas the are using another theme. After some CSS inspection, it is caused by id #left_tableList wich is set to display:none. Any idea about that ?

    Mike Hommé's picture

    Thanks for looking into this...

    Thank you.

    In the future, if anyone having trouble could provide:

    - PMA version
    - OS type/version
    - Browser(s) and versions

    This information would help very much.

    Out of curiosity, I looked at Darkblue/Orange and the Original theme's info.inc.php files, they only had one extraneous line but they still seem to work. Maybe two, is two too many?

    Guest's picture

    radek

    Hey,

    The theme rocks apart from minor issues:
    - like the background over the select fields should go to trash.
    - the table list should be visible.
    - some padding errors on the left

    If you want, I can upload the updated version.