Edit Data in Database through html Table

 <table cellspacing="0" style="font-size:15px;" width="100%" align="center" id="sl">
 
 <p class="a">Custom Subsidiary</p>
 <INPUT type="button" value="Add" onclick="addRow('sl')" style="font-family: 'icomoon';
    font-size: 12px;content: \e608;"/>
  <tr style="" width="100%">
  <th style="border-bottom: black 2px solid;"></th>
 

  <th style="border-bottom: black 2px solid;text-align:left;" valign="left">Key</th>
  <th style="border-bottom: black 2px solid;text-align:left;" align="left">Description</th>

  <th style="border-bottom: black 2px solid;text-align:left;" align="left">City</th>
  <th style="border-bottom: black 2px solid;text-align:left;" align="left">Address</th>
  <th style="border-bottom: black 2px solid;text-align:left;" align="left">Address</th>
 <th style="border-bottom: black 2px solid;text-align:left;" align="left">Zipcode</th>
 <th style="border-bottom: black 2px solid;text-align:left;" align="left">Municipal</th>


  </tr>
  <?php
  $c=1;
  $sq=mysql_query("select * from subsidiaryledger");
  while($re=mysql_fetch_array($sq))
  {
  ?>
  <tr>
  <td  align="left"><?php echo $c;?></td>
  <td style="font-family: erpag,Segoe UI;
    font-weight: bold;
    font-size: 11px;" align="left" contenteditable="true" onBlur="saveToDatabase(this,'keyss','<?php echo $re[0]; ?>')"><?php echo $re[1];?></td>
  <td style="font-family: erpag,Segoe UI;
    font-weight: bold;
    font-size: 11px;" align="left" contenteditable="true" onBlur="saveToDatabase(this,'description','<?php echo $re[0]; ?>')"><?php echo $re[2];?></td>
  <td style="font-family: erpag,Segoe UI;
    font-weight: bold;
    font-size: 11px;" align="left" contenteditable="true" onBlur="saveToDatabase(this,'city','<?php echo $re[0]; ?>')"><?php echo $re[3];?></td>
  <td style="font-family: erpag,Segoe UI;
    font-weight: bold;
    font-size: 11px;" align="left" contenteditable="true" onBlur="saveToDatabase(this,'address','<?php echo $re[0]; ?>')"><?php echo $re[4];?></td>
<td style="font-family: erpag,Segoe UI;
    font-weight: bold;
    font-size: 11px;" align="left" contenteditable="true" onBlur="saveToDatabase(this,'address1','<?php echo $re[0]; ?>')"><?php echo $re[5];?></td>
<td style="font-family: erpag,Segoe UI;
    font-weight: bold;
    font-size: 11px;" align="left" contenteditable="true" onBlur="saveToDatabase(this,'zipcode','<?php echo $re[0]; ?>')"><?php echo $re[6];?></td>
<td style="font-family: erpag,Segoe UI;
    font-weight: bold;
    font-size: 11px;" align="left" contenteditable="true" onBlur="saveToDatabase(this,'municipal','<?php echo $re[0]; ?>')"><?php echo $re[7];?></td>
<td><a href="subsidiaryledger.php?id=<?php echo $re[0];?>&st=del"><img src="delete.png"></a></td>
  </tr>
  <?php
$c++;  }
  ?>
 
 

  </table>












<script type="text/javascript">

function saveToDatabase(editableObj,column,id) {
$(editableObj).css("background","#FFF url(loaderIcon.gif) no-repeat right");
$.ajax({
url: "saveedit.php",
type: "POST",
data:'column='+column+'&editval='+editableObj.innerHTML+'&id='+id,
success: function(data){
$(editableObj).css("background","#FDFDFD");
}      
   });
}
</script>









saveedit.php

<?php
include("../db.php");

mysql_query("UPDATE subsidiaryledger set " . $_POST["column"] . " = '".$_POST["editval"]."' WHERE  id=".$_POST["id"]);
?>








Popular posts from this blog

Jtable with database manually in netbeans.

package Demo; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.Vector; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import net.proteanit.sql.DbUtils; /**  *  * @author NAVJYOTI  */ public class Jtablee extends javax.swing.JFrame {     /**      * Creates new form Jtablee      */     public Jtablee() {         initComponents();         set();     }     private int getsize() { int count=0; try {Class.forName("com.mysql.jdbc.Driver");             java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root"); Statement stmt=con.createStatement(); String query="select * from group1"; ResultSet rs= ...
Read more

Join in Kotlin coroutines

  In Kotlin coroutines, the  join()  function is used to wait for the completion of multiple coroutines running concurrently. It allows you to ensure that all the launched coroutines finish their execution before proceeding further in the code. When you launch multiple coroutines using  launch ,  async , or other coroutine builders, you obtain references to these launched coroutines. You can store these references in variables and later use  join()  on each of these variables to wait for the corresponding coroutines to complete. import kotlinx.coroutines.* suspend fun doTaskA() { println(“Task A started”) delay(2000) // Simulate some asynchronous work for 2 seconds println(“Task A finished”) } suspend fun doTaskB() { println(“Task B started”) delay(3000) // Simulate some asynchronous work for 3 seconds println(“Task B finished”) } fun main() = runBlocking { val jobA = launch { doTaskA() } val jobB = launch { doTaskB() } println(“Launched both coroutine...
Read more