search a MySql table using PHP

nicedad · November 12, 2015

Hello everyone,
I'm trying to create a search drop down menu to search a Mysql table, unfortunately the search does work. even though it was working but I don't know what I did in wrong way.
can anyone help and locate the mistake, please notice that there is not any error. it just does not retrieve any record from the DB.

<?php
session_start();
require_once("common/DAO.php");
require_once("./common/config.php");
require_once("classes/class.jobs.php");
require_once("services/MemberService.php");

$objUser = new Jobs();
$location = "";
$Jqualify = "";

$searchCondition = "";
if(!empty($_POST["search"])) {
	foreach($_POST["search"] as $k=>$v){
		if(!empty($v)) {
			$queryCases = array("location","Jqualify");
			if(in_array($k,$queryCases)) {

			}
			switch($k) {
				case "location":
					$location = $v;
					$searchCondition .= "where location LIKE '" . $v . "%'";
					break;
				case "Jqualify":
					$Jqualify = $v;
					if(strlen($searchCondition)>1)
						$searchCondition .= "and Jqualify LIKE '" . $v . "%'";
					else
						$searchCondition .= "where Jqualify LIKE '" . $v . "%'";
					break;
			}
		}
	}
}
$userList = $objUser->getJobs($searchCondition);
?>

<!DOCTYPE html>
<html lang="en">
  <head>
     <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Integrationsdienste</title>
<link href="css/style.css" rel="stylesheet" type="text/css" />
    <meta name="description" content="">
    <meta name="author" content="templatemo">
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <link href="css/templatemo_justified.css" rel="stylesheet">
    <!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
      <script src="js/html5shiv.js"></script>
      <script src="js/respond.min.js"></script>
    <![endif]-->
	<style>
	.btnjoin {
		padding: 5px 20px;
		border-radius: 4px;
		margin-bottom: 10px;
		color: #F0F8FF;
		background-color: #3CB6CB;
		border: none;
		cursor: pointer;
	}

    .table-striped>tbody>tr:nth-child(odd)>td,
.table-striped>tbody>tr:nth-child(odd)>th {
	background-color: #DDDDDD;
}

.table-striped>tbody>tr:nth-child(odd)>th {

	background-color: #bbb;
}

.space5 {
    margin-top: 5px;
}

p.test {
    width: 27em; 
    
    word-wrap: break-word;
}

	</style>

  </head>

  <body>

    <div id="container" class="container">

<a href="http://www.templatemo.com/preview/templatemo_382_simplex" rel="nofollow">
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000"
codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0"
width="468" height="60"
<param name="movie" value="banner.swf"<param name="quality" value="high" /><param name="bgcolor" value="#ffffff"/>
		<embed src="banner.swf" quality="high" bgcolor="#ffffff" width="1140" height="300"
name="banner" align="" type="application/x-shockwave-flash"
pluginspage="http://www.macromedia.com/go/getflashplayer">
</embed></object>
</a>

<ul class="nav nav-justified">
  <ul class="nav nav-justified">
  <li class=""><a href="index.html">Home</a></li>
  <li><a href="about.html">Über Uns</a></li>
  <li><a href="services.html">Service</a></li>
  <li><a href="datenbank.php">Datenbank</a></li>
  <li><a href="jobs.html">Jobs</a></li>
  <li><a href="contact.html">Contact</a></li>
</ul>
  <div class="row space30"> <!-- row 1 begins -->      
	<div class="col-md-12">
    
		<a href="login.php" class="btnjoin  pull-right" style="padding:5px 29px;margin-right:10px;"> Login/ Anmelden</a>
		<a href="jobs.php" class="btnjoin  pull-right">Jobs</a>
		<a href="datenbank.php" class="btnjoin  pull-right">Bewerber</a>
		
                     

<?php if(!empty($userList["total_records"])) { ?>
	<div class="left"> <span style="color: #240CF7"><strong>
	<?php echo $userList["total_records"]; ?></strong></span> <span style="color: #0E3CEF; font-size: 14px;">Jobs verfügbar 
    
    </span></div>
<?php } ?>


 

