Multiple criteria search using php

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
adelekepc
Forum Newbie
Posts: 3
Joined: Thu Apr 19, 2012 2:51 pm

Multiple criteria search using php

Post by adelekepc »

Hello guys, Please, I need help concerning a multiple criteria search form using php. Can somebody help me out here.
Below is my form

Code: Select all

<form "search" method="get" action="searchdetails.php">
<table align="center" border="1" cellpadding="5" cellspacing="0" width="750"> 
  <tr>
    <th colspan="2" scope="col">SEARCH CV</th>
    </tr>
    <tr>
    <td width="236">Vacancy Code</td>
    <td width="488"><input type="Text" name="vacancycode"  id="vacancycode"style="width: 180px;" value=""></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td width="236">Keyword(s)</td>
    <td width="488"><input type="Text" name="keyword"  id="keyword"style="width: 180px;" value=""></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Experience</td>
    <td>From:
      <select name="exp1" id="exp1">
        <option>1</option>
        <option>2</option>
        <option>3</option>
        <option>5</option>
        <option>6</option>
        <option>7</option>
        <option>8</option>
        <option>9</option>
        <option>10</option>
        <option>11</option>
        <option>12</option>
        <option>13</option>
        <option>14</option>
        <option>15</option>
        <option>16</option>
        <option>17</option>
        <option>18</option>
        <option>19</option>
        <option>20</option>
      </select>
To:

      <select name="exp2" id="exp2">
<option>1</option>
                        <option>2</option>
                        <option>3</option>
                        <option>5</option>
                        <option>6</option>
                        <option>7</option>
                        <option>8</option>
                        <option>9</option>
                        <option>10</option>
                        <option>11</option>
                        <option>12</option>
                        <option>13</option>
                        <option>14</option>
                        <option>15</option>
                        <option>16</option>
                        <option>17</option>
                        <option>18</option>
                        <option>19</option>
                        <option>20</option>
                      </select> in years</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Industry</td>
    <td><select name="sector" id="sector" style="width: 170px;"> 
		<option value="">Please select</option>
        <option value="accounting">ACCOUNTING</option>
