PHP Builder

[administrator]

BETA version 4.1.6 of PHP DataGrid is available for downloading from
>> here <<

Examples of using and code syntax see in code_template.php file.

Main additions and improvements:
Feature: [added] new type "linktoedit" for view mode
Feature: [added] display order of columns defined by user, not by order in SELECT SQL
Feature: [added] new parameter "unique" for columns in edit mode
Feature: [added] new parameters for type texarea: "rows"=>"7" and "cols"=>"50"

Feature: [improved] method getRequestVars() renamed in getVariable()
Feature: [improved] downloading of export files
Feature: [improved] detecting filed properties while auto code generation
Feature: [improved] selecting and highlighting rows
Feature: [improved] removed unnecessary sql statments on updating/deleting

Bug: [Fixed] small bug in setModes() function
Bug: [Fixed] strtolower() small bug in some place
Bug: [Fixed] wrong URL after the click on 'Reset' button
Bug: [Fixed] missing WHERE in SQL SELECT error
Bug: [Fixed] LCASE error for Oracle and MSSQL
Bug: [Fixed] canceling of row highlighting, with click on delete button in IE
Bug: [Fixed] wrong syntax with NUMROWS processing for Oracle
Bug: [Fixed] syntax error in setSqlByDbType() and setSqlLimitByDbType()
Bug: [Fixed] FireFox error on carrying out multirow operations and pagging (&amp;)
Bug: [Fixed] empty data error on required numeric fileds while updating
Bug: [Fixed] error on deleting last row from the last page

[zewa666]

hows the mail sending working?

i check the rows id like and click onto the button. He asks me if I'm sure, and after pressing ok, nothing happens.

Greetings
Zewa

[fcallez]

Good day

You will have to create his own code after the following:

[fcallez]

Hi

When the method is used:

setMultirowOperations

With the option:

[fcallez]

Hi :

Open a new window and put salt in the following message:

Can not find such path: ../../export.xml !

Can not find such path: ../../export.csv !

Thanks
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez

[fcallez]

Good day

Two observations, in the directory:

datagrid\examples

In programs:

code_example1.php
code_example2.php


1. Names of tables and fields in small letters,

example :

[zewa666]

hi fcallez ...

what I wanted to know is what the function right now performs, because I cant see anywhere a mailsending happening

Greetings
Zewa

[fcallez]

Hello

You will not find it..

You have to create the code than evalue the flag_name and the flag_value

[fcallez]

Hi :

Code:

[zewa666]

ahh ok I understand ... thought that was a fixed up function ready to go.

thx again for explanation

Greetings
Zewa

[fcallez]

Hi, Suggestions :

code : code_examples.php

## *** set data source with needed options
$default_order_field = "region, countryID";
$default_order_type = "ASC, ASC";
$dgrid->dataSource($db_conn, $sql, $default_order_field, $default_order_type);

...

## *** set sorting option: true(default) or false
$sorting_option = true;
$dgrid->allowSorting($sorting_option);


code : datagrid.class.php

-------------------------------------------->>>>>>>>>>>

