<?php
include_once("session.php");
include_once("settings.php");
include_once("functions.php");
//
//if (isset($_POST["submit"])) {
//    $name = $_POST['Brand_Name'];
//    $category = $_POST['Categoryname'];
//    $feedback = $_POST['Feedback_Name'];
////
//    $sql = "insert into tblnewcategory (brand_name,category_name,feedback,image) VALUES ('$name','$category',$feedback','$image')";
////
//    if (mysql_query($sql)) {
//        echo "New record created successfully";
//    } else {
//        echo "Error: " . $sql . "<br>" . mysql_error($con);
//      }
//    }  
//
//
if ($_REQUEST["mode"] == "Edit") {
    $mode = "Edit";
    $mode2 = "EDIT";
    $mode1 = "Update";
    $id = $_REQUEST['id'];
    $rs_tblsite = mysql_query("select * from tblnewcategory where `category_id`='$id'");
    $array_tblsite = mysql_fetch_array($rs_tblsite);

    $Id = $array_tblsite['category_id'];
    $name = $array_tblsite['brand_name'];
    $category_name = $array_tblsite['category_name'];
    $feedback = $array_tblsite['feedback'];
    $image = $array_tblsite['image'];
} else {
    $mode = "Add";
    $mode2 = "ADD";
    $mode1 = "Add";
}
?>
<LINK href="mel.css" type=text/css 
      rel=stylesheet><LINK href="sdmenu.css" 
      type=text/css rel=stylesheet>
<script>
    function MM_findObj(n, d) { //v4.01
        var p, i, x;
        if (!d)
            d = document;
        if ((p = n.indexOf("?")) > 0 && parent.frames.length) {
            d = parent.frames[n.substring(p + 1)].document;
            n = n.substring(0, p);
        }
        if (!(x = d[n]) && d.all)
            x = d.all[n];
        for (i = 0; !x && i < d.forms.length; i++)
            x = d.forms[i][n];
        for (i = 0; !x && d.layers && i < d.layers.length; i++)
            x = MM_findObj(n, d.layers[i].document);
        if (!x && d.getElementById)
            x = d.getElementById(n);
        return x;
    }

    function MM_validateForm() { //v4.0
        var i, p, q, nm, test, num, min, max, errors = '', args = MM_validateForm.arguments;
        for (i = 0; i < (args.length - 2); i += 3) {
            test = args[i + 2];
            val = MM_findObj(args[i]);
            if (val) {
                nm = val.name;
                if ((val = val.value) != "") {
                    if (test.indexOf('isEmail') != -1) {
                        p = val.indexOf('@');
                        if (p < 1 || p == (val.length - 1))
                            errors += '- ' + nm + ' must contain an e-mail address.\n';
                    } else if (test != 'R') {
                        num = parseFloat(val);
                        if (isNaN(val))
                            errors += '- ' + nm + ' must contain a number.\n';
                        if (test.indexOf('inRange') != -1) {
                            p = test.indexOf(':');
                            min = test.substring(8, p);
                            max = test.substring(p + 1);
                            if (num < min || max < num)
                                errors += '- ' + nm + ' must contain a number between ' + min + ' and ' + max + '.\n';
                        }
                    }
                } else if (test.charAt(0) == 'R')
                    errors += '- ' + nm + ' is required.\n';
            }
        }
        if (errors)
            alert('The following error(s) occurred:\n' + errors);
        document.MM_returnValue = (errors == '');
    }
