Is there an Error

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Gimpy
Forum Commoner
Posts: 42
Joined: Tue Jun 14, 2005 1:12 am
Location: Fort Worth, TX, US
Contact:

Is there an Error

Post by Gimpy »

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());
}
?>
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>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Phone:</div></td>
    <td align="center"><input type="text" name="phnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Cell:</div></td>
    <td align="center"><input type="text" name="cellnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Fax:</div></td>
    <td align="center"><input type="text" name="faxnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  </table>
<br />
<div align="center"><input type="submit" name="submit" value="Save Contact"></div>
</form>
Any help into finding out the problem would be more than helpful and grateful.
Thanks and happy 4th of July.amp;quote;Could not connect to localhost."); mysql_select_db("pcontact", $con) or die(&quote;Could not find db.&quote;);
$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>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Phone:</div></td>
    <td align="center"><input type="text" name="phnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Cell:</div></td>
    <td align="center"><input type="text" name="cellnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    &ampfax']; $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">&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());
}
?>
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>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Phone:</div></td>
    <td align="center"><input type="text" name="phnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</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());
}
?>
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>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Phone:</div></td>
    <td align="center"><input type="text" name="phnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Cell:</div></td>
    <td align="center"><input type="text" name="cellnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Fax:</div>&amp, "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());
}
?>
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>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Phone:</div></td>
    <td align="center"><input type="text" name="phnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Cell:</div></td>
    <td align="center"><input type="text" name="cellnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Fax:</div></td>
    <td align="center"><input type="text" name="faxnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</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());
}
?>
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>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Phone:</div></td>
    <td align="center"><input type="text" name="phnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Cell:</div></td>
    <td align="center"><input type="text" name="cellnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Fax:</div></td>
    <td align="center"><input type="text" name="faxnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</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());
}
?>
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>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Phone:</div></td>
    <td align="center"><input type="text" name="phnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Cell:</div></td>
    <td align="center"><input type="text" name="cellnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div>Fax:</div></td>
    <td align="center"><input type="text" name="faxnum" maxlength="10"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  </table>
<br />
<div align="center"><input type="submit" name="submit" value="Save Contact"></div>
</form>
Any help into finding out the problem would be more than helpful and grateful.
Thanks and happy 4th of July.
Last edited by Gimpy on Mon Jul 04, 2005 8:53 pm, edited 1 time in total.
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

Prepend to all your scripts the following

Code: Select all

ini_set('error_reporting', E_ALL);
ini_set('display_errors', TRUE);
Next, you need to sanitize your input

Code: Select all

$db = mysql_connect(....) or die(.....);

$username = mysql_real_escape_string($_POST['username'], $db);
Next, when you perform a mysql_query... you can also use mysql_error

Code: Select all

$result = mysql_query($sql);
if (!$result)
{
  die(mysql_error());
}
21d97]
$db = mysql_connect(....) or die(.....);

$username = mysql_real_escape_string($_POST['username'], $db);


Next, when you perform a mysql_query... you can also use mysql_error

Code: Select all

$result = mysql_query($sql);
if (!$result)
{
  die(mysql_error());
}
t('error_reporting', E_ALL);
ini_set('display_errors', TRUE);


Next, you need to sanitize your input

Code: Select all

$db = mysql_connect(....) or die(.....);

$username = mysql_real_escape_string($_POST['username'], $db);
Next, when you perform a mysql_query... you can also use mysql_error

Code: Select all

$result = mysql_query($sql);
if (!$result)
{
  die(mysql_error());
}
p]

Next, you need to sanitize your input

Code: Select all

$db = mysql_connect(....) or die(.....);

$username = mysql_real_escape_string($_POST['username'], $db);
Next, when you perform
ini_set('error_reporting', E_ALL);
ini_set('display_errors', TRUE);


Next, you need to sanitize your input

Code: Select all

$db = mysql_connect(....) or die(.....);

$username = mysql_real_escape_string($_POST['username'], $db);
Next, when you perform a mysql_query... you can also use mysql_error

Code: Select all

$result = mysql_query($sql);
if (!$result)
{
  die(mysql_error());
}
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post by hawleyjr »

There is a comma at the end of your query.

Code: Select all

, '$faxnum',)&quote;);

use or die() after mysql_query() to display your errors.
Gimpy
Forum Commoner
Posts: 42
Joined: Tue Jun 14, 2005 1:12 am
Location: Fort Worth, TX, US
Contact:

Post by Gimpy »

The only other thing I got was "Query was empty" WTF :cry: :cry: :cry:
Gimpy
Forum Commoner
Posts: 42
Joined: Tue Jun 14, 2005 1:12 am
Location: Fort Worth, TX, US
Contact:

Post by Gimpy »

DB: pcontact
table: contacts
This is the table that it should through the data into.
id int(7) No auto_increment
nick varchar(20) No
fname varchar(20) No
lname varchar(20) No
bizname varchar(100) No
email varchar(100) No
email1 varchar(100) No
bizemail varchar(100) No
phnum varchar(10) No
cellnum varchar(10)No
biznum varchar(10) No
bizfax varchar(10) No
faxnum varchar(10) No
uid int(7) No
User avatar
dethron
Forum Contributor
Posts: 370
Joined: Sat Apr 27, 2002 11:39 am
Location: Istanbul

Post by dethron »

are you sure you have the posted variables like $nick, if your register global is set to off, then you must use $_POST['nick'] instead ıf $nick.
Gimpy
Forum Commoner
Posts: 42
Joined: Tue Jun 14, 2005 1:12 am
Location: Fort Worth, TX, US
Contact:

Post by Gimpy »

Well it worked for my user registration so I dont see why it wouldnt here.
Post Reply