<?php
ini_set('display_errors',1);
 error_reporting(E_ALL);
/* MySQL Connection */
$host    = "localhost";
$user    = "cartcon";
$pwd     = "turnipcart";
$db      = "cart";
$sql_con = mysql_connect($host,$user,$pwd)
              or die("Cannot connect to MySQL");
mysql_select_db($db,$sql_con)
              or die("Cannot connect to database $db");
?>


<?php
/* Add New Product to Database */
if (strlen($_POST['prod_name']) >= 5 && is_float($_POST['prod_price']) && strlen($_POST['prod_weight']) < 4) {
   echo "Proper";
} else {
   echo "Inproper";
}
?>

<font size="6"><b>Add a New Product</b></font><hr/>
<form method="POST" action="products.php">
<b>Name:</b> <input type="text" name="prod_name" size="25" value="" />
<b>Price:</b> <input type="text" name="prod_price" size="25" value="" /><br/>
<b>Description:</b> <input type="text" name="prod_desc" size="53" value="" /><br/>
<b>Weight</b> <i>(in lbs):</i> <input type="text" name="prod_weight" size="4" value="" />
<b>Amount in Stock:</b> <input type="text" name="prod_stock" size="5" value="" /><br/>
<input type="submit" name ="action" value="Add"><hr></form>

<?php
/* Product Display */
$display_query  = "SELECT *
                   FROM prod";
$display_result = mysql_query($display_query);
?>