Database Related Tutorials - LearnPHP.org
Which database do I use: Postgres or MySQL? This age-old question has plagued developers for, what, at least a couple years now.
March 19,
2010
Today Views:
1 Total Views:
554
MySQL is currently the most popular open source database server in existence. On top of that, it is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications.
March 18,
2010
Today Views:
11 Total Views:
549
John Paul Ashenfelter looks at a specific class of SQL functions that operate on entire columns of data instead of discrete values -- the aggregate functions.
March 18,
2010
Today Views:
1 Total Views:
399
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, Access will work just fine.
March 15,
2010
Today Views:
2 Total Views:
821
A beginner tutorial demonstrating a simple form to update administrator privileges for a set of users using checkboxes.
March 12,
2010
Today Views:
3 Total Views:
250
John Paul Ashenfelter looks at how keys are used to construct relationships between tables in a relational database.
March 9,
2010
Today Views:
4 Total Views:
609
You have a web site with pages accessing a database. You want to use PHPLIB, but do not want to change your existing database to suit. Here is the answer to your dreams. PHPLIB and multiple databases.
March 9,
2010
Today Views:
1 Total Views:
691
Suppose you need to calculate constantly-changing information based on constantly-updated information in one or more tables. Are you stuck doing everything in multiple expensive queries? By no means.
March 5,
2010
Today Views:
1 Total Views:
537
Developing web applications using a static data store where data must be updated, stored and manipulated frequently can be a cumbersome task. However this article will introduce you to the world of relational databases allowing you to maximise your data's potential.
March 4,
2010
Today Views:
1 Total Views:
265
Microsoft's SQL Server takes a little different approach to working with dates.
March 3,
2010
Today Views:
4 Total Views:
2,120
