Basic Introduction to a DIY PHP Intranet + Code

Since I have entered the IT industry Excel has been the driving force for EVERYTHING around me. I am personally not a fan of Excel nor am I good at it.

So... for anyone who is keen on learning a bit, here is a BASIC web based intranet skeleton sample. It only allows you to perform a simple search on the data store in the database (sqlite in this instance). The entire setup contain only four files and only two of them are editable. While recording this it darned on me that me doing this on a Windows 10 machine would have been SO MUCH more beneficial to most people = I will probably do my next demo on Windows and show you how to get the Web Server installed (free software so no worries).

There are only 3 products to query: BX12, BX15 and LB100.

Hopefully this ULTRA basic setup will give you a general feel what to expect. It is obviously lacking user identification, control rights and other features but you have to start somewhere. This can be an amazing tool for someone to debug problems or create custom pages to aid their work flow.

I will probably introduce some new things like a function that queries stuff for you and spits out an array via ODBC + maybe something to read data from Excel files... Everyone loves Excel, right :D :D

Here is a download link:

http://db4you.co.uk/uploads/intranet.zip

Have fun!