Wednesday, December 17, 2008

[PHP Classes] Weekly newsletter of Wednesday - 2008-12-17

PHP Classes
Icontem

Weekly newsletter of Wednesday - 2008-12-17

Advertisement

You are getting this message because you voluntarily subscribed to the PHP Classes site. To change your newsletter or alert messages delivery options, see the instructions at the bottom of this message.
Advertisement
This newsletter is always available online and upto date at: http://www.phpclasses.org/newsletter/ .

Contents

Latest PHP specialists forum threads

Subject Updated on
Sockets without a Daemon
Chat, Daemons, Sockets, Push, etc.		 2008-12-16
Limit to same username access
How to limit accesses to same username		 2008-12-14
security with php
security with php		 2008-12-12
Face detection form picture and replacement
Face detection form picture and replacement		 2008-12-12
Multiple currencies with worldpay
I want to our own prices on worldpay...		 2008-12-12
Blanks emails are sent to few users.
Blanks emails are sent to few users.		 2008-12-10
take a screenshot
can php take url screenshot		 2008-12-10

Contents

Contents

Top friends of the site

Friends of the PHP Classes site is a initiative to provide recognition to the users that contribute to the growth of the site community.

For more information on how to become a friend of the site look here.

Rank Friend Referrals
1 Cesar D. Rodas 32
2 solomongaby 22
3 Khaled Al-Shamaa 18
4 Alexander Skakunov 17
5 lixlpixel 17
6 Olaf Lederer 15
7 Horst Nogajski 13
8 Protung Dragos 11
9 Liam Hatton 9
10 Richard Munroe 7

Contents

Browse all PHP User Groups by country

If you make part of a regional PHP User Group not listed here, submit your user group.

Contents

Innovation award results

Innovation Award Winners Congratulations to Felipe Ribeiro!


Rank Class Author Score Points Prize
1 Spell Corrector
Suggest corrected spelling text in pure PHP		 Felipe Ribeiro 21.31% 7
2 mysqli.so.php
Access MySQl databases with MySQLi compatible API		 Baris Yuksel 19.67% 6
3 JavaScript PHP Documentor
Generate documentation for Javascript scripts		 Rafael M. Salvioni 16.39% 5
4 Torrent RW
Create and parse Torrent files		 adrien gibrat 14.75% 4
4 Threading
Create parallel processes with the PHP CLI program		 Alex B. Snet 14.75% 4
6 MiniUrl short URL dynamic
Create and redirect URL shortcuts		 Igor Herson Aquino de França 9.84% 2
7 Alexa
Get site ranking information from Alexa site		 Sergey [YS.PRO] 3.28% 1

Nominees to win the award of November of 2008

Class: SQL Parse Convert to Tree Array Picture of François NEUMANN-RYSTOW
Description: Build a tree to represent an SQL query
Author: François NEUMANN-RYSTOW
Age: 28
Country: France France
Class: Bluetrait Picture of Michael Dale
Description: A multi-user blog system
Author: Michael Dale
Age: 22
Country: Australia Australia
Class: Open Inviter Picture of Open Inviter
Description: Get contacts of friends of different networks
Author: Open Inviter
Age: ???
Country: United States United States
Class: pl2method Picture of Ivo Nascimento
Description: Execute PgSQL stored procedures as class functions
Author: Ivo Nascimento
Age: 29
Country: Brazil Brazil
Class: Flood Assassin Picture of Benjamin Falk
Description: Check whether a message can be spam
Author: Benjamin Falk
Age: 18
Country: Austria Austria
Class: Console Picture of Alex B. Snet
Description: Control output of text to an ANSI console
Author: Alex B. Snet
Age: 19
Country: Russian Federation Russian Federation

Vote

Contents

Latest blog trackback links

