Code: Select all
<?php
header("Location:home.php");
$con=mysql_connect("localhost", "user", "userpass") or die("Could not connect to localhost."); mysql_select_db("pcontact", $con) or die("Could not find db.");
$nick=$_POST['nick']; $fname=$_POST['fname']; $lname=$_POST['lname']; $bizname=$_POST['bizname']; $email=$_POST['email']; $email1=$_POST['email1']; $bizemail=$_POST['bizemail']; $phnum=$_POST['phnum']; $cellnum=$_POST['cellnum']; $biznum=$_POST['biznum']; $bizfax=$_POST['bizfax']; $faxnum=$_POST['faxnum'];
$sql=mysql_query ("INSERT INTO contacts (nick, fname, lname, bizname, email, email1, bizemail, phnum, cellnum, biznum, bizfax, faxnum) VALUES ('$nick', '$fname', '$lname', '$bizname' '$email', '$email1', '$bizemail', '$phnum', '$cellnum', '$biznum', '$bizfax', '$faxnum')");
mysql_close($con);
$result = mysql_query($sql);
if (!$result){
die(mysql_error());
}
?>My form is:
Code: Select all
<form action="filecontact.php" method="post" name="addcontact">
<table width="50%" border="0">
<tr>
<td colspan="2" align="center"><div style="font-weight:bold">Personal:</div></td>
<td colspan="2" align="center"><div style="font-weight:bold">Business:</div></td>
</tr>
<tr>
<td><div>Nickname:</div></td>
<td align="center"><input type="text" name="nick" maxlength="20"></td>
<td><div>Business:</div></td>
<td align="center"><input type="text" name="bizname" maxlength="100"></td>
</tr>
<tr>
<td><div>First Name:</div></td>
<td align="center"><input type="text" name="fname" maxlength="20"></td>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="bizemail" maxlength="100"></td>
</tr>
<tr>
<td><div>Last Name:</div></td>
<td align="center"><input type="text" name="lname" maxlength="20"></td>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="biznum" maxlength="10"></td>
</tr>
<tr>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="email" maxlength="100"></td>
<td><div>Fax:</div></td>
<td align="center"><input type="text" name="bizfax" maxlength="10"></td>
</tr>
<tr>
<td><div>Alt. Email:</div></td>
<td align="center"><input type="text" name="email1" maxlength="100"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="phnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Cell:</div></td>
<td align="center"><input type="text" name="cellnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Fax:</div></td>
<td align="center"><input type="text" name="faxnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
</table>
<br />
<div align="center"><input type="submit" name="submit" value="Save Contact"></div>
</form>Thanks and happy 4th of July.amp;quote;Could not connect to localhost."); mysql_select_db("pcontact", $con) or die("e;Could not find db."e;);
$nick=$_POSTї'nick']; $fname=$_POSTї'fname']; $lname=$_POSTї'lname']; $bizname=$_POSTї'bizname']; $email=$_POSTї'email']; $email1=$_POSTї'email1']; $bizemail=$_POSTї'bizemail']; $phnum=$_POST['phnum']; $cellnum=$_POST['cellnum']; $biznum=$_POST['biznum']; $bizfax=$_POST['bizfax']; $faxnum=$_POST['faxnum'];
$sql=mysql_query ("INSERT INTO contacts (nick, fname, lname, bizname, email, email1, bizemail, phnum, cellnum, biznum, bizfax, faxnum) VALUES ('$nick', '$fname', '$lname', '$bizname' '$email', '$email1', '$bizemail', '$phnum', '$cellnum', '$biznum', '$bizfax', '$faxnum')");
mysql_close($con);
$result = mysql_query($sql);
if (!$result){
die(mysql_error());
}
?>
I dont get an error, but there is nothing in my table when I submit it.
My form is:
Code: Select all
<form action="filecontact.php" method="post" name="addcontact">
<table width="50%" border="0">
<tr>
<td colspan="2" align="center"><div style="font-weight:bold">Personal:</div></td>
<td colspan="2" align="center"><div style="font-weight:bold">Business:</div></td>
</tr>
<tr>
<td><div>Nickname:</div></td>
<td align="center"><input type="text" name="nick" maxlength="20"></td>
<td><div>Business:</div></td>
<td align="center"><input type="text" name="bizname" maxlength="100"></td>
</tr>
<tr>
<td><div>First Name:</div></td>
<td align="center"><input type="text" name="fname" maxlength="20"></td>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="bizemail" maxlength="100"></td>
</tr>
<tr>
<td><div>Last Name:</div></td>
<td align="center"><input type="text" name="lname" maxlength="20"></td>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="biznum" maxlength="10"></td>
</tr>
<tr>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="email" maxlength="100"></td>
<td><div>Fax:</div></td>
<td align="center"><input type="text" name="bizfax" maxlength="10"></td>
</tr>
<tr>
<td><div>Alt. Email:</div></td>
<td align="center"><input type="text" name="email1" maxlength="100"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="phnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Cell:</div></td>
<td align="center"><input type="text" name="cellnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
<tr>
&fax']; $faxnum=$_POST['faxnum'];
$sql=mysql_query ("INSERT INTO contacts (nick, fname, lname, bizname, email, email1, bizemail, phnum, cellnum, biznum, bizfax, faxnum) VALUES ('$nick', '$fname', '$lname', '$bizname' '$email', '$email1', '$bizemail', '$phnum', '$cellnum', '$biznum', '$bizfax', '$faxnum')");
mysql_close($con);
$result = mysql_query($sql);
if (!$result){
die(mysql_error());
}
?>My form is:
Code: Select all
<form action="filecontact.php" method="post" name="addcontact">
<table width="50%" border="0">
<tr>
<td colspan="2" align="center"><div style="font-weight:bold">Personal:</div></td>
<td colspan="2" align="center"><div style="font-weight:bold">Business:</div></td>
</tr>
<tr>
<td><div>Nickname:</div></td>
<td align="center"><input type="text" name="nick" maxlength="20"></td>
<td><div>Business:</div></td>
<td align="center"><input type="text" name="bizname" maxlength="100"></td>
</tr>
<tr>
<td><div>First Name:</div></td>
<td align="center"><input type="text" name="fname" maxlength="20"></td>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="bizemail" maxlength="100"></td>
</tr>
<tr>
<td><div>Last Name:</div></td>
<td align="center"><input type="text" name="lname" maxlength="20"></td>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="biznum" maxlength="10"></td>
</tr>
<tr>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="email" maxlength="100"></td>
<td><div>Fax:</div></td>
<td align="center"><input type="text" name="bizfax" maxlength="10">&ap");
$con=mysql_connect("localhost", "user", "userpass") or die("Could not connect to localhost."); mysql_select_db("pcontact", $con) or die("Could not find db.");
$nick=$_POST['nick']; $fname=$_POST['fname']; $lname=$_POST['lname']; $bizname=$_POST['bizname']; $email=$_POST['email']; $email1=$_POST['email1']; $bizemail=$_POST['bizemail']; $phnum=$_POST['phnum']; $cellnum=$_POST['cellnum']; $biznum=$_POST['biznum']; $bizfax=$_POST['bizfax']; $faxnum=$_POST['faxnum'];
$sql=mysql_query ("INSERT INTO contacts (nick, fname, lname, bizname, email, email1, bizemail, phnum, cellnum, biznum, bizfax, faxnum) VALUES ('$nick', '$fname', '$lname', '$bizname' '$email', '$email1', '$bizemail', '$phnum', '$cellnum', '$biznum', '$bizfax', '$faxnum')");
mysql_close($con);
$result = mysql_query($sql);
if (!$result){
die(mysql_error());
}
?>My form is:
Code: Select all
<form action="filecontact.php" method="post" name="addcontact">
<table width="50%" border="0">
<tr>
<td colspan="2" align="center"><div style="font-weight:bold">Personal:</div></td>
<td colspan="2" align="center"><div style="font-weight:bold">Business:</div></td>
</tr>
<tr>
<td><div>Nickname:</div></td>
<td align="center"><input type="text" name="nick" maxlength="20"></td>
<td><div>Business:</div></td>
<td align="center"><input type="text" name="bizname" maxlength="100"></td>
</tr>
<tr>
<td><div>First Name:</div></td>
<td align="center"><input type="text" name="fname" maxlength="20"></td>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="bizemail" maxlength="100"></td>
</tr>
<tr>
<td><div>Last Name:</div></td>
<td align="center"><input type="text" name="lname" maxlength="20"></td>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="biznum" maxlength="10"></td>
</tr>
<tr>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="email" maxlength="100"></td>
<td><div>Fax:</div></td>
<td align="center"><input type="text" name="bizfax" maxlength="10"></td>
</tr>
<tr>
<td><div>Alt. Email:</div></td>
<td align="center"><input type="text" name="email1" maxlength="100"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="phnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Cell:</div></td>
<td align="center"><input type="text" name="cellnum" maxlength="10"></td>
<td>&amzname' '$email', '$email1', '$bizemail', '$phnum', '$cellnum', '$biznum', '$bizfax', '$faxnum')");
mysql_close($con);
$result = mysql_query($sql);
if (!$result){
die(mysql_error());
}
?>My form is:
Code: Select all
<form action="filecontact.php" method="post" name="addcontact">
<table width="50%" border="0">
<tr>
<td colspan="2" align="center"><div style="font-weight:bold">Personal:</div></td>
<td colspan="2" align="center"><div style="font-weight:bold">Business:</div></td>
</tr>
<tr>
<td><div>Nickname:</div></td>
<td align="center"><input type="text" name="nick" maxlength="20"></td>
<td><div>Business:</div></td>
<td align="center"><input type="text" name="bizname" maxlength="100"></td>
</tr>
<tr>
<td><div>First Name:</div></td>
<td align="center"><input type="text" name="fname" maxlength="20"></td>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="bizemail" maxlength="100"></td>
</tr>
<tr>
<td><div>Last Name:</div></td>
<td align="center"><input type="text" name="lname" maxlength="20"></td>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="biznum" maxlength="10"></td>
</tr>
<tr>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="email" maxlength="100"></td>
<td><div>Fax:</div></td>
<td align="center"><input type="text" name="bizfax" maxlength="10"></td>
</tr>
<tr>
<td><div>Alt. Email:</div></td>
<td align="center"><input type="text" name="email1" maxlength="100"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="phnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Cell:</div></td>
<td align="center"><input type="text" name="cellnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Fax:</div>&, "user", "userpass") or die("Could not connect to localhost."); mysql_select_db("pcontact", $con) or die("Could not find db.");
$nick=$_POST['nick']; $fname=$_POST['fname']; $lname=$_POST['lname']; $bizname=$_POST['bizname']; $email=$_POST['email']; $email1=$_POST['email1']; $bizemail=$_POST['bizemail']; $phnum=$_POST['phnum']; $cellnum=$_POST['cellnum']; $biznum=$_POST['biznum']; $bizfax=$_POST['bizfax']; $faxnum=$_POST['faxnum'];
$sql=mysql_query ("INSERT INTO contacts (nick, fname, lname, bizname, email, email1, bizemail, phnum, cellnum, biznum, bizfax, faxnum) VALUES ('$nick', '$fname', '$lname', '$bizname' '$email', '$email1', '$bizemail', '$phnum', '$cellnum', '$biznum', '$bizfax', '$faxnum')");
mysql_close($con);
$result = mysql_query($sql);
if (!$result){
die(mysql_error());
}
?>My form is:
Code: Select all
<form action="filecontact.php" method="post" name="addcontact">
<table width="50%" border="0">
<tr>
<td colspan="2" align="center"><div style="font-weight:bold">Personal:</div></td>
<td colspan="2" align="center"><div style="font-weight:bold">Business:</div></td>
</tr>
<tr>
<td><div>Nickname:</div></td>
<td align="center"><input type="text" name="nick" maxlength="20"></td>
<td><div>Business:</div></td>
<td align="center"><input type="text" name="bizname" maxlength="100"></td>
</tr>
<tr>
<td><div>First Name:</div></td>
<td align="center"><input type="text" name="fname" maxlength="20"></td>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="bizemail" maxlength="100"></td>
</tr>
<tr>
<td><div>Last Name:</div></td>
<td align="center"><input type="text" name="lname" maxlength="20"></td>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="biznum" maxlength="10"></td>
</tr>
<tr>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="email" maxlength="100"></td>
<td><div>Fax:</div></td>
<td align="center"><input type="text" name="bizfax" maxlength="10"></td>
</tr>
<tr>
<td><div>Alt. Email:</div></td>
<td align="center"><input type="text" name="email1" maxlength="100"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="phnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Cell:</div></td>
<td align="center"><input type="text" name="cellnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Fax:</div></td>
<td align="center"><input type="text" name="faxnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
</table>
<br />
<div align="center"><input type="submit" name="submit" value="Save Contact"></div>
:home.php");
$con=mysql_connect("localhost", "user", "userpass") or die("Could not connect to localhost."); mysql_select_db("pcontact", $con) or die("Could not find db.");
$nick=$_POST['nick']; $fname=$_POST['fname']; $lname=$_POST['lname']; $bizname=$_POST['bizname']; $email=$_POST['email']; $email1=$_POST['email1']; $bizemail=$_POST['bizemail']; $phnum=$_POST['phnum']; $cellnum=$_POST['cellnum']; $biznum=$_POST['biznum']; $bizfax=$_POST['bizfax']; $faxnum=$_POST['faxnum'];
$sql=mysql_query ("INSERT INTO contacts (nick, fname, lname, bizname, email, email1, bizemail, phnum, cellnum, biznum, bizfax, faxnum) VALUES ('$nick', '$fname', '$lname', '$bizname' '$email', '$email1', '$bizemail', '$phnum', '$cellnum', '$biznum', '$bizfax', '$faxnum')");
mysql_close($con);
$result = mysql_query($sql);
if (!$result){
die(mysql_error());
}
?>My form is:
Code: Select all
<form action="filecontact.php" method="post" name="addcontact">
<table width="50%" border="0">
<tr>
<td colspan="2" align="center"><div style="font-weight:bold">Personal:</div></td>
<td colspan="2" align="center"><div style="font-weight:bold">Business:</div></td>
</tr>
<tr>
<td><div>Nickname:</div></td>
<td align="center"><input type="text" name="nick" maxlength="20"></td>
<td><div>Business:</div></td>
<td align="center"><input type="text" name="bizname" maxlength="100"></td>
</tr>
<tr>
<td><div>First Name:</div></td>
<td align="center"><input type="text" name="fname" maxlength="20"></td>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="bizemail" maxlength="100"></td>
</tr>
<tr>
<td><div>Last Name:</div></td>
<td align="center"><input type="text" name="lname" maxlength="20"></td>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="biznum" maxlength="10"></td>
</tr>
<tr>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="email" maxlength="100"></td>
<td><div>Fax:</div></td>
<td align="center"><input type="text" name="bizfax" maxlength="10"></td>
</tr>
<tr>
<td><div>Alt. Email:</div></td>
<td align="center"><input type="text" name="email1" maxlength="100"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="phnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Cell:</div></td>
<td align="center"><input type="text" name="cellnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Fax:</div></td>
<td align="center"><input type="text" name="faxnum" maxlength="10"></td>
<td> </td>
<td> </t
<?php
header("Location:home.php");
$con=mysql_connect("localhost", "user", "userpass") or die("Could not connect to localhost."); mysql_select_db("pcontact", $con) or die("Could not find db.");
$nick=$_POST['nick']; $fname=$_POST['fname']; $lname=$_POST['lname']; $bizname=$_POST['bizname']; $email=$_POST['email']; $email1=$_POST['email1']; $bizemail=$_POST['bizemail']; $phnum=$_POST['phnum']; $cellnum=$_POST['cellnum']; $biznum=$_POST['biznum']; $bizfax=$_POST['bizfax']; $faxnum=$_POST['faxnum'];
$sql=mysql_query ("INSERT INTO contacts (nick, fname, lname, bizname, email, email1, bizemail, phnum, cellnum, biznum, bizfax, faxnum) VALUES ('$nick', '$fname', '$lname', '$bizname' '$email', '$email1', '$bizemail', '$phnum', '$cellnum', '$biznum', '$bizfax', '$faxnum')");
mysql_close($con);
$result = mysql_query($sql);
if (!$result){
die(mysql_error());
}
?>My form is:
Code: Select all
<form action="filecontact.php" method="post" name="addcontact">
<table width="50%" border="0">
<tr>
<td colspan="2" align="center"><div style="font-weight:bold">Personal:</div></td>
<td colspan="2" align="center"><div style="font-weight:bold">Business:</div></td>
</tr>
<tr>
<td><div>Nickname:</div></td>
<td align="center"><input type="text" name="nick" maxlength="20"></td>
<td><div>Business:</div></td>
<td align="center"><input type="text" name="bizname" maxlength="100"></td>
</tr>
<tr>
<td><div>First Name:</div></td>
<td align="center"><input type="text" name="fname" maxlength="20"></td>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="bizemail" maxlength="100"></td>
</tr>
<tr>
<td><div>Last Name:</div></td>
<td align="center"><input type="text" name="lname" maxlength="20"></td>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="biznum" maxlength="10"></td>
</tr>
<tr>
<td><div>Email:</div></td>
<td align="center"><input type="text" name="email" maxlength="100"></td>
<td><div>Fax:</div></td>
<td align="center"><input type="text" name="bizfax" maxlength="10"></td>
</tr>
<tr>
<td><div>Alt. Email:</div></td>
<td align="center"><input type="text" name="email1" maxlength="100"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Phone:</div></td>
<td align="center"><input type="text" name="phnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Cell:</div></td>
<td align="center"><input type="text" name="cellnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div>Fax:</div></td>
<td align="center"><input type="text" name="faxnum" maxlength="10"></td>
<td> </td>
<td> </td>
</tr>
</table>
<br />
<div align="center"><input type="submit" name="submit" value="Save Contact"></div>
</form>Thanks and happy 4th of July.