Update multiple rows Mysql Php

Question

Been trying to figure this out for too long, here is my code

else if(isset($_POST['mytrigger1']))
{
$title1 = ($_POST['titleHOME']);
$title2 = ($_POST['titleLEARN']);
$title3 = ($_POST['titleVTOUR']);
$title4 = ($_POST['titleTRIVIA']);
$title5 = ($_POST['titleALBUMS']);
$title6 = ($_POST['titleFAQS']);

$stmt = $mysqli->prepare("UPDATE  page_title set PAGETITLE = 'title1' where PAGENAME='HOME',PAGETITLE = 'title2' where PAGENAME='LEARN'");
$stmt->execute();

}

I want to update multiple rows with multiple where clauses.

you can't have multiple WHERE and use AND or OR not commas for WHERE conditions. — Tin Tran
– Tin Tran, Commented Jan 20, 2014 at 22:10
Out of curiousity, why not do a transaction and do two UPDATE statements? — Chris Forrence
– Chris Forrence, Commented Jan 20, 2014 at 22:10
Also, I don't think your code is correct; you don't seem to be using $title1, $title2, etc. — Chris Forrence
– Chris Forrence, Commented Jan 20, 2014 at 22:12

mpyw · Accepted Answer · 2014-01-20 22:52:19Z

3

At the setout, you should call

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

This enables you don't have to check any return values, just put try { ... } catch { ... } blocks. And do not repeat preparing same statements, reuse it.

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

try {

    $mysqli = new mysqli(...);

    if (...) {

       ...

    } else if (isset($_POST['mytrigger1'])) {

        $stmt = $mysqli->prepare("UPDATE page_title set PAGETITLE = ? where PAGENAME = ?");
        foreach ($_POST as $k => $v) {
            if (!is_string($v) || strpos($k, 'title') !== 0) {
                continue;
            }
            $stmt->bind_param('ss', $v, substr($k, 5));
            $stmt->execute();
        }

    }

    ....

} catch (mysqli_sql_exception $e) {

    echo $e->getMessge();

}

edited Jan 20, 2014 at 22:52

answered Jan 20, 2014 at 22:36

mpyw

5,7744 gold badges35 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

Update multiple rows Mysql Php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related