How to select ID by changing xml file with PHP

[RRO]

Hello,

I’m trying to change an XML file by PHP.

It’s working but I can’t find how I can select the specific ID. any ideas?

For example, I would like to change the text of <data>    <SText id="p1">

Thanks in advance!

 

 

PHP:

<form method="post">
  <input name="ken1" id="ken1" type="text">
  <br>
  <input type="submit" name="submit" value="submit">
</form>

<?php

if(isset($_POST['submit'])) {

$data=simplexml_load_file('display.xml');
$data->data->SText->ken1->text=$_POST['ken1'];

$handle=fopen("display.xml","wb");
fwrite($handle,$data->asXML());
fclose($handle);
}

$data=simplexml_load_file('display.xml');
?>

 

XML file:

<kendisplay>

  <meta>
    <request>setData</request>
    <version>1</version>
  </meta>
  <data>
    <SText id="p1">
      <text>test</text>
    </SText>
    <SText id="p2">
      <text>test</text>
    </SText>
    <SText id="ken1">
      <text>test</text>
    </SText>
    <SText id="wait">
      <text>test</text>
    </SText>
  </data>

</kedisplay>

 

[requinix]

Use ->xpath to go directly to the right <text>.

/kendisplay/data/SText[@id="ken1"]/text

Keep in mind that XPath queries are like SQL and HTML: if you put user-provided data into them (like if "ken1" came from the form instead of your own fingers) then it needs to be escaped first, such as with

sprintf('/kendisplay/data/SText[@id="%s"]/text', htmlspecialchars($id))

 

[RRO]

Thanks for your reply. However, I'm not getting this implemented properly yet.

How can I best include this in my code?

[requinix]

What code have you tried so far and what happened when you used it?

[RRO]

I tried your suggestion but got a syntax error:

Quote

Parse error: syntax error, unexpected '=', expecting ']' in

And have searched for php xpath xml but don't know what to use.

[dodgeitorelse3]

Always show your current code. Much easier to find syntax errors as well as any other mistakes possibly entered as code.

[Barand]

14 minutes ago, RRO said:

And have searched for php xpath xml but don't know what to use.

https://www.php.net/manual/en/simplexmlelement.xpath.php

[RRO]

11 hours ago, dodgeitorelse3 said:

Always show your current code. Much easier to find syntax errors as well as any other mistakes possibly entered as code.

 

15 hours ago, RRO said:

PHP:

<form method="post">
  <input name="ken1" id="ken1" type="text">
  <br>
  <input type="submit" name="submit" value="submit">
</form>

<?php

if(isset($_POST['submit'])) {

$data=simplexml_load_file('display.xml');
$data->data->SText->ken1->text=$_POST['ken1'];

$handle=fopen("display.xml","wb");
fwrite($handle,$data->asXML());
fclose($handle);
}

$data=simplexml_load_file('display.xml');
?>

 

XML file:

<kendisplay>

  <meta>
    <request>setData</request>
    <version>1</version>
  </meta>
  <data>
    <SText id="p1">
      <text>test</text>
    </SText>
    <SText id="p2">
      <text>test</text>
    </SText>
    <SText id="ken1">
      <text>test</text>
    </SText>
    <SText id="wait">
      <text>test</text>
    </SText>
  </data>

</kedisplay>

 

Also tried:

$data/kendisplay/data/SText[@id="ken1"]/text=$_POST['ken1'];

Here I get a syntax error.

 

[Barand]

Conspicuously absent is any attempt to use xpath as you were advised. Obviously spoonfeeding is required. Here's my version  (slightly different from Requinix's, but not much)

$xmlstr = <<<XML

<kendisplay>

  <meta>
    <request>setData</request>
    <version>1</version>
  </meta>
  <data>
    <SText id="p1">
      <text>test</text>
    </SText>
    <SText id="p2">
      <text>test</text>
    </SText>
    <SText id="ken1">
      <text>test</text>
    </SText>
    <SText id="wait">
      <text>test</text>
    </SText>
  </data>

</kendisplay>
XML;

$target_id = 'ken1';
$newtext = 'Updated';

$xml = simplexml_load_string($xmlstr);
$path = sprintf("//SText[@id='%s']", htmlspecialchars($target_id) );
$ken = $xml->xpath($path);                                            // find the SText
$ken[0]->text = htmlspecialchars($newtext);                           // update its text

$xml->asXML('test.xml');                                              // output updated xml file

test.xml output ...

<?xml version="1.0"?>
<kendisplay>

  <meta>
    <request>setData</request>
    <version>1</version>
  </meta>
  <data>
    <SText id="p1">
      <text>test</text>
    </SText>
    <SText id="p2">
      <text>test</text>
    </SText>
    <SText id="ken1">
      <text>Updated</text>
    </SText>
    <SText id="wait">
      <text>test</text>
    </SText>
  </data>

</kendisplay>