/    Sign up×
Community /Pin to ProfileBookmark

SEO with database functionality – suggestions needed

Copy linkTweet thisAlerts:
Jun 20.2009

Hi all, thanks for having me.

This might be a hard one to explain.

I am developing a database (mysql) to store business details for many clients (directory), which will be displayed via a public search engine, which will retrieve the relevant search records to display on a web page within my site (using php).

Now I am still trying to work out how to retrieve records to display but not cause conflicts if more than one person is searching at the same time (this maybe not a problem if the page builds and loads fast enough), so logically I am assuming I will need to generate randomly named webpages dynamically. I am sure there are answers out there for this as I certainly wouldn’t be the first. I was trying to do this myself rather than use a piece of third party software… (I might have to do this short term)

The concern I have is trying to figure out a way to promote SEO for their details but if the info is sitting in a mysql DB this is not likey to happen.

What I have seen from searching around is that some people have created a directory on their server for each entry with a basic page with the details on it… I just think this is going to be messy and a little counter productive.

Does anyone have any suggestions or experience with this?

Cheers in advance!

to post a comment
SEO

2 Comments(s) ↴

Copy linkTweet thisAlerts:
@chazzyJun 21.2009 — I will need to generate randomly named webpages dynamically[/QUOTE]

Can you explain why you believe you need to do the above?
Copy linkTweet thisAlerts:
@bizhoundauthorJun 22.2009 — I admit I am not sure that it is the right answer but I am planning on having a search engine front end to my database which will send an SQL query based on user criteria to the DB and return a list of matches to the user (simply put)

I just don't know at this stage that [B]if [/B]the search query becomes a popular tool and more than one person is using it at the same time whether there is a risk of collision. I don't know if the php page will return a recordset for one person if it is under a static name and conflict with another user accessing the same page if it is being built dynamically at the same time.

I am still researching the answer for this one, knowing I am not the first nor the last person to do it.

My main concern was how to get some form of SEO for directory entries but I really think I need to have a physical page per entry or per 'like' group so crawlers will find it as there is no way if the entries just live in the DB.
×

Success!

Help @bizhound spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.18,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...