How can google find me if i am inside mysql table?

Question

I am creating an ad site.

Im saves all declarations in mysql database in different tables.

Is there any way to find these ads from googles?

Is it possible to create meta information about each ad so that Google can detect them?

How do large companies do?

I thought about auto-generating an html page for each inserted ad, but the 500,000 automatically generated html pages really don't show that this is good for a solution!

Any thoughts and ideas?

UPDATE : Here is my main site: (ALL STRESSY BASES) I have a search engine that searches for a database for records. After searching and displaying the search results, you can click on the result ("announcement"), and then PHP receives the information from the database and displays it simply! In the "post an ad" section on my site, you can post your own ad in the mysql database.

I need to know how I should make Google ads to search on my site, since I don’t think that a google crawler can search my database only because users can.

Please explain your answers in more detail so that I fully understand how this works!

thanks

Answer 1

Google does not find database records. Google finds web pages. If you want your ads to be found, they must be on a web page. You can help with this process by providing Google with the sitemap / index of all your ads.

I suggest you take a look at Google Basics and Creating and submitting SitemapsPrint . Basically, the idea is to give Google every URL that you want to find Google. Therefore, if your link to your ads this way:

http://www.mysite.com/classified?id=1234 

then you create a list of all the URLs needed to search for each category, and yes, it can be hundreds of thousands or even millions.

The above assumes one classification per page. You can, of course, place 5, 10, 50, or 100 on one page, and then create a smaller set of URLs for Google crawls.

Whatever you do, keep this in mind: your site map should reflect how your site is used. Each Google URL that you find (or you give it) will appear in the index. Therefore, don’t provide Google with a URL that the user couldn’t reach using the site normally or don’t want the user to use it.

Thus, while 50 ads per page may mean fewer requests from Google, if you do not want users to use your site (or the presentation you want to provide), you will have to do it differently.

Just remember: Google indexes web pages, not data.

Answer 2

How do you usually access these ads? You don't just store them in a database, do you?

Google sees that your site, like any other visitor, will see your site. If you have a regular database site, there is a unique URL for each category where it appears. If you have a link to it, Google will find it.

Answer 3

If you want Google to index your site, you need to place all your pages on the Internet and link them together.

You do not need to automatically generate a static HTML page for everything, all pages can be dynamically created (JSP, ASP, PHP, whatever you have), but they should be accessible to the web crawler.

Answer 4

Google can find you no matter where you are trying to hide. Even if you can somehow fit into the mysql table. Because they are Google.:-D

Seriously, however, they use the bot to periodically spider your site, so you just need to make the data in your database accessible as web pages on your site and make your site friendly to the bot (use the appropriate robots.txt file, provide a convenient to search a site map, etc.). You need to make sure that they can find your site, so make sure it is connected to other sites - preferably sites with a lot of traffic.

If your site displays only specific results in response to search queries, it will be harder for you. You might want to make complete lists of records available to people without search terms (if you have a lot of data).

Answer 5

First, create a PHP file that pulls out an index and a human-readable link for all entries.

This is your main page categorized (for example, in the case of Craigslist.com, by country and state).

Then each category link returns to the php script to the selected value regardless of the level (s) that finally reaches the ad itself.

So, if you select a category that contains more categories (for example, states contain cities) then display the following list of categories. Else displays a list of ads for this city.

This will give Google.com the ability to index the site (aka mysql db) dynamically without creating static content for the millions (billions or trillions) of records involved.

This is just an idea on how to get Google.com to index the database.