Chapter 3 Test 2 - Code

-Insert

Chapter 3 Main

<?php

require_once '../mainfunctions.php';
printHead("3", "Chapter 3 Test 2", "Display")
?>

<div>
<!--PRINT CONFIRMATION OF DELETION or UPDATE--->
<?php 

if(isset($_GET['actionheadervardeletefromb5'])){
    echo "<p>Track ID# " . $_GET['idheadervardelete'] . " " . $_GET['actionheadervardelete'] ."....</p>";
}
if(isset($_GET['actionheadervarupdatefromb4'])){
    echo "<p>Track ID# " . $_GET['idheadervarupdate'] . " " . $_GET['actionheadervarupdate'] ."....</p>";
}

?>

<!---LINK TO INSERT PAGE--->
<a href='3.6test2insert.php'>Insert New Track</a>
<br>
<br>

<!---PRINT TABLE--->
<table><tr><th>TrackID</th><th>Name</th><th>UnitPrice</th></tr>
<?php
$conn= createConn();
    $query = "Select TrackId, Name, UnitPrice FROM Track WHERE genreId=1 AND MediaTypeId=2";
    $result = mysqli_query($conn,$query);

if (!$result){
    die(mysqli_error($conn));
}


if (mysqli_num_rows($result)>0){
    while ($row=mysqli_fetch_assoc($result)){?>

    <tr><td> <?php echo $row['TrackId']?> </td>
    <td align='center'> <?php echo $row['Name']?> </td>
    <td> <?php echo $row['UnitPrice']?> </td>
    <td><a href='3.6test2update.php?idLinkVarFromb2=<?php echo $row['TrackId']?>'>Update</a></td>
    <td><a href='3.6test2delete.php?idLinkVarFromb2=<?php echo $row['TrackId']?>'>Delete</a></td></tr>
    
<?php    
    }
}

?>
</table>
</div>

<?php 
printFootWithCodeExample('3.6test2displaycode.php');
?>

BACK