Jump to content

whats wrong with it

rwachowiak

By rwachowiak
in PHP Coding Help

Recommended Posts

rwachowiak Member

rwachowiak

Posted
Posted

so i have a php form, it works fine, but i want to have required fields, on all but 1 field.

 

heres my code:

 

<?php
if(isset($_POST['add']))
{
include 'libs/dbopen.php';

$q1a = mysql_real_escape_string($_POST['q1a']);
$q1b = mysql_real_escape_string($_POST['q1b']);

$q2a = mysql_real_escape_string($_POST['q2a']);
$q2b = mysql_real_escape_string($_POST['q2b']);

$q3a = mysql_real_escape_string($_POST['q3a']);
$q3b = mysql_real_escape_string($_POST['q3b']);

$q4a = mysql_real_escape_string($_POST['q4a']);
$q4b = mysql_real_escape_string($_POST['q4b']);

$q5a = mysql_real_escape_string($_POST['q5a']);
$q5b = mysql_real_escape_string($_POST['q5b']);

$q6a = mysql_real_escape_string($_POST['q6a']);
$q6b = mysql_real_escape_string($_POST['q6b']);

$q7a = mysql_real_escape_string($_POST['q7a']);
$q7b = mysql_real_escape_string($_POST['q7b']);

$q8a = mysql_real_escape_string($_POST['q8a']);
$q8b = mysql_real_escape_string($_POST['q8b']);

$q9a = mysql_real_escape_string($_POST['q9a']);
$q9b = mysql_real_escape_string($_POST['q9b']);

$q10a = mysql_real_escape_string($_POST['q10a']);
$q10b = mysql_real_escape_string($_POST['q10b']);

$q11a = mysql_real_escape_string($_POST['q11a']);
$q11b = mysql_real_escape_string($_POST['q11b']);

$q12a = mysql_real_escape_string($_POST['q12a']);
$q12b = mysql_real_escape_string($_POST['q12b']);

$q121a = mysql_real_escape_string($_POST['q121a']);
$q121b = mysql_real_escape_string($_POST['q121b']);

$q122a = mysql_real_escape_string($_POST['q122a']);
$q122b = mysql_real_escape_string($_POST['q122b']);

$q123a = mysql_real_escape_string($_POST['q123a']);
$q123b = mysql_real_escape_string($_POST['q123b']);

$q124a = mysql_real_escape_string($_POST['q124a']);
$q124b = mysql_real_escape_string($_POST['q124b']);

$q125a = mysql_real_escape_string($_POST['q125a']);
$q125b = mysql_real_escape_string($_POST['q125b']);

$q13a = mysql_real_escape_string($_POST['q13a']);
$q13b = mysql_real_escape_string($_POST['q13b']);

$q14a = mysql_real_escape_string($_POST['q14a']);
$q14b = mysql_real_escape_string($_POST['q14b']);

$q15a = mysql_real_escape_string($_POST['q15a']);
$q15b = mysql_real_escape_string($_POST['q15b']);

$q16a = mysql_real_escape_string($_POST['q16a']);
$q16b = mysql_real_escape_string($_POST['q16b']);

$q17a = mysql_real_escape_string($_POST['q17a']);
$q17b = mysql_real_escape_string($_POST['q17b']);

$q18 = mysql_real_escape_string($_POST['q18']);
$q19 = mysql_real_escape_string($_POST['q19']);
$q20 = mysql_real_escape_string($_POST['q20']);
$q21 = mysql_real_escape_string($_POST['q21']);
$name = mysql_real_escape_string($_POST['name']);







$query = "INSERT INTO survey (q1a, q1b, q2a, q2b, q3a, q3b, q4a, q4b, q5a, q5b, q6a, q6b, q7a, q7b, q8a, q8b, q9a, q9b, q10a, q10b, q11a, q11b, q121a, q121b, q122a, q122b, q123a, q123b, q124a, q124b, q125a, q125b, q13a, q13b, q14a, q14b, q15a, q15b, q16a, q16b, q17a, q17b, q18, q19, q20, q21, name)
VALUES ('$q1a', '$q1b', '$q2a', '$q2b', '$q3a', '$q3b', '$q4a', '$q4b', '$q5a', '$q5b', '$q6a', '$q6b', '$q7a', '$q7b', '$q8a', '$q8b', '$q9a', '$q9b', '$q10a', '$q10b', '$q11a', '$q11b', '$q121a', '$q121b', '$q122a', '$q122b', '$q123a', '$q123b', '$q124a', '$q124b', '$q125a', '$q125b', '$q13a', '$q13b', '$q14a', '$q14b', '$q15a', '$q15b', '$q16a', '$q16b', '$q17a', '$q17b', '$q18', '$q19', '$q20', '$q21', '$name')";

mysql_query($query) or die('Error, insert query failed: '.mysql_error());


if (!($q1a && $q1b && $q18 && $q19)) {echo "You must complete the form to send it"; } else {
}
include 'libs/dbclose.php';
echo "Your Survey has been added, Thank You.<br><br><a href='index.php'>Go to Index</a>";
}
else
{

?>



<br><span class="titlebar">THE EMPLOYEE CTBK SATISFACTION SURVEY</span><br>
<br>
<form method="post" enctype="multipart/form-data">
<table width="850" border="0" cellspacing="1" cellpadding="2">
  <tr>
    <td height="25"> </td>
    <td width="150" height="25"><div align="center"><span class="titlebar2">OVERALL EVALUATION</span></div></td>
    <td width="150" height="25"><div align="center"><span class="titlebar2">ATTRIBUTE IMPORTANCE</span></div></td>
  </tr>
  <tr>
    <td height="25"> </td>
    <td width="150" height="25" valign="top"><div align="left" class="description">Please rate each of the following attributes: </div></td>
    <td width="150" height="25" valign="top"><div align="left" class="description">Please rate the following attributes in accordance with how you perceive their importance to you as an employee at CTBK</div></td>
  </tr>
  <tr>
    <td height="25"> </td>
    <td height="25" colspan="2"><div align="center" class="titlebar4">1 = Poor, 3 = Average, 5 = Excellent </div>      <div align="center"></div></td>
    </tr>
  <tr>
    <td height="30" bgcolor="#F0F3F8">1. The overall quality of the phsyical work environment.</td>
    <td width="150" height="30" bgcolor="#F0F3F8">
  
      <div align="center">
        <select name="q1a" id="q1a">
          <option value="" selected></option>
          <option value="1">1</option>
          <option value="2">2</option>
          <option value="3">3</option>
          <option value="4">4</option>
          <option value="5">5</option>
          </select>
        </div></td>
    <td width="150" height="30" bgcolor="#F0F3F8">
      
        <div align="center">
          <select name="q1b" id="q1b">
            <option value="" selected></option>
            <option value="1">1</option>
            <option value="2">2</option>
            <option value="3">3</option>
            <option value="4">4</option>
            <option value="5">5</option>
          </select>
        </div></td>
  </tr>
  <tr>
    <td height="30">2. Your overall satisfaction with the work load assigned.</td>
    <td width="150" height="30"><div align="center">
      <select name="q2a" id="select4">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q2b" id="select26">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr bgcolor="#F0F3F8">
    <td height="30">3. Your overall satisfaction with the challenge of work assignments. </td>
    <td width="150" height="30"><div align="center">
      <select name="q3a" id="select5">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q3b" id="select27">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr>
    <td height="30">4. Your overall satisfaction with the engagement mix. </td>
    <td width="150" height="30"><div align="center">
      <select name="q4a" id="select7">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q4b" id="select28">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr bgcolor="#F0F3F8">
    <td height="30">5. Do you feel you have the opportunity available to advance. </td>
    <td width="150" height="30"><div align="center">
      <select name="q5a" id="select6">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q5b" id="select29">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr>
    <td height="30">6. Your overall satisfaction with the compensation/salary you recieve. </td>
    <td width="150" height="30"><div align="center">
      <select name="q6a" id="select8">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q6b" id="select30">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr bgcolor="#F0F3F8">
    <td height="30">7. Your overall satisfaction with the fringes available. </td>
    <td width="150" height="30"><div align="center">
      <select name="q7a" id="select9">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q7b" id="select31">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr>
    <td height="30">8. The quality and quantity of recognition you recieve from superiors. </td>
    <td width="150" height="30"><div align="center">
      <select name="q8a" id="select10">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q8b" id="select32">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr bgcolor="#F0F3F8">
    <td height="30">9. The quality and quantity of recognition you recieve from peers. </td>
    <td width="150" height="30"><div align="center">
      <select name="q9a" id="select12">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q9b" id="select33">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr>
    <td height="30">10. The overall quality and quantity of guidance received from superiors.</td>
    <td width="150" height="30"><div align="center">
      <select name="q10a" id="select11">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q10b" id="select34">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr bgcolor="#F0F3F8">
    <td height="30">11. The overall quality and quantity of external training you are recieving. </td>
    <td width="150" height="30"><div align="center">
      <select name="q11a" id="select13">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q11b" id="select35">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr>
    <td height="30">12. The overall communications available within the office: </td>
    <td width="150" height="30"><div align="center"></div></td>
    <td width="150" height="30"><div align="center"></div></td>
  </tr>
  <tr bgcolor="#F0F3F8">
    <td height="30">- Top Down (ie. partner to manager to senior to staff) </td>
    <td width="150" height="30"><div align="center">
      <select name="q121a" id="select14">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q121b" id="select36">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr>
    <td height="30"> - Electronic </td>
    <td width="150" height="30"><div align="center">
      <select name="q122a" id="select15">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q122b" id="select37">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr bgcolor="#F0F3F8">
    <td height="30">- Phones </td>
    <td width="150" height="30"><div align="center">
      <select name="q123a" id="select16">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q123b" id="select38">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr>
    <td height="30">- Upwards (ie. staff to senior to manager to partner) </td>
    <td width="150" height="30"><div align="center">
      <select name="q124a" id="select17">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q124b" id="select39">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr bgcolor="#F0F3F8">
    <td height="30">- Mentoring Program </td>
    <td width="150" height="30"><div align="center">
      <select name="q125a" id="select18">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q125b" id="select40">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr>
    <td height="30">13. Do you feel you have the tools and or resources necessary to do the job. </td>
    <td width="150" height="30"><div align="center">
      <select name="q13a" id="select19">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q13b" id="select41">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr bgcolor="#F0F3F8">
    <td height="30">14. The overall satisfaction with the office hardware. </td>
    <td width="150" height="30"><div align="center">
      <select name="q14a" id="select20">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q14b" id="select42">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr>
    <td height="30">15. The overall satisfaction with the office software. </td>
    <td width="150" height="30"><div align="center">
      <select name="q15a" id="select21">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q15b" id="select43">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr bgcolor="#F0F3F8">
    <td height="30">16. The overall quality of process improvements. </td>
    <td width="150" height="30"><div align="center">
      <select name="q16a" id="select22">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q16b" id="select25">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr>
    <td height="30">17. Your overall satisfaction with working at CTBK </td>
    <td width="150" height="30"><div align="center">
      <select name="q17a" id="select23">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
    <td width="150" height="30"><div align="center">
      <select name="q17b" id="select24">
        <option value="" selected></option>
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>
        <option value="4">4</option>
        <option value="5">5</option>
      </select>
    </div></td>
  </tr>
  <tr bgcolor="#F0F3F8">
    <td height="30" colspan="3">18. What do you like best about working at CTBK? 
      <div align="center"></div>      <div align="center"></div></td>
    </tr>
  <tr>
    <td height="30" colspan="3"><textarea name="q18" rows="6" id="q18" cols="90"></textarea></td>
  </tr>
  <tr bgcolor="#F0F3F8">
    <td height="30" colspan="3">19. What one area could we improve to make your job easier or improve 
      the overall quality of the operations of the practice?
      <div align="center"></div>      <div align="center"></div></td>
    </tr>
  <tr>
    <td height="30" colspan="3"><textarea name="q19" rows="6" id="q19" cols="90"></textarea></td>
    </tr>
  <tr bgcolor="#F0F3F8">
<td width="455" height="30">20. What is your age demographic? </td>
<td height="30" colspan="2"><div align="left">
  <select name="q20" id="select">
    <option value="18-25">18-25</option>
    <option value="26-33">26-33</option>
    <option value="34-41">34-41</option>
    <option value="42+">42+</option>
  </select>
</div></td>
</tr>
<tr>
<td width="455" height="30">21. What is your position at CTBK? </td>
<td height="30" colspan="2"><div align="left">
  <select name="q21" id="select2">
    <option value="Administrative">Administrative</option>
    <option value="Staff">Staff</option>
    <option value="Senior">Senior</option>
    <option value="Manager">Manager</option>
    <option value="Principal or Director">Principal or Director</option>
  </select>
</div></td>
</tr>
<tr bgcolor="#F0F3F8">
  <td height="30">(Optional) What is your name? </td>
  <td height="30" colspan="2"><div align="left">
    <input name="name" type="text" id="name" size="40" />
  </div></td>
  </tr>
<tr>
<td width="455" height="25"> </td>
<td width="150" height="25">
  <div align="center">
    <input name="add" type="submit" id="add" value="Finish">
  </div></td>
<td width="150" height="25"><div align="center"></div></td>
</tr>
</table>
</form>
<?php
}
?>

 

