Jump to content

advanced search problem

pixeltrace

By pixeltrace
in PHP Coding Help

Recommended Posts

pixeltrace Advanced Member

pixeltrace

Posted
Posted

guys,

 

i need help on my advance seach form.

i have 2 page, advanced_search.php and view3.php

this is the code for my advanced_search.php

<form id="form1" name="form1" method="post" action="view3.php">
  <table width="473" border="0" cellspacing="4" cellpadding="0">
        <tr>
          <td width="465" valign="top">Keywords :
            <input type="text" name="textfield"></td>
        </tr>
        <tr>
          <td valign="top">Country
            :    
            <select name="country">
              <option value="">Select A Country</option>
              <option value="Afghanistan">Afghanistan</option>
              <option value="Albania">Albania</option>
              <option value="Algeria">Algeria</option>
              <option value="American Samoa">American Samoa</option>
              <option value="Andorra">Andorra</option>
              <option value="Angola">Angola</option>
              <option value="Anguilla">Anguilla</option>

            </select>
            <br></td>
        </tr>
        <tr>
          <td>Specialization<br>
              <select name="specialization[]" size="8" class="textfield1" multiple>
                <?
include '../admean/db_connect.php';
$uSql = "SELECT specialization FROM specialization ORDER by sid ASC";
$uResult = mysql_query($uSql, $connection);
if(!$uResult){
echo 'no data found';
}
else{
while($uRow = mysql_fetch_row($uResult)){
?>
                <option value="<?= $uRow[0]?>">
                <?= $uRow[0]?>
                </option>
                <?
    }    
}
?>
            </select></td>
        </tr>
        <tr>
          <td>Position Level
            <select name="level[]" multiple>
              <option value="">Select Position Level</option>
              <?
		$uSql = "SELECT level FROM level";
		$uResult = mysql_query($uSql, $connection);
		if(!$uResult){
		echo 'no data found';
		}else{
		while($uRow = mysql_fetch_array($uResult)){
			?>
              <option value="<?= $uRow[level]?>">
              <?= $uRow[level]?>
              </option>
              <?
			}    
			}
			?>
            </select></td>
        </tr>
        <tr>
          <td>Job Type 
            <span class="text3">
            <input type="checkbox" name="jtype[]" value="Permanent" >
Permanent
<input type="checkbox" name="jtype[]" value="Contract" />
Contract
<input type="checkbox" name="jtype[]" value="Part-Time" />
Part-Time </span></td>
        </tr>
        <tr>
          <td><input type="submit" name="Submit" value="Submit"></td>
        </tr>
      </table>
</form>

 

 

and this is the code for my view3.php

<?php
include("../admean/pagina/my_pagina_class.php");

//-for the keywords, specialization .... condition
$cond1 = '';
if($_POST['keywords'] != ''){
$cond1 = " j_position LIKE '%". $_POST['keywords'] ."%'";
}
$cond2 = '';
if($_POST['specialization'] != ''){
$cond2 = " AND specialization LIKE '%". $_POST['specialization'] ."%'";
}
$cond3 = '';
if($_POST['country'] != ''){
$cond3 = " AND country = '". $_POST['country'] ."'";
}
$cond4 = '';
if($_POST['level'] != ''){
$cond4 = " AND level = '". $_POST['level'] ."'";
}
$cond5 = '';
if($_POST['jtype'] != ''){
$cond5 = " AND j_type = '". $_POST['jtype'] ."'";
}

//-for the drop down menu
if(isset($_GET['sort1']) && $_GET['sort1']!='')
     $sort1 = $_GET['sort1'];
else
     $sort1 = "j_position";


if(isset($_GET['sort2']) && $_GET['sort2']!='')
     $sort2 = $_GET['sort2'];
else
     $sort2 = "ASC";

//-	 
$test = new JHpage;
$test->sql = "SELECT * FROM job_ads WHERE j_status ='open' AND ".$cond1." ".$cond2." ".$cond3." ".$cond4." ".$cond5." ORDER BY ".$sort1 ." ".$sort2."";

// the (basic) sql statement (use the SQL whatever you like)
$result = $test->get_page_result(); // result set
$num_rows = $test->get_page_num_rows(); // number of records in result set 
$nav_links = $test->navigation(" | ", "currentStyle"); // the navigation links (define a CSS class selector for the current link)
$nav_info = $test->page_info(); // information about the number of records on page ("to" is the text between the number)
$simple_nav_links = $test->back_forward_link(true); // the navigation with only the back and forward links, use true to use images
$total_recs = $test->get_total_rows(); // the total number of records
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>:: Job HiRings - Contact Us ::</title>

<style type="text/css">
<!--
body {
background-image: url(../images/bg.gif);
}
-->
</style>
<link href="../css.css" rel="stylesheet" type="text/css">
<script type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
</head>