<option value="actuary">ACTUARY</option>
<option value="aerospace">AEROSPACE</option>
<option value="agriculture">AGRICULTURE</option>
<option value="airline_operator">AIRLINE OPERATIONS</option>
<option value="architecture">ARCHITECTURE</option>
<option value="arts_entertainment_media">ARTS,ENTERTAINMENT & MEDIA</option>
<option value="banking">BANKING</option>
<option value="business_administration">BUSINESS ADMINISTRATION</option>
<option value="catering">CATERING</option>
<option value="communication">COMMUNICATION</option>
<option value="conservation">CONSERVATION</option>
<option value="construction">CONSTRUCTION</option>
<option value="consultancy">CONSULTANCY</option>
<option value="ecology">ECOLOGY</option>
<option value="economics_planning">ECONOMICS & PLANNING</option>
<option value="education">EDUCATION</option>
<option value="energy_powermanagement">ENERGY/POWER MANAGEMENT</option>
<option value="engineering_chemical">ENGINEERING - CHEMICAL</option>
<option value="engineering_electrical">ENGINEERING - ELECTRICAL</option>
<option value="engineering_mechanical">ENGINEERING - MECHANICAL</option>
<option value="engineering_civil">ENGINEERING - CIVIL</option>
<option value="engineering_electronics">ENGINEERING - ELECTRONICS</option>
<option value="engineering_others">ENGINEERING - OTHERS</option>
<option value="environment">ENVIRONMENT</option>
<option value="estate_management">ESTATE MANAGEMENT</option>
<option value="finance">FINANCE</option>
<option value="fmcg">FMCG</option>
<option value="graduate_middlemanagement">GRADUATE - MIDDLE MANAGEMENT</option>
<option value="health">HEALTH</option>
<option value="hotels_resorts_resturants">HOTELS, RESORTS & RESTURANTS</option>
<option value="human_resource">HUMAN RESOURCE</option>
<option value="humanities">HUMANITIES</option>
<option value="humanitarian">HUMANITARIAN</option>
<option value="IT">INFORMATION TECHNOLOGY</option>
<option value="insurance">INSURANCE</option>
<option value="international_development">INTERNATIONAL DEVELOPMENT</option>
<option value="internship">INTERNSHIP</option>
<option value="journalism">JOURNALISM</option>
<option value="legal">LEGAL</option>
<option value="logistics">LOGISTICS</option>
<option value="management_executives">MANAGEMENT & EXECUTIVES</option>
<option value="manufacturing">MANUFACTURING</option>
<option value="maritime">MARITIME</option>
<option value="marketing_promotion">MARKETING - PROMOTION</option>
<option value="medical">MEDICAL</option>
<option value="oilgas_upstream">OIL & GAS - UP STREAM</option>
<option value="oilgas_midstream">OIL & GAS - MID STREAM</option>
<option value="oilgas_downstream">OIL & GAS - DOWN STREAM</option>
<option value="pharmaceutical">PHARMACEUTICAL</option>
<option value="politics">POLITICS</option>
<option value="public_policy">PUBLIC POLICY</option>
<option value="public_sector">PUBLIC SECTOR</option>
<option value="public_utility">PUBLIC UTILITY</option>
<option value="purchasing_procurement">PURCHASING & PROCUREMENT</option>
<option value="quantity_surveying">QUANTITY SURVEYING</option>
<option value="real_estate">REAL ESTATE</option>
<option value="religious">RELIGIOUS</option>
<option value="research">RESEARCH</option>
<option value="rural_development">RURAL DEVELOPMENT</option>
<option value="sales">SALES</option>
<option value="science_technical">SCIENCE & TECHNICAL</option>
<option value="security_military">SECURITY / MILITARY</option>
<option value="social_affairs">SOCIAL AFFAIRS</option>
<option value="social_sciences">SOCIAL SCIENCES</option>
<option value="telecommunication">TELECOMMUNICATION</option>
<option value="tourism_travel">TOURISM & TRAVEL</option>
<option value="transportation">TRANSPORTATION</option>
<option value="urban_development">RBAN DEVELOPMENT</option>
<option value="volunteership">VOLUNTEERSHIP</option>
<option value="water_development">WATER DEVELOPMENT</option>
<option value="wildlife">WILD LIFE</option>
        </select></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Education Level</td>
    <td><select name="edulevel" id="edulevel" style="width: 160px;"> 
		<option value="0">--Select--</option>
                             <option>MBA/PGD</option>
                             <option>Bachelor</option>
                             <option>HND</option>
                             <option>OND</option>
                             <option>Others</option>
                           </select></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Language</td>
    <td><select name="language" id="language" style="width: 110px;"> 
		<option value="">Please select</option>
        <option >English</option>
        <option> French</option>
        <option>Arabic</option>
        </select></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Country</td>
    <td><select name="country" id="country" style="width: 221px;"> 
		<option value="">Please select</option>
		
			  <option >Albania</option>
                    <option >Algeria</option>
                    <option >Andorra</option>
                    <option >Angola</option>
                    <option >Antigua</option>
                    <option >Argentina</option>
                    <option >Australia</option>
                    <option >Austria</option>
                    <option >Azerbaijan</option>
                    <option >Bahamas</option>
                    <option >Bahrain</option>
                    <option >Bangladesh</option>
                    <option >Barbados</option>
                    <option >Belgium</option>
                    <option >Bermuda</option>
                    <option >Bosnia-Herzegovina</option>
                    <option >Brazil</option>
                    <option >Bulgaria</option>
                    <option >Canada</option>
                    <option >Cayman Islands</option>
                    <option>Chile</option>
                    <option>China</option>
                    <option >Colombia</option>
                    <option >Costa Rica</option>
                    <option >Croatia</option>
                    <option >Cyprus</option>
                    <option >Czech Republic</option>
                    <option >Denmark</option>
                    <option >Dominican Rep</option>
                    <option >Egypt</option>
                    <option>El Salvador</option>
                    <option >Estonia</option>
                    <option >Ethiopia</option>
                    <option >Finland</option>
                    <option >France</option>
                    <option >Georgia</option>
                    <option >Germany</option>
                    <option >Ghana</option>
                    <option >Gibraltar (UK)</option>
                    <option>Greece</option>
                    <option >Grenada</option>
                    <option >Guatemala</option>
                    <option >Hong Kong</option>
                    <option>Hungary</option>
                    <option >Iceland</option>
                    <option >India</option>
                    <option >Indonesia</option>
                    <option >Ireland</option>
                    <option >Israel</option>
                    <option >Italy</option>
                    <option >Jamaica</option>
                    <option >Japan</option>
                    <option >Jordan</option>
                    <option >Kenya</option>
                    <option >Kuwait</option>
                    <option >Latvia</option>
                    <option >Lebanon</option>
                    <option >Lithuania</option>
                    <option >Luxembourg</option>
                    <option>Malaysia</option>
                    <option >Maldives</option>
                    <option >Malta</option>
                    <option >Mauritius</option>
                    <option >Mexico</option>
                    <option >Monaco</option>
                    <option >Montenegro</option>
                    <option >Morocco</option>
                    <option >Netherland Antilles</option>
                    <option >Netherlands</option>
                    <option >New Zealand</option>
                    <option >Nigeria</option>
                    <option >Norway</option>
                    <option >Oman</option>
                    <option >Pakistan</option>
                    <option>Panama</option>
                    <option >Peru</option>

                    <option >Philippines</option>
                    <option >Poland</option>
                    <option >Portugal</option>
                    <option >Puerto Rico</option>
                    <option >Qatar</option>
                    <option >Romania</option>
                    <option >Russia</option>
                    <option >Saudi Arabia</option>
                    <option >Serbia</option>
                    <option >Singapore</option>
                    <option >Slovakia</option>
                    <option >South Africa</option>
                    <option >South Korea</option>
                    <option >Spain</option>
                    <option >St Kitts and Nevis</option>
                    <option >St Lucia</option>
                    <option >Sweden</option>
                    <option >Switzerland</option>
                    <option >Syria</option>
                    <option >Taiwan</option>
                    <option >Tanzania</option>
                    <option >Thailand</option>
                    <option >Trinidad and Tobago</option>
                    <option >Tunisia</option>
                    <option >Turkey</option>
                    <option >Turks Caicos</option>
                    <option >USA</option>
                    <option >Uganda</option>
                    <option >Ukraine</option>
                    <option >United Arab Emirates</option>
                    <option >United Kingdom</option>
                    <option >Vatican City</option>
                    <option >Vietnam</option>
                    <option>Zambia</option>
                    <option >Zimbabwe</option>
                    <option >[Other country]</option></select></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Nationality / Country of Origin</td>
    <td><select name="nationality" id="nationality" style="width: 221px;"> 
		<option value="">Please select</option>
		
			  <option >Albania</option>
                    <option >Algeria</option>
                    <option >Andorra</option>
                    <option >Angola</option>
                    <option >Antigua</option>
                    <option >Argentina</option>
                    <option >Australia</option>
                    <option >Austria</option>
                    <option >Azerbaijan</option>
                    <option >Bahamas</option>
                    <option >Bahrain</option>
                    <option >Bangladesh</option>
                    <option >Barbados</option>
                    <option >Belgium</option>
                    <option >Bermuda</option>
                    <option >Bosnia-Herzegovina</option>
                    <option >Brazil</option>
                    <option >Bulgaria</option>
                    <option >Canada</option>
                    <option >Cayman Islands</option>
                    <option>Chile</option>
                    <option>China</option>
                    <option >Colombia</option>
                    <option >Costa Rica</option>
                    <option >Croatia</option>
                    <option >Cyprus</option>
                    <option >Czech Republic</option>
                    <option >Denmark</option>
                    <option >Dominican Rep</option>
                    <option >Egypt</option>
                    <option>El Salvador</option>
                    <option >Estonia</option>
                    <option >Ethiopia</option>
                    <option >Finland</option>
                    <option >France</option>
                    <option >Georgia</option>
                    <option >Germany</option>
                    <option >Ghana</option>
                    <option >Gibraltar (UK)</option>
                    <option>Greece</option>
                    <option >Grenada</option>
                    <option >Guatemala</option>
                    <option >Hong Kong</option>
                    <option>Hungary</option>
                    <option >Iceland</option>
                    <option >India</option>
                    <option >Indonesia</option>
                    <option >Ireland</option>
                    <option >Israel</option>
                    <option >Italy</option>
                    <option >Jamaica</option>
                    <option >Japan</option>
                    <option >Jordan</option>
                    <option >Kenya</option>
                    <option >Kuwait</option>
                    <option >Latvia</option>
                    <option >Lebanon</option>
                    <option >Lithuania</option>
                    <option >Luxembourg</option>
                    <option>Malaysia</option>
                    <option >Maldives</option>
                    <option >Malta</option>
                    <option >Mauritius</option>
                    <option >Mexico</option>
                    <option >Monaco</option>
                    <option >Montenegro</option>
                    <option >Morocco</option>
                    <option >Netherland Antilles</option>
                    <option >Netherlands</option>
                    <option >New Zealand</option>
                    <option selected="selected" >Nigeria</option>
                    <option >Norway</option>
                    <option >Oman</option>
                    <option >Pakistan</option>
                    <option>Panama</option>
                    <option >Peru</option>

                    <option >Philippines</option>
                    <option >Poland</option>
                    <option >Portugal</option>
                    <option >Puerto Rico</option>
                    <option >Qatar</option>
                    <option >Romania</option>
                    <option >Russia</option>
                    <option >Saudi Arabia</option>
                    <option >Serbia</option>
                    <option >Singapore</option>
                    <option >Slovakia</option>
                    <option >South Africa</option>
                    <option >South Korea</option>
                    <option >Spain</option>
                    <option >St Kitts and Nevis</option>
                    <option >St Lucia</option>
                    <option >Sweden</option>
                    <option >Switzerland</option>
                    <option >Syria</option>
                    <option >Taiwan</option>
                    <option >Tanzania</option>
                    <option >Thailand</option>
                    <option >Trinidad and Tobago</option>
                    <option >Tunisia</option>
                    <option >Turkey</option>
                    <option >Turks Caicos</option>
                    <option >USA</option>
                    <option >Uganda</option>
                    <option >Ukraine</option>
                    <option >United Arab Emirates</option>
                    <option >United Kingdom</option>
                    <option >Vatican City</option>
                    <option >Vietnam</option>
                    <option>Zambia</option>
                    <option >Zimbabwe</option>
                    <option >[Other country]</option></select></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td colspan="2" align="center"><input type="Submit" value="Search" class="button" ></td>
    </tr>
  
</table>

</form>


User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: Multiple criteria search using php

Post by Celauran »

What is it exactly you need help with? What have you written so far? Where are you running into trouble?
adelekepc
Forum Newbie
Posts: 3
Joined: Thu Apr 19, 2012 2:51 pm

Re: Multiple criteria search using php

Post by adelekepc »

Thank You,
I was able to search with only one of the criteria but what I need is able to search with more than one criteria at a time and generate the report, so my issue is to be able to do multiple search
Post Reply