insert on one form

system · September 22, 2013, 2:37am

i have this form item4.php and i need to insert these items in my table, i don,t want to use 2 forms only one.
[php]<?php
session_start();
//echo"

Member only

";
?> <?php //if (session_is_registered("valid_user")) if (isset($_SESSION["name"])); { //echo "

Welcome $valid_user
"; ?>

<?php include "menu.inc"; //include this as menu ?>

<?php function new_items(){ echo "POST YOUR ITEMS HERE"; echo "Please fill in this form to post items"; echo "\n"; echo ""; echo "\n"; echo ""; echo ""; echo "\n";

    echo "<tr valign=top>\n";
    echo "<td align=right><b>Item name :</b></td>";
    echo "<td>";
    echo "    <input class=\"inputbox\" type=\"text\" name=\"item_name\">";
    echo "</td>";
    echo "</tr>\n";

    echo "<tr valign=top>\n";
    echo "<td align=right><b>Category :</b></td>";
    echo "<td>";
    echo "    <select name=\"item_cat\">";
	echo "    <option selected>Engine and performance</option>";
	echo "    <option>Wheels and chasis</option>";
	echo "    <option>Exterior and body</option>";
	echo "    </select>";
    echo "</td>";
    echo "</tr>\n";

    echo "<tr valign=top>\n";
    echo "<td align=right><b>Condition :</b></td>";
    echo "<td>";
    echo "    <input class=\"inputbox\" type=\"text\" name=\"item_cond\">";
    echo "</td>";
    echo "</tr>\n";

    echo "<tr valign=top>\n";
    echo "<td align=right><b>Price :</b></td>";
    echo "<td>";
    echo "    <input class=\"inputbox\" type=\"text\" name=\"item_price\">";
    echo "</td>";
    echo "</tr>\n";

    echo "<tr valign=top>\n";
    echo "<td align=right><b>Your name :</b></td>";
    echo "<td>";
    echo "    <input class=\"inputbox\" type=\"text\" name=\"supp_name\">";
    echo "</td>";
    echo "</tr>\n";

    echo "<tr valign=top>\n";
    echo "<td align=right><b>Your contact No :</b></td>";
    echo "<td>";
    echo "    <input class=\"inputbox\" type=\"text\" name=\"supp_cont\">";
    echo "</td>";
    echo "</tr>\n";

    echo "<tr><td colspan=2 align=center>\n";

    echo "<input type=submit name=Submit value=\"SAVE\">\n";
    //echo "<input type=reset name=Submit2 value=\"RESET\">\n";
    echo "</td></tr>\n";

    echo "</form>\n";
    echo "</table>\n";

} // end function new_items

function add_items(){
global $id,$item_name,$item_cat,$item_cond,$item_price,$supp_name,$supp_cont;

$dblink=mysql_connect(“localhost”, “root”,"") OR DIE(“Unable to connect to database”);
@mysql_select_db(“tenfifty”,$dblink) or die( “Unable to select database”);

    $query="insert into items (id,item_name,item_cat,item_cond,item_price,supp_name,supp_cont) VALUES ('$id','$item_name','$item_cat','$item_cond','$item_price','$supp_name','$supp_cont')";
    $result = mysql_query($query);

    echo "<br><br><br><center>Thank You..your item has been saved</center>\n";

} // end function add_items

switch($act) {
case “add”:
add_items();
break;

    default:
    new_items();
    break;

}

	}
	{
	
	echo "<a href =\"index.php\">Back to login</a>";
	}

?>[/php]

Id :

"; echo " "; echo "

Topcoder · September 23, 2013, 8:13pm

Is this form called “additem4.php” or “item4.php”?

Is it currently using 2 forms?