Can I create static pages from php reading data out of a mysql db?

**V_RocKs** · 04-22-2008, 11:51 PM

I think you are almost there.

**Hotrocket** · 04-22-2008, 11:55 PM

yep it can be done..I have a link to a free script w/ tutorial and examples but its on another webmaster forum so cant post it here..gimmie an email and I'll send it on over to ya.
sry no icq

**Adultnet** · 04-22-2008, 11:59 PM

yes can be done,
Basicly you can have 2 options :
1. Force the php script to connect to the database go all over the topics you got there and create the html pages for you based on a layout.(Dynamic if setup as batch/ static if not)
2. Force the pages to be auto created once a reply is added to the database by running the the same lines just for the recent topic. (Dynamic)
if you need help with setup you can hit me up at icq 502189..

**Kard63** · 04-23-2008, 12:39 AM

Originally posted by Hotrocket

yep it can be done..I have a link to a free script w/ tutorial and examples but its on another webmaster forum so cant post it here..gimmie an email and I'll send it on over to ya.
sry no icq

kard63atyahoocom

**Hotrocket** · 04-23-2008, 01:12 PM

email sent

**Kard63** · 04-23-2008, 03:14 PM

Originally posted by Hotrocket

email sent

Thanks man. That script seems to be it but I can't use a script. I have to code it.

Originally posted by Adultnet

yes can be done,
Basicly you can have 2 options :
1. Force the php script to connect to the database go all over the topics you got there and create the html pages for you based on a layout.(Dynamic if setup as batch/ static if not)
2. Force the pages to be auto created once a reply is added to the database by running the the same lines just for the recent topic. (Dynamic)
if you need help with setup you can hit me up at icq 502189..

Thank you. I'm going to go get a pizza and hit you up!

**Kard63** · 04-23-2008, 03:15 PM

Are these the two methods you mentioned adultnet
Generate Static HTML Pages From A Database
Create Online - Designing search engine friendly PHP pages

**woj** · 04-23-2008, 03:21 PM

Are you sure you need static pages? maybe just some mod_rewrite magic would be good enough?

**Sam Granger** · 04-23-2008, 03:25 PM

I am off to bed but I can program something like this in no time for free. If you dont have any luck today, email me: [email protected]

**Kard63** · 04-23-2008, 03:33 PM

Originally posted by woj

Are you sure you need static pages? maybe just some mod_rewrite magic would be good enough?

Static might not be the word I'm looking for. I want the extension to be html and I want google to be able to tell no difference when it indexes it.

**Bro Media - BANNED FOR LIFE** · 04-23-2008, 04:12 PM

Originally posted by Kard63

Static might not be the word I'm looking for. I want the extension to be html and I want google to be able to tell no difference when it indexes it.

RewriteRule ^articles/([^/]+).html$ index.php?article=$1

BLAM!!

**Kard63** · 04-23-2008, 04:25 PM

Originally posted by Jaysin

RewriteRule ^articles/([^/]+).html$ index.php?article=$1

BLAM!!

Umm I donut know what that is but is that 1 line really the answer to everything I want?'

**Bro Media - BANNED FOR LIFE** · 04-23-2008, 04:27 PM

Originally posted by Kard63

Umm I donut know what that is but is that 1 line really the answer to everything I want?'

its htaccess, what it does is it takes yoursite.com/articles/some-title-here.html and the server reads index.php?article=some-title-here

i use it on my sites
http://www.fukbag.com/articles/celeb...ed-to-you.html
is actually pulling
http://www.fukbag.com/index.php?cat=...appened-to-you

**ScriptWorkz** · 04-23-2008, 04:33 PM

Editted: What they said ^^

**Kard63** · 04-23-2008, 06:51 PM

Originally posted by Jaysin

its htaccess, what it does is it takes yoursite.com/articles/some-title-here.html and the server reads index.php?article=some-title-here

i use it on my sites
http://www.fukbag.com/articles/celeb...ed-to-you.html
is actually pulling
http://www.fukbag.com/index.php?cat=...appened-to-you

and google is clueless?

**brandonstills** · 04-23-2008, 11:47 PM

Are you wanting to do this to make the URL's look nicer or are you wanting to do this for performance reasons? For the former, there are numerous ways to go about making dynamic URL's that can be parsed any way you like. For the latter, you simply need some code that goes through the database entries and writes a file for each entry. Both are fairly trivial. Any decent programmer will be able to help you out.

**Bro Media - BANNED FOR LIFE** · 04-24-2008, 10:28 AM

Originally posted by Kard63

and google is clueless?

absolutely!

**gornyhuy** · 04-24-2008, 10:34 AM

imho its better to crank out static pages. Easier on the server, cleaner on the SEO, and just as easy.

**skrinkladoo** · 04-24-2008, 04:03 PM

Jaysin's right - .htaccess is the easy way

**skrinkladoo** · 04-24-2008, 04:09 PM

try adding this to the .htaccess

RewriteEngine on
RewriteBase /
RewriteRule ^([^/]*)\.html$ $1.php?%{QUERY_STRING} [NC]

make sure the mod_rewrite is enabled on the apache config (or ask your hosting company)

Can I create static pages from php reading data out of a mysql db?

Can I create static pages from php reading data out of a mysql db?

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment