How Can I Develop An Information Site on a Local LAN

Rahul Singh Rathaore February 4, 2010
Pinterest Stumbleupon Whatsapp

I want to develop a site that offer Factory related information (Technical support) to the employees. Actually My Factory is a Mobile Repair factory. There are 200 Technicians, they should be able to update some data about repairing a handsets. This data saved in MySQL. End of the shift, the Team should be analize the performace/produtivity of own technician.

I develop some pages in HTML, but how to connect MySQL to HTML form for retrieve/update data. I also installed Apache Server. plese someone help me.

1.How can i connect MySQL and HTML page? (step-by-step)?
2.How to use Apache Server?(step-by-step)?
3.How to use PHP?(step-by-step)?

Ads by Google

  1. donald choi
    September 8, 2010 at 7:59 pm

    Need to install LAMP on own networked PC (@winwong) for internal office network only

    ++ For "step by step" HTML hosting (LAMP) servers install instructions see : http://www.howtoforge.com/ Choose from several instructions for different linux distros - Ubuntu, SUSE, Fedora, Centos among the popular ones.

    ++ Then install something like the OSticket (@jack cola #3), on the LAMP webserver.

    For access externally e.g. home or via internet, its easier to buy hosting and domain name for external access and get a webdeveloper/designer to install the OSticket type system on it.

  2. winwong
    June 29, 2010 at 3:30 am

    You don't need to buy a hosting because Apache web server is a hosting...First you need to install Apache, Php and Mysql in the normal computer..I think hosting is free but need to buy domain name...

  3. Jack Cola
    February 8, 2010 at 12:09 pm

    The three steps you are asking will take someone years to learn.
    1. HTML and MySQL will not go together. You need to learn PHP. http://www.w3schools.com/ is a good start to learn all this.

    2. I think the best and easiest thing to do is purchase web hosting. I personally use Deasoft.com. It will be much easier then to try and manage your own webserver, especially if you require step-by-step instructions on how to set it up.

    3. Refer to step 1. Once you have learnt PHP, you can create your website that you want. Or you can download an open source script such as http://osticket.com/.

    If that suits your needs:
    1. Get webhosting
    2. Use Fantastico to install OS Ticket
    3. Login in admin and your done.