Jump to content
Sign in to follow this  
user123356

Creating a Research in Database

Recommended Posts

Hi! I'm new at php and

I need a help with this code I need to Search an employee from a Database that I already have I have the Search Form and I write the name and the lastname and the details of the employee appear, But I need help. I already have the search, but I tells me when I call the query that I have a fatal error  Trying to get property of non-object in    in this part of the code   

$count = $query -> num_rows;
and this  Fatal error: Call to undefined method EmployeeModel::searchEmployees()  in here  

$employees = $this->model->searchE($_GET['str']);
require_once('views/search.php');
  where I need to call this function in search.php 

 

I'm gonna leave my search.php

  I need a big help here I'm gonna be really thankfull

 

 <form method="get" action="index.php" name="searchform" id="searchform">
<input type="text" name="str" id="str">
<input type="submit" name="submit" id="submit" value="Search">
</form>
<?php
 
/*class SearchE
{*/
 
$user = "root"; 
$password = ""; 
$host = "localhost"; 
$dbase = "employees_assign"; 
$table = "tbl_employees";
 
 
 
 
 
 
$search_term= isset($_GET['str']) ? $_GET['str'] : '';
 
/*mysqli_connect($host,$user,$password); 
@mysqli_select_db($dbase) or die("Unable to select database");*/
 
$connect = mysqli_connect('localhost','root','','employees_assign');
 
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
 
 
$sql = "SELECT * FROM tbl_employees WHERE emp_fname LIKE '%$search_term%' 
  OR emp_lnames LIKE '%$search_term%'";
//$query = mysqli_query($connect,$sql);
 
$query = $connect ->query($sql);
 
//$count= mysqli_num_rows(mysqli_result $query);
$count = $query -> num_rows;
//$count=$query->num_rows;
/*if ($query === false) {
  error_log($connect->error);
  die("something failed.");
}*/
 
 
if ($count == 0)
{
echo "<fieldset><b>No Results Found for Search Query '$search_term'</b></fieldset>";
}
else
{
print "<table border=1>\n"; 
while ($row = mysqli_fetch_array($query)){ 
 
$emp_fname= $row['emp_fname'];
$emp_lname= $row['emp_lname'];
print "<tr>\n"; 
 
print "</td>\n";
print "\t<td>\n"; 
print "<font face=arial size=4/><div align=center>$emp_fname</div></font>"; 
print "</td>\n";
print "\t<td>\n"; 
echo "<font face=arial size=4/>$emp_lname</font>";
print "</td>\n";
print "</tr>\n"; 
} 
 
print "</table>\n"; 
}
 
/*}*/
?>   
Edited by requinix
fixing messed up bbcode

Share this post


Link to post
Share on other sites

/*if ($query === false) {
  error_log($connect->error);
  die("something failed.");
}*/
Make that work, try again, and check your error log.

 

As for the other error, that's something completely unrelated to the code you've shown.

Share this post


Link to post
Share on other sites

It tells me that 

 

) Notice: Trying to get property of non-object in C:\wamp64\www\employees_done\views\emp_search.php on line 41Call Stack#TimeMemoryFunctionLocation10.0016235768{main}( )...\index.php:020.0099274384Employee->loadViews( )...\index.php:830.0131285872require_once( p' )...\Employee.php:19

Share this post


Link to post
Share on other sites

Well that doesn't make sense: presumably the error message is talking about

error_log($connect->error);
so $connect is the "non-object" mentioned. But if that were the case then

$query = $connect ->query($sql);
that line would have failed catastrophically and everything after wouldn't even happen.

 

Therefore there's a misunderstanding somewhere.

 

$connect = mysqli_connect('localhost','root','','employees_assign');
echo "connect is ";
var_dump($connect);
What does that output? Then,

$query = $connect ->query($sql);
echo "query is ";
var_dump($query);
what about that?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • 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.