10 replies to this topic

[Adson Aquino]

Olá galera, tenho um relátorio de gastos e está dando um problema na soma, se os valores a serem somados forem exemplo: 10.00 + 165.00 até aí tudo bem soma blz, mais se for acima de mil da pal ex: 165.00 + 3.980.00, como posso fazer para consertar isso. segue meu código abaixo.

<php
$soma = 0;
while($dados=pg_fetch_array($exec)) {
$valor = str_replace(',', '.', $dados['c16']);
$soma += number_format($valor, 2, '.', '');
?>

Espero alguma ajuda, obg.

['' sem.Ponto]

Você está somando 3.980.00 com separador de milhar? Se no banco estiver registrado "3.980,00", realmente está somando com o separador de milhar. Seria então a causa do problema...

Eu ví que você está gravando os valores num formato fora do padrão. Por quê você não grava os valores num campo DECIMAL? Assim fica melhor para trabalhar com os valores, vai até permirtir fazer cálculos na consulta.

Edit

Campo DECIMAL é do MySQL, no PG eu não sei dizer qual seria o campo certo, mas deve ter algum que faz a mesma coisa.

[Adson Aquino]

Você está somando 3.980.00 com separador de milhar? Se no banco estiver registrado "3.980,00", realmente está somando com o separador de milhar. Seria então a causa do problema...

Eu ví que você está gravando os valores num formato fora do padrão. Por quê você não grava os valores num campo DECIMAL? Assim fica melhor para trabalhar com os valores, vai até permirtir fazer cálculos na consulta.

Edit

Campo DECIMAL é do MySQL, no PG eu não sei dizer qual seria o campo certo, mas deve ter algum que faz a mesma coisa.

Valeu amigo, consegui arrumar na mascara do campo valor, trocando o ponto por branco, obg.

[ursolouco]

Salve,

Já deu uma olhada nas funções de precisão do PHP ?

http://www.php.net/m...t_BR/ref.bc.php

Espero que possa lhe ajudar

Abraços

[Miguceamma]

Drug Class Amoxicillin viagra online pharmacy Cialis 10 Mg Prezzo Farmacia Frontal Baldness Propecia
Pak For Sale viagra prescription Cialis Per Durata Cialis 14 Compresse Prezzo

[LarPhozyHah]

Cialis Costo Ufficiale levitra 40 mga for sale mexico beach Cheap Clomid In The Usa Achat Viagra Forum What Bacteria Does Amoxicillin Kill
Canadian Pharm Support Group Cialis Efectos Colaterales cialis Viagras Cialis Mail Order Levaquin 500mg Cod Only
Viagra Drug Information Colchicine cialis Pyridium No Script Needed Low Price
Propecia Testicle Pain Swelling Of The Lips Amoxicilina 500 Mg From Mexico Propecia Lakemedelsverket cialis Keflex Is Making Me Itch Cialis En Espana Lisinopril 10 Mg No Prescription

[RonsisM]

Propecia 1 Mg Nebenwirkungen cialis levitra sales viagra Kamagra Ajanta Pharma Viagra Cheapest Online
Progesterone For Sale Buy Buspirone For Cats Canada buy cialis What Is Extra Super Avana

[HaroNism]

Propecia Dht Hair Loss viagra online Lisinopril Overdose Legally Progesterone In Internet Keflex Bronchitis
Priligy Generico Foro viagra Cialis In Der Apotheke Kaufen
Online Viagra Erfahrung Pristiq Cialis Online Koln viagra Propecia Hiperplasia Prostatica Cialis Generique Efficace
Use Of Keflex For Dogs Where To Buy Sildensfil Citrate Online buy viagra online Order Propecia Discount Cialis Se Necesita Receta Medica Discount Buy Now Clobetasol
Tindamax Cephalexin Dog Thirsty Isotretinoin Buy Online Uk viagra Viagra Generika Bewertung
Kamagra 100 Mg Jelly online pharmacy Achat Vrai Kamagra Viagra Kaufen Gunstig Come Acquistare Viagra
discount isotretinoin in usa drugs with free shipping viagra Cephalexin 250 Vendo Cialis Barcelona
Pfizer Viagra Kaufen Rezeptfrei viagra Sale On Line Dutasteride Website Macclesfield Propecia Precio Laboratorio Soft Fruit Flavor Viagra
Amoxil Acheter generic cialis Generic Finasteride Pills Priligy Mercadolibre Venezuela
Amoxicillin Canine Dosage Canadian Internet Pharmacies Cialis 60 Mg Prices viagra Propecia Facmed Cialis Presentaciones
Rash Reaction To Amoxicillin levitra 5mg Preisvergleich Viagra Generika
Cialis Duracion buy viagra online Tarif Du Kamagra Isotretinoin tab internet pharmacy with free shipping
Order Accutane Online From Canada Buy Celebrex 200 Mg Levitra 20 Mg Online viagra vs cialis vs levitra samples Achat Clomid Viagra Cialis Opinioni Dth Viaga
Viagra Generico Quando viagra Amoxicillin Weight Dog Cialis Modo Empleo Vente Generic Kamagra Super Active

[RonsisM]

Niazagra Online viagra Rezept Fur Viagra Viagra Cialis Acheter Buy Name Brand Viagra Cialis Online
Amoxicillin Dosing Chart generic levitra 40 mg Cialis Zonder Voorschrift Comment Durer Longtemps Cialis 5 Mg Compresse
Levitra Online Overnight Delivery Viagra Cialis Farmaci viagra Prix Cialis Pharmacie Maroc Cialis Prix Conseille En Pharmacie Viagra Masculino

[sapedlok]

Discounts! top beauty treatments 2017 Products which fall under this return policy can be returned domestically, as long as they are unused and in the original packaging. No questions asked! If a product that falls under this guarantee is found to be counterfeit, you will get a full refund (shipping costs included). READ MORE Samanta Sheffild – zhena novogo premera Anglii ¹2VKWORLD VK800X 5.0 inch Android 5.1 3G Smartphone MTK6580 Quad Core 8GB ROM Dual Cameras GPS WiFi 59.99$3 camera 1 monitor 7 inch monitor video door phone intercom doorbell camera intercom monitor door phone intercom doorbell system ( 108.56 $)Glass, HyuWomen hoodies zipper girl winter loose fluffy bear ear hoodie hooded jacket warm outerwear coat cute sweatshirt ( 12.15 $)Electric Fire Rescue Toy Car with Lazy Arm Music Light Radio Educational Toy-12.75 $DOOGEE X5 5.0 inch Android 5.1 3G Smartphone MTK6580 Quad Core 1GB RAM + 8GB ROM OTA OTG GPS 59.99$Original Meizu EP-51 Bluetooth HiFi Music Sport In-ear Earbuds-31.87 $Wholesale Remove Control SD TF Card 1.44 inch LCD Wireless FM Transmitter Car MP3 Player car audio car stereo hot selling~ ( 3.27 $)Basic white leather and black velvet slip on womens sneaker ( 248.75 $) DSquared2Diy Diamond Painting Set ANIMAL Leopard Diamond Rhinestone Stick Square Drill Full Rhinestone Beadwork Hobby DMC E8 FMM3040-2002 ( 14.13 $)Jack purcell ltt ox white and road trip blue mens sneaker ( 83.45 $) Converse Limited EditionCasual women's strappy crochet backless dress ( 13.53 $)Original ZMI 2A Charger Adapter ( $6.23 )5pcslot Festoon CANBUS 36 39 41mm C5W ERROR FREE 5630 5730 9 LED smd interior White LED Dome Light SMD Roof bulbs Super Bright ( 8.56 $)
Discounts! the best beauty


Products which fall under this return policy can be returned domestically, as long as they are unused and in the original packaging. No questions asked!
If a product that falls under this guarantee is found to be counterfeit, you will get a full refund (shipping costs included).


READ MORE
Sinkler, Epton Bill
Brown Studded Leather Belt ( 198.00 $)
Petroleum velvet fabric platform sandal ( 318.29 $) Jil Sander
Udostoennie «Zolotoj indyushki»
Burvogue hot shapers for women slimming body shaper waist Belt girdles Firm Control Waist trainer plus size Shapwear ( 24.98 $)
Elegant women's round neck sleeveless jacquard princess dress ( 14.20 $)
UCANBE Brand Professional 15 Color Concealer 15 colors Facial Face Cream Care Camouflage Makeup base Palettes Cosmetic ( 2.39 $)
Orangered and Lily Fabric Sneaker ( 156.00 $)
women genuine leather backpacks for women vintage school bag for college girl travel bag backpack mochila santoro escolar BD-001 ( 49.00 $)
Brazilian Virgin Hair Kinky Curly Brazilian Human Hair Weave Bundles 7A Brazilian Deep Wave Curly Hair Rosa Queen Hair Products ( 81.72 $)
Brazilian body wave 3 bundles 8a grade virgin unprocessed human hair weave brazilian virgin hair body wave brazillian body wave ( 29.60 $)
Free shipping new 2014 handbags vintage classic leather women handbag red totes women messenger bags shoulder bag ( 27.68 $)
Lihoradka subbotnego vechera
Full Body PU Leather Flip Cover for UMI Touch ( $4.98 )
2017 new cotton fashion cap cap for men and women high quality outdoor baseball cap la ( 4.90 $)



Discounts! best products in usa


Products which fall under this return policy can be returned domestically, as long as they are unused and in the original packaging. No questions asked!
If a product that falls under this guarantee is found to be counterfeit, you will get a full refund (shipping costs included).


READ MORE
3 bundles brazilian virgin hair water wave virgin hair wet and wavy human hair bundles mink brazilian hair weave bundles osa ( 50.00 $)
Xenon h7 hid kit 55w h1 h3 h4 h7 h8 h10 h11 881 h27 hb3 9005 ( 18.89 $)
MACAW T1000 Bluetooth HiFi Sport Earbuds with Mic Volume Control-19.73 $
USB Dual Charger Fits for XiaoMi Yi Sports Camera - 5V / 2A ( $3.11 )
Needlework diamond painting cross stitch diamond embroidery wolves pictures of rhinestones hobbies and crafts diamond mosaic ( 11.19 $)
Red and Black Quilted Wallet On Chain ( 132.00 $)
Fashion plaid bling geometric patchwork tote bags for women luxury sac a main shoulder bag designer clutch famous brand handbags ( 36.58 $)
BEWELL Citizen 2035 Movement Men Quartz Watch-23.37 $
Large Crystal Stone Ring ( 118.00 $)
Original GameSir G2 Xiaoji Bluetooth Wireless Wired Gamepad Game Controller for Smartpone Tablet PC Notebook-23.28 $
Polkdot Silk Ascot ( 57.60 $)
OBrajen, Mark
2015 unprocessed virgin malaysian light yaki full lace wig no bangs 100 human hair full lace italy yaki wig for black women ( 100.74 $)
20pcs bag dahlia flower dahlia seeds not dahlia bulbs bonsai flower seeds gorgeous flower balcony potted ( 0.88 $)
Gift certificates - P. S. BOX. Impressions as a gift! A gift certificate! A gift certificate! Gifts with meaning! Internet gift shop.



Discounts! best seller products


Products which fall under this return policy can be returned domestically, as long as they are unused and in the original packaging. No questions asked!
If a product that falls under this guarantee is found to be counterfeit, you will get a full refund (shipping costs included).


READ MORE
Double Chiffon Silk Stole ( 68.60 $)
Pillar Aero PSR 1420 super light bladed spokes flat spokes J-bend and Straight spokes with free silver 14mm brass spoke nipples ( 53.60 $)
Newest Car Camera Car Dvr Blue Review Mirror Digital Video Recorder Auto Registrator Camcorder Full HD 1080P Camera Car Dvrs ( 59.98 $)
Premiya «Emmi» za luchshuyu muzhskuyu rol v dramaticheskom teleseriale
Nylon packing cube travel bag system durable 6 pieces one set large capacity of unisex clothing ( 9.81 $)
Stainless Steel Cardinal Points Rudder Pendant Necklace ( 109.00 $)
Backstage pass necklace ( 144.43 $) MM6 Maison Martin Margiela
Sexy dragonfly print plunging neck sleeveless dress for women ( 25.75 $)
New crossbody bags for women hollow out pu shoulder handbags bolsas femininas bag female messenger bag for women ( 39.80 $)
Albicocca Leather Sandal ( 142.50 $)
New original fashion orange top high quality luxury lock designer handbags famous brand real women bag evening bags totes fr028 ( 112.19 $)
Pisen 18650 power bank 20000mah lcd external battery portable mobile fast charger dual usb powerbank for iphone 6 samsung tablet ( 41.41 $)
REMAX Micro USB Fast Charging Data Sync Cable 2m ( $3.59 )
Opal Stone Stud Earrings Christmas Party 2016 Brand New Elegant Crystal Earrings For Women Trendy Gold Plated Women Earrings ( 2.16 $)
S15855 jjrc h15 large rc quadcopter one key auto return rc drone helicopter rtf uav with 0.3mp hd camera fs ( 132.41 $)



Discounts! skin product reviews


Products which fall under this return policy can be returned domestically, as long as they are unused and in the original packaging. No questions asked!
If a product that falls under this guarantee is found to be counterfeit, you will get a full refund (shipping costs included).


READ MORE
Cooper: We know Trump has no wiretapping facts
Men wallet pu leather portfolio 2016 famous brand jinbaolai male passport holder bag money pocket large capacity coin purses men ( 45.30 $)
Sexy Lace Bra Embroidery Women Underwear Black and White Sexy Push up Bralette 36D - 44 C D DD ( 7.99 $)
Bolsos mujer 2016 trapeze smiley tote bag luxury brand pu leather women handbag shoulder bag famous designer crossbody bags sac ( 38.99 $)
2015 new guitars 40-2 40 inch high quality acoustic guitar rosewood fingerboard guitarra with guitar strings ( 132.05 $)
EHEAR Car GPS Map HUD-11.64 $
8a brazilian virgin hair stema hair company brazilian deep wave 34 pc brazilian deep curly virgin hair deep wave brazilian hair ( 48.25 $)
Women handbag patent leather crossbody bags brand tote fashion women messenger bags clutch shoulder bag bolsas q0 ( 28.20 $)
Light blue perforated suede womens jacket ( 395.86 $) Forzieri
Men's solid color turn-down collar long sleeve shirt ( 15.25 $)
Cute Cat Pattern Case Cover For Apple iPhone 6 6s Plus 6Plus 4 4s 5 5s SE 5C Transparent Soft Silicone Cell Phone Cases ( 1.36 $)
Grade 7A Peruvian Virgin Hair Body Wave Queen Hair Products Peruvian Body Wave Human Hair 4 Bundles Deals Grace Hair Company ( 60.00 $)
2016 swimwear women s sexy mesh bikinis set hollow out bandage swimsuit strappy swimwear sexy bathing ( 8.40 $)
7a malaysian virgin hair lace closure straight human hair closure free middle 3 prat straight closure li&queen hair products ( 40.00 $)
Rarest Heirloom Super Giant Japan Red Strawberry Organic Seeds, Professional Pack, 100 Seeds Pack, Sweet Juicy Fruit E3063 ( 0.36 $)

[HaroNism]

Propecia Minox Got Precio De Kamagra En Farmacia cialis Acheter Vrai Viagra En Ligne En Antibes Canadaonlinepharmacy Amoxicillin Minocycline
Buy Zithromax Overnight Delivery cialis Finasteride Claravis Carmarthenshire