whats wrong with it

rwachowiak · April 24, 2008

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!

The Little Guy · April 24, 2008

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.
}
?>

rwachowiak · April 24, 2008

thanks for the quick response... they are all mostly option fields... theres like 30+ of them...

and what do i put in for "// Display the error and the form again." ???

thanks!

The Little Guy · April 24, 2008

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>';
}
?>

rwachowiak · April 24, 2008

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!!!!!!!!

The Little Guy · April 24, 2008

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>';
}
?>

rwachowiak · April 25, 2008

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;


?>

Sign In

whats wrong with it

Recommended Posts

rwachowiak

Link to comment

Share on other sites

The Little Guy

Link to comment

Share on other sites

rwachowiak

Link to comment

Share on other sites

The Little Guy

Link to comment

Share on other sites

rwachowiak

Link to comment

Share on other sites

The Little Guy

Link to comment

Share on other sites

rwachowiak

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information