PHP字符串排序 - php string sorting

php string sorting

本文关键字：排序字符串 PHP | 更新日期: 2023-09-26

我在mysql数据库中有一个字符串，包含字符，并想做下一步:

$string = "actor1 as aaa, actor2 as bbb, actor3 as ccc";
for (do a loop for 0 to length of the $string) {
   echo actor1
   echo aaa
}

每次循环输出

actor1
aaa
actor2
bbb
actor3
ccc

如何在PHP中做到这一点?

Try with:

$string = "actor1 as aaa, actor2 as bbb, actor3 as ccc";
$groups = explode(',', $string);
foreach ( $groups as $group ) {
  $items = explode(' as ', trim($group));
  foreach ( $items as $item ) {
    echo $item . '<br/>';
  }
  echo '<br/>';
}

或改进后没有第二个循环:

foreach ( $groups as $group ) {
  list($actor, $role) = explode(' as ', trim($group))
  echo $actor . '<br/>';
  echo $role . '<br/>';
  echo '<br/>';
}

foreach(explode(",", $string) as $value) {
    $parts = explode(" as ", $value);
    echo trim($parts[0])."<br/>".trim($parts[1])."<br/>";        
}

注:我假设你有一个查询，但只是没有放入适当的查询字符串，所以我添加了一个典型的mySQL示例。

$query = mysql_query("SELECT actor1 as aaa, actor2 as bbb, actor3 as ccc FROM some_table");
$result = mysql_fetch_object($query);
$numrows = mysql_num_rows($query);
for ($i = 1; $i <= $numrows; $i++) {
  echo "actor1 <br>";
  echo $result->aaa . "<br>";
  echo "actor3 <br>";
  echo $result->bbb . "<br>";
  echo "actor3 <br>";
  echo $result->ccc . "<br>";
}