input form doesn't work

[mrsrands]

I am having a problem spotting an error in my coding. There are no parse errors, the include of config.php works and connects to the database fine. When you enter data and click submit, nothing is submitted, the page is merely refreshed. Can anyone spot the error for me?

?>
<div>
 <form action="index.php" method="post">
    <b>Contributing Organization</b>
    <input type="text" name="contributing_org" size="150">
    <b>Address</b>
    <input type="text" name="org_address" size="120">
    <b>City</b>
    <input type="text" name="org_city" size="100">
    </br>
    <b>State</b>
    <input type="text" name="org_state" size="8">
    <b>Zip</b>
    <input type="int" name="org_zip" size="20">
    <b>Phone</b>
    <input type="int" name="org_phone" size="50">
    </br>
    <b>Email (optional)</b>
    <input type="text" name="org_email" size="50">
    </br></br>
    <b>Contact Person</b>
    <input type="text" name="org_contact" size="150">
    <b>Contact Address</b>
    <input type="text" name="cont_address" size="120">
    <b>City</b>
    <input type="text" name="cont_city" size="100">
    </br>
    <b>Zip</b>
    <input type="int" name="cont_zip" size="20">
    <b>Phone</b>
    <input type="text" name="cont_phone" size="50">
    </br>
    <b>Email (optional)</b>
    <input type="text" name="cont_email" size="50">
    </br></br>
    <b>Receiving Committee</b>
    <input type="text" name="rec_comm" size="150">
    <b>Committee Address</b>
    <input type="text" name="comm_add" size="120">
    <b>City</b>
    <input type="text" name="comm_city" size="100">
    </br>
    <b>Zip</b>
    <input type="int" name="comm_zip" size="20">
    <b>Phone (optional)</b>
    <input type="int" name="comm_phone" size="50">
    </br>
    <b>Email (optional)</b>
    <input type="text" name="comm_email" size="50">
    </br> </br>
    <b> Date of Contribution</b>
    <input type="date" name="cont_date" size="20">
    <b> Amount of Contribution</b>
    <input type="decimal" name="cont_amt" size="20">
    </br>
    <b> Description of contribution (if in kind)</b>
    <input type="text" name="inkind_descrip" size="120">
    <b>County  (if applicable)</b>
    <input type="text" name="county" size="100">
    </br>
    <b>Date of election</b>
    <input type="date" name="election_date" size="20"
    </br></br> </p>
    <INPUT TYPE="SUBMIT"="comm" VALUE="Submit">
    </form></div></span>

<?php include('C:\apache\htdocs\contributions\config.php');
if($comm!=''){
$db=mysql_connect($database['HOST'],$database['USER'],$database['PASS'])
or die(mysql_error()); mysql_select_db($database['DBNM'],$db) or die(mysql_error());
}

if($comm=='Submit'){
if(mysql_query ("INSERT INTO `otc`(`contributing_org`,`org_address`,`org_city`,`org_state`,
`org_zip`,`org_phone`,`org_email`, `org_contact`,`cont_address`, `cont_city`, `cont_zip`,
`cont_phone`,`cont_email`,`rec_comm`,`comm_add`,`comm_city`, `comm_zip`,`comm_phone`,`comm_email`,
`cont_date`,`cont_amt`,`inkind_descrip`,`county`,`election_date`),

VALUES('$contributing_org','$org_address','$org_city','$org_state','$org_zip',
'$org_phone','$org_email', '$org_contact','$cont_address','$cont_city', 
'$cont_zip','$cont_phone','$cont_email','$rec_comm','$comm_add','$comm_city',
'$comm_zip','$comm_phone', '$comm_email','$cont_date','$cont_amt','$inkind_descrip',
'$county','$election_date')",

$db)){
echo "Thank you for filing electronically!";
} else {
echo "Insert Failed?";

}
if(isset($_POST['submit'])){
if(trim($_POST['contributing_org'])==''){
echo "You forgot your organization's name!";
die("could not process");
                }

if(trim($_POST['org_contact'])==''){
echo "You forgot your contact person!";
die("could not process");
                }
if(trim($_POST['cont_address'])==''){
echo "You forgot the contact address!";
die("could not process");
                }
if(trim($_POST['cont_phone'])==''){
echo "You forgot the contact phone number!";
die("could not process");
                }
if(trim($_POST['rec_comm'])==''){
echo "You forgot the receiving committee name!";
die("could not process");
                }
if(trim($_POST['cont_date'])==''){
echo "You forgot the date of contribution!";
die("could not process");
                }
if(trim($_POST['cont_amt'])==''){
echo "You forgot the amount of the contribution!";
die("could not process");
                }

            }

} else {
}
?>

