circle.ch :: PHP

Hacking cafelog/b2 can be a pain. I tried to add some caching based on PEAR::Cache while adding it to the code of b2. There was no reasonable way to do so within an acceptable amount of time. But the pages went slow on the blog and there was something to do about it.

So I think there is a way to handle it; at least it looks like. The caching now done is based on the idea, that I take an application and say something like "start caching" at the very beginning of the script and "stop it" at the very end. A way to control such mechanism is done by the Apache directive php_value, where one can reconfigure the Apache server configuration. Therefore the parameters auto_prepend_file and auto_append_file have been used. They allow exactly a handling of such a start-stop mechanism. What follows is some lines of code of PHP, split up into two files, the prepend.php and the append.php.

This solution is probably suboptimal but it improved the accessability of the blog posts at least subjectively but hopefully not only. Any improvements are welcome.

01  <?php
02  // $Id: prepend.php,v 1.1 2003-09-11 01:31:17+02 urs Exp urs $
03
04  /**
05  * Quick & dirty way of caching a blog.
06  * Put this into your .htaccess file:
07  *   php_value auto_prepend_file /home/example.com/htdocs/prepend.php
08  *   php_value auto_append_file  /home/example.com/htdocs/append.php
09  *
10  * References:
11  * - http://ch.php.net/manual/de/ref.outcontrol.php
12  * - http://www.onlamp.com/lpt/a/1227
13  * - http://www.ulf-wendel.de/php/show_source.php?file=cache_dem_file
14  * - http://iamcal.com/publish/articles/php/processing_html/
15  */
16
17  // Include the package
18  require_once 'Cache/Output.php';
19
20  // Set some variables
21  $cache_path = array(
22                    'cache_dir'       => "/home/example.com/cache/",
23                    'filename_prefix' => "cache_"
24                );
25
26  // Create a Cache object
27  $objCache = &new Cache_Output('file', $cache_path );
28
29  // Compute unique cache identifier for the page
30  $cache_params = array(
31                      'url'       => $_SERVER['REQUEST_URI'],
32                      'post'      => $_POST,
33                      'cookies'   => $_COOKIE
34                  );
35
36  $urltest = parse_url("http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] );
37  if( preg_match('#([cmp]+)([0-9]{1,}).html#', $urltest['path'] , $match )
38      OR ( trim($urltest['path'], "/") == "blog") ) {
39
40      // Set an ID for this cache
41      $cache_id = $objCache->generateID($cache_params );
42
43      // Query the cache
44      if ( $content = $objCache->start($cache_id )  ) {
45
46          // Cache Hit
47          echo $content;
48          exit("[Cache hit]");
49      }
50  }
51
52  ?>

01  <?php
02  // $Id: append.php,v 1.1 2003-09-11 01:29:08+02 urs Exp urs $
03
04  /**
05  * Test if there is any cached data. If not obtain it,
06  * save and display it.
07  *
08  */
09  if( strlen($objCache->start($cache_id)) < 1 ) {
10      // This should not be here either, but it is obviously required.
11      // Tell me if You know any better...
12      ob_end_clean();
13
14      // Cache pages starting with pXXX.html, cXXX.html and mXXX.html. The main
15      // page http://example.com/blog/ is being cached using a parse_url trick.
16      if( preg_match('#([cmp]+)([0-9]{1,}).html#', $urltest['path'] , $match )
17              OR ( trim($urltest['path'], "/") == "blog") ) {
18          // Store page into cache
19          echo $objCache->end(3600);
20      }
21  }
22  ?>

circle.ch weblog by Urs Gehrig Search


2010-08-25T08:13:16 Academic, Android, Apache, Apple, Art, Best Of, Biotech, Civil Society, Content Management, Cooking, Copyright, Creative Commons, Crosspost, Culture, Database, Deutsch, DRM, Economy, Education, Event, Gadget, General, Geodata, Government, Health, Howto, Humor, Innovation, Intellectual Property, Java, Language, LaTeX, Law, Linux, Media, Moblog, Mozilla, Music, Office, Open Content, Open Source, P2P, PHP, Podcast, Politics, Privacy, Projects, Random Thought, Rant, Science, Search, Social Network, Software, Sport, Talks, Technology, Technology Transfer, Travelling, Weblog, Wiki, Wireless and Mobile, XML
01. June 2007 Liip is hiring - again, again, more and more PHP (wiki) \| Economy (wiki) \| Best Of (wiki) - urs @ 14:55:21 Watch out Liip AG on www.liip.ch - they are hiring Flash/Java Multimedia Developers, JavaScript Developers, PHP/XSLT Web Developers and offer Interns in Web Development and Publishing [1]. They are going to become real big. And they have really interesting projects. As a small sidenote - if you get hired by Liip, just mention to them to send that iPod to Basel ;) [1] http://blog.liip.ch/archive/2007/05/23/liip-is-hiring-yet-again.html Related post(s): DeLaRue is hiring (7.62) Google in Zürich is hiring (6.34) adfinis is hiring (4.21) Bitflux is hiring (4.01) Related tags(s): technology, economy, content_management, open_source, php Comments (0) Permalink del.icio.us 02. March 2007 adfinis is hiring PHP (wiki) \| Open Source (wiki) \| Economy (wiki) - urs @ 21:37:33 adfinis GmbH in Bern is looking for a web developer Zur Unterstützung unseres jungen Teams bei Neuprojekten und Wartung/Erweiterung von bestehenden Lösungen suchen wir per sofort eine/n PHP Entwickler/in mit Pensum nach Vereinbarung, ca. 80-100%. More details can be found on their blog [1]. [1] http://www.adfinis.com/node/177 Related post(s): phpug V (8.30) Liip is hiring - again, again, more and more (8.17) DeLaRue is hiring (7.62) Google in Zürich is hiring (6.34) Lenovo Thinkpad mit Linux Kubuntu Feisty Fawn (5.68) Related tags(s): moblog, best_of, technology, economy, linux Comments (0) Permalink del.icio.us 12. July 2006 zlyfe - Blogs, Bilder, Community et.al. PHP (wiki) \| Weblog (wiki) \| Deutsch (wiki) - urs @ 13:46:33 Der Slogan tönt so: zlyfe is the place where you can tell others about the most memorable, astonishing, or funniest moments in your life. Grundsätzlich kann man das und vieles mehr auch auf anderen Plattformen. zlyfe [1] pflegt aber einen besonderen Bezug zur Schweiz - sprich - die Technologie kommt aus Bern [2]. [1] http://www.zlyfe.net [2] http://www.adfinis.com/node/176 Related post(s): Blogging at the University of St.Gallen (8.20) Bilder aus dem Mattequartier (7.35) Corporate Blogs at Sun (6.61) Funky and Recursive Blogroll-Finder (5.41) Roxen Challenger ::: or how to manage your online data (5.25) Related tags(s): economy, weblog, law, linux, rant Comments (0) Permalink del.icio.us 01. September 2005 Open Office Dokument des Hanbuchs zu PHP und MySQL PHP (wiki) \| Deutsch (wiki) \| Office (wiki) - urs @ 21:08:31 Zu meiner letztlich publizierten PDF Version meines Einführungsscripts zu PHP und MySQL [1] aus dem Jahr 2003 ist nun auch das Open Office Dokument hinzugekommen und steht zum Download bereit. Allfällige Rückmeldungen oder Ergänzungen nehme ich gerne entgegen. Korrekturen etc. können aber auch direkt im Wiki eingetragen werden. [1] http://circle.ch/wiki/?page=HandbuchPHP Related post(s): Einführung in PHP (9.88) Office v.X repair hints (7.20) Silbentrennung nach Installation von Office XP SP3 fehlerhaft (6.71) MySQL 3.23 Declared Stable (6.62) The Center for Open Source in Government (6.34) Related tags(s): education, apple, government, database, moblog Comments (0) Permalink del.icio.us 30. August 2005 Freetag - a tagging and folksonomy system PHP (wiki) \| Weblog (wiki) \| Random Thought (wiki) - urs @ 23:08:58 Or more detailed: Freetag [1] is a module that implements a simple, fairly robust beginning of a tagging and folksonomy system. It works with PHP4 and MySQL 3.23 so far, and i imagine that if it gets popular, it should be easy to port to additional databases and/or languages. Maybe a way to build up its own tagging repository. Acutally I haven't tried, but according to the docs it is promising. As to feed the database, one could use his own tags or category names first. There are probably at least two ways to tag a blog post. Either tags selected by hand at the time of writing or as a self-tagging system (algorithm), that takes e.g. the content of a blog post, analyzes it and applys the tags to the post. Some more thoughts on tagging and retagging at overstated.net [2]. [1] http://getluky.net/freetag/ [2] http://overstated.net/04/10/09-migrating-to-delicious Related post(s): Sharing folders with VirtualBox (4.74) Slide System - PHP Ming and Flash Bitmaps (4.10) TagCloud to analyze my blog (4.08) Doxygen - a documentation system (3.99) PHPNuke ::: News system, Web Portal etc. (3.91) Related tags(s): php, weblog, open_source, database Comments (0) Permalink del.icio.us 29. August 2005 Get Tags with Yahoo! Term Extraction PHP (wiki) \| Weblog (wiki) \| Technology (wiki) - urs @ 21:54:35 This is a start: The Term Extraction service provides a list of significant words or phrases extracted from a larger content. It can be implemented by making use of the Yahoo! API [1]. One might then need to sort out the result set a bit and use them as "tags". Since this blog has no cache and the API only lets me have a limited number [2] of requests a day, I will not dive into it yet ;) For those using PHP, there is a so called yahoolib availabe. [1] http://developer.yahoo.net/search/content/V1/termExtraction.html [2] http://developer.yahoo.net/search/rate.html [3] http://sourceforge.net/projects/yahoolib Related post(s): Scaling PHP for Yahoo (9.09) Yahoo! to buy some Blog company? (7.67) Blog backend with recommended tags per post (6.91) Finding related tags to blog posts (6.14) Freetag - a tagging and folksonomy system (5.66) Related tags(s): random_thought, economy, law, technology, weblog Comments (0) Permalink del.icio.us 28. August 2005 Related posts on b2/cafelog PHP (wiki) \| Weblog (wiki) - urs @ 23:46:54 To get the related posts, there was only to apply the FULLTEXT feature to the the b2posts table. ALTER TABLE b2posts ADD FULLTEXT post_related ( post_title, post_content ) A typical SQL query looks like: SELECT ID, post_title, post_content, MATCH ( post_title, post_content ) AGAINST ( 'make zip files' ) AS score FROM b2posts WHERE MATCH ( post_title, post_content ) AGAINST ( 'make zip files') AND ( ID != '910' ) ORDER BY score DESC LIMIT 5 The you only need to handle the results and format it with a little bit of HTML. Thats it. Related post(s): Working out a category cloud (6.32) Technorati ping for cafelog/b2 (6.18) circle.ch moved myNews to cafelog (6.12) Finding related tags to blog posts (6.09) DATE_FORMAT with MySQL (5.51) Related tags(s): database, law, linux, apple, xml Comments (0) Permalink del.icio.us An unexpected T_PAAMAYIM_NEKUDOTAYIM PHP (wiki) - urs @ 22:58:57 It is said, that this PHP parse error is pointing out, that there is a problem with two colons [1]. Further it is said, that this is Hebrew. Programming can make fun. [1] http://www.php.net/manual/en/keyword.paamayim-nekudotayim.php Comments (0) Permalink del.icio.us TagCloud to analyze my blog PHP (wiki) \| Weblog (wiki) - urs @ 18:21:50 TagCloud (beta) is an automated Folksonomy tool. It analyzes RSS feeds and comes up with a cloud of related items [1]. Even though items like "http" and "htm" do not make that much sense, it might e.g. help giving an idea on what topics certain blog is talking about. I guess either with MySQL FULLTEXT search [2] or Bayesian classification [3] one could handle out something similar on his own blog. [1] http://www.tagcloud.com/User/index.php?TC_Cloud_ID=5920 [2] http://dev.mysql.com/doc/mysql/en/fulltext-search.html [3] http://www.xhtml.net/php/PHPNaiveBayesianFilter Related post(s): PHP Developers for blog.ch (1.31) VTX mit Blog Hosting (1.30) Blog Aggregator for Switzerland (1.27) International Blog Meetup Day (1.22) Monoroms blog (1.13) Related tags(s): law, creative_commons, humor, java, crosspost Comments (2) Permalink del.icio.us 03. August 2005 PHP Developers for blog.ch PHP (wiki) \| Weblog (wiki) \| Technology (wiki) - urs @ 10:55:09 blog.ch is seeking PHP developers to turn the projectlist into reality [1]. Matthias has some good ideas and is eager to fulfil them. [1] http://blog.ch/blog/?p=148 Related post(s): Liip is hiring - again, again, more and more (6.80) European Mozilla Developers Meeting 2003 (5.78) PHP developers: Fill your XML toolbox (5.38) PHP and Web Standards Conference UK 2004 (3.31) ReactOS - NT driver compatible opensource OS (3.20) Related tags(s): mozilla, government, law, creative_commons Comments (0) Permalink del.icio.us 18. July 2005 Einführung in PHP PHP (wiki) \| Education (wiki) - urs @ 23:44:42 Im Jahr 2003 verfasste ich für Unterrichtszwecke eine Einführung in PHP. Das Dokument steht nun unter HandbuchPHP zum Download zur Verfügung [1]. Nebst PHP wird auch MySQL und Apache HTTPD, mehrheitlich für Windows, thematisiert. Das Dokument ist unter einer Creative Commons Lizenz lizenziert. Anregungen, Änderungen und Aktualisierungen sind natürlich willkommen. [1] http://www.circle.ch/wiki/HandbuchPHP Comments (1) Permalink del.icio.us 08. June 2005 Not 1, 2, 3, 4, 5, 6, 7, 8, 9 but 10 years of PHP PHP (wiki) - urs @ 21:52:46 [via chregu, 1] Just to have it said. It is said that PHP exists for 10 years today [2]. [1] http://blog.bitflux.ch/archive/2005/06/07/a-decade-of-php.html [2] http://groups.google.ch/groups?selm=3r7pgp%24aa1%40ionews.io.org Related post(s): Favourite URL? (4.75) Japanese Copyright Law Reform (3.93) May 1st - "Tag der Arbeit"; cyber riot (3.15) Learning Salsa (3.11) Visual history of spam email (2.94) Related tags(s): best_of, civil_society, government, open_source, biotech Comments (0) Permalink del.icio.us 05. April 2005 Access to Desktop Search results PHP (wiki) \| Open Source (wiki) \| Technology (wiki) \| Privacy (wiki) - urs @ 22:16:07 Today I run across DNKA [1]: DNKA is a search tool for remote computers. It acts as a web server by interacting as a layer between Google Desktop Search (GDS) and the user. It allows other users to search, view and download your files, emails, chats and web history. Basically it is wonderful; you get a full search access to the indexed content of a remote computer. IMHO this application should be filed under "As long as You know what You are doing.". I tried it out in an intranet and got full access to the root drive C:\. Then later on I found Baagle [2]. The principle is similar to the above but the tools are different. Baagle is a set of Perl scripts wrapped around the search engine Swish-e. Baagle provides a standalone webserver and an indexer. But compared to GDS it is up to you to configure and restrict the indexing to the data directories of your desire. If you like to figure out a similar solution with PHP have a look at the earlier mentioned nanoweb or nanoserv webserver built with PHP [3] and a Swish-e wrapper written in PHP [4]. Once decided to go for Swish-e (on Windows) you need a couple of tools to handle various file mime types, among others pdftotext, ps2ascii, antiword and one that I found today to convert Excel files to text, called xlhtml. Just search.ch for them ;) Well, now the only thing I could not find is a few lines of code to get a configurable search field to be integrated in the Windows task bar as we know it from GDS. Anyone up with a solution? [1] http://dnka.com [2] http://floatingsheep.com/baagle.html [3] http://nanoweb.si.kz [4] http://www.neokraft.net/articles/swish-e/ Related post(s): Googles Desktop Search privacy policy (12.3) Google Desktop Search going for Thunderbird (10.5) Beagle - Open Source Desktop Search (9.99) Livesearch - let's talk about usability (6.70) Google and CC sensitive search (6.67) Related tags(s): content_management, privacy, search, art, economy Comments (0) Permalink del.icio.us 23. March 2005 Multiuser Worpress evolved PHP (wiki) \| Weblog (wiki) - urs @ 16:05:11 As talked about multiuser-Wordpress earlier, I was wondering what is going on with it. So here is a refresh pointing to some sites of interest: - http://blogs.linux.ie/xeer/2005/03/15/wpmu-snapshot-2/ - http://blogs.linux.ie/download/wpmu/ChangeLog-wpmu.txt - http://www.proyectoisla.com/planetawp/?cat=10 - http://incsub.org/blog/?p=266 Most coding seems to be done by donncha. Related post(s): Patch for multi-site capability of Worpress (4.92) Blogsome - Worpress based Blog Hosting (4.44) Related tags(s): weblog Comments (0) Permalink del.icio.us 15. March 2005 Maguma Open Studio PHP (wiki) \| Open Source (wiki) - urs @ 22:12:13 Stumbled over that piece of information today: A PHP IDE that includes features for class browsing, ftp support, snippets, debugging and project management. The Open Source version of Maguma Studio. [1] http://sourceforge.net/projects/openstudio/ Related post(s): Hacking .NET Without Buying Visual Studio .NET (7.52) Jahrbuch zu Open Source und Open Content (4.81) Tägliche Ration Open Source (4.27) Create Windows forms using ink (4.22) Open Wiki for IIS (4.19) Related tags(s): moblog, government, talks, social_network, innovation Comments (0) Permalink del.icio.us 10. February 2005 Bug #2415 - No UTF-8 decoding of header PHP (wiki) - urs @ 21:48:19 Bug #2415 "No UTF-8 decoding of header" [1] which I reported quite some time ago got reedited today. The problem is described even more complex. But jazfresh proposes some additional fixes. [1] http://pear.php.net/bugs/bug.php?id=2415 Related post(s): Adding header or footer information to existing PDF (7.48) Another view on PEAR (4.10) XmlWriter: Generating XML from PHP (3.58) IPTC parsing with PHP (2.85) Converting an Image to standalone SVG (1.80) Related tags(s): open_source, php, xml, projects Comments (0) Permalink del.icio.us 27. January 2005 ffmpeg - The upcoming tool for video conversion PHP (wiki) \| Weblog (wiki) \| Wireless and Mobile (wiki) - urs @ 11:16:19 ffmpeg [1] is the tool I have used locally for some time now [1]. It allows conversions of various video formats and video to image conversions. Over the last few months I started a collection of links to some helpful articles and discussions [2]. Recently, there has been started the development of a PHP extension [3]. I could imagine, that ffmpeg would be quite an interesting PHP5 standard extension ;) I haven't checked the license for compatibility though. Grabbing a frame out of a video is as simple as follows. It took me quite some time to figure out the appropriate options, since the web and the documentation did not yet satisfy my needs: $ ffmpeg -i test.3gp -f singlejpeg -img jpeg -y test.jpg Input #0, mov, from 'test.3gp': Duration: 00:00:04.8, bitrate: 80 kb/s Stream #0.0: Video: h263, 128x96, 10.00 fps Stream #0.1: Audio: 0x726d6173, 8000 Hz, mono Output #0, singlejpeg, to 'test.jpg': Stream #0.0: Video: mjpeg, 128x96, 10.00 fps, q=2-31, 200 kb/s Stream mapping: Stream #0.0 -> #0.0 frame= 48 q=4.0 size= 117kB time=4.8 bitrate= 200.0kbits/s I am sure this will boost video blogging enormously [4]. I first was heading for mplayer, but mplayer is IMHO kind of related to X and we do not really want X to be installed on a production server, do we? Finally, I would like to talk about animated GIF files and provide an example. As with a combination of Imagemagick and ffmpeg, it is a matter of two command lines evtl. one (I am not a pipe specialist ;). As shown below, ffmpeg generates a set of 10 images and Imagemagick converts them to an animated GIF: $ ffmpeg -i test.3gp -f image -img gif -t 1.0 test%03d.gif Input #0, mov, from 'test.3gp': Duration: 00:00:04.8, bitrate: 80 kb/s Stream #0.0: Video: h263, 128x96, 10.00 fps Stream #0.1: Audio: 0x726d6173, 8000 Hz, mono Output #0, image, to 'test%03d.gif': Stream #0.0: Video: rawvideo, pal8, 128x96, 10.00 fps, q=2-31, 200 kb/s Stream mapping: Stream #0.0 -> #0.0 frame= 10 q=0.0 size= 0kB time=1.0 bitrate= 0.0kbits/s $ convert -delay 20 -loop 0 test.gif animated.gif Feeback always welcome ;) [1] http://ffmpeg.sourceforge.net [2] http://www.circle.ch/wiki/MpegToJpeg [3] http://ffmpeg-php.sourceforge.net [4] http://www.circle.ch/wiki/3gpVideo Related post(s): Word to LaTeX conversion (7.43) Pearl Jam Music Video unter CC (6.45) PPT2XML conversion II (6.30) Upcoming - collaborative event calendar (6.18) Free PDF conversion of MS Office documents (5.79) Related tags(s): office, latex, technology, music, weblog Comments (6) Permalink del.icio.us 24. January 2005 s9y podcast plugin by Hannes* PHP (wiki) \| Content Management (wiki) - urs @ 11:09:31 Hannes [1] hacked a PodCasting plugin for s9y and has it up and running on his test blog [2]. There are on the other hand some good arguments, why PodCasting is not always cool [3]. [1] http://hannes.kaywa.com [2] http://s9y.lebureau.mediagonal.ch/archives/200501.html [3] http://blog.koehntopp.de/archives/649-Warum-podcasting-nervt.html Related post(s): WYSIWYG Plugin for Wordpress (6.95) iTunes with podcast (6.85) RSS Reader Plugin for jEdit (5.89) Wikipedia plugin for Mozilla (5.83) Firefox search plugin für Bundesgerichtsentscheide (5.47) Related tags(s): open_source, mozilla, deutsch, random_thought, intellectual_property Comments (0) Permalink del.icio.us 30. December 2004 JPEG image problem with PHP GD PHP (wiki) \| Random Thought (wiki) - urs @ 23:15:04 I wrote a PHP script based on imagecopyresampled() to resize images coming from mobile phones. Some phone models seem to produce corrupt JPEG files. As on calling imagecreatefromjpeg() a message gets produced looking like: "Corrupt JPEG data: 164 extraneous bytes before marker 0xd9". Imagemagick handles such problems in some - to me unknown - way and resizes the image properly, regardless of the problem pointed out. But there is currently only GD available and with that few lines of code I get a black resized thumbnail. The message pointed out above gets printed out when calling imagecreatefromjpeg(). A random thought was to rewrite a function from scratch in PHP that creates a valid image resource [1] in spite of the corrupt JPEG format. But as we have 23p.m. now, I am just too tired now ;) So I am stuck. A corrupt image can be found here [2]. [1] http://lxr.php.net/source/php-src/ext/gd/libgd/gd_jpeg.c#238 [2] http://circle.ch/blog/media/bild015.jpg Update: Problem-walk-around, as I got imagemagick support on the server ;) Related post(s): Handling JPEG metadata with PHP (11.5) Modify a comment in a JPEG image (8.75) JPEG pictures can carry viruses (6.95) Converting an Image to standalone SVG (6.10) CSS to style images (5.91) Related tags(s): projects, mozilla, creative_commons, moblog, government Comments (2) Permalink del.icio.us 14. December 2004 PECL Bit Torrent PHP (wiki) - urs @ 09:42:14 Just came along http://pecl.php.net/File_Bittorrent ;) Related post(s): Wyona Pictures presents FUD (6.81) PECL dll files for Windows (6.71) PECL binaries for Windows (6.50) PECL Tidy extension for Windows (4.98) PECL extension for SQLite database (4.85) Related tags(s): culture, xml, deutsch, php, open_source Comments (0) Permalink del.icio.us 03. December 2004 Standalone PHP script viewer for Win32 PHP (wiki) - urs @ 09:51:13 Daaron Dwyer writes: You blogged about my ScriptViewer (PHP without a dedicated web server) app many many moons ago, and I have updated it recently. Oh, I am a "moons away" blogger. So here we go [1]. [1] http://www.angorasoftware.com/scriptviewer.html Related post(s): Standalone PHP viewer for Win32 V.1.4.5 released (16.3) Standalone PHP viewer for Win32 V.1.4.6 released (16.3) Standalone PHP viewer for Win32 (12.9) Converting an Image to standalone SVG (8.42) Converting an Image to standalone SVG (8.08) Related tags(s): open_source, content_management, mozilla, database, java Comments (0) Permalink del.icio.us 25. November 2004 Atom enabled Weblog in PHP PHP (wiki) \| Weblog (wiki) \| XML (wiki) - urs @ 18:05:31 Yoan Blanc has worked out a fully functional Atom based weblog tool [1]. This project is a school essay about dealing with atom format, HTTP request and XSL transformation. The code is available under the GPL license. Let's hope this will ignite some further implementations. Yoan also has a short presentation available [2]. [1] http://atom.dosimple.ch [2] http://atom.dosimple.ch/docs/pres/ Related post(s): Gmail with Atom feed (7.47) Going LOTS or an experiment in ridiculously easy group forming (7.27) Echo/Atom/Pie 0.2 feed available (7.04) Nokia 6600 to blog via Atom API (6.33) Using Atom as common transport and storage format for Blogs and Wikis (5.99) Related tags(s): mozilla, creative_commons, government, open_source Comments (0) Permalink del.icio.us 18. November 2004 Gmail photo album PHP (wiki) - urs @ 15:21:14 Yet another gmail [1] application, which is called goollery: Goollery is a GMail based photo gallery. You can upload pictures from a website. The pictures will automatically be stored in your gmail accout. Via David Duret [2] [1] http://www.wirzm.ch/goollery/about/about.php [2] http://pilgrim.maleo.net/archives/2004/11/18/gmail-antispam-en-ligne/ Related post(s): Lockdown in sector 4 (9.07) Froogle glued to Gmail (8.73) GmailFS - Gmail Filesystem (8.18) Gmail with Atom feed (8.17) Gmail as a blog engine (7.20) Related tags(s): software, xml, open_source, weblog Comments (0) Permalink del.icio.us 07. November 2004 PHP5 on OSX PHP (wiki) \| Apple (wiki) - urs @ 21:46:29 Marc [1] is doing a great job to get PHP5 as easy as possible on OSX. [1] http://www.entropy.ch/home/000012.html Related post(s): A PHP5 preview documentation (6.78) PHP5 CGI parallel to PHP4 module on Windows (6.65) PHP5 binaries for Windows (6.56) Build instructions for PHP5 on Windows (6.46) PHP5 and namespaces (5.78) Related tags(s): php, apache, weblog, xml, open_source Comments (0) Permalink del.icio.us 05. November 2004 Bitflux is hiring PHP (wiki) \| Open Source (wiki) \| Economy (wiki) \| XML (wiki) \| Content Management (wiki) - urs @ 10:09:49 chregu [1] of Bitflux GmbH is looking for a developer with strong skills in XSLT and PHP. Bitflux has strong competences in realizing custom client projects while mostly using their own Bitflux CMS (BxCMS). An other interesting product is their Bitflux Editor, a Wysiwyg XML Editor. Most if not all of their tools are Open Source. [1] http://blog.bitflux.ch/archive/work-at-bitflux.html Related post(s): Liip is hiring - again, again, more and more (8.17) DeLaRue is hiring (7.62) Donate! - to get an exciting WYSIWYG editor GPLd (6.66) Bitflux CMS is said to run on Windws (6.37) Google in Zürich is hiring (6.34) Related tags(s): economy, xml, best_of, deutsch, technology_transfer Comments (0) Permalink del.icio.us 20. October 2004 Cropping, rotating and resizing images in Wordpress PHP (wiki) \| Weblog (wiki) - urs @ 12:42:41 Some month ago I implemented a PHP script [1] to handle images that I integrated into the "Manage" respectively "Edit" menu in Wordpress. The script allows images located in a certain directory to be rotated, resized and cropped. The cropping is based on a library provided by Walter Zorn, whom I mentioned earlier this year already. A PHP script building a cropping interface around that library can be found at amunts.com [3]. The script discussed here is an updated version (added cropping) of what I posted in March [4]. Use it or leave it! ;-) [1] http://www.circle.ch/php/files/edit-images.phps [2] http://www.walterzorn.com/dragdrop/dragdrop_e.htm [3] http://php.amnuts.com/index.php?do=view&id=12 [4] http://www.circle.ch/blog/p1371.html Related post(s): HTMLarea with enhanced Image Handler (9.78) Image Handler for Wordpress (8.99) WordPress CSS Style Competition (7.11) Multi-user blog, pictures handling and PDF generation with Wordpress (6.87) Atom 0.1 feed generator for Wordpress (6.77) Related tags(s): intellectual_property, mozilla, creative_commons, law, wireless_and_mobile Comments (0) Permalink del.icio.us 19. October 2004 Outlook to iCal export PHP (wiki) - urs @ 10:17:27 phpicalendar [1] is a PHP tool that parses ics files. Norm Jones [2,3] wrote a script that converts Outlook calendar items to iCal files which are easy to spread among a group with phpicalendar: The outlook2ical utility is a VB macro that can be used to export a set of appointments from an Outlook Calendar to the iCal format. The end result is a .ics file. My motivation for developing this macro is that I am not happy with the "Save As Web Page" option in Outlook. The main problem is that it saves all appointments associated with an Outlook calendar. I would like to only export appointments of a selected category or categories. I also wanted to be able to view the exported calendar using PHP-iCalendar, which has a far superior appearance when viewed on the web. [1] http://phpicalendar.sf.net [2] http://www2.et.byu.edu/~njones/share/outlook2ical/ [3] http://phpicalendar.net/forums/viewtopic.php?t=492 Update: Have a look at other tools: http://circle.ch/wiki/CalendarTools Related post(s): Import Outlook calendar items into iCal (12.5) tel.search.ch with vCard export (9.16) Open Source Outlook MAPI connecter available (6.90) NeoOffice/J 0.7 with PDF export (6.22) Outlook calendar to RSS (5.17) Related tags(s): open_source, content_management, software, technology, mozilla Comments (4) Permalink del.icio.us 18. October 2004 W3C link checker* PHP (wiki) - urs @ 21:17:14 (Re)found a comfy tool to check an HTML file for valid links [1]. Thanks to W3C who offers it as an online service. I am wondering, if there is a comparable PHP implementation to work locally since I am not sure, if the PEAR HTTP_Client_LinkChecker is effectively is an equivalent or at least a starting point [2]. [1] http://validator.w3.org/checklink [2] http://www.phpkitchen.com/viewableCode/linkchecker.phps Related post(s): Error page 404 and RSS autodiscovery (4.49) PHP-XML related link repository (4.36) Tagging for lots.ch (4.34) Link-back URL Regarding The Attribution Option In Licenses (3.83) Without any words... (3.76) Related tags(s): php, rant, technology, random_thought, java Comments (0) Permalink del.icio.us 17. October 2004 Rewrite of captcha-like feature PHP (wiki) \| Weblog (wiki) - urs @ 20:31:27 The captcha-like [1] feature on behalf of the blog comments for this weblog has been rewritten. If it does not work for you as expected, please let me know. The feature is based on a completely homegrown implementation written in PHP and adopted to b2/cafelog. If you like something similar then you might like to have a look at the PEAR captcha package [2]. [1] http://en.wikipedia.org/wiki/Captcha [2] http://pear.php.net/pepr/pepr-proposal-show.php?id=80 Related post(s): reCAPTCHA - avoid spam (7.94) XML Tutorial on webreview.com (4.76) tel.search.ch with vCard export (4.72) Undocumented feature in trim() (4.45) Adds disturbing the Blog frontpage (4.12) Related tags(s): php, economy, social_network, rant Comments (0) Permalink del.icio.us 12. September 2004 Gmail as a blog engine PHP (wiki) \| Weblog (wiki) - urs @ 17:09:09 Jonathan Hernandez [1] wrote a PHP application that converts Gmail messages to blog entries, where the messages are signed with a star. Replies to conversations are converted to blog comments. The scripts are licensed under GPL. Some more Gmail related projects are linked in my wiki under GmailFS. [1] http://ion.gluch.org.mx/files/Hacks/gallina/ Related post(s): Lockdown in sector 4 (9.49) Froogle glued to Gmail (8.73) GmailFS - Gmail Filesystem (8.64) Gmail with Atom feed (8.63) Gmail photo album (8.32) Related tags(s): technology, howto, wiki, law Comments (2) Permalink del.icio.us 15. August 2004 Designing labels with SVG and convert them to PDF with PHP PHP (wiki) \| Open Source (wiki) \| XML (wiki) - urs @ 13:36:20 Alan Knowles [1] described the process of designing labels with SVG and the conversion to PDF with PHP last December. There he points to an SVG editor called Sodipodi [2]. Inkscape [3] is yet another SVG editor running on various platforms [3]. Designing labes with SVG seems a reasonable approach. As Alan states correctly, the FPDF [http://fpdf.org ] is quite a nice library for creating PDFs, however, the thought of hardcoding up all the locations in PHP, for all the text on both applications horrified me. That is how we implemented our label printing system for LOTS 2004. Positioning a few lines of text and an image is easily done with FDPF for "design once, use many" labels. [1] http://blog.akbkhome.com/blog/archives/26_PHP_SVG_and_PDFs.html [2] http://www.sodipodi.com [3] http://www.circle.ch/blog/p1396.html Related post(s): HTML To PDF Conversion with PHP (4.08) How to OCR multipage PDF files (4.03) PPT2XML conversion II (3.96) XML Spy 4.0b1 has been released (3.92) Multi-user blog, pictures handling and PDF generation with Wordpress (3.36) Related tags(s): content_management, software, apple, creative_commons Comments (0) Permalink del.icio.us 09. August 2004 Minimalistic CMS PHP (wiki) \| Content Management (wiki) - urs @ 14:40:13 Edit This Page PHP [1] is a PHP script that can be uploaded to any webhost that supports PHP. It allows for the HTML content of a page to be edited by a link on that page. Only two files are required: the core PHP script (editthispage.php) and a data file for each page. The core file can support as many pages as desired. Get more background information on that lightweight Wiki from Christopher Allen [2], one of its authors. [1] http://editthispagephp.sourceforge.net [2] http://www.lifewithalacrity.com/2003/12/editthispagephp.html Comments (0) Permalink del.icio.us 30. July 2004 Fulltext search in PHP files on Windows PHP (wiki) - urs @ 15:49:11 Mark [1] pointed out a way to let the standard Windows search engine search through php files; for those not using find, grep et. al. ;-) [1] http://weblogtoolscollection.com/?p=464 Related post(s): TagCloud to analyze my blog (9.09) Related posts on b2/cafelog (8.04) FULLTEXT searching with MySQL (7.71) Access to Desktop Search results (7.61) tel.search.ch with vCard export (6.39) Related tags(s): database, art, search, linux, civil_society Comments (0) Permalink del.icio.us 26. July 2004 PHP on Symbian? PHP (wiki) \| Wireless and Mobile (wiki) - urs @ 23:13:33 The question has been asked already [1] but what I can see has been left un-answered. Has there anyone some news on that topic? [1] http://groups.google.ch/groups?selm=b4g8vt%24jbq%241%40FreeBSD.csie.NCTU.edu.tw Related post(s): Webserver for Symbian phones (8.41) p2p - tiny code on mobiles to share anywhere (4.45) Locative Technology on Nokia Series 60 phones (3.02) QR coded blog entries (2.10) Related tags(s): technology, p2p, drm, geodata, wireless_and_mobile Comments (1) Permalink del.icio.us 07. July 2004 Livesearch - let's talk about usability PHP (wiki) \| Weblog (wiki) - urs @ 21:27:17 With some Javascript and PHP Chregu Stocker implemented a feature to his blog search that I have only seen on the X1 search engine [1] for Windows so far; he calls it Livesearch [2]. While typing a word into the form field, a list of results refined by each letter gets displayed below. Really uebergeil. [1] http://www.x1.com [2] http://blog.bitflux.ch/p1736.html Related post(s): Searching Wikipedia content à la LiveSearch (8.32) Reenabled LiveSearch (7.65) Google search plugin based on XMLHttpRequest? (6.37) Zend and Extending PHP (5.60) Megapixel camera phones (4.80) Related tags(s): wiki, random_thought, php, social_network, creative_commons Comments (0) Permalink del.icio.us 06. June 2004 Single-file PHP Auth class PHP (wiki) - urs @ 22:03:06 I got an email from Lucas Carlson, the author of PHP Auth [1], asking me to blog something about this class. The authentication class viewed from its usage looks quite similar to the PEAR Auth class. Lucas' class is focused on database containers as far as I can see. What I first saw at Paul M. Jones DB_Table class, is now also to be used in this class; defining a table directly in the PHP code. It looks kind of complex at first sight but is actually very simple to handle from my point of view. http://phpauth.sourceforge.net Related post(s): File Upload with PEAR (10.4) How to OCR multipage PDF files (7.44) Authentication with PEAR Auth (6.69) news on your website (6.54) New file upload script based on PHP PEAR class. (6.47) Related tags(s): open_source, random_thought, crosspost, wireless_and_mobile, drm Comments (0) Permalink del.icio.us 02. June 2004 PEAR XML_FOAF package PHP (wiki) \| XML (wiki) \| Social Network (wiki) - urs @ 22:25:09 Daniel O'Conner [1] pointed out in a comment [2] on this blog, that PEAR now has a FOAF package to offer [3]. [1] http://my.opera.com/CloCkWeRX/journal/39 [2] http://www.circle.ch/blog/p909.html [3] http://pear.php.net/package/XML_FOAF/ Related post(s): Another view on PEAR (8.56) Bytecode compiler for PHP scripts (8.21) Wiki parser in PEAR (7.64) SMS package for PEAR (6.68) PEAR version 1.2 RC1 released (6.51) Related tags(s): php, wireless_and_mobile, weblog, xml, moblog Comments (0) Permalink del.icio.us 19. May 2004 PHP Layers Menu - dynamic menu trees PHP (wiki) - urs @ 09:57:01 PHP Layers Menu [1] is a Javascript-based hierarchical dynamic menu system to rapidly choose among the items.It provides also JavaScript-based tree menus, whose nodes can be expanded and collapsed on sufficiently DOM-compliant browsers. Probably good news for those, seeking a navigation for a structured CMS. [1] http://phplayersmenu.sourceforge.net Update: Just found another DHTML menu on sourceforge: http://xmenu-xlayer.sourceforge.net Related post(s): menu im du nord (13.4) Nested menu with Flash on sourceforge.net (11.2) Cascading menu in skinable Javascript (10.6) See cascading button menu in action! (10.1) new trees at the university (9.31) Related tags(s): moblog, technology, open_source, economy Comments (0) Permalink del.icio.us 10. May 2004 DB_Table - working differently with Tables and Forms PHP (wiki) - urs @ 17:15:22 I recently decided to dive into Paul M. Jones' DB_Table class [1] - now officially available through PEAR - to get a clear view on what this is about. The most odd thing for me was the fact, that you do no longer create tables directly e.g. MySQL but define colums, indexes and - pretty cool - selects in advance, which means, directly within your PHP script. What it does; it creates a defined table at first run if there is no such table yet in the database. Paul explains in small steps how you could build a guestbook with it. One of the nice parts of DB_Table is the ready-to-use QuickForm configuration. While defining a column for the table you give additional QuickForm information to that regarding that certain field. Building forms is therefore quite easy. ThanQ Paul for those contributions. [1] http://wiki.ciaweb.net/yawiki/index.php?area=DB_Table Related post(s): PHP Formmail to handle forms easily (6.50) Single-file PHP Auth class (4.40) Get a complete working back-end! (4.27) Collaborative Events handling with a Wiki (4.26) PEAR table.php tutorial (4.18) Related tags(s): wiki, content_management, database, open_source Comments (0) Permalink del.icio.us 27. March 2004 De- and encoding Base64, UUEncoding, XXEncoding and Yenc files with PHP PHP (wiki) - urs @ 13:55:07 Stéphane Degré and Renaud Hager [1] have implemented an encoder and decoder extension for PHP to handle Base64, UUEncoding, XXEncoding and Yenc encoding. [1] http://php-attcodec.sourceforge.net Related post(s): Converting an Image to standalone SVG (6.84) How to OCR multipage PDF files (3.99) phpChannel to handle RSS files (3.87) Personalizing PDF files (3.70) Getting all installation files for IE6 SP1 (3.61) Related tags(s): projects, apple, software, media, random_thought Comments (0) Permalink del.icio.us 24. March 2004 Apache2 with PHP5 CGI and PHP4 module on OS X PHP (wiki) \| Apache (wiki) - urs @ 15:15:30 Looking at the configuration now looks like it was a job at ease; but it took me some hours to work properly. PHP is now working in two versions in parallel on Apache2 on OS X 10.3.3. I will show you the configurations for the compilation first. Firstly, there is the configuration for PHP 4.3.4: #:~/src/php-4.3.4 urs$ ./configure \ --disable-cgi \ --disable-pdo \ --enable-force-cgi-redirect \ --prefix=/usr/local/php \ --with-zlib \ --with-iconv=/sw/ \ --without-bundle-libxml \ --with-dom=/sw/ \ --with-libxml-dir=/sw/ \ --with-xsl=/sw/ \ --disable-pear \ --with-gd \ --with-freetype-dir=/sw/lib/freetype2/ \ --with-jpeg-dir=/sw/ \ --with-png-dir=/sw/ \ --enable-sockets \ --enable-pcntl \ --enable-shmop \ --enable-sysvshm \ --enable-sysvsem \ --with-mysql=/usr/local/mysql/ \ --enable-debug \ --with-apxs2=/usr/local/apache2/bin/apxs \ --with-config-file-path=/usr/local/php \ --with-config-file=/usr/local/php/php.ini As below, this is what you can type to get PHP 5.0.0 RC1: #:~/src/php-5.0.0RC1 urs$ ./configure \ --enable-force-cgi-redirect \ --prefix=/usr/local/php5-cgi \ --with-zlib \ --with-iconv=/sw/ \ --without-bundle-libxml \ --with-dom=/sw/ \ --with-libxml-dir=/sw/ \ --with-xsl=/sw/ \ --disable-pear \ --with-gd \ --with-freetype-dir=/sw/lib/freetype2/ \ --with-jpeg-dir=/sw/ \ --with-png-dir=/sw/ \ --with-mysql=/usr/local/mysql/ \ --enable-debug \ --with-config-file-path=/usr/local/php5-cgi \ --with-config-file=/usr/local/php5-cgi/php.ini I have chose specific configuration paths for each version. As far as I can see, you need to give the path and the filename as well. Especially for the CGI version, you should specify the option --enable-force-cgi-redirect. Now the tricky part was to get a working configuration for the virtual hosts. The idea behind is to have a PHP 4 module installed as default and a per-virtual-host-configuration for other versions of PHP; that might be PHP 5 or 3. So on port 86 php scripts will be processed by PHP 5.0.0 RC1. Listen 86 <VirtualHost _default_:86> ServerName localhost ScriptAlias /php5 /usr/local/php5-cgi/bin/ <Directory /usr/local/php5-cgi/bin/> Options +ExecCGI +FollowSymLinks AllowOverride None </Directory> DocumentRoot /Library/Webserver/Documents/project-a <Directory /Library/Webserver/Documents/project-a> DirectoryIndex index.php Options Includes Indexes FollowSymLinks MultiViews AllowOverride None Options FileInfo Action php5-cgi /php5/php AddHandler php5-cgi .php .php5 </Directory> ErrorLog logs/default_86-error_log CustomLog logs/default_86-access_log combined </VirtualHost> <VirtualHost > LoadModule php4_module modules/libphp4.so AddType application/x-httpd-php .php AddType application/x-httpd-php-source .phps DocumentRoot /Library/Webserver/ <Directory /Library/Webserver/> DirectoryIndex index.php Options Includes Indexes FollowSymLinks MultiViews AllowOverride None Options FileInfo </Directory> </VirtualHost> I collected various links and jotted down some eventually interesting information in the (Wiki/PHP5). Related post(s): PHP5 CGI parallel to PHP4 module on Windows (13.7) PHP4 libplot extension module (8.00) mod_auth_sqlite released (7.10) multimedia.uni-greifswald.de/~php4/ (7.08) A PHP5 preview documentation (6.78) Related tags(s): apache, php, technology, software Comments (2) Permalink del.icio.us 22. March 2004 Image cropping with PHP and Javascript* PHP (wiki) \| Weblog (wiki) - urs @ 11:39:51 By far, this is some of the most valuable javascript code I have seen for a while. Walter Zorn has written various libraries to drag & drop [1] layers and also to draw graphics [2] with javascript. At least the jsgraphics library is published under GPL; for the others I would propose to visit the website of Walter and ask himself regarding license question. The image above show the result of an implementation of one library together with some PHP image handling which was done by Andrew Collington [3]. It was very easy to implement it into my Wordpress Image Handler. [1] http://www.walterzorn.com/dragdrop/dragdrop_e.htm [2] http://www.walterzorn.com/jsgraphics/jsgraphics_e.htm [3] http://www.zend.com/codex.php?id=1340&single=1 Related post(s): Cropping, rotating and resizing images in Wordpress (8.83) HTMLarea with enhanced Image Handler (4.81) Playing with Qemu (4.81) Converting an Image to standalone SVG (4.68) Fugu (4.61) Related tags(s): random_thought, projects, creative_commons, deutsch, government Comments (5) Permalink del.icio.us 21. March 2004 PHP5 CGI parallel to PHP4 module on Windows PHP (wiki) - urs @ 15:38:05 I was looking for a way to have both PHP4 and PHP5 running on Windows. So there was a bit of adaption of the note made by seric [1] to the Windows environment (Installation/PHP5). PHP4 still works as Apache module while PHP5 runs as CGI on a port-based virtual host: Listen 83 <Virtualhost _default_:83> ServerName localhost ServerAdmin me@localhost DirectoryIndex index.html index.php ErrorLog logs/error.log # http://httpd.apache.org/docs-2.1/mod/core.html.en#limit <Location /> <Limit CONNECT> Order allow,deny Allow from all </Limit> </Location> DocumentRoot "C:/www/project-a/" ScriptAlias /cgi-bin/ "C:/php5/" Action php5-script /cgi-bin/php-cgi.exe AddHandler php5-script .php .html </Virtualhost> The downloaded PHP 5.0.0RC1 zip package has been unpacked to c:\php5. Then I renamed the php.ini-dist to php.ini and restarted Apache. [1] http://seric.cowiki.org/17.html Related post(s): PHP5 binaries for Windows (9.61) Apache2 with PHP5 CGI and PHP4 module on OS X (9.43) Daily PHP4 builds for Windows (8.25) Build instructions for PHP5 on Windows (8.24) PHP4 libplot extension module (8.00) Related tags(s): php, open_content, content_management, apple Comments (0) Permalink del.icio.us 16. March 2004 Just no win-win situation PHP (wiki) \| Apple (wiki) \| Linux (wiki) - urs @ 21:24:46 Yesterday I moved a PHP project from Windows to OS X. For reasons of laziness I often code something like: if (stristr(PHP_OS, "WIN")) { echo "Do something Windows-related here..."; } This worked usually perfect for scripts moved between Windows and Linux based systems. But one has to be more precise for scripts to run additionally on OS X. Since OS X comes with a PHP_OS string consisting of "Darwin". If you are wondering, why your scripts do not work on Mac try this: if (stristr(PHP_OS, "Windows")) { echo "Do something Windows-related here..."; } Related post(s): Total Information Awareness (2.80) Eventually dropped your mail (2.68) How to walk back N directories (2.58) Sony Ericsson Z520i sync with Google Calendar (2.23) Open Communities Projekt - oc4 (2.15) Related tags(s): law, social_network, technology, php, wireless_and_mobile Comments (0) Permalink del.icio.us A Wiki Blog joint-venture by Elke PHP (wiki) \| Weblog (wiki) \| Wiki (wiki) - urs @ 00:23:27 Elke Engel [1] showed up a working demo [2] of an interoperable Wiki-Blog the other day. The system is based on the Kaywa blog and uses the PEAR class by Paul M. Jones [3] to handle the Wiki syntax. Good look with finishing up your thesis ;) [1] http://purplegreen.abstrakt.ch/blog/archives/000214.html [2] http://engelwiki.var.cc [3] http://wiki.ciaweb.net/view.php?wiki=Text_Wiki Related post(s): Microsoft dives into RFID (7.19) To Trackback a Wiki page (5.57) Open Wiki for IIS (5.47) Using Atom as common transport and storage format for Blogs and Wikis (5.32) Blog, wiki et al. as lightweight tools for successful projects (4.70) Related tags(s): wiki, java, podcast, open_content, open_source Comments (1) Permalink del.icio.us 14. March 2004 Image Handler for Wordpress PHP (wiki) \| Weblog (wiki) - urs @ 17:05:58 The other day I was just fed up using the ftp client to clean up a mal-orientated image. So here is a basically stand-alone script [1] to treat (rotate, resize, delete) images used e.g. with Wordpress [2]. The PHP based script requires either the GD 2.0, Imagemagick or PHP ext/imagick to be installed. PEAR Image_Transform is an option as well, but not necessary. The script has been tested on Windows as on Debian. You can copy it to wp-admin and configure your base directory where you keep your images. [1] http://www.circle.ch/php/files/edit-images.php.html [2] http://www.wordpress.org Related post(s): Image cropping with PHP and Javascript (13.6) HTMLarea with enhanced Image Handler (12.5) WordPress CSS Style Competition (7.11) Atom 0.1 feed generator for Wordpress (6.77) WYSIWYG Plugin for Wordpress (6.67) Related tags(s): intellectual_property, weblog, culture, projects, creative_commons Comments (0) Permalink del.icio.us 11. March 2004 How to walk back N directories PHP (wiki) - urs @ 02:23:27 While scanning a directory tree I run into the following situation; Consider you have the following three paths: - /home/project/user/www/ (web root folder ) - /home/project/user/www/images (folder for images ) - /home/project/user/www/include/dummy/script.php (script to handle images ) The problem was, that the function to scan the images folder (tree) in script.php did not handle absolute path properly (access rights?). So I was looking for a solution to give the relative path from the working directory of script.php back to the absolute path. The following few lines in PHP did it quite well: $p1 = substr_count(realpath(ABSPATH), DIRECTORY_SEPARATOR); $p2 = substr_count(realpath(dirname(__FILE__)), DIRECTORY_SEPARATOR); for($j=0;$j< ($p2-$p1);$j++) $ret .= "../"; echo $relative_path = $ret . ltrim($image_base_dir, DIRECTORY_SEPARATOR); A possible result would be "../../images", while $image_base_dir is set to "images". Eventually I missed a simple function this topic easier, if so, let me know ;-) Related post(s): FOAF walk on semaview (6.31) Get a complete working back-end! (5.98) back at work (4.97) get that stuff back (4.94) dani back from canada (4.86) Related tags(s): economy, travelling, humor, random_thought, civil_society Comments (0) Permalink del.icio.us 06. March 2004 HTMLarea with enhanced Image Handler PHP (wiki) - urs @ 14:28:44 HTMLarea has an enhanced Image Handler written by Wei Zhuo [1]. It is based on PHP and uses GD or Imagemagick. It is not quite clear under which license the code is published; The HTMLarea itself is available under a BSD-like license. The Image Handler allows to upload and treat images such as rotating, resizing etc. It runs as well under Mozilla as IE. A modified version is available for Coldfusion [2]. [1] http://www.zhuo.org/htmlarea/?view=flat [2] http://huizen.ddsw.nl/bewoners/slopera/projects/projects.htm Related post(s): Image cropping with PHP and Javascript (11.1) Image Handler for Wordpress (10.2) HTMLArea 3.0 alpha - Mozilla and IE compatible (6.29) Enhanced ODBC driver for MySQL released (5.70) Kodiak - Island of the bears (5.25) Related tags(s): open_source, culture, random_thought, projects, creative_commons Comments (0) Permalink del.icio.us 04. March 2004 Japha - expandable implementation of Java in PHP PHP (wiki) \| Open Source (wiki) - urs @ 10:37:34 Java to be used within PHP often is painful. So, Japha [1] is an attempt to bring the main classes in the Java 1.4.1 (soon to be 1.4.2, time allowing) to PHP for use in everyday programs. Japha refers to PHP 5. This allows us to easily implement interface, abstract classes, and more inheritance capabilities, not to mention excellent error handling and the ability to better conform with user-created data types. [1] http://japha.xzon.net Related post(s): Playing Skip-bo over the Network (7.05) Sun will support PHP in Java (5.95) Top Ten Java and XSLT Tips (5.95) Java2 Standard Edition Version 1.3 RC1 (5.95) QR code - decoder to proof the concept (5.69) Related tags(s): wiki, apple, random_thought, geodata, java Comments (2) Permalink del.icio.us foresite PRS - a GPL Project Reporting System PHP (wiki) \| Open Source (wiki) - urs @ 09:53:42 foresite Systems [1] has released its first package under GPL. The foresite PRS is a PHP based Project Reporting System. On OS X you have to give as well to give some rights: mojito:~/foresitePRS urs$ chmod 0777 config/prs.ini mojito:~/foresitePRS urs$ chmod 0777 lang/lang_cache.txt mojito:~/foresitePRS urs$ sudo find . -name "init.sql" ./config/init.sql You will be pointed to an installation routine. The installation process indicated that the init.sql could not be found. If this is the case just upload the init.sql from the config/ folder with e.g. phpMyAdmin. Nice work of the foresite Programmers. [1] http://foresite.ch/Download.html Related post(s): foresite CMS - workshop (10.6) Ganttproject - Open source project management (6.17) Wyona XPS Content Management (5.46) AGNULA - A GNU/Linux Audio distribution (5.46) Sharing folders with VirtualBox (4.74) Related tags(s): mozilla, moblog, php, open_source, wiki Comments (1) Permalink del.icio.us 27. February 2004 [RT] Handling SQLite remote files with PHP PHP (wiki) \| Open Source (wiki) \| Wiki (wiki) \| Random Thought (wiki) - urs @ 10:38:28 First I have to clarify the [RT]; Bertrand Delacrétaz [1] mentioned at LOTS, that he indicates "random thoughts" in mailinglists as "[RT]". I like that idea, because the title to this blog post does not mean to be a new feature in the PECL sqlite extension but generally a random thought of mine. I started a new project on sourceforge called wikita [2]. It is a common playground for me to set up a simple wiki based on PEAR classes where ever possible. Since I have started the PEAR sqlite DB wrapper earlier, it needed some more testing. Wikita from that point of view is also a testbed for this wrapper. Just the other day I checked in some code into the CVS of sourceforge. The code is not much more than a hack for now. Anyway. To come to the point of this post: SF does not yet support the sqlite extension. So the title here suggests that there could/should be a way to handle sqlite remote database files. PHP does allow to handle remote files but IMHO the sqlite extension does not. If this is secure or not is to discuss afterwards. PHP5 will generally offer sqlite support. Nevertheless I ask myself if there are any applications that would make sense to have sqlite databases handled remotely. Maybe for portable devices such as mobile phones or handhelds, if they ever offer PHP support (some actually _do_ offer already Python [3]). Since they offer limited storage space, it could be a solution. Contradictions, comments? [1] http://codeconsult.ch/bertrand/ [2] http://sourceforge.net/projects/wikita [3] http://www.mobilewhack.com/programming/python/python_on_nokia_screenshots.html Related post(s): SQLite wrapper for PEAR:DB (10.0) PECL SQLite installation (9.66) SQLite - Embeddable SQL Database Engine (8.50) PECL extension for SQLite database (8.33) SQLite running as Client/Server (8.27) Related tags(s): technology, open_source, database, privacy, php Comments (1) Permalink del.icio.us 26. February 2004 Sleepycat DB XML 1.2.1 with PHP API PHP (wiki) \| XML (wiki) - urs @ 13:40:50 The new DB XML offers now a PHP API: Sleepycat Software is pleased to announce the release of Berkeley DB XML version 1.2.1! DB XML 1.2.1 is a maintenance/bug fix release. New Features A PHP API has been added to the distribution. This is a preliminary release of this functionality. For details please see the src/php4/README file contained in the distribution. [1] http://www.merrells.com/john/dbxml/archives/cat_release_history.html#000229 Related post(s): Syncato - weblog based on Python and Berkeley DB XML (4.44) Related tags(s): xml, weblog Comments (0) Permalink del.icio.us 24. February 2004 Andi Gutmans on the PHP5 final release schedule PHP (wiki) - urs @ 00:21:11 Regarding the scheduled release of PHP5 final Andi said: Rob: How much time we looking at between RC1 and a final release? Andi: I'd guesstimate a couple of months, around May. Guess-timate; I always wondered how they scheduled releases... ;-P [1] http://marc.theaimsgroup.com/?l=php-cvs&m=107752000920056&w=2 Related post(s): Andi Gutmans and "How-to-pass-by-reference" (15.6) KDE 2.0 Final Released! (7.09) A PHP5 preview documentation (6.78) PHP5 CGI parallel to PHP4 module on Windows (6.65) PHP5 binaries for Windows (6.56) Related tags(s): weblog, economy, technology, apache, php Comments (0) Permalink del.icio.us 28. January 2004 SqliteManager for your Browser PHP (wiki) \| Open Source (wiki) - urs @ 01:00:42 SQLiteManager [1] is what I was looking for; a phpMyAdmin-like administration tool for the browser. It basically works out of the box. Thanks to Frédéric Henninot. [1] http://sqlitemanager.sourceforge.net Update: There are some fixes I had to add to make it running on OS X: Changed the file: common.lib.php, function SQLIteCheckOk() if($SQL_SERVER_OS == "LIN" OR $SQL_SERVER_OS == "DAR") $extName = "sqlite.so"; Furthermore the folder and its files did not have the correct owner which generated the following message: Warning: sqlite_query(): unable to open database file in /Library/WebServer/Documents/SQLiteManager-0.9.1/include/SQLiteDbConnect.class.php on line 122 So changing the owner fixed that problem too: #:/Library/WebServer/Documents me$ sudo chown -R www:www SQLiteManager-0.9.1/ Update: Just found another SQLite web manager. This one requires PHP5: http://www.phpro.org/sqlite/ Related post(s): Xopus - Online In-Browser XML Editor (4.90) Cross-browser DHTML (4.77) Ever used a "text-based" browser? (4.69) Mozile - Mozilla Inline Editor (4.63) Phoenix all-the-best-out-of-mozilla browser? (4.43) Related tags(s): mozilla, technology, open_source, weblog Comments (0) Permalink del.icio.us 06. January 2004 PHP and Web Standards Conference UK 2004 PHP (wiki) - urs @ 08:16:47 he PHP and Web Standards (PaWS) Conference [1] is designed to cater to long-suffering UK PHP and Web developers, who until now have had to travel abroad to learn in person. With the help of Mark Leavy and the input of many members of the PHP community, we're bringing some of the finest talents in PHP and Web standards right here to Manchester. [1] http://pawscon.com Related post(s): More than just DocBook (6.90) PHP Conference 2001 opened in Frankfurt, Germany (5.90) Moblogging Conference pictures (5.78) XSLT-UK conference 2001 (5.40) Call for papers - PHP Conference 2002, Frankfurt (5.06) Related tags(s): culture, government, politics, talks Comments (0) Permalink del.icio.us 11. December 2003 Wiki parser in PEAR PHP (wiki) \| Wiki (wiki) - urs @ 20:08:10 Paul M Jones [1] finally comes up with a Wiki parser in PEAR [2] parsing from the default markup style (combined from WikkiTikkiTavi and coWiki) to render into XHTML. [1] http://ciaweb.net/free/textwiki.php [2] http://pear.php.net/package/Text_Wiki Related post(s): A Wiki Blog joint-venture by Elke (7.55) PEAR installation on Windows from scratch (6.34) PEAR Out of Beta (6.28) PEAR 1.0 is released! (6.18) Work on go-pear for Windows (6.02) Related tags(s): weblog, php, technology, wiki, moblog Comments (0) Permalink del.icio.us 23. October 2003 SMS package for PEAR PHP (wiki) \| Wireless and Mobile (wiki) - urs @ 10:40:49 Tobias Schlitt [1] proposed a new packe for PEAR. It allows to handle SMS (short message service) with a PHP CLI interface through a connected mobile phone. As seen at the ITU Swisscom offers now a new Outlook plugin called "Desktop SMS" [2]. Since they shut down the free SMS service on gomobile.ch one needs to pay for each message now. [1] news.php.net [2] http://www.swisscom-mobile.ch/sp/UEOAAAAA-de.html Related post(s): PEAR XML_FOAF package (9.91) Another view on PEAR (8.56) Bytecode compiler for PHP scripts (8.21) Wiki parser in PEAR (7.64) PEAR version 1.2 RC1 released (6.51) Related tags(s): social_network, php, weblog, xml, moblog Comments (1) Permalink del.icio.us 17. October 2003 Bayesian Filtering of Spam PHP (wiki) \| Weblog (wiki) \| Technology (wiki) - urs @ 07:54:23 The hit rate of this blog is now about 3 per day: I am talking about comment spam. This is no fun at all. I intended to turn off the back-channels like comments and trackback eventually pingback too. But that is no fun. So I started to look around for spam blocking solutions. Beside blacklists - mentioned earlier here - BayesianClassification caught my eyes. So I added a new wiki page to have some starting point. Also most solutions are intended to fight email spam there could be a combination with blacklists I guess. There is currently no PHP implementation so I started to convert the C implementation of Paul Graham's "A Plan for Spam" [1] by Craig Morrison [2]. Unfortunately I got stuck because the PECL sqlite extension does not yet include the sqlite_compile and sqlite_step functions which are used in Craig's version to do some fun stuff with SQLite: sqlite_compile() is used as a precursor to sqlite_step(). It takes an SQL statement and "compiles" it into a VM (virtual machine) that sqlite uses for each successive call to sqlite_step(). What it does is allow me to query a database without using a callback function. Each call to sqlite_step() returns the next row in the result set from the initial sqlite_compile() call. I needed to do that, because I have to do lookups in the same database and I could not do those lookups recursively inside the callback which would be needed when using sqlite_exec(). The use of the virtual machines allows me to maintain a seperate state for each lookup that I need to do. Craig was answering me via email as I asked him if there is a possible workaround to come along without the mentioned functions. Thanks to Craig. [1] http://www.paulgraham.com/spam.html [2] http://sourceforge.net/projects/bayesiancfilter Related post(s): PHP Naive Bayesian Filter against Spam (13.3) Spam filter for Outlook 2000 and 2002 (12.4) Bayesian Filtering of Spam in MT (11.2) SpamPal, ASK et. al. (7.09) Visual history of spam email (6.78) Related tags(s): software, law, weblog, civil_society, government Comments (0) Permalink del.icio.us 09. October 2003 MozPHP - running PHP in Mozilla PHP (wiki) \| Mozilla (wiki) - urs @ 10:05:09 MozPHP [1] is a Mozilla PHP integration package. With MozPHP you can execute PHP scripts in Mozilla directly without the need for a local HTTP server. Currently the integration is one way, i.e. it is not possible to access Mozilla internals from PHP scripts. This may change in the future but there are no concrete plans for this. This reminds me of an earlier server-less approach by Scriptviewer [2] dated back to 2001. As far as I can see MozPHP only installs on Windows and Linux but not yet on Mac OS X. A full crossplatform integration would probably be nescessary to make MozPHP interesting for CD-ROM distributions of PHP applications. MozPHP and Sqlite would make a nice couple too, especially for distributable but offline use. [1] http://www.thomas-schilz.de/MozPHP/ [2] http://www.angorasoftware.com/phpviewer.html Related post(s): Mozilla with SVG (6.69) Mozilla gets kind of ContentEditable (5.88) Phase - PHP Content Management System (5.76) Phoenix all-the-best-out-of-mozilla browser? (5.75) aggreg8 - reading RSS in mozilla (5.69) Related tags(s): database, mozilla, office, wiki Comments (0) Permalink del.icio.us 24. September 2003 Smarty Tidy Output Filter PHP (wiki) - urs @ 09:56:35 John Coggeshall runs all his pages through his Smarty Tidy Output Filter [1]. Since Smarty does some caching this should not be a speed drawback. I just wonder if it does not break minutiously designed sites using CSS e.g. for positioning instead of images like with spacer.gif. But this is eventually no problem if tidy i only applied on the (inner) site content rather than on the site's main design. [1] http://coggeshall.org/show_source.php?filename=outputfilter.tidyrepairhtml.php Related post(s): Tidy into PECL (11.6) PHP Template Engine Smarty 2.0.1 Released (9.15) Multi-user blog, pictures handling and PDF generation with Wordpress (9.04) PECL Tidy extension for Windows (7.97) Tidy extension for Firefox (7.30) Related tags(s): xml, mozilla, weblog, software, economy Comments (0) Permalink del.icio.us 17. September 2003 Disable functions per directory in PHP 4.3.3 PHP (wiki) \| Apache (wiki) - urs @ 11:54:58 Tvrtko A. Uršulin [1] provided an interesting patch for PHP that only touches two files (main/main.c and sapi/apache/mod_php4.c ), which will allow to disable PHP functions per virtual directory. Interesting feature for service providers and Universities. [1] http://www.zend.com/lists/php-dev/200309/msg00120.html Related post(s): Apache2 with PHP5 CGI and PHP4 module on OS X (8.18) UNESCO Free Software Directory (6.62) .htaccess problem on drives other than C (6.12) SVG in Firefox (5.42) How to generate a PHP functions overview (4.68) Related tags(s): intellectual_property, software, apache, mozilla, social_network Comments (0) Permalink del.icio.us 16. September 2003 PECL Tidy extension for Windows PHP (wiki) \| XML (wiki) - urs @ 00:36:19 Frank Kromann [1] was kind enough to build the Tidy PECL extension [2] for PHP. He will make the dll available online with the next build cycle. The first step into Tidy used via PHP could be the following: <?php // 1. http://kromann.info/php4-pear/php_tidy.dll // 2. libtidy.dll to c:\winnt\system32; get it from http://htmltrim.sf.net // 3. php.ini: extension=php_tidy.dll // 4. Start with: // - http://cvs.php.net/cvs.php/pecl/tidy/tests // - http://coggeshall.org/show_source.php?filename=cleanhtml.php print_r(get_extension_funcs('tidy')); ?> This produces the currently available functions in this extension: Array ( [0] => tidy_create [1] => tidy_setopt [2] => tidy_getopt [3] => tidy_parse_string [4] => tidy_parse_file [5] => tidy_get_output [6] => tidy_get_error_buffer [7] => tidy_clean_repair [8] => tidy_diagnose [9] => tidy_get_release [10] => tidy_get_status [11] => tidy_get_html_ver [12] => tidy_is_xhtml [13] => tidy_is_xml [14] => tidy_error_count [15] => tidy_warning_count [16] => tidy_access_count [17] => tidy_config_count [18] => tidy_load_config [19] => tidy_load_config_enc [20] => tidy_set_encoding [21] => tidy_save_config ) Credits to John [3] for implementing Tidy. [1] http://kromann.info/pear-pecl.php [2] http://pear.php.net/package-info.php?package=tidy [3] http://coggeshall.org Related post(s): Tidy into PECL (16.9) PECL extension for SQLite database (11.4) Imagemagick as PHP extension on Windows (10.1) Tidy extension for Firefox (9.89) PECL dll files for Windows (9.85) Related tags(s): random_thought, wiki, mozilla, wireless_and_mobile, deutsch Comments (0) Permalink del.icio.us 11. September 2003 Serendipity presented by coWiki PHP (wiki) - urs @ 12:55:00 Well, Serendipity [1], a ~~Smarty-based~~ blog tool, is now being presented on a tool called coWiki [2], which is based on PHP5. [1] http://www.s9y.org [2] http://www.develnet.org Related post(s): Serendipity - PHP weblog software (9.45) Serendipity weblog to release soon (5.16) Wiki parser in PEAR (4.47) Download XML docbookx from nwalsh.com (3.87) The cock of the walk dies out (3.84) Related tags(s): weblog, php, wiki, civil_society Comments (3) Permalink del.icio.us Using PEAR to cache cafelog/b2 PHP (wiki) - urs @ 02:00:48 Hacking cafelog/b2 can be a pain. I tried to add some caching based on PEAR::Cache while adding it to the code of b2. There was no reasonable way to do so within an acceptable amount of time. But the pages went slow on the blog and there was something to do about it. So I think there is a way to handle it; at least it looks like. The caching now done is based on the idea, that I take an application and say something like "start caching" at the very beginning of the script and "stop it" at the very end. A way to control such mechanism is done by the Apache directive php_value, where one can reconfigure the Apache server configuration. Therefore the parameters auto_prepend_file and auto_append_file have been used. They allow exactly a handling of such a start-stop mechanism. What follows is some lines of code of PHP, split up into two files, the prepend.php and the append.php. This solution is probably suboptimal but it improved the accessability of the blog posts at least subjectively but hopefully not only. Any improvements are welcome. Lots of good discussions about caching can be found on Simons blog [1]. 01 <?php 02 // $Id: prepend.php,v 1.1 2003-09-11 01:31:17+02 urs Exp urs $ 03 04 /** 05 * Quick & dirty way of caching a blog. 06 * Put this into your .htaccess file: 07 * php_value auto_prepend_file /home/example.com/htdocs/prepend.php 08 * php_value auto_append_file /home/example.com/htdocs/append.php 09 * 10 * References: 11 * - http://ch.php.net/manual/de/ref.outcontrol.php 12 * - http://www.onlamp.com/lpt/a/1227 13 * - http://www.ulf-wendel.de/php/show_source.php?file=cache_dem_file 14 * - http://iamcal.com/publish/articles/php/processing_html/ 15 / 16 17 // Include the package 18 require_once 'Cache/Output.php'; 19 20 // Set some variables 21 $cache_path = array( 22 'cache_dir' => "/home/example.com/cache/", 23 'filename_prefix' => "cache_" 24 ); 25 26 // Create a Cache object 27 $objCache = &new Cache_Output('file', $cache_path ); 28 29 // Compute unique cache identifier for the page 30 $cache_params = array( 31 'url' => $_SERVER['REQUEST_URI'], 32 'post' => $_POST, 33 'cookies' => $_COOKIE 34 ); 35 36 $urltest = parse_url("http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ); 37 if( preg_match('#([cmp]+)([0-9]{1,}).html#', $urltest['path'] , $match ) 38 OR ( trim($urltest['path'], "/") == "blog") ) { 39 40 // Set an ID for this cache 41 $cache_id = $objCache->generateID($cache_params ); 42 43 // Query the cache 44 if ( $content = $objCache->start($cache_id ) ) { 45 46 // Cache Hit 47 echo $content; 48 exit("[Cache hit]"); 49 } 50 } 51 52 ?> 01 <?php 02 // $Id: append.php,v 1.1 2003-09-11 01:29:08+02 urs Exp urs $ 03 04 /* 05 * Test if there is any cached data. If not obtain it, 06 * save and display it. 07 * 08 / 09 if( strlen($objCache->start($cache_id)) < 1 ) { 10 // This should not be here either, but it is obviously required. 11 // Tell me if You know any better... 12 ob_end_clean(); 13 14 // Cache pages starting with pXXX.html, cXXX.html and mXXX.html. The main 15 // page http://example.com/blog/ is being cached using a parse_url trick. 16 if( preg_match('#([cmp]+)([0-9]{1,}).html#', $urltest['path'] , $match ) 17 OR ( trim($urltest['path'], "/") == "blog") ) { 18 // Store page into cache 19 echo $objCache->end(3600); 20 } 21 } 22 ?> [1] http://simon.incutio.com/archive/2003/06/21/ Related post(s): Rewrite of captcha-like feature (7.15) Alternative PHP Cache (6.59) PEAR installation on Windows from scratch (6.34) PEAR Out of Beta (6.28) Technorati ping for cafelog/b2 (6.18) Related tags(s): weblog, social_network, php, moblog, wireless_and_mobile Comments (0) Permalink del.icio.us 06. September 2003 IP to Country - PHP implementation update* PHP (wiki) - urs @ 14:38:16 Mika Tuupola [1] has updated the PHP implementation of the IP to Country conversion based on the database provided by Directi [2]. There has recently been a brought up a new ip-to-country database format. [1] http://www.appelsiini.net/~tuupola/archives/110/ [2] http://ip-to-country.directi.com Related post(s): IP to country conversion (7.50) Country maps as GIF and PDF (6.32) Weblogs and ISSN (6.30) Beagle - Open Source Desktop Search (4.78) Firefox smart update (4.62) Related tags(s): government, creative_commons, copyright, mozilla, health Comments (0) Permalink del.icio.us 02. September 2003 PHP to IL compiler PHP (wiki) - urs @ 14:22:18 Reading Urs Müllers weblog today, he asks if noone ever thought of writing a PHP to IL - also known as Microsoft Intermediate Language (MSIL) [1]. I liked to go further on that idea and did some look-around, after having read today, that Novell bought Ximian. Anyway, the one mostly dealing with mono and PHP is probably Sterling Hughes [2] and that is where I found some more on PHP to IL. It does not yet seem to have a completed solution around, but if one gets stuck, he or she might like to try the ASM to IL compiler [3] as a last possibility. [1] http://www.compisoft.ch/BLog/Default.aspx?EntryId=e4c6ab78-1e70-4dff-b568-71900c08c4d9 [2] http://www.edwardbear.org/blog/archives/000216.html [3] http://home.worldonline.dk/viksoe/asmil.htm Related post(s): Dev-Cpp - a C/C++ programming language IDE (7.05) Bytecode compiler for PHP scripts (7.05) PHP# compiler project by Alan Knowles (7.04) Debian switches to GCC 3.2 as default compiler (4.48) A brainfuck interpreter in PHP (4.41) Related tags(s): open_source, software Comments (0) Permalink del.icio.us 15. August 2003 Error page 404 and RSS autodiscovery PHP (wiki) \| Weblog (wiki) - urs @ 16:23:48 Had a real laugh at Marks 404 error page [1]. The correct URL would be this [2]. Actually I was looking for his ideas on the RSS autodiscovery feature [3]. The aim is to not give a specific RSS location but simply the site address. His autodiscovery script will detect the RSS source link: <link rel="alternate" type="application/rss+xml" title="RSS" href="http://circle.ch/blog/b2rss.php"> Unless you have that link tag in your (x)html source, the result of autorss.py is the passed URL. [1] http://diveintomark.org/archives/2002/08/15/ultraliberal_rs [2] http://diveintomark.org/archives/2002/08/15/ultraliberal_rss_locator.html [3] http://diveintomark.org/archives/2002/05/31/rss_autodiscovery_in_python Related post(s): phpize uses automake (5.51) Minimalistic CMS (4.50) Why does the web work? (4.30) PEAR version 1.2 RC1 released (4.16) To Trackback a Wiki page (4.16) Related tags(s): content_management, rant, database, weblog Comments (0) Permalink del.icio.us 11. August 2003 Tidy into PECL PHP (wiki) - urs @ 08:53:40 John Coggeshall moved tidy [1] into PECL [2]. There is still some work to do for the Windows dll; more to come hopefully soon. From my point of view, this should not be an extension but part of the default function set in PHP. Having proper XHTML output is something to go for. HTML Tidy, including both TidyLib and the command line utility, uses the W3C license: That sounds not too bad and finally: The copyright holders and contributing author(s) specifically permit, without fee, and encourage the use of this source code as a component for supporting the Hypertext Markup Language in commercial products. From the legal side it should be possible to have tidy compiled into PHP. Please notify me if you have a different point of view. [1] http://tidy.sf.net [2] http://pear.php.net/package-info.php?package=tidy Related post(s): PECL Tidy extension for Windows (12.9) Smarty Tidy Output Filter (7.87) Tidy extension for Firefox (7.30) PECL dll files for Windows (6.71) Multi-user blog, pictures handling and PDF generation with Wordpress (6.56) Related tags(s): xml, mozilla, php, open_source Comments (0) Permalink del.icio.us 09. July 2003 IP to country conversion PHP (wiki) - urs @ 23:07:52 Today I found that IP Address Locator, which returns localized information based on the client's IP address [1]. A non-commersial version based on PHP is written by Mika Tuupola [2] and is easy installable via PEAR: pear install http://www.appelsiini.net/~tuupola/php/download/I18N_IP2Country-0.2.0.tgz The relation between the IP and the country is constructed via information [3] put into a database: CREATE TABLE ip2country ( ipfrom INTEGER UNSIGNED, ipto INTEGER UNSIGNED, code CHAR(2), country VARCHAR(64) ); [1] http://www.geobytes.com/IpLocator.htm?GetLocation [2] http://www.appelsiini.net/~tuupola/php/I18N_IP2Country/docs/ [3] http://www.ip-to-country.directi.com/latest/ip-to-country.csv.zip Related post(s): IP to Country - PHP implementation update (11.2) Country maps as GIF and PDF (6.32) Weblogs and ISSN (6.30) Word to LaTeX conversion (5.13) CC-ch weblog (4.24) Related tags(s): php, government, office, latex, creative_commons Comments (1) Permalink del.icio.us Fancy PHP debugging PHP (wiki) - urs @ 14:47:20 There is a new tutorial about debugging PHP with the help of Javascript on Zend [1] and via a usercomment I came across just another similar implementation [2]. [1] http://www.zend.com/zend/tut/tutorial-DebugLib.php [2] http://dev.izibox.isa-geek.org/NiceDebug/ Related post(s): PHP 4.3.0 released (5.53) Maguma Open Studio (4.31) Xdebug extension for PHP (4.26) John towards U3 (3.83) RFID enabled cell phones (2.76) Related tags(s): open_source, php, apple, mozilla Comments (0) Permalink del.icio.us DOM Abstraction Classes for PHP PHP (wiki) - urs @ 10:15:16 Matt Kynaston [1] proposed a package to PEAR that handles DOM with PHP 4.3.x like the upcoming PHP5. require_once("DOM_Document.php"); $dom =& DOM_Document::factory('domxml'); $dom->load('tests/article.001.xml'); $node =& $dom->createTextNode("Hello World!"); $root =& $dom->documentElement(); $root->appendChild($node); $xmlstr = $dom->saveXML(); echo "xml: $xmlstr"; Why should this be of any use? Since one can work with an abstraction of DOM it will be much easier to upgrade the written applications from PHP4 to PHP5. Update: The installation should work like: pear install http://matt.online-canarias.com/dom/DOM.tar.gz [1] http://matt.online-canarias.com/dom/ Related post(s): How to DB with PHP PEAR (9.98) Quick Start with Pear DB (7.90) Using PHP PEAR DB abstraction (7.43) Abstract Presentation Layer (APL) (7.30) Caching with most known PHP Template classes (7.26) Related tags(s): weblog, technology, xml, php Comments (2) Permalink del.icio.us 07. July 2003 SQLite documentation on Zend PHP (wiki) - urs @ 23:33:18 Zend [1] already has a documentation of the PECL implementation of SQLite on the web. I passed by at www.php.net but there is nothing comparable around. Seems that Zend pushes SQLite for PHP5 somewhat. [1] http://www.zend.com/manual/ref.sqlite.php Related post(s): PECL SQLite installation (12.0) SQLite - Embeddable SQL Database Engine (8.50) phpize uses automake (8.36) SQLite running as Client/Server (8.27) SQLite wrapper for PEAR:DB (8.12) Related tags(s): technology, random_thought, open_source, database, wiki Comments (1) Permalink del.icio.us 29. June 2003 PHP 5.0.0 Beta 1 PHP (wiki) - urs @ 21:12:48 [via Sterling, 0] The PHP development community is proud to announce the release of PHP 5 Beta 1. Both source packages and a Win32 build are available, you can find these packages at http://www.php.net/downloads.php . For a complete list of changes, please refer to http://www.php.net/ChangeLog-5.php . Some of the more major changes include: - PHP5 features the Zend Engine 2. For a list of Zend Engine 2 changes, please visit http://www.php.net/zend-engine-2.php - XML support has been completely redone in PHP5, all extensions are now focused around the excellent libxml2 library (http://www.xmlsoft.org/ ). - SQLite has been bundled with PHP. For more information on SQLite, please visit their website, http://www.hwaci.com/sw/sqlite/ - Streams have been greatly improved, including the ability to access low-level socket operations on streams. - Due to issues surrounding the MySQL 4.0 license, the MySQL libraries are no longer bundled with PHP. For more information on these licensing changes please see the MySQL licensing policy [1] Note: This is a beta version. It should not be used in production or even semi-production web sites. There are known bugs in it, and in addition, some of the features may change (based on feedback). We encourage you to download and play with it (and report bugs[2] if you find any!), but please do not replace your production installations of PHP 4 at this time. [0] http://marc.theaimsgroup.com/?l=php-general&m=105691130207273&w=2 [1] http://www.mysql.com/products/licensing.html [2] http://bugs.php.net/ Related post(s): PEAR Out of Beta (6.85) Apache 2.0 released as beta (5.47) Beta XML Cooktop 2.200 Beta released (5.47) PHP-GTK Version 0.5.1 <hardboiled wonderland> (5.24) SUSE Linux 10.0 Beta 1 available (5.19) Related tags(s): weblog, linux, random_thought, mozilla Comments (0) Permalink del.icio.us 26. June 2003 Parsing FOAF with PHP PHP (wiki) - urs @ 10:00:56 The article [1] by Ian Davis is a guide to using PHP to parse FOAF documents. FOAF stands for Friend-of-a-Friend and is a fun application of RDF that describes people and their relationships to one another. [1] http://www.semanticplanet.com/2003/05/parsingFOAFWithPHP.html Related post(s): Parsing for trusted FOAFs (9.79) FOAF Explorer (8.03) Finding friends with XML and RDF (7.87) Advogato to FOAF Utility (7.20) If the FOAF file has moved (6.98) Related tags(s): crosspost, weblog, xml, software, civil_society Comments (1) Permalink del.icio.us Turck MMCache for PHP on Windows PHP (wiki) - urs @ 08:37:13 Turck MMCache [1] is a free open source PHP accelerator, optimizer, encoder and dynamic content cache for PHP. It increases performance of PHP scripts by caching them in compiled state, so that the overhead of compiling is almost completely eliminated. The files are also available as binary on Sourceforge [2]. The installation in the php.ini is pretty straight forward and well documented in the README: zend_extension_ts="c:\php\extensions\mmcache.dll" mmcache.shm_size="16" mmcache.cache_dir="c:\tmp\mmcache" mmcache.enable="1" mmcache.optimizer="1" mmcache.check_mtime="1" mmcache.debug="0" mmcache.filter="" mmcache.shm_max="0" mmcache.shm_ttl="0" mmcache.shm_prune_period="0" [1] http://www.turcksoft.com/en/e_mmc.htm [2] http://sourceforge.net/project/showfiles.php?group_id=69426 Related post(s): Turck MMCache for PHP (18.8) PHP Windows mailinglist (4.20) Microsoft Warning of serious Windows hole (4.16) Just no win-win situation (4.06) Instant Windows in days of worms (3.94) Related tags(s): wireless_and_mobile, deutsch, apple, intellectual_property, open_content Comments (0) Permalink del.icio.us 25. June 2003 Having SQLite per default in PHP5? PHP (wiki) - urs @ 01:28:59 Sterling started a thread [1] to have the sqlite extension, which is currently available as a PECL module, being enabled by default with the upcoming PHP5. Rasmus wrote down some of his thought, what PHP is and always was and will be [2]. Follow the thread in gmane [3]. On the other hand there was a thread on disabling MySQL by default [4] and a request for enabling PostgreSQL instead [5]. [1] http://news.php.net/article.php?group=php.internals&article=2563 [2] http://news.php.net/article.php?group=php.internals&article=2715 [3] http://article.gmane.org/gmane.comp.php.devel/15705 [4] http://article.gmane.org/gmane.comp.php.devel/15621 [5] http://article.gmane.org/gmane.comp.php.devel/15826 Related post(s): SQLite documentation on Zend (10.1) SQLite - Embeddable SQL Database Engine (8.50) SQLite running as Client/Server (8.27) SQLite wrapper for PEAR:DB (8.12) PECL SQLite installation (8.03) Related tags(s): technology, random_thought, apple, open_source, database Comments (0) Permalink del.icio.us 23. June 2003 PHPTAL - PHP Template Attribute Language PHP (wiki) - urs @ 12:37:42 PHPTAL [1] is an implementation of the excellent Zope Page Template (ZPT) system for PHP. PHPTAL supports TAL, METAL, I18N namespaces. PHPTALES is the equivalent of TALES, the Template Attribute Language Expression Syntax, it defines how are handled xml attribute values. XML/HTML templates exists to separate logic from presentation in web services. This separation brings more than one benefits in its luggage. * better application design * easier task repartition * better maintainability * web skins I came across that implementation while reading about Simon's own work [2]. [1] http://phptal.sourceforge.net [2] http://simon.incutio.com/archive/2003/06/17/theHolyGrail Related post(s): New PHP Template Class by ISPI geeks (5.19) PHP PEAR offers now Template class (5.12) Caching with most known PHP Template classes (5.01) Open Digital Rights Language (4.97) PHPLib Template Tutorial (4.69) Related tags(s): drm, deutsch, php, database, xml Comments (0) Permalink del.icio.us PEAR version 1.2 RC1 released PHP (wiki) - urs @ 11:37:34 PEAR comes with some updates, news and fixes: Version: 1.2RC1-stable (2003-06-23 08:45:00) * Changed license from PHP 2.02 to 3.0 * Added support for optional dependencies * pear makerpm, now works and generates a better system independant spec file * pear install\|build pecl-package, now exposes the compilation progress * Added new pear bundle command, which downloads and uncompress a pecl-package The main purpose of this command is for easily adding extensions to the PHP sources before compiling it. and Tomas V.V. Cox worked out a new DB release too Version: 1.5.0RC1-stable (2003-06-23 01:09:00) New Features: - Added $dbh->freePrepared(), for explicitily free a prepared result - Test suite enhanced - Added new experimental driver for SQLite Bugs fixed: - Fixed memory leaks with methods that did automatic prepare/execute - ibase: better error handling and various bugfixes - mssql: added port setting to connect and enhancements to the error hanlder - mysql: $db->createSequence(); $db->nextID(); now returns 1 and other minor fixes - odbc: added native quote() function, better error handling, and other bugfixes - pgsql: minor bugfixes Special thanks for those persons who sent patches and bug reports. This release is done for public testing before the final release in sync with the upcomming PHP 4.3.3 version. [1] http://pear.php.net Related post(s): PEAR 1.0 is released! (8.84) PHP 4.0.5 released (6.81) PEAR installation on Windows from scratch (6.34) PEAR Out of Beta (6.28) PHP Debugger DBG 2.04 released (6.17) Related tags(s): php, content_management, moblog, weblog, apache Comments (0) Permalink del.icio.us 16. June 2003 Sun will support PHP in Java PHP (wiki) - urs @ 12:52:07 Sun will support - among other languages - PHP technology within Java. Therefore Sun, Zend, Oracle and Macromedia founded the JCP (Java Community Prozess) [1]. [1] http://www.computerwoche.de/index.cfm?pageid=254&artid=49919 Related post(s): Howto compile PHP with Java on Linux (8.93) Top Ten Java and XSLT Tips (5.95) Java2 Standard Edition Version 1.3 RC1 (5.95) Japha - expandable implementation of Java in PHP (5.21) Pure Java PHP Editor (5.13) Related tags(s): apple, geodata, moblog, economy, java Comments (0) Permalink del.icio.us 15. June 2003 Micropayment - PHP and Paypal PHP (wiki) - urs @ 18:40:03 Zend offers a Tutorial discussing a Paypal based micropayment solution with PHP [1]. [1] http://www.zend.com/zend/tut/tutorial-paypal.php Related post(s): broken T68 display (7.36) OpenSource donation stolen from PayPal account (4.91) Sony HMD-A200 quit service (4.55) Related tags(s): moblog, open_source, technology Comments (0) Permalink del.icio.us 12. June 2003 Fanmail for Rasmus PHP (wiki) - urs @ 08:43:05 [via Sterling, 1] Rasmus got a "fanmail" [2] where someone is not only discrediting the OpenSource movement but Rasmus himself. This reminds me to a similar mail from a "fan" to chregu [3]. [1] http://www.edwardbear.org/blog/archives/000201.html [2] http://lerdorf.com/fanmail.txt [3] http://trash.chregu.tv/instructions.txt Related post(s): Rasmus and his digicam ;-) (7.05) Rasmus has a blog (6.72) PHP introduction by Rasmus himself ::: Superb examples (6.35) Rasmus offers some PHP tips and tricks (5.53) How to add GD 2 support to PHP (5.48) Related tags(s): weblog, php Comments (0) Permalink del.icio.us YAML for PHP PHP (wiki) - urs @ 08:29:35 YAML is a new language for data. A readable, friendly language for storing lists, dictionaries, text, numerics and more. Earlier this year, YAML entered "Last Call" status. It's time to start using YAML [1][2]. The YAML cookbook is a good starting point [3]. [1] http://www.yaml.org [2] http://whytheluckystiff.net/syck/ [3] http://yaml4r.sourceforge.net/cookbook/ Comments (0) Permalink del.icio.us 11. June 2003 RAP - RDF API for PHP PHP (wiki) - urs @ 18:05:59 [via http://whump.com ] RDF API for PHP is a pure PHP software package for parsing, manipulating and serializing RDF models [1]. [1] http://www.wiwiss.fu-berlin.de/suhl/bizer/rdfapi/index.html Comments (0) Permalink del.icio.us 27. May 2003 SQLite wrapper for PEAR:DB PHP (wiki) - urs @ 19:11:40 I have been working on a wrapper class around SQLite for PEAR:DB [1]. The main difference between SQLite and other known databases is probably, that it does not run as a server but a commandline executable, which is also available via an API. So the DSN is a bit abused to something like "sqlite:///c:/temp/database.db". The wrapper is not yet placed in PEAR. But you can simply move the file "sqlite.php" to "PEAR/DB/sqlite.php". [1] http://www.circle.ch/php/files/DB_sqlite/ Related post(s): .NET wrapper for SQLite (11.9) [RT] Handling SQLite remote files with PHP (11.6) PECL SQLite installation (11.3) PECL extension for SQLite database (8.69) SQLite - Embeddable SQL Database Engine (8.50) Related tags(s): open_source, random_thought, technology, php, database Comments (1) Permalink del.icio.us 22. May 2003 Themes for PHP-GTK on Windows PHP (wiki) - urs @ 10:01:45 Christiain Weiske [1] offers a package with some theme generators for PHP-GTK on Windows. [1] http://www.cweiske.de/phpgtk_themes.htm Related post(s): Theme Editor for T68 / T610 (5.90) PHPNuke ::: News system, Web Portal etc. (4.47) PHP Windows mailinglist (4.20) Microsoft Warning of serious Windows hole (4.16) Just no win-win situation (4.06) Related tags(s): civil_society, wireless_and_mobile, deutsch, apple, intellectual_property Comments (0) Permalink del.icio.us PHP a threat for ASP .NET? PHP (wiki) - urs @ 08:46:33 Jesus Castagnietto [1] pointed an article on infoworld [2] where it is rumoured, that "[..] certain Microsofties consider the open-source scripting language PHP to be the biggest threat to its own ASP .Net [..]"; you might also read Microsofts own comparison [3]. Sterling already commented that one [4]. [1] http://www.castagnetto.org [2] http://www.infoworld.com/article/03/05/09/19OPcringely_1.html [3] http://msdn.microsoft.com/library/en-us/dnaspp/html/phpvsaspnet.asp [4] http://www.edwardbear.org/blog/archives/000180.html Related post(s): FOSS Licensing Howto (3.55) barratry - the offense of persistently instigating lawsuits (3.25) Related tags(s): open_source, law Comments (0) Permalink del.icio.us 20. May 2003 *OpenOffice Impress (.sxi) docs to pres2** PHP (wiki) - urs @ 23:42:18 As mentioned the recent work [1] by Sterling, giving it a try to convert OpenOffice Impress documents to the PHP presentation (pres2) [2] format, I tried to come along with another approach using XSLT [3] instead of expat. The xsl is just too simple yet but it works for OOo slides with a title and a text; did not try more [4]. Just uncompress the pres.sxi to a folder tmp and use xsltproc.exe to run the XSLT. It should work. Some discussion on what a basic sxi file needs to look like can be found on a OOo mailinglist [5] or at Raymond Yee's site [6]. [1] http://circle.ch/blog/p802.html [2] http://cvs.php.net/cvs.php/pres2 [3] http://circle.ch/pdf/gehrig_030521_OOo2pres.pdf [4] http://circle.ch/pdf/gehrig_030521_OOo2pres.sxi [5] http://xml.openoffice.org/servlets/ReadMsg?msgId=645904&listName=dev [6] http://iu.berkeley.edu/rdhyee/discuss/msgReader$755 Update: Forgot to mention "OpenOffice.org XML transformation to HTML/WML/PALM HTML 3.2" [7]. [7] http://xml.openoffice.org/sx2ml/ Related post(s): OpenOffice slides to PHP pres2 (14.7) OpenOffice 1.9.60 and Angela (7.31) nanoweb and OpenOffice.org releases (6.89) OpenOffice Source Project (6.57) OpenOffice.org 1.1.0 for OS X (6.43) Related tags(s): php, office, culture, apple, database Comments (2) Permalink del.icio.us HttpAuthPlus for PHP* PHP (wiki) - urs @ 22:41:00 HttpAuthPlus [1] is a php class for HTTP Authentication against a database, or a ASCII file. It further provides user administration methods for adding, updating, deleting users from both database and ASCII file authentication methods. It is requires PEAR:DB. I did not try it out; the user handling was just to mention here. [1] http://sourceforge.net/projects/httpauthplus/ Comments (0) Permalink del.icio.us 18. May 2003 Apache-PHP-Horde-Win32 installation PHP (wiki) - urs @ 17:59:55 This document by Mike Cochrane [1] guides you through the installation of the Horde Framework, and it's prerequisites on the Windows 2000 platform. The goal is a working webmail system using an existing imap server and a Windows 2000 webserver. This document covers the installation of Apache, PHP, Mysql, Horde, IMP, Turba, Nag, Mnemo, Kronolith. [1] http://www.graftonhall.co.nz/mikes/Apache-Mysql-Php-Horde/ Related post(s): Cygwin - Apache - MySQL - PHP Installation (8.87) GIMP for Win32 (8.43) PHP upgrade installer for Win32 (7.55) Apache, PHP, Sablotron, libxml, GD on OS X (7.55) Get a PHP 4.1.0 win32 release TS build here (6.76) Related tags(s): apple, technology, apache, linux, deutsch Comments (0) Permalink del.icio.us 17. May 2003 OpenOffice slides to PHP pres2 PHP (wiki) - urs @ 14:11:20 Sterling [1] has been working out a converter for OpenOffice slides to the PHP presentation framework pres2. You'll need PHP5. [1] http://www.edwardbear.org/blog/archives/000179.html Related post(s): OpenOffice Impress (.sxi) docs to pres2 (16.8) OpenOffice 1.9.60 and Angela (7.31) Slides online - PHP Conference Frankfurt 2001 (7.00) nanoweb and OpenOffice.org releases (6.89) OpenOffice Source Project (6.57) Related tags(s): office, culture, apple, database, software Comments (1) Permalink del.icio.us 14. May 2003 Flat file database supporting SQL* PHP (wiki) - urs @ 21:31:55 PHP Text DB API is a flat file database supporting SQL and is already available from c-worker [1]. [1] http://www.c-worker.ch/txtdbapi/index_eng.php Related post(s): How to find a new flat in Bern (7.87) HttpAuthPlus for PHP (6.80) news on your website (6.09) jEdit - Open Source programmer's text editor (5.58) Open Database Transport Protocol (5.04) Related tags(s): civil_society, open_source, culture, software, crosspost Comments (1) Permalink del.icio.us 13. May 2003 Undocumented feature in trim() PHP (wiki) - urs @ 19:43:37 There is a kind of an undocumented feature in PHPs trim function. One may set an argument to be trimmed by something: <?php $path = "/this/goes/to/the/path/"; echo trim($path, '/'); ?> this/goes/to/the/path I found that in a script of Rasmus. Related post(s): Rewrite of captcha-like feature (5.56) XML Tutorial on webreview.com (4.76) tel.search.ch with vCard export (4.72) Adds disturbing the Blog frontpage (4.12) Real-time preview of Blog Comment (3.80) Related tags(s): php, weblog, economy, social_network Comments (3) Permalink del.icio.us 12. May 2003 PECL SQLite installation PHP (wiki) - urs @ 13:08:46 Did a PECL install on SQLite: # pear install SQLite-0.9.tgz 38 source files, building running: phpize PHP Api Version : 20020918 Zend Module Api No : 20020429 Zend Extension Api No : 90021012 building in /var/tmp/pear-build-root/SQLite-0.9 running: /tmp/tmpJcmmYM/SQLite-0.9/configure running: make sqlite.so copied to /tmp/tmpJcmmYM/SQLite-0.9/sqlite.so install ok: SQLite 0.9 Related post(s): PECL extension for SQLite database (11.4) SQLite documentation on Zend (10.0) SQLite via ODBC (9.50) SQLite - Embeddable SQL Database Engine (8.50) SQLite running as Client/Server (8.27) Related tags(s): technology, random_thought, weblog, database Comments (1) Permalink del.icio.us 09. May 2003 Perl embedded in PHP PHP (wiki) - urs @ 15:23:26 Johannes Schlueter has written a PHP Extension to embed a perl interpreter to PHP. It is far from complete, but worth having a look at it and keeping it in mind I guess [1][2]. Ohh... just found out, that this is idea is not at all that new [3]. [1] http://www.schlueters.de/perl-pre0.1.tar.bz2 [2] http://news.php.net/article.php?group=php.pear.dev&article=15811 [3] http://msalem.translator.cx/perlinphp.php And there is one more: Thies [4]: you may want to look at http://www.apache.org/~dougm/php-perl.tar.gz which is something Doug MacEachern has written some time ago. [4] http://news.php.net/article.php?group=php.pear.dev&article=16066 Related post(s): perlre - Perl regular expressions (5.93) PHP embedded in Mysql (5.90) POPFile classifies E-Mail and Spam (5.53) Mozilla indicates Creative Commons license (5.33) "Cheap" Perl HTTPD for Windows 95/NT (4.87) Related tags(s): php, open_source, intellectual_property, weblog, xml Comments (0) Permalink del.icio.us 08. May 2003 PHP embedded in Mysql PHP (wiki) - urs @ 10:42:24 David Sklar has a talk tomorrow [1] on his implementation of embedded PHP in MySQL. This look e.g. like this: mysql> SELECT php('','hello, world!'); +-------------------------+ \| php('','hello,world!') \| +-------------------------+ \| hello, world! \| +-------------------------+ 1 row in set (0.36 sec) The source files are available at his site [2]. [1] http://talks.php.net/show/myphp/ [2] http://www.sklar.com/page/article/myphp Related post(s): OS X MySQL binary installer .pkg by Liyanage becomes official (6.12) MySQL 4.1 with multiline queries (5.89) NuSphere vs. MySQL AB (5.64) MySql AB has a new CI (5.64) MySQL 4.0 alpha released (5.54) Related tags(s): database, wiki, intellectual_property, weblog, xml Comments (1) Permalink del.icio.us phpize uses automake PHP (wiki) - urs @ 09:46:48 There was missing automake, when I got these messages: #:/usr/local/src/SQLite-0.9# phpize /usr/local/bin/phpize: line 41: aclocal: command not found configure.in:20: error: possibly undefined macro: AC_MSG_ERROR If this token and others are legitimate, please use m4_pattern_allow. See the Autoconf documentation. configure.in:72: error: possibly undefined macro: AC_PROG_LIBTOOL configure:2327: error: possibly undefined macro: AC_DEFINE You should add the contents of `/usr/share/aclocal/libtool.m4' to `aclocal.m4'. Configuring for: PHP Api Version: 20020918 Zend Module Api No: 20020429 Zend Extension Api No: 90021012 So an "# apt-get install automake" did the job. It had nothing to do with locales. Related post(s): PECL SQLite installation (3.93) Related tags(s): php Comments (0) Permalink del.icio.us 06. May 2003 PECL binaries for Windows PHP (wiki) - urs @ 08:41:02 To summarize, there are currently the following sources of PECL binaries available: http://snaps.php.net/win32/PECL_STABLE/ http://pear.jawa.at http://kromann.info/pear-pecl.php Related post(s): PHP5 binaries for Windows (11.7) PECL dll files for Windows (9.85) Imagemagick as PHP extension on Windows (8.58) PHP 4.0.4 binaries for Windows (7.78) PECL extension for SQLite database (7.68) Related tags(s): wireless_and_mobile, database, deutsch, apple, intellectual_property Comments (1) Permalink del.icio.us 05. May 2003 Handling JPEG metadata with PHP PHP (wiki) - urs @ 18:35:12 Sebastian Delmont has written a new class to handle JPEG metadata including EXIF and IPTC [1]. require_once 'Image/JPEG.php'; $jpeg =& new JPEGInfo('images/photos001.jpg'); echo $jpeg->getExifField("ApertureValue"); echo $jpeg->getIPTCField("Caption"); $jpeg->setIPTCField("Byline", "Sebastian Delmont"); $jpeg->save("images/photos001-bis.jpg"); $info = $jpeg->getBasicInfo(); echo $info['Width'] . "x" . $info['Height']; A similar package found already its way into PEAR lately [2]. [1] http://www.zonageek.com/tmp/JPEG.php.txt [2] http://cvs.php.net/cvs.php/pear/Image_IPTC/ Related post(s): JPEG image problem with PHP GD (6.21) Modify a comment in a JPEG image (6.10) PHP 4.0.4RC5 availabe for download (5.29) JPEG pictures can carry viruses (4.84) PHP 4.0.4RC6 availabe for download (4.06) Related tags(s): php, mozilla, linux, apache Comments (0) Permalink del.icio.us Securing PHP on Debian Linux PHP (wiki) - urs @ 16:59:03 pookey [1] found a way securing PHP on Debian using binfmt. [1] http://www.pookey.co.uk/php-secure.php Related post(s): Installing Debian on a PC (10.3) mono for Debian (9.20) Debian GNU/Linux on Xbox (8.88) Java2 Standard Edition Version 1.3 RC1 (7.93) Installing Debian on an Apple iBook (7.50) Related tags(s): technology, linux, economy, talks Comments (0) Permalink del.icio.us Fatal error: Maximum execution time of 120 seconds exceeded in /home/circle.ch/htdocs/blog/b2comments.php on line 184