//-->
</script>
<script language="javascript" type="text/javascript" src="<?= _WWWROOT ?>/tinymce/jscripts/tiny_mce/tiny_mce.js"></script>
<script language="javascript" type="text/javascript">
    tinyMCE.init({
        theme: "advanced",
        mode: "exact",
        elements: "Category_Description",
        save_callback: "customSave",
        content_css: "example_advanced.css",
        extended_valid_elements: "a[href|target|name]",
        plugins: "table",
        theme_advanced_buttons3_add_before: "tablecontrols,separator",
        //invalid_elements : "a",
        theme_advanced_styles: "Header 1=header1;Header 2=header2;Header 3=header3;Table Row=tableRow1", // Theme specific setting CSS classes
        //execcommand_callback : "myCustomExecCommandHandler",
        debug: false
    });

    // Custom event handler
    function myCustomExecCommandHandler(editor_id, elm, command, user_interface, value) {
        var linkElm, imageElm, inst;

        switch (command) {
            case "mceLink":
                inst = tinyMCE.getInstanceById(editor_id);
                linkElm = tinyMCE.getParentElement(inst.selection.getFocusElement(), "a");

                if (linkElm)
                    alert("Link dialog has been overriden. Found link href: " + tinyMCE.getAttrib(linkElm, "href"));
                else
                    alert("Link dialog has been overriden.");

                return true;

            case "mceImage":
                inst = tinyMCE.getInstanceById(editor_id);
                imageElm = tinyMCE.getParentElement(inst.selection.getFocusElement(), "img");

                if (imageElm)
                    alert("Image dialog has been overriden. Found image src: " + tinyMCE.getAttrib(imageElm, "src"));
                else
                    alert("Image dialog has been overriden.");

                return true;
        }

        return false; // Pass to next handler in chain
    }

    // Custom save callback, gets called when the contents is to be submitted
    function customSave(id, content) {

    }
</script>
<table width="94%" border="0" cellspacing="0" cellpadding="0">
    <tr> 
        <td><form action="write_newcategory.php" method="post" enctype="multipart/form-data"  name="add_Category_form" onsubmit="MM_validateForm('Category_Id', '', 'R', 'Category_Name', '', 'R');
                return document.MM_returnValue">
                <fieldset>
                    <legend> NEW CATEGORY 
                        <?= $mode2 ?>
                        FORM</legend>
                    <table width="97%" border="0" cellspacing="2" cellpadding="0">
                        <tr> 
                            <td height="26" class="general" required>Local Brand  Name : </td>
                            <td height="26" > 
                                <!--              <?= listdisplaydropdownvalues('Species_Id', 'Species_Id', 'tblSpecies', 'Species_Name', $Species_Id); ?>  -->
                                <input name="Brand_Name" type="text" class="textfield" id="Brand_Name"  value="<?= $name; ?>" size="35" maxlength="100"/>
                            </td>
                        </tr>
                        <tr> 
                            <td width="29%" height="26" class="general">Local Category Name :</td>
                            <td width="71%" height="26" ><input name="Categoryname" type="text" class="textfield" id="Categoryname"  value="<?= $category_name; ?>" size="35" maxlength="100"/></td>
                        </tr>                                                                  

                        <tr>
                            <td width="29%" height="26" class="general">Feedback Message</td>
                            <td><TEXTAREA  name="Feedback_Name" rows="5" cols="40" class="textfield" id="Feedback_Name"  value="<?= $feedback; ?>" /><?= $feedback; ?> </TEXTAREA> </TD>
                        </Tr>

                        <tr> 
                            <td height="26" class="general">Image uploaded:</td>
                            <td height="26"><input type="file" name="image" class="textfield"> <?php if ($image != "") { ?><img src="../cat_images/catBg/<?= $image; ?>" width="189" height="81"> <?php } ?></td>
                        </tr>

                        <tr align="center"> 
                            <td height="26" colspan="2"><label for="label"> 
                                    <input type="hidden" name="id" value="<?= $_REQUEST['id'] ?>" />
                                    <input type="submit" name="Submit" value="  Save  " class="button" />
                                    &nbsp;&nbsp;&nbsp;&nbsp; 
                                    <input type="reset" name="Submit" value="Reset" class="button" />
                                    <input name="mode" type="hidden" id="mode" value="<?= $_REQUEST['mode'] ?>" />
                                </label></td>
                        </tr>
                    </table>
                </fieldset>
            </form></td>
    </tr>
</table>