Solved

How can I store values globally over the internet?

Posted on 2004-03-25
2
142 Views
Last Modified: 2010-04-06
Sorry about the vague title, I really didn't know any other way to word it.  Here's the problem: Yesterday my dad asked me to make a website for his work.  They deal with gas transmission lines and the like.  He wanted a private website he and his co-workers could use at work that would keep track of what valve was opened or released.

What my dad wants:
He will draw up a picture of the pipe lines.  He wants to be able to goto this website and click on a specific area of the pipe and the entire area will light up, and on the side will be displayed information about the name and whether or not the valve is open or not.  He then wants a toggle on/off switch to be used to change the value of it.  

This is just going to be a representation or a map of the pipes to keep track of everything.  No actual valves will be turned on or off with this :)  And probably the most important part, he wants the values to remain the same whether you log onto the site from home or office, whether you turn on or off your computer, etc.  Someone at his work should be able to map out that a valve has been released, then anyone else who accesses the site should be able to see the current status.

Now for the hard part, the actual programming.  I really have no clue how this is done, being that I only really know html.  Would I have to learn something like java or php for this kind of work?  Any ideas or tips would be greatly appreciated.  I have no clue where to begin.

-Kronikle
0
Comment
Question by:Kronikle66
2 Comments
 
LVL 6

Expert Comment

by:Reapz
Comment Utility
Ideally you would use a database to store the pipe area information and the on/off status of the pipe. Most hosts provide the MySQL database. If you are just using your ISP provided webspace get your dad to fork over for a proper hosting package. You will then be able to write some code into your webpage that will retrieve the on/off status and the info from the database and display it to anyone at any time. When you dad changes the on/off status or the information about that area of pipe the page would execute a small piece of code to update those fields in the database. You could protect this action by requesting a password to execute the changes. Personally I use PHP to do this sort of stuff because I found it really easy to pick up.
0
 
LVL 26

Accepted Solution

by:
skullnobrains earned 350 total points
Comment Utility
MAPPING
- use the MAP and AREA tags _ i won't discuss their use further since plenty of information is available over the internet
- simply make it different images or embed a classical link in the image

MAPPING IS PROBABLY USELESS
- can't you have a background image with just the valves being links or if you want the sections to light up one image per section, playing on the transparency attribute (or just another image with just the same drawing and different colours to highlight the section)

you will then need to use javascript to highlight the sections
use getElementById to fetch the image and the usual syntax imageElement.property='value';

STORING
fairly easy using databases (and the good way indeed) but you may also consider using a simple text file to write the informations if you can't use a database. anyway you will need to be able to use some server-side script.

SCRIPTING
use php : it is free, powerfull, easy to learn, available almost everywhere, possibly usefull for system programming as well, the scripting is similar to C thus you can understand C fairly easily when you are used to PHP, and the online manual is excellent and always available which is definitely not the case with any other scripting language (you will find false or even foolish information about 50% of the time at least if you search for javascripts for example)

ADDITIONNAL
the fully-featured version of your project would be something which permits dynamic drawing of the map ie the use of a user function to create each part of the map, linked to the previous : fct(sectionNumber,drawing_direction[Left,Right,...],status[open/closed]).
if the valves obey to a tree-like structure you may consider passing a boolean parameter set to 1 if ALL the previous valves are open...
of course in this case the drawing of the structure is made using a simple form (addsection) with inputs such as (parent, direction, length, ... where parent is the id of the parent valve, and direction could be changed to childnumber if for instance u use a graphical design similar to genealogy trees)

STRUCTURE
the use of a frame for the drawing and another for changes could let you automate actualisation of the drawing frame for monitering and still let you modify things easily through the other page (display and change status of valve x, the source of page 2 only changes when you press a new valve-link)

hope you'll figure out something using this information.
i'm available for help (or project realisation) at alexb_orgAThotmailDOTcom
advice is always free so ask if you need
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

When you work with shopping cart / ecommerce relates web sites, you need to pass the certain form post details to the payment gateway process page with required details for the products items you give to order. Also you may need to track the ordered…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now