Читать реферат по информационному обеспечению, программированию: "Разработка онлайн-сервиса для подбора спортивного снаряжения" Страница 22

(Назад) (Cкачать работу)

(((((u442201515_board.Board bu442201515_board.Style_has_BoardProfile p)u442201515_board.Style_has_BoardFlex f)u442201515_board.Style_has_BoardShape s)u442201515_board.Style st)u442201515_board.Brand br)

((b.idBoardProfile = p.idBoardProfile)(b.idBoardFlex = f.idBoardFlex)(b.idBoardShape = s.idBoardShape)(p.idStyle = f.idStyle)(f.idStyle = s.idStyle)(s.idStyle = st.idStyle)(b.idBrand = br.idBrand))BY b.idBoard , p.idStyle

Представление BootRel:VIEW u442201515_board.BootRel AS.idBoot AS idBoot,.BootGender AS BootGender,.BrandName AS BrandName,.BootModel AS BootModel,.idBootFlex AS idBootFlex,.Lacing AS Lacing,.BootPrice AS BootPrice,.StyleName AS StyleName,.Relevance AS Relevance,.image AS image

((u442201515_board.Boot bu442201515_board.Brand br ON ((b.idBrand = br.idBrand)))(u442201515_board.Style_has_BootFlex su442201515_board.Style st ON ((s.idStyle = st.idStyle))))

(b.idBootFlex = s.idBootFlex)BY b.idBoot

Представление BindRel:VIEW u442201515_board.BindRel AS.idBinding AS idBinding,.BindingGender AS BindingGender,.BrandName AS BrandName,.BindingModel AS BindingModel,.idBindingFlex AS idBindingFlex,.BindingPrice AS BindingPrice,.StyleName AS Stylename,.Relevance AS Relevance,.image AS image

((u442201515_board.Binding bu442201515_board.Brand br ON ((b.idBrand = br.idBrand)))(u442201515_board.Style_has_BindingFlex su442201515_board.Style st ON ((s.idStyle = st.idStyle))))

(b.idBindingFlex = s.idBindingFlex)BY b.idBinding

Функция get_size()get_size($weight,$height,$foot,$style,$link)

{

$query_length="select minLength, maxLength from AverageLength where (minWeight=$weight) and (minHeight=$height)";

$res_length=mysqli_query($link,$query_length);($res_length) {($row = mysqli_fetch_array($res_length)) {

$size= array("minl"=>$row[0], "maxl"=>$row[1]);

}

}

{"Ошибка выполнения запроса: " . mysqli_error($link);false;

}($style)

{"jib":

$size["minl"]=$size["minl"]-6;

$size["maxl"]=$size["maxl"]-3;;"jump":

$size["minl"]=$size["minl"]-4;

$size["maxl"]=$size["maxl"]-2;;"freeride":

$size["maxl"]=$size["maxl"]+3;

$size["minl"]=$size["minl"]+1;;"pow":

$size["maxl"]=$size["maxl"]+3;

$size["minl"]=$size["minl"]+1;;

}

$query_width="select minWidth, maxWidth from AverageWidth where FootSize=$foot";

$res_width=mysqli_query($link,$query_width);($res_width) {($row = mysqli_fetch_array($res_width)) {

$size["minw"]=$row[0];

$size["maxw"]=$row[1];

}

}

{"Ошибка выполнения запроса: " . mysqli_error($link);false;

}($foot=6){

$size["bind"]="S";

}($foot=8){

$size["bind"]="M";

}($foot=10.5){

$size["bind"]="L";

}($foot>=12.5){

$size["bind"]="XL";

}$size;

}

Функция findboards()findboards($gender,$style,$minl,$maxl,$minw,$maxw,$budget,$link){

$budget=$budget*0.5;

$query="select*, (0.5*FlexRel+0.25*ProfileRel+0.25*ShapeRel) as Rating from BoardRel s inner join BoardFlex f on s.idBoardFlex=f.idBoardFlex inner join BoardSize b on s.idBoard=b.idBoard where StyleName='$style' and Length=$minl and Width=$minw and BoardPrice

Похожие работы