arduino mega ethernet shield tft display pricelist

When I try adding any code for the SD card (card inserted into the Ethernet shield slot), it initializes the SD card, but can"t find the Ethernet shield. If I remove the SD card, it obviously can"t find it, but the ethernet shield works.

I suspect this has something to do with the various chip selects. Some posts say the ethernet CS is on pin 10, others refer to 53 for MEGA. I tried both, no luck.

If it is the official Arduino Ethernet Shield, you can probably fit a 6-way IDC ribbon connector onto the 3x2 male pins at the back of your display and then attach the wires to digital#51, 52, 53 on the Mega2560. I would solder the ribbon wires onto some real male header. This will give a good electrical connection to the MEGA2560 female header.

As you have realised, no one can really help unless you say which 7" TFT and which pins it uses. Are they in conflict with the Ethernet Shield"s pin usage?

My idea is to use only one SDCard, de Ethernet Sd card would be the one to use for everithing. So the question is how to connect (by wiring) the TFT to the arduino board, and know if i have to make any changes on tft configuration to disable de microsd to not cause any conflict with the microsd ethernet card.

ok so i own a arduino mega 2560 with a 3.2 tft touch screen and LCD shield, recently just bought a Ethernet shield and connected to the mega and ended up with a white screen... if i remove the Ethernet shield, then the tft will display like normal... any idea why i am getting this white screen when the Ethernet shield is plugged in?

i haven"t defined the Ethernet shield but i don"t think it matters as the tft is all connected together as a stack anyways, So even if the Ethernet is not being used... wouldn"t the tft still displays?

Description:This Package includes 1 X Ethernet Shield W5100 Development board For Arduino UNO Mega 2560 1280 328 UNR .Based on the W5100Based on the Wiznet W5100 it allows an Arduino board to connect to the internet. Stackable Design, can directly support Arduino official Ethernet Library. It Supports up to four simultaneous socket connections.This can use to store files for serving over the network.It is Compatible with the Arduino Duemilanove, Uno as well as Mega that Can be accessed using the Mini SD TF library.The Operating voltage is 5V with Ethernet Controller W5100 with internal 16K buffer.

so while UIPEthernets API is the same as stock Ethernet-library, there’s a subtle (but important) difference: As the enc28j60 is just the physical interface having no brainpower like WIZ5100-based shields, UIPEthernet does no background-processing of ethernet-packets while you don’t call into the library. (It’s a design-decision in UIPEthernet not to use a Timer-interupt within the library as this would allocate this resource not being available for the user any more).

So you’d rather want replace the ‘delay(interval) with some active waiting like ‘if (millis()-until > 0) { } else { Ethernet.maintain()};

In the past few days it occured 2 times that the Arduino froze after a while. This night it happened again, it didn’t wrote any temperature readings to my MySQL DB after 01:00… After disconnecting the Arduino from power (USB 5V adapter) and connecting it again the readings are working for a few hours, but most of the times it will freeze again. Did this ever happen to you?

So far it has been working perfect! The benefit of using millis() instead of delay() is that it also responds to ping now, so it is easier to check if the Arduino is still alive. Great! Let’s hope it stays working.

I did some research and found a way to fix that problem (not related to the Arduino getting “stuck”). I’ll add the modifications for the app. 49-50 day limit as soon as I find the current code to be stable enough.

Please let me know what your findings are. During my testing I have a lot of unrelated network traffic running (downloads), not sure if that influences things or not … I’ll also make sure I’m running the latest version of UIPEthernet.

It is also dead here right now. Booted the Arduino with your updated code yesterday at 21:37, and now, a day later at 19:26 it has frozen. No measurements are added anymore, and the Arduino doesn’t respond to pings either.

On the UIPethernet it says: Only 400-600 Bytes of Arduinos RAM are used (depending on the number of concurrently open connections). Maybe the problem lies in the code, are the connections correctly closed after updating the database? Maybe the RAM is filling up, to a point where the Arduino freezes?

Then I started digging in the UIPEthernet files and noticed that the README file still indicates 1.01, where as posts on GitHub refer to 1.5x so I’ll be digging a little and see if I can download a dev version which might address the issue. Since I’m not too familiar with the ins-and-outs of GitHub, this might take a few extra minutes

Resetting the Arduino is for me a method that might work, but kind-a feels like a work around for a problem that could be solved in a cleaner way – wouldn’t want to generate extra network traffic each time it restarts to get an IP address from the DHCP for example. Not to mention other applications where we’d like the Arduino to stay on all the time and resetting in between is not an option.

But if the problem resides at the server, the Arduino should respond back to ping, and that is not happening. If there are no readings added anymore, the Arduino is also not responding to pings anymore.

“Feels” like the Arduino get’s congested or something like that. I found two functions that I will test later on – see if that “resets” the ethernet stuff.

