Why is the feedback form is not submmiting

[Mitturu sudhi]

hi

i have created a feedback form , its working on wamp server but in online its not posting data to database. here am providing code please someone help me.

Feedback.php

<script language="javascript" type="text/javascript">
function validate(nm, eml, fdk, ph)
{
   var name = document.getElementById(nm);
   var email = document.getElementById(eml);
   var feedback = document.getElementById(fdk);
   var phone = document.getElementById(ph);
   if (name.value == "")
   {
      alert("Please Enter Your Name..!");
      name.focus();
      return false;
   }
   if (email.value == "")
   {
      alert("Please Enter Email-id..!");
      email.focus();
      return false;
   }
   var emailRe = /^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*\.(\w{2}|(com|net|org|edu|int|mil|gov|arpa|biz|aero|name|coop|info|pro|museum))$/
   var phone = /^((\+\d{1,3}(-| )?\(?\d\)?(-| )?\d{1,5})|(\(?\d{2,6}\)?))(-| )?(\d{3,4})(-| )?(\d{4})(( x| ext)\d{1,5}){0,1}$/
   // var phoneRe = /^\d{10}(-)/
   if ( ! emailRe.test(email.value))
   {
      alert('Email-id Is Invalid');
      return false;
   }
   if (phone.value = "")
   {
      if ( ! phoneRe.test(phone.value))
      {
         alert('Phone Number Is Invalid');
         return false;
      }
   }
   if (feedback.value == "")
   {
      alert("Please Enter Your Feedback..!");
      feedback.focus();
      return false;
   }
}
 
    </script>
 
<form name="testform" method="post"action="submited.php">
 
Neme:<input type="text" name="name" id="name" maxlength="30" size="30" tabindex="1"/>
 
email<input type="text" name="email" id="email" maxlength="34" size="30" tabindex="3"/>
 
Feedback:<textarea name="feedback" rows="7" cols="24" id="feedback"  tabindex="4"></textarea>
 
Phone No:<input type="text" name="contactno" id="phone" maxlength="11" size="30" tabindex="2"/>
 
<input name="Submit" value="Submit" onclick="return validate('name','email','feedback','phone');"  type="submit" tabindex="5"/>
 
 
</form>
 
 

Submited.php

<?php
        // opening connection
                    $conn=mysql_connect("localhost","root","");
        //  getting database to use
                        mysql_select_db("school",$conn);
        // Sql statements
                $Name=$_POST["name"];
                $Contactno=$_POST["contactno"];
                $Emailid=$_POST["email"];
                $Feedback=$_POST["feedback"];
    $sql="INSERT INTO feedback values('','$Name','$Contactno','$Emailid','$Feedback')";
        // execute statements
                $result=mysql_query($sql,$conn);    
                if($result==1)
                    echo"<font color=black face=Verdana, Arial, Helvetica, sans-serif style=font-size:12px>";
                    echo"Thanks for your feedback,we will get back to you Soon.";
                    echo"</font>";
                    echo"<br><br>";
                    ?>
 

mysql table:

feedback` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(30) NOT NULL,
  `Contactno` varchar(60) NOT NULL,
  `Emailid` varchar(40) NOT NULL,
  `Feedback` varchar(500) NOT NULL,
  PRIMARY KEY (`Id`)
)

[Markus]

Turn error reporting on:

<?php
// Very top of your script
ini_set('display_errors', 1);
error_reporting(-1);
 

Check that your connect to the database and selecting of database worked:

$conn = mysql_connect('localhost', 'root', '');
if (!$conn)
{
  printf("Error when trying to connect to MySQL server: %s", mysql_error());
}
else
{
  // Do rest
}
 

Also, the mysql_* functions are outdated and have been superseded. Use MySQLi or PDO instead.