2024-03-04 16:08:20 +01:00
< ? php
function CourseEdit ( $connection , $cid )
{
$return = " " ;
$name = " " ;
$descr = " " ;
$diffname = " " ;
$level = " " ;
$link = " " ;
$color = " " ;
if ( $cid > 0 ) {
$course_query = " SELECT * FROM li_courses WHERE cid= " . $cid ;
$result = mysqli_query ( $connection , $course_query );
while ( $row = mysqli_fetch_object ( $result )) {
$name = $row -> name ;
$descr = $row -> description ;
$diffname = $row -> diffname ;
$level = $row -> level ;
$link = $row -> link ;
$color = $row -> color ;
}
mysqli_free_result ( $result );
}
$return .= '<input id="cid" type="hidden" value="' . $cid . '" />' ;
$return .= '<div class="leftcol">Gruppenname</div><div class="rightcol"><input id="cname" type="text" value="' . $name . '" /></div>' ;
2024-09-02 01:37:42 +02:00
$return .= '<div class="leftcol">Alter</div><div class="rightcol"><input id="cdescr" type="text" value="' . $descr . '" /></div>' ;
2024-03-04 16:08:20 +01:00
$return .= '<div class="leftcol">Level</div><div class="rightcol"><input id="clevel" type="text" value="' . $level . '" /></div>' ;
2024-09-02 01:37:42 +02:00
$return .= '<div class="leftcol">Tanzstil</div><div class="rightcol"><input id="cdiffname" type="text" value="' . $diffname . '" /></div>' ;
2024-03-04 16:08:20 +01:00
$return .= '<div class="leftcol">Link</div><div class="rightcol"><input id="clink" type="text" value="' . $link . '" /></div>' ;
$return .= '<div class="leftcol">Farbe</div><div class="rightcol"><input id="ccolor" type="text" value="' . $color . '" /></div>' ;
return $return ;
}
function CourseDelete ( $connection , $cid ) {
$querystr = " DELETE FROM li_courses WHERE cid= " . $cid ;
mysqli_query ( $connection , $querystr );
$querystr = " DELETE FROM li_plan WHERE cid= " . $cid ;
mysqli_query ( $connection , $querystr );
return $GLOBALS [ " operation_success " ];
}
function CourseCommit ( $connection , $cname , $cdescr , $cdiffname , $clevel , $clink , $ccolor ) {
$querystr = " INSERT INTO li_courses (name,description,diffname,level,link,color,age_begin,age_end) VALUES(' " . $cname . " ',' " . $cdescr . " ',' " . $cdiffname . " ',' " . $clevel . " ',' " . $clink . " ',' " . $ccolor . " ',0,99) " ;
mysqli_query ( $connection , $querystr );
return $GLOBALS [ " operation_success " ];
}
function CourseUpdate ( $connection , $cid , $cname , $cdescr , $cdiffname , $clevel , $clink , $ccolor ) {
$querystr = " UPDATE li_courses SET name=' " . $cname . " ', description=' " . $cdescr . " ', diffname=' " . $cdiffname . " ', level=' " . $clevel . " ', link=' " . $clink . " ', color=' " . $ccolor . " ' WHERE cid= " . $cid ;
mysqli_query ( $connection , $querystr );
return $GLOBALS [ " operation_success " ];
}
?>