circle.ch weblog by Urs Gehrig

01. June 2007

02. March 2007

12. July 2006

01. September 2005

30. August 2005

29. August 2005

28. August 2005

03. August 2005

18. July 2005

08. June 2005

05. April 2005

23. March 2005

15. March 2005

10. February 2005

27. January 2005

24. January 2005

30. December 2004

14. December 2004

03. December 2004

25. November 2004

18. November 2004

07. November 2004

05. November 2004

20. October 2004

19. October 2004

18. October 2004

17. October 2004

12. September 2004

15. August 2004

09. August 2004

30. July 2004

26. July 2004

07. July 2004

06. June 2004

02. June 2004

19. May 2004

10. May 2004

27. March 2004

24. March 2004

22. March 2004

21. March 2004

16. March 2004

14. March 2004

11. March 2004

06. March 2004

04. March 2004

27. February 2004

26. February 2004

24. February 2004

28. January 2004

06. January 2004

11. December 2003

23. October 2003

17. October 2003

09. October 2003

24. September 2003

17. September 2003

16. September 2003

11. September 2003

06. September 2003

02. September 2003

15. August 2003

11. August 2003

09. July 2003

07. July 2003

29. June 2003

26. June 2003

25. June 2003

23. June 2003

16. June 2003

15. June 2003

12. June 2003

11. June 2003

27. May 2003

22. May 2003

20. May 2003

18. May 2003

17. May 2003

14. May 2003