Create LISA <span id="rf2" name="rf2"></span><span> <input type="submit" value="Add" onclick="func1(); return false;"></span> <?php $title=$_GET["title"]; $packid=$_GET["packid"]; require_once "configs.php"; ?> <link rel="stylesheet" type="text/css" href="table.css"> <div class = "outertb"> <table id="tble" align="center"> <thead><tr id='tableHeader'> <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;'>⚙packid</th><th style='width:10px;'>⚙fbox</th><th style='width:10px;'>⚙Tool </th><th style='width:10px;'>⚙Tool </th> </tr></thead><tr> <?php $packid=$_GET["packid"]; $title=$_GET["title"]; // Include config file require_once "configs.php"; $rows=0; $sql = "SELECT *,lisa.id as lisaid FROM `lisa` join fixa on lisa.fixaid=fixa.id where lisa.packid=$packid order by lcode"; $res = $db->query($sql); $i=0; while ($row = $res->fetchArray()) { echo "<td>" . $row['lisaid'] . "</td>"; // echo "<td>" . $row['fixaid'] . "</td>"; echo "<td>" . $row['title'] . "</td>"; echo "<td>" . $row['scode'] . "</td>"; echo "<td>" . $row['packid'] . "</td>"; echo "<td>" . $row['fbox'] . "</td>"; $crurl= (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? "https" : "http") . "://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]"; echo "<td><a href='zupdtfixa.php?id=". $row['fixaid'] ."' title='Update' data-toggle='tooltip' class='button1 grey'>📝Update</a>"; echo "" ."<a href='liza_del.php?back=".$crurl."&id=". $row['lisaid'] ."' title='DEL Record' data-toggle='tooltip' class='button0 red' >DEL</a>"."</td>"; echo "</tr>"; $i++; } //echo $i; ?> </table> </div> <!-- end outertb --> <script> myfuncf2("sq_qcombo.php","rf2"); function myfuncf2(server,param="") { document.getElementById(param).innerHTML ="Wait...."; // cmd=(document.getElementsByName("cmd")[0].value); params="postdata="+param; var xhttp = new XMLHttpRequest(); xhttp.onreadystatechange = function() { if (this.readyState == 4 && this.status == 200) { document.getElementById(param).innerHTML = this.responseText; } }; xhttp.open("POST",server, true); xhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded"); xhttp.send(param); } function func1(){ // alert("hi"); var en1 = document.getElementsByName("pname")[0]; var en2 = document.getElementsByName("qname")[0]; // var ec1 = document.getElementsByClassName("fc1")[0]; // var en1 = document.getElementsByName("fn1")[0]; // var eid1 = document.getElementById("fid1"); //var ti1 = document.getElementsByName("title")[0]; // var sc1 = document.getElementsByName("score")[0]; // var cd1 = document.getElementsByName("code")[0]; datapack={}; //dont need this -as issue with special charactor // datapack.name=btoa(en1.value); //decode =atob datapack.pid=<?php echo $packid;?>; datapack.qid=(en2.value); datapack.oid=("<?php echo $id;?>"); data=datapack; data=JSON.stringify(datapack); updatato("zqtop.php",data); } function updatato(server,rdata) { //cmd=(document.getElementsByName("cmd")[0].value); //var e = document.getElementById("name"); //cmd=(document.getElementsByName("name")[0].value); //var value = e.options[e.selectedIndex].value; params="postdata="+rdata ; var xhttp = new XMLHttpRequest(); xhttp.onreadystatechange = function() { if (this.readyState == 4 && this.status == 200) { // document.getElementById("snackbar2").innerHTML = this.responseText; //reloadme(); // snackbar2reload(); if (this.response == "OK") { alert(x.value+" created"); window.history.back(); } else { alert(this.response); } } }; xhttp.open("POST", server, true); xhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded"); xhttp.send(params); } </script> </script>
Edit file:zlisalist2pa-20210911145103.php5366