$top_menu = "sell"; $grey_box = "Teaching > List a Class"; $green_box_img = "bar_icon02.gif"; $green_box = "List a Class"; $bors = "supply"; include "../include/header.php"; //�ο� if(!$_SESSION[p_id]){ include "../member/login_page.php"; }else{ if(!$mycom_row[school_no]) { echo(" "); exit; } else { if(!$_REQUEST[no]) { $selling_no = cntHistory('listing',$_SESSION[p_seq_no],$connect); $list_limit = $mycom_row[list_limit]; $expiry = date("Ymd",strtotime($mycom_row[valid])); $today = date("Ymd"); if($today > $expiry) { echo (" "); exit; } if($list_limit <= $selling_no) { echo (" "); exit; } $show_option = "Y"; if($sc2){ $scategory=$sc2; }elseif(($sc1)&&(!$sc2)){ $scategory=$sc1; } if($scategory) { $special_event_row = select_qry('edu_fee','title','Special Event',$connect); $s_event_price = $special_event_row[price]; $pre_charged = $s_event_price; } } else { $query = "select * from e_auct_master where anum=$no"; $result = mysqli_query($query); $row = mysqli_fetch_array($result); if($row[seq_num] != $_SESSION[p_seq_no]) { $message = "Sorry, only the member who posted this list has permission to access this page."; include("../help/error_page.php"); include("../include/footer.php"); exit; } if(substr($row[catenum],-6,6) != "000000") { $c1 = substr($row[catenum],0,-6)."000000"; if(substr($row[catenum],-4,4) != "0000") { $c2 = substr($row[catenum],0,-4)."0000"; if(substr($row[catenum],-2,2) != "00") { $c3 = substr($row[catenum],0,-2)."00"; $c4 = $row[catenum]; } else { $c3 = $row[catenum]; $c4 = ""; } } else { $c2 = $row[catenum]; $c3 = ""; $c4 = ""; } } else { $c1 = $row[catenum]; $c2 = ""; $c3 = ""; $c4 = ""; } $auct_start = strtotime($row[reg_date]); $within_hr = date("YmdHis",mktime(date("H",$auct_start)+1,date("i",$auct_start),date("s",$auct_start),date("m",$auct_start),date("d",$auct_start),date("Y",$auct_start))); if(date("YmdHis") < $within_hr) { $show_option = "Y"; $charged_qry = "SELECT * FROM account WHERE seq_num=$_SESSION[p_seq_no] AND site='Educationinfo' AND a_code=$row['anum'] ORDER BY no DESC LIMIT 1"; $charged_res = mysqli_query($charged_qry,$connect); $charged_tot = mysqli_num_rows($charged_res); if($charged_tot) { $charged_row = mysqli_fetch_array($charged_res); $pre_charged = $charged_row[debit]; } else { $pre_charged = ""; } } else { $show_option = "N"; } $state = $row[state_no]; $town = $row[location]; $photo = $row[photo]; if($sc2){ $scategory=$sc2; }elseif(($sc1)&&(!$sc2)){ $scategory=$sc1; } $e_type = explode(",",$row[e_type]); for($e=0;$e Choose a category ========== Choose =========== $query3 = "select * from e_category where catedep=1 order by catename"; $result3 = mysqli_query($query3); $step1_tag = ""; for($i=0; $row3 = mysqli_fetch_array($result3); $i++){ $catename_1 = stripslashes($row3[catename]); $step1_tag .= " ========== Choose =========== ========== Choose =========== ========== Choose =========== List Details Listing title * Tutoring Style > Private Tutor > Class Tutor Tuition Choose >Free >$10~25 >$26~50 >$51~75 >$75~100 >$101~125 >$126~150 >$151~175 >$175~200 >$200~225 >$226~250 >$250~300 >$300~350 >$351~400 >$401~500 >$501~600 >$601~700 >$701~800 >over $800 / Week Class Length Week(s) No. of Students Choose for($s=0;$s<10;$s++) { $s_val = $s * 5; if($s == '0') { echo "1"; } else if($s == '9') { echo "more than 40"; } else { echo "$s_val"; } } ?> / Class Qualification Choose >Non-Certificate >Certificate >Diploma >Degree Class Location Street No. State Choose $first_state_qry = "SELECT * FROM local_area WHERE country_no='2' GROUP BY state_no ORDER BY state_name"; $first_state_res = mysqli_query($first_state_qry,$connect); $first_state_total = mysqli_num_rows($first_state_res); if($first_state_total) { for($j=0;$j<$first_state_total;$j++) { $first_state_row = mysqli_fetch_array($first_state_res); ?> > } } ?> City / Town Choose $first_city_qry = "SELECT * FROM local_area WHERE state_no='$state' GROUP BY town_no ORDER BY city_name,town_name"; $first_city_res = mysqli_query($first_city_qry,$connect); $first_city_total = mysqli_num_rows($first_city_res); if($first_city_total) { for($k=0;$k<$first_city_total;$k++) { $first_city_row = mysqli_fetch_array($first_city_res); ?> > } } ?> Weekly Schedule Day(s) / Week Term Schedule Specialty & Conditions * Photo if($show_option == 'Y') { ?> Options (Options apply for a month from the date you list.) $sec_opt_qry = "SELECT * FROM edu_fee WHERE category='listing' GROUP BY section ORDER BY section;"; $sec_opt_res = mysqli_query($sec_opt_qry,$connect); $sec_num = mysqli_num_rows($sec_opt_res); for($i=0;$i<$sec_num;$i++) { // Selects out all kinds of sections $sec_opt_row = mysqli_fetch_array($sec_opt_res); echo ""; echo ""; echo " "; echo $sec_opt_row[section]; echo ""; echo ""; echo " "; echo " "; echo " "; $title_opt_qry = "SELECT * FROM edu_fee WHERE section='$sec_opt_row[section]' GROUP BY title ORDER BY title;"; $title_opt_res = mysqli_query($title_opt_qry,$connect); $title_num = mysqli_num_rows($title_opt_res); for($j=0;$j<$title_num;$j++) { // Selects out all kinds of titles under the current section $title_opt_row = mysqli_fetch_array($title_opt_res); if($scategory && ($title_opt_row[title] == 'Special Event')) { // Makes the special event tick box readonly $chk_onclick = "checked onClick='return false'"; } else if(!$scategory && ($title_opt_row[title] == 'Special Event')) { // Makes the special event disappear when it's for special event break; } else { // Sets a tick box to work with chkOptSum function when it's not for special event nor specific closing time $chk_onclick = "onClick=chkOptSum(this.value,this.getAttribute('value2'),this)"; } echo ""; echo ""; echo ""; echo $title_opt_row[title]; if($title_opt_row[title] == 'Duration') { echo " *"; } echo ""; $desc_opt_qry = "SELECT * FROM edu_fee WHERE section='$title_opt_row[section]' AND title='$title_opt_row[title]' ORDER BY description;"; $desc_opt_res = mysqli_query($desc_opt_qry,$connect); $desc_num = mysqli_num_rows($desc_opt_res); echo ""; if($desc_num > 1) { // Makes optioins to be a select(drop down menu) type when there are descriptions more than one echo ""; echo "choose"; for($k=0;$k<$desc_num;$k++) { // Selects out all the options under the current titile. $desc_opt_row = mysqli_fetch_array($desc_opt_res); echo "".$desc_opt_row[description]."($".$desc_opt_row[price].")"; } echo ""; echo ""; echo ""; if($title_opt_row[title] == 'Duration') { echo ""; } echo $title_opt_row[details]; } else { // Makes optioins to be a tick box type when there is only one options(description) // Selects out all the options under the current titile. $desc_opt_row = mysqli_fetch_array($desc_opt_res); ?> > ($) } echo ""; echo " "; echo ""; } echo ""; echo " "; echo ""; echo ""; echo " "; echo " "; echo " "; echo ""; echo ""; } ?> Total / Your Current Balance : $ } if($category4){ $catenum = $category4; }elseif((!$category4)&&($category3)&&($category2)&&($category1)){ $catenum = $category3; }elseif((!$category4)&&(!$category3)&&($category2)&&($category1)){ $catenum = $category2; }elseif((!$category4)&&(!$category3)&&(!$category2)&&($category1)){ $catenum = $category1; } ?> } } include "../include/footer.php"; //�ο� ?>