Database of 100 countries

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
jamhussain
Forum Newbie
Posts: 17
Joined: Sat Apr 07, 2012 2:04 am

Database of 100 countries

Post by jamhussain »

Aslam o alaikum,
Please guide me.
I have sheet with these columns

country country code inflows(Million) Year

Countries are 100
Each country has its code.
with respect to country there is inflows in million
Year :from 2001 to 2010
How can I make the database and table in Mysql. I m using php
so that I may select the country and year in the HTML Form then Post the values of Inflows(million) and then I may update Inflows
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Database of 100 countries

Post by Christopher »

First you need to define the database schema that contains the fields above and any others you want. Then import the data into the database. You can use tab-delimited or generate INSERT statements in you spreadsheet.

Once that it does you will need a page to browse and search for records to edit and a page to edit a record. Search for "CRUD" for more information on that.
(#10850)
Post Reply