PHP Developers Summit 2010

In partnership with Microsoft Philippines, PHP User Group Philippines presents PHP Developers Summit 2010. We are inviting you to come and join us in this gathering of the country's best tech-talents, professionals and web developers promoting the use of PHP and open source solutions in the enterprise and schools.

Regular rate - Php 1,200.00

Walk-in price - Php 1,500.00

Group of 3 Promo - Php 3,500.00 (instead of Php 3,600.00; payment for 3 people should be deposited at the same time to be recognized as group of 3)

**All tickets include meals (lunch + snack), event t-shirt, raffle entry and other freebies.

Registration and Ticket Payment Instructions

Online registration website is currently being tested right now. In the mean time, you could pre-register by sending your name, position, company and contact details to chean@phpugph.com and by settling your ticket payment through bank deposit:

Bank Name: Banco de Oro (BDO)
Account Name: PHP User Group Philippines Inc.
Savings Account No. 290226988
Branch: San Juan Branch

To all who would pay for the event tickets, kindly send me a scanned copy of the deposit slip for payment confirmation. - Chean

Speakers

Dominick Nowell A. Danao (CEO of Happy Mobile Inc.)
- PHP Development with Yahoo Developer's Network

Former VASHead of Sun Cellular, Founder of Pinoymail which he sold to Smart's Orlando Vea for P100M back in the early 2000s, He is also a Palanca Awardee, He recently won in the Yahoo Open Hack's Day in Indonesia.

Bing Bryan Tan (President and CEO of Brewed Concepts)
- Keynote Speaker

Paolo Alexis Falcone (Senior Developer, Friendster Inc.)
- PHP Scaling

Alezandra Nicholas (Microsoft Developer Evangelist)
- Website spark and Bizspark

Inspired by technopreneurship and helping students/professionals be more capable and employable, she hopes to empower them to dream bigger through innovation, enterprise and technology. She has more than 10 years of IT career experience as a trainer, conducting training in different programming languages, and as a technical consultant for various IT companies. She develops applications for both Windows and Web. She holds a Bachelor’s degree in Computer Science from Trinity University of Asia.

Rodney C. Jao (MVP for Device Application Development)
- PHP in IIS7 (using Fast CGI) and about PHP and ASP.NET interop via SOAP

Driven by his passion in sharing his knowledge to the IT community, Rodney has delivered numerous technical sessions on windows, web and mobile development using different platforms since 1999, including PHP interoperability. A technologist by heart, he has developed mobile applications and applications that integrate with Barcodes and RFID’s from several vendors. His technical competencies include networking and system administration. He is currently managing the Asia operations of Lane Systems, a software and consulting firm with offices in Asia and in North America.

Marco Palinar

He will talk about simplex yet sexy UI development for developers or his freelancing escapades. Marco used to work for Friendster.

Rick Bahague, Jr. (Computer Professionals' Union)
- Windows Cache Extension for PHP

Globe Labs
- Globe Labs API

Sponsors

Microsoft Philippines
Zend
Globe Labs

**For sponsorships, please contact me (Cherrie Ann Domingo) thru the ff. contact details: chean@phpugph (E-mail), +63917.865.2412 (Mobile), (02) 975.6976 (Phone)

Free flowing coffee with lots of freebies and raffle prizes plus new friends to meet! =) So what are you waiting for? Registration starts at 8 AM. See you all there! ^__~

Windows 7 Community Launch Party

On October 22, 2009, Microsoft will be globally launching its newest desktop operating system, Windows 7. While Microsoft Philippines will hold its formal launch event on November 7th, that does stop us from joining the world in celebrating this great new operating system.

Come and join us as we meet the new operating system with demos, presentations, discussions, Q&A, and mixing with fellow Windows entusiasts.

There will be finger-foods, music, contests, raffles, and give-aways! Be there!!!

It's time to celebrate the global launch of the most anticipated Operating System of all time... Windows 7!

Register here now! See yah! ^__~

Oracle SQL: ROWID Pseudocolumn

Again, one of my students asked me a question during the Oracle 11g Introduction to SQL class.

