我使用的是 diff 算法 ( the Paul Butler one )，现在我开始使用它了。我发现我需要 mysql_fetch_array() 而不是 mysql_fetch_object()，它解决了警告和错误消息，但现在当我尝试 print_r() 显示结果时，结果只是“Array”而不是数据库中的字段我需要它来显示和比较...当我调用不同的函数时，它似乎显示了字段，但不比较它们而不是将它们列出两次并使用 Array ( [0] => Array ( [ d] => 数组 ( [0] => 在它之前。

知道为什么吗？是的，我用谷歌搜索并查找了它，并花了大约两天时间试图解决这个问题。

这是脚本的一部分:

    $oldhistory = mysql_query("SELECT history FROM members WHERE id = '$id'") or die(mysql_error());
    $oldhistory = mysql_fetch_array($oldhistory);

    $newhistory = mysql_query("SELECT history FROM profile_edit WHERE userid = '$id'") or die(mysql_error());   
    $newhistory = mysql_fetch_array($newhistory);

    $oldpersonality= mysql_query("SELECT personality FROM members WHERE id = '$id'") or die(mysql_error());
    $oldpersonality = mysql_fetch_array($oldpersonality);

    $newpersonality = mysql_query("SELECT personality FROM profile_edit WHERE userid = '$id'") or die(mysql_error());   
    $newpersonality = mysql_fetch_array($newpersonality);

    $oldappearance = mysql_query("SELECT description FROM members WHERE id = '$id'") or die(mysql_error());
    $oldappearance = mysql_fetch_array($oldappearance);

    $newappearance = mysql_query("SELECT personality FROM profile_edit WHERE userid = '$id'") or die(mysql_error());    
    $newappearance = mysql_fetch_array($newappearance);

    echo "
      <form action=\"$PHP_SELF?id=$id&s=a\" method=\"post\">
      <table cellpadding=\"5\" cellspacing=\"1\" border=\"0\" align=\"center\" bgcolor=\"#234904\">
        <tr bgcolor=\"#000000\">
         <td>History :: </td>
         <td> 
";

function diffhistory($oldhistory, $newhistory){

foreach($oldhistory as $oindex => $ovalue){
        $nkeys = array_keys($newhistory, $ovalue);
        foreach($nkeys as $nindex){
            $matrix[$oindex][$nindex] = isset($matrix[$oindex - 1][$nindex - 1]) ?
                $matrix[$oindex - 1][$nindex - 1] + 1 : 1;
            if($matrix[$oindex][$nindex] > $maxlen){
                $maxlen = $matrix[$oindex][$nindex];
                $omax = $oindex + 1 - $maxlen;
                $nmax = $nindex + 1 - $maxlen;
            }
        }   
    }
    if($maxlen == 0) return array(array('d'=>$oldhistory, 'i'=>$newhistory));
    return array_merge(
        diffhistory(array_slice($oldhistory, 0, $omax), array_slice($newhistory, 0, $nmax)),
        array_slice($newhistory, $nmax, $maxlen),
        diffhistory(array_slice($oldhistory, $omax + $maxlen), array_slice($newhistory, $nmax + $maxlen)));
}

function htmlDiffHistory($oldhistory, $newhistory){
    $diffhistory = diffhistory(explode(' ', $oldhistory), explode(' ', $newhistory));
    foreach($diffhistory as $k){
        if(is_array($k))
            $ret .= (!empty($k['d'])?"<del><color=red>".implode(' ',$k['d'])."</color></del> ":'').
                (!empty($k['i'])?"<ins><color=green>".implode(' ',$k['i'])."</color></ins> ":'');
        else $ret .= $k . ' ';
    }
    return $ret;

}
print_r (diffhistory($oldhistory, $newhistory));

最佳答案

可能您只需要使用 mysql_fetch_assoc()(或者可能是 mysql_fetch_row())从数据库读取数据作为关联或索引，而不是两者兼而有之，但我怀疑您的方法存在很大缺陷-一方面，您要在一个地方进行 6 个查询。您还将一个单值数组传递给一个函数，我怀疑该函数需要两个多值数组进行比较。

试试这个(根据下面的评论编辑):

<?php

  function diff($old, $new){
    $maxlen = 0;
    foreach ($old as $oindex => $ovalue) {
      $nkeys = array_keys($new, $ovalue);
      foreach ($nkeys as $nindex) {
        $matrix[$oindex][$nindex] = isset($matrix[$oindex - 1][$nindex - 1])
          ? $matrix[$oindex - 1][$nindex - 1] + 1
          : 1;
        if ($matrix[$oindex][$nindex] > $maxlen) {
          $maxlen = $matrix[$oindex][$nindex];
          $omax = $oindex + 1 - $maxlen;
          $nmax = $nindex + 1 - $maxlen;
        }
      } 
    }
    return ($maxlen == 0)
      ? array(array('d'=>$old, 'i'=>$new))
      : array_merge(
          diff(array_slice($old, 0, $omax), array_slice($new, 0, $nmax)),
          array_slice($new, $nmax, $maxlen),
          diff(array_slice($old, $omax + $maxlen), array_slice($new, $nmax + $maxlen)));
  }

  function htmlDiff($old, $new){
    $ret = '';
    $diff = diff(preg_split('/\s+/', $old), preg_split('/\s+/', $new));
    foreach ($diff as $k) {
      if (is_array($k)) {
          $ret .= (!empty($k['d']) ? "<del style='color:red'>".implode(' ',$k['d'])."</del> " : '')
                . (!empty($k['i']) ? "<ins style='color:green'>".implode(' ',$k['i'])."</ins> " : '');
      } else {
        $ret .= $k . ' ';
      }
    }
    return $ret;
  }

  $query = "
    SELECT
      `m`.`history`, `p`.`history` AS 'p_history',
      `m`.`personality`, `p`.`personality` AS 'p_personality',
      `m`.`description`, `p`.`description` AS 'p_description'
    FROM `members` `m`
    JOIN `profile_edit` `p` ON `p`.`userid` = `m`.`id`
    WHERE `m`.`id` = '".mysql_real_escape_string($id)."'
    LIMIT 1
  ";

  $result = mysql_query($query) or die(mysql_error());
  $data = mysql_fetch_assoc($result);

  echo "
    <form action=\"$PHP_SELF?id=$id&s=a\" method=\"post\">
      <table cellpadding=\"5\" cellspacing=\"1\" border=\"0\" align=\"center\" bgcolor=\"#234904\">
        <tr bgcolor=\"#000000\">
          <td>History :: </td>
          <td>".htmlDiff(htmlspecialchars($data['history']), htmlspecialchars($data['p_history']))."</td>
        </tr>
        <tr bgcolor=\"#000000\">
          <td>Personality :: </td>
          <td>".htmlDiff(htmlspecialchars($data['personality']), htmlspecialchars($data['p_personality']))."</td>
        </tr>
        <tr bgcolor=\"#000000\">
          <td>Description :: </td>
          <td>".htmlDiff(htmlspecialchars($data['description']), htmlspecialchars($data['p_description']))."</td>
        </tr>
      </table>
    </form>";

关于php - print_r() 函数返回 diff 算法的简单结果 "Array"，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/9196178/