WTF Programmer
25-February 2008.
559
6 I want your resume if you have these following caterias:
- Have good knowledge in writing PHP and MySQL.
- Knowledge in proper JavaScript programming is much apprieciated.
- Understand what Web 2.0 really means.
- Can work at Petaling Jaya, Malaysia.
PHP Bug: Oracle field name truncated to 15 characters using ODBC/Instantclient
Have anyone else experience this bug/issue?
Compiled PHP 5.2.5 with Apache 2.2.6 with UnixODBC support and other
standard options.
ODBC connection was set up using Instantclient version 10.2.0.3 ODBC
driver. When tested using isql, the output was OK but when execute using
PHP, the fields name truncated to only 15 chars resulting "Undefined
Index" notice. This may be a notice but has huge impact on the system.
for example:
SS_SUBJECT_STATUS truncated to SS_SUBJECT_STAT.
Surprisingly, it seems that I'm alone. The closest article i found was
field name limited to 30 chars but that is for MSSQL. Setting the
defaultlrl also not working as the problem is in the field name, not the
content.
If you have any suggest, feel free to drop a comment here.
Quick Note (1)
I'm not back from hiatus, still am busy with day and night job which most likely end somewhere in the middle of December. However I have setup a dedicated website for Savvy.UI (or best known here as Savvy.JS) at SavvyUI.com to host development update as well as documentation for Savvy.UI. ChronoSight Wiki and ChronoSight Forum may be brought down temporarily unless I can make time to continue the development of ChronoSight.CMS. Some people keep asking me to release the CMS but it just not fully functional for general usage.
What make it worst, I just come out with a new idea for a new project which combine both PHP and JavaScript (namely Savvy.UI). The concept to the idea isn't new and there a number of group already have a working prototype and running system but all of it (As Far As I Know) are webservice and what I intent to do is actually public release version where everyone can download and install at their own hosting. Anyone interested to join me on this project?
Avoid Your E-mail From Becoming Spam
Let forget about mail() function in PHP, as most emailservers today will eventually mark e-mails sent using this function as spam. But fear not, there are better way to send e-mail and today and one of it is PHPMailer, it support e-mail sending using both method (mail() or SMTP method) but our problem will not be solve if we still using mail(), the use SMTP is the way to go by minimizing the possibility of your e-mails to end up in spam/junk folder.
No whitespace after HereDoc Syntax
In one of my previous entry I have introduce the usage of HereDoc Syntax in PHP, but please be cautious not to add whitespace right after you close your syntax or you will end up with this error.
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/example/domains/example.com/public_html/home.php on line 111
This may look like a simple error but most of the time you might forget that this error where from HereDoc Syntax because the message "on line 111" wouldn't help you solve the mistery as in most cases the problem started before line 111. Where actually do we not have whitespace? Sample code below illustrate the location of the actual error.
<?php
return <<<AJAX
"alertpop":"",
"jumpto":"",
"exec":"",
"result":""
AJAX;{do not add any whitespace here}