doulei1965 2016-11-11 13:01
浏览 27

使用php更新sql中的特定行

I want to grab the specific $key and $id and insert it into my sql table, How can i get the $key and $id? If i just had 1 row, i could have solve it, but since its a while loop, do i have to do it other way?

I've tried with key as a start like this

if(isset($_POST['$key'])) 

When i press my button for update

if(isset($_POST['$key'])) {
            $dbhost = '*****';
            $dbuser = '*****';
            $dbpass = '*****';

        $conn = db2_connect($dbhost, $dbuser, $dbpass);

        if(! $conn ) {
           die('Could not connect: ');
        }

        $postkey = $_POST['$key'];

        $sql = "UPDATE Products SET , KEY = $key, ID = $ID, DONE = 'X'  " ;
        $retval =  db2_exec( $conn, $sql);

        if(! $retval ) {
          die('Could not update data: ' . db2_stmt_errormsg());
        }
        echo "Updated data successfully
";
        db2_close($conn); 
     }     

Looping my tables

  while((db2_fetch_row($queryexe)){
     $key = db2_result($queryexe, 'KEY');
     $id = db2_result($queryexe, 'ID');
     $done = db2_result($queryexe, 'DONE');

    print("<td>$key</td>
");
    print("<td>$id</td>
");
    print("<td><button  name = '$key' type='submit' id = '$key' class='btn btn-default'>
    <i class='glyphicon glyphicon-repeat'></i> Done
    </button></td>
");
    print("</tr>
");

Sorry if im unclear. I've tried my best

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Oracle中如何从clob类型截取特定字符串后面的字符
    • ¥15 想通过pywinauto自动电机应用程序按钮,但是找不到应用程序按钮信息
    • ¥15 MATLAB中streamslice问题
    • ¥15 如何在炒股软件中,爬到我想看的日k线
    • ¥15 51单片机中C语言怎么做到下面类似的功能的函数(相关搜索:c语言)
    • ¥15 seatunnel 怎么配置Elasticsearch
    • ¥15 PSCAD安装问题 ERROR: Visual Studio 2013, 2015, 2017 or 2019 is not found in the system.
    • ¥15 (标签-MATLAB|关键词-多址)
    • ¥15 关于#MATLAB#的问题,如何解决?(相关搜索:信噪比,系统容量)
    • ¥500 52810做蓝牙接受端