Viewing file:  ws.php (2.33 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
require_once('nusoap.php');
function studentbio($studentId) {
$host="localhost";
$username="root";
$pass_word="";
$db="reg";
mysql_connect( $host,$username,$pass_word) or die ("ติดต่อกับฐานข้อมูล Mysql ไม่ได้ ");
mysql_select_db($db) or die("เลือกฐานข้อมูลไม่ได้");
//$sql = "SELECT * FROM student,faculty,department,branch,rent WHERE (StudentID like '%$studentid%') and (student.bran_code=branch.bran_code) and (student.StudentID=rent.RentID) ORDER BY StudentID,IsreturnAll";
//$sql = "SELECT * FROM StudentMaster WHERE (studentId='492101001')";
//$sql = "SELECT * FROM StudentMaster, StudentBio WHERE (StudentID like '%$studentId%') and (StudentCode =StudentCode) and (StudentMaster.studentId=StudentBio.studentId) ORDER BY studentId";
$sql = "SELECT * FROM StudentMaster WHERE (studentId='492101001')";
$dbquery = mysql_query($sql);
$information = '<?xml version="1.0" encoding="UTF-8"?>';
$information .= '<studentbio>';
$StudentID = '1';
while($result= mysql_fetch_array($dbquery))
{
//$StudentID = $result["studentId"];
/// if($StudentID!=$BioID){
//$BioID = $result["studentId"];
$information .= '<student>';
$information .= '<code>';
$information .= $result["StudentCode"];
$information .= '</code>';
$information .= '<Name>';
$information .= $result["StudentName"];
$information .= '</Name>';
$information .= '<Surname>';
$information .= $result["StudentSurname"];
$information .= '</Surname>';
$information .= '<phone>';
$information .= $result["HomePhoneNo"];
$information .= '</phone>';
$information .= '<Email>';
$information .= $result["ParentEmail"];
$information .= '</Email>';
$information .= '</student>';
//}
$information .= '</studentbio>';
return $information;
}
$server = new soap_server;
$server->configureWSDL('student_bio_wsdl', 'urn:student_bio_wsdl');
$server->register('studentbio',
array('studentid' => 'xsd:string'),
array('information' => 'xsd:string'),
'http://61.19.29.30/webservice/',
'http://61.19.29.30/webservice/',
'rpc',
'encoded',
'Search_For_Student_Bio');
$HTTP_RAW_POST_DATA = isset($HTTP_RAW_POST_DATA) ? $HTTP_RAW_POST_DATA : '';
$server->service($HTTP_RAW_POST_DATA);
?>
|