Posted by & filed under PHP Development.

When using the mysqli_bind_params() function, you may want to consider listing int parameters as strings if the number may be greater than the maximum allowed value for an int.

For Example:

If you specify type “i” (integer), the maximum value it allows you to have is 2^32-1 or 2147483647. So, if you are using UNSIGNED INTEGER or BIGINT in your database, then you are better off using “s” (string) for this.

Here’s a quick summary:

(un)signed TINYINT: i
(un)signed SMALLINT: i
(un)signed MEDIUMINT: i
signed INT: i
unsigned INT: s
(un)signed BIGINT: s

(VAR)CHAR, (TINY/SMALL/MEDIUM/BIG)TEXT/BLOB should all have “s”.

FLOAT/REAL/DOUBLE (PRECISION) should all be “d”.

So when you call your dbUpdate function, the following is correct for the initial 2billion records, but would lead to problems after that:

dbUpdate( $query, array("i", $bigIntValue) );

This is how it should be done:

dbUpdate( $query, array("s", $bigIntValue) );

This advice is for MySQL Databases.

Posted by & filed under PHP Development.

We’ve tried many different methods to set precision for a number variable (specifically a currency amount) and we’d like to share the best method we’ve found:

number_format(
   {number}, 
   {precision},
   'decimal_separator',
   '1000s_separator' );

Example:

number_format( $number, 2, '.', ',' );

Hope this helps!

We have also tried using round( $number, {precision} ) but it ignores zeros(0) within the precision numbers.

Example:

$number = 9.90;
round( $number, 2 ); // returns: 9.9

Posted by & filed under News & Updates.

July is quickly going to become a cornerstone in our company’s progress to becoming a major competitor in the web and software development industry. Our plans include the purchase of a dedicated server (hosted in Canada) to host our clients websites (only), a new logo along with new business cards and a new website. We’re also planning to submit our project plan for our up-and-coming major project to venture capitalists for financing.

Our iaps.php-cssFramework is being updated on a regular basis and we feel we now have a secure a flexible starting point for all projects (CMS and User-end). Our growth is directly related to the feedback provided by our clients. We hope you all enjoy our new endeavors.

Posted by & filed under News & Updates.

We just completed our new php framework and have fully tested the application. This framework can be integrated into any website and provides a solid base for updating and adding new information and pages. So far we have successfully completed 3 integrations of the framework with 2 more coming up within the week! We hope you all enjoy!

Posted by & filed under News & Updates.

FTPConn v3.1.0 has just been released. We have made several functionality changes that will allow for a smoother & seemless flow of the application. For more details, go to Projects & Downloads. Please contact us if you wish to have a FTP Client installed on your webserver!

Posted by & filed under News & Updates.

We have decided to use Jira Studio instead of Codendi for issue tracking, sub-versions, tasks & workflow, and source repository. Project development using this application starts today! We hope to have a full review of Jira by August 10th, 2009.

Posted by & filed under News & Updates.

We recently updated our portfolio and project & downloads page! We now offer project management, issue tracking and a source repository through 3rd party software. The current implementation we are testing is provided by Codendi. Please contact us if you’re interested in integration. Also, we have recently made changes to our terms & conditions and have re-written our Service Contract.