newbie help required plz

hasnain721 · May 3rd, 2006, 05:59 PM

Hello there,
Iam a webmaster.
I started everything from scratch and made my website on my own research. All thanks to the internet.
Now i have decided to implimend a database in my website.
Can any one help me some tips getting started.
-Like which software to use to write the database.
-How to link it up to a server.
E.g.
If i have a travel agent website.
When my customers want to check a flight, they should be able to access my database which would be connected to British Airways's database and shows the customers the latest deals.

Would appreciate a reply.
Thank You

sypher · May 3rd, 2006, 07:15 PM

Are british airways going to give you access to their database?

craig · May 3rd, 2006, 07:28 PM

hasnain721 · May 4th, 2006, 11:16 AM

Well,
I just gave u an example.
Can u help me plz ?

sypher · May 4th, 2006, 11:40 AM

PHP/mySQL

Code:


			
@$link = mysql_pconnect('localhost', 'username', 'password');
if (!$link) {
   die('Not connected : ' . mysql_error());
}

// make nexus the current db
@$db_selected = mysql_select_db('database_name', $link);
if (!$db_selected) {
   die ('Can\'t use database : ' . mysql_error());
}

You change the above details to fit your own myql database which is situated on your host.

You can now do commands to mysql via php such as fetching records to display etc.

hasnain721 · May 4th, 2006, 11:46 AM

Suppose iam designing a database for a music store .
How do start ?
Do i use the code which u just gave me ?

sypher · May 4th, 2006, 12:25 PM

Do you know the basics of web design?

hasnain721 · May 4th, 2006, 03:12 PM

yea and i know quite a lot about access databases.
But i have no idea about web based databases.

sypher · May 4th, 2006, 04:06 PM

Ok you need to learn php/mysql.

Basically they go hand in hand. mySQL is a database format like Access but its for online.
PHP is used to interact with the database in order to add, edit, delete and show records.

http://www.freewebmasterhelp.com/tutorials/phpmysql

hasnain721 · May 5th, 2006, 11:16 AM

Thanks a million 4 helping me mate.
And 1 more thing.
I have a complete database for a video hiring company.
I made that in access 2003.
How do i convert it to sql?

sypher · May 5th, 2006, 02:43 PM

Hmm never tried it, but try the import functions in phpmyadmin.

ukgeoff · May 5th, 2006, 05:29 PM

Quote:

Originally Posted by hasnain721

Thanks a million 4 helping me mate.
And 1 more thing.
I have a complete database for a video hiring company.
I made that in access 2003.
How do i convert it to sql?

You don't covert to SQL. SQL is what it is, a Structured Query Language. Not a database system.

You can use SQL on Access.

Depending on what software tools you can get hold of or are pepaired to buy you can do a data transfer from one to the other.

If you have a tool that will let you dump the data along with the SQL for setting up the table, then you can just run that under MySQL and job done.

A more long winded way would be to set-up your database structure in MySQL, dump the data from Access as a CSV file, then upload the CSV file into MySQl.

Lots of fun.

hasnain721 · May 5th, 2006, 06:32 PM

Ok
but how do i get a CSV file from my access database ?

ukgeoff · May 8th, 2006, 09:41 AM

Quote:

Originally Posted by hasnain721

Ok
but how do i get a CSV file from my access database ?

Suggest you read the help files or get an Access manual.

iZone · May 10th, 2006, 07:04 AM

Look under File > Export. Then choose Text File under the file types. For the rest you'll want to look in the help like geoff suggests.