Trackback Class Age in days
PHP on Rails - The Flash
Last week I wrote an article about ex...		 Flash Messages 2
Watermarks
It's easy to add watermarks to an ima...		 phMagick 2
Console: Progress Bar
Continuing the theme of the console ...		 Console Progress Bar 3
Interesantes links para PHP
phpffmpeg es una clase que nos permit...		 PHP Video Toolkit 9
como importar xls a php
El Talend hace sus trabajos en phyton...		 csv2mysql database migration tool 10
Geocoding/Geolocating with PHP
We have noticed in several sites visi...		 GeoLocation 15
Import data from CSV file into a MySQL database
Few days ago, Client wanted to import...		 File Importer 16
Descargar video de YouTube
Tengo una serie de videos alojados en...		 YouTube Downloader 16
[php class] Open Inviter - Get contacts of friends of different networks
Yet another great class found on the ...		 Open Inviter 16
Polaroid effect
We can add a polaroid effect to image...		 phMagick 17

Contents

Latest support forum threads

Subject Posted on Class
not all files as i see.
Package rating comment		 2008-12-17 AlefMentor
Problems and fixes
in this forum you can find problem fixing methods		 2008-12-16 YouTube video download
display posted page
displaing posted page in my app		 2008-12-16 MyCurl
Cannot use ampersand in cell text?
All text after the "&" symbol lost		 2008-12-15 DrasticTools
related tables
how can show fields from related tabe?		 2008-12-15 Eyesis Data Grid Control
Filename correction
In net-2008-01-16.zip one of the files is named incorrectly		 2008-12-14 Client and Server Socket
Errors in class.Numerical.php
Spelling errors and other errors		 2008-12-14 Numerical
8BITMIME Error using SMTP
8BITMIME Error while connecting to smtp server using smtp class		 2008-12-14 MIME E-mail message sending
Great script!!!
Package rating comment		 2008-12-13 ezSQL
Problem with sending a CC command
Problem with sending a CC(BCC) command		 2008-12-13 SMTP E-mail sending class