thanks for looking!

Link to comment
https://forums.phpfreaks.com/topic/102716-whats-wrong-with-it/
Share on other sites
The Little Guy Prolific Member

The Little Guy

Posted
Posted

assuming they are text fields:

 

<?php
if(!empty($_POST['q1a'])||!empty($_POST['q1b'])/*||!empty($_POST['...*/){  // all fields except the optional one
     // Fields are good make query
     $query = "INSERT INTO survey (q1a, q1b, q2a, q2b, q3a, q3b, q4a, q4b, q5a, q5b, q6a, q6b, q7a, q7b, q8a, q8b, q9a, q9b, q10a, q10b, q11a, q11b, q121a, q121b, q122a, q122b, q123a, q123b, q124a, q124b, q125a, q125b, q13a, q13b, q14a, q14b, q15a, q15b, q16a, q16b, q17a, q17b, q18, q19, q20, q21, name)
VALUES ('$q1a', '$q1b', '$q2a', '$q2b', '$q3a', '$q3b', '$q4a', '$q4b', '$q5a', '$q5b', '$q6a', '$q6b', '$q7a', '$q7b', '$q8a', '$q8b', '$q9a', '$q9b', '$q10a', '$q10b', '$q11a', '$q11b', '$q121a', '$q121b', '$q122a', '$q122b', '$q123a', '$q123b', '$q124a', '$q124b', '$q125a', '$q125b', '$q13a', '$q13b', '$q14a', '$q14b', '$q15a', '$q15b', '$q16a', '$q16b', '$q17a', '$q17b', '$q18', '$q19', '$q20', '$q21', '$name')";

}else{
     // Display the error and the form again.
}
?>

