Question

I ve devised a tagging system for my Website where tags beginning with a hash (#) function differently to those without. I m trying to extract all hash tags from my database and load them into an array:

$keywords = mysql_query("SELECT Keywords FROM Tags WHERE Keywords LIKE  #% ") or die("Query failed with error: ".mysql_error());
$stack = array();
while ($row = mysql_fetch_array($keywords))
{
    $wrds = $row[ Keywords ];
    $val = preg_match("/#w+(?=,|)/", $wrds, $matched);
    while (!empty($matched))
    {
        $val = array_pop($matched);
        if (array_search($val, $stack) === FALSE)
        {
            array_push($stack, $val);
    }
    }
}

5. MySQL询问如下:

+------------------------+
| Keywords               |
+------------------------+
| #test1, test           |
| #test1, #test2, #test4 |
| #test3, #est5          |
| #test3                 |
+------------------------+

我想像以下几个方面:

Array(
  [0] => #test1
  [1] => #test2
  [2] => #test4
  [3] => #test3
  [4] => #est5
  )

我做了什么错误?

Answer 1

使用preg_match_all:

$arr = array( #test1, test , #test1, #test2, #test4 , #test3, #est5 , #test3 );
$stack = array();
foreach($arr as $wrds) {
    $val = preg_match_all("/#w+(?=,|$)/", $wrds, $matched);
    while (!empty($matched[0])) {
        $val = array_pop($matched[0]);
        if (array_search($val, $stack) === FALSE)
        {
            array_push($stack, $val);
        }
    }
}
print_r($stack);

<>光>

Array
(
    [0] => #test1
    [1] => #test4
    [2] => #test2
    [3] => #est5
    [4] => #test3
)

Answer 2

例:preg_match ("/^#w+$/$/>,wrds,$matelle/code>

Answer 3

正如@NullUserException所说,在RDBMS中,设计设计错误,使序列值变得复杂。

对于你的问题,你可以尝试另一种方式:

$result = array_filter(explode( , , $wrds), function($a){ return $a[0]=== #  } );

友情链接