5.0 Arives : LAMP gets major upgrade.

Another great day for LAMP development! If you have been waiting for features in MySQL such as:

  • Stored Procedures and SQL Functions
  • Triggers
  • Views
  • Cursors
  • XA Distributed Transactions
  • SQL2003 Compliance
  • And much much more!
  • Check out the [url=http://www.mysql.com/news-and-events/news/article_976.html]MySQL 5.0 Release notes[/url] for more information.

    Zend Collaboration Project

    There are times when you go to conferences, and you have a great time. Then there are those other times when you decide “Hmmm…maybe next year” then kick your self when something really big is announced.

    While I was lucky enough to see the announcement of OpenOffice at OSCON a few years back, this week I missed what may one day become the NextBigThing for the PHP Community from Zend.

    If you haven’t yet heard of the [url=http://www.zend.com/collaboration/]PHP Collaboration Project[/url], you may want to go check out Zend’s website for it. From their FAQ:
    [quote]The PHP Collaboration Project is an open source initiative through which the PHP community and partners will create an industrial-grade PHP Web application development and deployment environment.[/quote]

    Sure, at the moment it is just an announcement. However, if anyone is going to be able to muster the open source [i]and[/i] big-business backing to actually pull off a decent/universal programming platform for PHP it would be Zend.

    Good luck guys!

    October 2005 :: Using Image_Graph

    [img align=right]http://www.kcpug.org/doghouse/2005_oct/gradient_pie-200.png[/img]
    Want to make cool graphs? Check out today’s presentation [url=http://www.kcpug.org/doghouse/2005_oct/image_graph.swf]Using Image_Graph[/url].

    Also, be sure to check out some of the great information on the web:

  • [url=http://pear.veggerby.dk/documentation.php]Documentation[/url]
  • [url=http://pear.veggerby.dk/samples/index.php]Samples graphs and code[/url]
  • [url=http://pear.speedpartner.de/talks.php]Stefan Neufeind’s presentation on Image_Graph[/url]
  • [url=http://pear.php.net/package/Image_Graph]Image_Graph on PEAR[/url]
  • The topic of WYSIWYG HTML Editors for Linux came up. While it isn’t WYSIWYG, [url=http://bluefish.openoffice.nl/index.html]bluefish[/url] came to mind. We also thought of [url=http://nvu.com/screenshots.html]Nvu[/url], and it certainly looked full-featured.

    This discussion lead us into a chat on CSS and web-standards based design. The websites [url=http://www.alistapart.com/]A List Apart[/url] (for info) and [url=http://www.csszengarden.com/]CSS Zend Garden[/url] (for inspiration) both came up. I also had to show off the [url=https://addons.mozilla.org/extensions/moreinfo.php?id=60]Web Developer Toolbar[/url] for Firefox…a web-coder’s best tool.

    See you next month!

    PHP 5 Objects, Patterns and Practice, reviewed on the dot.

    Part shameless plug, part book review notification: I just wanted to announce that my review of [url=http://www.amazon.com/exec/obidos/tg/detail/-/1590593804/qid]PHP5OPP[/url] is now available on slashdot.org. I loved this book so much, and believe in it so completely that I wanted the review to get as much exposure as possible.

    If you have been wanting to give your programming skills an object oriented upgrade but don’t really know where to take the plunge–go check out [url=http://books.slashdot.org/books/05/08/16/0434205.shtml?tid=169&tid=6]my review of PHP 5 Objects, Patterns and Practice[/url] from Apress.

    June 16th, 2005

    We had a nice little chat this month. We talked about some job offers that have come in, kcpug’s future, simple content management systems, the need for css and much more. A wrap up and some followup info, all in this month’s pug newsletter.

    Job Prospects

    JCCC is Hiring! I’ve recently accepted a position at my place of employment, and my old job is needing to be filled. We’re looking for a web application developer with lots of experience, a great attitude, and who is not afraid to do non-developer things. Check out the [url=http://web.jccc.net/hr/jobs/CurrentOpenings.htm]Jobs and Opportunities[/url] of http://jccc.edu for more information.
    There were others, but I don’t want to announce them here, unless you want to. You know who you are. 😉

    Doug is looking for content management

    Doug asked a question like “My clients need a CMS to edit simple websites, but they shouldn’t need to know any html, or anything.”

    Helen suggested looking into DreamWeaver templates, as mostly his issue is providing a safty-net from his client’s own…creativity. We all agreed that this would be a good solution for many clients.

    The lite section opensourcecms.com was also suggested as a place to look. After the meeting, I found cmsimple and sapid as possible candidates. Sapid looks really, really cool…and appears to be just downright perfect for this. Very clicky/sqishy…although the opensourcecms install is a little horked. Once you are logged in, just append ?mode=edit to the url of any page you want to switch into edit more. The edit button in the toolbar seems to be broken…but again, I’m sure it would work in your own install.

    Helen is looking for a single page, easy update solution

    The best I could think of was using something like [url=http://www.dynarch.com/projects/htmlarea/]HTMLArea[/url], and let it post to a password-protected php script that would get the html and save the file.

    So, say your user’s only saw mypage.php:
    mypage.php
    [code]

    This is my page

    include(‘uploaded_page.inc’);

    [/code]

    Then, write up a simple php script…let’s call it uploader.php. It could draw a form using an html area. It should probably load the uploaded_page.inc file and put it in the html area.
    On form submit, write the html-area into uploaded_page.inc.

    This should naturally be password protected. You would also want to be careful not to let it write to any other page on your site, etc. But it should be fairly straightforward.

    CSS: Any good info?

    The topic of CSS came up as well. I’m a huge fan of it, and went on my pre-programmed rant of why it is a good thing. If you are interested, you may want to check on this handful of links:

  • [url=http://www.tanfa.co.uk/css/layouts/flexi-floats-3col.asp]A great 3 column, stretchy layout[/url]
  • [url=http://www.tanfa.co.uk/]tanfa in general is a great css reference.[/url]
  • [url=http://www.alistapart.com/]A list apart[/url]
  • Specificly, their [url=http://www.alistapart.com/articles/slashdot/]re-writing slashdot[/url] article
  • Anything Else?

    I’m sure I have missed a ton of things. Feel free to add anything I missed, or any additional information as a comment.

    See you all next month!!

    It’s your birthday, PHP!

    [url=http://zak.greant.com/]Zak Greant[/url] reminds us that [url=http://zak.greant.com/archives/2005/06/a_decade_of_php.html]PHP is 10 years old[/url] today.

    [url=http://groups.google.ch/groups?selm=3r7pgp%24aa1%40ionews.io.org&oe=UTF-8&output=gplain]Happy Birthday PHP![/url] My how you have grown.

    Get Involved! Help out a great guy, and get loads of exp. points!

    [url=http://www.brotherjonathan.org/][img align=right]http://www.kcpug.org/site/uploads/img4231cd1232be1.gif[/img][/url]
    [b]Help Jared finish this remarkable ERP/MRP system! [/b]
    Are you looking for a nice Open Source, PHP/MySQL Project to contribute to? How about something nice and impressive to add to your resume? Look no farther than BrotherJonathan. Nearly complete, this project just needs a little TLC to take it to it’s 1.0 release! And you can help!

    Visit [url=http://www.brotherjonathan.org/]brotherjonathan.org[/url] for more information, screenshots, demos and downloads!

    Welcome Selia; our youngest little PUG!

    [code]assignNewPriority($selia);
    $dholmes->setFreeTime(“.01%”);

    echo $dholmes->getStatusMessage();
    echo $rholmes->getStatusMessage();
    echo $selia->getStatusMessage();
    ?>[/code]
    [b]Result[/b]…

    [quote]Dan Holmes is currently very busy helping his wife Becky with their new baby daughter, Selia Avery Holmes. As such, his free time has been reduced to a tenth of one percent of his total time, and may be unable to respond efficiently to additional requests.

    Becky Holmes is doing quite well–thanks for asking.

    Selia Avery Holmes is doing quite well. She has returned to her birthweight of 8 lbs and 6 oz and makes a lot of funny noises throughout the day and night. Additional information will be accessible following the activation of the NaturalLanguage composite extension.[/quote]