Show Me The Datafeed
The next step in creating a database driven website is to display the results.
We have the contents loaded up in the MySQL database ready and waiting.
First thing to do is write a simple query that pulls out a few of the entries.
The way I will do that looks like this:
The important part is line #62, the one that starts with $sql.
The way to read it is "Give me everything that has the word 'Tree' in the title.
Once we have that information, then lets print it out.
The "while" statement on line #65 goes through the results and prints out the title and description. Nothing fancy ... at least not yet.
That's enough to hold me over. Enjoy the "family video" that shows you how to do this.
March 14th, 2008 07:21
Your video made it look easy!
Could you have the script create the "query" from the keyword meta tag so each page has products listed based on the keyword meta tag?
This would require template based product pages and it would be nice to vary the template page styles too.
But what if one keyword has 100's or 1000's of products? How would you break down the large number of products into more pages with some limit of the number of products per page?
How can you create a search box, so people can search for a product and the search result links are displayed to related products on your site?
Is this making it too complex now?
March 14th, 2008 07:34
Brian,
Anything is possible :)
If there are 100's or 1000's of results, you can add a LIMIT to the query. Wouldn't be difficult to paginate the results, say to 10 per page.
Search box, you bet.
I'll post a reply this weekend that does something like you are suggesting.
Dave
March 14th, 2008 08:14
Let's do it! " Anything is possible :) "
March 16th, 2008 04:38
Pardon the interruption, Dave...but I lost your email address and I can't find it here or your site or anywhere else. (!!!)
Just wanted to say...I bought Article Post Robot this week and it is, without question, the worst piece-of-crap software I've ever seen in my life (and that's saying something).
If you get bored, Mr. Programmer, and want to create something that people could really use...THERE's an idea for ya. ALL I REALLY WANTED was a program to save time by storing my log-in info for 20 or so article sites, and to store articles with titles and author boxes in a convenient format for retrieval.
But apparently that's brain surgery for the guy that wrote this thing. What a joke!
You could probably make a mint building something like this and selling it for a reasonable price...as opposed to the bloatware and submit-to-a-billion-sites-with-a-single-click crap out there.
So, there's a little idea for ya...no charge! ;-)
March 16th, 2008 09:22
Chuck,
Let me know how you really feel :)
What about using Roboform? If I am not mistaken, it should be able to store your login information - doubtful that it would store your articles/title/author boxes though.
I'm sending you an email.
Dave
April 14th, 2008 20:45
hey there this stuff is great. I am making a few data driven websites and a youtube video promotion site. Drop me a message if you would like to help out, Im always looking for a good programmers, to tell me what im doing wrong.
LOL
Mark.