Uploading and parsing formatted text via PHP, populating a MySQL database
Posted on 2007-03-30
I'd like to create a field on a website that people could cut & paste information into. Then have a PHP script handle the upload and throw the information into a database. The data will ALWAYS be in this format:
_:. Government Information
Nation Name: Tealopolis
Last Donation: No donations on record.
Last Activity: 3/30/2007 9:41:31 AM
Alliance Affiliation: none
About Shaka Khan: Ixnay Broheim Laborious
Government Type: Anarchy (Next Available Change 4/2/2007)
Your people approve of this form of government but the majority of your people would prefer something else. They desire a government that is based on radical change.
National Religion: Mixed (Next Available Change 3/25/2007)
Your people approve of this national religion but the majority of your people would prefer something else. They desire a modern middle eastern religion that focuses on monotheism.
Nation Team: - Black - Team Information Panel
Nation Created: 2/22/2007 4:43:25 PM (36 days old)
Tax Rate: 28% (This high tax rate angers your citizens.)
Area of Influence: 32.533 mile diameter.
14.381 from purchases/sales/gains, 18.152 from natural growth.
War/Peace Preference: War is an option for Shaka Khan.
Bonus Resources: None
Improvements: No improvements purchased.
National Wonders: No national wonders.
Senate Votes: 0 Votes
_:. Military Information
Nation Rank: Ranked #30,157 of 37,981 total nations
Nation Strength: 373.618
Number of Soldiers: 656
Number of Tanks: 0
Number of Cruise Missiles: 0
Number of Nuclear Weapons: 0
Number of Soldiers Lost in All Wars. 127 Attacking + 2,246 Defending = 2,373 Casualties
_:. Population Information
Total Population: 1,368 Supporters
Primary Ethnic Group: Somali
Population Happiness: -10.30
Population Per Mile: 42.05 Population Per Mile.
712 Working Citizens
Avg. Gross Income Per Individual Per Day: $13.94 (A very weak economy)
Avg. Individual Income Taxes Paid Per Day $3.90
Avg. Net Daily Population Income (After Taxes) $10.04
_:. Government Financial
Current Dollars Available: $2,731.23 (Surplus)
Yes, its for an online game :) I've played similiar games and some people have created websites where you paste the source from the page into an upload box, and then the website handles that information and makes it searchable (security?). I'm creating an alliance CMS system for this particular game, and need to be able to use this information in a MySQL database. I'm relatively new to PHP & MySQL, but eager to learn.