1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

<?php
    include('_init.php');
    include('webadmin/_functions.php');
    
    exit;
    //$code = "J17042701100018";
    //short_code($code, -5);

    //var_dump(aes_crypt("V201S2JGcEhNWFpoZWtGNlVVZGtkRmxYYkhOTWJVNTJZbEU5UFE9PQ==", 2));
    //var_dump(aes_crypt("ff4a57ba6715602d46c8f70e8e711819017d00846b98d6e38ccd478f2955b6a4", 2));
    //var_dump(aes_crypt2("On2XAyhINpfUZJ1/3J9KA/P57Li4d8KzyM/n7Wrfdc6oxpWsHPYaM++vDE86i6ZWoOowFloXO7xP6BiO2H8aZPlMZoRwi7xUCVcGqhXIUyjmngR8rM7PDnWwtcGWHTNA4U47VYvYk8o7vb9lhJh4W2ReLBUGZ+tufrAtKUJXuxMma5MKwyRqxJawbI/2WD3HvqmIyU5hZy/C/l3jCy8xOA==", 2));

    $sql = "select * from student_postjob";
    $result = bind_pdo($sql, array(), "selectall");
    foreach ($result as $row){
        $sql = "select * from student_main where id = ?";
        $parameter = array($row["studentmain_id"]);
        $result2 = bind_pdo($sql, $parameter, "selectone");

        $student_mas_yearrange = $result2["mas_yearrange"];
        $student_mas_contactstudentrel = $result2["mas_contactstudentrel"];

        if(empty($row["student_mas_yearrange"]) && empty($row["student_mas_contactstudentrel"])){
            $sql = "update student_postjob set student_mas_yearrange = ?, student_mas_contactstudentrel = ? where id = ?";
            $parameter = array($student_mas_yearrange, $student_mas_contactstudentrel, $row["id"]);
            //echo dump_sql($sql, $parameter)."<br>";
            bind_pdo($sql, $parameter);
        }
    }