I created some landing page template in which I test various products.
currently it is a .php file which I manually change each time, along with 3 other files, plus an image, and then upload all of them to my ftp, and edit the .htaccess file to make the links "pretty".
It is pretty inefficient, as it wastes too much time and I guess there's a way to automate this.
basically I need a way just to update the product's price, product name, product image, products description, page title; update links in the related other 3 files; and update the .htaccess file according to the cannonical url which I choose on the product page.
Someone told me that I can use SQL in order to achieve that, is that correct? I have zero knowledge in SQL. he told me I can either used some designated system to update these files, or rather use something called DB.
Is this the way to go? should I try to learn it myself? from where? or where and for how much can I hire someone to do that?
Thanks