I just don't see some of the data.

I manage MySQL databases. And this was not difficult before. But now I tried many thoughts and ideas how to solve the complexity, but didn't correct the problem. I can't access the amount of data due to the complexity of the program. And I can't understand what to do about it.

Posted by TaylorHaynes 4 months ago


How to connect my arduino uno to Internet to connect to MYSQL

Hi - I have arduino uno card which has a light sensor. I would want to transfer the light readings to MySQL database. How do I do it? I can write a sketch that can connect to MySQL and insert the data and upload the same to arduino card. But how will my ardino card connect to MySQL. Can you help me here as I am beginner to these topics? Regards, Harish

Posted by harishkompelh 2 years ago


Got my Raspberry Webserver running - what to do now?

See my Setup here: http://langeder.no-ip.org/cms/index.php?p=raspberry-pi-server Now i would like to know what else i can do to improve it (both, setup and website) thanks already

Posted by miicchhii 6 years ago


Achiev'ibles - Some interesting statistics

Hi Everyone. Tonight I did some updates to the Perl script which scrapes the statistics from your Instructable profile page. With the changes I made I now collect 3 more stats that I didn't before, because they were kept in weird places. As of tonight I'm now also collecting the number of people you're following, the number of favourites you have and your number of best answers (which is hidden, you can normally only see it by looking at the HTML). (Click here if you haven't a clue what I'm talking about and haven't heard of Achiev'ibles before) So with these new stats, I thought it'd be fun to announce the 15 members with the most of each stat. And so here they are! Following: mary+candy 1450 jessyratfink 1161 scoochmaroo 979 Dr.+Pepper 845 Goodhart 755 sunshiine 697 dombeef 655 Hiyadudez 607 zieak 298 nfk11 257 knexinventer 249 AngryRedhead 230 PotatoCoffee 206 MegaMetal8 203 poofrabbit 190 ----- Favourites: rockhardmj 2344 poofrabbit 1039 MichelMoermans 439 knexinventer 380 ewilhelm 320 CrayfishYAY 282 possum888 272 annahowardshaw 255 canida 252 Kryptonite 236 DJ+Radio 226 dombeef 225 Win+Guy 224 Kaelessin 213 iceng 199 Lithium+Rain 199 ----- Best Answers: steveastrouk 835 Re-design 692 lemonie 575 Kiteman 365 kelseymh 344 rickharris 334 iceng 228 canucksgirl 214 NachoMahma 178 AndyGadget 161 RavingMadStudios 129 Vyger 127 yokozuna 103 jeff-o 102 gmxx 90 mikeasaurus 89 Ok so I actually included 16 for favourites and best answers, because the 16th places were so close to 15th. Interesting stats? It should also be remembered that these aren't site wide, just for the 300 active site users that have signed up to be on the list. Finally, Canucksgirl sent me a new patch design this week. I'm not yet collecting the number of featured yet as I can't find it as a raw number, only as a percentage. Image below!

Posted by Jayefuu 6 years ago


Feedback for my website?

After a couple of months of building my website, it is finally in a state where I am proud of it! However the people using it are my friends, and I need some fresh eyes for feedback. Basically it's called Come Clean, and you make confessions to get them off your chest. Simple idea really. So please visit my website and tell me what you think: http://www.comeclean.co.nz       If you think something is good or bad, or if you spot a bug, leave a comment :) Thanks!

Posted by asasklfjklasfkljasklfjaklfsjkl 7 years ago


Total Views Count - Update

