PHP on a Windows Server 2003 System

sc2_ct

Hello,

I am working on a project which will require me to build a php-based system for tracking serial numbers by customer on a Windows 2003 Web Server system, and have a few questions since I've never taken this approach before (all of my previous experience is using PHP4 with a MySQL database running on Apache webservers).

First of all, I have read several seemingly contradictory articles regarding which SQL server I will need to use. Is it possible to install MySQL on Windows servers without a linux emulation? How well would PHP4 operate with a MsSQL database?

Also, does anyone happen to know of any pre-existing scripts for serialization tracking of products based on a table of customers using PHP that I might be able to get some ideas from? Any information that anyone can provide would be much appreciated.

Tracer

You can download the binary install of MySQL for windows...

As for a sample script...you would need to be more specific in what you are doing...

sc2_ct

Hi, thanks for the quick response. Basically what I am looking to do is set up a database where a product's part number and serial number are scanned in when they are shipped out and referenced to a re-seller, including date, notes and a couple spare fields for various other numbers (order numbers and the like).

It shouldn't be too difficult of a database to get up and running, but I thought that if someone knew of a script that was out there already, I might be able to get some ideas there and maybe avoid any pitfalls.

Tracer

Due to how it would have to interact with your current systems (Im assuming you would need to perform a lookup of some sort) you are probably better off beginning from scratch....

I use a system similar to this in Pharmacy's where we:

1) Scan RX Number
2) Lookup Rx number from a large enterprise database
3) Scan serial numbers
4) Scan Shipping Tracking Numbers
5) Write all the scanned data to a MySQL backend

The only thing you ned to be carefull about on windows is that the webserver user will need appropriate permissions to access your databases and or windows shares/mapped drives

Tracer

Due to how it would have to interact with your current systems (Im assuming you would need to perform a lookup of some sort) you are probably better off beginning from scratch....

I use a system similar to this in Pharmacy's where we:

1) Scan RX Number
2) Lookup Rx number from a large enterprise database
3) Scan serial numbers
4) Scan Shipping Tracking Numbers
5) Write all the scanned data to a MySQL backend

The only thing you ned to be carefull about on windows is that the webserver user will need appropriate permissions to access your databases and or windows shares/mapped drives