使用SQL行作为数组

Question

Here's the problem:

I got a row (voters) in my sql database containing nicknames of people who already voted like this:

"Nickname1", "Nickname2", "Nickname3", 

But, if I try to use this row in an array to check if the logged in user already voted:

$voters = array($data['voters']);
if (!in_array($_SESSION['user'], $voters)) { // count his vote // } else { echo 'already voted' };

It simply doesn't work. If the user already voted but try anyway, his vote is counted and he's added again in my voters row.

What's wrong with my code ? Thanks

Answer 1

Your code is wrong because you don't have to use a single row to store multiple voters but instead you should have multiple rows each to store a single voter. Learn about database normalization or your work will be hard and fruitless

Anyway, here's your solution

$voters = explode(",",$data['voters']);
if (!in_array('"'.$_SESSION['user'].'"', $voters)) { // do something... }