<div class="container"> <div class="tab tab-1"> <table id="table" border="1"> <tr> <th class="ref">Réf du service</th> <th class="id">ID client</th> <th class="debut">Date de début </th> <th class="exp">Date d'expiration</th> <th class="code">Code annuelle</th> <th class="doc">Document de client</th> <th class="prix">Prix</th> <th class="refv">Version</th> <th class="action">Action</th> </tr> <tr> <?php $servername = "localhost"; $username = "sa"; $password = ""; $db = "database"; $connin = array("Database"=>$db, "UID"=>$username, "PWD"=>$password); $conn = sqlsrv_connect($servername, $connin ); if($conn === false){ } $sqlForTrack ="SELECT * FROM service"; $queryForTrack = sqlsrv_query( $conn, $sqlForTrack ); /* Handle sql errors if retuned */ if( $queryForTrack === false ) { die( '<pre class="error">' . print_r( sqlsrv_errors(), true ) . '
); } if( sqlsrv_num_fields( $queryForTrack ) ) { while( $row = sqlsrv_fetch_array( $queryForTrack, SQLSRV_FETCH_ASSOC ) ) { echo "<tr>"; echo "<td>" . $row['Ref_service'] . "</td>"; echo "<td>" . $row['ID_client'] . "</td>"; echo "<td>" . $row['Date_debut'] -> format('Y/m/d'); echo "</td><td class= 'outtime'>". $row['Date_expiration'] -> format('Y/m/d'); echo "</td><td>" . $row['Code_annuelle'] . "</td>"; echo "<td>" . $row['doc_client'] . "</td>"; echo "<td>" . $row['Prix_service'] . "</td>"; echo "<td></td>"; echo"<td class='sup'><a href ='deletes.php?ref=$row[Ref_service]' target='popup' onclick ='return checkdelete ()'><input type='button' class='del' value='Supprimer'></a></td></tr>"; echo "</tr>"; } echo "</table>"; } } sqlsrv_close ( $conn ); ?> </tr> </table> </div> <div class="tab tab-2"> <form action="sqledits.php" method="post" > <label class="ref" for="ref" >Ref service:</label> <input class="ref" type="number" name="ref" id="ref" placeholder="réference du service"> <label class="id" for="id" >ID client:</label> <input class="id" type="number" name="id" id="id" placeholder="identifiant du client"> <label class="debut" for="debut" >Date de début:</label> <input class="debut" type="Date" name="debut" id="debut"> <label class="exp" for="exp" >Date d'expiration:</label> <input class="exp" type="Date" name="exp" id="exp"> <label class="code" for="code" >Code annuelle:</label> <input class="code" type="number" name="code" id="code" placeholder="code d'installation anuelle"> <label class="doc" for="doc" >Doc de client:</label> <input class="doc" type="text" name="doc" id="doc" placeholder="document de renouvellemnet"> <label class="prix" for="prix" >Prix:</label> <input class="prix" type="number" name="prix" id="prix" placeholder="prix du service"> <label class="refv" for="refv" >Ref version:</label> <input class="refv" type="number" name="refv" id="refv" placeholder="réference de la version"> <input type="button" name="add" href="sqlinserts.php" class ="add" target="popup" value="Ajouter" onclick="window.open('add_s.html','popup','width=480,height=800'); return false;"> <button class="edit" formtarget="_blank" onclick="document.getElementById('id01').style.display='block'">Modifier</button></form> </div> </div> <script> // display selected row data into input text function selectedRowToInput() { for(var i = 1; i < table.rows.length; i++) { table.rows[i].onclick = function() { // get the selected row index rIndex = this.rowIndex; document.getElementById("ref").value = this.cells[0].innerHTML; document.getElementById("id").value = this.cells[1].innerHTML; document.getElementById("debut").value= this.cells[2].innerHTML; document.getElementById("exp").value= this.cells[3].innerHTML; document.getElementById("code").value= this.cells[4].innerHTML; document.getElementById("doc").value = this.cells[5].innerHTML; document.getElementById("prix").value = this.cells[6].innerHTML; document.getElementById("refv").value = this.cells[7].innerHTML; }; } } selectedRowToInput(); </script>
$Date_debut = date("Y/m/d", strtotime($row['Date_debut']));
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)