donglu6805 2017-08-15 12:43
浏览 35

php mysql-query中的两个输入类型

I have a table in which two text fields and one input text field. A query is created new row, and if there is one, just update.

if (isset($_POST['submit'])) {
$text = !empty($_POST['text']) ? $_POST['text'] : null;
foreach ($text as $idt => $pages) {
if ($pages != NULL) {    
$todb = $mysqli->query('INSERT INTO extendtovar (book_id, pages) 
VALUES ("' . $idt . '", "' . $pages . '") 
ON DUPLICATE KEY UPDATE pages = "' . $pages . '"');
  }
 }
}   
  $todb = $mysqli->query('SELECT 
  nalvmag.id AS id,
  nalvmag.name AS name,
  extendtovar.book_id AS id2,
  extendtovar.pages AS pages
  FROM nalvmag LEFT JOIN extendtovar 
  ON nalvmag.id = extendtovar.book_id 
  WHERE nalvmag.remainder > 0
  ORDER BY name ASC');
  echo '<table class="raz">';
  while ($row = $todb->fetch_array())
  { echo '<tr><td>'.$row[id].'</td>';
      echo '<td>'.$row[name].'</td>';
      echo '<td><input type="text" name="text['.$row[id].']" value="'.$row[pages].'" maxlength="5" size="6"><br></td></tr>';
  }
    echo '</table>';    

echo'<button type="submit" name="submit">Submit</button></form>';
}

But now I want to add one more input text field

echo $row[id];
echo row[name];
echo '<input type="text" name="text['.$row[id].']" value="'.$row[pages].'" maxlength="5" size="6">
echo '<input type="text" name="text2['.$row[id].']" value="'.$row[pages2].'" maxlength="5" size="6">

and when i update php code to

if (isset($_POST['submit'])) {
    $text = !empty($_POST['text']) ? $_POST['text'] : null;
    foreach ($text as $idt => $pages) {
    if ($pages != NULL) {    
    $todb = $mysqli->query('INSERT INTO extendtovar (book_id, pages, pages) 
    VALUES ("' . $idt . '", "' . $pages . '", "' . $pages2 . '") 
    ON DUPLICATE KEY UPDATE pages = "' . $pages . '", pages2 = "' . $pages2 . '"');
      }
     }
    }   

field pages2 not update.

I can not understand how to properly change foreach and form a request

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 基于卷积神经网络的声纹识别
    • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
    • ¥100 为什么这个恒流源电路不能恒流?
    • ¥15 有偿求跨组件数据流路径图
    • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
    • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
    • ¥15 CSAPPattacklab
    • ¥15 一直显示正在等待HID—ISP
    • ¥15 Python turtle 画图
    • ¥15 stm32开发clion时遇到的编译问题