Page 1 of 1

Is there an Error

Posted: Mon Jul 04, 2005 12:16 pm
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.

Posted: Mon Jul 04, 2005 12:45 pm
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());
}

Posted: Mon Jul 04, 2005 12:45 pm
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.

Posted: Mon Jul 04, 2005 8:46 pm
by Gimpy
The only other thing I got was "Query was empty" WTF :cry: :cry: :cry:

Posted: Mon Jul 04, 2005 9:10 pm
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

Posted: Tue Jul 05, 2005 4:57 am
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.

Posted: Tue Jul 05, 2005 1:11 pm
by Gimpy
Well it worked for my user registration so I dont see why it wouldnt here.