Online PHP editor | output for bC3Lf

@ 2019-08-23T04:25:14Z

<?php
$submit_input = array(
  "PhysicalAddress:E8-6A-64-DE-48-60PhysicalAddress:04-EA-56-08-E6-8EPhysicalAddress:04-EA-56-08-E6-8FPhysicalAddress:06-EA-56-08-E6-8EPhysicalAddress:04-EA-56-08-E6-92",
  "PhysicalAddress:04-EA-56-08-E6-92PhysicalAddress:E8-6A-64-DE-48-60PhysicalAddress:04-EA-56-08-E6-8EPhysicalAddress:04-EA-56-08-E6-8FPhysicalAddress:06-EA-56-08-E6-8E",
  "PhysicalAddress:06-EA-56-08-E6-8EPhysicalAddress:E8-6A-64-DE-48-60PhysicalAddress:04-EA-56-08-E6-8EPhysicalAddress:04-EA-56-08-E6-8FPhysicalAddress:04-EA-56-08-E6-92",
  "PhysicalAddress:04-EA-56-08-E6-8FPhysicalAddress:E8-6A-64-DE-48-60PhysicalAddress:04-EA-56-08-E6-8EPhysicalAddress:06-EA-56-08-E6-8EPhysicalAddress:04-EA-56-08-E6-92",
  "PhysicalAddress:04-EA-56-08-E6-8EPhysicalAddress:E8-6A-64-DE-48-60PhysicalAddress:04-EA-56-08-E6-8FPhysicalAddress:06-EA-56-08-E6-8EPhysicalAddress:04-EA-56-08-E6-92",     
);
    
foreach($submit_input as $k=>$v) {
  $components = explode("PhysicalAddress:", $submit_input[$k]);
  $main_value = implode("%'\n  AND preview LIKE '%", array_filter($components) );
  $query = "SELECT * FROM table1 WHERE preview LIKE '%" . $main_value . "%'";
 
  echo $query;
  
}

exit;

Output for 7.1.25 - 7.1.31, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.34, 8.2.0 - 8.2.30, 8.3.0 - 8.3.30, 8.4.1 - 8.4.18, 8.5.0 - 8.5.3: SELECT * FROM table1 WHERE preview LIKE '%E8-6A-64-DE-48-60%' AND preview LIKE '%04-EA-56-08-E6-8E%' AND preview LIKE '%04-EA-56-08-E6-8F%' AND preview LIKE '%06-EA-56-08-E6-8E%' AND preview LIKE '%04-EA-56-08-E6-92%'SELECT * FROM table1 WHERE preview LIKE '%04-EA-56-08-E6-92%' AND preview LIKE '%E8-6A-64-DE-48-60%' AND preview LIKE '%04-EA-56-08-E6-8E%' AND preview LIKE '%04-EA-56-08-E6-8F%' AND preview LIKE '%06-EA-56-08-E6-8E%'SELECT * FROM table1 WHERE preview LIKE '%06-EA-56-08-E6-8E%' AND preview LIKE '%E8-6A-64-DE-48-60%' AND preview LIKE '%04-EA-56-08-E6-8E%' AND preview LIKE '%04-EA-56-08-E6-8F%' AND preview LIKE '%04-EA-56-08-E6-92%'SELECT * FROM table1 WHERE preview LIKE '%04-EA-56-08-E6-8F%' AND preview LIKE '%E8-6A-64-DE-48-60%' AND preview LIKE '%04-EA-56-08-E6-8E%' AND preview LIKE '%06-EA-56-08-E6-8E%' AND preview LIKE '%04-EA-56-08-E6-92%'SELECT * FROM table1 WHERE preview LIKE '%04-EA-56-08-E6-8E%' AND preview LIKE '%E8-6A-64-DE-48-60%' AND preview LIKE '%04-EA-56-08-E6-8F%' AND preview LIKE '%06-EA-56-08-E6-8E%' AND preview LIKE '%04-EA-56-08-E6-92%'

preferences:dark modelive previewkey bindings