Esempi in PHP per table_data_delete_by_id

Esempio n. 1

File: classroom_manage.php Progetto: dalinhuang/classsheet

if ($semesterTargetArray != "") {
    database_table_create($CLASSROOM_TABLE_NAME, $CLASSROOM_TABLE_KEY_NAMES_ARRAY, $CLASSROOM_TABLE_KEY_TYPES_ARRAY);
}
//ADD the information to database if POST
print $_POST['CLASSROOM_NAME'];
if ($_POST["classroomInfoAdd"]) {
    //Load the POST info array
    foreach ($CLASSROOM_TABLE_KEY_NAMES_ARRAY as $value) {
        $classroomInfoArray[$value] = $_POST[$value];
    }
    unset($value);
    table_data_add($CLASSROOM_TABLE_NAME, $CLASSROOM_TABLE_KEY_NAMES_ARRAY, $classroomInfoArray);
}
//DELETE the information from database if POST
if ($_POST["classroomListDelete"]) {
    table_data_delete_by_id($CLASSROOM_TABLE_NAME, $targetId);
}
//CHANGE the information to database if POST
if ($_POST["classroomInfoChanged"]) {
    foreach ($CLASSROOM_TABLE_KEY_NAMES_ARRAY as $value) {
        $classroomInfoChangeArray[$value] = $_POST[$CLASSROOM_TABLE_KEY_NAMES_ARRAY[$value]];
    }
    unset($value);
    table_data_change($CLASSROOM_TABLE_NAME, $CLASSROOM_TABLE_KEY_NAMES_ARRAY, $targetId, $classroomInfoChangeArray);
}
//REQUERY the $classroomListArray for display
$classroomListArray = table_data_query($CLASSROOM_TABLE_NAME, $CLASSROOM_TABLE_KEY_NAMES_ARRAY);
//------  -[ Views Functions ]-  ------
div_head_output_with_class_option("mainMiddle");
//Print Main Title
main_title_output($PAGE_INFO_ARRAY, $PAGE_SWITCH);

Esempio n. 2

File: teacher_manage.php Progetto: dalinhuang/classsheet

    database_table_create($TEACHER_TABLE_NAME, $TEACHER_TABLE_KEY_NAMES_ARRAY, $TEACHER_TABLE_KEY_TYPES_ARRAY);
}
//ADD the information to database if POST
print $_POST['TEACHER_NAME'];
if ($_POST["teacherInfoAdd"]) {
    //Load the POST info array
    foreach ($TEACHER_TABLE_KEY_NAMES_ARRAY as $value) {
        $teacherInfoArray[$value] = $_POST[$value];
    }
    var_dump($teacherInfoArray);
    unset($value);
    table_data_add($TEACHER_TABLE_NAME, $TEACHER_TABLE_KEY_NAMES_ARRAY, $teacherInfoArray);
}
//DELETE the information from database if POST
if ($_POST["teacherListDelete"]) {
    table_data_delete_by_id($TEACHER_TABLE_NAME, $targetId);
}
//CHANGE the information to database if POST
if ($_POST["teacherInfoChanged"]) {
    foreach ($TEACHER_TABLE_KEY_NAMES_ARRAY as $value) {
        $teacherInfoChangeArray[$value] = $_POST[$value];
    }
    unset($value);
    table_data_change($TEACHER_TABLE_NAME, $TEACHER_TABLE_KEY_NAMES_ARRAY, $targetId, $teacherInfoChangeArray);
}
//REQUERY the $teacherListArray for display
$teacherListArray = table_data_query($TEACHER_TABLE_NAME, $TEACHER_TABLE_KEY_NAMES_ARRAY);
//------  -[ Views Functions ]-  ------
div_head_output_with_class_option("mainMiddle");
//Print Main Title
main_title_output($PAGE_INFO_ARRAY, $PAGE_SWITCH);

Esempio n. 3

File: students_schedule_manage.php Progetto: dalinhuang/classsheet

//Load $studentsScheduleArray
$STUDENTS_SCHEDULE_TABLE_NAME = table_name_form($PAGE_INFO_ARRAY, $STUDENTS_SCHEDULE_PAGE_SWITCH, $semesterListArray, $semesterTargetArray);
$STUDENTS_SCHEDULE_TABLE_KEY_NAMES_ARRAY = $TABLE_KEY_NAMES_ARRAY[$STUDENTS_SCHEDULE_PAGE_SWITCH];
$STUDENTS_SCHEDULE_TABLE_KEY_TYPES_ARRAY = $TABLE_KEY_TYPES_ARRAY[$STUDENTS_SCHEDULE_PAGE_SWITCH];
//Database Query menthod
if ($_POST['classListQuery']) {
    $studentsScheduleArray = table_data_query($STUDENTS_TABLE_NAME, $STUDENTS_SCHEDULE_TABLE_KEY_NAMES_ARRAY);
}
//Database Delete method
//TODO: Test this method.
if ($_POST['classListDelete']) {
    $studentsScheduleArray = table_data_query($STUDENTS_TABLE_NAME, $STUDENTS_SCHEDULE_TABLE_KEY_NAMES_ARRAY);
    $studentsScheduleArrayCount0 = count($studentsScheduleArray);
    for ($i = 0; $i < $studentsScheduleArrayCount0; $i++) {
        $targetDeleteId = $studentsScheduleArray[$i]['id'];
        table_data_delete_by_id($STUDENTS_SCHEDULE_TABLE_NAME, $targetDeleteId);
    }
}
//Create the dataabse table.
database_table_create($STUDENTS_SCHEDULE_TABLE_NAME, $STUDENTS_SCHEDULE_TABLE_KEY_NAMES_ARRAY, $STUDENTS_SCHEDULE_TABLE_KEY_TYPES_ARRAY);
//Load target class name.
$classTargetArray = $_POST['classList'];
//Reschedule determinative syntax
if ($_POST['RESCHEDULE']) {
    $targetClassName = $classListArray[$classTargetArray]['CLASS_NAME'];
    //Load $courseWeekArray
    //$courseWeekArray structure describe
    //$courseWeekArray[0] = 0;
    //				  [1] = 2;
    //...
    $targetClassListArrayTemp = table_data_query($CLASS_TABLE_NAME, $CLASS_TABLE_KEY_NAMES_ARRAY, "CLASS_NAME = '{$targetClassName}'");