Medoo - Updating table row matching multiple field

Question

I am using Medoo. the update below works fine with single field match. I want to update data if match with clientId and businessCity.

$database->update("clientInfo", array(
     "businessName" => $_POST['businessName'],
     "contactName" => $_POST['contactName'],
     "businessEmail" => $_POST['businessEmail'],
     "businessPhone" => $_POST['businessPhone'],
     "businessWebsite" => $_POST['businessWebsite'],
     "businessAddress" => $_POST['businessAddress'],
     "businessAddress2" => $_POST['businessAddress2'],
     "businessCity" => $_POST['businessCity'],
     "businessState" => $_POST['businessState'],
     "businessZip" => $_POST['businessZip']
), array(
    "clientId" => $_POST['clientId'],
    "businessCity" => $_POST['businessCity'],
));

I tried like this. but not working for me.

are u using medoo OR cakephp ? bcoz it does not seem to be cakephp UPDATE — Pratik Joshi, Nov 11 '14 at 06:29
Hi Why didn't go for cakePHP , Do u think medoo Is better ? :) haha — Pratik Joshi, Nov 11 '14 at 06:45

score 1 · Answer 1 · answered Nov 17 '14 at 17:39

1

echo $database->last_query();

use this function to check out the SQL query performed for debug.

answered Nov 17 '14 at 17:39

Deror

51
3

score 1 · Answer 2 · answered Feb 21 '15 at 21:08

Read about the Relativity Condition from Medoo documentation: http://medoo.in/api/where

Just add AND connector to each value.

$database->update("clientInfo", array(
     "businessName" => $_POST['businessName'],
     "contactName" => $_POST['contactName'],
     "businessEmail" => $_POST['businessEmail'],
     "businessPhone" => $_POST['businessPhone'],
     "businessWebsite" => $_POST['businessWebsite'],
     "businessAddress" => $_POST['businessAddress'],
     "businessAddress2" => $_POST['businessAddress2'],
     "businessCity" => $_POST['businessCity'],
     "businessState" => $_POST['businessState'],
     "businessZip" => $_POST['businessZip']
), array(
    'AND' => array(
        "clientId" => $_POST['clientId'],
        "businessCity" => $_POST['businessCity'],
    )
));

score 0 · Answer 3 · answered Mar 19 '15 at 13:42

Example:

$datas = $db->update( "meta" , ["metalabel"=>$label[0][0]], ["AND"=>["metakey"=>"Collection", "metavalue"=>$_POST["metavalue"]] ]  );

you must set an array with logic operator (AND or OR) and as the first value of this you must set another array...see my example above

Medoo - Updating table row matching multiple field

3 Answers3