在文本框中用逗号分隔的文本在MYSQL中添加新行

问题描述：

我有一个PHP/MYsql问题.

I have a PHP/MYsql question.

我正在尝试在每个逗号后插入新行.

I am trying to insert a new row after each comma.

基本上，我想要这个功能:

Basically, I want this function:

假设我们有一个包含以下文本的文本框:

Let's say we have a textbox with the following text:

篮球，网球，足球，排球->提交按钮

Basketball, Tennis, Futbol, Volleyball --> Submit Button

单击提交"按钮后，我想在每个单词后的一个表中插入新行.

After the submit button is clicked, I want to Insert a new row in one table after each word.

基本上，我希望这样的结果在数据库中

Basically, I want the outcome in the DB like this

id      category
1       Basketball
2       Tennis
3       Futbol
4       Volleyball

任何人都可以帮助我吗?

Anyone can help me with this ?

谢谢:)

答

您可以循环浏览每个对象，然后分别添加它们.

You could just loop through each, and add them individually.

$input = "Basketball, Tennis, Futbol, Volleyball";
foreach (explode(',',$input) as $piece)
{
    $piece = mysql_real_escape_string(trim ($piece));
    $sql = "INSERT INTO table VALUES($piece)";
    //Run sql
}

在文本框中用逗号分隔的文本在MYSQL中添加新行

相关推荐