Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <? php
- <head>
- <meta name="viewport" content="width=device-width, initial-scale=1" />
- <style type="text/css">
- .Fixed_Header thead th{
- background: lightgray;
- }
- .Fixed_Header thead th:first-of-type{
- border-top-left-radius: 10px;
- }
- .Fixed_Header thead th:last-of-type{
- border-top-right-radius: 10px;
- }
- table {
- border-collapse: collapse;
- }
- table.Fixed_Header tbody {
- border: 2px solid black;
- border-collapse: separate;
- border-spacing: 6px; }
- table.Fixed_Header tr {
- border: 2px solid black;
- border-collapse: separate;
- border-spacing: 6px; }
- </style>
- </head>
- <h1>Team Beverly Whiteboard</h1>
- <?php
- echo "as of <b>" . date("Y/m/d") . "</b><br>";
- include 'index2.php';
- $hostname = "localhost";
- $username = "root";
- $password = "hidden";
- ############## Make the mysql connection ###########
- try {
- $db = new PDO("mysql:host=$hostname;dbname=whiteboard", $username, $password);
- $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
- ////////This is the main table for Whiteboard//////////
- $count = $db->exec($sql);
- $sql = "Select * from BevWhiteboard ";
- $result = $db->query($sql);
- echo "<table class='fixed_header' width='1080'>";
- echo "<thead background='black'>";
- Echo "<th id='man' width='100px'>Employee Name</th>";
- Echo "<th class='model' width='100px'>GP</th>";
- Echo "<th class='desc' width='75px'>Activations</th>";
- Echo "<th class='ingram' width='75px'>Upgrades</th>";
- Echo "<th class='verizon' width='75px'>Smartphones</th>";
- Echo "<th class='mp' width='75px'>GP / Smart</th>";
- Echo "<th class='dpmax' width='75px'>Acc. GP / Smart</th>";
- Echo "<th class='percent' width='75px'>Pullthrough %</th>";
- Echo "<th class='netprofit' width='75px'>TMP %</th>";
- Echo "<th class='netprofit' width='75px'>Bundle %</th>";
- Echo "<th class='netprofit' width='75px'>HUM</th>";
- echo "</tr></thead>";
- echo "<tbody id='imwireless' align='center' border='1'>";
- foreach ($result as $data) {
- if($data["tmppercent"] <"70"){
- echo '
- <tr >
- <td id="man" width="100px">'.$data["Employee_Name1"].'</td>
- <td id="model" width="100px">'.$data["GP"].'</td>
- <td width="75px">'.$data["activations"].'</td>
- <td width="75px">'.$data["upgrades"].'</td>
- <td width="75px">'.$data["smartphone"].'</td>
- <td width="75px">'.$data["gp_smart2"].'</td>
- <td width="75px">'.$data["accessorygp"].'</td>
- <td width="75px">'.$data["pullthroughpercent"].'</td>
- <td width="75px" id="tmp"><font color="red">'.$data["tmppercent"].'%</td>
- <td width="75px" id="tmp">'.$data["bundlepercent"].'</td>
- <td width="75px" id="profit">'.$data["HUM_Devices"].'</td>
- ';
- }
- elseif($data["HUM_Devices"] < "1"){
- echo '
- <tr >
- <td id="man" width="100px">'.$data["Employee_Name1"].'</td>
- <td id="model" width="100px">'.$data["GP"].'</td>
- <td width="75px">'.$data["activations"].'</td>
- <td width="75px">'.$data["upgrades"].'</td>
- <td width="75px">'.$data["smartphone"].'</td>
- <td width="75px">'.$data["gp_smart2"].'</td>
- <td width="75px">'.$data["accessorygp"].'</td>
- <td width="75px">'.$data["pullthroughpercent"].'</td>
- <td width="75px" id="tmp">'.$data["tmppercent"].'%</td>
- <td width="75px" id="tmp">'.$data["bundlepercent"].'</td>
- <td width="75px" id="profit"><font color="red">'.$data["HUM_Devices"].'</td>
- ';
- }
- else{
- echo '
- <tr >
- <td id="man" width="100px">'.$data["Employee_Name1"].'</td>
- <td id="model" width="100px">'.$data["GP"].'</td>
- <td width="75px">'.$data["activations"].'</td>
- <td width="75px">'.$data["upgrades"].'</td>
- <td width="75px">'.$data["smartphone"].'</td>
- <td width="75px">'.$data["gp_smart2"].'</td>
- <td width="75px">'.$data["accessorygp"].'</td>
- <td width="75px">'.$data["pullthroughpercent"].'</td>
- <td width="75px" id="profit">'.$data["tmppercent"].'%</td>
- <td width="75px" id="profit">'.$data["bundlepercent"].'</td>
- <td width="75px" id="profit">'.$data["HUM_Devices"].'</td>
- ';
- }
- }
- echo "</tr></tbody></table>";
- //echo 'entry succesfull';
- $db = null; // close the database connection
- }
- catch(PDOException $e) {
- echo $e->getMessage();
- }
- ///////// END MAIN TABLE/////////////////////////
- ?>
- <style type="text/css">
- .copywrite {
- position: fixed;
- bottom: 0;
- width: 100%;
- text-align: center;
- border: 3px solid white;
- }
- </style>
- <div class="copywrite">
- © IMWireless <?php echo date("Y");?>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment