Guriddo » jumpingjackson's Replies

jumpingjackson

Guriddo

Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)

Author

Replies

February 17, 2016 at 8:09 am in reply to: Pager error: Uncaught TypeError: Cannot read property 'styleUI' of undefined #124864

jumpingjackson

Participant

&lt;?php
session_start();

if(!isset($_SESSION[&#039;user_session&#039;]))
{
    header(&quot;Location: index.html&quot;);
}

include_once &#039;dbconfig.php&#039;;

$stmt = $db_con-&gt;prepare(&quot;SELECT * FROM tbl_users WHERE user_id=:uid&quot;);
$stmt-&gt;execute(array(&quot;:uid&quot;=&gt;$_SESSION[&#039;user_session&#039;]));
$row=$stmt-&gt;fetch(PDO::FETCH_ASSOC);

?&gt;

&lt;!doctype html&gt;
&lt;!--[if lt IE 7]&gt;      &lt;html class=&quot;no-js lt-ie9 lt-ie8 lt-ie7&quot; lang=&quot;&quot;&gt; &lt;![endif]--&gt;
&lt;!--[if IE 7]&gt;         &lt;html class=&quot;no-js lt-ie9 lt-ie8&quot; lang=&quot;&quot;&gt; &lt;![endif]--&gt;
&lt;!--[if IE 8]&gt;         &lt;html class=&quot;no-js lt-ie9&quot; lang=&quot;&quot;&gt; &lt;![endif]--&gt;
&lt;!--[if gt IE 8]&gt;&lt;!--&gt; &lt;html class=&quot;no-js&quot; lang=&quot;&quot;&gt; &lt;!--&lt;![endif]--&gt;
&lt;head&gt;
    &lt;meta charset=&quot;utf-8&quot;&gt;
    &lt;meta http-equiv=&quot;X-UA-Compatible&quot; content=&quot;IE=edge,chrome=1&quot;&gt;
    &lt;title&gt;&lt;/title&gt;
    &lt;meta name=&quot;description&quot; content=&quot;&quot;&gt;
    &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1&quot;&gt;
    &lt;link rel=&quot;apple-touch-icon&quot; href=&quot;apple-touch-icon.png&quot;&gt;

    &lt;style&gt;
        body {
            padding-top: 50px;
            padding-bottom: 20px;
        }
    &lt;/style&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;css/vendor/bootstrap/bootstrap.min.css&quot;&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;css/vendor/bootstrap/bootstrap-theme.min.css&quot;&gt;
    &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; media=&quot;screen&quot; href=&quot;css/vendor/jquery-ui/jquery-ui.css&quot; /&gt;
    &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; media=&quot;screen&quot; href=&quot;css/vendor/jqgrid/ui.jqgrid.css&quot; /&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;css/main.css&quot;&gt;

    &lt;script src=&quot;js/vendor/modernizr-2.8.3-respond-1.4.2.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;js/vendor/jquery-1.12.0.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;js/vendor/bootstrap.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;js/vendor/i18n/grid.locale-en.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;js/vendor/jquery.jqGrid.min.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;

    &lt;script src=&quot;js/tables.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
    &lt;/body&gt;

&lt;/head&gt;
&lt;body&gt;
&lt;!--[if lt IE 8]&gt;
&lt;p class=&quot;browserupgrade&quot;&gt;You are using an &lt;strong&gt;outdated&lt;/strong&gt; browser. Please &lt;a href=&quot;http://browsehappy.com/&quot;&gt;upgrade your browser&lt;/a&gt; to improve your experience.&lt;/p&gt;
&lt;![endif]--&gt;
&lt;nav class=&quot;navbar navbar-inverse navbar-fixed-top&quot; role=&quot;navigation&quot;&gt;
    &lt;div class=&quot;container&quot;&gt;
        &lt;div class=&quot;navbar-header&quot;&gt;
            &lt;button type=&quot;button&quot; class=&quot;navbar-toggle collapsed&quot; data-toggle=&quot;collapse&quot; data-target=&quot;#navbar&quot; aria-expanded=&quot;false&quot; aria-controls=&quot;navbar&quot;&gt;
                &lt;span class=&quot;sr-only&quot;&gt;Toggle navigation&lt;/span&gt;
                &lt;span class=&quot;icon-bar&quot;&gt;&lt;/span&gt;
                &lt;span class=&quot;icon-bar&quot;&gt;&lt;/span&gt;
                &lt;span class=&quot;icon-bar&quot;&gt;&lt;/span&gt;
            &lt;/button&gt;
            &lt;a class=&quot;navbar-brand&quot; href=&quot;#&quot;&gt;Home Inventory App&lt;/a&gt;
        &lt;/div&gt;
        &lt;div id=&quot;navbar&quot; class=&quot;navbar-collapse collapse&quot;&gt;

        &lt;/div&gt;&lt;!--/.navbar-collapse --&gt;
    &lt;/div&gt;
&lt;/nav&gt;
&lt;div class=&quot;col-md-12&quot;&gt;
    &lt;table id=&quot;loclist&quot;&gt;&lt;/table&gt;
    &lt;div id=&quot;locPager&quot;&gt;&lt;/div&gt;

    &lt;hr&gt;
&lt;/div&gt;

&lt;footer&gt;
    &lt;p&gt;&amp;copy; PCB 2016&lt;/p&gt;
&lt;/footer&gt;

&lt;/html&gt;

<?php

session_start();

if(!isset($_SESSION['user_session']))

{

header("Location: index.html");

}

include_once 'dbconfig.php';

$stmt = $db_con->prepare("SELECT * FROM tbl_users WHERE user_id=:uid");

$stmt->execute(array(":uid"=>$_SESSION['user_session']));

$row=$stmt->fetch(PDO::FETCH_ASSOC);

<!doctype html>

<html class="no-js" lang="">

<head>

<style>

body {

padding-top: 50px;

padding-bottom: 20px;

}

</style>

</body>

</head>

<body>

<!--[if lt IE 8]>

<p class="browserupgrade">You are using an <strong>outdated</strong> browser. Please <a href="http://browsehappy.com/">upgrade your browser</a> to improve your experience.</p>

<![endif]-->

<span class="sr-only">Toggle navigation</span>

</button>

<a class="navbar-brand" href="#">Home Inventory App</a>

</div>

</div>

</div>

</nav>

<hr>

</div>

</footer>

</html>

February 17, 2016 at 8:08 am in reply to: Pager error: Uncaught TypeError: Cannot read property 'styleUI' of undefined #124863

jumpingjackson

Participant


/**
 * Created by Phil on 1/30/2016.
 */
$(function () {
    $(&quot;#loclist&quot;).jqGrid({
        url: &quot;../HomeInventory/GetLocations.php&quot;,
        editurl: &quot;../HomeInventory/CRUDLocations&quot;,
        datatype: &quot;json&quot;,
        mtype: &quot;GET&quot;,
        colNames: [&quot;loc Id&quot;, &quot;Name&quot;, &quot;Street1&quot;, &quot;Street2&quot;, &quot;Street3&quot;, &quot;City&quot; , &quot;State&quot;, &quot;Zip&quot;],
        colModel: [
            { name: &quot;locid&quot;, width: 55 ,key: true, editable: true, editrules : { required: true} },
            { name: &quot;locname&quot;, width: 90  ,editable: true},
            { name: &quot;street1&quot;, width: 80, align: &quot;right&quot; ,editable: true },
            { name: &quot;street2&quot;, width: 80, align: &quot;right&quot;  ,editable: true},
            { name: &quot;street3&quot;, width: 80, align: &quot;right&quot;  ,editable: true},
            { name: &quot;city&quot;, width: 80, align: &quot;right&quot;  ,editable: true},
            { name: &quot;state&quot;, width: 80, align: &quot;right&quot;  ,editable: true},
            { name: &quot;zip&quot;, width: 80, align: &quot;right&quot; ,editable: true }
        ],
        pager: &quot;#locPager&quot;,
        rowNum: 10,
        rowList: [10, 20, 30],
        sortname: &quot;locid&quot;,
        sortorder: &quot;desc&quot;,
        viewrecords: true,
        gridview: true,
        autoencode: true,
        caption: &quot;Locations&quot;
    });
    $(&#039;#locPager&#039;).navGrid(&#039;#locPager&#039;,
        // the buttons to appear on the toolbar of the grid
        { edit: true, add: true, del: true, search: false, refresh: false, view: false, position: &quot;left&quot;, cloneToTop: false },
        // options for the Edit Dialog
        {
            editCaption: &quot;The Edit Dialog&quot;,
            recreateForm: true,
            checkOnUpdate : true,
            checkOnSubmit : true,
            closeAfterEdit: true,
            errorTextFormat: function (data) {
                return &#039;Error: &#039; + data.responseText
            }
        },
        // options for the Add Dialog
        {
            closeAfterAdd: true,
            recreateForm: true,
            errorTextFormat: function (data) {
                return &#039;Error: &#039; + data.responseText
            }
        },
        // options for the Delete Dailog
        {
            errorTextFormat: function (data) {
                return &#039;Error: &#039; + data.responseText
            }
        });
});

/**

* Created by Phil on 1/30/2016.

$(function () {

$("#loclist").jqGrid({

url: "../HomeInventory/GetLocations.php",

editurl: "../HomeInventory/CRUDLocations",

datatype: "json",

mtype: "GET",

colNames: ["loc Id", "Name", "Street1", "Street2", "Street3", "City" , "State", "Zip"],

colModel: [

{ name: "locid", width: 55 ,key: true, editable: true, editrules : { required: true} },

{ name: "locname", width: 90 ,editable: true},

{ name: "street1", width: 80, align: "right" ,editable: true },

{ name: "street2", width: 80, align: "right" ,editable: true},

{ name: "street3", width: 80, align: "right" ,editable: true},

{ name: "city", width: 80, align: "right" ,editable: true},

{ name: "state", width: 80, align: "right" ,editable: true},

{ name: "zip", width: 80, align: "right" ,editable: true }

pager: "#locPager",

rowNum: 10,

rowList: [10, 20, 30],

sortname: "locid",

sortorder: "desc",

viewrecords: true,

gridview: true,

autoencode: true,

caption: "Locations"

});

$('#locPager').navGrid('#locPager',

// the buttons to appear on the toolbar of the grid

{ edit: true, add: true, del: true, search: false, refresh: false, view: false, position: "left", cloneToTop: false },

// options for the Edit Dialog

{

editCaption: "The Edit Dialog",

recreateForm: true,

checkOnUpdate : true,

checkOnSubmit : true,

closeAfterEdit: true,

errorTextFormat: function (data) {

return 'Error: ' + data.responseText

}

// options for the Add Dialog

{

closeAfterAdd: true,

recreateForm: true,

errorTextFormat: function (data) {

return 'Error: ' + data.responseText

}

// options for the Delete Dailog

{

errorTextFormat: function (data) {

return 'Error: ' + data.responseText

}

});

Author

Replies

Viewing 2 replies - 1 through 2 (of 2 total)