Last Updated: February 25, 2016
·
771
· dubrod

Database Integer Problem

#php
#csv
#sum
#integer
#equations

If your getting errors with array_sum or any simple integer based PHP function from a database where you imported data, like a CSV, its important you make sure the imported data is just numbers.

preg_replace('/[^0-9\.]/', '', ($row[22]))

will ensure you just have integer data

#php
#csv
#sum
#integer
#equations

Written by Wayne Roddy

Say Thanks
Respond

Related protips

HTML5 Mobile Device Camera Access

373.2K
20

Pretty print array php

311K
0

Laravel's .htaccess to remove "public" from URL

251.9K
10

Have a fresh tip? Share with Coderwall community!

Post
Post a tip
Best #Php Authors
projectcleverweb
516.8K
#php
#javascript
#css
brandonbeeks
373.1K
#php
#javascript
#css
jvinceso
311K
#php
#ASP
#JavaScript
hnordt
251.9K
#php
#laravel
#CoffeeScript
rmcdaniel
244.3K
#php
#JavaScript
#Open Source
Related Tags
#php
#csv
#sum
#integer
#equations
Sponsored by
#native_company#
#native_desc#
#native_cta#
Filed Under
PHP tips that still matter
Awesome Job
See All Jobs
Post a job for only $299
Did you know?

PHP applications still send a browser full of JavaScript. Hardening the server does not inventory the payment, analytics, and plugin scripts that run after the HTML is delivered.

Security insights from Cside

Thanks to our sponsor
Sponsored by #native_company# — Learn More
#native_title# #native_desc#
#native_cta#