Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Please see my example code below on how to accomplish this.</p> <pre><code>&lt;?php $xml = &lt;&lt;&lt;XML &lt;videos&gt; &lt;video&gt; &lt;id&gt;1&lt;/id&gt; &lt;enSub&gt;Hello Foo! Good morning!&lt;/enSub&gt; &lt;cnSub&gt;你好 Foo! 早上好！&lt;/cnSub&gt; &lt;/video&gt; &lt;video&gt; &lt;id&gt;2&lt;/id&gt; &lt;enSub&gt;Hello Bar! Good afternoon!&lt;/enSub&gt; &lt;cnSub&gt;你好 Bar! 下午好！&lt;/cnSub&gt; &lt;/video&gt; &lt;/videos&gt; XML; // Lowercase the XML so we can do a non-case-sensitive search. $xml = strtolower($xml); // Create a DOMDocument based on the xml. $dom = new DOMDocument; $dom-&gt;loadXML($xml); // Create an xpath based on the dom document so we can search it. $xpath = new DOMXpath($dom); // Search for any video tag that contains the text good morning. $nodes = $xpath-&gt;query('//video[contains(.,\'good morning\')]'); // Iterate all nodes foreach($nodes as $node){ // find the ID node and print its content. var_dump($xpath-&gt;query('id',$node)-&gt;item(0)-&gt;textContent); } </code></pre> <p>-- Edit</p> <p>I reread your post and it looks like you're using keywords and not strings. If that's the case, then try this snippet on for size:</p> <pre><code>&lt;?php $xml = &lt;&lt;&lt;XML &lt;videos&gt; &lt;video&gt; &lt;id&gt;1&lt;/id&gt; &lt;enSub&gt;Hello Foo! Good morning!&lt;/enSub&gt; &lt;cnSub&gt;你好 Foo! 早上好！&lt;/cnSub&gt; &lt;/video&gt; &lt;video&gt; &lt;id&gt;2&lt;/id&gt; &lt;enSub&gt;Hello Bar! Good afternoon!&lt;/enSub&gt; &lt;cnSub&gt;你好 Bar! 下午好！&lt;/cnSub&gt; &lt;/video&gt; &lt;/videos&gt; XML; // Lowercase the XML so we can do a non-case-sensitive search. $xml = strtolower($xml); // Create an DOMDocument based on the xml. $dom = new DOMDocument; $dom-&gt;loadXML($xml); // Create an xpath based on the dom document so we can search it. $xpath = new DOMXpath($dom); // Define the search keywords $searchKeywords = array('good','hello'); // Iterate all of them to make them into valid xpath $searchKeywords = array_map( function($keyword){ // Replace any single quotes with an escaped single quote. $keyword = str_replace('\'','\\\'',$keyword); return 'contains(.,\''.$keyword.'\')'; }, $searchKeywords ); // Implode all the keywords using and, you could change this to be // an"or" condition if you so desire. $searchKeywords = implode(' and ',$searchKeywords); // The search keywords now look like contains(.,'good') and contains(.,'hello') // Search for any video tag that contains the text good morning. $nodes = $xpath-&gt;query('//video['.$searchKeywords.']'); // Iterate all nodes foreach($nodes as $node){ // find the ID node and print its content. var_dump($xpath-&gt;query('id',$node)-&gt;item(0)-&gt;textContent); } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow can I use php to search multiple key words in xml file and return the containing tag?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USKyle
    1. USKyle
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow can I use php to search multiple key words in xml file and return the containing tag?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COHi @Kyle! thanks so so much! I tested your code in php sandbox. It works really well! I took an hour to study some functions unknown to me. Thanks! can I ask how this function will affect the performance of my php hosting server? Say I have 1000 users and 1000 <video>s, and they search by this function. Will it make my server really slow? I totally have no idea about performance. maybe I underestimate my hosting php server? Thanks!
      singulars
      1. PO
      1. USLuke Chen
    2. COhello @Kyle! Would you please teach me what does the dot, '.', in the contrains() function mean? I looked up the manual, should it be a str that contains a keyword?
      singulars
      1. PO
      1. USLuke Chen
    3. COAnother question is that I load an xml file. How can I lowercase the whole xml file? Should I first load the xml and then $dom->saveXML($dom)? Thanks!!
      singulars
      1. PO
      1. USLuke Chen
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload