Welcome to RCF - WHF

Glenn I · Apr 22, 2005

I'm interested in putting an aircraft registration function on my site like this - http://www.casa.gov.au/casadata/regsearch/findairs.asp

You just enter a plane's registration (see the box under "quick search" in a box and the page opens a new window displaying all the relevant info on a plane such as owner etc...

This site has been running pretty slow lately and it takes too long to search for aircraft. You can download the entire register at http://www.casa.gov.au/casadata/register/datafiles.asp but it's in CSV and you'd need to be able to set up some kind of a database to display the results. Other web sites have this too and I might even extend it to international databases later on.

Does anyone know of where I can get some information to aid in this?

Nightrider · Sep 25, 2004

I took the CSV file, saved it in dbf format, then Imported it to my Test database, then Exported it in SQL format so that you can now Import it into any database that you want...

ACRFTREG.sql.zip

headbang

Glenn I · Apr 22, 2005

Ok thanks. So now what do I do? Ohh and this file gets updated regularly too so I need a quick simple way to add the updates Smile

Nightrider · Sep 25, 2004

There is no easy way that I know of to import a CSV file to a database without writing a utility to do it. I know there is a MOD in the phpBB MOD Database that allows you to import and/or export Users via a CSV file. It might be possible to modify it to work with this CSV file if it indeed has the ability to import into the phpBB table...

The first thing you do is import this SQL file into your database using phpMyAdmin. Then you have to decide what you want to do with the data...

munky2

Glenn I · Apr 22, 2005

I just created a database and imported the file. Was I supposed to import it the the phpbb database?

With the data I want to set it up like this site http://www.rwy34.com/regsearch/

Enter a 3 letter code such as KSN and see how it displays the results

Nightrider · Sep 25, 2004

If this utility is going to be tied into your phpBB board, then the table should be imported into your Live forum database. If you want to keep them completely separate, then you can use a separate database. It probably would be easier to use the phpBB database functionality though in order to access the table, so it might be better if it was imported into the phpBB database...

If there isn't already a utility created for this, you can use the Template MOD that you have installed on your site to create a template that looks like the page from your link. Then you will want to add the SQL functionality to make the page dynamic/interactive...

headbang

Glenn I · Apr 22, 2005

Ahh ok

I have the blank page template so all I do is set it up using html ie. the titles and fields etc... So how do I get the info from the file to display in the page? If that makes sense

eg.. Aircraft Type - (get this info from the databse to display here)

Nightrider · Sep 25, 2004

You would have to decide what you want to present based on the available data, then design a page for the results. The SQL queries would take the input, then search the table and load the output variables that will be used in the output page. The whole process would work very much like all of our forum pages work...

It's way past my bed time, so I'm going to call it a night. We can deal with this more tomorrow...

headbang

Glenn I · Apr 22, 2005

Ok thanks. I'll leave it for now too. Time to go watch a movie occasion9