Problem inserting data into database

i have some problem inserting data into the database through a form.the data does not appear.Can anyone help me check the following codes for error?

form.html


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>


<body>
<form method="post" action="form_testing2.php">
 <p>
 <label>Name: </label>
<input name="Name" type="text"/>
 </p>
 <p>
 <label>Telephone: </label>
 <input name="Telephone" type="text"/>
 </p>
 <p>
 <label>Birthday: </label>
 <input name="Birthday" type="text"/>
 </p>
 <p>
 <input name="Submit" type="submit" value="Submit"/>
 </p>
</form>
</body>
</html>

form_testing2.php


<?php
session_start();
$_SESSION['Name'] = $_POST['Name'];
$_SESSION['Telephone'] = $_POST['Telephone'];
$_SESSION['Birthday'] = $_POST['Birthday'];


$con = mysql_connect("localhost","root","");
if (!$con)
 {
 echo "Fail to connect!";
 }
mysql_select_db("sally", $con);


$sql="INSERT INTO people (Name, Telephone, Birthday)
VALUES
('{$_SESSION['Name']}','{$_SESSION['Telephone']}','{$_SESSION['Birthday']}')";


$result = mysql_db_query($db, $sql, $con);


if (!mysql_query($sql,$con))
 {
 die('Error: ' . mysql_error());
 }
else { echo "1 record added"; }


mysql_close($con)
?>

Problem inserting data into database

slaly

nanat

nanat

slaly

eelixduppy

slaly

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week