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); ?>
|
|
|