I Want To Break Free

Editando: fund_transfer.php

<?php
$page = 'Fund Transfer';
$page_icon = "";
//$employee = "active";
include("check.php");
include 'header.php';

if (@$_REQUEST['btn_add']) {

$ac_id = $_POST['ac_id'];
    $b_ac_id = $_POST['b_ac_id'];
    $payment_date = $_POST['payment_date'];
    $amounts = $_POST['amounts'];
    $status = "Debit";

$select_ac2 = mysql_query("select * from account where id='$b_ac_id'");
    while ($row2 = mysql_fetch_array($select_ac2)) {
        $beneficial = $row2['bank_name'] . ' - ' . $row2['holder_name'];
    }
    $select_ac3 = mysql_query("select * from account where id='$ac_id'");
    while ($row3 = mysql_fetch_array($select_ac3)) {
        $beneficial1 = $row3['bank_name'] . ' - ' . $row3['holder_name'];
    }

$insert = mysql_query("insert into co_accounts(bank_ac_id,payment_date,narration,amounts,status,cdate) "
            . "values('$ac_id','$payment_date','$beneficial','$amounts','$status','$date')");
    if (!$insert) {
        $_SESSION['msg'] = "Something is wrong..Please try again..";
        $_SESSION['type'] = "Error";
    } else {
//        $c_acount_id = mysql_insert_id();
        $status_emp = "Credit";

$insert = mysql_query("insert into co_accounts(bank_ac_id,payment_date,narration,amounts,status,cdate) "
                . "values('$b_ac_id','$payment_date','$beneficial1','$amounts','$status_emp','$date')");

$_SESSION['msg'] = "Sucessefully inserted record..";
        $_SESSION['type'] = "Success";
    }
    echo '<script>window.location="fund_transfer.php";</script>';
}
?>

<div class="page-content-wrap"> 
    <div class="row"> 
        <div class="col-md-12"> 
            <div class="panel panel-colorful">
                <div class="panel-heading ui-draggable-handle modal-header">                                
                    <h3 class="panel-title">Fund Transfer</h3>
                    
                    <ul class="panel-controls" style="margin-right: 5px;">
                        <li><a href="#" class="panel-refresh"><span class="fa fa-refresh"></span></a></li>
                    </ul>
                </div>
                <form  method="post" enctype="multipart/form-data" class="form-horizontal" role="form">
                    <div class="panel-body">
                        <div class="row"> 
                            <div class="col-md-6"> 
                                <div class="block">
                                    <div class="form-group">
                                        <label class="col-md-4 control-label">Select Bank Name</label>
                                        <div class="col-md-8">                                    
                                            <select name="ac_id" class="form-control select" data-live-search="true" required="">
                                                <option disabled="" selected="">Select Bank Name</option> 
                                                <?php
                                                $select_ac = mysql_query("select * from account");
                                                while ($row = mysql_fetch_array($select_ac)) {
                                                    ?>
                                                    <option value="<?php echo $row['id']; ?>"><?php echo $row['bank_name'] . ' - ' . $row['holder_name']; ?></option>     
                                                    <?php
                                                }
                                                ?>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-md-4 control-label">Select Beneficial Bank</label>
                                        <div class="col-md-8">                                  
                                            <select name="b_ac_id" class="form-control select" data-live-search="true" required="">
                                                <option disabled="" selected="">Select Beneficial Bank Name</option>     
                                                <?php
                                                $select_ac1 = mysql_query("select * from account");
                                                while ($row1 = mysql_fetch_array($select_ac1)) {
                                                    ?>
                                                    <option value="<?php echo $row1['id']; ?>"><?php echo $row1['bank_name'] . ' - ' . $row1['holder_name']; ?></option>     
                                                    <?php
                                                }
                                                ?>
                                            </select>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-6"> 
                                <div class="block"> 
                                    <div class="form-group">
                                        <label class="col-md-4 control-label">Payment Date</label>
                                        <div class="col-md-8">
                                            <input name="payment_date" id="datepicker" style="background-color: #F9F9F9;" value="" required="" type="text" class="form-control datepicker" />
                                        </div>
                                    </div> 
                                    <div class="form-group">
                                        <label class="col-md-4 control-label">Amounts</label>
                                        <div class="col-md-8">
                                            <input name="amounts" value="" onkeypress="return onlyNos(event, this);" required="" type="text" class="form-control" />
                                        </div>
                                    </div> 
                                </div>
                            </div>
                        </div> 
                    </div>
                    <div class="panel-footer">
                        <div class="row"> 
                            <div class="col-md-12 text-center">
                                <div class="form-group">
                                    <input type="submit" class="btn btn-primary" name="btn_add" value="Transfer" />
                                    <button type="reset" class="btn btn-info">Reset</button>
                                </div> 
                            </div> 
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>
 
<?php
include("footer.php");
?>

Cancelar