Insert into database help please?

fehrenbacher33 · December 12, 2009

Ok i dont know what im doing wrong here it says failed to insert data.

heres the form

<?php

echo "<html>";

echo "<title> Insert Order </title>";

echo "<head> <h1>SIU Instructional Support Services Equipment Order</h1> </head>";

echo "<body>";

echo "<form method= 'post' action='addEquipment.php'>";

echo "Equipment_Category:";

$server = "localhost";

$user = "root" ;

$pwd = "" ;

$connect = mysql_connect($server, $user, $pwd)

or die ("Error: Connection lost!");

$sel = mysql_select_db ("SIU");

if (!$sel)

exit ("Error: Could not select database!");

$sql = "SELECT * FROM Equipment";

$query = mysql_query($sql);

if (mysql_num_rows($query) == 0)

{

echo "No records found";

}

else

{

echo "<td><select name='equipment' id='equipment' size = '8'>";

while($row = mysql_fetch_object($query))

{

echo "<option Value = $row->Equip_Number>$row->Equipment_Category</option>";

}

echo "</select></td>";

mysql_close($connect);

}

echo"<p>";

echo "Product_Details: <textarea name='Product_Details' id='Product_Details' cols='25' rows='5'>";

echo "</textarea>";

echo "<p>";

echo "Equipment_Name: <input type = 'text' name ='Equipment_Name'> </input>";

echo"<p>";

echo "Comments:<textarea name='Comments' id='Comments' cols='25' rows='5'>";

echo "</textarea>";

echo "<p>";

echo "<button type ='submit' value ='Submit' name= 'Submit'> Submit";

echo "</button>";

echo "<button type ='Reset' value ='Reset' name= 'Reset' > Reset </button>";

echo "</form>";

echo "</body>";

echo "</html>";

?>

Heres php

<?php

/****************************************************

Print the content of the array POST

Use it to verify the content coming from the FORM

****************************************************/

//echo "<pre>";

//print_r($_POST);

//echo "</pre>";

/****************************************************

Assign variables with information from the array POST

****************************************************/

$Equipment_Name = $_POST['Equipment_Name'];

$Product_Details = $_POST['Product_Details'];

$Equipment_Category = $_POST['Equipment_Category'];

$Comments = $_POST['Comments'];

/****************************************************

Connect to database

****************************************************/

$server = "localhost"; // Server name

$user = "root"; // User name

$pass = ""; // Password

// Connect to MySQL

$connect = mysql_connect($server, $user, $pass)

or die( "ERROR: Connection failed!");

// Select a database to use

$sel = mysql_select_db("SIU");

if(!$sel)

exit("Error: Could not select database");

// Create the SQL command to insert data into the table student

$sql = "INSERT INTO Equipment (Equipment_Name, Product_Details, Equipment_Category, Comments) ";

$sql .= "VALUES ('$Equipment_Name','$Product_Details','$Equipment_Category','$Comments')";

// Perform Query

$query = mysql_query($sql);

$numRows = mysql_affected_rows($connect);

if($numRows > 0)

echo "<h2>New Order Inserted:</h2>";

else

echo "<h2>Fail to Add New Order</h2>";

// Close the database connection

mysql_close($connect);

?>

here is the database if needed

DROP DATABASE if exists SIU;

CREATE DATABASE if not exists SIU;

USE SIU;

CREATE TABLE EQUIPMENT (

Equip_Number INT NOT NULL,

Equipment_Name CHAR (40) NOT NULL,

Product_Details TEXT NOT NULL,

Equipment_Category CHAR(30) NOT NULL,

Comments TEXT NOT NULL,

Primary Key(Equip_Number)

)engine=innodb;

CREATE TABLE Equipment_Receipt(

Order_ID INT NOT NULL AUTO_INCREMENT,

Request DATE NOT NULL,

Pickup DATE NOT NULL,

Name CHAR(40) NOT NULL,

Buliding CHAR(30) NOT NULL,

SIU_STATUS CHAR(20) NOT NULL,

Dept CHAR (25) NOT NULL,

Dwag_Tag INT NOT NULL,

Phone INT NOT NULL,

Comments TEXT,

Equip_Number INT NOT NULL,

Primary Key(Order_ID),

Foreign Key(Equip_Number) REFERENCES EQUIPMENT(Equip_Number)

)engine=innodb;