Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR CSHARP

temp^late php table for mysql

<?php
$sqlacq ="SELECT * FROM tblAcq";
$resultacq = $conn->query($sqlacq);
?>
       <table id="acq-tbl" class="tbl-qa" border="1">
          <thead>
              <tr>
                <th class="table-header" width="10%">AcqID</th>
                <th class="table-header">Data (an-luna-zi)</th>
                <th class="table-header">AcqNumber</th>
                <th class="table-header">AcqSupplier</th>
                <th class="table-header">AcqNote</th>
                <th class="table-header">InStocLa</th>

              </tr>
          </thead>
          <tbody>
       <?php
        function table_print($rowacq) {
              echo '<tr class="table-row" ondblclick="mySelection(event)">';
              echo '<td>'.$rowacq["AcqID"].'</td>';
              echo '<td contenteditable="true" onBlur="saveToDatabase(this,'AcqDate',''.$rowacq["AcqID"].'')" onClick="showEdit(this);">'.$rowacq["AcqDate"].'</td>';
              echo '<td contenteditable="true" onBlur="saveToDatabase(this,'AcqNumber',''.$rowacq["AcqID"].'')" onClick="showEdit(this);">'.$rowacq["AcqNumber"].'</td>';
              echo '<td contenteditable="true" onBlur="saveToDatabase(this,'AcqSupplier',''.$rowacq["AcqID"].'')" onClick="showEdit(this);">'.$rowacq["AcqSupplier"].'</td>';
              echo '<td contenteditable="true" onBlur="saveToDatabase(this,'AcqNote',''.$rowacq["AcqID"].'')" onClick="showEdit(this);">'.$rowacq["AcqNote"].'</td>';
              echo '<td>'.$rowacq["InStocLa"].'</td>';
              echo '<td align="center"><a href="javascript:delete_id('.$rowacq["AcqID"].')"><img src="b_drop.png" alt="Delete" /></a></td>'
              echo "</tr>";

        }
       if ($resultacq->num_rows > 0) {
            while($rowacq = $resultacq->fetch_assoc()) {
                table_print($rowacq);
            }
       }
?>
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #php #table #mysql
ADD COMMENT
Topic
Name
4+1 =