<?php
include 'includes/dash_header.php';
include 'includes/dash_links.php';



?>

<div class="span8">
                    <div class="row-fluid">
                      <div class="span9">

                        <?php
                          include 'includes/db_connection.php';

                          if (isset($_POST['recharge_code'])){
                            $recharge_code = $_POST['recharge_code'];
                            if (!empty($recharge_code)) {
                              
                              if (strlen($recharge_code) == 16) {

                                $query = "SELECT * FROM `credit_cards` WHERE `Card_num` = $recharge_code ";
                                $result = mysql_query($query);
                                $count = mysql_num_rows($result);
                                $row = mysql_fetch_array($result); 

                                if ($count == 1) {
                                  
                                  if ($row['Validity'] == true) {
                                    $credit_value = $row['Card_Credit'];
                                    $phoneNumber = $_SESSION['phoneNumber'] ; 
                                    $query = "SELECT * FROM `user_information` WHERE `cus_num` = $phoneNumber ";
                                    $result = mysql_query($query);
                                    $row = mysql_fetch_array($result);
                                    $old_credit = $row['Credit'];
                                    $new_credit = $credit_value + $old_credit ; 

                                    $update_query = "UPDATE `user_information` 
                                                     SET `Credit`= $new_credit 
                                                     WHERE `cus_num` = $phoneNumber";

                                    $update_result = mysql_query($update_query);

                                    if ($update_result) {
                                      echo "<h4><img src='img/success.png' />"."Your Credit Has Been Updated</h4>";
                                      echo "<p><a href='check_credit.php'>". "Check Your Credit Now" . "</a></p>";
                                      $new_validity = 0 ;
                                      $update_query = "UPDATE `credit_cards` 
                                                     SET `validity`= $new_validity 
                                                     WHERE `Card_num` = $recharge_code ";
                                      $update_validity = mysql_query($update_query);
                                    }

                                  }else{
                                    echo "<h4><img src='img/error.png' />"."This Card Not Valid</h4>";
                                  }

                                }else{
                                  echo "<h4><img src='img/error.png' />"."Card numbers Not Exist</h4>";
                                }



                            
                              }else{
                                echo "<h4><img src='img/error.png' />"."Cards numbers Should Be 16 numbers </h4>";
                              }
                              


                            }else{
                              echo "<h4><img src='img/error.png' />"."Please Recharge code Please</h4>";
                            }
                          }

                        ?>

                      	    <form method="post" action="recharge_credit.php">
                               <fieldset>
                                  <legend>Recharge Your Credit</legend>

                                      <label>Enter Recharge Code Here</label>
                                         <input type="text" placeholder="Recharge Code" name="recharge_code">
                                            <br>
                                            <input type="submit" name="Rcharge" value="Recharge" class="btn btn-info">
                               </fieldset>
                            </form>

                      </div>

<?php
include 'includes/dash_footer.php';
?>