"How would you delete only 1 record of 2 identical records, all with same column values and there is no PK (Primary Key) to uniquely identify them?"

I told her that we can make use of the ROWID pseudocolumn.The ROWID pseudocolumn returns the physical address of the row. Oracle Database rowid values contain information necessary to locate a row:

• The data object number of the object
• The data block in the datafile in which the row resides
• The position of the row in the data block (first row is 0)
• The datafile in which the row resides (first file is 1). The file number is relative to the tablespace.

Usually, a rowid value uniquely identifies a row in the database. However, rows in different tables that are stored together in the same cluster can have the same rowid. Values of the ROWID pseudocolumn have the datatype ROWID or UROWID.

Rowid values have several important uses:

• They are the fastest way to access a single row.
• They can show you how the rows in a table are stored.
• They are unique identifiers for rows in a table.

You should not use ROWID as the primary key of a table. If you delete and reinsert a row with the Import and Export utilities, for example, then its rowid may change. If you delete a row, then Oracle may reassign its rowid to a new row inserted later.

Although you can use the ROWID pseudocolumn in the SELECT and WHERE clause of a query, these pseudocolumn values are not actually stored in the database. You cannot insert, update, or delete a value of the ROWID pseudocolumn.

The ROWID Demo

To simulate the scenario, I created a sample table named Test:

SQL> CREATE TABLE Test
(test varchar2(10));

Then, I inserted two identical records with no primary key

SQL> INSERT INTO Test
VALUES ('Test1');

SQL> INSERT INTO Test
VALUES ('Test1');

Then, selected the rowid of two identical records

SQL> SELECT rowid, test
FROM Test;

Then, the query returned

ROWID                  TEST
--------------------   ---------------
AAASDcAAEEAADOMAAA     Test1
AAASDcAAEEAADOMAAB     Test1

Then, I tried to delete one of the two identical records

SQL> DELETE FROM Test
WHERE rowid = 'AAASDcAAEEAADOMAAA';

Then, the result says 1 row deleted

Yey, we've successfully deleted one of the two identical records. ^_~

Oracle SQL: Traditional Outer Join Syntax

I was teaching Oracle 11g SQL Fundamentals and PL/SQL Fundamentals course when one of my students asked me a startling question right after I've discussed JOIN topic.

"What's the difference of using the JOIN keyword and using the (+) for joining of tables?"

Then, he showed me a SQL script using the (+) syntax and explained to me that his mentor taught him to use this syntax and that they are also using this SQL syntax in all their systems and applications.

For a while, I wondered... because I've never encountered this (+) syntax with Oracle 9i, 10g and 11g books and course materials. I told him, maybe it was the old JOIN syntax being used by earlier versions of Oracle.

To support my wild guess... that it is really an old JOIN syntax still supported by Oracle, I started to google about it and I landed on Oreilly's Oracle SQL*Plus Pocket Reference, 2nd Edition, by Jonathan Gennick, sample chapter excerpt: http://oreilly.com/catalog/orsqlpluspr2/chapter/ch01.html


According to the book, the (+) syntax for joining tables is an old syntax for outer joins until Oracle 8i. An outer join returns rows for one table, even when there are no matching rows in the other. You specify an outer join in Oracle by placing a plus sign (+) in parentheses following the column names from the optional table in your WHERE clause. For example:

SELECT ut.table_name, uc.constraint_name
FROM user_tables ut, user_constraints uc
WHERE ut.table_name = uc.table_name(+)

The (+) after uc.table_name makes the user_constraint table optional. The query returns all tables, and where there are no corresponding constraint records, Oracle supplies a null in the constraint name column. Full outer join is not supported using the (+) syntax.

At the release of Oracle 9i and later versions, full outer join is already supported using the JOIN syntax. 

SELECT ut.table_name, uc.constraint_name

FROM user_tables ut FULL OUTER JOIN user_constraints uc

ON ut.table_name = uc.table_name

Although you could still use the old (+) syntax for outer joins for backward compatibility, Oracle strongly encourage to use the new JOIN syntax for full outer join support. 

CamStudio - Open Source

CamStudio is an open-source and free streaming video software which is able to record all screen and audio activity on your computer and create industry-standard AVI video files and using its built-in SWF Producer can turn those AVIs into lean, mean, bandwidth-friendly Streaming Flash videos (SWFs).

Cool, right? ^_^

So, when can you use this FREE software?

• You can use it to create demonstration videos for any software program
• You can create video tutorials for school or college class
• You can use it to record a recurring problem with your computer so you can show technical support people
• You can use it to create video-based information products you can sell
• You can even use it to record new tricks and techniques you discover on your favourite software program, before you forget them

CamStudio can also add high-quality, anti-aliased (no jagged edges) screen captions to your recordings in seconds and with the unique Video Annotation feature you can even personalise your videos by including a webcam movie of yourself "picture-in-picture" over your desktop.

And if all that wasn't enough, CamStudio also comes with its own Lossless Codec that produces crystal clear results with a much smaller filesize compared with other more popular codecs, like Microsoft Video 1.

You have total control over the output of your video: you can choose to use custom cursors, to record the whole screen or just a section of it and can reduce or increase the quality of the recording depending on if you want smaller videos (for emailing to people, for instance) or you can have "best quality" ones for burning onto CD/DVD.

For more details, check out their website - http://camstudio.org/

Real-Time Collaboration of Flow Charts

Meeting face to face with all the people involved in the system is quite difficult due to schedule conflicts. As I search for a way for me and our client to talk about the actual business processes while both of us design the flowchart without the need of meeting up, I came upon http://www.flowchart.com

Flowchart.com is an online multi-user, real-time collaboration flowchart software. Flowcharting made easy. It does not require any software download, it works with your favorite browser such as Fire Fox, IE, Opera, Safari, Konquerer plus it works on any Operating System.

Create and share your flowcharts for free! This is a very useful tool for teams whose members are working remotely. You can collaborate with your colleagues in real-time. All collaborating parties can chat and design a flowchart at the same time.

Below are the features of flowchart.com:

• Free
  
• Easy to use
  
• No plugins to install
  
• Works in all browsers
• Drawing Tools (Lines, Arrows, Curves) and objects (flowchart objects, clipart)
• Real-time online collaboration between multiple users with different browsers
• Save your flowchart as a PDF or PNG formats
• Upload your original clipart and use it in your flowchart, or share them with the community, or sell them.

Using SE K610i Mobile Phone as Modem

Last month, our office's internet connectivity was down for 1 week and our work was affected. I got dismayed with Globe and PLDT customer service as the support came too late. Internet has been quite a necessity in my everyday life so I came up with an alternative solution - using my 3G mobile phone as a modem.

Luckily, Globe also offers competitive connectivity rates such as Smart for Php10.00/30 mins. Just switch from per KB charging rate (the default) to time based charging rate by texting TIME to 1111 and you would be receiving the confirmation within an hour. You are now ready to surf!

Overview of Sony Ericsson K610i Phone


A compact classic

Slim, elegant, with a back-lit keypad and large screen; you can access the most used functions in one or two steps and talk and surf at the same time.

Big on business

Push email and PC synchronisation ensure you’re always on top of things; and it’s a high-speed modem to connect your PC to the Internet on the go.

Enjoy the small world

News and events are at your fingertips with RSS feeds, and you’ve got music, video and games to entertain you in flight or when you deserve a break.

Size does matter

One of the smallest 3G phones available, it’s packed with powerful features including a discreet quality camera and always-on, high speed Internet.

Getting ready to surf the Internet

• Connect the mobile phone to the PC thru USB cable provided with the unit.
• Choose Phone Mode when prompted in the mobile phone screen.
  
• Open Sony Ericsson PC Suite 3.1 and phone would be detected as modem.
  
• PC Suite would be in phone mode and screen would be shown like in the figure below.

• Click Internet Connection and this screen would be shown.

• Click connect and the phone modem would establish connection.

• When connection is estbalished, this screen would be displayed.
  

Voila! You can now enjoy surfing the internet. =) An alternative way of connecting to the internet - the mobile way. ^_~