|
// عرض عدد الزيارات للمدرب صاحب الصفحة فقط
if($id==$MID){
?>
لقد تم زيارة صفحتكم ( $NewV )";?> مرة
}
?>
|
ID: echo $TrainerID; ?>
//if ($row[sex]) $title='المدرب'; else $title='المدربة';
echo $row[pre].' '.$Name;
?>
|
|
" WIDTH="120" HEIGHT="140" BORDER=0 ALT="">
|
if($row['showdata'] == 1){
$phones="select * from phone_numbers where user_id='$id'";
$phone_res=mysql_query($phones);
while($phones_row=mysql_fetch_array($phone_res)){
if ($phones_row[type]==1){
$phone=$phones_row[country_code].'-'.$phones_row[city_code].'-'.$phones_row[number];
}
if ($phones_row[type]==2){
$fax=$phones_row[country_code].'-'.$phones_row[city_code].'-'.$phones_row[number];
}
if ($phones_row[type]==3){
$Mob=$phones_row[country_code].'-'.$phones_row[city_code].'-'.$phones_row[number];
}
}
}
?>
|
المدينــــة
|
//echo $row[city]
$city_q="select cities.id,cities.city_name_a, countries.id, countries.country_name_a from cities inner join countries on cities.country_id=countries.id where cities.id='$row[city]'";
$city_res=mysql_query($city_q);
if(!$city_res){
echo mysql_error();
exit();
}
while($city_row=mysql_fetch_array($city_res)){
$CITY=$city_row[city_name_a];
$COUNTRY=$city_row[country_name_a];
}
echo $CITY;
?>
|
الدولـــــة
|
echo $COUNTRY ?>
|
العمل
|
echo $row[job] ?>
|
if($row['showdata'] == 1){
?>
|
الهاتف
|
=$phone?>
|
الفاكس
|
echo $fax ?>
|
الموبايل
|
=$Mob?>
|
}
?>
|
المدن التي درب فيها
|
$citysql="select distinct (cities.city_name_a), cities.city_name_e, this_event_trainer.event_id, training_events.city_id from this_event_trainer inner join training_events on this_event_trainer.event_id= training_events.event_id inner join cities on training_events.city_id=cities.id where this_event_trainer.user_id='$_GET[id]' group by binary(city_name_a)";
$cityres=mysql_query($citysql);
if(!$cityres){
echo "Error";
exit;
}
$citynum=mysql_num_rows($cityres);
if($citynum){
//echo "Training Cities: ";
while($cityrow=mysql_fetch_array($cityres)){
echo "".$cityrow[city_name_a].", ";
}
}// end of if(1)
?>
|
رتبة المدرب
|
$sql="select trainer.trankid, trainers_rank.aname,trainers_rank.ename from trainer inner join trainers_rank on trainer.trankid=trainers_rank.id where trainer.trainer_id='$id'";
//echo $sql;
$res=mysql_query($sql);
if(!$res){
echo mysql_error();
exit;
}
//echo mysql_num_rows($res);
while($row=mysql_fetch_array($res)){
$ARank=$row[aname];
//$ERank=$row[ename];
}
if($ARank)echo $ARank; else echo "غير محدد";
?>
|
|
|
|
|
$cv_q="select cv from users_cv where user_id='$id'";
$cv_res=mysql_query($cv_q);
while ($cv_row=mysql_fetch_array($cv_res)){
echo $cv_row[cv];
}
?>
|
} //first while end
$schedule_q="select training_schedule.id,training_schedule.trainer_id,training_schedule.start_time ,training_schedule.time,training_schedule.course_id,training_schedule.course_id,training_schedule.start_date,training_schedule.start_date,training_schedule.bran_no,training_schedule.city_id,training_schedule.fees,training_schedule.currency,training_schedule.currency,course.course_name,cities.city_name_a from training_schedule inner join course on training_schedule.course_id=course.course_id inner join cities on training_schedule.city_id=cities.id where training_schedule.trainer_id='$id' and start_date>=current_date() order by start_date ASC limit 6";
$sch_res=mysql_query($schedule_q);
echo mysql_error();
$num=mysql_num_rows($sch_res);
if(mysql_num_rows($sch_res)){
?>
|
جدول الدورات القادمة
|
|
CID
|
اسم الدورة
|
التاريخ
|
المدينة
|
الساعة
|
قيمة الاستثمار
|
للتسجيل
|
while($sch_row=mysql_fetch_array($sch_res)){
echo "
|
$sch_row[course_id]
|
$sch_row[course_name]
|
$sch_row[start_date]
|
$sch_row[city_name_a]
|
";
if($sch_row[start_time]){
echo "$sch_row[start_time] $sch_row[time]";
}else{
echo "غير محدد";
}
echo"
|
";
if($sch_row[fees]){
echo "$sch_row[fees] دولار أمريكي";
/*
echo"
| $sch_row[fees] | ";
$cu_q="select short,name_a from currency where short='$sch_row[currency]'";
$c_res=mysql_query($cu_q);
while ($c_row=mysql_fetch_array($c_res)){
//echo " ".$c_row[name_a];
echo "
$c_row[name_a] |
";
} // while end
*/
}
else{
echo "اتصل بنا ";
}
echo" |
|
";
} // end of while ($sch_row)
//echo "num".$num;
if ($num>=6){
echo "
|
المزيد >>>
|
";
}
?>
} // end of if($num)
?>
|