[sigitParticipant]

hi walter..

no.. haha.. i still find a way out how to CRUD this table..
and i got a little solution,.. haha, the table can update rows, but.. it not generate on database..
i think if it can generate on database. it is a great way out. and solve our problem. haha…

look out..
on demos :

var generaterow = function (i) {
                var row = {};
                var productindex = Math.floor(Math.random() * productNames.length);
                var price = parseFloat(priceValues[productindex]);
                var quantity = 1 + Math.round(Math.random() * 10);
                row["firstname"] = firstNames[Math.floor(Math.random() * firstNames.length)];
                row["lastname"] = lastNames[Math.floor(Math.random() * lastNames.length)];
                row["productname"] = productNames[productindex];
                row["price"] = price;
                row["quantity"] = quantity;
                row["total"] = price * quantity;
                return row;
            }
            for (var i = 0; i < 10; i++) {
                var row = generaterow(i);
                data[i] = row;
            }

how to imple this demo code on my script

 var generaterow = function (i) {
                <!--??????????????????????????????????-->
            }
            for (var i = 0; i < 10; i++) {
                var row = generaterow(i);
                data[i] = row;
            }

if this resolve,, i have to be happy with jqwidgets..

thank you wallter, Peter (sorry bad english)

sigit

[sigitParticipant]

hii mr peter,

i already defined generate row function, but still doesnt work..
-the table can generate.. but it cant create, read, update and delete data..

 var generaterow = function (i) {
                
            }
            for (var i = 0; i < 10; i++) {
                var row = generaterow(i);
                data[i] = row;
            }

please for correction my generate data…

thank you mr peter..

sigit

[sigitParticipant]

hai mr peter…

i am to noob to handle this..
how to defined that function?

many thanks

sigit

[sigitParticipant]

here my error code ….

ReferenceError: generaterow is not defined
var datarow = generaterow();
show.php (line 107)

ReferenceError: generaterow is not defined
var datarow = generaterow(rowscount + 1);
show.php (line 118)

ReferenceError: generaterow is not defined
var datarow = generaterow();
show.php (line 107)

ReferenceError: generaterow is not defined
var datarow = generaterow(rowscount + 1);

regards ..

[sigitParticipant]

hii dimitiar, hii wfr..

i’ve got same problem at you, i already update jquery ver. 1.11.0
but i’ve got nothing.. this is my table

s->varchar
a->varchar

table name ‘tes’;
grid_data.php to process query
show.oho to process table

//grid_data.php

<?php
#Include the connect.php file
include('konek.php');
#Connect to the database
//connection String
$connect = mysql_connect($hostname, $username, $password)
or die('Could not connect: ' . mysql_error());
//Select The database
$bool = mysql_select_db($database, $connect);
if ($bool === False){
   print "can't find $database";
}

// get data and store in a json array
$query = "SELECT * FROM tes";
if (isset($_GET['insert']))
{
	// INSERT COMMAND 
	$insert_query = "INSERT INTO <code>tes</code>(<code>s</code>, <code>a</code>) VALUES ('".$_GET['s']."','".$_GET['a']."')";
	
   $result = mysql_query($insert_query) or die("SQL Error 1: " . mysql_error());
   echo $result;
}
else if (isset($_GET['update']))
{
	// UPDATE COMMAND 
	$update_query = "UPDATE <code>tes</code> SET <code>a</code>='".$_GET['a']."' WHERE <code>s</code>='".$_GET['s']."'";
	 $result = mysql_query($update_query) or die("SQL Error 1: " . mysql_error());
     echo $result;
}
else if (isset($_GET['delete']))
{
	// DELETE COMMAND 
	$delete_query = "DELETE FROM <code>tes</code> WHERE <code>s</code>='".$_GET['s']."'";	
	$result = mysql_query($delete_query) or die("SQL Error 1: " . mysql_error());
    echo $result;
}
else
{
    // SELECT COMMAND
	$result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
	while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
		$employees[] = array(
			's' => $row['s'],
                    'a' => $row['a']
			
		  );
	}
	 
	echo json_encode($employees);
}
?>

//show.php

