Untitled

 avatar
unknown
plain_text
5 months ago
1.7 kB
2
Indexable
create table product(itemcode varchar(5),itemname varchar(15),unit price varchar(10));

<!-- html file (product.html) -->
<html>
    <body align="center">
        <h1>Product Details</h1><br><br>

        <form action="prod_details.php" method="get">
            Item Code:
            <input type="text" name="icode"><br><br>

            Item Name:
            <input type="text" name="iname"><br><br>

            Unit Price:
            <input type="text" name="unitprice"><br><br>

            <input type="submit" value="ADD"
        </form>
    </body>
</html>

<!-- PHP file(prod_details.php) -->

<?php
    $code=$_GET['icode'];
    $name=$_GET['iname'];
    $unit=$_GET['unitprice'];

    $dbconn=pg_connect("host=localhost port=5433 dbname=postgres user=postgres user=postgres password=devagiri");

    if($db){
        $iqry="insert into product value('$code','$name','$unit')";

        $insert=pg_query($dbconn,$iqry);

        $qry="select *from product";

        $select=pg_query($dbconn,$qry);

        echo"<body>
        <center>
            <h1>Product Details</h1>
        </center>";

        echo "<br><br>
        <table border="2" align="center" width="50%"> ";

        echo"<tr>
                <th>Product Code</th>
                <th>Prodcut Name</th>
                <th>Unit Price</th>
            </tr>";

        while($row=pg_fetch_row($select)){
            echo"<tr>";
            echo"<td>$row[0]</td>";
            echo"<td>$row[1]</td>";
            echo"<td>$row[2]</td>";
            echo"</tr>
        }
        echo"</table></body>";
    }
    ?>
Editor is loading...
Leave a Comment