Build Instructions

Collapse

• 1

  Register for a free web hosting service

  You don't actually need a free web hosting service if you are willing to pay for one. I personally used 000webhost.com, but you can use any web hosting service that provides PHP and MySQL.

• 2

  Set up a database on your web site

  This example is valid for 000webhost.com, but the procedure should be very similar for any free webhost.

  • Login to the web host admin page.
  • Click on the icon "Manage database".
  • Click on the button "New database".
  • Enter a database name, for example "data" with a username and password for management of this database.
  • You will be shown a list of your databases with the full name, for example id1234567_data. Remember this name, it will be needed later.
  • Beside id1234567_data, click on Manage->PhpMyAdmin to manage the database.
  • Click on the tab "SQL". Paste in the following text (after changing id1234567 to the correct user id) and click "Go".

  -- Create a table "Info" which contains columns "Time" and "Voltage" in database "data"
  -- Remember to change id1234567 to the correct user id
  SET time_zone = "+00:00";
  CREATE TABLE id1234567_data.Info (
    Time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    Voltage text COLLATE utf8_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  ALTER TABLE id1234567_data.Info ADD PRIMARY KEY (Time), ADD KEY Time (Time);
  

  If you have any problems, click on the tab "Structure" and enter the above options using the graphical interface.
  

• 3

  Upload files to your website

  This example is valid for 000webhost.com, but the procedure should be very similar for any free webhost.

  • Login to the web host admin page.
  • Click on the icon "File Manager".
  • Click on the button "Upload files now".
  • Click on the upload button (up arrow) to upload index.html and newdata.php
  • Right-click on the file .htaccess, select "Edit" and add the following text to the end of the .htaccess file (it allows the PHP in index.html to be executed automatically)

  <Files index.html>
  AddType application/x-httpd-php .html
  Files>

View all 6 instructions