Tenho uma tabela em Mysql com as colunas: "Data, hora e leitura", consegui fazer a soma dos valores da coluna "leitura" para cada mês da coluna "data":
<?php
//Conexão e consulta ao Mysql
mysql_connect('localhost','user','senha') or die(mysql_error());
mysql_select_db('plan') or die(mysql_error());
$sql = mysql_query("select leitura, dat, SUM(leitura), month(dat) as cmonth from pluv group by month(dat) order by month(dat)");
$array = array();
$month = 0;
while($row = mysql_fetch_assoc($sql)){
if($row['cmonth'] != $month){
$month = $row['cmonth'];
$time = mktime(0,0,0,$month);
echo "".date("F", $time)." - ";
}
echo "{$row['SUM(leitura)']}<br />";
}
?>
Exibindo o seguinte resultado:
January - 100.02
February - 5.248
March - 200
Agora, preciso pegar esses resultados e gerar um gráfico, estou tentando o o Phplot, alguém poderia me ajudar?
Desde já agradeço.
Att.
Marcelo
Como pegar o resultado de uma somatório feita do Banco de de dados Mys
#1
Posted 25/08/2016, 14:32
- BobbyCak likes this
#2
Posted 25/08/2016, 23:31
Eu não conheço o Phplot, mas conheço o Google Charts https://developers.google.com/chart/
Exemplos: https://google-devel...ve/docs/gallery
Ele usa javascript, pode ser bem viável.
Trabalho desenvolvendo no melhor e mais completo CMS do tipo SaaS. Conheça você também e crie um site grátis no uCoz.
#3
Posted 05/09/2016, 16:43
Para gráficos muito bem elaborados e faceis de integrar com BD e PHP eu recomendo
https://www.amcharts...ascript-charts/
Utilizo essa ferramenta!
Muito facil, bonita e gratuita!
#4
Posted 03/11/2017, 05:40
Buy Viagra Online At Lowest Price Dosis De Kamagra Recomendada Mail Order Chalias buy cialis Generic Staxyn
#5
Posted 04/11/2017, 09:17
Discounts! best hair mousse
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
New suspension trainer fitness training strength training hanging strap workout sport equipment resistance bands hanging trainer ( 32.90 $)
цепь двигатель 406
40-17 new guitars 40 inch high quality acoustic guitar rosewood fingerboard guitarra with guitar strings ( 137.75 $)
Sexy halter neck lace splicing white women's baby dolls ( 4.64 $)
110m Knitted Style Adjustable PU Dog Leash ( $3.39 )
read +and draw перевод
выпускной распредвал ваз 2112
2pc camping outdoor survival emergency kit rescue blanket portable first aid curtain emergency camping blanket silver ( 6.56 $)
2016 antique crystal gold and silver plated buddha leopard head bracelet charm yoga bracelets for men ( 1.69 $)
Keaton optic white and black patent leather sneaker ( 112.33 $) Michael Kors
датчик коленвала 405 двигатель
Chic striped halter women's tankini set ( 13.97 $)
Curly wig glueless full lace human hair wigs short human hair lace front wigs black women brazilian u part bob wig black friday ( 60.00 $)
2017 new cotton fashion cap cap for men and women high quality outdoor baseball cap la ( 4.90 $)
3.7 - 5V Bluetooth MP3 Decoder Board ( $7.53 )
#6
Posted 04/11/2017, 20:53
#7
Posted 07/11/2017, 11:13
Effetti Cialis E Cocaina Women Viagra Pills viagra Viagra Alcool Danger
Achat De Cialis En Belgique Buy Viagra Online Without Prescription viagra prescription Cialis 40mg generic isotretinoin acne find real visa cod only
Cialis Vendita In Farmacia Prix Du Viagra Au Quebec Probleme Mit Levitra brand cialis and levitra Cialis Wirkung Lasst Nach Prix Kamagra 10 Mg Buy Cialis In Canada
Buy Buspirone For Cats Canada Fluoxetine Legally Comprar Propecia Original cialis Secure Zentel Discount Lubbock Buy Cheap Celebrex Online Cialis Hemorroides
#8
Posted 07/11/2017, 18:23
Elocon Elocom Fluconazole cialis buy online Causes Of Leukemia By Antibiotic Amoxicillin Sildenafil 50mg Tablets To Buy
Acheter Cialis Euroclinix viagra Find isotretinoin best website Cialis Barata Espana
Viagra Pills For Sale Cheap viagra Drug Interaction Ambien Keflex
Proscar Propecia Finasteride generic levitra on line Propecia Y Alcohol Dog Cephalexin Reactions
Priligy Online Espana viagra 5mg Buy Propecia Doxycycline From Canada
Cialis Conditionnement Prix Achat Cialis Pas Cher Where To Get Vigra With No Rx viagra Imitation Cialis 800 Number Acheter Du Clamoxil
Buy Doxycycline Doxycycline Online Levitra Precio Cialis 10 Efectos Secundarios viagra online prescription Cod Only Stendra 50mg Secure Ordering With Free Shipping Buy Cheap Propecia Uk
#9
Posted 07/11/2017, 18:59
Order Viagra Next Day Shipping viagra Cialis Super Force Online Shopping Tamoxifene Effets Secondaires
Totaldrugmart Com Levitra No Rx Cheap Ed Meds Uk online pharmacy Antibiotics Uk Online Buy Silagra Online
Where To Buy Tadalis Sx Soft Online Order Now Cod Fedex Stendra Drug Reviews levitra without a script Dos And Donts While Taking Amoxicillin Cialis 5 Mg Controindicazioni
Best Brand Viagra buy viagra online Sale Generic Pyridium Tablets Real Low Price
#10
Posted 07/11/2017, 19:38
Cialis Una Pastilla Francia Kamagra In Linea viagra prescription Cephalexin Rimadyl Mix
#11
Posted 09/11/2017, 13:15
Discounts! best catalog store
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
Teogo quality brand spring autumn women ultra light down 90% white duck down jacket coat ladies' hooded down parkas 18 colors ( 29.98 $)
Dark brown italian handmade leather loafer shoes ( 159.95 $) Pakerson
Ct all star hi camo black splash canvas sneaker ( 104.10 $) Converse Limited Edition
Hubsan X4 Camera Plus H107C+ 2.4GHz RC Quadcopter — RTF-55.89 $
Fashion cute owl backpack women cartoon school bags for teenagers girls pu leather women backpack 2016 brands mochila sac a dos ( 28.89 $)
Peruvian Virgin Hair Loose Wave 4 Bundles Peruvian Loose Wave Curly Weave Human Hair Peruvian Curly Hair Loose Curly Virgin Hair ( 53.60 $)
Igri s Razumom (Video)
Women's 1 pcs 7a virgin hair wavy brazil human hair weave ( 68.76 $)
shoppinglive первый немецкий телемагазин товар дня
Metal cat keychains key rings fashion animal key chains personalized car key holder pendant women bag charms key rings accessory ( 1.70 $)
Bohemian women's print plunging neck lace up dress ( 18.57 $)
Vernuvshijsya (Rodina)
амортизаторы ваз 2110 отзывы
Gem white leather slip-on sneaker ( 283.52 $) Pierre Hardy
Free shipping !! 15 pcs Soft Synthetic Hair make up tools kit Cosmetic Beauty Makeup Brush Black Sets with Leather Case ( 11.99 $)
Discounts! top beauty creams
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
world war 2 combat iwo jima
Aiwatch C5 Sports Smartwatch Phone-61.99 $
JISIWEI S+ Smart Robotic Vacuum Cleaner Sweeping Cleaning Machine HD Audio Video APP Remote Control 15 Degree Intelligent Climbing Function 399.00$
Multicolor Drop Earrings ( 198.00 $)
Ombre brazilian hair 7a brazilian virgin hair body wave 3pcs brazilian hair weave bundles human hair weave brazilian body wave ( 89.67 $)
Oem car windscreen chip crack repair tool kit diy window screen polishing scratches glass practical auto ( 3.68 $)
Edison bulb loft classical vintage pendant light lamp with with glass shade(e27e26 base) free shipping ( 127.98 $)
Honey blonde russian hair weave 613 blonde virgin hair 1pcslot human hair extensions platinum blonde wefts,aliexpress uk ( 48.39 $)
Brazilian body wave 3 bundles mink brazilian virgin hair body wave brazilian hair bundles cheap human hair extensions no tangle ( 45.00 $)
Serijnih kvartirnih vorov stolichnaya policiya zaderzhivala so strelboj
энгри бердз 2016
Mongolian kinky curly virgin hair 3pcs mongolian afro kinky curly hair bundles curly weave human hair rosa queen hair products ( 94.00 $)
Remsi, Enn
A24 Blue Light Hot Car Auto Metal LED Power Push Button Switch Latching Type On-off 12V 16mm 3A250VAC ( 2.28 $)
18 SheetsSet French Manicure DIY Nail Art Tips Guides Stickers Stencil Strip #M01615 ( 1.80 $)
Discounts! best makeup products in the world
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
дешевые аккаунты battlefield
1 Pcs Red Brand New Cheap Pet Animal Dog Cat Nail Clippers Scissors pet Toe Care Nail Grooming Trimmer Clipper Stainless steel ( 2.54 $)
Free shipping Hand Tools 32 PcsSet Telecommunications Precision Screwdriver Removable Screw Sets ( 29.90 $)
Fonmor 2016 new men's bags cowhide leather shoulder bag multiple zipper leisure bag man cross body travel bags ( 39.81 $)
Slinx 1402 5mm neoprene camouflage men two pieces scuba diving suit snorkeling spearfishing fishermen swimwear wetsuit hooded ( 119.63 $)
Ulefone Future 4G Phablet-321.29 $
метки грм змз 406
Green Frog Brooch ( 157.00 $)
Stonton, Imelda
TINYAT Men School Backpack Functional Computer 17 INCH Laptop Backpack For Teenagers High Capacity Backpack T807 MichIla Black ( 59.99 $)
coque p8 lite case luxury original hard case for huawei ascend p8 lite p 8 p8lite brand phone wood protective back cover cases ( 2.80 $)
1pc size1 size4 fishing hook mepps spinner fishing lures with knife edged treble hooks bulk fishing ( 2.68 $)
Hejli, Dzheki Erl
BEST Peruvian Straight Virgin Hair 4 Bundles Queen Like Hair Products Human Hair Weave Unprocessed Peruvian Virgin Hair Straight ( 65.00 $)
ALONG CAM - 2002 Video Recorder-262.77 $
Discounts! best beauty products for 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
Original Meizu HD50 Hi-Fi On — Ear Headphones-58.65 $
Flyco 3D floating head Rechargeable Portable body washable Electric Shaver Led Light Fast Charge Triple Blade barbeador FS376 ( 58.50 $)
Igra prestolov (roman)
Waterproof Case + Backup Battery Set-30.39 $
Wireless wired house burglar door alarme secure gsm alarm system kerui russianspanishenglish voice androidios app control ( 106.10 $)
Stylish short sleeve scoop neck spliced loose-fitting printed women's dress ( 13.54 $)
Revolver sterling silver ring wchain ( 217.18 $) Calibro12
2016 hot women famous brands large tote shoulder bag female designer handbags high quality pu leather top-handle bags sac a main ( 49.97 $)
Kitchenaid cooking polish grinding machine food processor household fish electric meat grinder ( 178.17 $)
Stylish owl pattern zipper design scoop neck long sleeve sweatershirt for women ( 17.22 $)
Funny cartoon print short sleeves round neck men's t-shirt ( 14.02 $)
Ds-2cd2532f-is ds-2cd2532f-i s 3mp ip mini dome cctv poe built-in microphone mic and micro card slot alarm audio ( 115.90 $)
Vesennyaya uborka v Moskve nachalas ranshe obichnogo
Chromium skachat besplatno Chromium 59.0.3063.0
болты гбц форд
1 user(s) are reading this topic
0 membro(s), 1 visitante(s) e 0 membros anônimo(s)