PHP Query Not Working When Within Function

Question

This makes no sense to me?..

Ok so i have an SQL query that i am doing like this

$wut = new mysqli("1", "2", "3", "4");
$updateReferralPoints = $wut->prepare("UPDATE `referrals` SET `totalreferrals` = ? WHERE `referralkey` = ?");
$updateReferralPoints->bind_param("ss", $referralPointAmount,$referralKeyForUpdate);
$referralPointAmount = 10;
$referralKeyForUpdate = "1234";
$updateReferralPoints->execute();

It works completly fine...

BUT

When i add it to a function the SQL query just doesn't work..

So for example this will NOT work

if($doUpdate)
{
    updateReferralPointsCall();//DOESN'T WORK?
}

function updateReferralPointsCall()
{
    $wut = new mysqli("1", "2", "3", "4");
    $updateReferralPoints = $wut->prepare("UPDATE `referrals` SET `totalreferrals` = ? WHERE `referralkey` = ?");
    $updateReferralPoints->bind_param("ss", $referralPointAmount,$referralKeyForUpdate);
    $referralPointAmount = 10;
    $referralKeyForUpdate = "1234";
    $updateReferralPoints->execute();
}

BUT this will work

if($doUpdate)
{
    $wut = new mysqli("1", "2", "3", "4");
    $updateReferralPoints = $wut->prepare("UPDATE `referrals` SET `totalreferrals` = ? WHERE `referralkey` = ?");
    $updateReferralPoints->bind_param("ss", $referralPointAmount,$referralKeyForUpdate);
    $referralPointAmount = 10;
    $referralKeyForUpdate = "1234";
    $updateReferralPoints->execute();
}

score 0 · Answer 1 · answered Feb 11 '17 at 23:45

0

You need to pass the mysqli object into the function. You can only call global variables inside normal functions like this.

So, something like this should work:

if($doUpdate)
{
    updateReferralPoints($mysqlconnection);//DOESN'T WORK?
}

function updateReferralPoints($updateReferralPoints)
{

answered Feb 11 '17 at 23:45

Major Stuen

3
3

I don't think it's the scope... in the example provided, the connection is created inside the function meaning it should be available for use. – Feb 12 '17 at 00:59
Also you are defining the variables after the bind. That will not work. – Major Stuen Feb 12 '17 at 01:07
You should also bind by index – Major Stuen Feb 12 '17 at 01:09

PHP Query Not Working When Within Function

1 Answers1