<body>
<table width="776" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><table width="776" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td colspan="3" valign="top"><img src="../images/main/top.gif" width="776" height="6"></td>
      </tr>
      <tr>
        <td width="6" align="left" valign="top" background="../images/main/left.gif"><img src="../images/main/left.gif" width="6" height="14"></td>
        <td width="764" bgcolor="#FFFFFF"><table width="764" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td colspan="2" valign="top"><img src="../images/contactus/flashmenu.gif" width="764" height="54"></td>
          </tr>
          <tr>
            <td width="525" valign="top" height="159"><img src="../images/contactus/flash02.gif" width="525" height="159"></td>
            <td width="239" valign="top">
				<!--start of search form-->
				<form method="post" action="view.php" name="searchform">
				<table width="239" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
                      <tr>
                        <td colspan="4" valign="top"><img src="../images/contactus/subquickjob01.gif" width="239" height="32"></td>
                      </tr>
                      <tr>
                        <td width="8" rowspan="8" align="left" background="../images/aboutus/subquickjob02.gif"><img src="../images/contactus/subquickjob02.gif" width="8" height="112"></td>
                        <td colspan="2" valign="top" class="text1"><img src="../images/spacer.gif" width="10" height="4"></td>
                        <td width="5" rowspan="8" align="right" background="../images/contactus/subquickjob03.gif"><img src="../images/contactus/subquickjob03.gif" width="5" height="112"></td>
                      </tr>
                      <tr>
                        <td colspan="2" class="text1"> Keywords</td>
                      </tr>
                      <tr>
                        <td colspan="2" align="right"><input name="keywords" type="text" class="field2">
                           </td>
                      </tr>
                      <tr>
                        <td colspan="2" align="right" valign="top"><span class="text1"><img src="../images/main/spacer.gif" width="1" height="1"></span></td>
                      </tr>
                      <tr>
                        <td colspan="2" class="text1"> Job Specialization </td>
                      </tr>
                      <tr>
                        <td colspan="2" align="right">
				  <select name="specialization" class="field3">
					  <option value="">All</option>
					<?
					 include '../admean/db_connect.php';
					$uSql = "SELECT specialization FROM specialization";
					$uResult = mysql_query($uSql, $connection);
					if(!$uResult){
					echo 'no data found';
					}else{
					while($uRow = mysql_fetch_row($uResult)){
						?>
					<option value="<?= $uRow[0]?>"><?= $uRow[0]?></option>
					  <?
						}    
						}
						?>
					  </select>
				    </td>
                      </tr>
                      <tr>
                        <td colspan="2" align="right" valign="top"><img src="../images/main/spacer.gif" width="1" height="1"></td>
                      </tr>
                      <tr>
                        <td width="155"> <a href="../asearch.php" class="link1">advanced search</a> </td>
                        <td width="71" align="right"><input name="Submit2" type="submit" class="button1" value="Search">
                           </td>
                      </tr>
                      <tr>
                        <td colspan="4" valign="top"><img src="../images/contactus/subquickjob04.gif" width="239" height="15"></td>
                      </tr>
                    </table>
				</form>
				<!--end of search form-->			</td>
          </tr>
          <tr>
            <td height="62" colspan="2" align="left" valign="top" bgcolor="#FFFFFF"><table width="764" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="181" valign="top" background="../images/contactus/middlebar03.gif"> </td>
                <td width="344" valign="top"><img src="../images/contactus/middlebar02.gif" width="344" height="50"></td>
                <td width="239" background="../images/contactus/middlebar03.gif"> </td>
              </tr>
              <tr>
                <td colspan="3" valign="top"> </td>
                </tr>
              <tr>
                <td colspan="3" valign="top"> </td>
              </tr>
              <tr>
                <td colspan="3" align="center" valign="top">
<table width="755" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="6"><img src="../admean/images/spacer.gif" width="6" height="10"></td>
    <td width="743" class="text9"><table width="216" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td colspan="3" valign="top" bgcolor="#666666"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td>
      </tr>
      <tr>
        <td align="left" bgcolor="#666666" width="1"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td>
        <td width="214" valign="top"><table width="741" border="0" cellspacing="2" cellpadding="0">
          <tr>
            <td colspan="5"><form method="get" action="view.php">
              <table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td width="450"><span class="text6">
                    <?php
				 echo "   total record found: " .$total_recs; ?>
                  </span></td>
                  <td width="287" align="right" class="text6"><span class="text7">sort by :</span>
                    <select name="sort1">
                        <option value="j_position">Position</option>
                        <option value="location">Location</option>
                        <option value="date_posted">Date Posted</option>
                      </select>
                     
                      <select name="sort2">
                        <option value="ASC">ASC</option>
                        <option value="DESC">DESC</option>
                      </select>
                      <input type="submit" name="Submit" value="Go" />
                       </td>
                </tr>
              </table>
            </form>
            </td>
          </tr>
          <tr>
            <td colspan="5"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td width="60%" align="left" class="text8"> </td>
                  <td width="39%" align="right"><!-- nav top -->
                      <?
				echo "<span class='link1'>".$nav_links."</span>";
				?>
                  </td>
                  <td width="1%" align="right"><img src="../image/spacer.gif" width="1" height="1" /></td>
                </tr>
            </table></td>
          </tr>
          <tr>
            <td width="78" bgcolor="950101" class="text9">  Date</td>
            <td width="212" valign="top" bgcolor="950101" class="text9">   Position </td>
            <td width="243" bgcolor="950101" class="text9">  Company </td>
            <td width="198" colspan="2" bgcolor="950101" class="text5">  <span class="text9">Location</span></td>
          </tr>
          <?php 