Contents

  • Latest package entries

  • IAF decoder coder

    Picture of ruslan
    Author: ruslan
    Date: 2008-12-16 (1 day ago)
    Groups: PHP 5, Files and Folders, Configuration
    Description: This class can be used to parse and generate Outlook Express IAF configuration files.

    It can generate configuration files for Outlook Express in the IAF format that may include details of configuration for accessing SMTP, POP3, NNTP, IMAP and HTTP servers.

    The class can also load IAF files and extract the values of the configuration option values which are stored in class variables.

  • Google SiteMap generator

    Picture of Botnari Constantin
    Author: Botnari Constantin
    Date: 2008-12-16 (1 day ago)
    Groups: XML, Content management
    Description: This class can be used to generate XML sitemaps from page lists.

    It can add URLs of pages to a list and then it generates a XML document in the sitemap structure format that includes all the pages.

    The generated sitemap document is stored in a given file.

  • YouTube video download

    Picture of Abdulkadir KUCUK
    Author: Abdulkadir KUCUK
    Date: 2008-12-15 (2 days ago)
    Groups: PHP 5, Web services, Video
    Description: This class can be used to download videos from YouTube.

    It takes an URL of the page of YouTube video and retrieves the page to determine the URL of the Flash video stream.

    The class downloads the video stream data and serves it for download as the current script output.

  • Proxy Check

    Picture of Ivan Markovic
    Author: Ivan Markovic
    Date: 2008-12-15 (2 days ago)
    Groups: HTTP, PHP 5
    Description: This class can be used to check whether the user is accessing the site via a proxy server.

    It retrieves all known request headers that may be used to determine the proxy server the user may be using to access the site.

    The class can also check several well known ports of a given IP to determine the port that may be used to connect to a proxy server.

  • Template Emailer

    Picture of Chris Thorne
    Author: Chris Thorne
    Date: 2008-12-14 (3 days ago)
    Groups: Email, PHP 5, Templates
    Description: This class can be used to compose and send messages using templates.

    It extends the PHPMailer class to compose a message by reading a template file that has some tags replaced by given values.

    The composed message is sent with the regular Send() function of the PHPMailer class.

  • Console Progress Bar

    Picture of Alex B. Snet
    Author: Alex B. Snet
    Date: 2008-12-14 (3 days ago)
    Groups: PHP 5, Console
    Description: This class can be used to draw a progress bar in an ANSI console.

    It extends the ANSI console class to render a progress bar.

    The bar starts in a given console column and display a given percentage next to a bar made of repeated characters that represent the width of the bar relative to the total character width of the bar.

  • paging.inc.php

    Picture of tuhin
    Author: tuhin
    Date: 2008-12-13 (4 days ago)
    Groups: HTML
    Description: This class can be used to display links to browse listings split between multiple pages.

    It takes as arguments the number of the current page, the total number of entries in the listing, and the limit of entries to display per page.

    The class generates HTML for links to go to the next, previous and other pages of the listing.

  • Date/Time Select Generator

    Picture of Joshua Bettigole
    Author: Joshua Bettigole
    Date: 2008-12-13 (4 days ago)
    Groups: HTML, PHP 5, Time and Date
    Description: This class can be used to generate form select inputs to choose dates and times.

    It generates HTML for form select inputs that let the user choose ranges of years, months, days, hours, minutes, seconds, etc..

    The class can generate several select inputs according to a format that defines which date and time format inputs should appear.

  • FreecoNet API

    Picture of Pawel Banasiak
    Author: Pawel Banasiak
    Date: 2008-12-12 (5 days ago)
    Groups: PHP 5, Web services
    Description: This class can be used to manage accounts and make calls using FreecoNet.

    It can connect to the FreecoNet Web services API server and send request to execute several operations.

    Currently it can retrieve the balance of a account and initiate a call from a given phone number.

  • FBCount

    Picture of Nemanja Avramovic
    Author: Nemanja Avramovic
    Date: 2008-12-12 (5 days ago)
    Groups: Text processing
    Description: This class can generate enumerated lists of names.

    It takes an array with a list of names and generates a single string separated with commas except the last two names that are separated by the word "and".

    The names can be formatted with a configurable template string that is passed to the sprintf function. If the name list array is associative, both the array entry values and keys are passed.

  • GeoLocation (geoPlugin)

    Picture of Andy S
    Author: Andy S
    Date: 2008-12-11 (6 days ago)
    Groups: Web services, Geography, Finances
    Description: This class can get geographical information of an IP address using the geoPlugin Web service.

    It takes a given IP address and sends a request to the geoPlugin Web services server to obtain the geographic location associated to the IP address.

    The class also retrieves location currency name and conversion rate relatively to a given base currency. This can be used to convert a given amount of money to the local currency.

    It can also retrieve locations near a place given its latitude and longitude coordinates.

  • SQL Parse and Compile

    Picture of Tom Schaefer
    Author: Tom Schaefer
    Date: 2008-12-11 (6 days ago)
    Groups: PHP 5, Databases, Text processing
    Description: This package can be used to parse and compose SQL queries programatically.

    It can take an SQL query and parse it to extract the different parts of the query like the type of command, fields, tables, conditions, etc..

    It can also be used to do the opposite, i.e. compose SQL queries from values that define each part of the query.


    Features:
    I. Parser
    - insert
    - replace
    - update
    - delete
    - select
    - union
    - subselect
    - recognizes flow control function (IF, CASE - WHEN - THEN)
    - recognition of many sql functions

    II. Composer (Compiler)
    - insert
    - replace
    - update
    - delete
    - select
    - union

    III. Wrapper SQL
    - object oriented writing of SQL statements from the scratch

    i.e.:
    #################################################
    $insertObject = new Sql();
    $insertObject
    ->setCommand("insert")
    ->addTableNames("employees")
    ->addColumnNames(array("LastName","FirstName"))
    ->addValues(
    array(
    array("Value"=>"Davolio","Type"=>"text_val"),
    array("Value"=>"Nancy","Type"=>"text_val"),
    )
    );
    $sqlout = $insertObject->compile();
    #################################################

    result:
    echo $sqlout;
    #################################################
    INSERT INTO employees (LastName, FirstName) VALUES ('Davolio', 'Nancy')
    #################################################



    #################################################
    a more advanced example:
    #################################################

    $sql = 'SELECT
    countrylanguage.CountryCode,
    country.Name,
    country.Continent,
    country.Region,
    country.SurfaceArea,
    city.District,
    country.IndepYear,
    country.Population,
    city.CountryCode,
    city.Name,
    city.Population,
    countrylanguage.Language AS lang,
    countrylanguage.IsOfficial,
    countrylanguage.Percentage,
    country.GovernmentForm,
    country.LocalName,
    country.GNPOld,
    country.GNP,
    country.LifeExpectancy
    FROM
    country co
    LEFT JOIN city ct ON co.Code = ct.CountryCode
    LEFT JOIN countrylanguage cl ON cl.CountryCode = ct.CountryCode
    WHERE
    (co.Continent='Asia' AND cl.Language='Pashto')
    GROUP BY
    co.Name
    HAVING
    ct.CountryCode = 'AFG'
    LIMIT 100
    ':

    // using wrapper class
    $sqlDef = new Sql();
    $sqlDef->parse($sql);

    // adding a left join
    $sqlDef->setJoinLeft(
    array(
    'Left'=> array("Value"=>"employees.employeeID", "Type" => "ident"),
    'Op'=> '=',
    'Right'=> array("Value"=>1, "Type" => "int_val"),
    )
    );

    $sqlout = $sqlDef->compile();
    #################################################

    result:

    echo $sqlout;
    #################################################
    SELECT countrylanguage.CountryCode, country.Name, country.Continent, country.Region, country.SurfaceArea, city.District, country.IndepYear, country.Population, city.CountryCode, city.Name, city.Population, countrylanguage.Language AS lang, countrylanguage.IsOfficial, countrylanguage.Percentage, country.GovernmentForm, country.LocalName, country.GNPOld, country.GNP, country.LifeExpectancy
    FROM country AS co
    LEFT JOIN city AS ct ON co.Code = ct.CountryCode
    LEFT JOIN countrylanguage AS cl ON cl.CountryCode = ct.CountryCode
    LEFT JOIN employees ON employees.employeeID = 1
    WHERE (co.Continent = 'Asia' and cl.Language = 'Pashto')
    GROUP BY co.Name
    HAVING ct.CountryCode = 'AFG'
    LIMIT 0,100
    #################################################

    IV. Hint
    Sql_Compiler is none validating, but throws errors on type mismatch or corrupt statements


    Note:
    If you have good ideas to improve this set of classes, let me know.

  • SVF_Log

    Picture of Silvan von Felten
    Author: Silvan von Felten
    Date: 2008-12-10 (7 days ago)
    Groups: PHP 5, Libraries, Logging
    Description: This package provides logging class for the Zend framework.

    It provides several plug-ins in the test app pagage to process log messages in several ways.

    Currently it can log messages to files, PHP output, output for Firebug extension, and the PHP error log.

  • Autofill 1.1

    Picture of Zinke
    Author: Zinke
    Date: 2008-12-10 (7 days ago)
    Groups: HTML, PHP 5
    Description: This class can be used to complete form input values with suggestions.

    This is an updated version of the class written originally by Carlos Reche.

    This version allows to complete multiple words separated by the user with commas, like for instance to complete user defined in tag lists.

Contents

Contents

Contents

If you are not interested in receiving any more messages like this one, send an empty message to unsubscribe-newsletter@phpclasses.org or go to the user options page and uncheck the respective e-mail delivery option. There you can also switch the message format between text and HTML. Note that there are several mailing lists. If you want to unsubscribe from all lists at once, send an empty message to unsubscribe-content@phpclasses.org .
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2008 PHP Classes
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)