dsjlqkbpn029473708 2016-12-09 17:48
浏览 41
已采纳

使用逗号将用户名插入数据库

i have a on line multi player game php mysql flash drivin,

i am getting winners player names via php and need to insert them to a db row using comma's or a space between the names so that i may fetch it via php to display them in flash/animate.

here is the code that insert's to temp db row but only insert's one player name

if($user != ''){
 mysql_query("insert into ".DB_TEMPWINNER." (username,gameID) values('".$user."','".$gameID."')") or  die("could Not update");
}

$user being the players names to be inserted fetched above this code using php

if this is a bad way i could change it i've experimented a bit and inserted each player name it's own row but was unable to send back to .swf to be displayed as it only displayed 1 player name when there was 2 for example.

I've been 6 years developing this game and try not to ask but this has had me baffled for roughly a year now.

Thanks in advance

  • 写回答

1条回答 默认 最新

  • du94414 2016-12-09 17:56
    关注

    http://php.net/manual/en/function.implode.php

    $arr = array("a", "b", "c");
    $res = implode(",", $arr);
    echo $res;
    // a,b,c
    

    http://php.net/manual/en/function.explode.php to reverse

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?