Pls help and advice
Posted: Mon Apr 07, 2008 2:26 pm
Dear all,
Below are my code for my class Member. It has been running really slow in my site. I need some comments and suggestion on how to speed up the execution of this code. Thanks.
The class is being called as below:
$m = Member::getMemberData($member_id);
echo $m->firstname.", ".$m->lastname;
Below are my code for my class Member. It has been running really slow in my site. I need some comments and suggestion on how to speed up the execution of this code. Thanks.
Code: Select all
class Member
{
function getMemberData($uid){
$query="SELECT * FROM users WHERE U_ID LIKE '".$uid."'";
$search=mysql_query($query);
$member = mysql_fetch_array( $search );
$list->firstname=str_replace('"','"',($member['FIRSTNAME']));
$list->lastname= str_replace('"','"',($member['NAME']));
$list->gender=$member['GENDER'];
$list->photo=getUsrProfImg($uid);
$list->opt_personal_display=$member['OPT_PERSONAL_DISPLAY'];
$list->crt_tms=$member['CRT_TMS'];
$list->login_id=$member['LOGIN'];
$list->email=$member['EMAIL'];
$townInfo=getTownState($member['TOWN_ID']);
$list->town=$townInfo['TOWN'];
$list->state_id=$townInfo['STATE_ID'];
$list->state=$townInfo['STATE'];
$list->postcode=$townInfo['POSTCODE'];
$list->uInfo['sshort']=$townInfo['STATE_SHORT'];
$list->type=$member['TYPE'];
$list->userId=$member['U_ID'];
$list->lastlog=$member['LAST_LOGIN'];
$list->ques=$member['QUES'];
$list->ans=$member['ANS'];
$dob=trim($member['DOB']);
$list->dt=substr($dob, 0,2);
$list->mn=substr($dob, 2,2);
$list->yr=substr($dob, 4, 4);
mysql_free_result($search);
return $list;
}
}
$m = Member::getMemberData($member_id);
echo $m->firstname.", ".$m->lastname;