I am after a solution in order to be able to modify/edit XML nodes/sections via a PHP form.
The form would have several text boxes and when filled in/submitted, it would REPLACE a certain value in the XML.
The XML is initially extracted from a SQL Database table where it is stored as a blob I assume...
The XML itself is actually a Cognos report and I need maximum/minimum values changes on a Gauge chart. Annoyingly, this is a cognos limitation whereby it cannot be linked to a value in a database table and so I need to modify this 24 times a day everyday manually.
What I want is to create a form which is tied to these maximum/minimum values so that it is easy to enter in a textbox and the report gets modified accordingly.
Once the submit is hit, I can then "update" the database table with the complete XML with the modifications that the form did.
I hope this makes sense!
Please see in the code section the type of XML it would be tied to
The solution would have to be to edit the value in <gaugeNumericalAxis max="8962"> (in this case 8692)
Then for Dial 2, it would be the same but for refQuery="Query2
showTooltips="true" maxHotspots="10000" refQuery="Query1" name="Gauge Chart1">