on upload file it get submitted.and submit button show no reaction

[kkshansid]

i require following steps

• browse file
• click upload button to display csv file
• then if user finds csv correct he may submit form for update of mysql data

i want to update mysql with csv file but on upload file it get submitted.and submit button show no reaction on click

<?php
$db = mysql_connect("localhost", "root", "") or die("Could not connect.");
if(!$db) 
die("no db");
if(!mysql_select_db("asdf",$db))
die("No database selected.");
$handle = fopen('school.csv', "r");
$firstRow = true;
?>
<form enctype="multipart/form-data" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>" method="post">
File to sql:<br />
<input size='30' type='file' name='filename'>
<input type="submit" name="upload" value="Upload"></form>
<?php
if (isset($_POST['upload'])) { 
    if (is_uploaded_file($_FILES['filename']['tmp_name'])) {
            echo "<table border='1'>";
            while (($data = fgetcsv($handle, ",")) !== FALSE) {
               echo "<tr><td>".$data[0]."</td><td>".$data[1]."</td><td>".$data[2]."</td><tr/>";
         }
      echo "</table>";    
      ?>
      <input type="submit" name="submit"  value="Submit">
       <?php
   }}
   ?>
   </form>
   <?php
   if (isset($_POST['submit'])) { 
   echo "submit clicked";
   }
        ?>
 
 
 

[Oralloy]

I'm not PHP expert, but it sounds like your "if (isset($_POST['upload']))" is not executing.

Try building a loop that prints all values in the _POST array above the form. Verify that the values are what you expect them to be.