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

<?php
    require_once("check_login.php");

    exit;
    //setting
    $location_id    = 3;
    $master_room_id = 91;
    $zone           = "X";
    $total_room     = 27;

    for ($i = 1; $i <= $total_room; $i++) {
        $room_no = str_pad($i, 2, "0", STR_PAD_LEFT);

        $data = array(
            "location_id"    => $location_id,
            "master_room_id" => $master_room_id,
            "status"         => "OPEN",
            "code"           => $zone . $room_no,
            "typeid"         => "STROAGE",
            "zone"           => $zone,
            "createby"       => $_SESSION['cmsloginid'],
            "createdate"     => $nowdate,
            "lastupby"       => $_SESSION['cmsloginid'],
            "lastupdate"     => $nowdate
        );

        $result = insert_record("room", $data);
    }