Recently I was asked by a fellow coder about displaying the most recent members on his website that have joined. You see this statistic on many websites especially those such as forums, boards, blogs and other social mediums.
So I thought I would share a little PHP Snippet with my readers as to how you go about actually achieving this. First, you must realise that before you can list by this criteria you must be saving certain data to a field within your already existing database.
Random Quotes… What do I mean by this? Simple, I mean creating a script that allows you to insert your choosen quotes into an MySQL Database and recall them at random displaying one at a time. When the page is refreshed, reloaded on a system the PHP Code would select from your inserted quotes and show one at random.
So, who would actually need something like this? There are many plugins out there to grab and use on your sites. So lets just say you do not use a Blogging Platform. You have a static website that you are looking at trying to change dynamically as a visitor first visits or revisits your site.
JDBC is a Java API for communicating with relational databases using SQL commands. It consists of a set of classes and interfaces written in the Java programming language.
JDBC performs a similar role to ODBC; it provides a platform independent interface that enables a single version of an application system to access any compliant database. Like ODBC, it does require the availability of a software driver for each type of database to be accessed. A JDBC-ODBC bridge is also available; this enables JDBC to work with any database for which an ODBC driver is available.
Microsoft Open Database Connectivity (ODBC) specification was created with a view to making it easier for an application developer to write systems involving communication with different types of databases.
The objective was to make it possible to develop an application system that would work unchanged with a variety of different databases. Although it was originally designed by Microsoft, it is now supported by all major database vendors and is subject to international standardisation.
Here I am going to attempt to define the term ‘database’; but unfortunately, like many terms used in computer technology, there is considerable variation in interpretations placed on the word ‘database’.
A basic look would be something like ‘a collection of data’. Ha ha, yes that is rather basic I know and trust me thats not it. I have more to tell you so stay with me. 
Another look might be ‘a large centralised shared data repository’, but surely that definition would not include a database on a personal computer.
The Database Concept! What do I mean by this? Well, I certainly do not mean that further down this article your going to see a fantastic picture of a new innovative concept car. (That would be nice though!)
No, what I mean by The Database Concept is basically the reason why we have databases today and use them so much in everyday life. Before I begin, lets just take a short look at the common problems with files systems in general that became apparent for us to consider the use of a database.
Ok, so you might have seen my previous article when I provided my fellow world coding community with a SQL table structure and content for all the countries. Well, I am back again but this time I have one for all the states of North America (including Canada).
If you want to see my other SQL Table for countries then you can view it by clicking MySQL Table – Listing all countries.
Post revisions, a WordPress 2.6 and beyond feature, can be very useful, but they also increase the size of your MySQL database. Sure, you can manually delete posts revisions, but that’s very long and boring work. (Now I don’t know about you but that just does not sit well with me.)
The solution to this problem is simple: we can delete post revisions in a few seconds by using a simple SQL query. The result can be almost unbelievable if you have a lot of posts: Your database size will be reduced by half!
Ok, so I dont know about you but when I develop PHP Applications I tend to find myself having to create forms for users/customers to fill in. Most online applications developed are for a worldwide audience. So having a field that displays your country location is vital.
I know I for one dont like having to create this table and add all the entries to the table manually. So I thought why not share with the worldwide community of coders a structure for a table that will enter all the country names for you. This will allow you to insert this list into any database you desire and then call upon that table list to display within your forms.
I have come accross coders who want to know a simple solution to stop users from using the back button to resubmit data if they have made a mistake. Now I have plenty of solutions for this situation but they would depend on your current system in place such as; do you require a user to login? Does your system create sales order numbers? and many more questions.
So to keep it simple I will assume that you basically have a form that anyone in your company can use to submit an order which reduces the amount of stock you hold. This would simply be a system that monitors the amount of stock you have and nothing else.
Shaun is a man with a background in joinery, music, administration, management, web development and technologies. A devoted friend and father to his wonderful daughter, he is also a family man. He likes to create and produce things which has led him into a stronger, more passionate pursuit of development.
Loading ...
Where possible I do not use cookies unless you have given me consent to do so.
As a valued visitor to my website, I am committed to maintaining your privacy and being clear & transparent on how I use cookies and any personal data you submit to me.
I use cookies to recognise website visitors and to store the way visitors use this site. This allows me to analyse website activity, so I can optimise the user experience and make sure I offer the best content for visitors.
I use cookies in order to give me information on the number of visitors to different parts of my website and thus to monitor which areas are most useful.
I do not collect personal information about my visitors unless you have submitted those details via one of my forms.
To find out more about my Privacy and Cookie Policy you can visit the following page:
Shaun Ellerton Feed