Build Own Secured PHP IOT Website Free - Arduino

Introduction: Build Own Secured PHP IOT Website Free - Arduino

About: Want to do some thing best with my less resource.

I feel its costly to purchase IOT from websites. So i plan to build our own IOT web page. When come to IOT the security is more essential, So i use MD5 encryption from PHP to secure the page. With the page i design we able to control lot of devices with seperate user name and password for each device. And access the data with the user name of the device.

Step 1: Materials Required

For Programming

1) PC with web connection.

For Testing

1) Link IT one board (Or Arduino UNO with WIFI or GSM Module"

2) ESP8266 WIFI module

3) Wifi hot spot of smart phone with internet connection and WIFI hotspot.

4) Power Supply

5) Relay module

6) Potentiometers

Step 2: Find a Suitable Web Site

Use google and Found a free Website hosting web site. Even with limited size is enough for testing. If we want to expand the project then purchase a space from them. I found 000webhost.Com is a nice web site with free database support. Database is very essential when develop a iot webpage.

The program we going to use is PHP with Mysql.

Step 3: Free Signup and Verification

1) Sign up using your email id.

2) After verify email id in your web page.

3) Use mobile send the unique code listed in the page to the given mobile number.

4) Then your mobile number also verify.

Step 4: Create a Website

1) When login the website.

2) Click the + sign on the web site and enter the website name and password of the website, then click create.

3) Your web site created sucessfully.

4) Use Build web site using three options given. I use upload own website. Because i develop a php web site. I give it in up coming pages.

Step 5: Create a Domain

1) Now its time to create your domain name.

2) In the menu click my domains.

3) Then Click add domain in the screen.

4) In the domains page click Add domain.

5) In the Window click free subdomain.

6) Enter sub domain name and click save.

Step 6: Create a Database

1) Create your PHP data base.

2) In the databases click new database.

3) Enter the database name, username and password.

4) Click create.

5) Your database created.

Step 7: Manage Database

1) Create the tables in the database.

2) Create your tables in the php as per your requirement.

3) I given my DB here.

4) Download the local host.sql in the list.

5) Use import in the page to import the tables from file given.

Step 8: Create Iot Pages

1) I given my php files as rar here.

2) Down load the file and change your dbusername, password, db name in config .php file and upload.

Step 9: Upload to Website

1) Down load the pages i given and upload the pages in the upload own web site.

Step 10: Arduino Program

1) Upload the given program in linkit one (or change it for Arduino).

2) Run the kit and found the sensor value posted on in your database.

3) By use the Sensorvalue.php with your domain name u able to see sensor value any where in the world.

4) By use the Switches.php with your domain name u able change the switch status in the kit.

Syntax for each page:

1) To see sensor value

your web domain name/Sensorvalue.php?id=User name in table&pwd=Encrypted password using MD5

2) To change switch status

your web domain name/Switchesphp?id=User name in table&pwd=Encrypted password using MD5&switch=integer in decimal to control up to 10 digital pins.

In the arduino program u want to change the addresses and wifi settings. Also add program to convert received decimal to binary value and change the digital pin status according to the decimal value.

I php I add only basic pages use the coding add plugins like graph for php from net develop pages to view the details in graph. And use image map send the switch status from php page to database to switch on and off the devices.

IoT Builders Contest

Participated in the
IoT Builders Contest

Epilog Contest 8

Participated in the
Epilog Contest 8

Arduino Contest 2016

Participated in the
Arduino Contest 2016

Be the First to Share

    Recommendations

    • The 1000th Contest

      The 1000th Contest
    • Battery Powered Contest

      Battery Powered Contest
    • Hand Tools Only Challenge

      Hand Tools Only Challenge

    45 Discussions

    0
    roshan7505
    roshan7505

    3 months ago

    I have created database in 000webhost. where do i find my ip address

    0
    IntelliGads
    IntelliGads

    Question 4 months ago

    Hello, thanks a lot for posting this simple and excellent project.
    I have a question. How and where do you create the password?

    0
    jegatheesan.soundarapandian
    jegatheesan.soundarapandian

    Answer 4 months ago

    Sorry i dont develop separate page for user name and password. Go to the data base and select the security table and insert data there.

    0
    IntelliGads
    IntelliGads

    Reply 4 months ago

    OK, thanks for the response..
    So, when we access the URL, we have to type the password also in the address?
    For example, if my password is "alpha" my URL will look like below?

    web domain name/Sensorvalue.php?id=User name in table&pwd=alpha

    0
    IntelliGads
    IntelliGads

    Reply 4 months ago

    So, you mean we have to type the password in the browser to use it?
    but then the password will be viewable by anyone by looking at the browser history. Then how is it secure?

    0
    jegatheesan.soundarapandian
    jegatheesan.soundarapandian

    Reply 4 months ago

    But when you transfer data you send from microcontroller so no one able to view. For report if you want you put a login screen.

    0
    IntelliGads
    IntelliGads

    Reply 4 months ago

    Oh, ok
    Thanks for your time.. Would you mind sharing your contact details? I would like to discuss further. Or please email me at lateststuff2016@gmail.com

    0
    Femi Durai
    Femi Durai

    Question 9 months ago on Introduction

    Can I get a easy program using php for this?

    0
    jegatheesan.soundarapandian
    jegatheesan.soundarapandian

    Answer 4 months ago

    That progam i attached is very simple and easy just download and view in notepad for coding.

    0
    Femi Durai
    Femi Durai

    Question 9 months ago

    How to create an web page?..Is there any online creater??

    0
    jegatheesan.soundarapandian
    jegatheesan.soundarapandian

    Reply 9 months ago

    sorry for the delay reply. The website i used have web page creator. If you want to create php lot of developers available. If you want to just check or create small page use notepad and PHP coding.

    1
    Anil Alok
    Anil Alok

    Question 1 year ago

    hy u are providing the wrong code..
    can u please send me ur libraries and the right code
    sir, please just change ur confidential part.....

    0
    jegatheesan.soundarapandian
    jegatheesan.soundarapandian

    Answer 1 year ago

    Use Link it one board. Link it one library are different than Arduino libraries. If you use arduino change the code as per its library.

    0
    רזד
    רזד

    1 year ago

    Hi there; well done for the write up here.Thanks a lot for your files you shared with us.
    I think there is more little details that missing like how you put it all together in one page and how you can check that the DB is connected and get the info that stored without getting the Arduino on.
    Or I'm doing it wrong?

    sorry for my english.

    0
    jegatheesan.soundarapandian
    jegatheesan.soundarapandian

    Reply 1 year ago

    Please check there are separate files for configuration to db connection and user lock. All are in php attached in single rar file, unzip it. Even Arduino is not on data is recovered because are the data are stored in the server.

    0
    hemu.katiyar
    hemu.katiyar

    1 year ago

    i am getting this error while uploading your database localhost.sql
    1. Missing expression. (near "ON" at position 25)
    0
    jegatheesan.soundarapandian
    jegatheesan.soundarapandian

    Reply 1 year ago

    May the version varies. But if you know my sql its very easy. Open the localhost.Sql in a notepad and copy all the text to the MS word. You find the script in format. It contain Create Database, Create table, Insert commands. Copy that one by one and run in mysql Query.

    0
    dhanrajs3
    dhanrajs3

    2 years ago

    Hi ...

    First of all thank you for such a detailed explanation. As a beginner to website building domain i found this much helpful. As i am going through building website exactly like the one you shown in php_files.rar i couldn't find index and web config. Is it missing by mistake or is it system generated. Please reply.

    Screenshot (32).png