PHP,
pasted
on Jun 17:
|
function globe_receive_sms(){
$in = file_get_contents("php://input");
/* temporary storage */
$list = array();
/* available in PHP5 is the DOMDocument class which we can use to parse XML */
$doc = new DOMDocument();
$doc->loadXML($in);
/* here we just iterate through the XML and store the data points into the $list
array */
$params = $doc->getElementsByTagName("param");
foreach( $params as $param )
{
$names = $param->getElementsByTagName("name");
$name = $names->item(0)->nodeValue;
$values = $param->getElementsByTagName("value");
$value = $values->item(0)->nodeValue;
$list[$name] = mysql_escape_string($value);
list($action, $name, $age, $localchurch, $district) = $list;
list($action, $event,$location,$time) = $list;
}
if list=($action, $name, $age, $localchurch, $district)
{
$action== reg
{
$db=mysql_connect("localhost", "root", "******") or die("Cannot connect to DB!");
mysql_select_db("cyfdb") or die("Cannot select DB!");
$sql="INSERT INTO mydb (name,age,localchurch,district)
VALUES ('$name','$age','$localchurch','$district')";
$r = mysql_query($sql);
if(!$r) {
$err=mysql_error();
print $err;
exit();}
$mysql_close($db);
}
}
else if($action== inq)
{
$link=mysql_connect("localhost", "root", "jya0312@") or die("Cannot connect to
DB!");
mysql_select_db("cyfdb") or die("Cannot select DB!");
$sql = "SELECT event,location,time from activity";
while($r = mysql_fetch_array($sql)){
$items[] = array('event'=>$r['event'],
'location'=>$r['location'],
'date'=>$r['date']);
}
return $items;
$mysql_close($link);
}
return $list;
}
|
Output:
|
function globe_receive_sms(){
$in = file_get_contents("php://input");
/* temporary storage */
$list = array();
/* available in PHP5 is the DOMDocument class which we can use to parse XML */
$doc = new DOMDocument();
$doc->loadXML($in);
/* here we just iterate through the XML and store the data points into the $list
array */
$params = $doc->getElementsByTagName("param");
foreach( $params as $param )
{
$names = $param->getElementsByTagName("name");
$name = $names->item(0)->nodeValue;
$values = $param->getElementsByTagName("value");
$value = $values->item(0)->nodeValue;
$list[$name] = mysql_escape_string($value);
list($action, $name, $age, $localchurch, $district) = $list;
list($action, $event,$location,$time) = $list;
}
if list=($action, $name, $age, $localchurch, $district)
{
$action== reg
{
$db=mysql_connect("localhost", "root", "******") or die("Cannot connect to DB!");
mysql_select_db("cyfdb") or die("Cannot select DB!");
$sql="INSERT INTO mydb (name,age,localchurch,district)
VALUES ('$name','$age','$localchurch','$district')";
$r = mysql_query($sql);
if(!$r) {
$err=mysql_error();
print $err;
exit();}
$mysql_close($db);
}
}
else if($action== inq)
{
$link=mysql_connect("localhost", "root", "jya0312@") or die("Cannot connect to
DB!");
mysql_select_db("cyfdb") or die("Cannot select DB!");
$sql = "SELECT event,location,time from activity";
while($r = mysql_fetch_array($sql)){
$items[] = array('event'=>$r['event'],
'location'=>$r['location'],
'date'=>$r['date']);
}
return $items;
$mysql_close($link);
}
return $list;
}
|
|