function dataSource($db_handl, $sql = "", $start_order = "", $start_order_type = ""){

....

$this->sql_view = str_replace(";", "", $sql);

$this->start_order = $start_order; // Adding 02/07/07
$this->start_order_type = $start_order_type; // Adding 02/07/07

....

function setFieldsFiltering($filter_fields_array = ""){

....


// $this->dataSource($this->db_handler, $this->sql_view); // Modify 02/07/07
$this->dataSource($this->db_handler, $this->sql_view, $this->start_order, $this->start_order_type); // Modify 02/07/07

....

function drawControlPanel(){

....

echo "</td>";

echo "<td align='right' width='20px'>"; // Adding 02/07/07
echo "<input class='class_button' type='button' value='".$this->lang['reset']."' onClick='document.location.href=\"".$this->HTTP_URL.$this->combineUrl("view")."\"'>&nbsp;"; // Adding 02/07/07
echo "</td>"; // Adding 02/07/07

echo "</tr>";
echo "</table>";
}

....

function setUrlStringSorting(&$curr_url, $amp="&amp;"){

.....

}else {
if(!is_numeric($this->default_sort_field[0])){ $this->default_sort_field[0] = $this->getFieldOffset($this->default_sort_field[0]) + 1; }
// $curr_url .= $amp.$this->unique_prefix."sort_field=".$this->default_sort_field[0]; // Modify 02/07/07
}; // make pKey
if($sort_type != "") {
$this->sort_type = $sort_type;
// $curr_url .= $amp.$this->unique_prefix."sort_type=".$this->sort_type; // Modify 02/07/07
} else {
// $curr_url .= $amp.$this->unique_prefix."sort_type=".$this->default_sort_type[0]; // Modify 02/07/07
};
}

--------------------------------------------<<<<<<<<
Of course, this proposal is improvable


Greetings
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez

[fcallez]

Hi :

I, reading, studying, understanding the code, and everything is working OK, excellent functionality. Thanks

But :

Creating a new method, this would be able to be useful

------------------------------>>>>>>>

Code : code_examples.php

## *** set variables that used to the page

$http_get_vars_all = array(
"options" => array("val1", "val2", "val3", "val4", "val5"),
"values" => array("100", "200", "300", "500", "1000")
);
$dgrid->setHttpGetVarsall ($http_get_vars_all);

-------------------------------------------<<<<<<<<<<<<<<

Code : datagrid.class.php


function setHttpGetVarsall($http_get_vars_all = ""){

if(is_array($http_get_vars_all)){

foreach($http_get_vars_all as $hgvkey1 => $hgvValue1){

foreach($hgvValue1 as $hgvkey2 => $hgvValue2){

$this->http_get_vars_all [$hgvkey1] [$hgvkey2] = $hgvValue2;

}
}
}
}

.....

function saveHttpGetVars(){

if(is_array($this->http_get_vars) && (count($this->http_get_vars) > 0)){
foreach($this->http_get_vars as $key){
echo "<input type='hidden' name='".$key."' id='".$key."' value='".((isset($_REQUEST[$key]))?$_REQUEST[$key]:"")."'>";
}
}

// Adding

if(is_array($this->http_get_vars_all) && (count($this->http_get_vars_all) > 0)){
foreach($this->http_get_vars_all as $hgvkey1 => $hgvValue1){
foreach($hgvValue1 as $hgvkey2 => $hgvValue2){
}
}
$count_hgckey2=$hgvkey2+1;

for($ind=0;$ind<$count_hgckey2;$ind++) {
echo "<input type='hidden' name='".$this->http_get_vars_all['options'][$ind]."' id='".$this->http_get_vars_all['options'][$ind]."' value='".$this->http_get_vars_all['values'][$ind]."'>";
}
}


.........


function combineUrl($mode, $rid="", $amp="&"){
$ind = 0;

if(is_array($this->http_get_vars) && (count($this->http_get_vars) > 0)){
foreach($this->http_get_vars as $key){
if($ind == 0){ $a_url = "?"; $ind = 1; }
else $a_url .= $amp;
$a_url .= $key."=".((isset($_REQUEST[$key]))?$_REQUEST[$key]:"");
}
}

// Adding

if(is_array($this->http_get_vars_all) && (count($this->http_get_vars_all) > 0)){
foreach($this->http_get_vars_all as $hgvkey1 => $hgvValue1){
foreach($hgvValue1 as $hgvkey2 => $hgvValue2){
}
}
$count_hgckey2=$hgvkey2+1;

for($i=0;$i<$count_hgckey2;$i++) {

if($ind == 0){ $a_url = "?"; $ind = 1; }
else $a_url .= $amp;
$a_url .= $this->http_get_vars_all['options'][$i]."=".$this->http_get_vars_all['values'][$i];
}
}


-------------------------------------<<<<<<<<<<

Greetings
_________________
Franklin Calle Zapata
fcallez@gmail.com
skype : fcallez

[Matt Bittner]

Forgive me, but when I uploaded 4.1.6 and tried to open (run) the page that worked fine in 4.1.5 I receive the following error message:

"No data found! Please, check carefully your code syntax!
It may be case sensitive or there are some unexpected symbols.

For more information, turn on debug mode."

What are the changes made that stopped my code from executing? Frustrating...
_________________
Matt Bittner
Modeling the Aircraft of the Soviet VVS
http://vvs.hobbyvista.com/index.php

[administrator]

[Matt Bittner]

<sigh>

I understand, but my point was when you're changing the parameters and functionality to document what the changes are between versions.

Thanks for the tip on turning on debug mode, I now see that you stick in your own "WHERE 1=1" into the main SQL statement, which is totally messing up my own WHERE clause (to join all my tables together). How can I get around your "WHERE 1=1" and still have all my tables joined together?
_________________
Matt Bittner
Modeling the Aircraft of the Soviet VVS
http://vvs.hobbyvista.com/index.php