douzheng9221 2019-07-13 03:10
浏览 165

如何使用PHP从textarea向MySQL插入多个值和多行?

Now i submit this to textarea :

1|Value

This insert to database :

-------------------
Column1 | Column2
1       | Value
-------------------

Now I want to add these results to multiple lines by pressing the enter key, please help me add it This is my HTML index code :

<form method="POST" action="add.php">
<div class="form-group">
    <label for="chonphim">Film:</label>
  <select class="form-control" name="chonphim" id="chonphim">
<option value="kono-yo-no-hate-de-koi-wo-utau-shoujo-yu-no_JZ93Q">Phim Kono Yo no Hate de Koi wo Utau Shoujo YU-NO</option>
  </select>
</div>
<div class="form-group">
    <label for="player">Multiple row and data:</label>
    <textarea class="form-control" id="player" name="player" rows="4" placeholder="1|Value1
2|Value2
3|Value3"></textarea>
  </div>
<center>
<div class="form-group">
<button style="margin-top: 15px;" class="btn btn-primary active" type="submit" >Add value</button></div></center>
</form>

This is add.php

$chonphim=$_POST['chonphims'];
$player = escape_string($_POST['player']);
$player1 = explode("|", $player);
$tapphim = $player1[0];
$linkplayphim = $player1[1];
$sql2 = "UPDATE vohuunhan_film SET settime = settime + 1 WHERE link = '$chonphim'";
$sql88 = "INSERT INTO vohuunhan_episode (tap, linkplay, id_film)
VALUES (N'$tapphim', N'$linkplayphim', N'$chonphim');";
if ($connect->query($sql88) === TRUE && $connect->query($sql2) === TRUE) {
    echo "Success !"; 
} else {
    echo "Error: " . $connect->error;
}

I want :

1|Value1
2|Value2
3|Value3

Insert to database :

-------------------
Column1 | Column2
1       | Value1
2       | Value2
3       | Value3
-------------------
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 如何在scanpy上做差异基因和通路富集?
    • ¥20 关于#硬件工程#的问题,请各位专家解答!
    • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
    • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
    • ¥30 截图中的mathematics程序转换成matlab
    • ¥15 动力学代码报错,维度不匹配
    • ¥15 Power query添加列问题
    • ¥50 Kubernetes&Fission&Eleasticsearch
    • ¥15 報錯:Person is not mapped,如何解決?
    • ¥15 c++头文件不能识别CDialog