Link to comment
https://forums.phpfreaks.com/topic/102716-whats-wrong-with-it/#findComment-525964
Share on other sites
The Little Guy Prolific Member

The Little Guy

Posted
Posted

OK, for the option fields, you would want to do isset instead of !empty

 

You would just say what field(s) then need to look over again and correctly fill it out.

 

I would put another if/else statement in there:

 

 

<?php
if(isset($_POST['q1a'])||isset($_POST['q1b'])/*||isset($_POST['...*/){  // all fields except the optional one
     // Fields are good make query
     $query = "INSERT INTO survey (q1a, q1b, q2a, q2b, q3a, q3b, q4a, q4b, q5a, q5b, q6a, q6b, q7a, q7b, q8a, q8b, q9a, q9b, q10a, q10b, q11a, q11b, q121a, q121b, q122a, q122b, q123a, q123b, q124a, q124b, q125a, q125b, q13a, q13b, q14a, q14b, q15a, q15b, q16a, q16b, q17a, q17b, q18, q19, q20, q21, name)
VALUES ('$q1a', '$q1b', '$q2a', '$q2b', '$q3a', '$q3b', '$q4a', '$q4b', '$q5a', '$q5b', '$q6a', '$q6b', '$q7a', '$q7b', '$q8a', '$q8b', '$q9a', '$q9b', '$q10a', '$q10b', '$q11a', '$q11b', '$q121a', '$q121b', '$q122a', '$q122b', '$q123a', '$q123b', '$q124a', '$q124b', '$q125a', '$q125b', '$q13a', '$q13b', '$q14a', '$q14b', '$q15a', '$q15b', '$q16a', '$q16b', '$q17a', '$q17b', '$q18', '$q19', '$q20', '$q21', '$name')";

}else{
     $errMsg = '';
     if(!isset($_POST['q1a'])){
          $errMsg .= 'q1a must be filled in.<br />';
     }
     if(!isset($_POST['q1b'])){
          $errMsg .= 'q1b must be filled in.<br />';
     }

     //...

     echo $errMsg;
     echo '<form action="'.$_SERVER['PHP_SELF'].'" method="post">
     ...
     </form>';
}
?>

