Internet of Things (Arduino,Php,Html,Mysql,IOT,iot)
3.3 (25 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,755 students enrolled

Internet of Things (Arduino,Php,Html,Mysql,IOT,iot)

internet of things and automation with fully open source structure.
3.3 (25 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,755 students enrolled
Last updated 8/2019
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 1 article
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Computer Skills, Electrical Skills

Summary Description: Training of turning on and off an electrical device remotely with Arduino, Php, Html, MySQL. It is basically explained how the objects can be connected to a member access panel via internet or internal network, the relay connected to the arduino uno card is switched on and off with the logic of IoT which requires more power. Web interface part is realized with HTML, PHP, MYSQL technologies. In the Arduino section, some additions were made to the query result file in the mysql connector library. database select feature has been added. With the information obtained, home, business, building automation can be done very cheaply.

Detailed Description: With this tutorial Arduino, PHP, HTML, MySQL, Embedded Systems, IoT | The internet of the objects will be explained as a basic prototype.

With the logic of the internet of things with the web panel of electrical devices from all over the world

• How to automation personal home, work or building using Arduino card,

• How the arduino will behave in cases where it cannot access the internet or software, and how to automatically close the contact,

• How the memory of the relevant it is not interrupted even if the power is cut using the Eeprom of the card,

• How to prepare the control panel with the encrypted login screen,

• Adding components from codes to design and development card,

  one by one will be explained.

• Remote controllable devices.

Refrigerator, air conditioner, lamp, rolling shutter systems, feeding machine, socket, contact, irrigation etc. products

• Access to the database and communication with Arduino are explained.

• The database used for Arduino is Mysql.

• Database selection feature was added to arduino mysql connector.

• How to insert,update,delete,select over arduino for mysql.

After taking the course, you can ask me questions from the question and answer section. I will try to answer the questions as soon as possible.

Keywords: arduino mysql connection, mysql with arduino, arduino mysql, arduino ethernet, arduino database data extraction, arduino php, arduino sql connection, arduino mysql connection, arduino phpmyadmin, arduino database connection, arduino sql, arduino mysql, remote arduino, arduino ethernet shiled, how to send data from arduino to mysql database server,arduino save data to database, arduino read data from mysql, how to save data from arduino to mysql database server, send arduino data to mysql , arduino data logging web server

NOTE: Up to 25 amps (rated current) can be operated with the relay described in the prototype. (Use another model relay for applications requiring higher current.) With 2.5mm2 cable described in the prototype, it can carry current up to 20 Ampere for Turkish standart . (For applications that require higher current, use a cable of other thickness.)

Who this course is for:
  • Home or business automation, Arduino developers
  • Database access with arduino,php,html
Course content
Expand all 31 lectures 01:59:43
+ Second Chapter
11 lectures 58:48
Interface design continued
Database preparation
Update.php page preparation
Data.php page preparation
Test without login
Article of "press to open"
Login page preparation
Exit page preparation
Login page test
+ Arduino Programming
2 lectures 27:21
Query Result and Pin Control (the corrected)
+ Prototype
1 lecture 03:31

Disclaimer: This tutorial is a prototype of a planned product.

All tests have not been carried out by me or by any security certificate, TSE, CE etc.

All kinds of material (fire, electricity leakage, product breakdown, diseases due to electric shock, etc.) that may occur due to human health and animal health related to these problems will not be covered by the responsibility.

No responsibility is assumed for persons acting on the basis of this training.

codes, tools, equipment, hardware, student mistakes no liability is accepted for these and similar problems.

any material and moral responsibility that may arise for codes, tools, equipment, hardware, student errors such as these and so on is unacceptable.

Preview 03:31
+ How to insert,update,delete,select with arduino
8 lectures 16:34
Database process
How to insert mysql data with arduino
How to update mysql data with arduino
How to select mysql data with arduino
How to delete mysql data with arduino
Write data from Dht11 sensor to mysql database