Jump to content


Photo

Como pegar o resultado de uma somatório feita do Banco de de dados Mys

PhPlot Mysql

  • Faça o login para participar
10 replies to this topic

#1 Marcelo Balbino

Marcelo Balbino

    Novato no fórum

  • Usuários
  • 1 posts
  • Sexo:Não informado

Posted 25/08/2016, 14:32

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



#2 ShZlot

ShZlot

    12 Horas

  • Moderadores
  • 121 posts
  • Sexo:Masculino
  • Localidade:Bahia

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 Guilherme Luiz

Guilherme Luiz

    Normal

  • Usuários
  • 78 posts
  • Sexo:Masculino
  • Localidade:São Paulo

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!


just its a lie when the truth is found !

#4 RonsisM

RonsisM

    Super Veterano

  • Usuários
  • 15724 posts
  • Sexo:Masculino
  • Localidade:Plovdiv

Posted 03/11/2017, 05:40

Cephalexin Warnings generic levitra no prescription Staxyn Price
Buy Viagra Online At Lowest Price Dosis De Kamagra Recomendada Mail Order Chalias buy cialis Generic Staxyn

#5 lapedlok

lapedlok

    Ativo

  • Usuários
  • 350 posts
  • Sexo:Feminino
  • Localidade:Braunschweig

Posted 04/11/2017, 09:17

Discounts! beauty products you need progect13.jpg 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). buy.png READ MORE Casual leopard lace up suede design women's flat shoes ( 21.45 $)LED Door Warning Light With FOR AUDI Logo Projector For Audi A1 A3 A4 A5 A6 A7 A8 R8 Q3 Q5 Q7 TT 80 B5 B6 B7 B8 C5 C6 R8 A4L A6L ( 10.00 $)counter strike globalFIREFLY 6S 4K WiFi Sport HD DV Camera-74.16 $болт коленвала форд фокусZOYO Flying Hero Infrared Control Helicopter-15.89 $Just 6 dollar real rex rabbit fur Winter female hair fur hat female autumn and winter ear cycling cap knitted hat northeast cap ( 6.50 $)Chakiris, Dzhordzhкрасный богатырь поселок владимирская областьFashion long sleeve off shoulder slash neck sexy club women dress slim bodycon knitted sweater knee-length party night dresses ( 20.98 $)Loren BekollBluboo X9 5.0 inch 4G Smartphone Android 5.1 MTK6753 64bit Octa Core 1.3GHz Fingerprint Sensor 13.0MP Main Camera IPS FHD Screen OTA 135.39$зимние резиновая обувь360 lace frontal with bundle pre plucked 7a 360 lace frontal closure with bundles loose wave peruvian virgin hair with closure ( 140.00 $)Ancient Greek Sandals with LALAoUNIS Agapi Snakes Black Leather Sandal ( 162.50 $) 37.jpg
Discounts! best hair mousse

progect13.jpg
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).

buy.png

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 )


25.jpg

#6 LarPhozyHah

LarPhozyHah

    Super Veterano

  • Usuários
  • 14515 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 04/11/2017, 20:53

Cialis 36 Where To Buy Amoxicillin Filtre Baclofen cialis online Mail Order Macrobid 100mg Mastercard Mail Order Discount Generic Doryx In Internet Cheapeast

#7 RonsisM

RonsisM

    Super Veterano

  • Usuários
  • 15724 posts
  • Sexo:Masculino
  • Localidade:Plovdiv

Posted 07/11/2017, 11:13

Cialis Brevetto viagra Cialis Come Agisce
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 LarPhozyHah

LarPhozyHah

    Super Veterano

  • Usuários
  • 14515 posts
  • Sexo:Masculino
  • Localidade:San Miguel de Tucuman

Posted 07/11/2017, 18:23

Prix De Xenical En France Clomid Pills For Sale Buy Levitra At Walmart viagra Amoxicillin Clavul Bayer Generic Generic Levitra 100mg Isotretinoin Shop
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 Miguceamma

Miguceamma

    MiguPenjisse

  • Usuários
  • 13201 posts

Posted 07/11/2017, 18:59

Doxycycline Epocrates Online viagra Propecia Topico Online Pyridium Mail Order Glendale
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 RonsisM

RonsisM

    Super Veterano

  • Usuários
  • 15724 posts
  • Sexo:Masculino
  • Localidade:Plovdiv

Posted 07/11/2017, 19:38

Viagra Mail Order No Prescription generic cialis Propecia Espana Online Mail Order Online Provera Clinofem Real Opinion Finasteride Propecia
Cialis Una Pastilla Francia Kamagra In Linea viagra prescription Cephalexin Rimadyl Mix

#11 zapedlok

zapedlok

    Expert

  • Usuários
  • 554 posts
  • Sexo:Feminino
  • Localidade:Waimea

Posted 09/11/2017, 13:15

Discounts! best product detail page design progect13.jpg 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). buy.png READ MORE Gradient Green Wool and Cashmere Stole ( 42.00 $)WIKILEAKS WL - 4405 Electric Heated Eyelash Curler-6.51 $ремкомплект грм змз 406Ulefone Tiger 4G Phablet-111.25 $100 pcs FREE SHIPPING Red carp,smell lure Red Grass Carp Baits Fishing Baits Fishing Lures ( 4.99 $)4 1 inch embedded car radio player 4016c car video mp5 players lcd display full viewing ( 48.62 $)Farfalla - silk square scarf ( 178.45 $) Emilio Pucciвпускной +и выпускной распредвал ваз 21122016 hot sale cycling bicycle bike carbon bottle cage bottle holder rack lightweight durable essential portabidones ( 2.06 $)Peruvian Virgin Hair Straight 4 Bundles Peruvian Straight Human Hair Weave Bundles Unprocessed Virgin Hair Lucky Queen Hair ( 56.00 $)Sloan small quilted-leather wrhodium finish chain shoulder bag ( 220.93 $) Michael KorsJust Escape Brown Strap Mens Watch ( 165.00 $)CHUWI VI10 PLUS Tablet PC-153.50 $Malaysian virgin hair with closure 3 bundle deals kinky curly weave human hair with closure malaysian curly hair with closure ( 85.00 $)Bike light with no battery mountain road bike bicycle lights leds tyre tire valve caps wheel ( 0.39 $) 29.jpg
Discounts! best catalog store

progect13.jpg
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).

buy.png

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 $)


49.jpg
Discounts! top beauty creams

progect13.jpg
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).

buy.png

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 $)


301.jpg
Discounts! best makeup products in the world

progect13.jpg
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).

buy.png

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 $


57bb.jpg
Discounts! best beauty products for 2017

progect13.jpg
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).

buy.png

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
болты гбц форд


73bb.jpg




1 user(s) are reading this topic

0 membro(s), 1 visitante(s) e 0 membros anônimo(s)

IPB Skin By Virteq