Link to comment
https://forums.phpfreaks.com/topic/102716-whats-wrong-with-it/#findComment-525979
Share on other sites
rwachowiak Member

rwachowiak

Posted
  • Author
Posted

instead of an error for EACH one because there are a lot, how about just a simple one that says "you missed a field" or something like that.

 

and could u be a bud and give me the exact code, im really new!!! and explain it too plz so i can learn!!

 

thanks!!!!!!!!

Link to comment
https://forums.phpfreaks.com/topic/102716-whats-wrong-with-it/#findComment-526173
Share on other sites
The Little Guy Prolific Member

The Little Guy

Posted
Posted

Not sure how to explain it, so if you have a question about some part, just ask:

 

<?php
if(isset($_POST['q1a'])||isset($_POST['q1b'])/*||isset($_POST['...*/){  // all fields except the optional one
     // Fields are good make query
     $query = "INSERT INTO survey (q1a, q1b, q2a, q2b, q3a, q3b, q4a, q4b, q5a, q5b, q6a, q6b, q7a, q7b, q8a, q8b, q9a, q9b, q10a, q10b, q11a, q11b, q121a, q121b, q122a, q122b, q123a, q123b, q124a, q124b, q125a, q125b, q13a, q13b, q14a, q14b, q15a, q15b, q16a, q16b, q17a, q17b, q18, q19, q20, q21, name)
VALUES ('$q1a', '$q1b', '$q2a', '$q2b', '$q3a', '$q3b', '$q4a', '$q4b', '$q5a', '$q5b', '$q6a', '$q6b', '$q7a', '$q7b', '$q8a', '$q8b', '$q9a', '$q9b', '$q10a', '$q10b', '$q11a', '$q11b', '$q121a', '$q121b', '$q122a', '$q122b', '$q123a', '$q123b', '$q124a', '$q124b', '$q125a', '$q125b', '$q13a', '$q13b', '$q14a', '$q14b', '$q15a', '$q15b', '$q16a', '$q16b', '$q17a', '$q17b', '$q18', '$q19', '$q20', '$q21', '$name')";

}else{
     // A field was missed display a message
     $errMsg = 'You missed a field.';

     echo $errMsg;
     echo '<form action="'.$_SERVER['PHP_SELF'].'" method="post">
     ...
     </form>';
}
?>

