Project Description:
We need to develop a way to use PHP to query a MySQL database to populate data on a Wordpress website.
For example, we have a vehicle with a stock number of 3A6691. We want to query the MySQL database to find the parts available for that stock number.
Currently, we have a database with thousands of truck parts and no way to query this database to transpose it on our webpage. We are looking for a solution to scan the inventory and look for changes on a daily basis to keep an up-to-date online inventory. We would like this data to be indexed by search engines to generate traffic to our site.
Also, our inventory software uses 3 letter prefixes for the part names (for example, TCS stands for Transfer Case) We need a way to replace these prefixes with a customer friendly version that makes sense.
