Databases
StackOverflow2013
Postsdbo
POboth validation messages are appearing on javascript and php
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POboth validation messages are appearing on javascript and php
    primarykey
    data
    text
    <p>In the code below I have two types of validation. I use a javascript validaton which displays the error message for when the user does not enter in anything in the course text input.</p> <p>Then I have a php validation where that if it does not contain a row for the result from the query which checks to see if there are any assessments within the course the user has typed in the course text input, then it displays a message stating that no assessments are found.</p> <p>The problem I am having though is that if the user does not enter in anything in the "Course" text input and they click on the submit button, it displays both the javascript validation and the php validation. </p> <p>This is incorrect, what should happen is that :</p> <ul> <li><p>if the user has not written anything in the course text input, then it should simply show only the javascript validation and NOT the php validation.</p> <ul> <li>if the user has written something in the course text input and submits the form, but it then cannot find any results from the query, then it should display the php validation ONLY.</li> </ul></li> </ul> <p>My question is what do I need to change in the code in order to be able to not show both validation messages at the same time and show only the correct validation messages when they should be shown? </p> <p>In other words how do I stop the form from submitting if the javascript validation fails? And then obviously how do I make sure that if the javascript validation succeeds, then it does submit the form. </p> <p><strong>Javascript</strong></p> <pre><code>function validation() { var isDataValid = true; var courseTextO = document.getElementById("coursesDrop"); var errModuleMsgO = document.getElementById("moduleAlert"); if (courseTextO.value == "") { $('#targetdiv').hide(); $('#assessmentForm').hide(); $('#updateForm').hide(); $('#submitupdatebtn').hide(); errModuleMsgO.innerHTML = "Please Select a Course"; isDataValid = false; } else { errModuleMsgO.innerHTML = ""; } return isDataValid; }​ </code></pre> <p><strong>PHP/HTML</strong></p> <pre><code>&lt;?php // connect to the database include('connect.php'); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); die(); } $sql = "SELECT CourseId, CourseNo, CourseName FROM Course ORDER BY CourseId"; $sqlstmt=$mysqli-&gt;prepare($sql); $sqlstmt-&gt;execute(); $sqlstmt-&gt;bind_result($dbCourseId, $dbCourseNo, $dbCourseName); $courses = array(); // easier if you don't use generic names for data $courseHTML = ""; $courseHTML .= '&lt;input type="text" name="courses" id="coursesDrop" /&gt;' . PHP_EOL; ?&gt; &lt;form action="&lt;?php echo htmlentities($_SERVER['PHP_SELF']); ?&gt;" method="post" onsubmit="return validation();"&gt; &lt;table&gt; &lt;tr&gt; &lt;th&gt;Course: &lt;?php echo $courseHTML; ?&gt;&lt;/th&gt; &lt;/tr&gt; &lt;/table&gt; &lt;p&gt; &lt;input id="moduleSubmit" type="submit" value="Submit Course and Module" name="moduleSubmit" /&gt; &lt;/p&gt; &lt;div id="moduleAlert"&gt;&lt;/div&gt; &lt;div id="targetdiv"&gt;&lt;/div&gt; &lt;/form&gt; &lt;?php if (isset($_POST['moduleSubmit'])) { $sessionquery = " SELECT SessionId, SessionName, SessionDate, SessionTime, CourseId, SessionActive FROM Session WHERE (CourseId = ? AND SessionActive = ?) ORDER BY SessionName "; $active = 1; $sessionqrystmt=$mysqli-&gt;prepare($sessionquery); // You only need to call bind_param once $sessionqrystmt-&gt;bind_param("si",$course, $active); // get result and assign variables (prefix with db) $sessionqrystmt-&gt;execute(); $sessionqrystmt-&gt;bind_result($dbSessionId,$dbSessionName,$dbSessionDate,$dbSessionTime, $dbCourseId, $dbSessionActive); $sessionqrystmt-&gt;store_result(); $sessionnum = $sessionqrystmt-&gt;num_rows(); if($sessionnum == 0) { echo "&lt;p&gt;&lt;span style='color: red'&gt;Sorry, You have No Assessments under this Module&lt;/span&gt;&lt;/p&gt;"; } else { echo ""; } ... } ?&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCups
    1. USuser1830984
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COAlways assume the data isn't valid (`var isDataValid = false;`), then, if it passes all tests, set it to true. Can you check if the form still submits if you `return false;` from the `validation()` function?
      singulars
      1. POboth validation messages are appearing on javascript and php
      1. USCerbrus
    2. COYour code appears to be correct. Take a look at this example: http://codepen.io/anon/pen/GpmjH. It appears to be working properly. Check your error console and see if you are getting a javascript error or something.
      singulars
      1. POboth validation messages are appearing on javascript and php
      1. USTravesty3
    3. CO@Travesty3 that makes sense. If there is a bug somewhere ELSE, in some unrelated function (i.e. jQuery lib related), then the JS won't fire properly but the FORM action still will.
      singulars
      1. POboth validation messages are appearing on javascript and php
      1. USJoshua
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload