Hello I need to do a form that writes to a database I know how to do that What I dont now how to do is how I dump my data from the db as XML
I want the data to come out like this on the xml
<jobs>
<job id="5575757" title="Teacher" company="Mesa Public Schools" location="Mesa, AZ" />
<job id="8585858" title="Teacher" company="Tempe Public Schools" location="New York, NY" />
</jobs>
Any Ideas Thank you
Use concatenate . and escaping \ operators like:
echo "<job id=\"". $result['id'] ."\" title=\"". $result['title'] ."\" company=\"". $result['company'] ."\" location=\"". $result['location'] ."\" />";In this way we have the result in xml syntax.
Use concatenate . and escaping \ operators like:
echo "<job id=\"". $result['id'] ."\" title=\"". $result['title'] ."\" company=\"". $result['company'] ."\" location=\"". $result['location'] ."\" />";In this way we have the result in xml syntax.
Ok but I will create a table call jobs right and the fields will be
Job_id
Title
Company
Location
Am I right?
Thank you
Yes, more difficult is to put xml data to db. Depending on your PHP version, if it is 5 you can use built-in SimpleXML functions, or in case if it is PHP4 you will need a class to parse xml to an array. Both cases will provide to you access to element attributes in a variable to put afterwards in db.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.