If, And, Or code for data entry

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • jcage@lycos.com

    If, And, Or code for data entry

    I have a drop down box with 'Incomplete', 'Resolved' and 'Complete' as
    part of my $status variable on a form and a text box called
    '$datecomp' that passes the data from both variables to a MySQL
    database.

    How might I include an 'if' statement where if the drop down selection
    for variable $datecomp is 'Incomplete' or 'Resolved', an error message
    is displayed on the data entry confirmation page that requests the
    user to click their browser 'back' button and enter a date in the
    'datecomp' field? I was trying to modify the following code but so
    far, without any luck. In other words, if 'status' = Complete or
    Resolved, trigger the error on the confirmation page where a user
    clicks their back button and either enters a date in the datecomp
    field OR leaves the drop down box as Incomplete.

    thanks,
    John

    if (!$datecomp || and $status="Comple te" or "Resolved")
    {
    echo 'You must enter a DATE for items marked Complete or
    Resolved.<br />'
    .'Please click the browser BACK button, fill in a Complete/
    Resolved date and try again.';
    exit;
    }

  • jcage@lycos.com

    #2
    Re: If, And, Or code for data entry

    On Jun 13, 7:23 pm, j...@lycos.com wrote:
    I have a drop down box with 'Incomplete', 'Resolved' and 'Complete' as
    part of my $status variable on a form and a text box called
    '$datecomp' that passes the data from both variables to a MySQL
    database.
    >
    How might I include an 'if' statement where if the drop down selection
    for variable $datecomp is 'Incomplete' or 'Resolved', an error message
    is displayed on the data entry confirmation page that requests the
    user to click their browser 'back' button and enter a date in the
    'datecomp' field? I was trying to modify the following code but so
    far, without any luck. In other words, if 'status' = Complete or
    Resolved, trigger the error on the confirmation page where a user
    clicks their back button and either enters a date in the datecomp
    field OR leaves the drop down box as Incomplete.
    >
    thanks,
    John
    >
    if (!$datecomp || and $status="Comple te" or "Resolved")
    {
    echo 'You must enter a DATE for items marked Complete or
    Resolved.<br />'
    .'Please click the browser BACK button, fill in a Complete/
    Resolved date and try again.';
    exit;
    }

    Solved this puzzle (though it may not be the best example of code
    writing) and thought I'd put the solution here in hopes of helping
    someone else in a similar bind.. :-)

    if ((($status == "Complete") or ($status == "Resolved") and ($datecomp
    == "")))
    {
    echo 'All items marked COMPLETE or RESOLVED must have a date
    entered.<br />'
    .'Please click the browser BACK button, fill in the date and
    try again.';
    exit;
    }

    Comment

    • Norman Peelman

      #3
      Re: If, And, Or code for data entry

      jcage@lycos.com wrote:
      I have a drop down box with 'Incomplete', 'Resolved' and 'Complete' as
      part of my $status variable on a form and a text box called
      '$datecomp' that passes the data from both variables to a MySQL
      database.
      >
      How might I include an 'if' statement where if the drop down selection
      for variable $datecomp is 'Incomplete' or 'Resolved', an error message
      is displayed on the data entry confirmation page that requests the
      user to click their browser 'back' button and enter a date in the
      'datecomp' field? I was trying to modify the following code but so
      far, without any luck. In other words, if 'status' = Complete or
      Resolved, trigger the error on the confirmation page where a user
      clicks their back button and either enters a date in the datecomp
      field OR leaves the drop down box as Incomplete.
      >
      thanks,
      John
      >
      if (!$datecomp || and $status="Comple te" or "Resolved")
      {
      echo 'You must enter a DATE for items marked Complete or
      Resolved.<br />'
      .'Please click the browser BACK button, fill in a Complete/
      Resolved date and try again.';
      exit;
      }
      >
      if (!$datecomp && ($status == 'Complete' || $status == 'Resolved'))


      ....use '=' for assignment and '==' for comparison.

      Norm

      Comment

      • Gordon Burditt

        #4
        Re: If, And, Or code for data entry

        >I have a drop down box with 'Incomplete', 'Resolved' and 'Complete' as
        >part of my $status variable on a form and a text box called
        >'$datecomp' that passes the data from both variables to a MySQL
        >database.
        The variable passed to PHP is $_GET['datecomp'] or $_POST['datecomp'],
        not $datecomp. (register_globa ls is evil and should be turned off).
        >How might I include an 'if' statement where if the drop down selection
        >for variable $datecomp is 'Incomplete' or 'Resolved', an error message
        >is displayed on the data entry confirmation page that requests the
        >user to click their browser 'back' button and enter a date in the
        >'datecomp' field? I was trying to modify the following code but so
        >far, without any luck. In other words, if 'status' = Complete or
        >Resolved, trigger the error on the confirmation page where a user
        >clicks their back button and either enters a date in the datecomp
        >field OR leaves the drop down box as Incomplete.
        There's no meaning to a subexpression like: "Complete" or "Resolved".
        Think of it as: If status is Complete or status is Resolved, then ....
        >thanks,
        >John
        >
        >if (!$datecomp || and $status="Comple te" or "Resolved")
        if (isset($_GET['datecomp'] && ($_GET['status'] == "Complete" || $_GET['status'] == "Resolved") )
        {
        echo 'You must enter a DATE for items marked Complete or
        >Resolved.<br />'
        .'Please click the browser BACK button, fill in a Complete/
        >Resolved date and try again.';
        exit;
        }
        >

        Comment

        • jcage@lycos.com

          #5
          Re: If, And, Or code for data entry

          On Jun 13, 9:04 pm, gordonb.ic...@b urditt.org (Gordon Burditt) wrote:
          I have a drop down box with 'Incomplete', 'Resolved' and 'Complete' as
          part of my $status variable on a form and a text box called
          '$datecomp' that passes the data from both variables to a MySQL
          database.
          >
          The variable passed to PHP is $_GET['datecomp'] or $_POST['datecomp'],
          not $datecomp. (register_globa ls is evil and should be turned off).
          >
          How might I include an 'if' statement where if the drop down selection
          for variable $datecomp is 'Incomplete' or 'Resolved', an error message
          is displayed on the data entry confirmation page that requests the
          user to click their browser 'back' button and enter a date in the
          'datecomp' field? I was trying to modify the following code but so
          far, without any luck. In other words, if 'status' = Complete or
          Resolved, trigger the error on the confirmation page where a user
          clicks their back button and either enters a date in the datecomp
          field OR leaves the drop down box as Incomplete.
          >
          There's no meaning to a subexpression like: "Complete" or "Resolved".
          Think of it as: If status is Complete or status is Resolved, then ....
          >
          thanks,
          John
          >
          if (!$datecomp || and $status="Comple te" or "Resolved")
          >
          if (isset($_GET['datecomp'] && ($_GET['status'] == "Complete" || $_GET['status'] == "Resolved") )
          >
          {
          echo 'You must enter a DATE for items marked Complete or
          Resolved.<br />'
          .'Please click the browser BACK button, fill in a Complete/
          Resolved date and try again.';
          exit;
          }

          Thanks very much for your help guys - appreciate it!

          Comment

          Working...