Transferring contents of tables and parsing variab

2019-09-02 02:56发布

站内问答 / PHP
1432 0 4

Problem: I need to transfer all the files from the table invoicesub to another table called displaybilling in invoicesubmitfinal page and then delete all the contents inside invoicesub. Then, i need to parse in the total_amt variable and paid variable as well as the customer name variable(cname) to a 4th page. How do i go about doing these 2 things?

Create Invoice: This is a form that takes allows the admin to add in more rows of description, quantity, amount, discount. All values keyed in as there is more than 1 row is put inside an array and then parsed to invoice submit page.

invoice submit: This page loops all the arrays and insert them into the table called invoicesub.

invoicesubmitfinal: This page shows all the rows from the table invoicesub in a table form and calculate the sum of the total variable as total_amt which is then shown at the bottom after all the rows that were on the first page are displayed.

Create_Invoice

<script type="text/javascript">

var count = 0;


function addTextArea(){
count= count+1;
var div = document.getElementById('name');
div.innerHTML += "<div> <input type='text' name='name[]' value='' "+"id=name"+count+"> </div>";
div.innerHTML += "\n<br />";
var div = document.getElementById('quantity');
div.innerHTML += "<div><input type='text' name='quantity[]' value ='' "+"id=quantity"+count+"></div>";
div.innerHTML += "\n<br />";
var div = document.getElementById('amount');
div.innerHTML += "<div><input type='text' name='amount[]'  value ='' "+"id=amount"+count+"></div>";
div.innerHTML += "\n<br />";
var div = document.getElementById('discount');
div.innerHTML += "<div><input type='text' name='discount[]'  value ='' "+"id=discount"+count+"></div>";
div.innerHTML += "\n<br />";
}

function removeTextArea(){
document.getElementById("name"+count).remove();

document.getElementById("quantity"+count).remove();

document.getElementById("amount"+count).remove();

document.getElementById("discount"+count).remove();
count = count-1;
}

</script>


</head>

<body>

<form  action="invoicesubmit.php" method="POST">
<?php
echo "<table border='2'>\n"; 
echo "<tr>\n"; 
echo "<th>Description</th>\n"; 
echo "<th>Quantity</th>\n"; 
echo "<th>Amount($)</th>\n";
echo "<th>Discount(%)</th>\n";
echo "</tr>"; 

echo "<tr>";
echo "<td>"?><input type='text' size="50" name='name[]' value='Examination and Consultation' readonly/><?php "</td>";
echo "<td>"?><input type='text' size="50" name='quantity[]' value='' /><?php "</td>";
echo "<td>"?><input type='text' size="50" name='amount[]' value='' /><?php "</td>";
echo "<td>"?><input type='text' size="50" name='discount[]' value='' /><?php "</td>";
echo "</tr>";

echo "<tr>"; 
echo "<td>"?><div id="name"></div> <?php "</td>"; 
echo "<td>"?><div id="quantity"></div> <?php "</td>"; 
echo "<td>"?><div id="amount"></div> <?php "</td>"; 
echo "<td>"?><div id="discount"></div> <?php "</td>"; 
echo "</tr>";
?>
Customer Name:
<br />
<input type="text" name="cust_name" value="" /> &nbsp;
<br />
<input type="button" value="Add Description" onClick="addTextArea();"> &nbsp;


<input type="button" value="Remove Description" onClick="removeTextArea();"> &nbsp;
<input type="submit" name="submit" value="submit">

</form>

</body>

InvoiceSubmit

<?php
echo "<table border='1'>\n";
echo "<tr>\n";
echo "<th>Description</th>\n";
echo "<th>Quantity</th>\n";
echo "<th>Amount($)</th>\n";
echo "<th>Discount(%)</th>\n";
echo "<th>Total_amt</th>\n";
echo "</tr>";

if (isset($_POST['submit'])){ // Process the form
    $name_array = $_POST['name'];
    $quantity_array = $_POST['quantity'];
    $amount_array = $_POST['amount'];
    $discount_array = $_POST['discount'];
    $cust_name_array = mysql_prep( $_POST['cust_name']);
    for ($i = 0; $i < count($name_array); $i++){
        $cust_name = $cust_name_array;
        $name = $name_array[$i];
        $quantity = $quantity_array[$i];
        $amount = $amount_array[$i];
        $discount = $discount_array[$i];
        $total_amt = ($amount - ($amount * ($discount / 100))) * $quantity;




            echo "<tr>";
            echo "<td>" . $name . "</td>";
            echo "<td>" . $quantity . "</td>";
            echo "<td>" . "$" . $amount . "</td>";
            echo "<td>" . $discount . "%" . "</td>";
            echo "<td>" . "$" . $total_amt . "</td>";
            echo "</tr>";

            global $connection;
            $query = "INSERT INTO invoicesub (";
            $query.= " cust_name, description, quantity, amount, discount, total";
            $query.= ") VALUES (";
            $query.= " '{$cust_name}', '{$name}', {$quantity}, {$amount}, {$discount}, {$total_amt}";
            $query.= ")";

            $result = mysqli_query($connection, $query);


        }


            }




           redirect_to("invoicesubmitfinal.php?cname=".urlencode($cust_name));

        }


?>

InvoiceSubmitFinal

echo "<table border='1'>\n";
echo "<tr>\n";
echo "<th>Services Rendered</th>\n";
echo "<th>Quantity</th>\n";
echo "<th>Price($)</th>\n";
echo "<th>Discount(%)</th>\n";
echo "<th>Amount</th>\n";
echo "</tr>";

$cname = $_GET["cname"];

global $connection;

$sql1="SELECT description,quantity, amount, discount, total, SUM(total) as sumtotal FROM invoicesub WHERE cust_name='$cname' GROUP BY description ORDER BY id";
$result2 = mysqli_query($connection, $sql1) or die(mysqli_error($connection));


echo $count;
while ($rows = mysqli_fetch_array($result2)){
            echo "<tr>";
            echo "<td>" . $rows['description'] . "</td>";
            echo "<td>" . $rows['quantity'] . "</td>";
            echo "<td>" . $rows['amount'] . "</td>";
            echo "<td>" . $rows['discount']. "%" . "</td>";
            echo "<td>" ."$". $rows['total']  . "</td>";
            echo "</tr>";



          }         
          echo "</table>";
          ?>





          <?php
          $sql1="SELECT SUM(total) as total_amt FROM invoicesub WHERE cust_name='$cname'";
$result3 = mysqli_query($connection, $sql1) or die(mysqli_error($connection));

          while ($rows = mysqli_fetch_array($result3)){

          echo "<tr>";
          echo "<td>". "Total Amount:" ."$". $rows['total_amt']  . "</td>";
          echo "</tr>";

          echo "<form action=\"4thpage.php\" method=\"POST\">";
          echo "<input type=\"hidden\" name=\"total_amt\"/>";
          echo "Customer Paid:";
          echo "<input type=\"text\" name=\"paid\" value=\"\"/>";
          echo "<br />";
          echo "<input type=\"submit\" name=\"submit\" value=\"Submit\"/>";
          echo "<input type=\"button\" value=\"Cancel\" onclick=\"window.location='manage_content.php';\"/>";
          echo "</form>";

          }

标签： php forms mysqli
举报
0条回答
登录 后发表回答
相关问题
查看全部
相关文章
查看全部
收藏的人(4)