As a workaround i now have a mechanical 230V timeclock that switches off the powersupply of the Arduino around 01:00. The minimum interval for the timeclock is 5min, so i am not missing/only 1 reading missing because my measuring interval is also 5min. However this is not a permanent solution, and i hope you can find something. I think it has something to do with the networkcard. Maybe using the EtherCard library instead of the UIPEthernet is a solution?

You could most certainly try another library – I think the main issue is that the EtherShield vs the ENC28J60. The Ethershield (according from what I understand from Norberts comments) is more “intelligent” … and more expensive. The lacking intelligence is something a library needs to compensate for, and I can only imagine the increased complexity,…

I am using parts of this sketch for posting stuff from Arduino to MySQL (i am now busy editing this sketch: http://juerd.nl/site.plp/kwh so it puts the number it displays on the screen in my MySQL database).

The person mentioned that the onboard 3.3V is supplied by the FTDI chip, which can only supply a limited amount of mA. The case he was describing was that the current drawn by the ENC28j60 was too high for the FTDI chip to supply, and therefore the sketch would sometimes freeze because of the ethernet module stalling because a lack of power.

[…] wäre es, den Sketch von pull auf push umzustellen, d.h. nicht einen Server auf dem Arduino laufen zu lassen, der durchgängig laufen und connected […]

Hans, sketch is running for a while now. No problems so far. However it is not a fair comparison, as i had to power off the Arduino a few times (turned everything off because i went on vacation, and i hate idle power consumption) and also because my power company came to install a so called ‘Smart Meter’. I have written a blog about reading the data from this meter in my blog: http://thinkpad.tweakblogs.net/blog/10673/slimme-meter-p1-poort-uitlezen-met-arduino-en-waarden-opslaan-in-mysql-database.html with a little bit of help from the forum users i was able to readout the meter with my self made Arduino sketch. Quite proud of myself haha. Setup uses a W5100, works fine. Much more stable than those ENC28J60 thingies.

If you look at this comment, then you’ll see that me (and others) occasionally run into to connection issues with teh ENC28J60 which is not necessarily caused by UIPEthernet, but rather by the limitations of the ENC28J60.

I try to get this work, but when i try to compiling code (i have standard w5100 ethernet shield and i need to use SPI.h and Ethernet.h because UIPEthernet.h not found ip ) I get this error code “Enc28J60 was not declared in this scope”…

Can somebody help me to get this code to work in standard ethernet shield….(Demo code work just fine, but final code not work because i don’t have Enc28J60 ethernet shield) or is the only option to buy the right shield????

As far as I can see (can’t test it unfortunately): the enc28j60 is a standard object declared in the UIPEthernet.h. For the W5100 one would use the Ethernet.h and I suspect that you can replace the enc28j60 object with “ethernet” as a name. You might want to look at some of the demo code’s on the Arduino website.

I went to buy the rightenc28j60 ethernet shield and demo code works just fine and send data to my mysql, but when i upload final code and php files then serial monitor show right info

http://testserver/arduino_temperatures/add_data.php?serial1=28%2088%2084%2082%2005%2000%2000%206b&temperature1=11.1&serial2=28%2088%2084%2082%2005%2000%2000%206b&temperature2=22.2&serial3=28%2088%2084%2082%2005%2000%2000%206b&temperature3=33.3

I just wantet to let you know I just fixed a bug in UIPEthernet that could hang the ENC28J60 chip (some used a call to Ethernet.begin(mac) to reinitialize the enc28j60 as a workaround – this should be obsolete with this fix). New Version 1.09 runs very stable here (Webserver-sketch with > 1000000 Requests and running…):

This acticle and all the comments has been a massive help for me. I’m using it as a basis to display the windspeed, rather than the temperature, for a windsurfing club. I’m using the W5100 shield but I’m still having issues with the setup hanging. : sometimes after 40 or so readings, sometimes after 300. I haven’t found where the problem lies as yet but when I do, I’ll post again. I wouldn’t have made as much progress without this article. Thanks again. Ian

I’ve found with the ENC28J60, even though it’s a different Ethernet shield, that fully resetting the device seems to “clear” congestion. It took me a little bit to find the proper statement for that in the library, but I’m sure the W5100 library has a similar statement. You migth want to look into the code of the library to find it, as it might not be documented.

Yippee! Finally got it going. The problem was not with the W5100 but the way in which I’d configured the website: It’s a hosted website with address wpx2.yyy.co.uk and I’d configured it as that rather than http://www.wpx2.xxx.co.uk. Finding that was the breakthrough as well as a few other silly mistakes such as not configuring the DNS server and default gateway addresses in the Arduino. Anyway, that’s water under the bridge now. Again, that’s for the article Hans, much appreciated. – Ian

The ENC Ethernet shield has proven to be not exactly the greatest, and what seems like congestion has been seen before. Make sure you get the latest library.

If that doesn’t resolve things, I’ve found a “wrong” way of doing it by resetting the ethernet shield. Norbert has updated his excellent library to make that unnecessary though. Worth to toy with …

This has been VERY helpful in setting up my whole house sensor network. I am using Wifly and it works great. Thanks. I would like to add a little security so have added a user name and password with .htaccess file in my sites folder. I wonder if you could tell me how to change the arduino code to handle sending these items to the access form.

I’am making a logging device, Arduino Mega, to be put in a racing motorcycle sidecar. This device logs\makes lap times with the onboard GPS, Gyro for some forces, RTC-clock, to the onboard SD-card. But in addition it sends the data to my webserver every second.

I’m a little confused about what you’re trying to do. To control lights and/or relays, you’d need a different function. I assume you mean that the webserver is sending data to the Arduino to switch lights/relays on/off? Or did I miss understand that?

I’m working my way through what you have taught. I have a 12 sensor network and I’m looking to expand it to 24. Also, I’m looking to add other information collected and managed by the Arduino. I’m concerned because you mention the character limit and for what I’m planning, I’m certain I will go over. Are there any ideas as to how to get around this potential problem? Possibly building different loops that would build and post to maybe different tables? I’m thinking temperature bank 1, temperature bank 2, Tachometer data, gps data and other things. (All this is for my boat).

If you’re using an Arduino MEGA, you could consider trying MySQL Connector for Arduino, which requires more memory (Uno will run out of memory very fast).

Another method would be using POST instead of GET. This does take a little more effort to program though, but you’d get rid of the link length limitation. Here you can use multiple fields or for example data in a JSON format. Some example code can be found at Arduino Playground, Instructables, StackOverflow and GitHub HTTP Client.

I just wanted to say thank you very much for this concise and informative tutorial. I had gotten an ftp client working from a mega2560 and now you have provided the other key piece that I needed to monitor my well houses, septic pumping stations and hot water boiler systems.

[…] I’m using: HTTP: //www.tweaking4all.com/hardware/arduino/arduino-ethernet-data-push/ Agentuino (SNMP): https://code.google.com/p/agentuino/source/browse/#svn%2Ftrunk%2FAgentuino Yes, […]

Only MEGA and DUE models have more – be careful with the Mega models, since some shady eBay/Amazon sellers advertise a Mega but in the fine print you’ll see that they are only selling a Uno clone.

I could make this example work, however I still have some concerns: The temperature table, while hanging from the “test” data base works ok. It is possible to add records either by running the php script (add_data) from the browser or through the client connections performed by Arduino.

[…] are some of the helpful links that helped me created this build. Arduino Ethernet – Pushing data to a (PHP) server How to measure temperature with your Arduino and a DS18B20 Brick-Temperature-DS18B20 Arduino […]

I’m monitoring already several months the temperature in- and outside and also the temperature of the heating-side of the c.v. to monitor the behaving of the heater, it’s working perfectly on a Arduino Nano with a ethernetboard pluggen on to it and the data on a qnap server.

Now I would not use port 80, rather pick something else like port 8080 or 81 (which you have to use in the URL used in the Arduino’s at the pool). Just to avoid confusion with regular HTTP traffic.

Assuming your MySQL server is at home, and your Arduino is connected to the Internet, then you’ll have to do Port Forwarding on your Internet modem/router for Port 3306 (assuming you’re using the default port for MySQL and you allow MySQL remote access),

The latter would be an IP address for example. You could also use ‘%’ if all remote connections are allowed. So “user@’%’” should work no matter what the IP address of the Internet connection of your Arduino is.

Another problem I have seen is when users connect their Ethernet straight to their computer – this I cannot recommend, as it would only work with a crossed Ethernet cable and a fixed IP address. Tricky at times even for the best of us.

the connection between my pc and the ethernet shield is ok. I can ping in both directions. I am also able to connect with google.com and send some requests. BUT when connecting to the wamp server (server ip 192.168.1.5, which is the same as of my machine), arduino fails. in other words

Does anyone know how to get the “socketio arduino client“ runnable with the UIPEthernet-Lib. My project run´s well with a python-flask webserver, but i want to make it faster.

Hi all…i have followed this post keenly and have been able to create all the PHP files. when i post data manually using http://vintagegreens.byethost7.com/add_data.php?humidity=50&temperature=13 , the data is posted. However, my arduino cant post data despite there being no error in the code below. Someone kindly help me out -:)

thanks for responding to my post despite being in the middle of your journey….i already tried that and it still does not send…i assume the client.print part is not posting, or the arduino cant locate the add_data.php file…….as you may notice, i am using free web hosting site therefore i may not have much knowledge of the directory structure…….when you do get time, i will be grateful if you help me troubleshoot. Regards.

Hi supreme, i think you need to change localhost on the line $MyHostname = “localhost”; in dbconnect file to the IP address of the computer where the mysql database is installed. ‘Localhost’ in this context means the arduino, rather than the server.

try to put serial. print after every client.print we see how the syntax appears on the serial monitor…..the idea is, if we can get the arduino to print something likehttp://192.168.0.101/diplomna/add_data.php?temperature=21&humidity=78

This code worked for me….i have edited it to suit your settings…can you try it?you can remove the sensor first if you are not using arduino mega which has pin 40..

The connect between your Arduino and your webserver will each time only be temporary. After sending the data, the connection will be closed. So in the next round of submitting data, we need to connect again. Hence the “Connected!” keeps appearing each time that happens.

i am using Mega+Ethernet shield(wiznet) that need to connect and updating the readings to mysql database. I’m able to get the output from serial monitor which is

i got it..thanks.., i change the ip for the arduino and change the “localhost” to the same ip..and its working..now i need to obtain a graph from this readings..highchart maybe. have any idea? or link that i can try? :)

