submit button doesn´t work!!

Codewalkers Forums Sponsor:

June 11th, 2003, 12:47 PM

beeman81

Join Date: Apr 2007

Location: Jakobstad, Finland

Posts: 59

Time spent in forums: < 1 sec
Reputation Power: 2

submit button doesn´t work!!

Why does the submit button not work?
when I run the file (user_add.php) this message shows up (before the form):
Notice: Undefined variable: submit in C:WebsitesphpsitephpB6.tmp on line 2

I used php for the first time 2 days ago, so look out for dumb mistakes!!

the code (focus on the submit button!):

php Code:

Original - php Code

<?php
   if ($submit)
      {
         include("db_conn.php");
         include("kjellmantest.php");

$query = "INSERT INTO forsale (`make`,`model`,`useage`,`price`)
          VALUES ('$make', '$model', '$useage', '$price')";
         $result = mysql_query($query) or die("Error in query. "  .mysql_error());
      }
// if the form hasn't been submitted we need to display it
   else
      {
// here is the form
?>
   <h1>Machines</h1>
   <form class="cent" action="<?php PHP_SELF ?>" method="post">
     <table class="form" width="70%" border="0" cellpadding="0" cellspacing="0">
        <tr>
           <td colspan="2">
              Please Enter the Details<br>
           </td>
        </tr>
        <tr>
           <td>
              <br>
              make
           </td>
           <td>
              <br>
              <input type="Text" name="make">
              <br>
           </td>
        </tr>
        <tr>
           <td>
              <br>
              model
           </td>
           <td>
              <br>
              <input type="Text" name="model">
              <br>
           </td>
        </tr>
        <tr>
           <td>
              <br>
              useage
           </td>
           <td>
              <br>
              <input type="Text" name="useage">
              <br>
           </td>
        </tr>
        <tr>
           <td>
           <br>
              price
           </td>
           <td>
              <br>
              <input type="Text" name="price">
              <br>
           </td>
        </tr>
        <tr>
           <td colspan="2">
           </td>
        </tr>
      <tr>
         <td colspan="2">
            <input type="submit" name="submit" value="submit">
         </td>
      </tr>
        <tr>
           <td colspan="2">

</td>
        </tr>
     </table>
   </form>
<?php
      }
?>
                        </td>
                  </tr>
               </table>
            </td>
         </tr>
      </table>
</body>
</html>

 
<?php
   if ($submit)
      {
         include("db_conn.php");
         include("kjellmantest.php");
 
         $query = "INSERT INTO forsale (`make`,`model`,`useage`,`price`)
          VALUES ('$make', '$model', '$useage', '$price')";
         $result = mysql_query($query) or die("Error in query. "  .mysql_error());
      }
// if the form hasn't been submitted we need to display it
   else
      {
// here is the form
?>
   <h1>Machines</h1>
   <form class="cent" action="<?php PHP_SELF ?>" method="post">
     <table class="form" width="70%" border="0" cellpadding="0" cellspacing="0">
        <tr>
           <td colspan="2">
              Please Enter the Details<br>
           </td>
        </tr>
        <tr>
           <td>
              <br>
              make
           </td>
           <td>
              <br>
              <input type="Text" name="make">
              <br>
           </td>
        </tr>
        <tr>
           <td>
              <br>
              model
           </td>
           <td>
              <br>
              <input type="Text" name="model">
              <br>
           </td>
        </tr>
        <tr>
           <td>
              <br>
              useage
           </td>
           <td>
              <br>
              <input type="Text" name="useage">
              <br>
           </td>
        </tr>
        <tr>
           <td>
           <br>
              price
           </td>
           <td>
              <br>
              <input type="Text" name="price">
              <br>
           </td>
        </tr>
        <tr>
           <td colspan="2">
           </td>
        </tr>
      <tr>
         <td colspan="2">
            <input type="submit" name="submit" value="submit">
         </td>
      </tr>
        <tr>
           <td colspan="2">
 
           </td>
        </tr>
     </table>
   </form>
<?php
      }
?>
                        </td>
                  </tr>
               </table>
            </td>
         </tr>
      </table>
</body>
</html>

The db_conn.php - file only includes connection to the MySql database... what the heck... here´s the code if for any use..:

php Code:

Original - php Code
<?php // variables used to open connection to the database $server = "localhost"; $user = ""; $pass = ""; $db = "kjellman"; // open connection $connection = mysql_connect($server, $user, $pass); // select database mysql_select_db($db, $connection);

 
<?php
// variables used to open connection to the database
$server = "localhost";
$user = "";
$pass = "";
$db = "kjellman";
 
// open connection
$connection = mysql_connect($server, $user, $pass);
 
// select database
mysql_select_db($db, $connection);

And the code for kjellmantest.php if needed:

php Code:

Original - php Code

 
<html>
<body>
 
<?php
 
include("db_conn.php");
 
$result = mysql_query("SELECT * FROM forsale",$connection);
 
    echo "<table border=1>n";
    echo "<tr><td>make</td><td>model</td><td>useage</td><td>price</tr>n";
 
while ($myrow = mysql_fetch_row($result))
{
      echo "<tr><td>";
      echo $myrow[0] ;
      echo "</td><td>";
      echo $myrow[1] ;
      echo "</td><td>";
      echo $myrow[2] ;
      echo "</td><td>";
      echo $myrow[3] ;
      echo "</td></tr>n";
}
echo "</table>n";
 
mysql_close($connection);
?>
 
</body>
</html>

Thanks in advance!!

June 11th, 2003, 03:00 PM

sliver

Moderator

Join Date: Apr 2007

Location: WI, USA

Posts: 906

Time spent in forums: 1 Day 1 h 18 m 35 sec
Reputation Power: 2

RE: submit button doesn´t work!!

OK you may need to replace the post variable like $submit with $_POST['submit']. Also in the user_add.php script you have:

php Code:

Original - php Code
<form class="cent" action="<?php PHP_SELF ?>" method="post">

 
<form class="cent" action="<?php PHP_SELF ?>" method="post">

when it should be:

php Code:

Original - php Code
<form class="cent" action="<?php $PHP_SELF ?>" method="post">

 
<form class="cent" action="<?php $PHP_SELF ?>" method="post">

June 12th, 2003, 05:50 AM

beeman81

Join Date: Apr 2007

Location: Jakobstad, Finland

Posts: 59

Time spent in forums: < 1 sec
Reputation Power: 2

It still doesn't work..

You wrote: "OK you may need to replace the post variable like $submit with $_POST['submit']..."

Where do I put in that?? Be more specific

June 12th, 2003, 02:33 PM

sliver

Moderator

Join Date: Apr 2007

Location: WI, USA

Posts: 906

Time spent in forums: 1 Day 1 h 18 m 35 sec
Reputation Power: 2

RE: submit button doesn´t work!!

Whereever you have variable posted through a post form you need to use them like this:

php Code:

Original - php Code
$name=$_POST['name'];

 
$name=$_POST['name'];

or whatever the name of the variable would be:

php Code:

Original - php Code
<form action=myform.php method=post> Name: <input type=text name=name><br> <input type=submit name=sub value="Submit"> </form>

 
<form action=myform.php method=post>
Name: <input type=text name=name><br>
<input type=submit name=sub value="Submit">
</form>

Myform.php:

php Code:

Original - php Code
if($_POST['sub']) { print "Hi ".$_POST['name']; }

 
if($_POST['sub']) {
   print "Hi ".$_POST['name'];
}

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: