Advertisement

03.30.2007 at 11:19AM PDT, ID: 22483476
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.8

Uploading and parsing formatted text via PHP, populating a MySQL database

Asked by bwsycom in PHP Scripting Language, PHP and Databases, MySQL Server

Tags: , ,

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
Ruler:      Napolean
 Last Donation:      No donations on record.
Last Activity:      3/30/2007 9:41:31 AM
National Flag:       
 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)
 Technology:       4.68
 Infrastructure:      68.11
 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.
 My Resources:       
Connected Resources:       
 Bonus Resources:      None
 Improvements:      No improvements purchased.
 National Wonders:       No national wonders.
 Environment:       7.00
Senate Votes:      0 Votes
_:. Military Information
Nation Rank:      Ranked #30,157 of 37,981 total nations
 Nation Strength:      373.618
 Efficiency:      10.38
 DEFCON Level:       
 Number of Soldiers:      656
       Deployed Soldiers:
      0
       Defending Soldiers:
      656  
 Number of Tanks:      0
       Deployed Tanks:
      0
       Defending Tanks:
      0
 Aircraft:      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.
       Military Personnel:
       Citizens:
      656 Soldiers
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. Start Free Trial
[+][-]03.30.2007 at 01:36PM PDT, ID: 18826358

View this solution now by starting your 14-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: PHP Scripting Language, PHP and Databases, MySQL Server
Tags: eastern, focuses, middle
Sign Up Now!
Solution Provided By: JakobA
Participating Experts: 2
Solution Grade: A
 
 
[+][-]05.21.2007 at 07:31AM PDT, ID: 19127132

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 14-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]06.02.2008 at 05:52AM PDT, ID: 21691486

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 14-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]06.08.2008 at 06:33PM PDT, ID: 21740301

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 14-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-43