Results 1 to 12 of 12
March 28th, 2007, 11:38 PM #1Where do the bulk of databases files go too
Having learned to import SAS datafeed from this post
http://forum.abestweb.com/showthread.php?t=86606 and it specified: This code will only manage ONE datafeed.
I am converting my html site to php.
present html site
www.mysite.com - index.html
www.mysite.com/product-C.html ......and so on.
All these are place in the same directory as the index page.
Now I convert the above to php
www.mysite.com - index.php
The index.php will be my content page with no calling of products from the database.
For all the other product pages, it will have each merchant database to call.
For each merchant database, I will have to create difference config, db_funcs, catlist files etc...
Lets say that I have 10 databases with 10 different merchants, can I put all the 10 config, db_funcs, catlist files etc under the same directory as the index page? Will it work?
I hope you all understand my question.
March 29th, 2007, 12:05 AM #2
1. Why do you have seperate php files for each product? Is there some mod-rewrite work going on.
2. With the proper planning why can't you do this with one set of php and make your needed changes in the config file?
I am also still a little confused as to what you are trying to do?
March 29th, 2007, 12:27 AM #3
I have one database for each merchant so 10 different databases for 10 different merchants, all from SAS.
Each database will require their own config, db_funcs, catlist files etc, because the input details like merchant id, product id, descriptions etc are different.
I hope I am making it clearer.
March 29th, 2007, 12:44 AM #4
I am a person who designs large database on a daily basis, so here are some suggestions that might make it easier.
- Do it all in one database with different tables for each vendor
- If they all come from SAS that means all of the formats are the exact same. Why not do them all in one table? If you need to know the difference between the vendors add your own column that identifies which vendor it is.
March 29th, 2007, 12:45 AM #5
"Where do the bulk of databases files go too"
March 29th, 2007, 01:03 AM #6
Thanks patrick24601 and Donuts for responding.
I am still very raw with php and importing of datafeeds from merchants.
I am using the script as provided in this thread
http://forum.abestweb.com/showthread.php?t=86606 to import SAS merchant datafeeds and it specified: This code will only manage ONE datafeed per merchant.
The only way I can think of is place each merchant data on the third level i.e
www.mysite.com/merchantA/index.php, each merchant on its own directory???
I still have to learn how to import datafeed from all merchants into one table as mentioned by patrick24601.
March 29th, 2007, 01:41 PM #7Originally Posted by Donuts
- ScottHatred stirs up strife, But love covers all transgressions.
March 30th, 2007, 03:24 AM #8
Thank you Snib, Donuts,
Does it mean if I create one database for each merchant for each page, it will all be placed as supplemental results by google?
March 30th, 2007, 09:20 AM #9
if that's all it is, a repeat of the merchant's feed, your seo will suffer. i can't predict with certainty that it'll be supplemental, but i'd guess it's very, very likely to be so. think of ways to compare, analyze and make the data useful, in unique ways, and you'll change the outcome. ask yourself what is the compelling reason for a consumer to see the product feed, on your site, versus the merchant's site where it's available directly... that's the key to getting natural backlinks and to also distinguish your site from being a mirror of data available elsewhere.
March 30th, 2007, 09:54 AM #10
Will look for ways and study on how to make better use of the data.
Still learning the php thing, one question if I may.
I have the merchant datafeeds in my webhost database, can I select and choose only certain products from the database to be placed on my site pages using php coding (is there such a coding)?
March 30th, 2007, 10:07 AM #11can I select and choose only certain products from the database to be placed on my site pages using php coding (is there such a coding)?
You can limit what you want to show by general products, by price, by category, etc.
"is there such a coding"
Those are the easier scripts to make.
March 30th, 2007, 10:28 AM #12I am still very raw with php and importing of datafeeds from merchants.
SAS may have all the feeds with the same columns, but it's surprising how many ways merchants can mess with that. Here is an example from the Custom 1 column for ReStockit "KitchenUtensilsDishers".
All you need is a reference book and a little time. It's not that hard. Try "PHP and MySQL Web Development" by Welling and Thomson.
By davidh in forum Programming / Datafeeds / ToolsReplies: 1Last Post: May 21st, 2009, 04:14 AM
By bettylou in forum Midnight Cafe'Replies: 16Last Post: October 7th, 2008, 07:32 PM
By pachecus in forum Midnight Cafe'Replies: 1Last Post: June 12th, 2006, 09:54 AM
By zendozen in forum Midnight Cafe'Replies: 1Last Post: May 26th, 2005, 10:55 AM