insert values from form!!

Anon

Hi guys!! i wonder if you can give me any help..i am new in databases.
i use ZEND(zend.com) software and i created a simple database.i have one table with 3 variables(TERMID,TERM,Soundex)

i created that tables i know how to insert values in it from my code but i dont know how to insert values from a form in site.

I have created a page and a small form which says.."please enter a word"
i want to add a new word and this form to add it in the table in the TERMID variable..

how can i do that...
i have some code that i make but it seems is not working!!

please help me!!

thank you!!

Anon

hi,

make form with texts fields like your variable names, and PHP codu should look somehing like this:

$TERMID = doubleval($TERMID);
$TERM = addslashes($TERM);
$Soundex = addslashes($Soundex);

@ $db = mysql_pconnect("localhost", "max", "jazz12");

if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db("your_db");

$query = "INSERT INTO your_table (TERMID,TERM,Soundex) VALUES ('".$TERMID."', '".$TERM."')";

$result = mysql_query($query);

if($result)
{
echo mysql_affected_rows(). " record inserted.";

}
mysql_close($db);

Max

Anon

sorry here is the code agin.

$TERMID = doubleval($TERMID);
$TERM = addslashes($TERM);
$Soundex = addslashes($Soundex);

@ $db = mysql_pconnect("localhost", "user", "pass");

if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db("your_db");

$query = "INSERT INTO your_table (TERMID, TERM, Soundex) VALUES ('".$TERMID."', '".$TERM."', '".$Soundex."')";

$result = mysql_query($query);

if($result)
{
echo mysql_affected_rows(). " record inserted.";

}
mysql_close($db);

Anon

$query = "INSERT INTO your_table (TERMID, TERM, Soundex) VALUES ('".$TERMID."', '".$TERM."', '".$Soundex."')";

You don't need to use all the double quotes, this will work just as well and is easier to read.

$query = "INSERT INTO your_table (TERMID, TERM, Soundex) VALUES ('$TERMID','$TERM','$Soundex')";

Anon

thank you, i will try my best

Anon

<BODY>
<H1>LexiconDB</H1>

<?php
$link = mysql_connect();
mysql_drop_db("LexiconDB",$link);
mysql_create_db("LexiconDB",$link);
mysql_select_db("LexiconDB",$link);

$query = "CREATE TABLE english
(
TermID INTEGER NOT NULL,
Term VARCHAR(32) NOT NULL,
soundex VARCHAR(32)
);";

if(!mysql_query($query,$link))
{
echo "false";
}

function Insert_Value($TermID_var,$Term_var,$link)
{

$soundex_var = soundex($Term_var);


$query = "INSERT INTO english
VALUES ('$TermID_var','$Term_var','$soundex_var');";

$result=mysql_query($query);


if($result)
{
echo mysql_affected_rows()."record inserted.";
}
mysql_close($LexiconDB);

}

//Insert_Value(1,"salinity",$link);

echo'
<FORM METHOD ="POST" ACTION="Insert_Value($TermID_var)">
<DIV ALIGN="center"><CENTER>
<H2>Please enter a new word:<INPUT TYPE="text" NAME="term" SIZE="20"></P></H2>

if($REQUEST_METHOD=="POST")

{
Insert_Value(1,"salinity",$link);

}

</BODY>

This is my code. When i try to insert the certain word in my form i get an error page from the browser and an empty database.
what could be wrong???