Tilted Forum Project Discussion Community - View Single Post - Best way to set this up? PHP/MYsql? XML? ...

Realizm · 03-02-2004, 07:24 PM

I'm trying to figure out what method I should use for storing my information (and subsequently being able to bring it up, later) I'm going to describe my situation for you to see what you think... Here's how it is:

There's 4 of us right now, we all test the same products and need to write down certain info about each of them, general info regarding diffrent types (printer, computer, monitor).

Currently I am working on setting up some PHP pages that will write to a MYSQL database containing columns for each of the things of info our test pages need to insert. (serial number, model number, tester name for example)

Since different products have different test pages, I'm thinking I will make a seperate mysql table for each type of product, so like 3 tables (computers, printers, monitors). The page we testers will see will have an option for which of these items we are writing info down (pull down menu for monitor computer or printer) and then bring up a form for the appropriate item.

--

So, does this sound like an ok way of doing things? Writing all the information to their appropriate tables?

I'm kind of new to mysql and the concept of databases but this seemed appropriate at the time. NOW, though I've been doing a little reading about XML and am wondering if there is some way I should be using this instead?

I have yet to figure out how XML and Mysql (or any database) for that matter can work together, though I know it's got to be something really simple..

Like instead of writing to a mysql database, should I just store my info in XML files? For instance, should I make a php page that would write the text

<Tester name="Jim">
<item>HP 4200</item>
<serial>3424</serial>
</Tester> ?

into an XML file? One big thing I've yet to grasp is how an XML file gets its data. Whether forms write somethign similar to what I just made above to a .xml file or what..

I just absolutely can not comprehend how to use XML except I think MAYBE I should be using this instead of Mysql. I guess the obvious answer is "if you don't get it, you don't need it" but I would really like to get it so I could more understand why I do or don't need it. This has been a lengthy post, so thanks for your patience and answer if you read through this all..

03-02-2004, 07:24 PM	#1 (permalink)
Realizm Insane Location: A fuzzy cloud.	Best way to set this up? PHP/MYsql? XML? ... I'm trying to figure out what method I should use for storing my information (and subsequently being able to bring it up, later) I'm going to describe my situation for you to see what you think... Here's how it is: There's 4 of us right now, we all test the same products and need to write down certain info about each of them, general info regarding diffrent types (printer, computer, monitor). Currently I am working on setting up some PHP pages that will write to a MYSQL database containing columns for each of the things of info our test pages need to insert. (serial number, model number, tester name for example) Since different products have different test pages, I'm thinking I will make a seperate mysql table for each type of product, so like 3 tables (computers, printers, monitors). The page we testers will see will have an option for which of these items we are writing info down (pull down menu for monitor computer or printer) and then bring up a form for the appropriate item. -- So, does this sound like an ok way of doing things? Writing all the information to their appropriate tables? I'm kind of new to mysql and the concept of databases but this seemed appropriate at the time. NOW, though I've been doing a little reading about XML and am wondering if there is some way I should be using this instead? I have yet to figure out how XML and Mysql (or any database) for that matter can work together, though I know it's got to be something really simple.. Like instead of writing to a mysql database, should I just store my info in XML files? For instance, should I make a php page that would write the text <Tester name="Jim"> <item>HP 4200</item> <serial>3424</serial> </Tester> ? into an XML file? One big thing I've yet to grasp is how an XML file gets its data. Whether forms write somethign similar to what I just made above to a .xml file or what.. I just absolutely can not comprehend how to use XML except I think MAYBE I should be using this instead of Mysql. I guess the obvious answer is "if you don't get it, you don't need it" but I would really like to get it so I could more understand why I do or don't need it. This has been a lengthy post, so thanks for your patience and answer if you read through this all..