Once I started to write to the database, I added another sensor (BMP080). The sensor works great. Then I wanted to sent information from both sensor, wirelessly, using RF transmitter and receiver. After that i want to record information in a database and show it on display (using I2C interface). The final step is my problem :)

#include #include #include #include "Wire.h"#include "Adafruit_BMP085.h"EthernetClient client;byte mac[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED };char server[] = "192.168.0.101";Adafruit_BMP085 bmp;dht DHT;int interval = 50000; // Wait between dumps#define DHT11_PIN 2void setup(){Ethernet.begin(mac);Serial.begin(115200);bmp.begin();}void loop() {// READ DATAint chk = DHT.read11(DHT11_PIN);Serial.print("Temperature = ");Serial.print(bmp.readTemperature());Serial.println(" *C");Serial.print("Pressure = ");Serial.print(bmp.readPressure());Serial.println(" Pa");Serial.print("Temperature2 = ");Serial.print(DHT.temperature);Serial.println(" *C");Serial.print("Humidity = ");Serial.print(DHT.humidity);Serial.println(" ");if (client.connect(server, 80)) {client.print( "GET /diplomna/Arduino/add_data.php?");client.print("temperature=");client.print( bmp.readTemperature() );client.print("&&");client.print("humidity=");client.print( DHT.humidity );client.print("&&");client.print("pressure=");client.println( bmp.readPressure() );client.println( "HTTP/1.1");client.println( "Connection: close" );//client.stop();Serial.println("CONNECTED");}else {// you didn’t get a connection to the server:Serial.println("–> connection failed/n");}delay(interval);}

