hi.
i have written this code to add contact details but it says error inserting values.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Add Contact Details</title>
<style type="text/css">
html,body {
margin: 0px;
}
.text {
color: green;
}
table{
border: 1px solid black;
border-collapse: collapse;
background-color: #d6e5f4;
width: 700px;
}
th{
border: 1px solid black;
padding: 5px 5px 5px 5px;
width: 200px;
font-size: 15px;
font-family: Georgia, serif;
color: brown;
}
td{
border: 1px solid black;
padding: 5px 5px 5px 15px;
text-align: left;
}
table .iptd {
padding: 5px 5px 5px 5px;
border: 2px dashed black;
border-color: purple;
width: 250px;
}
.txtarea {
border: 3px solid #cccccc;
padding: 7px;
font-family: Georgia, serif;
color: black;
}
.img {
border: 3px solid #cccccc;
padding: 7px;
width: 350px;
}
.error {
font-size: 20px;
color: brown;
}
.heading {
font-family: fantasy;
font-size: 30px;
text-align: center;
color: #8B0000;
border: 2px solid black;
}
</style>
</head>
<body>
<?php
if(isset($_POST['contactadd']))
{
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$homead = $_POST['homead'];
$offad = $_POST['offad'];
$llno = $_POST['llno'];
$mobno1 = $_POST['mobno1'];
$mobno2 = $_POST['mobno2'];
$email = $_POST['email'];
$image = $_FILES['image']['name'];
$description = $_POST['description'];
if( (!empty($fname)) && (!empty($lname)) &&(!empty($homead)) && (!empty($offad)) && (!empty($llno)) &&
(!empty($mobno1)) && (!empty($mobno2)) && (!empty($email)) && (!empty($image)) && (!empty($description)))
{
$dbc = mysqli_connect('localhost','username','password','addcontact')
or die('Error Connecting to Mysql');
$query = "INSERT INTO contactlist VALUES('$fname','$lname','$homead',$offad','$llno','$mobno1','$mobno2','$email','$image','$description')";
mysqli_query($dbc,$query)
or die('Error Inserting Values');
mysqli_close($dbc);
}
else
{
echo '<center><p class="error">Some of the data entered is wrong or incomplete</p></center>';
}
}
?>
<center>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" enctype="multipart/form-data" method="post">
<table>
<tr>
<td class="heading"><b>ADD CONTACT TO DATABASE</b></td>
</tr>
</table>
<table>
<tr>
<th><em>FIRST NAME:</em></th>
<td><input type="text" name="fname" class="iptd" value="<?php if(!empty($fname)) echo $fname; ?>" /></td>
</tr>
<tr>
<th><em>LAST NAME:</em></th>
<td><input type="text" name="lname" class="iptd" value="<?php if(!empty($lname)) echo $lname; ?>" /></td>
</tr>
<tr>
<th rowspan="2"><em>ADDRESS</em></th>
<td class="text">RESIDENCE:<br /><textarea class="txtarea" cols="60" rows="18" name="homead"><?php if(!empty($homead)) echo $homead; ?></textarea></td>
</tr>
<tr>
<td class="text">OFFICE:<br /><textarea class="txtarea" cols="60" rows="18" name="offad"><?php if(!empty($offad)) echo $offad; ?></textarea></td>
</tr>
<tr>
<th rowspan="3"><em>TELEPHONE NO'S:</em></th>
<td class="text">LANDLINE:<br /><input type="text" class="iptd" name="llno" value="<?php if(!empty($llno)) echo $llno; ?>" /></td>
</tr>
<tr>
<td class="text">MOBILE NO 1:<br /><input type="text" class="iptd" name="mobno1" value="<?php if(!empty($mobno1)) echo $mobno1; ?>" /></td>
</tr>
<tr>
<td class="text">MOBILE NO 2:<br /><input type="text" class="iptd" name="mobno2" value="<?php if(!empty($mobno2)) echo $mobno2; ?>" /></td>
</tr>
<tr>
<th><em>EMAIL-ID:</em></th>
<td><input type="text" name="email" class="iptd" value="<?php if(!empty($email)) echo $email; ?>" /></td>
</tr>
<tr>
<th><em>UPLOAD IMAGE:</em></th>
<td><input type="file" class="img" name="image" alt="picture" /></td>
</tr>
<tr>
<th><em>RELATION<br /></em>(OR)<br /><em>DESCRIPTION:</em><br />( Say a Few words about this person)</th>
<td><textarea rows="12" cols="40" name="description" class="txtarea"><?php if(!empty($description)) echo $description; ?></textarea></td>
</tr>
<tr>
<th></th>
<td><input type="submit" name="contactadd" value="ADD CONTACT" /></td>
</tr>
</table>
</form>
</center>
</body>
</html>