for ($i = 0; $i < $num_rows; $i++) {
$date_posted = mysql_result($result, $i, "date_posted");
$jobid = mysql_result($result, $i, "jobid");
$j_position = mysql_result($result, $i, "j_position");
$c_name = mysql_result($result, $i, "c_name");
$location = mysql_result($result, $i, "location");

?>
          <tr>
            <td bgcolor="#e5e5e5" class="text4">  <? echo "$date_posted"; ?></td>
            <td bgcolor="#e5e5e5">  <a href="javascript:;" class="link1" onClick="MM_openBrWindow('jobpost.php?jobid=<? echo "$jobid"; ?>','','scrollbars=yes,width=720,height=700')"><? echo "$j_position";?></a></td>
            <td bgcolor="#e5e5e5" class="text4">  <? echo "$c_name";?> </td>
            <td bgcolor="#e5e5e5" class="text4">  <? echo "$location";?>  </td>
          </tr>
          <?        
}
?>
          <tr>
            <td colspan="5" bgcolor="#950101"><img src="../admean/images/spacer.gif" width="10" height="2" /></td>
          </tr>
          <tr>
            <td colspan="5"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td width="60%" align="left" class="text8"> </td>
                  <td width="39%" align="right"><!-- nav top -->
                      <?
				echo "<span class='link1'>".$nav_links."</span>";
				?>
                  </td>
                  <td width="1%" align="right"><img src="../image/spacer.gif" width="1" height="1" /></td>
                </tr>
            </table></td>
          </tr>
  </form>
  
  <tr>
    <td colspan="5"> </td>
  </tr>
        </table></td>
        <td align="right" bgcolor="#666666" width="1"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td>
      </tr>
      <tr>
        <td colspan="3" valign="top" bgcolor="#666666"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td>
      </tr>
    </table></td>
    <td width="10"><img src="../admean/images/spacer.gif" width="6" height="10"></td>
  </tr>
</table>
			</td>
              </tr>
              <tr>
                <td colspan="3" valign="top"> </td>
              </tr>
              <tr>
                <td colspan="3" valign="top"> </td>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td colspan="2" valign="top" style="background:url(../images/main/footer.gif); background-repeat:no-repeat">
		<? include '../footer.php'; ?>
		</td>
          </tr>
        </table></td>
        <td width="6" background="../images/main/right.gif" align="right"><img src="../images/main/right.gif" width="6" height="3"></td>
      </tr>
      <tr>
        <td colspan="3" valign="bottom"><img src="../images/main/bottom.gif" width="776" height="8"></td>
      </tr>
    </table></td>
  </tr>
</table>
</body>
</html>

 

i am getting problem since i can't make it work and i am getting this errors on my view3.php

Notice: Undefined index: keywords in c:\hosting\webhost4life\member\diorgrace\new\jobsearch\view3.php on line 6

 

Notice: Undefined index: specialization in c:\hosting\webhost4life\member\diorgrace\new\jobsearch\view3.php on line 10

 

Notice: Undefined index: level in c:\hosting\webhost4life\member\diorgrace\new\jobsearch\view3.php on line 18

 

Notice: Undefined index: jtype in c:\hosting\webhost4life\member\diorgrace\new\jobsearch\view3.php on line 22

 

my basic search form is working and i just base the cond of view3.php from my basic search engine

but i cant make it work, maybe because now i am using selectbox with mulitple selections and checkbox too

 

hope you could help me fix this since i've been trying to solve this for couple of days already.

need help.

 

thanks a lot!

Link to comment
https://forums.phpfreaks.com/topic/41420-advanced-search-problem/
Share on other sites
iceman400 Newbie

iceman400

Posted
Posted

well first of all, your text field for keywords is called "textfield", that's y u get a "undefined index: keywords" error.

 

specialization is an array, so u cant get a value from $_POST[specialization]. try $_POST[specialization][0] or a foreach loop. or to check if it exists do a is_array instead of $_POST[specialization] != ' '.

 

same for jtype and level.

 

 

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.