Tomorrow will be the first time I've posted stats from my Total Views Count script since January. I had some problems with the script breaking and losing the data, then was very busy throughout February/March since I was at Instructables HQ as an Artist in Residence, then when I got home to the UK I didn't have the motivation to fix it. Well, I've now started work on it again and last Friday I ran it for the first time since January. Tomorrow I'll be running it again and will have a gain value for each group member to share with everyone. It's still not completely finished, below is a description of how it worked before, how I've changed it and what I'm going to change further. Skip to the last bit if you want to read what the group's going to change into. Where it was: I used to run the group once per week by opening a Perl script on my desktop computer. The script automatically visited each of your profiles and added the total views count to a new column in a spreadsheet. Instructables updated some code, my script got confused, didn't update the spreadsheet properly and so all the data went screwy. I had to then post a forum topic and hand out patches, it took a long time. Where it is now: I've rewritten the Perl script, it now saves the data to a MySQL database instead of a spreadsheet. It also gathers far more data: total views, number of instructables, comments total, best answers total, number of forum topics, number of subscribers. I have a web page that looks up the total views from that database and displays a list I can copy to a forum topic. I still have to run it manually like before but it's much less hassle. Where it's going: I have spent a few hours working on learning to get Perl scripts working on my personal website. I can now automatically run them once per day, which I didn't know how to do. I now need to: 1) Check that the total views script will run daily 2) Write functionality to patch automatically 3) Design more patches! Once I have total views patches sending automatically I would like to award people for the following:   Total Views: 10k, 25k, 50k, 100k, 250k, 500k, 1m Subscribers: 10, 25, 50, 100, 250, 500, 1000 Answers: 10, 25, 50, 100, 250, 500, 1000 Best Answers: 1, 5, 10, 25, 50, 100, 200, 300, 400, 500 Instructables: 1, 5, 10, 25, 50, 75, 100, 200 Comments: 50, 100, 250, 500, 1000, 2000, 3000 Subscriptions: The newest site update now lets me see how many people YOU'VE subscribed to. The more you subscribe to. You'll earn patches for more subscriptions. If you're arty and want to help out with this bit, please volunteer, it'll save me some time and they'll look prettier. The cartoons Caitlinsdad did for the total views patches were fantastic, but last time I asked he was too busy to design more. 4) Implement automatic sending out of all of the types of patches 5) Change the name of the group to reflect that it no longer really is just to show a list of total views. That's been surpassed when HQ added the baseball cards to profiles. Got a suggestion? Once done, the weekly forum topic that I post will become a pretty list of who's been awarded what patches. Let me know in the comments if you've got feature ideas you'd like to see implemented or want to help out. This group's been going 2 years now! Thanks! James

Posted by Jayefuu 6 years ago


Total Views Count - 29/06/2012

