Dynamic query php/ mysql

Question

I have some issues with a dynamic query:

    $cond = array();

    if (!empty($type_contrat)) {
        $cond[] = "job_offers.type_contrat = '$type_contrat'";
    }

    if (!empty($categorie_poste)) {
        $cond[] = "job_offers.cat_poste = '$categorie_poste'";
    }

    if (!empty($niveau_etudes)) {
        $cond[] = "job_offers.qualifications = '$niveau_etudes'";
    }

    if (!empty($experience)) {
        $cond[] = "job_offers.experience >= '$experience'";
    }       

    if (count($cond)) {

                $query = $mysqli->query('SELECT 
                job_offers.ref_org,
                job_offers.titre,
                job_offers.qualifications,
                job_offers.experience,
                job_offers.cat_poste,
                job_offers.type_contrat,
                job_offers.taux_occupation,
                job_offers.lieu_affectation,
                job_offers.pays,
                job_offers.url,
                job_offers.date_entered,
                job_offers.date_expire,
                organisations.ref_org,
                organisations.name_organisation
                FROM job_offers,organisations
                WHERE job_offers.ref_org = organisations.ref_org AND ');

                $query .=  implode(' AND ', $cond);
    }


    print_r($query);

--> result: prints only (linebreaks added for readability):

job_offers.type_contrat = '1' AND
job_offers.cat_poste = '3' AND
job_offers.qualifications = '2' AND
job_offers.experience >= '1'

and therefore no result.

did my answer fix the problem for you?

RichardBernards
– RichardBernards

2014-10-17 09:59:02 +00:00
Commented Oct 17, 2014 at 9:59 — RichardBernards
– RichardBernards, Commented Oct 17, 2014 at 9:59

RichardBernards · Accepted Answer · 2014-10-13 15:27:58Z

2

You are trying to append a string to a mysqli-result object...

Check the returnvalue of the mysqli->result() function here.

Since someone is keen on removing this answer; here's your solution:

    $cond = array();

    if (!empty($type_contrat)) {
        $cond[] = "job_offers.type_contrat = '$type_contrat'";
    }

    if (!empty($categorie_poste)) {
        $cond[] = "job_offers.cat_poste = '$categorie_poste'";
    }

    if (!empty($niveau_etudes)) {
        $cond[] = "job_offers.qualifications = '$niveau_etudes'";
    }

    if (!empty($experience)) {
        $cond[] = "job_offers.experience >= '$experience'";
    }       

    if (count($cond)) {

                $query = $mysqli->query('SELECT 
                job_offers.ref_org,
                job_offers.titre,
                job_offers.qualifications,
                job_offers.experience,
                job_offers.cat_poste,
                job_offers.type_contrat,
                job_offers.taux_occupation,
                job_offers.lieu_affectation,
                job_offers.pays,
                job_offers.url,
                job_offers.date_entered,
                job_offers.date_expire,
                organisations.ref_org,
                organisations.name_organisation
                FROM job_offers,organisations
                WHERE job_offers.ref_org = organisations.ref_org AND '.implode(' AND ', $cond));
    }


    print_r($query);

answered Oct 13, 2014 at 15:27

RichardBernards

3,0971 gold badge25 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dany Caissy Over a year ago

Ah I didn't see he was executing the query before adding to it, you're right.

Collectives™ on Stack Overflow

Dynamic query php/ mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related