Skip to main content
This topic has been closed for replies.
Correct answer bregent

Query was empty


OK, please post the entire page code. You're probably just missing curly braces or a line terminator.

1 reply

J
Jonathan_FortisAuthor
Inspiring
April 6, 2012

sorry posted by mistake..

ok i added two if statements to check if a password is correct

if($POST['password'] == $_POST['password2'])

          if($_POST['email'] == $_POST['email2'])

and when i add the above it return a query is empty.

the full code is below

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form4"))

{

          if($POST['password'] == $_POST['password2'])

          if($_POST['email'] == $_POST['email2'])

 

  $insertSQL = sprintf("INSERT INTO think_signup (FirstName, Surname, password, email, ContactMethod, TeleNumber, SalaryReq, PositionReq, skills_offered, cv, location) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",

                       GetSQLValueString($_POST['FirstName'], "text"),

                       GetSQLValueString($_POST['Surname'], "text"),

                       GetSQLValueString($_POST['password'], "text"),

                       GetSQLValueString($_POST['email'], "text"),

                       GetSQLValueString($_POST['ContactMethod'], "text"),

                       GetSQLValueString($_POST['TeleNumber'], "text"),

                       GetSQLValueString($_POST['SalaryReq'], "text"),

                       GetSQLValueString($_POST['PositionReq'], "text"),

                       GetSQLValueString($_POST['skills_offered'], "text"),

                       GetSQLValueString($_POST['cv'], "text"),

                       GetSQLValueString($_POST['location'], "text"));

and the inputs are here

              <td nowrap="nowrap" align="right">Password:</td>

              <td><input type="text" name="password" value="" size="30" /></td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="right">Confirm Password</td>

              <td><input type="text" name="password2" value="" size="30" /></td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="right">Email:</td>

              <td><input type="text" name="email" value="" size="30" /></td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="right">Confirm Email</td>

              <td><input type="text" name="email2" value="" size="30" /></td>

B
bregent
Participating Frequently
April 6, 2012

Typo in your POST variable.

J
Jonathan_FortisAuthor
Inspiring
April 6, 2012

OK, please post the entire page code. You're probably just missing curly braces or a line terminator.


<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

  if (PHP_VERSION < 6) {

    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;   

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form4"))

{

          if($_POST['password'] == $_POST['password2'] && $_POST['email'] == $_POST['email2'])

 

  $insertSQL = sprintf("INSERT INTO think_signup (FirstName, Surname, password, email, ContactMethod, TeleNumber, SalaryReq, PositionReq, skills_offered, cv, needCV, otherComments, location) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",

                       GetSQLValueString($_POST['FirstName'], "text"),

                       GetSQLValueString($_POST['Surname'], "text"),

                       GetSQLValueString($_POST['password'], "text"),

                       GetSQLValueString($_POST['email'], "text"),

                       GetSQLValueString($_POST['ContactMethod'], "text"),

                       GetSQLValueString($_POST['TeleNumber'], "text"),

                       GetSQLValueString($_POST['SalaryReq'], "text"),

                       GetSQLValueString($_POST['PositionReq'], "text"),

                       GetSQLValueString($_POST['skills_offered'], "text"),

                       GetSQLValueString($_POST['cv'], "text"),

                                                     GetSQLValueString(isset($_POST['needCV']) ? "true" : "", "defined","'Y'","'N'"),

                                                     GetSQLValueString($_POST['otherComments'], "text"),

                       GetSQLValueString($_POST['location'], "text"));

  mysql_select_db($database_hostprop, $hostprop);

  $Result1 = mysql_query($insertSQL, $hostprop) or die(mysql_error());

  $insertGoTo = "signup-complete.php";

  if (isset($_SERVER['QUERY_STRING'])) {

    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";

    $insertGoTo .= $_SERVER['QUERY_STRING'];

  }

  header(sprintf("Location: %s", $insertGoTo));

}

mysql_select_db($database_hostprop, $hostprop);

$query_rsReg = "SELECT * FROM think_signup";

$rsReg = mysql_query($query_rsReg, $hostprop) or die(mysql_error());

$row_rsReg = mysql_fetch_assoc($rsReg);

$totalRows_rsReg = mysql_num_rows($rsReg);

?>

        <form action="<?php echo $editFormAction; ?>" method="post" name="form4" id="form4">

          <table width="500" align="center">

            <tr valign="baseline">

              <td nowrap="nowrap" align="left"><p>FirstName:

                </p>

                <p>

                  <input type="text" name="FirstName" value="" size="30" />

              </p></td>

              <td><p>

                <input type="text" name="cv" value="" size="32" />

              </p>

              <p>                Cv </p></td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="left"><p>Surname

                </p>

                <p>

                  <input type="text" name="Surname" value="" size="30" />

              </p></td>

              <td><p>

                <input type="checkbox" name="needCV"/>

              </p>

              <p>need cv </p></td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="left"><p>Password

                </p>

                <p>

                  <input type="text" name="password" value="" size="30" />

              </p></td>

              <td rowspan="2">

                <p>

                  <textarea name="otherComments"cols="20" rows="5"></textarea>

                </p>

                <p>other comments</p>

              <p>  </p></td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="left"><p>Confirm Password

                </p>

                <p>

                  <input type="text" name="password2" value="" size="30" />

              </p></td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="left"><p>Email

                </p>

                <p>

                  <input type="text" name="email" value="" size="30" />

              </p></td>

              <td> </td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="left"><p>Confirm Email

                </p>

                <p>

                  <input type="text" name="email2" value="" size="30" />

              </p></td>

              <td> </td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="left"><p>ContactMethod

                </p>

                <p>

                  <input type="text" name="ContactMethod" value="" size="30" />

              :</p></td>

              <td> </td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="left"><p>TeleNumber

                </p>

                <p>

                  <input type="text" name="TeleNumber" value="" size="30" />

              :</p></td>

              <td> </td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="left"><p>SalaryReq

                </p>

                <p>

                  <input type="text" name="SalaryReq" value="" size="30" />

              :</p></td>

              <td> </td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="left"><p>PositionReq

                </p>

                <p>

                  <input type="text" name="PositionReq" value="" size="32" />

              :</p></td>

              <td> </td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="left"><p>Skills_offered

                </p>

                <p>

                  <input type="text" name="skills_offered" value="" size="32" />

              :</p></td>

              <td> </td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="left"><p> </p>

                <p>

            :</p></td>

              <td> </td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="left">Location

                <input type="text" name="location" value="" size="32" />

              :</td>

              <td> </td>

            </tr>

            <tr valign="baseline">

              <td nowrap="nowrap" align="left"> </td>

              <td><input type="submit" value="Insert record" /></td>

            </tr>

          </table>

          <input type="hidden" name="MM_insert" value="form4" />

        </form>

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices