PHP | Obidos Technologies Knowledge Base

Join separate Date and Time fields to one field in MS SQL Server

Posted on July 31, 2017
/Under ColdFusion, Database, Lucee, PHP, Railo, Server, SQL Server
/With 0 Comments

When you have date and time separate in two fields, it becomes difficult to have date operation like add in them. To have a correct solution, we need to join these two fields and create a new DateTime value on which we can operate on. Use the following code in...Read more

$Hide the fractional part in a decimal number if it is .00, in PHP$

Hide the fractional part in a decimal number if it is .00, in PHP

Posted on April 21, 2017
/Under Apache, Internet, PHP, Server, Technology, Tomcat
/With 0 Comments

When displaying decimal numbers, it will show both the Integer and Fractional part even if the fractional part is 00. Like below: 2.35 3.50 2.00 If we need to hide the fractional part when it is 0, just add the number with 0 as below: <?php echo $amount + 0; ?>...Read more

Accurate way to round decimals in JavaScript

Posted on February 27, 2017
/Under ColdFusion, Internet, JavaScript, JSON, Node.JS, PHP, Technology
/With 0 Comments

The rounding problem can be avoided by using numbers represented in exponential notation: Number(Math.round(1.005+'e2')+'e-2'); // 1.01 Source: http://www.jacklmoore.com/notes/rounding-in-javascript/Read more

SOLVED QuickBooks Integration Error – EDGE-CR-ERR-8090 – Auth ID does not exist

Posted on October 14, 2016
/Under ColdFusion, Integration, JSON, MySQL, PHP, QuickBooks, Server, Technology
/With 0 Comments

Integration with QuickBooks is easy if you know the OAuth flow. QuickBooks uses the OAuth 1.0 specification. They provide libraries for PHP, Java and other popular languages. For ColdFusion/Railo, you can use the OAuth implementation from http://oauth.riaforge.org/. Usually the error messages from QB are self-explanatory and are mostly related with Signature...Read more

Fixing error with MySQL “Headers and client library minor version mismatch.”

Posted on August 18, 2016
/Under Database, MySQL, PHP, Server
/With 0 Comments

With PHP and MySQL, if the MySQL is upgraded you may end up with this error on every request to the database from PHP. This error means the MySQL library in PHP is not compatible with the version of MySQL it is connecting to. So, the solution is that you...Read more