<form method="post">
<div class="row space30"> <!-- row 2 begins -->
	<div  class="col-md-12 text-center">
	  <?php
	$userCity = $objUser->getJobByLocation();
	?>
	<select name="search[location]" style="min-width: 150px;padding: 3px;margin-right:25px;">
	<option value="">Kanton auswählen</option>
	<?php
	if(!empty($userCity)) {
	foreach($userCity as $k=>$v) {
	?>
<option value="<?php echo $userCity[$k]["location"]; ?>" <?php if($userCity[$k]["location"] == $location) { echo "selected"; } ?>><?php echo $userCity[$k]["location"]; ?></option>
	<?php
	}
	}
	?>
	</select>
	<?php
	$userOccupation = $objUser->getQualification();
	?>
	<select name="search[location]" style="min-width: 150px;padding: 3px;">
	<option value="">Beruf auswählen</option>
	<?php
	if(!empty($userOccupation)) {
	foreach($userOccupation as $k=>$v) {
	?>
	<option value="<?php echo $userOccupation[$k]["Jqualify"]; ?>" <?php if($userOccupation[$k]["Jqualify"] == $Jqualify) { echo "selected"; } ?>>
	<?php echo $userOccupation[$k]["Jqualify"]; ?></option>
	<?php
	}
	}
	?>
	</select>
	<input type="submit" name="go" value="Search" style="border-color: none;border: 2px outset buttonface;padding: 2px 45px;margin-left: 20px;" >
	<input type="reset" value="Reset" style="border-color: none;border: 2px outset buttonface;padding: 2px 45px;margin-left: 10px;" onclick="window.location='jobs.php'">
	</div>
</div>
<?php
if(!empty($userList)) {
?>
      	<div class="row space5"> <!-- row 3 begins -->
		<div  class="col-md-12">
            <table class="table table-striped">
            <tr>
			<th style="width: 10%;">Firmenname</th>
			<th style="width: 10%;">Job Title</th>
			<th style="width: 30%;">Job Beschreibung</th>
			<th style="width: 10%;">Erfahrung</th>
			<th style="width: 10%;">Kanton</th>
			<th style="width: 10%;">Branche</th>
			<!--<th style="width: 10%;">Job Type</th>!-->
			<!--<th style="width: 10%;">Qualifikation</th>!-->
			<th style="width: 10%;">Vertragsart</th>
			<th style="width: 10%;">Gehalt/ Stunde</th></tr>
<?php

    foreach($userList as $i => $value) {
		if(is_numeric($i)) {
?>
<tr>
    <td><?php echo $userList[$i]["comp_name"]; ?></td>
	<td><?php echo $userList[$i]["jobtitle"]; ?></td>
	<!--<?php echo $userList[$i]["job_description"];?></td>!-->
	<td><?php echo nl2br($userList[$i]["job_description"], "<br/>\n"); ?></td>
    <td><?php echo $userList[$i]["minexp"]; ?> - <?php echo $userList[$i]["maxexp"]; ?></td>
	<td><?php echo $userList[$i]["location"]; ?></td>
	<td><?php echo $userList[$i]["Jqualify"]; ?></td>
    <td><?php echo $userList[$i]["JContract"]; ?></td>
<!--<td><?php echo $userList[$i]["Jtype"]; ?></td>!-->
<!--<td><?php echo $userList[$i]["Jqualify"]; ?></td>!-->
	<td><?php echo $userList[$i]["minsal"]; ?> - <?php echo $userList[$i]["maxsal"]; ?></td>

</tr>
<?php
		}
	}//for close
?>
		</table>
		</div>
		</div>

<?php if(!empty($userList["perpage"])) { ?>
	<div class="pagination center"><?php echo $userList["perpage"]; ?></div>
<?php } ?>
<?php
}//if close
?>
</form>


      <!-- Site footer -->
      <div class="footer">
        <p><center>© Copyright 2015 | Ausländer und Integrations Dienste | <a rel="nofollow" href="http://www.a-Integrationsdienste.ch">www.a-Integrationsdienste.ch</a></center>
               </div>

    </div> <!-- /container -->

    <!-- Bootstrap core JavaScript
    ================================================== -->
    <!-- Placed at the end of the document so the pages load faster -->
    </ul>


  </body>
</html>

QuickOldCar · November 13, 2015

Hard to say because do not see the rest of the code for all your includes.

//This part does nothing useful as is

$queryCases = array("location","Jqualify");
if(in_array($k,$queryCases)) {

}

switch($k) {
               case "location":
                   $location = $v;//why define this as $v and not use it
                   $searchCondition .= " where location LIKE '" . $v . "%'";
                   break;
               case "Jqualify":
                   $Jqualify = $v;//why define this as $v and not use it
                   if(strlen($searchCondition)>1){
                       $searchCondition .= " and Jqualify LIKE '" . $v . "%'";
                    }else{
                       $searchCondition .= " where Jqualify LIKE '" . $v . "%'";

                    }
                   break;
           }

echo out the value of $searchCondition

do a var_dump() on $userList and post it here

nicedad · November 16, 2015

Hi QuickOldCar,

thanx for your replay, you're right the Problem has to do with another file.

Sign In

search a MySql table using PHP

Recommended Posts

nicedad

Link to comment

Share on other sites

QuickOldCar

Link to comment

Share on other sites

nicedad

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information