Solved

Which method is better to read custom data?

Posted on 2011-09-07
5
234 Views
Last Modified: 2012-05-12
Hello everybody,

I've been asked to make a pretty simple website with only one page and a list of items being sold. The list has to be separated in cathegories and needs to be very simple to update by hand but I don't have more than 3 days to make it so I can't make a control panel or something fancy. I need the user to be able to fill up a file (txt file, excel or something like that) and upload it to the server so the site is automatically updated.

What would be the best way to go? XML seems a little too complicated for a non-technical person to fill every other day and I really don't know how to make "sub-cathegories" in a text file  so each group of items are displayed under their corresponding cathegory.

In example, I would need something like the following:

- Beans
-- Rice     $0.99
-- Oat     $1.29
-- Weat     $1.19

- Meat
-- Pork     $2.99
-- Cow     $2.59
-- Chicken     $1.99

Open in new window


Thanks in advance!
0
Comment
Question by:Caracena
5 Comments
 
LVL 82

Accepted Solution

by:
Dave Baldwin earned 500 total points
Comment Utility
Have them do it in Excel and export it as CSV.  That's probably the simplest text format you could do quickly.
0
 
LVL 2

Expert Comment

by:shdwmage
Comment Utility
well in HTML code your list would look something like this:

<li>Products
<ul>Beans
<li>Rice $0.99</li>
<li>Oat  $1.29</li>
<li>Weat $1.19</li>
</ul></li>
<li>Meat<ul>
<li>Pork $2.99</li>
<li>Cow $2.59</li>
<li>Chicken $1.99</li>
</ul></li>
</ul> 

Open in new window


That code will show bullets with sub-bullets for the lower categories.  Quickest, dirtiest way to do it.

I would spend the time to write the administration section and just put it in a database and have the data formatted by the php.

Additionally there is another cheap dirty way to do this (again not my cup of tea), setup a text file like the following:
$beans = array("rice $0.99","oat $1.20","Weat $1.19");
$meat = array("pork 2.99","cow $2.59","chicken $1.99");

and then in the php file do the following
echo "<ul><li>Beans<ul>";
foreach ($beans as $value) {
    echo "<li> $value</li>\n";
}
echo "</li></ul>";
echo "<ul><li>Meats";
foreach ($meat as $value) {
    echo "<li> $value</li>\n";
}
echo "</li></ul>"

Open in new window


Other than that I don't know any quick easy ways to get around it.
0
 
LVL 2

Expert Comment

by:shdwmage
Comment Utility
I'd like to note I don't encourage the use of the above as it is a bad coding practice in my opinion and I would only ever use it as a testing purpose.
0
 
LVL 6

Author Closing Comment

by:Caracena
Comment Utility
Thanks to both of you. DaveBaldwin's answer was much straight to the point. Althought the second answer was more complex, it would be something harder for the user to fill.

Thanks again!
0
 
LVL 82

Expert Comment

by:hielo
Comment Utility
my suggestion would be to use an ini file and then use parse_ini_file() function:
http://php.net/manual/en/function.parse-ini-file.php

;Here's your sample products.ini file
;Do not include the dollar sign for the prices.
;Also keep one item per line
[Grains]
Rice=0.99
Oat=1.29
Wheat=1.19

[Meat]
Pork=2.99
Cow=2.59
Chicken=1.99



<?php
//sample php
$items = parse_ini_file('/path/to/your/products.ini', true);
echo $items['Grains']['Oat'];
?>

Open in new window

0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now