I have one more problem. When I displayed information of pressure in serial monitor of transmitter, the pressure is 111 000Pa, but the value that the second arduino received is negative (-3350 Pa).

PHP code should be fine, because I can add data manually, but for some reason arduino can’t connect to the wampserver. Everything else in the code is roughly the same.

Thank you very much for replying so soon, The cable works, with my computer and also gives the arduino IP as well (tested through DHCPAdressPrinter), although it’s an A-B standard cable, don’t know if it would make a difference though. DHCP is enabled, also I tried adding the MAC to a static IP list. What network issue could it be? I’m using an asus wireless router which shares a 4g mobile connection through usb. Could it be, that the service provider has DHCP off, so it wouldn’t matter if it’s turned on, in my router settings? What could be the workaround?

Yes, by A-B cable I mean cross-cable (sorry i’m not a native speaker and we only use a-b here). Do I understand correctly that the cross-cable would be no good? Do I need the standard straight? cable then? The arduino is connected to the computer with USB as a power supply, also to make it easier to make changes to the code (to make the uploading process faster, not having to switch between the standard PS or USB) The network cable goes directly to the router, yes.

The Arduino connected to your PC is not a problem, great power supply and easy for changing code indeed. It will however not handle the network traffic of course.

I still can’t get it to work, I changed the cable, double checked that it works. Also the arduino gets an IP when testing with DHCPAddressprinter in examples.

It remains weird that you’re not getting an IP address – specially when you’re using a straight Ethernet cable, and you already tested that DHCP works.

