viewcomp.html
dbconnect(); //Directs user to comproj.html if the request object comproj is true. if(request.comproj) { redirect("comproj.html?companyname=" + escape(request.companyname)) } if(request.up) { database.execute("UPDATE companies SET address = '" + request.address + "', city = '" + request.city + "', stateorprovince = '" + request.stateorprovince + "', postalcode = '" + request.postalcode + "', country = '" + request.country + "', mainphone = '" + request.mainphone + "', mainfax = '" + request.mainfax + "' WHERE companyname = '" + request.companyname + "'") redirect("company.html"); } if(request.del) { database.execute("DELETE FROM companies WHERE companyname = '" + request.companyname + "'") redirect("company.html"); } if(request.name) { company = database.cursor("SELECT * FROM companies WHERE companyname = '" + request.name +"'") //search for company by company name }
公司基本資料
if(company.next()) { write("
公司中文名稱
" + company.companyname + "
") write("
公司英文名稱
") write("
地址
") write("
區域號碼
") write("
聯絡人
") write("
統一編號
") write("
電話號碼
") write("
傳真號碼
") write("
") }