Modify Items <link rel="stylesheet" type="text/css" href="table.css"> <div class = "outertb"> <?php $packid=$_GET["packid"]; $title=$_GET["title"]; // Include config file require_once "configs.php"; echo '<table id="tble" align="center">'; echo "<thead><tr id='tableHeader'>"; echo "<th style='width:3%;' onclick=sortTableX(0);>id</th><th style='width:40%;' onclick=sortTableX(1);>Title</th><th onclick=sortTableX(2); style='width:5%;'>Score</th><th style='width:10px;'>⚙Tool </th><th style='width:10px;'>⚙Tool </th><th style='width:10px;'>⚙Tool </th><th style='width:10px;'>⚙ATT </th><th style='width:10px;'>⚙FNO</th><th style='width:10px;'>⚙Tool </th>"; echo "</tr></thead>"; $rows=0; $sql="SELECT *,lisa.id as lisaid FROM `lisa` join fixa on fixa.id=lisa.fixaid where lisa.packid=".$packid." group by lisa.packid,lisa.id order by lisa.lcode";//group by fixaid"; $res = $db->query($sql); $i=0; while ($row = $res->fetchArray()) { echo "<td>" . $row['lisaid'] . "</td>"; echo "<td>" . $row['title'] . "</td>"; echo "<td>" . $row['scode'] . "</td>"; echo "<td>" . $row['packid'] . "</td>"; echo "<td>" . $row['lcode'] . "</td>"; echo "<td><input type='text' style='width:4em' maxlength=5 name='b".$row['lisaid']."' placeholder='".$row['lcode']."' value=".$row['lcode']."></td>"; echo "<td><input type='text' style='width:2em' maxlength=3 name='a".$row['lisaid']."' placeholder='".$row['attachmentv']."' value=".$row['attachmentv']."></td>"; echo "<td><input type='text' style='width: 2em' maxlength=3 name='f".$row['lisaid']."' placeholder='".$row['fbox']."' value=".$row['fbox']."></td>"; $lid=$row['lisaid'];?> <td> <a href=#\ name="save" id ="myCheck" value="save" onclick=myfuncf2("zlisaupdate.php?lid=<?php echo $lid;?>","rf2","<?php echo $lid;?>",this) >💾 Save</a></td> <?php echo "</tr>"; $i++; } ?> </table> </div> <!-- end outertb --> <script> function myfuncf2(server,param="",row1,el) { var checkBox = document.getElementById("myCheck"); //alert(el); //var obj = JSON.parse(myJSON); //var drow1 = atob(row1); // var myJSON = JSON.stringify(drow1); //get datafrom row er="b"+row1; //line code (sort) fr="f"+row1; //fail line ar="a"+row1; //atachment cmd1=(document.getElementsByName(er)[0].value); cmd2=(document.getElementsByName(fr)[0].value); cmd3=(document.getElementsByName(ar)[0].value); alert("update:"+row1+":"+cmd1); // document.getElementById("snackbar2").innerHTML = "Updated record:"+row1+",Lvalue:"+cmd1+",Fvalue:"+cmd2+",Avalue:"+cmd3; // snackbar2reload(); //document.getElementById(el).checked = false; // var myJSON = JSON.parse(drow1); //alert(myJSON.hbx1+myJSON.hbx2+myJSON.hbx3); // cmd1=(document.getElementsByName(myJSON.hbx1)[0].value); // cmd2=(document.getElementsByName(myJSON.hbx2)[0].value); // cmd3=(document.getElementsByName(myJSON.hbx3)[0].value); //alert(cmd1+cmd2+cmd3); ///// if (el.checked == true){ datapack={}; //dont need this -as issue with special charactor // datapack.name=btoa(en1.value); //decode =atob datapack.lid=row1; datapack.lcode=cmd1; datapack.fbox=cmd2; datapack.abox=cmd3; data=datapack; data=JSON.stringify(datapack); // alert(data); //alert(obj.hbx1); //document.getElementById(param).innerHTML =row1; // alert(row1); // rr="row"+row; //if (row) rr=(document.getElementById(row).value); //cmd1=(document.getElementsByName(row1)[0].value); //cmd2=(document.getElementsByName(row2)[0].value); ///// if (el.checked == true){ //alert(el.attributes["name"].value+"+"+drow1); params="postdata="+data;//+row2+cmd1+cmd2; var xhttp = new XMLHttpRequest(); xhttp.onreadystatechange = function() { if (this.readyState == 4 && this.status == 200) { //document.getElementById(param).innerHTML = console.log(this.responseText); alert(this.responseText); } }; xhttp.open("POST",server, true); xhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded"); xhttp.send(params); /////} ///// } //exit; //alert(el.attributes["name"].value+"+"+row1); } </script>
Edit file:zfixalist4p-20210911144158.php5413