THE Database is working fine with the php script/nusoap. but if i try to retrieving information about a particular student, visual studio (c#) crashes. I have another code that retrieve only a single row but i want every subject remain about a student. The attach file is the error message from visual studio.
please i need urgent help.
please i need urgent help.
Code:
Here is my nusoap/php script
function GetRemainingSubject($Sid){
$connect = mysql_pconnect("******","****","*******")
or die ('could not connect :'. mysql_error());
IF ($connect){
IF( mysql_select_db('theabani_sg',$connect));{
//$sql = ("select Subject_code,SemName,SemYear from enrolment_record where Sid =".$Sid." and Score < 50");
$sql = ("select Subject_code,SemName,SemYear from enrolment_record,student where student.Sid =enrolment_record.Sid And enrolment_record.Sid = ".$Sid." and Score < 50");
// $result = mysql_fetch_array(mysql_query($sql));
$result = mysql_query($sql);
while($rows = mysql_fetch_array($result)){
print $rows['Subject_code']. "<BR>";
print $rows['SemName']. "<BR>";
print $rows['SemYear']. "<BR>";
// return $result['Subject_code']." ".$result['SemName']." ".$result ['SemYear'];
} mysql_close($connect);
} } }
$HTTP_RAW_POST_DATA = isset($HTTP_RAW_POST_DATA) ? $HTTP_RAW_POST_DATA : '';
$server->service($HTTP_RAW_POST_DATA);
?>
visual studio code
private void Button_Click(object sender, RoutedEventArgs e)
{
// Creating new proxy object of our service;
MyServicePortTypeClient read = new MyServicePortTypeClient();
read.GetRemainingSubjectCompleted += new EventHandler<GetRemainingSubjectCompletedEventArgs>(read_GetRemainingSubjectCompleted);
// Calling method, as a parameters we type text contained in IdTextBox
// but we must change text type of string to integer (ID in web service have integer type)
read.GetRemainingSubjectAsync(Rbox1.Text);
}
void read_GetRemainingSubjectCompleted(object sender, GetRemainingSubjectCompletedEventArgs e)
{
// MessageBox.Show(e.Result);
libox.Items.Add(e.Result.ToString());
// libox(e.Result);
}
}