Trying to modify a Search to use mysqli help

[Mitka]

Hi,

I'm trying to modify a search code but I'm not able to get any results and I'm not getting any errors.

 

The page is supposed to allow the user to search by one or multiple fields and return the according results.

 

The code was originally using the depreciated MySQL and I was trying to modify to MYSQLI.

 

I'm not sure that I'm using it correctly.

 

I have attached the files. If anyone can look at it and possibly correct it I'd greatly appreciate it.

 

Attached Files:

index.html - User Search Page

search.php - Search Code

Users.txt - Data I've been using (rename to csv).

 

I'm using WAMP.

 

Thanks,

Mitka

index.html

search.php

Users.txt

[QuickOldCar]

Place this the top of your search.php and see if any errors

error_reporting(E_ALL | E_NOTICE);
ini_set('display_errors', '1');

You have a $conn instead of $con line 7 in search.php

 

Try that and can look more if need it.

[Mitka]

Hi,

Didn't make a difference.

 

The code you gave didn't do anything.

 

Mitka

[mac_gyver]

if would help if you told us or showed us what output you are getting. just telling us you are getting no result can mean a number of different things. what output are you getting from the code?

 

as to the mysqli code, your connection and connection error checking is a mix of procedural and oop usage that isn't correct. it also looks like it had a trigger_error() statement in it at one point that got removed. the php.net documentation contains examples of using procedural code to make a connection and testing if the connection worked. you should start by reading the documentation.