使用php从id获取呼叫状态 [英] get call status from id using php
问题描述
< html>
< body>
$ ipAddress = $ _ SERVER [' REMOTE_ADDR'];
$ macAddr = false;
$ out_put =;
// $ SP_VAL =;
// echo您的IP地址是：$ ipAddress;
#run外部命令，将输出分解为行
$ arp =`arp - $ ipAddress`;
$ lines = explode（\ n，$ arp）;
#look输出行描述我们的IP地址
foreach（$行作为$ line）
{
$ cols = preg_split（'/ \ s + /'， trim（$ line））;
if（$ cols [0] == $ ipAddress）
{
$ macAddr = $ cols [ 1];
}
}
？>
if（isset（$ _ POST ['webpanel']））{
$ mobileno = $ _ POST ['mobileno'];
$ fname = $ _ POST ['fname'];
$ email = $ _ POST ['femail'];
$ fmessage = $ _ POST [' fmessage'];
$ colorRadio = $ _ POST [ colorRadio'];
$ demo1 = $ _ POST ['demo1'];
$ flag =CALL_ORIGIN;
$ client = GALACTIC;
$ mysqli = mysqli_connect（localhost，root，，call_conference）;
$ call = $ mysqli-> prepare（'CALL CALL_ORIGIN（？，？，？，？，？，？，？，？，？，？，@ out_put）'）;
$ call-> bind_param（'ssssssssss'，$ mobileno，$ flag，$ fname，$ email，$ fmessage，$ ipAddress，$ macAddr，$ colorRadio，$ demo1，$ client）;
$ call-> execute（）;
$ select = $ mysqli-> query（'SELECT @out_put'）;
$ result = $ select-> fetch_assoc（）;
$ SP_VAL = $ result ['@ out_put'];
echo来自SP procOutput_sum的结果::::: $ SP_VAL;
if（empty（$ mobileno）||空（$ fname））{
echoSP OUT_VAL：$ output;
echo< label class ='err'>所有字段都是必需的< /标签>;
}
elseif（！is_numeric（$ mobileno））{
echo< ; label class ='err'>手机号码必须为数字< / label>;
}
else {
echo 您的IP地址是：$ ipAddress，您的Mac地址是：$ macAddr和CALL_SCHEDULER_TIME ::: $ demo1;
？>
}
？>
< body style =背景：白色;>
您好
您的电话被转移到我们的服务器
echo来自SP procOutput_sum的结果::::: $ SP_VAL;
$ mysqli = mysql_connect（localhost，root，，call_conference）;
if（！$ mysqli）{
die（'无法连接：'。mysql_error（））;
}
？>
$ select =从tbl_call_origin选择call_status，其中id ='$ SP_VAL';
echo $ select;
$ data = mysql_query（ $ select）;
$ row = mysql_fetch_array（$ data）;
// echo $ row ['call_status'];
？>
< / body>
< / html>
<html>
<body>
$ipAddress=$_SERVER['REMOTE_ADDR'];
$macAddr=false;
$out_put="";
//$SP_VAL="";
//echo "Your IP address is : $ipAddress";
#run the external command, break output into lines
$arp=`arp -a $ipAddress`;
$lines=explode("\n", $arp);
#look for the output line describing our IP address
foreach($lines as $line)
{
$cols=preg_split('/\s+/', trim($line));
if ($cols[0]==$ipAddress)
{
$macAddr=$cols[1];
}
}
?>
if(isset($_POST['webpanel'])){
$mobileno=$_POST['mobileno'];
$fname=$_POST['fname'];
$email=$_POST['femail'];
$fmessage=$_POST['fmessage'];
$colorRadio=$_POST['colorRadio'];
$demo1=$_POST['demo1'];
$flag="CALL_ORIGIN";
$client="GALACTIC";
$mysqli = mysqli_connect("localhost", "root", "", "call_conference");
$call = $mysqli->prepare('CALL CALL_ORIGIN(?, ?, ?, ?, ?, ?, ?, ?, ?, ?,@out_put)');
$call->bind_param('ssssssssss',$mobileno,$flag,$fname,$email,$fmessage,$ipAddress,$macAddr,$colorRadio,$demo1,$client);
$call->execute();
$select = $mysqli->query('SELECT @out_put');
$result = $select->fetch_assoc();
$SP_VAL = $result['@out_put'];
echo "Result from SP procOutput_sum:::::$SP_VAL";
if(empty($mobileno) || empty($fname)){
echo "SP OUT_VAL:$output";
echo "<label class='err'>All field is required</label>";
}
elseif(!is_numeric($mobileno)){
echo "<label class='err'>Mobile no must be numeric</label>";
}
else{
echo " Your IP address is : $ipAddress and Your Mac address is:$macAddr and CALL_SCHEDULER_TIME::: $demo1";
?>
}
?>
<body style="background:white;">
Hi
Your call is transferred to our Server
echo "Result from SP procOutput_sum:::::$SP_VAL";
$mysqli = mysql_connect("localhost", "root", "", "call_conference");
if (!$mysqli) {
die('Could not connect: ' . mysql_error());
}
?>
$select="select call_status from tbl_call_origin where id='$SP_VAL'";
echo $select;
$data=mysql_query($select);
$row=mysql_fetch_array($data);
//echo $row['call_status'];
?>
</body>
</html>
推荐答案
ipAddress =
ipAddress=
_SERVER ['REMOTE _ADDR'];
_SERVER['REMOTE_ADDR'];
macAddr = false;
macAddr=false;
这篇关于使用php从id获取呼叫状态的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
