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
Database of 100 countries
Moderator: General Moderators
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: Database of 100 countries
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.
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)