Inserting data from multiple value list

nc_brox

Hi,

I'm trying to input a form onto my page, where the user can select from a range of different sports, and more than one sport can be selected.

But I'm not sure how I go about writing the code so that it's entered into the mySql table that I have set up - I want it to go into one field in the table called Sport or something along those lines. I can write the code for just one value to go in but I'm not sure about when there's more than 1...

Please help if you can!

Thanks!

🙂

The_Chancer

If the form element is a multiple - this will come across as an array value. using

$str = explode(",",$array)

Will give you a comma separated string.

etully

Edited. I like his answer better. 🙂

etully

Isn't explode for taking apart a comma separated string? Don't you mean implode?

laserlight

One user can take up more than one sport. A sport may have more than one user taking it up. As such, there is a many-many relationship between users and sports.

Instead of having a multi-valued column by using implode(), it might be better to add more rows to an intermediate table between the users table and the sports table.

The_Chancer

Implode() is for placing a string into an array, whilst explode() is for an array into a string.

laserlight

Implode() is for placing a string into an array, whilst explode() is for an array into a string.

I think you got them mixed up :p

quandrie

One user can take up more than one sport. A sport may have more than one user taking it up. As such, there is a many-many relationship between users and sports.

Instead of having a multi-valued column by using implode(), it might be better to add more rows to an intermediate table between the users table and the sports table.

Seems to me be best solution as well. So create a table users_sports, with fields user_id and sport_id. Loop through the submitted sports, for each sport insert a new entry:

for($x = 0;$x < count($_POST['sport_id']);$x++){
   $sql = 'INSERT INTO users_sports(user_id,sport_id) VALUES($_POST['user_id'],$_POST['sport_id'][$x])';
  $query = mysql_query($sql);
}

nc_brox

Thanks everyone, the implode thing worked.

When I want to show the contents of the sport cell on my page I guess I would use 'explode' then?