Anyone out there please debug my PHP form script?

  • Thread starter Thread starter giridharanbtech
  • Start date Start date
G

giridharanbtech

Guest
Friends,
i am designed a html form. It contains 5 fields as firstname,lastname,email,contactno,comments.
I also create a database and created a table named submissions.
I also written php but i have errors. Here is my code. Please debug it.

<?php
$username = "myusername";
$password = "mypassword";
$hostname = "myhostname";
$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
$selected = mysql_select_db("dbname",$dbhandle)
or die("Could not select database");
$fname=$_POST['fname'];
$lname=$_POST['lname'];

$email=$_POST['email'];
$cno=$_POST['cno'];
$comments=$_POST['comments'];
$sql="INSERT INTO submission values('$fname','$lname','$email','$cno','$comments')";
$result=mysql_query($sql);
mysql_close($dbhandle);
?>
 
Back
Top