猿问

请帮我解决下面的数组情况

我有下面的代码,我想问一下,如何根据之前的数据将源插入到其他表中的数据库中?


我从数据库中获取数据并将其显示在复选框上,但是当我检查复选框并按下按钮 Tambah 时,数据被插入到表中,但数据错误,只有 0 和数组。


<!DOCTYPE html>

<html>

<head>

  <title>kumpulan data command</title>

  <link rel="stylesheet" type="text/css" href="style.css">

</head>

<body>

  <h1>Evaluation</h1>

  <h2>Data command</h2>

  <?php


$db = new mysqli("localhost","root","","FWS_online");

echo $db->connect_errno?'Koneksi gagal :'.$db->connect_error:'';

$query = ("SELECT * FROM printer_function_commands")  or die(mysql_error());

$result = mysqli_query($db, $query);

$pilihan = '';

$data = array();

if (isset($_POST['submit']) && isset($_POST['commands']))

{

    if (count($_POST['commands']) > 0)

    {

        $pilihan = serialize($_POST['commands']);

        echo "<p>Data berhasil disimpan ke database berupa ".$pilihan."</p>";

    }

}

if ($pilihan <> '')

{

    $data = unserialize($pilihan);

}

?>


  <table border="1">

    <tr>

      <th>ID</th>

      <th>No</th>

      <th>Commands</th>

    </tr>

    <?php 

    include "database.php";

    $data1 = mysql_query("select * from result_commands");

    $no = 1;

    while($d = mysql_fetch_array($data1)){

    ?>

    <tr>

      <td><?php echo $no++; ?></td>

        <td><?php echo $d['no_commands']; ?></td>

        <td><?php echo $d['commands']; ?></td>    

    </tr>

    <?php } ?>

  </table>

  <br/>

  <h2>Input Banyak Data</h2>

  

<form method="post" action="tambah.php">    

  <table border="1">

      <tr>

        <th>ID</th>

        <th>No</th>

        <th>Commands</th>

        <th>Pilih</th>

      </tr>

      <?php 

      include "database.php";

      $data = mysql_query("select * from printer_function_commands");

      $no = 1;

      while($d = mysql_fetch_array($data)){

      ?>

蝴蝶不菲
浏览 138回答 1
1回答
随时随地看视频慕课网APP
我要回答