Tag Archives: MySQL

Starting a New Project…Wanna Help?

Help Wanted Sign
So…starting a new project. I am going to make it work, but if you are a genuis when it comes to this stuff, I could really use some help understanding it. As you may well know, I am a bit of a foursquare fan. I have been posting badge info for quite some time. What started out as a simple post to help me keep track of my own badges has turned into one of the most extensive foursquare badge information sites on the internet. And now, it is becoming more than one person can attend to and still have some semblance of a life.

In the beginning, I hand coded everything just using the WYSIWYG editor in WordPress. This was back when there were only 50 badges total. As the badge count grew, I moved on to coding it in DreamWeaver and pasting the code in the page. A bit later, I had about 150 pages of content that I was having to go back and update with new/updated information so I decided hand coding was not a viable option. I created a Microsoft Access database to generates all the code I need to update my pages with the click of a button. This was nice as it added a GUI to make tracking everything much more simple.

Now, I am at another crossroads and am wanting to take my project to yet another level. Here is what I have: a MySQL database, a Microsoft Access frontend, a WordPress site, two types of web pages I need to generate (badge lists and single badge pages), and a will to make my life easier. I have only just begun to learn php. My intent is to use the Access frontend to update the info in my MySQL database. I would like to only have to enter some snippet of short code into my single badge pages (something like [BadgeID 215]) and have the php query the database to pull the most current data. Same with the badge lists, but I assume that will be a bit more intense.

Here is how I work right now. I get a new snippet of info. I make the change in my database. I output the new code (for one badge update I generate 6 separate web pages) and copy/paste that code into the appropriate pages. Again, what once worked is now becoming a lot more work that it should be.

What I envision is simply changing the code in the MySQL database and having all the pages simply pull the data. Sounds simple, but I have no idea where to begin. If you are someone who knows about this stuff and have a few minutes here and there to help out someone who is wanting to learn, please let me know.

Thanks for stopping by. I hope to hear from you.