need guidance before jumping into a major project

[ishee]

Hi ,
I would like guidance about following issue :

1 - How much to add to a sites cost for incorporating paypal functionality ?(amount in dollar)

2 - Is it possible to automatically sumbit CMS pages to google ?

3 - How can I incorporate category management into a php site ?
(table design and php code hints would be great, I want the ability to create categories and change the order as well , moving categories and sub categories up and down).

4 - How to build a sitemap of CMS pages.

[mark_tyler]

1. cant tell for sure (dont know hourly rates in your country), but afaik paypal integration is pretty straightforward.

2. Do you mean to send a link to your page to a Google after you published it in your CMS? No, Google does not provide such a feature. All pages are indexed organically.

3. For a simple category tree, you could use table like that:

id    title    parentid    position
1    Cars    0              1
2    BMW    1             2
3    Audi    1              3

id - int, auto_increment;
title - varchar or text,
parentid - int, references a parent category
position - just generate a unique number when creating category. Later you change position just by swapping this position number for a category that is to be moved, and next (or previous) to it. And you output your category list with ORDER BY position ASC (or DESC, depends on your implementation).

4. Very similiar to categories. Page can be a row in database with parentid referencing to parent page. If you want to generate a sitemap, take a look here: http://stackoverflow.com/questions/2...tion-list-menu

[ishee]

Thanks for the prompt reply,

Is answer to you mentioned "afaik paypal integration" I quite didn't understand what you meant by "afaik", and any advice on one time cost not based on hourly rates.

For your answer to second question , does google provide any API which can be included on the site and user prompted to copy and paste a link provided and click submit button.

your answer to the third question was really helpful.

Thanks a lot for all your help.

[mark_tyler]

"afaik" stands for "as far as i know".

Google provides a form where you can submit a page (but they dont guarantee that page will be indexed and when) - http://www.google.com/addurl/. Dont know if they have API for that.

[ishee]

thanks for the clarifications.