Trying to use a function in php to update a database

Question

When I write the code out without a function it works, otherwise I get a 500 connection error. Not sure what error I'm making. Here is my code:

$date = "2016-01-12";
$date = date("Y-m-d", strtotime($date));

$sql    = 'INSERT INTO `campaigns` (campaign_id, campaign_date) VALUES (9001, "' . $date . '")';
$result = $link->query($sql);

if ($result) {
    echo "database updated";
} else {
    echo $link->error;
}

function insertIntoDB($mysqli, $date) {

    $sql    = 'INSERT INTO `campaigns` (campaign_id, campaign_date) VALUES (9001, "' . $date . '")';
    $result = $mysqli->query($sql);

    if ($result) {
        echo "database updated";
    } else {
        echo $mysqli->error;
    }

}

insertIntoDB($link, $date);

$link is working fine, not included because it doesn't seem to be relevant. Database updates when not in function, doesn't when I use a function. — bpr, Jan 18 '16 at 20:36
@devpro, changing $mysqli in the function to $link doesn't fix things :/ — bpr, Jan 18 '16 at 20:37
`$result = $link` works, right? Then you're using `function insertIntoDB($mysqli` <<< So which one is the right one here? — Funk Forty Niner, Jan 18 '16 at 21:37
possible duplicate of [PHP: “Notice: Undefined variable” and “Notice: Undefined index”](http://stackoverflow.com/questions/4261133/php-notice-undefined-variable-and-notice-undefined-index) — Funk Forty Niner, Jan 18 '16 at 21:39

score 0 · Answer 1 · answered Jan 19 '16 at 14:50

0

The function works properly when I call it above defining it. Dunno.

answered Jan 19 '16 at 14:50

bpr

483
1
11
23

Trying to use a function in php to update a database

1 Answers1