<!DOCTYPE html>
<html lang="en">
<head>
    <link rel="stylesheet" href="../../../jqwidgets/styles/jqx.base.css" type="text/css" />
    <link rel="stylesheet" href="../../../jqwidgets/styles/jqx.classic.css" type="text/css" />
    <script type="text/javascript" src="../../../scripts/jquery-1.10.2.min.js"></script>
    <script type="text/javascript" src="../../../jqwidgets/jqxcore.js"></script>
    <script type="text/javascript" src="../../../jqwidgets/jqxbuttons.js"></script>
    <script type="text/javascript" src="../../../jqwidgets/jqxscrollbar.js"></script>
    <script type="text/javascript" src="../../../jqwidgets/jqxmenu.js"></script>
    <script type="text/javascript" src="../../../jqwidgets/jqxcheckbox.js"></script>
    <script type="text/javascript" src="../../../jqwidgets/jqxlistbox.js"></script>
    <script type="text/javascript" src="../../.../jqwidgets/jqxdropdownlist.js"></script>
    <script type="text/javascript" src="../../../jqwidgets/jqxgrid.js"></script>
    <script type="text/javascript" src="../../../jqwidgets/jqxdata.js"></script>
    <script type="text/javascript" src="../../../jqwidgets/jqxgrid.selection.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            var source =
                                {
                                datatype: "json",
                                cache: false,
                                datafields: [
                                { name: 's'},
                                { name: 'a'}
                              
                                ],
                                id: 's',
                                url: 'grid_data.php',
                                
                       addrow: function (rowid, rowdata, position, commit) {
                                // synchronize with the server - send insert command
                                var data = "insert=true&" + $.param(rowdata);
                                $.ajax({
                                dataType: 'json',
                                url: 'grid_data.php',
                                data: data,
                                cache: false,
                                success: function (data, status, xhr) {
                                // insert command is executed.
                                commit(true);
                                },
                                error: function(jqXHR, textStatus, errorThrown)
                                {
                                commit(false);
                                }
                                });
                                },
                      deleterow: function (rowid, commit) {
                                // synchronize with the server - send delete command
                                var data = "delete=true&" + $.param({EmployeeID: rowid});
                                $.ajax({
                                dataType: 'json',
                                url: 'grid_data.php',
                                cache: false,
                                data: data,
                                success: function (data, status, xhr) {
                                // delete command is executed.
                                commit(true);
                                },
                                error: function(jqXHR, textStatus, errorThrown)
                                {
                                commit(false);
                                }
                                });
                                },
                     updaterow: function (rowid, rowdata, commit) {
                                // synchronize with the server - send update command
                                var data = "update=true&" + $.param(rowdata);
                                $.ajax({
                                dataType: 'json',
                                url: 'grid_data.php',
                                cache: false,
                                data: data,
                                success: function (data, status, xhr) {
                                // update command is executed.
                                commit(true);
                                },
                                error: function(jqXHR, textStatus, errorThrown)
                                {
                                commit(false);
                                }
                                });
                                }
                                };
                                
                                var dataAdapter = new $.jqx.dataAdapter(source);
// initialize jqxGrid
                            $("#jqxgrid").jqxGrid(
                            {
                            width: 500,
                            height: 350,
                            source: dataAdapter,
                            
                            columns: [
                            { text: 's', datafield: 's', width: 100 },
                            { text: 'a', datafield: 'a', width: 100 },
                            
                            ]
                            });
                            
                            $("#addrowbutton").jqxButton();
                            $("#deleterowbutton").jqxButton();
                            $("#updaterowbutton").jqxButton();
                            // update row.
                            $("#updaterowbutton").bind('click', function () {
                                var datarow = generaterow();
                                var selectedrowindex = $("#jqxgrid").jqxGrid('getselectedrowindex');
                                var rowscount = $("#jqxgrid").jqxGrid('getdatainformation').rowscount;
                                if (selectedrowindex >= 0 && selectedrowindex < rowscount) {
                                    var id = $("#jqxgrid").jqxGrid('getrowid', selectedrowindex);
                                    $("#jqxgrid").jqxGrid('updaterow', id, datarow);
                                }
                            });
                            // create new row.
                            $("#addrowbutton").bind('click', function () {
                                var rowscount = $("#jqxgrid").jqxGrid('getdatainformation').rowscount;
                                var datarow = generaterow(rowscount + 1);
                                $("#jqxgrid").jqxGrid('addrow', null, datarow);
                            });
                            // delete row.
                            $("#deleterowbutton").bind('click', function () {
                                var selectedrowindex = $("#jqxgrid").jqxGrid('getselectedrowindex');
                                var rowscount = $("#jqxgrid").jqxGrid('getdatainformation').rowscount;
                                if (selectedrowindex >= 0 && selectedrowindex < rowscount) {
                                    var id = $("#jqxgrid").jqxGrid('getrowid', selectedrowindex);
                                    $("#jqxgrid").jqxGrid('deleterow', id);
                }
            });
        });
                            
    </script>
</head>
<body class='default'>
    <div id='jqxWidget' style="font-size: 13px; font-family: Verdana; float: left;">
        <div style="float: left;" id="jqxgrid">
        </div>
        <div style="margin-left: 30px; float: left;">
            <div>
                <input id="addrowbutton" type="button" value="Add New Row" />
            </div>
            <div style="margin-top: 10px;">
                <input id="deleterowbutton" type="button" value="Delete Selected Row" />
            </div>
            <div style="margin-top: 10px;">
                <input id="updaterowbutton" type="button" value="Update Selected Row" />
            </div>
        </div>
    </div>
</body>
</html>

thank you 😀

[sigitParticipant]

hai,

i have same problem about CRUD, i dont know what the problem that make this script not running, about query or about that script, i think i already input same script like tutorial you make, and really, 2 weeks try to find what’s wrong with this php CRUD,

soorry noob, i really need someone help right now. 🙂

thankyou
Sigit

[Author]

Posts