duanlei2458 2016-11-25 09:46
浏览 31

在iis上使用php更新多行mssql

i want update multiple rows my table sql server use php 7 on iis, i have script like this

this is my script

this my action when click "submit" button

            $getResults= sqlsrv_query($conn, $tsql, $params);
            $rowsAffected = sqlsrv_rows_affected($getResults);
            if ($getResults == FALSE or $rowsAffected == FALSE)
                die(FormatErrors(sqlsrv_errors()));
            echo ($rowsAffected. " row(s) updated: " . PHP_EOL);
            sqlsrv_free_stmt($getResults);
            }
            }
            else
            {
                echo "Data belum berubah";
            }
            ?>

this is my form

        <form action='' method='POST'>
        <div class="box-body">
            <div style='overflow:auto;width:1300px;'>
                <table id="example2" class="table table-bordered table-hover">
                    <thead>
                        <tr>
                            <th>my column name</th>
                        </tr>
                    </thead> 
            <?php
            $tampil=sqlsrv_query($conn,'SELECT top 10 * FROM ws_manado ORDER BY Region', array(), array( "Scrollable" => 'static' ));
            $count=sqlsrv_num_rows($tampil);
            if (!$tampil) 
            {
                printf("Error: %s
", msql_error($conn));
                exit();
            }
            $no=1;
                while ($r=sqlsrv_fetch_array($tampil,SQLSRV_FETCH_ASSOC))
                {
                echo "$count
                <tr>
                    <td id='Id[]' value=$r[Id]>$no</td>
                    <td id='Site_ID_Implementation[]' contenteditable='true'>$r[Site_ID_Implementation]</td>
                    <td id='Implementation_Date[]' contenteditable='true'>$r[Implementation_Date]</td>
                    <td id='PR_Number[]' contenteditable='true'>$r[PR_Number]</td>
                    <td id='PR_Amount[]' contenteditable='true'>$r[PR_Amount]</td>
                </tr>";
            $no++; 
            }
            ?>
                </table>
            </div>
            <input type="submit" name="submit" id="submit" value="submit">
        </div>
        </form>

but when i click submit button my table not update

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 用windows做服务的同志有吗
    • ¥60 求一个简单的网页(标签-安全|关键词-上传)
    • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
    • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
    • ¥100 为什么这个恒流源电路不能恒流?
    • ¥15 有偿求跨组件数据流路径图
    • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
    • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
    • ¥15 一直显示正在等待HID—ISP
    • ¥15 Python turtle 画图