hi,

did anyone know how to create header detail transaction form in one
page and input it on the database?

for example that i created in php :

=== form_input_tr_pr.php ===
<form name="PRForm" method="post" enctype="multipart/form-data"
action="input_tr_pr.php">
    <table>
        <tr>
            <td align="center">Stock ID</td>
            <td align="center">Quantity</td>
        </tr>
        <tr id="rowID1">
            <td>
                <div align=center>
                    <select size=1 name=stock_id_1>
                        <option>-select-</option>
                            <?php
                                tambah();
                            ?>
                    </select>
                </div>
            </td>
            <td>
                <input type=text name="quantity_1" size="12"
maxlength="9"/>
            </td>
        </tr>
    </table>
    <table>
        <tr>
            <td align="right">
                <input type=submit value=Save title="Input Surat Order
Pengeluaran Barang" />
                    &nbsp;
                <input type="reset" value="Clear" title="Clear All
Data" />
            </td>
        </tr>
    </table>
</form>

=== input_tr_pr.php ===
<?php
include ('../../connectdb.php');

$date = date ("Y/m/d");

$numresults = mysql_query ("SELECT * FROM tr_pr_header WHERE date =
CURRENT_DATE()");
$numrows = mysql_num_rows ($numresults);

$no = $numrows + 1;

$statement = mysql_query ("INSERT INTO tr_pr_header (pr_no, date)
VALUES ('CA/PR/$date/$no', NOW())");
$statements = mysql_query ("INSERT INTO tr_pr_detail (pr_no, stock_id,
quantity) VALUES ('CA/PR/$date/$no', '$stock_id', $quantity)");

header ("location:view_tr_pr.php");
?>

any hints, suggestion is well appreciate, thank you so much before

Reply via email to