too long

Question

This question is an exact duplicate of:

• Regex with div classes 1 answer

I need to remove the div and td tags in order to extract out the content between to insert into database. However to some constraints I have to use regex and not xpath or DOM Document to extract out the content. Need help! Thanks

 <tr class = "student_information" >
            <div class="admin"><td>141234U</td></div>
            <div class="name"><td>Tan Ping Ping</td></div>
            <div class="hp"><td>82222222</td></div>
            <div class="email"><td>[e-mail]</td></div>
        </tr>
                    <tr class = "student_information" >
            <div class="admin"><td>132458Q</td></div>
            <div class="name"><td>Tan Rui</td></div>
            <div class="hp"><td>86339557</td></div>
            <div class="email"><td>[e-mail]</td></div>

 Output: 

 141234U
 Tan Ping Ping
 82222222
 [e-mail]

 132458Q
 Tan Rui
 86339557
 [e-mail]

</div>

Answer 1

However to some constraints I have to use regex and not xpath or DOM Document to extract out the content

Based on the above, you can use this regex: (?<=>)([\w .@]+)(?=<), i.e.:

$str = <<< EOF
 <tr class = "student_information" >
            <div class="admin"><td>141234U</td></div>
            <div class="name"><td>Tan Ping Ping</td></div>
            <div class="hp"><td>82222222</td></div>
            <div class="email"><td>[e-mail]</td></div>
        </tr>
                    <tr class = "student_information" >
            <div class="admin"><td>132458Q</td></div>
            <div class="name"><td>Tan Rui</td></div>
            <div class="hp"><td>86339557</td></div>
            <div class="email"><td>[e-mail]</td></div>
EOF;

preg_match_all('/(?<=>)([\w .@]+)(?=<)/', $str, $result, PREG_PATTERN_ORDER);
foreach($result[1] as $match){
echo $match."
";
}

---

Output:

141234U
Tan Ping Ping
82222222
[e-mail]
132458Q
Tan Rui
86339557
[e-mail]

---

Regex Explanation:

(?<=>)([\w.@]+)(?=<)

Assert that the regex below can be matched, with the match ending at this position (positive lookbehind) «(?<=>)»
   Match the character “>” literally «>»
Match the regex below and capture its match into backreference number 1 «([\w.@]+)»
   Match a single character present in the list below «[\w.@]+»
      Between one and unlimited times, as many times as possible, giving back as needed (greedy) «+»
      A “word character” (Unicode; any letter or ideograph, any number, underscore) «\w»
      A single character from the list “.@” «.@»
Assert that the regex below can be matched, starting at this position (positive lookahead) «(?=<)»
   Match the character “<” literally «<»