Hi, For the first time since January, here is the total views count. To get your name on the list, join this group. To learn about changes coming soon or help out, read this forum topic. To make sure you don't miss any future total views topics, click the subscribe button :) James   22/06/2012 29/06/2012 Gain scoochmaroo 9454382 9567558 113176 canida 6580997 6621699 40702 fungus+amungus 5662479 5685979 23500 randofo 5086564 5143862 57298 jessyratfink 3575389 3620957 45568 Honus 3446295 3458226 11931 Kiteman 2567393 2581067 13674 Plasmana 2503911 2514783 10872 ChrysN 2114462 2136749 22287 Tool+Using+Animal 2083765 2091376 7611 Creativeman 1674743 1692508 17765 chr 1581811 1596307 14496 drinkmorecoffee 1584035 1593703 9668 mikeasaurus 1557247 1575847 18600 killerjackalope 1465376 1472077 6701 T3h_Muffinator 1410280 1413828 3548 zieak 1394842 1398999 4157 frenzy 1327979 1337871 9892 Weissensteinburg 1286935 1294102 7167 gmjhowe 1281064 1284167 3103 lemonie 1273318 1279085 5767 Frivolous+Engineering 1111455 1114063 2608 mikey77 967945 972831 4886 shesparticular 952056 956215 4159 Brennn10 923565 927382 3817 jeff-o 873274 878857 5583 scraptopower 852492 858851 6359 aeray 820575 827428 6853 CameronSS 808453 814041 5588 ModMischief 806623 812563 5940 Mrballeng 787977 795980 8003 laxap 767493 770365 2872 PKM 764548 767407 2859 depotdevoid 724990 728446 3456 starshipminivan 705115 712786 7671 belsey 699344 704966 5622 Jayefuu 670406 673240 2834 Gadget+Gangster 565017 572045 7028 BrittLiv 509178 513120 3942 AngryRedhead 503657 507339 3682 rimar2000 459418 464651 5233 vishalapr 376051 377804 1753 mary+candy 371889 374995 3106 Spl1nt3rC3ll 368846 370582 1736 Vyger 335427 337019 1592 KentsOkay 335273 336442 1169 rickharris 332788 334730 1942 Greasetattoo 324459 328371 3912 scooter76 318508 319026 518 Ninzerbean 317347 319005 1658 Lithium+Rain 300597 303928 3331 sunshiine 286748 291077 4329 Xellers 286854 288559 1705 Computothought 278467 283145 4678 Technochicken 277060 278577 1517 AndyGadget 271024 272312 1288 knife141 267537 270139 2602 bajablue 254545 258017 3472 justjonty 248744 251153 2409 Hiyadudez 236714 238477 1763 iminthebathroom 236012 237193 1181 bertus52x11 233305 234463 1158 dark+sponge 232299 232768 469 annahowardshaw 230366 232643 2277 bongodrummer 230293 231208 915 janw 226948 228242 1294 JamesRPatrick 222591 223846 1255 comodore 213528 214394 866 Nelson_Yepez 206919 208884 1965 jen7714 206024 208729 2705 Lynne+Bruning 207865 208630 765 thermoelectric 206537 208630 2093 Kaelessin 206143 207054 911 craftknowitall 181860 205863 24003 yokozuna 201703 202540 837 coolbeansbaby68 199176 200495 1319 Dr.Paj 193293 194094 801 RavingMadStudios 190979 193219 2240 ynze 164288 165097 809 Jimmy+Proton 161909 164480 2571 WYE_Lance 141887 150909 9022 I_am_Canadian 149639 150398 759 The+Jamalam 149938 150349 411 lw119 144719 148871 4152 DJ+Radio 145088 145970 882 marc.cryan 141701 142650 949 HHarry 138864 142220 3356 wizgirl 137984 139776 1792 Goodhart 136570 137068 498 susanrm 129038 131415 2377 Mr.Sanchez 127848 128623 775 The+Papier+Boy 127477 128106 629 Killer%7ESafeCracker 119226 121084 1858 MichelMoermans 112631 113418 787 Biggsy 108708 109910 1202 dombeef 103014 103515 501 cammers 99401 100327 926 mman1506 97771 98410 639 blinkyblinky 96174 97936 1762 fjordcarver 96613 97479 866 KoffeeKommando 89432 90204 772 Shadowman39 84998 85852 854 beanieostrich 81634 82496 862 Re-design 81681 82271 590 agis68 81217 81661 444 LargeMouthBass 80726 81544 818 monsterlego 74753 76941 2188 The+Ideanator 75342 75713 371 ajleece 72840 73052 212 kelseymh 69920 70359 439 diyoutdoorsman 68827 69591 764 cdawisconsin 68287 68960 673 TabbyDeAnne 67271 68104 833 arthurb 67484 67655 171 TitanTechRobotics 66836 67631 795 Winged+Fist 65718 66989 1271 Sunkicked 64561 64905 344 EmmettO 64189 64521 332 coolpizzadude 64020 64463 443 Win+Guy 62011 62472 461 mkanoap 61262 61649 387 jwystup 59660 60044 384 Berkin 57854 58258 404 lizzyastro 55923 56617 694 nickodemus 54390 54764 374 knuckel 54226 54547 321 iceng 53199 53457 258 TSC 50716 51083 367 kcls 49768 50132 364 cbm104 49300 49827 527 ahrshin 49075 49392 317 Z.Backas 48987 49322 335 Mimikry 48620 49121 501 krysteanuh 47533 47917 384 lilyfrancis 47699 47834 135 ilpug 46894 47601 707 MotaBoi 44437 44660 223 patriots8888 44149 44425 276 tqwerty 43860 44185 325 steveastrouk 43516 43915 399 Rob+O 43333 43577 244 possum888 42559 42820 261 Bot1398 39780 41279 1499 razvan_iycdi 39796 40767 971 drknotter 40262 40666 404 zack247 40101 40589 488 Tornado96 39610 40016 406 splazem 39414 39854 440 Data643 39313 39509 196 qazwsx755 38144 38801 657 shadowninja31 36251 36365 114 lil+larry 34978 35373 395 Derin 34993 35260 267 peguiono 34797 34900 103 Sorunome 33356 33889 533 canucksgirl 32909 33855 946 plane+phanatic 33086 33230 144 CrayfishYAY 30732 30825 93 zurichko 29925 30614 689 Dr.+Pepper 29253 29439 186 m6233555m 28857 28900 43 Knex_Gun_Builder 28671 28760 89 Twinmum 27970 28265 295 fdmjh 27713 27917 204 Legofanatic 26979 27225 246 nutsandbolts_64 26846 27092 246 aeronut01 26887 27079 192 poofrabbit 25487 26419 932 colorex 25076 25459 383 floris2burn 25105 25186 81 Tom+Buckey 24681 24768 87 mJusticz 24538 24752 214 Nostalgic+Guy 23220 23344 124 mistyp 22325 22931 606 zascecs 22156 22268 112 RollerScrapper 21904 22220 316 knexinventer 21620 21895 275 robot1398 21495 21870 375 acidbass 21418 21648 230 username252 20187 20458 271 A-Nony-Mus 20027 20254 227 knexsuperbuilderfreak 18929 19012 83 bricabracwizard 17940 18131 191 Football+viking+boy 16059 16244 185 masterochicken 15470 15543 73 LoneWolf 15323 15541 218 Zaphod+Beetlebrox 14123 15411 1288 Kryptonite 14831 15035 204 Super_Nerd 14376 14711 335 iproberry1 13707 14393 686 RNB 13939 14076 137 NatNoBrains 13862 13981 119 FrozenStar 13488 13588 100 Mahmoud+Alaa 12298 13067 769 NachoMahma 12866 12887 21 king1000 12749 12811 62 moocowdog 12103 12181 78 cherishcherub 11986 12036 50 furrysalamander 11249 11404 155 slithien 11110 11239 129 TheMacyC 10617 10875 258 Kaptain+Kool 10488 10642 154 35Timmy 9142 9326 184 wareneutron 8752 8860 108 tech+dawg 8026 8360 334 tbcross 7713 7756 43 thegeeke 7222 7463 241 Randomguy65 7276 7371 95 ElvenChild 7010 7077 67 happyjo 6773 6838 65 MegaMetal8 6536 6578 42 jamesdude 6122 6144 22 solarblade90 6040 6083 43 BladeFyre+Studios 5823 5857 34 Jag56 5668 5716 48 nfk11 5550 5585 35 emilyvanleemput 5030 5385 355 TheAwesomestDude 4995 5078 83 9400dk 4980 4990 10 White+Shadow 4580 4726 146 mg0930mg 4695 4713 18 neuropol 4420 4488 68 iApple+guy 4106 4211 105 AwesomeSwordGuy 4097 4128 31 rockhardmj 2082 4098 2016 shadon 3650 3674 24 LivStoleYourPie 3324 3377 53 cj81499 3054 3062 8 gmxx 3030 3043 13 cyanyears 2870 2905 35 BLUEBLOBS2 2719 2845 126 PotatoCoffee 2523 2613 90 Black+Panther+Knex 2162 2203 41 vicvelcro 2104 2131 27 Mutantflame 2108 2119 11 j.g.kuster 1913 1980 67 The+Chunky+Sniper%21 1653 1677 24 FastLearner 1553 1566 13 daredevil499 1406 1434 28 kyleslab 1016 1027 11 Jeff+Kallaus 1010 1023 13 protolabs 860 956 96 CeruleanPhoenix 753 763 10 Alexvolos1 590 594 4 Fr-Pa-Co 473 475 2 %28YOUR+N 261 263 2 heratio 244 246 2 schumi23 58 95 37 lightingever 13 13 0

Posted by Jayefuu 6 years ago


send mq7 or other sensors data to mysql of local website via NodeMcu-esp8266

Hi guys im doing a project about uploading sensors data to database of my local site in the internet (via NodeMcu) i install nodemcu libraries to my arduino IDE & can upload easily arduino examples and running well, but don't know how can read sensors data and send it to my website host in .txt format or sql to access it in host & show it on my website. I try this process with one mq7 gas sensor to know what should i do and after success that example continue it, but i stuck in first step. please help me MASTER guys:(((

Posted by hadi95126 1 year ago


Suggestion: Instructibles should host a website catagory.

Is it realistic for me to think that Instructibles should host a Website Catagory? I happen to be a 'junior' webmaster and would greatly appreciate some instructibles on php, mysql, mail servers. etc.

Posted by mattameo213 9 years ago


About making Single Board Computers...

Hi guys! I just wondered how can I make a custom Single Board Computer... I am interested to make a custom 8 bit AVR SBC and 32 bit ARM SBC (Must I learn even with the 16 bit architecture?) in a cheap way and without the aid of Raspberry Pi and Arduino. I have these questions: - There is any book or else about learn making Single Board Computers? - Where can I find the components for the board? - I can program and I know a few of many languages (C,C++,Python,Javascript,HTML5,CSS,PHP,MySql). Must I make an OS for everything for make my board work or I can make a "bootable software" (like a MP3 player)? And again,there is a book or else for learn this? Thank you for your time!