Can’t reply anymore… I think you’ve found the source of my problem, I’m using what i’d say is the “original” ethernet shield (http://www.sivava.com/image/cache/data/products/arduino/k02-arduino/950-k02-arduino-1-600×600.jpg). And I didn’t add the arduino_uip library to the DHCPaddressprinter, that’s probably the reason, it works. Is it possible to make the code work without arduino_uip? I don’t know how I overlooked the fact you’re using a different ethernet shield:(

It could be possible to simply replace “UIPEthernet.h” with “Ethernet.h” (in the sketch in this article) as it is almost a 100% drop-in replacement for ‘Ethernet.h”. So the should mostly be compatible.

Hi, my name is george, Im not getting any change in my localhost when i tried to send dump information from my arduino UNO, but when i did it manually it actually change well… this is my sketch

For example: WAMP Server (Windows) by default only allows access when you’re working on the server itself and you’ll have to set it to “online” to be able to access the webserver from another computer (or Arduino).

I am using the example, but I have not the sensor, so he put default values, the program sends data correctly, check the file for Apache access log and appears “192.168.1.100 – – [14/Aug/2015:20:26:40 -0500] “GET /add_data.php/serial=288884820500006C&&temperature=12.3 HTTP/1.1″ 403 310” but by placing in browser It 192.168.1.100/add_data.PHP not show me the variables, which are sent with Arduino. Use wampserver

add_data.php should indeed be on the server. Is your browser displaying anything when you do it manually? (ie. enter http://192.168.1.115/add_data.php?serial=288&&temperature=1)

[…] is part of my little ongoing project of learning with the Arduino.  I want to give a mention to Tweaking4all’s guide to PHP, SQL and Arduino, because I started out using it as a base for this section of the project, though I altered a few […]

Sending the code would be the same as above (instead of the Temperature), with or without logging access attempts in the MySQL database. Just catching the “answer” would be trickier on the Arduino end (I have yet to test something like that).

You might have to start looking in the examples that came with UIPEthernet or Google something like “Arduino Ethernet read data from web page“. This Arduino Forum Topic seems useful.

work just fine and add data to chart which i can view by 192.168.x.x/review_data.php, but when request for adding data to chart is sent by arduino wamp server is returning message https://ctrlv.cz/LmyR

I am trying to adapt your tutorial for a simple project I’m doing which consists in, having Arduino sending an LDR value to a simple web-page I created.

Arduino is connecting to the website through MAMP server but, I don’t know how (I didn’t quite understand) how to make a php script on the web-server to receive, understand and display the results on the web-site in the HTML class below instead of the dummy value ‘999’ in the paragraph.

I have not tested this, but it could be something like this (assuming you run the PULL version on your Arduino, and removed all XML from the sketch – so it ONLY returns the value of the LDR and nothing else):

I understand what you are telling me there and you’re right, but, the sketch I uploaded is a simple one but the end result of this project will be to present the data as a realtime graph which will will be putting a lot of stress on Arduino, that is why I opted to use a PC as my web server.

It would only have a value when the Arduino would call for that page, and pass the LDR value. The PC would not know this value, unless you use a database, or pull data in like I showed in the previous answer.

To show a graph, even realtime, you’d probably be best off with the use of a database that is constantly being filled by the Arduino. Your page, the one you’re looking at on your PC, should constantly try to get fresh data from the database.

I used your php files on my page with a slight modified example wifi client on an ESP8266-12e on a NODEMCU DEVKIT 1.0. My DS18B20 has gnd and 3.3v from those outs on the board, and the data pin is connected to d3(gpio 0). Polls/posts every minute. All done in Arduino 1.6.6 with ESP libraries installed, posting to a namecheap hosted page. I did modify review_data.php line 43 to read

did you try raspberry pi to make the webserver and connect to the arduino so that it will be no longer the need of the ethernet? how can I send data without it? thank you

Hans is right, this would be better served using the Pi alone.You could load light Raspbian & C++ implementation of the sketch and not have to deal with the hardware troubles of having several different modules stacked together, and the additional software to interpret Arduino -> Pi without ethernet.

Looking into this just a little, http://wiringpi.com/ seems to be the C++ library to use GPIO. They mention using the arduino as a GPIO expander in the abstract, but unless you are filled up on the GPIO I don’t think I would bother.

The Arduino IDE is the easy way to program them. We are all familiar with that, and they have a load of example sketches.Cut and paste my post from last month into the IDE and with the appropriate fields (ssid/password/webserver addr) it should fire right up. I am running one right now reporting to http://boat.750carbs.com/review_data.php I modded it to respond in degrees F, because my family doesn’t speak C. And the Sensor Serial field has been modified to report wifi connection failures so I can monitor the dropouts.I see you have looked at the Adafruit Huzzah, I went with the NODEMCU devkit for the microusb interface. http://www.ebay.com/itm/121811389556 this is the seller I have used, gone up 2 bucks per unit since my first buy.

I am looking for someone who help me with my Arduino+Android project. I want to send data from arduino (Arduino Uno+Ethernet shield+Sound/Temperature sensors+button like doorbell) to the virtual server with PHP. My vision is – arduino sends measured data to the server, there will be caught and processed with PHP script. I dont need save data into SQL table, only catch and process it for next Android processing. How can I achieve this goals (send data, catch data, process data) ? Can anybody help me with this? Do you have some tutorial or example? Thank you very much.

When thinking about what you’d like to do, I can’t help wondering what kind of processing you’d like on the Android device. If you plan to write an app for that purpose (on the Android device), then I think buffering a little bit of the data in a database might still be a good thing to do, to overlap time differences. Unless, … you have you Android app pull data straight from the Arduino (you’d have to open some ports on your router for “public” access – ie. access outside of your home/business) which might be more effective/realtime.

Most common issues happen when folks try the link on the same computer where the webserver is running, and that usually works well. However, for another computer (or the Arduino in this case) to be allowed to do this, you’d need to set the webserver open to other computers in your network.

Yeah..I am using wampserver on laptop…I tried to put data from arduino from different laptop and wampserver is running on different computer. but its not working. I also make sure that wampser is online..BY clicking on put online.

hello , can you help me to fix my problem ?i try to send a data to my database but no one display… i use arduino uno,ethernet shield and xampp for database

At a previous post(12 Jul 14) you suggested 2 changes that i made, and it showed the error above.What are any other changes that should be made in php code or arduino code?

Hi and thank you so much for this tutorial. I have a question I am using an arduino atmega 2560 the wifi shield (instead of the ethernet shield) and I am doing an example to see if it works just sending data to a table. this is my arduino code:

// Give the server some time to recieve the data and store it. I used 10 seconds here. Be advised when delaying. If u use a short delay, the server might not capture data because of Arduino transmitting new data too soon.

The php code works for example if I enter http://localhost/write_data.php?value=100 in my web browser the value 100 enters in my database. But when In try with the arduino code, nothing happens no data is inserted in my database, it seems that the get part is not working or I don’t know I am stuck in this problem for a few days and I don’t know what else to do could you help me?

Hi!First, yes I have WAMP server (wamp64 for 64 bits to be more exact) I think I don’t need to do it from another computer I am doing it from the same computer where I have the WAMP server and the arduino. The php code works for example when I enter http://localhost/write_data.php?value=1 in my web browser my database is filled with the value 1, so it works. By the way I don’t have XXAMP I have MySQL Workbench, but it works. But when I try to do the same with the arduino code it does not work, that’s my problem. Do I need to enable something in my arduino IDE to get the “GET” request work????? I enabled in the firewall the app of the arduino desperately looking if that’s the solution. I am using an arduino atmega2560 and a WIFI shield for my purposes….. What else can I do??? Please help me…. because I don’t know what else to do…. in the arduino forum nobody helped me….

the problem is that WAMPServer will not allow “outside” access (ie. another computer, or in your case the Arduino) by default. So you will have to set it to online. So by default the Arduino will not even reach your webserver.

Test the link (replacing “localhost” with an IP address) from another computer in your network, or a tablet or smartphone. You’ll see that it cannot reach the server. This is why it will not work with the Arduino either.

Hello, the tutorial is great help but i am having issues uploading to mysql. I can manually input http://yourserver/add_data.php?serial=288884820500006b&temperature=20.79 and the mysql updates with the correct values. Though even though arduino is saying connected no data is being add to the server.

I am using the wampserver and the arduino is connected to a router which the pc that is the host of server is also connected. I am using the example code for the http get and using hard values to verify that the arduino can speak to the server.

Thanks, I seeing data coming from my arduino to mysql. I however ran into another problem i can’t access the server from say my laptop or another device. I believe that its cause i using the with my desktop ip address Local Databases. I tried creating a virtual host called project.dev but it says I don’t have permission. How do i set up a wamp server that is not local host with ip 127.0.0.1. I don’t plan to have any traffic but would like to test arduino outside my local network.

Update: while try to create another virtual host my arduino stop sending data to localhost. I don’t know what happend but now i have a option on the wamp tray to have the server either online or local right now its says its online.

Hi, I wanted to give an update and I was able to get the arduino working. Had to use a friends mysql but everything is working. I did want to ask how the best way to send data for even time. I have tried both the delay and creating a loop with millis() function but my timing is off. For example the most reliable method using the millis() function I get an error of 5 seconds if i take reading every 15 minutes. How do i correct for this, also i do plan to be able to take different time readings but 15 minutes is what i was testing.

As for timing: the Enc28J60 is not know to be the most reliable ethernet shield, hence the reset after an error (line 62: Enc28J60.init(mac);). Norbert has done a ton of work though to make his library a good as possible (thanks again Norbert!!).

Timing is indeed tricky and the fact that the Arduino doesn’t really have a realtime clock (date and time) and the fact that some work needs to be done in the background is not helping either. One of the reasons that I added

I know it might be a lot of info to dig through. If I’d had my ENC28j60 and Arduino nearby, I’d do some tests as well – but that is unfortunately not the case.

I really don’t know what Im doing wrong. Tried the manual method of typing the URL/add1.php?(values) and it works so Im guessing it has something to do with the Ethernet part of the project.

I’m not really sure where to find the webserver’s IP address. It works though when I type the (webserver)/add1.php?(data), the data were uploaded successfully into the database. I’m thinking that it could be something to do with the connection between the arduino and the webserver where I can access the PHP file.

According what I could find, the UIPEthernet library should be able to resolve the name properly when using the DNS library which comes with UIPEthernet. This offers the GetHostByName function (I have not been able to test this yet though).

One of the things I did in my example code, is test if there is a connection, and if not, reset the connection, which I’m not seeing in your code. (see as of line 58 of my Arduino sketch):

I’m not familiar with the ESP8266WiFi.h library (which I hope to start playing with in the next few weeks). I assume this (client) works similar to UIPEthernet.h? Have you tried the link straight in a browser? When I try this link I get an Internal server error?

I followed your code and it successfully run. I have to control arduino through web page virtual switch. but i do not have any idea regarding received data from php file or read data from php file in arduino. so, please sir help me regarding this

A lot of handling in the background isn’t handled by the card and the Arduino [library] may or may not be capable of dealing with this correctly or fast enough.

I successfully manage to get ethernet shield and TFT shield to work individually. Then since TFT shield will not be able to use the ICSP interface I connected the jumpers as it says on wiki.

After this I put everything together and try to get them working with the below code but for some reason I don"t know, Ethernet shield stopped working. I get the error Ethernet shield was not found. Sorry, can"t run without hardware. :(. Even though the error, my TFT screen lights up and runs demo. Probably I"m missing something simple. I"ll appreciate any help or guidance.

OVERVIEW:The Arduino Ethernet Shield connects your Arduino to the internet in mere minutes. Just plug this module onto your Arduino board, connect it to your network with an RJ45 cable (not included) and follow a few simple instructions to start controlling your world through the internet. As always with Arduino, every element of the platform – hardware, software, and documentation – is freely available and open-source. This means you can learn exactly how it"s made and use its design as the starting point for your own circuits. Hundreds of thousands of Arduino boards are already fueling people’s creativity all over the world, every day.The Arduino Ethernet Shield allows an Arduino Board to connect to the internet. It is based on the Wiznet W5100 ethernet chip. The Wiznet W5100 provides a network (IP) stack capable of both TCP and UDP. It supports up to four simultaneous socket connections. Use the Ethernet library to write sketches that connect to the internet using the shield. The Ethernet Shield connects to an Arduino board using long wire-wrap headers which extend through the shield. This keeps the pin layout intact and allows another shield to be stacked on to.Document:

Arduino Mega+Ethernet Shield+Lcd Display+AdvancedHMI: I recently got an Arduino Mega board in oder to more I/O than an Arduino UNO or a clone based on an atmega328p/644p/1284p.…

Spice up your Arduino project with a beautiful large touchscreen display shield with built in microSD card connection. This TFT display is big (5" diagonal) bright (12 white-LED backlight) and colorful 480x272 pixels with individual pixel control. As a bonus, this display has a capacitive touch panel attached on screen by default.

The shield is fully assembled, tested and ready to go. No wiring, no soldering! Simply plug it in and load up our library - you"ll have it running in under 10 minutes! Works best with any classic Arduino Mega 2560.

This display shield has a controller built into it with RAM buffering, so that almost no work is done by the microcontroller. You can connect more sensors, buttons and LEDs.

Of course, we wouldn"t just leave you with a datasheet and a "good luck!" - we"ve written a full open source graphics library at the bottom of this page that can draw pixels, lines, rectangles, circles and text. We also have a touch screen library that detects x,y and z (pressure) and example code to demonstrate all of it. The code is written for Arduino but can be easily ported to your favorite microcontroller!

If you"ve had a lot of Arduino DUEs go through your hands (or if you are just unlucky), chances are you’ve come across at least one that does not start-up properly.The symptom is simple: you power up the Arduino but it doesn’t appear to “boot”. Your code simply doesn"t start running.You might have noticed that resetting the board (by pressing the reset button) causes the board to start-up normally.The fix is simple,here is the solution.

TFT LCD (thin-film transistor liquid crystal display) or TFT display is a type of Liquid Crystal Display (LCD) that uses thin-film transistor technology to improve features such as contrast and addressability. TFT display technology powers each individual pixel with a single transistor, resulting in faster response times.

TFT LCD technology uses "field-effect" transistors that are built by layering thin films on a glass substrate, hence the name. This method is commonly used to construct microprocessors. The TFT display module in the LCD controls individual pixels in the display by adjusting the amount of electric field across the three liquid crystal capacitors (one for each sub-pixel of red, green, and blue) in the pixel. This has an impact on the polarisation of the crystal material. How much backlighting reaches the colour filter is determined by the amount of polarisation in the crystal. Because of its ability to manipulate each pixel quickly and directly, TFT modules are also known as active-matrix LCD technology.

TFT screen: When it comes to cameras TFT stands for "Thin-Film-Transistor" liquid-crystal display. TFT display technology enables the development of high-resolution LCD display screens with superior contrast performance. TFT displays are used by camera manufacturers because they allow LCD displays to display high-resolution, colour-accurate replicas of acquired images. This eliminates the need to upload photographs to a higher resolution display device and allows photographers to accurately evaluate their work while it is still in progress. TFT displays are used in devices other than cameras, such as home televisions, mobile phones, and computer monitors.

The Arduino"s backlit TFT LCD screen has a micro SD card port on the back. You can draw text, pictures, and shapes on the screen using the TFT library. Although it can be used with any Arduino board, the pin configuration of the TFT display Arduino screen is designed to fit easily into the sockets of an Arduino Esplora and an Arduino Robot. TFT LCD modules provide This technology is used in thin-film transistor liquid crystal display modules, or TFT LCDs. TFT technology allows for a full RGB display of a wide range of colours and hues. For vivid graphics, finely detailed images, and rich colours, choose an LCD with a TFT screen

TFT LCD (TFT liquid-crystal display) is a type of liquid-crystal display that uses thin-film transistor technology to improve image qualities such as addressability and contrast. A TFT LCD is an active matrix LCD, as opposed to a passive matrix LCD or a few simple, direct-driven (i.e., segments directly connected to electronics outside the LCD) LCDs. TFT LCDs are found in a variety of appliances such as televisions, computer monitors, mobile phones, handheld devices, video game systems, personal digital assistants, navigation systems, projectors, and automobile dashboards.

LCD: Liquid Crystal Display; an increasingly common type of display panel (like TV, PC computer, Mobile phone screen, etc.) TFT: Thin film transistor, which controls the colour and brightness of the LCD"s pixels, none directly endanger the eyes.

TFT displays motion more smoothly and responds more quickly than a monochrome LCD panel. TFT displays are bit expensive compared to monochrome LCD panels since they consume more electricity when operating.

TFT is a type of LCD that uses thin film transistor technology to improve image quality, whereas an LCD is a type of display that uses the modulating properties of liquid crystals to form what we call an LCD (liquid crystals display), which does not directly emit light.

Arduino shields are boards that will expand the functionalities of your Arduino. You just need to plug them over the top of the Arduino board. There are countless types of shields to do countless tasks.

The Ethernet Shield allows you to connect your Arduino to the internet . You just have to plug the shield onto the Arduino board and then, connect it to your network. Pretty simple.

This Shield makes it easy to use a 16×2 Character LCD. With this, it is  possible to control a 16×2 Character LCD, up to 3 backlight pins and 5 keypad pins using only the two I2C pins on the Arduino.

This Shield solves many problems related to audio low quality with electronic projects with audio. It can play up to 22KHZ, 12 bit uncompressed audio files of any length. Audio files are read off of an SD/MMC card. With this shield, it is possible to add high quality audio to your projects.

With this Shield you can connect up to 64 buttons to your Arduino. Some cool projects with this shield include musical intruments, cool computer interfaces, etc.

The GSM/GPRS Shield allows you to connect your Arduino to GSM/GPRS cell phone network. It allows you to dial a phone number or send a text message to  a friend via easy to use AT commands.

With this Shield it is possible to reduce the complexity of the camera control interface.  It uses I2C interface for the sensor configuration and SPI interface for camera commands and data stream.

This Shield is a well-equipped network processing unit that can simplify the network connecting process.  It can lower the MCU’s demand on software, which makes it a perfect solution for embeded applications of low-cost, low-power consumption MCU.

ESP8266 Wi-Fi Shield is an Arduino compatible shield for the ESP8266 WiFi SoC – a leading platform for Internet of Things (IoT) or Wi-Fi related projects.

Arduino4 เป็นเว็บขาย Arduino, Microcontroller, Module, Breakout board, Sensor และอุปกรณ์อิเล็กทรอนิกส์ต่างๆ ราคาถูก เหมาะสำหรับผู้ที่สนใจเกี่ยวกับ Arduino, Microcontroller และอิเล็กทรอนิกส์ทั่วไป ถึงการทำโปรเจคต่างๆ ร้านมีสินค้าสต็อกพร้อมจัดส่ง จัดส่งสินค้ารวดเร็วภายใน 1-2 วันทำการเท่านั้น จะซื้อ Arduino ต้อง Arduino4.com เท่านั้น