Question

为什么这赢得了工作? I 用户已经安装,希望其他有相同标签的用户获得。

主计长:

$this->load->model( tag_model );
            $data[ usr_tags ] = $this->tag_model->get_home_tags($user_id);
            $tags = $this->tag_model->get_home_tags($user_id);
            $tag_array = $tags;
            $data[ tag_users ] = $this->tag_model->get_tag_users($tag_array);

模式:

function get_tag_users($tag_array)
    {
            //$tag = array( item1 , item2 , item3 );
            $tag = $tag_array;
            $query_str =  SELECT DISTINCT user_id FROM tags WHERE tag IN (" . implode( "," , $tag) . ") ;

            $query = $this->db->query($query_str);

            if($query->num_rows() > 0) {
                    foreach($query->result_array() as $tag_users) {
                            $data[] = $tag_users;
                    }
                    return $data;
            }else{
                    return false;
            }
    }

错误:

A PHP Error was encountered
Severity: Notice
Message: Array to string conversion
Filename: models/tag_model.php
Line Number: 20

Answer 1

页: 1 looks:

array(4){
    [0]=> array(1){
        ["tag"]=> string(3) "lol"
    }
    [1]=> array(1){
        ["tag"]=> string(4) "here"
    }
    [2]=> array(1){
        ["tag"]=> string(3) "php"
    }
    [3]=> array(1){
        ["tag"]=> string(5) "mysql"
    }
}

这实际上是一系列阵列,你可以使用implode。 “Array to string”换算之所以发生,是因为阵列的每个组成部分都是一个阵列,而PHP需要改换成一个扼子,以“imp”。

您可以使用<代码>array_map,从各个阵列中获取每个标签。

function get_tag_users($tag_array)
{
    $tag = array_map(function($a){
        return $a[ tag ];
    }, $tag_array);
    $query_str =  SELECT DISTINCT user_id FROM tags WHERE tag IN (" . implode( "," , $tag) . ") ;

如果你没有PHP5.3,你可以这样做:

function get_tag_users($tag_array)
{
    $tag = array_map(create_function( $a ,  return $a["tag"]; ), $tag_array);
    $query_str =  SELECT DISTINCT user_id FROM tags WHERE tag IN (" . implode( "," , $tag) . ") ;

Answer 2

<><><><><>><>>>><>>>>>>

$this->load->model( tag_model );
$data[ usr_tags ] = $this->tag_model->get_home_tags($user_id);
$data[ tag_users ] = $this->tag_model->get_tag_users($data[ usr_tags ]);

<><><>>>>

function get_tag_users($tag_array)
{
    $tags=array();
    foreach($tag_array as $tag)
    {
        $tags[]= $tag[ tag ];
    }
    $query_str =  SELECT DISTINCT user_id FROM tags WHERE tag IN ( .implode(",", $tags). ) ;
    $query = $this->db->query($query_str);
    if($query->num_rows() > 0)
    {
        return $query->results();
    }
    else
    {
        return false;
    }
}

http://www.hchr.org。页: 1

友情链接