PHP & SQL Database updates
Budget: $1,500 – $3,000 AUD
I'm looking for an experienced PHP & SQL developer to create a program that can handle multimedia data. The primary functionality will be data input and retrieval.
My Client has a directory folder located on a windows server that contains a series of TIF images. These image names contain a plan number followed by a version number. For example the image file may be called "FTY1901;0.tif" where the plan number is FTY1901 and anything following the ; character is the version number - in this case 0 but it could be anything up to 9.
I wish to create a php script or any language can be used, to scan the folder location (instigated by a regular task scheduled on the server) and look for all TIF images in that location. Once the scan is complete i wish to have the application look for the latest version of the plan (the highest number following the "; "character) and then append the name of that file into a SQL database.
The table being updated to the SQL database via SMSS should contain 4 fields. The first will just be the plan number extracted from the folder (the name of the file with all characters before the ";") the second field will be the actual file that is the latest version (for example FTY1901;5.tif) then the third and fourth columns will be autogenerated based on the file name and containing a path that is used to link these images to a mapping application.
Examples of the third and fourth columns using the FTY1901;0.tif example would be references to virtual directory URLS such as https://intramaps.gympie.qld.gov.au/surveyplans/FTY1901;0.tif. The fourth column would be similar but to be advised later.
This process could be conducted via a PHP script or powershell or any suitable application but needs to be able to be scheduled on a windows server by the "Task Scheduler" function and needs to update a SQL database table.
The end goal is the mapping application will link to the SQL database that contains this information and have the ability to retrieve the correct survey plan (i.e. Latest version of the TIF Image) that is matched to the plan number.
My Client has a directory folder located on a windows server that contains a series of TIF images. These image names contain a plan number followed by a version number. For example the image file may be called "FTY1901;0.tif" where the plan number is FTY1901 and anything following the ; character is the version number - in this case 0 but it could be anything up to 9.
I wish to create a php script or any language can be used, to scan the folder location (instigated by a regular task scheduled on the server) and look for all TIF images in that location. Once the scan is complete i wish to have the application look for the latest version of the plan (the highest number following the "; "character) and then append the name of that file into a SQL database.
The table being updated to the SQL database via SMSS should contain 4 fields. The first will just be the plan number extracted from the folder (the name of the file with all characters before the ";") the second field will be the actual file that is the latest version (for example FTY1901;5.tif) then the third and fourth columns will be autogenerated based on the file name and containing a path that is used to link these images to a mapping application.
Examples of the third and fourth columns using the FTY1901;0.tif example would be references to virtual directory URLS such as https://intramaps.gympie.qld.gov.au/surveyplans/FTY1901;0.tif. The fourth column would be similar but to be advised later.
This process could be conducted via a PHP script or powershell or any suitable application but needs to be able to be scheduled on a windows server by the "Task Scheduler" function and needs to update a SQL database table.
The end goal is the mapping application will link to the SQL database that contains this information and have the ability to retrieve the correct survey plan (i.e. Latest version of the TIF Image) that is matched to the plan number.