PHP – ObidosTech Knowledge Base

Help snippets on NodeJs, React, ColdFusion, PHP, Android, iOS and tech news

ObidosTech

Obidos Technologies (P) Ltd is an off-shore development and maintenance center for ColdFusion applications, PHP application along with ReactJS, NodeJS

Using Server Sent Events (SSE) with Session

March 13, 2020March 13, 2020

2 mins read

SSE or server sent events are a great choice for pushing data from server to the clients. The benefit of SSE over web-sockets is that unlike web-sockets SSE is a…

ColdFusion Database Lucee PHP Railo Server SQL Server

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

July 31, 2017

1 min read

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…

Apache Internet PHP Server Technology Tomcat

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

April 21, 2017April 21, 2017

1 min read

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…

ColdFusion Internet JavaScript JSON Node.JS PHP Technology

Accurate way to round decimals in JavaScript

February 27, 2017February 27, 2017

1 min read

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/

ColdFusion Integration JSON MySQL PHP QuickBooks Server Technology

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

October 14, 2016October 19, 2016

2 mins read

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…

Database MySQL PHP Server

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

August 18, 2016

1 min read

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…

Category: PHP

Using Server Sent Events (SSE) with Session

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

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

Accurate way to round decimals in JavaScript

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

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

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