Link to comment
https://forums.phpfreaks.com/topic/102716-whats-wrong-with-it/#findComment-526184
Share on other sites
rwachowiak Member

rwachowiak

Posted
  • Author
Posted

ok i must be missing something... heres what i got and its not working

 

<?php
if(isset($_POST['q1a'])||isset($_POST['q1b'])){

include 'libs/dbopen.php';

$q1a = mysql_real_escape_string($_POST['q1a']);
$q1b = mysql_real_escape_string($_POST['q1b']);

$q2a = mysql_real_escape_string($_POST['q2a']);
$q2b = mysql_real_escape_string($_POST['q2b']);

$q3a = mysql_real_escape_string($_POST['q3a']);
$q3b = mysql_real_escape_string($_POST['q3b']);

$q4a = mysql_real_escape_string($_POST['q4a']);
$q4b = mysql_real_escape_string($_POST['q4b']);

$q5a = mysql_real_escape_string($_POST['q5a']);
$q5b = mysql_real_escape_string($_POST['q5b']);

$q6a = mysql_real_escape_string($_POST['q6a']);
$q6b = mysql_real_escape_string($_POST['q6b']);

$q7a = mysql_real_escape_string($_POST['q7a']);
$q7b = mysql_real_escape_string($_POST['q7b']);

$q8a = mysql_real_escape_string($_POST['q8a']);
$q8b = mysql_real_escape_string($_POST['q8b']);

$q9a = mysql_real_escape_string($_POST['q9a']);
$q9b = mysql_real_escape_string($_POST['q9b']);

$q10a = mysql_real_escape_string($_POST['q10a']);
$q10b = mysql_real_escape_string($_POST['q10b']);

$q11a = mysql_real_escape_string($_POST['q11a']);
$q11b = mysql_real_escape_string($_POST['q11b']);

$q12a = mysql_real_escape_string($_POST['q12a']);
$q12b = mysql_real_escape_string($_POST['q12b']);

$q121a = mysql_real_escape_string($_POST['q121a']);
$q121b = mysql_real_escape_string($_POST['q121b']);

$q122a = mysql_real_escape_string($_POST['q122a']);
$q122b = mysql_real_escape_string($_POST['q122b']);

$q123a = mysql_real_escape_string($_POST['q123a']);
$q123b = mysql_real_escape_string($_POST['q123b']);

$q124a = mysql_real_escape_string($_POST['q124a']);
$q124b = mysql_real_escape_string($_POST['q124b']);

$q125a = mysql_real_escape_string($_POST['q125a']);
$q125b = mysql_real_escape_string($_POST['q125b']);

$q13a = mysql_real_escape_string($_POST['q13a']);
$q13b = mysql_real_escape_string($_POST['q13b']);

$q14a = mysql_real_escape_string($_POST['q14a']);
$q14b = mysql_real_escape_string($_POST['q14b']);

$q15a = mysql_real_escape_string($_POST['q15a']);
$q15b = mysql_real_escape_string($_POST['q15b']);

$q16a = mysql_real_escape_string($_POST['q16a']);
$q16b = mysql_real_escape_string($_POST['q16b']);

$q17a = mysql_real_escape_string($_POST['q17a']);
$q17b = mysql_real_escape_string($_POST['q17b']);

$q18 = mysql_real_escape_string($_POST['q18']);
$q19 = mysql_real_escape_string($_POST['q19']);
$q20 = mysql_real_escape_string($_POST['q20']);
$q21 = mysql_real_escape_string($_POST['q21']);
$name = mysql_real_escape_string($_POST['name']);







$query = "INSERT INTO survey (q1a, q1b, q2a, q2b, q3a, q3b, q4a, q4b, q5a, q5b, q6a, q6b, q7a, q7b, q8a, q8b, q9a, q9b, q10a, q10b, q11a, q11b, q121a, q121b, q122a, q122b, q123a, q123b, q124a, q124b, q125a, q125b, q13a, q13b, q14a, q14b, q15a, q15b, q16a, q16b, q17a, q17b, q18, q19, q20, q21, name)
VALUES ('$q1a', '$q1b', '$q2a', '$q2b', '$q3a', '$q3b', '$q4a', '$q4b', '$q5a', '$q5b', '$q6a', '$q6b', '$q7a', '$q7b', '$q8a', '$q8b', '$q9a', '$q9b', '$q10a', '$q10b', '$q11a', '$q11b', '$q121a', '$q121b', '$q122a', '$q122b', '$q123a', '$q123b', '$q124a', '$q124b', '$q125a', '$q125b', '$q13a', '$q13b', '$q14a', '$q14b', '$q15a', '$q15b', '$q16a', '$q16b', '$q17a', '$q17b', '$q18', '$q19', '$q20', '$q21', '$name')";

mysql_query($query) or die('Error, insert query failed: '.mysql_error());


include 'libs/dbclose.php';
echo "Your Survey has been added, Thank You.<br><br><a href='index.php'>Go to Index</a>";
}
else
{
$errMsg = 'You missed a field.';

     echo $errMsg;


?>

Link to comment
https://forums.phpfreaks.com/topic/102716-whats-wrong-with-it/#findComment-527025
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.