Issue with PHP Like query

Question

I have a PHP error I cannot seem to fix with this code

$_POST['location'] = 'Northern Province';
$_POST['transport'] = 'transport';

if (isset($_POST['location'])) {
    $region = "%{$_POST['region']}%";
    $transport = "%{$_POST['transport']}%";
    $stmt = $conn->prepare("SELECT users.id, users.email, users.profilePhoto, users.userType, organization.userFk, organization.name, organization.specialization from users, organization WHERE users.id = organization.userFk AND organization.specialization LIKE ? AND users.region LIKE ?");
    $stmt->bind_param("ss", $transport, $regions);
    $stmt->execute();
    $response["transPortCompanies"] = array();
    $stmt->bind_result($id, $email, $profilePhoto, $userType, $userFk, $name, $specialization);

    while($row = $stmt->fetch()) {
        $company = array();
        $company["id"] = $id;
        $company["email"] = $email;  
        $company["profilePhoto"] = $profilePhoto;
        $company["name"] = $name;
        $company["specialization"] = $specialization;
        $response["message"] = "Loaded";
        $response["error"] = FALSE;
        array_push($response["transPortCompanies"], $company);
    }
    echo json_encode($response);

Apparently it returns an empty companies list, but when I hardcode it like

SELECT users.id, users.email, users.profilePhoto, users.userType, organization.userFk, organization.name, organization.specialization from users, organization WHERE users.id = organization.userFk AND organization.specialization LIKE '%transport%' AND users.region LIKE '%Northern Province%'

I get my my output, so am wondering where am I going wrong? I have another script that does searching and that is how I implemented it

i have question with me. if there is no **relationship** between these two tables ? why not you use join them ? — Karthi, Nov 19 '16 at 09:53
@Karthi I plan on doing that, but for now I want the query to work, if it does them I plan on replacing it with a join — Thandi Ngamu, Nov 19 '16 at 09:59
Having used error reporting http://php.net/manual/en/function.error-reporting.php would have more than likely avoided this question. — Funk Forty Niner, Nov 19 '16 at 15:59

score 2 · Accepted Answer · answered Nov 19 '16 at 10:01

2

I guess you have typo

bind_param("ss", $transport, $region); // "region", not "regionS"

answered Nov 19 '16 at 10:01

AlexandrX

806
8
18

@ThandiNgamu, this solution should work for you. – Rajdeep Paul Nov 19 '16 at 10:05
:D php isnt there an IDE that checks some of these things? thanks a lot that worked. – Thandi Ngamu Nov 19 '16 at 10:06
@RajdeepPaul thank you as well for the effort, I couldnt have done it – Thandi Ngamu Nov 19 '16 at 10:06

Issue with PHP Like query

1 Answers1