DwZone Forum DwZone Forum
Welcome to the DwZone-it Forum
 
  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  
    RegisterRegister -->   LoginLogin  
Ajax DataGrid  
DwZone Forum Index -> Ajax DataGrid

Moderators: AdministratorsModerators 
Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.
New Topic Search for
 View     Per page     Messages Since 
Messages 251 to 260 of 485 (Total: 409) First |  Prev |  Next |  Last  
 Subject Author Date  
   Re: Set session variable  
View this persons public profile  Gianluigi   9:17 24 Oct 2011  
   Re: Set session variable  
View this persons public profile  Andrew   21:15 25 Oct 2011  
   Re: Set session variable  
View this persons public profile  Gianluigi   9:29 26 Oct 2011  
   Re: Set session variable  
View this persons public profile  Andrew   15:34 26 Oct 2011  
    Cannot get to work  
View this persons public profile  Andrew   18:39 5 Oct 2011  
 
I am using Adobe Dreamweaver CS4. I tried creating the server behavior, went through setting up a recordset, setup a simple datagrid but nothing is showing on the page. I followed the instructions carefully on the video as well. What is the max number of records this can handle? Just wondering if that is an issue.



<?php
//***************
// Ajax DataGrid
//***************
require_once('dwzGrid/AjaxDataGrid.php');
?>
<?php require_once('Connections/med.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

mysql_select_db($database_med, $med);
$query_georeference = "SELECT * FROM georeference";
$georeference = mysql_query($query_georeference, $med) or die(mysql_error());
$row_georeference = mysql_fetch_assoc($georeference);
$totalRows_georeference = mysql_num_rows($georeference);
?>
<?php
//******************************
// http://www.DwZone-it.com
// Ajax DataGrid
// Version 1.2.2
//******************************
$dwzGrid_1 = new dwzAjaxDataGrid();
$dwzGrid_1->Init();
$dwzGrid_1->SetInstance("1");
$dwzGrid_1->SetRootPath("");
$dwzGrid_1->SetCnString("None");
$dwzGrid_1->SetEditPar("void|_@_|void|_@_||_@_|georef_id|_@_|ALL");
$dwzGrid_1->Add("georef_id", "georef_id", "50", "String", "Left", "Y", "N", "N|_@_|Y|_@_|50|_@_|3|_@_|TextBox|_@_||_@_||_@_||_@_||_@_||_@_||_@_|Void|_@_||_@_|false|_@_||_@_||_@_||_@_||_@_||_@_||_@_|20|_@_|12|_@_||_@_||_@_|None|_@_|rec_placeholder|_@_|Y|_@_|None|_@_|None|_@_|", Null);
$dwzGrid_1->Add("point_id", "point_id", "50", "String", "Left", "Y", "N", "N|_@_|Y|_@_|50|_@_|3|_@_|TextBox|_@_||_@_||_@_||_@_||_@_||_@_||_@_|Void|_@_||_@_|false|_@_||_@_||_@_||_@_||_@_||_@_||_@_|20|_@_|12|_@_||_@_||_@_|None|_@_|rec_placeholder|_@_|Y|_@_|None|_@_|None|_@_|", Null);
$dwzGrid_1->AddDetailPar("");
$dwzGrid_1->AddDetailFields("");
$dwzGrid_1->SaveDelete();
$dwzGrid_1->SetRecordset($georeference);
$dwzGrid_1->SetDetailRecordset("NULL");
$dwzGrid_1->SetMainPar("400|_@_|250|_@_|void|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|15|_@_|10,15,20,25,40|_@_|Georeference|_@_|Form|_@_|en|_@_|utf-8;65001;Unicode (UTF-8)|_@_|like|_@_|date|_@_||_@_|false|_@_|Required|_@_|Max length must be {1}|_@_|Text format|_@_|Date format|_@_|Min value must be {1}|_@_|Max value must be {1}|_@_|Not the first item|_@_|false|_@_||_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|,|_@_|No|_@_|false|_@_|root|_@_|row|_@_|Nodes|_@_|false|_@_|None;12;#000000;false;false;false;#FFFFFF|_@_|None;12;#000000;false;false;false;#FFFFFF;0;#000000;0,3|_@_|A4;L;25;25;25;25;false;Center;1|_@_|No|_@_||_@_||_@_||_@_|#000000|_@_|0.6|_@_|10|_@_|350|_@_|_s|_@_|false|_@_|None|_@_|<b>{0} - {1} Item(s)</b>|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|ASC|_@_|false|_@_|false|_@_||_@_||_@_||_@_|");
$dwzGrid_1->CreateData();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?php
//******************************
// Ajax DataGrid
//******************************
echo dwzGridGetHeadCode("", "black-tie", "en");
//******************************
// Ajax DataGrid
//******************************
?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<?php
//******************************
// Ajax DataGrid
//******************************
$dwzGrid_1->GetHeadCode();
//******************************
// Ajax DataGrid
//******************************
?>
</head>

<body>
<?php
//******************************
// Ajax DataGrid
//******************************
$dwzGrid_1->CreateGrid();
//******************************
// Ajax DataGrid
//******************************
?>
</body>
</html>
<?php
mysql_free_result($georeference);
?>


 
Reply to this current thread  View this persons public profile  Send Private Message
   Re: Cannot get to work  
View this persons public profile  Gianluigi   7:12 7 Oct 2011  
   Re: Cannot get to work  
View this persons public profile  Andrew   21:14 19 Oct 2011  
   Re: Cannot get to work  
View this persons public profile  Gianluigi   11:59 20 Oct 2011  
   Re: Cannot get to work  
View this persons public profile  Andrew   15:41 20 Oct 2011  
   Re: Cannot get to work  
View this persons public profile  Andrew   17:07 20 Oct 2011  
Last Visit: Saturday 19 Apr, 2025 3:48 pm First |  Prev |  Next |  Last  
 Login
Username:  Password:    
Read Message Read Message   Unread message Unread message
Read message [popular] Read message [popular]   Unread message [popular] Unread message [popular]
Read message [locked] Read message [locked]   Unread message [locked] Unread message [locked]
All times are GMT-2

Jump to: