I have av webpage with a form:
- Code: Select all
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="style.css" />
<title>USBgeoA</title>
</head>
<body>
<div id="content">
<h1>Sammanställning</h1> </br>
<table border="1">
</br>
<P><a>STEG 1.</a></P>
<p>Fyll i alla rutor för att skapa legenden till din presentation</p>
<tr>
<td>
<table>
<form method="post" action="input.php">
<tr>
<td><p><a>Dina uppgifter</a></p></td>
</tr>
<tr>
<td><p>Förnamn</p></td>
<td><input type="text" name="fName" size="25"/>
</td>
</tr>
<tr>
<td><p>Efternamn</p></td>
<td><input type="text" name="lName" size="25">
</td>
</tr>
<tr>
<td><p>Titel</p></td>
<td><input type="text" name="titel" size="25"/>
</td>
</tr>
<tr>
<td><p>Avdelning</p></td>
<td><input type="text" name="avd" size="25"/>
</td>
</tr>
<tr>
<td><p>Myndighet</p></td>
<td><input type="text" name="mynd" size="25"/>
</td>
</tr>
<tr>
<td><p>Telefon</p></td>
<td><input type="text" name="tele" size="25"/>
</td>
</tr>
<tr>
<td><p>Email</p></td>
<td><input type="text" name="email" size="25"/>
</td>
</tr>
<tr>
<td><p><a>Angående Beställare av sammanställningen:</a></p></td>
</tr>
<tr>
<td><p>Namn på beställare</p></td>
<td><input type="text" name="bName" size="25"/>
</td>
</tr>
<tr>
<td><p>Beställares Email</p></td>
<td><input type="text" name="bEmail" size="25"/>
</td>
</tr>
<tr>
<td></td>
<td align="right"><input type="submit" name="submit" value="Nästa steg"></td>
</tr>
</table>
</td>
</tr>
</table>
</br>
</div>
</body>
</html>
I have also a PHP file:
- Code: Select all
<?php
$con = mysql_connect("localhost","root","myPassword");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
$sql="INSERT INTO my_pres (fName, lName, titel, avd, mynd, tele, email, bName, bEmail)
VALUES
('$_POST[fName]','$_POST[fName]','$_POST[titel]','$_POST[avd]','$_POST[mynd]','$_POST[tele]','$_POST[email]','$_POST[bName]','$_POST[bEmail])";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con);
?>
I also have setup a database in phpMyAdmin
database name: my_db
table in database: my_pres
Problem I have is that when i push submit button on the HTML form, nothing is submittet to the database and the only thing that happens is that a window open that asks whet to do with the .php file....like if i wanne save or open it.
I am on a Ubuntu 12.04.