Thanks!!!

[leatherback]

Hi,

What is $comm and where does it get set?

I think you need to add a line: if (isset ($POST['comm'] )){$comm = $POST['comm']};

You check if ($comm != '')
and you check if ($comm = 'Submit'
But if $comm = '' you do nothing.

It looks to me like you need to set $com somewhere perhaps?

If this is not the problem, please post again, and I will have a closer look at the code.

J.

[thessoro]

you may want to correct this ->
<INPUT TYPE="SUBMIT"="comm" VALUE="Submit">

if not, you could try echoing your db_query.
Instead of : mysql_query ("Select blablabla....",$link);
you could try:
$query="blablabla";
echo $query // for debugging purposes
mysql_query ($query,$link);

[leatherback]

Thessoro is right: The submit button is also wrong. You should make that :
<INPUT TYPE="SUBMIT" name="comm" VALUE="Submit">

(In addition to the other suggestion I made above)

[mrsrands]

I changed input form button as suggested.

I also tried to put in isset on com, but got parse error. "comm"=submit (or communication) so if comm='', or is missing a required field, it should error out.

Should I remove the "com" altogether? and work with just $POST and "submit"?

All new to me and I was coding from an example from my "mentor", who isn't available anymore.😕

[leatherback]

Hi,

To check wether a form has been submitted, I usually add a hidden entry:

<submit type="hidden" name="form1" value="check">

Then, in the code, you can test: If(isset($post['form1'])) and ($POST['form1'] = 'check')) do bladiebladieblaa

J.

[mrsrands]

Okay,

I changed the code from the submit button to just before the if isset trim

it now reads:

if($comm!=''){
$db=mysql_connect($database['HOST'],$database['USER'],$database['PASS'])
or die(mysql_error()); mysql_select_db($database['DBNM'],$db) or die(mysql_error());
}

if($comm=='Submit'){
if(mysql_query ("INSERT INTO `otc`(`contributing_org`,`org_address`,`org_city`,`org_state`,
`org_zip`,`org_phone`,`org_email`, `org_contact`,`cont_address`, `cont_city`, `cont_zip`,
`cont_phone`,`cont_email`,`rec_comm`,`comm_add`,`comm_city`, `comm_zip`,`comm_phone`,`comm_email`,
`cont_date`,`cont_amt`,`inkind_descrip`,`county`,`election_date`),

VALUES('$contributing_org','$org_address','$org_city','$org_state','$org_zip',
'$org_phone','$org_email', '$org_contact','$cont_address','$cont_city', 
'$cont_zip','$cont_phone','$cont_email','$rec_comm','$comm_add','$comm_city',
'$comm_zip','$comm_phone', '$comm_email','$cont_date','$cont_amt','$inkind_descrip',
'$county','$election_date')",

$db)){
echo "Thank you for filing electronically!";
} else {
echo "Insert Failed?";
}{
if(isset($_POST['submit']))
echo "nothing submitted";{

..the echo "Insert Failed" comes back upon submission....

should I try to do a query on the INSERT INTO otc and the Value $"?

[thessoro]

i just don't understand your code
you say:

if ($comm!='') connect to the database;
if ($comm=="Submit") do the query;

if (isset ($_POST['submit'])) echo "nothing submitted"; (¿¿¿???)

$comm can't be nothing and "submit" at the same time, so when you try to do the query you might not be connected to the database...

try this instead:

if ($_POST['comm'])  {
     $error=false;
     if (!$_POST['field1']) $error="you have to fill the field number one";
     if (!$_POST['field2']) $error="you have to fill the field number two";
     if (!$_POST['field3']) $error="you have to fill the field number three";

 if (!$error) {

      connect to the database;
      do the query;
 }
 else echo $error;
}

if (!$_POST['comm'] || $error) {

 echo the whole form here

}

[mrsrands]

I am willing to try...wish I knew more about what I am doing!!

😕

Thanks!!

[mrsrands]

I want to thank you all!!! The code is working great!!!

😃