PHP, MYSQL is that the way to go for my site

Hi I have websites built with 500 product pages, everything static. Now I need to add more pages. It is very time consuming.

But I have all the content to go on the product page in cvs, excel and xml format.

Now I want to add more product page dynamically. But still want to have the category page static.

Read somewhere i can create pages in php and mysql......and what do u think will be the development cost?

IS that the best way to go about?

Any help will be highly appreciated...

 

yes, use php/mysql, and u can still make the url static still by using mod_rewrite.

Development cost will likely depend on who you are asking to build, most probably range from 200 - 1000$, i bet

 

You must use php and mysql ... or other
If you have a site who sell products you can use some free e-commerce solutions like oscommerce, zen cart ...

 

That’s for you help toby and zzzttt..really appreciated….

Can I import xml data to the MYSQL or is it easier to import excell or csv and I already have a blog for my website….so will I have to have a separate database or can I integrate with the existing database ?

Actually I have content pages and not an ecommerce page…..

 

Depends on who's working on importing. Any method can work. I too recommend on switching to a dynamic site right away. Very few and small sites rely on static pages as they are very hard to update and maintain. Not to mention redesign and all that stuff. Pay it and it will pay back.

 

if it is just product pages and no online buying option then you can try using wordpress and convert all data. or either use oscommerce if you want to make a online shop of your products

 

this can be done in just about any server side language and database combination of your choice. it's completely up to you. php however, is the most widely used as well as mysql. but in the end, it's your decision. PHP, ASP.NET, Cold Fusion, JSP, the choice is yours.

 

ansi seems to be angry with saying only PHP-Mysql and zztt wrote....or other.this forum's name is PHP ,so every members of this forum would say PHP-Mysql at first .

 

hello :
you can use the same database if the both scripts doesn't share the same fields names .

however , for security reasons , it's better to use a separate database for each script .

 

oh im not angry at all hehe, i was just making a point. i actually prefer PHP/MySQL over any other combination. but i thought i should point out that you have more options than just php/mysql and you could take it in any direction that you wanted to.

 

Most webhosting and servers support PHP so you have a wide range of choices for server and hosting if you pick PHP aside from other server-side scripting languages. Also, there are a lot more web developers that use PHP compared to other scripting languages like JSP and ASP so if you need addons, or having tech issues with your site, you can more easily find help than if your running on other server-side scripting engines.

 

Our company deal with such cases, we also do the installation for free

 

If you have the data in XML format or even CSV, then that is great, it saves the work of scraping the HTML of static pages. In fact, all you need to do is get something like osCommerce and have someone make a quick script that parses the XML into the osCommerce database.

Sure, you can integrate with existing database but is there a problem with making a new database for the e-commerce section of the site? It just sounds as if it might be.

By the way, I also highly recommend you use a dynamic system for your site, especially in your case where the initial workload is relatively low.