Posted by MichaelP170 2 years ago


Instructables Internship - Day 4

Alo Again,Well, this morning I didn't have the opportunity to burn my PB sandwich, not only because it was a PB&J; sandwich, but because the oven was filled with semi-burnt roasted tomatoes/garlic.Anyhow, Today I did some more outreach for the new Launch It! Contest and... drumroll please.... Billy and I shipped all of the remaining Laser Cutter Contest Winners' prizes! Woo Hoo! Other than that, the morning was pretty chill. I'm getting used to the much more relaxed setting here at Instructables. At all of my other internships I've had, everything was always so fast-paced, tense, and ridiculously demanding. At Instructables, everyone's just Chill. Everyone enjoys what they're doing. It's awesome.Also, I downloaded the Instructables MySQL dumpfile from Rachel, and I'm in the process of getting it back into MySQL. Eventually, I'm going to try and make some cool new statistic features for you guys!Billy and I tested out some LEDs and my ultra-thin/flexible solar panels, which are hella awesome. The specs say that they get 3V @ 22 mA max in the sunlight, but yesterday, I got that in the shade. In the sunlight?: 4.19V!After that, Jason, Billy, Noah and I checked out the Water Jet in Instructables' machine shop. Billy had to cut some stuff for a project of his, but watching the machine "do its thing" was really cool. There's so much awesome stuff here, I still can't believe it.Noah, Jason, and I then picked out some stuff that was going to get thrown out to use in Proj. X, and we ordered the Surgical Tubing, too!Then, Jason, Mike (Works for Potenco), and I went to the beach to check out the kite boarders, and fly the trainer kite. (Eventually, we'll get to kite board, too!)Alright, I think that I'm actually going to go get started on Proj. X now...I've included some pictures that I've taken throughout the day.Cheers,-MuffinatorP.S. I came up with an awesome badge idea, and I'll draw it up today on the computer. I'll post it by tonight, so make sure you tell me if you like it or not!

Posted by T3h_Muffinator 11 years ago


Let Er Rip guys.

I just put a new Forum up on my server. I want to see what it's breaking point is and also would find it handy to get ANY feedback from it, I know there will be a couple things astrew on my forum, but for the most part it's your average SMF forum, with a little bit of work done to it to set up the settings to my likings and changed the theme.I know there are a malicious few that will stumble across my forum link (not necessarily members on this website), but I welcome the testing of my server's security, as I also need to know of any leaks.Also, aside from the testing aspect of my forum, I welcome new users, as I would like to have a user-base of more than 5-6 people, just makes things more exciting ya-kno? I plan to make computer utilities accessible to members and guests, however all other downloads are off limits to guests, you must register, although I haven't really got much to download, there are a couple things to see in there so far.I thank any one of you's who takes time to look this over for me.However, don't try any funny stuff with my ftp access or the rest of my system, as it's set up fairly well and tight and you'll most likely get yourself automatically banned, the Apache, mysql, and php however, I do not think are completely secure, like I said, do test it out.

Posted by Punkguyta 9 years ago


Failed Experimentation : AI : My new creature is alive !

.It's alive !Alive, yes, but not as much intelligent than expected ..........Instead of watching a stupid movie at TV, I decided to write a tiny AI programme all in PHP.My goal was to get some functionalities comparable to logic programming languages like Prolog.In simpler words : I wanted to create a programme that could learn facts, and find the solutions to some logical problems.For instance :> blue is colour.Okay.> carrot is vegetable.Okay.> blue is colour ?Yes.> blue is vegetable ?No.> carrot is colour ?No.etc.So far, I can teach it facts in the form of 3-words-affirmations, and I can ask it questions and definitions, and the creature is able to find some connections between facts.Experimentation #1 : > red is colour.Okay> black is colour.Okay> orange is colour.Okay> orange is fruit.Okay(Here, we have a trap : orange is both a color and a fruit.)> red is colour ?Yes> black is fruit ?No> orange is colour ?Yes> orange is fruit ?Yes(Good. The beast did not fall in the trap.)> translate : red- "colour"> translate : orange- "colour"- "fruit"> translate : colour- "red"- "black"- "orange"Good ! The beast can give a sense to the words it learned.Experimentation #2 :> Paul is human.Okay> human eat fruit.Okay> apple is fruit.Okay> human is animal.Okay> animal eat meat.Okay> animal is mortal.OkayNow, let's see if it can "chain" the facts in a logical manner :> translate : Paul- "human"Here it should have replied : "human", "animal" and "mortal", since human are animals, and animals are mortal ...Let's see how it defines "Paul" :> define : Paul- Paul is humanMy creature seems obviously narrow minded ...Let's quiz it now :> Paul is apple ?No> Paul is fruit ?No> Paul is human ?Yes> human is Paul ?Yes> Paul is Paul ?Yes> Paul eat fruit ?Yes> Paul eat apple ?Yes> Paul is animal ?Yes> Paul eat meat ?No> Paul is mortal ?YesAs we can see, it successfully (and surprisingly) replied correctly to each question by connecting facts together, excepted for "Paul eat meat ?".At this question, it should have replied "yes", since it knows that "Paul is human", "human is animal" and "animal eat meat". But it did not ... ... and it's bizarre since it can reply correctly to "Paul is mortal ?", from "Paul is human", "human is animal" and "animal is mortal", or to "Paul eat apple ?" from "Paul is human", " human eat fruit" and "apple is fruit" ...Interesting, isn't it ? =o)If you want, you can submit your facts and questions to my experimental creature (which has no name yet) =o)What would be interesting also, is to confront it to a "paradox" just to see how it behaves ! =o)20080625 : For those of you who would like to have a look at the guts of the beast, here is available the source code.However, keep it mind it's a spaghetti-code and many function names are in french (as well as comments).Also, this version relies on MySQL to store and query facts (I'm planning to replace it with simple arrays though), which make the code slightly more complicated than required ...The main code makes less than 250 lines =o)There is no direct input interface : instead, it use scripts (exp_*.php) that call functions. For example :declarer("red","is","colour"); // <---- declarationsdeclarer("black","is","colour");declarer("orange","is","colour");declarer("orange","is","fruit");verifier("red","is","colour"); // <---- questionsverifier("black","is","fruit");verifier("orange","is","colour");verifier("orange","is","fruit");... which is slightly more complicated than what I showed above for the sake of comprehension and simplification !

Posted by chooseausername 10 years ago