o/` Radiohead-Paranoid_Android o/`
It’s Snowing!!!!!!!!!!!!!!!!!
Ahem, now that I got that out of my system… the snow is nice, fluffy, happy snow %) We have something like 4 inches on the ground, it’s not supposed to stop til this evening, YAY! I love snow, and last year we hardly had any. We’re calling a place that delivers half cords of wood to get one delivered this weekend hopefully, with any luck that’ll be all we need this winter for our fireplace, and hopefully we’ll find room on our little porch for it all, hehehe.
Good news! Yesterday I made several breakthroughs with PHP and MySQL! I ended up creating a user for ‘guest’ in the guestbook database, made a table called book, went and then connected with php and I was able to write to the database using the mysql php module. Then I was able to grab the entries made by the php page with more php and display them on a page… all this took about 3-4 hours. Then this morning I finally got finished being able to post all the entries onto one page.. this was actually the hardest part of the whole process.! Uh, well if anyone is interested I’ll just post what I did after the connection to the database was established here:
$Rows = mysql_query(“select count(*) from book;”) or die (“Invalid Query”);
$NumberOfEntries = mysql_result($Rows,0);
$Entry = mysql_query(“select * from book;”) or die (“Invalid Query”);
while ($NumberOfEntries >= 1)
{
$NumberOfEntries–;
printf(“Date: %s?br?n”, mysql_result($Entry,$NumberOfEntries,”date”));
printf(“Name: %s?br?n”, mysql_result($Entry,$NumberOfEntries,”name”));
printf(“Email: %s?br?n”, mysql_result($Entry,$NumberOfEntries,”email”));
printf(“Webpage: %s?br?n”, mysql_result($Entry,$NumberOfEntries,”webpage”));
printf(“How: %s?br?n”, mysql_result($Entry,$NumberOfEntries,”how”));
printf(“Comments: %s?br?n”, mysql_result($Entry,$NumberOfEntries,”comments”));
printf(“?br??br?”);
}
Hrm, it appears these weblogs dont like replacement values for <'s and >‘s … well that’s what those ?’s are in the code %)
That looks like this (with two entries in the database at the moment):
It’s not very complicated, but I am really inexperienced with both MySQL and PHP, so it’s quite an acomplishment for me %) I’m really excited. I will make it all “pretty” today, and I’ll have Myk add a user for me in the MySQL database on the Cobalt (currently only root can write to the database, and I dont have the root pass) so I can put this on my webpage tomorrow. YAY!!!
We decorated the tree last night, well, put lights on it and an angel on top, hehe. We have bulbs to put on it, but none of those little wire things that you hang the bulbs from, I think we had this problem last year as well and said “aw we’ll get them next year..” hehe. The tree looks nice just with lights on it tho %)
My father called me last night. He seems to be doing alright, I guess his arthritis is getting pretty bad so he is seeing doctors about it… but he’s doing ok in the rehab program, reading a lot and doing a lot of writing, which is all cool ’cause those are things I enjoy too, and that I know he enjoyed before he became an alcoholic. It was nice talking to him though, even if half the conversation consisted of “you should move back to new england, the job market is nice, it’s beautiful here, you will be near family!” … I do love new england, but I don’t have terribly strong family bonds, so the only reason I would move up there is if Myk could find a good job, and we could find a nice place to live. My dad asked if I was getting married sometime too, ugh, my *mother* asks that everytime I talk to her too! Parents! They’re divorced, I’d think they’d know better than anyone not to rush into anything… I guess they just want to see me taken care of *shrugs*
Anyway, I’m gonna go make my guestbook pretty %) I’ll be making a “preview entry” page too I think, it’ll be fun anyway, I like making things pretty, hehe. *wanders off*