| dmcglone | Hi everyone | 01:25 |
|---|---|---|
| BiosElement | unHi dmcglone | 01:26 |
| dmcglone | what's up? | 01:26 |
| dmcglone | anyone good with database design? | 01:26 |
| BiosElement | Eh, maybe. haha | 01:26 |
| Cheri703 | Don't forget daylight savings time! | 01:27 |
| dmcglone | I'm just fooling around with techniques on paging | 01:27 |
| dmcglone | was wondering if I should number the pages in the DB or just go by the "title" of the page | 01:28 |
| BiosElement | dmcglone, As in number each db entry? Or tag 15 entries with 'page5'? | 01:28 |
| dmcglone | more like putting a number to each db entry, besides the primary key ID | 01:30 |
| dmcglone | for instance the db would look something like this: | 01:31 |
| dmcglone | ID | page | description | 01:31 |
| BiosElement | Sounds like you're over-thinking it maybe. | 01:31 |
| dmcglone | and when called, go by the page number to get the description | 01:31 |
| dmcglone | I think I am too | 01:32 |
| BiosElement | I'm not aware of any db design that actually does that. | 01:32 |
| dmcglone | say for instance I put in the db ID 1 | page index | description bla bla bla on the page | 01:33 |
| dmcglone | wait a second, that wasn't correct | 01:33 |
| dmcglone | more like: ID 1 | page 1 | description bla bla bla text on page | 01:34 |
| BiosElement | You think too hard :P | 01:34 |
| dmcglone | I usually pull from the DB by title | 01:35 |
| dmcglone | I was playing around today and was trying new techniques | 01:35 |
| BiosElement | You may have a good idea, but I think it's probably more complex then it's worth. | 01:36 |
| dmcglone | and I pull the content for that page based on the page title | 01:36 |
| dmcglone | it's pretty much the way all the CMS's do it | 01:37 |
| dmcglone | I can't use the actual ID because it may not match up with the page title | 01:38 |
| dmcglone | I've even used case statements for page display :-) | 01:40 |
| dmcglone | huh, matter of fact I've used if else to display them too | 01:40 |
| dmcglone | is google sucking bad or what? I do a search and get a complete blank page | 01:43 |
| dmcglone | BiosElement: check this out, I wrote this about 5 years ago, simple function to get the page number from the db and display it's contents http://pastebin.com/5nwXPHLV | 01:47 |
| BiosElement | Mmm Ahh cool | 01:48 |
| dmcglone | with that code, I could enter everything for the page into a db and give that page a number and it would automagically generate that page | 01:48 |
| dmcglone | Oh the power of PHP ;-) | 01:51 |
| BiosElement | lol, I bet I could do it in python easier ;) | 01:54 |
| * Cheri703 watches yet another python / php pissing match | 01:54 | |
| Cheri703 | :D | 01:55 |
| dmcglone | bet? you don't sound so confident ;-) | 01:56 |
| dmcglone | lol Cheri703 | 01:56 |
| Cheri703 | put them on the table and measure already! | 01:56 |
| dmcglone | haha | 01:58 |
| dmcglone | I might break the table :-/ | 01:59 |
| dmcglone | he's awful quiet, he's probably googling how to write paging methods for python | 02:00 |
| dmcglone | lol | 02:00 |
| dmcglone | I got another one for ya, that doesn't use a DB. I'll post it on PB for you to droooooooool over... LOL | 02:02 |
| dmcglone | drool on this: http://pastebin.com/Q3ZXQk57 | 02:03 |
| dmcglone | Ah come on dude, you gotta drop kick me or something, just give me a sign... lol | 02:09 |
| dmcglone | and no I don't mean the middle finger haha | 02:09 |
| BiosElement | lol, sorry. Neck deep in auth code atm | 02:12 |
| Cheri703 | can I just say for the record: SeaQuest is RIDICULOUS | 02:13 |
| dmcglone1 | whats seaquest? | 02:19 |
| dmcglone1 | a game? | 02:19 |
| dmcglone1 | auth code in pearl? ;-) | 02:19 |
| Cheri703 | 90's sci-fi tv show | 02:19 |
| dmcglone1 | Oh ok | 02:22 |
| dmcglone1 | I'm watching "I almost got away with it" | 02:23 |
| dmcglone1 | getting ready to get my midnight snack. Cereal :-D | 02:24 |
| dmcglone1 | shredded wheat anyone? | 02:26 |
| dmcglone1 | well I'm off to bed :-) | 02:40 |
| dmcglone1 | g'night everyone | 02:40 |
| BiosElement | Folks nextdoor want to run up and down the stairs all night and bang things around...apparently tonight's a free loud music night! ^_^ | 06:01 |
| BiosElement | Yay for long as hell day tomorrow | 23:57 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!