Project

General

Profile

Statistics
| Branch: | Revision:

colonymech / docs / www / colonyscout / internal / assembly_edit_steps.php @ f59acf11

History | View | Annotate | Download (1.9 KB)

1
<html>
2
<head>
3
<link href="css/assembly.css" rel="stylesheet" type="text/css" media="screen">
4
<style>
5
input.text {font-size:16px;font-weight:bold;background-color:#ececec;border:none;}
6
</style>
7
</head>
8
<?php
9
include_once("do_login.php");
10
doDB("colony_scout");
11

    
12
if (!isset($_GET['save']) && !isset($_POST['stepNo'])) {
13
        echo "No direct access!";
14
        exit;
15
} elseif (isset($_GET['save']) && $_GET['save']=='true') {
16
        //do save
17
        $verify_account_sql = "UPDATE assemblysteps SET StepTitle=\"".$_POST['stepTitle']."\", Content=\"".mysqli_escape_string($mysqli,$_POST["stepContent"])."\" WHERE ID=".$_POST['stepNo'];
18
        $verify_account_res =  mysqli_query($mysqli, $verify_account_sql) or die(mysqli_error($mysqli));
19

    
20
        //close connection to MySQL
21
        mysqli_close($mysqli);
22

    
23
        header("Location: ?save=success");
24
        exit();        
25
} elseif (isset($_GET['save']) && $_GET['save']=='success') {
26
        echo "<h1>Saved!</h1>";
27
} else {
28
        $get_assembly_sql = "SELECT * FROM assemblysteps WHERE ID=\"".$_POST['stepNo']."\" LIMIT 1";
29
        $get_assembly_res = mysqli_query($GLOBALS['mysqli'], $get_assembly_sql) or die(mysqli_error($GLOBALS['mysqli']));
30
                                
31
        if (mysqli_num_rows($get_assembly_res)>0) {
32
                while ($r = mysqli_fetch_array($get_assembly_res)) {
33
                        echo "
34
                        <form action=\"?save=true\" method=\"post\" class=\"editForm\">
35
                        <dl>
36
                                <dt><label for=\"title\">Title:</label></dt>
37
                                <dd><input class=\"text\" type=\"text\" name=\"stepTitle\" value=\"".$r['StepTitle']."\" id=\"email\" size=\"50\" maxlength=\"128\" /></dd>
38
                        </dl>
39
                        <dl>
40
                                <dt><label for=\"comments\">Message:</label></dt>
41
                                <dd><textarea name=\"stepContent\" id=\"comments\" rows=\"10\" cols=\"120\">".$r['Content']."</textarea></dd>
42
                        </dl>
43
                        <dl>
44
                                <dt></dt>
45
                                <dd><input type=\"submit\" name=\"save\" id=\"submit\" value=\"Save Changes\" style=\"font-size:20px;\"/></dd>
46
                                <input type=\"hidden\" name=\"stepNo\" value=\"".$r['ID']."\"/>
47
                        </dl>
48
                        </form>                        
49
                        ";
50
                }
51
        }
52
}
53
?>
54

    
55
</html>