For small and large database projects, Microsoft Access works wonderfully. If you have a database with hundreds of thousands of records, maybe even connecting to other databases remotely. Security isn’t too much of a problem (no Access database is truly secure), and with a wide range of options for publishing and reporting on your data. (more…)
Posts Tagged ‘mysql’
Converting MS Access to MySQL
Thursday, September 6th, 2007Creating an object oriented MySQL abstraction class
Saturday, May 26th, 2007In this tutorial I will show you how you can create an object oriented database abstraction class for MySQL database. Besides the basic functions this manager class can summarize total time spent with db connection and query execution and counts how many query were executed. (more…)
8 Essential MySQL Queries
Sunday, May 13th, 2007Here”s a list of queries that I found myself using very often and that save me a lot of development time. I hope you can benefit from them as well. (more…)
Creating sortable lists with PHP and Ajax
Saturday, May 12th, 2007You might have been in a situation before where you had a list of items in your database that needed to be output in a specific order. These items could be anything: perhaps a listing of your favourite movies or your favourite books. (more…)
Going to the Polls with PHP: Part 2 – Admin panel
Wednesday, May 9th, 2007The next step in building this application is to provide the administrator with an easy way to add and delete questions and answers from the MySQL database. (more…)
Going to the Polls with PHP: Part 1 – The frontside
Wednesday, May 9th, 2007It’s a polling system for a web site, one which allows you to quickly measure what your visitors think about controversial issues (Kerry versus Bush, to-mah-to versus to-mae-to, that kind of thing). (more…)