Can I have a standard HTML page pull the SQL product info?

[Guest]

I'd like to be able to keep and make some static HTML pages which would integrate with the osCommerce DB. This is largely for search engines--I can put the product name and description, etc. in static form, but am hoping that the price and a 'buy now' button or something can be pulled into a box on the static page, which would then take someone to the osCommerce cart. I have good search engine listings with my existing CGI cart, and don't want to abandon those pages. However, manually updating the HTML for price, availability, etc., is something I hope osCommerce can get rid of for me while allowing me to keep some static product pages.

 

If this requires a custom solution or much time to work out, I'm willing to pay or donate for the info/service.

 

Regards,

 

Kevin

[hobbzilla]

I'd like to be able to keep and make some static HTML pages which would integrate with the osCommerce DB.

 

This sentence meets the requirement for an oxymoron.

 

stat?ic (adj.)

2. Fixed; stationary.

 

dy?nam?ic (adj.)

2. Characterized by continuous change, activity, or progress:

 

You can't have a static HTML page that dynamically pulls information from a database.

[Guest]

You can't have a static HTML page that dynamically pulls information from a database.

 

True, but you can integrate information from the database into an HTML page. This will be the "front page"(index.html) of my site soon. It seemlessly goes from the HTML to the dynamically generated pages of OSC.

 

To make the page I copied the generated HTML of the page I wanted to match and made sure all of the session id's were removed and Voila'! An HTML page that has dynamic menus, uses the same stylesheet, etc.

 

http:www.bird-e-toys.com/test1.html

[burt]

You can't have a static HTML page that dynamically pulls information from a database.

 

True, but you can integrate information from the database into an HTML page. This will be the "front page"(index.html) of my site soon. It seemlessly goes from the HTML to the dynamically generated pages of OSC.

 

To make the page I copied the generated HTML of the page I wanted to match and made sure all of the session id's were removed and Voila'! An HTML page that has dynamic menus, uses the same stylesheet, etc.

 

http:www.bird-e-toys.com/test1.html

 

I don't see any value to you doing this ? Can you explain your reasoning for making the .html file ?

[burt]

I'd like to be able to keep and make some static HTML pages which would integrate with the osCommerce DB. This is largely for search engines

 

What is the difference to a search engine between a 'static' html page and a 'dynamically' produced page ?

 

One will have variable and ?'s in it. Easily solved by using "Search Engine Friendly" URLs...

 

Can you explain what you hopw to achieve by using .html pages as opposed to .php pages

[Guest]

I don't see any value to you doing this ? Can you explain your reasoning for making the .html file ?

 

My personal reasons were influenced by the discussions of the problems with search engines indexing the dynamic pages. I already have pretty good placement and I didn't want to have to worry about an sID killer or header-tag generator that might not get the same results I already have.

 

My marketing strategy has always been to be rated in the top 10 under a keyword that is used rather than just having lots of listings...in other words, if you search for "bird toys" you will find me...I won't get any sales from getting the privacy policy listed.

[burt]

I didn't want to have to worry about an sID killer or header-tag generator that might not get the same results I already have.

 

That makes sense. I can see where you are coming from on it now...still don't agree it's worth doing ;) but to each their own :D

[Guest]

That makes sense. I can see where you are coming from on it now...still don't agree it's worth doing icon_wink.gif but to each their own

 

LOLOL...That's ok, I've never been accused of being completely conventional.

[Christian Lescuyer]

Kevin,

 

You can add your own pages to osCommerce, or osCommerce to an existing site without problems.

You can design a mostly static page with a fixed query, for example to get a product price. The buy now button will be a fixed link and doesn't require any special work.

 

Usually you have to name your pages something.php, but if you can change your apache settings, you can keep the existing .htm/.html extension. It's also possible to do some magic with the .htaccess file.

 

The query would be similar to osCommerce queries in product_info, only simpler. Eg

tep_db_query("select products_price from products where p.products_id='232');

 

Is that what you want?

[Guest]

I appreciate the oxymoron of a dynamic static page. I have several product pages in HTML that come up (already) in the top 10 for searches on those terms and would rather take extra time to modify those pages to pull current pricing/purchase info from the DB while putting the product descriptions in static form to maintain searchability and spiderability.

 

I'm not a PHP whiz, so cutting and pasting then modifying the product's item number, etc., is OK, but I can't figure out what code to use. One good example would suffice. If I can do this, it will make me very happy, in addition to giving me a lot more work to do! :lol:

 

So to sum up, I'd like to make a hybrid site where some pages are .html and contain standard HTML formatted text for an extended product description, but have a box somewhere on the page which pulls the current pricing information (including quantity controller discounts, if possible), provides a quantity box for multiple item purchases, and has an 'add to cart' button. If someone can create a sample page of just one item with this setup, it will give me enough keys to get it done for my own pages.

 

Thanks,

 

Kevin