PHP Mysql插入数据到数据库中的函数

Question

我想要捕获$状态并将其插入到数据库的'smsdb'中。但是，我无法这样做，并希望有人会指导我。 此起始代码是墙功能的一部分，并且在调用该函数之后获取状态。在grabdetails函数中，我将其他详细信息导入到db中，$ status是无法访问的。会有人领我请... //代码

$name = $resultarr['name']; 
$amount = $resultarr['amount']; 
$transaction_id = $resultarr['trans_id']; 
$date = $resultarr['time_paid']; 

//message template 
$message = "Dear $name we have received $amount from you. MPESA transaction Id $transaction_id on $date."; 

$mobilenumber = $resultarr['msisdn']; // get mobile number from array 
$message_sent = $message; 

$serviceArguments = array(
     "mobilenumber" => $mobilenumber, 
     "message" => $message_sent 
); 

$client = new SoapClient("http://59.38.606.10:8080/smsengine/smsws?WSDL"); 

$result = $client->process($serviceArguments); 

grabdetails($message_sent, $mobilenumber); 

return $result; 

} 
//I call the function wall() to send sms   

wall(); 
$perm = wall(); 
$status = $perm->return; //outputing the status 
    // Here I want to capture the $status variable and put it in a db below 
echo "$status"; 


function grabdetails($messagee, $mobno) 
{ 

$message_sent = $messagee; 
$mobilenumber = $mobno; 


$servername = "localhost"; 
$username = "root"; 
$password = ""; 
$dbname = "smsdb"; 

// Create connection 


// Check connection 

$sql = "INSERT INTO smsdb (sms_text, receiver_number, time_sent, status) 
    VALUES 
    ('$message_sent', '$mobilenumber', NOW(), '$status')"; 
$conn->query($sql); 

任何一个？

Answer 1

该$status变量是out of scope。

添加一行：

global $status;

给你的函数。

http://php.net/manual/en/language.variables.scope.php

编辑：

当你wall()函数中调用grabdetails，在$status变量尚未设置。可能在wall()函数中将状态作为grabdetails函数中的参数传递。

例如grabdetails($message_sent, $mobilenumber, $result);

也改变了函数声明grabdetails($messagee, $mobno, $status);