Click here to Skip to main content
15,891,248 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
when i select a table row all the value displayed correctly in the inputs but the date still empty idk why

What I have tried:

 <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>
Posted
Updated 31-Oct-21 1:13am
Comments
CHill60 28-Oct-21 8:25am    
Which date is blank? Debut or Exp or both?

1 solution

make a separate variable with $date_debut like so
$Date_debut = date("Y/m/d", strtotime($row['Date_debut']));
then echo $Date_debut for the correct time format.
 
Share this answer
 
v4

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900