Todayโs tutorial follows up on phpMyAdmin interface to MySql and PHP Primer Tutorial in that we again use the brilliant phpMyAdmin to use MySql calls to create several tables and show that you can build a Linux or Unix based file system method of using some RDBMS techniques to do with joining tables on a Linux command line to give a similar result to using MySql RDBMS on a database. Why should that be interesting? Well, to my mind, you donโt need to have a database, necessarily, for every data-based job you do, because, letโs face it, as good as the databases of today are, they use quite a bit of memory. This is just some food for thought โฆ am thinking ???. Some cases in point at this domain here at www.rjmprogramming.com.au are:
So, for todayโs tutorial we make use of the Linux (or Unix) command join. Integration of such ideas into PHP would get you into the world of fopen and fread and fwrite and fclose and exec and system and more.
Here is some downloadable Linux (Mac Terminal) shell programming source code LinuxJoin_MySql_Primer as required.
Here is some downloadable input SQL used to create and populate the MySql tables file1_file2_file3sql, address_stats
sql as required.
Here are some downloadable input data files used at Linux file1,file2, file3, address, stats as required.
Previous phpMyAdmin interface to MySql and PHP Primer Tutorial is relevant and shown below.
Transcript:
You never hear much about the data when you hear about great PHP products, but we
all know it is the data that differentiates the quality of the end result.
That is probably because database products like MySql, SqlServer, Oracle SQL, Advantage and Access
are pretty good at what they do, and emphasise reliability rather than flashiness.
MySql and PHP have a great open source interface with phpMyAdmin, which is so good,
you forget that it is not the default MySql administratorโs interface product.
Letโs have a look at this WordPress database and a bit of how it looks, looking
through the prism of phpMyAdmin โฆ
If this was interesting you may be interested in this too.
If this was interesting you may be interested in this too.