Project

General

Profile

Statistics
| Branch: | Revision:

root / docs / www / colonyscout / internal / assembly_edit_old.php @ f59acf11

History | View | Annotate | Download (2.23 KB)

1
<?php
2
        if(!isset($_GET['q'])) {
3
                echo "<h1 style=\"color:#FF6600;\">Please search for a part..</h1>";
4

    
5
        } else {
6

    
7
        //must already be logged in
8
        $get_assembly_sql = "SELECT * FROM assemblyinstructions WHERE id='".$_GET['q']."' LIMIT 1";
9
        $get_assembly_res = mysqli_query($GLOBALS['mysqli'], $get_assembly_sql) or die(mysqli_error($GLOBALS['mysqli']));
10

    
11
        while ($r = mysqli_fetch_array($get_assembly_res)) {
12
                $assm["data"]                =        $r;
13
        }
14
?>        
15

    
16
<div  style="overflow:hidden;">
17
        <div class="box-row">
18
        <h1>Edit:</h1>
19
        </div>
20

    
21

    
22
        <form action="vars.php" method="post" class="niceform">
23
                <fieldset>
24
                        <legend>Assembly Instruction Set</legend>
25
                        <dl>
26
                                <dt><label for="title">Title:</label></dt>
27
                                <dd><input type="text" name="title" value="<?php echo $assm['data']['Name']; ?>" id="email" size="50" maxlength="128" /></dd>
28
                        </dl>
29
                </fieldset>
30
        
31
<?php
32
        $get_assembly_sql = "SELECT * FROM assemblysteps WHERE AssemblyID=\"".$_GET['q']."\" ORDER BY StepNo ASC";
33
        $get_assembly_res = mysqli_query($GLOBALS['mysqli'], $get_assembly_sql) or die(mysqli_error($GLOBALS['mysqli']));
34
                                
35
        if (mysqli_num_rows($get_assembly_res)>0) {
36
                while ($r = mysqli_fetch_array($get_assembly_res)) {
37
                        echo "
38
                        <fieldset>
39
                                <a href=\"javascript:;\" onmousedown=\"toggleDiv('step".$r['StepNo']."');\">
40
                                <legend>Step ".$r['StepNo']."</legend>
41
                                </a>
42
                                
43
                                <div id=\"step".$r['StepNo']."\" style=\"display:none;\">
44
                                <dl>
45
                                        <dt><label for=\"title\">Title:</label></dt>
46
                                        <dd><input type=\"text\" name=\"title\" value=\"".$r['StepTitle']."\" id=\"email\" size=\"50\" maxlength=\"128\" /></dd>
47
                                </dl>
48
                                <dl>
49
                                        <dt><label for=\"comments\">Message:</label></dt>
50
                                        <dd><textarea name=\"comments\" id=\"comments\" rows=\"10\" cols=\"150\">".$r['Content']."</textarea></dd>
51
                                </dl>
52
                                </div>
53
                        </fieldset>
54
                        ";
55
                }
56
        }
57
?>
58
                                        
59
                                </div>
60
</div>
61

    
62
    <fieldset class="action">
63
            <input type="submit" name="submit" id="submit" value="Submit" />
64
    </fieldset>
65
        
66
        <fieldset>
67
                <SELECT name="Multi-line, multi-selection Listbox example" size="5" style="width:150px;font-size:20px;">
68
                <OPTION value="5">five</OPTION>
69
                <OPTION selected value="6">six</OPTION>
70
                <OPTION value="7">seven</OPTION>
71
                <OPTION value="8">eight</OPTION>
72
                </SELECT>
73
        </fieldset>
74
        
75
</form>
76

    
77
<?php
78
}
79
?>1
80

    
81
</div>