Hi All;
I am trying to add a new record web database using Mysql&PHP.
But after at every add process a new blank record is added to mysql table.
The entered text is not considered with codes.
What is my trouble in this html or php code?
Could anyone has any idea?
Thanks.
***************name.html******************
<html>
<body>
<form action="name.php" method="post">
<PRE>
name...... : <input
type="text"
name="name"
size="25"
maxlength="25"
value="<? echo $name>">
<P>
surname: <input
type="text"
name="surname"
size="25"
maxlength="25">
< input type="submit"
name="submit"
value="submit">
</PRE>
</form>
</body>
</html>
*******************name.php***************
<?php
mysql_connect("localhost","user","password");
mysql_select_db ("mydatabasename");
mysql_query ("INSERT INTO name (name,surname)
VALUES ('$name','$surname')");
echo ('Your record has been added.');
print ("<p>");
print ("Your Name:");
print ($name);
print (" ");
print ("<p>");
print ("Your Surname:");
print ($surname);
print ("<p>");
print ("THANKS");
?>
Mahmut
