Re: [PHP-DB] Generate Report

[Luis Morales]

ok,

Let's go here..! 

--- generate_report.php --
 0){
  $wval = array ();
  foreach($_REQUEST['sel_group'] as $k => $v){
$wval[] = "groups_id='{$v}'";
  }
  
  //extract the columns 
  $scols = array ();
  if(count($_REQUEST['sel_cols]') > 0){
foreach($_REQUEST['sel_group'] as $k => $v){
  $scols[] = "{$v}";
}
 
//building query
$where = join(' AND ', $wval);
$sel_cols = join(',', $scols);
$query = "SELECT {$sel_cols} FROM tasks WHERE {$where}";
  }

}

//if $query is empty you can catch this case as an error because
there is not any group or selected columns

  break;

  default:
//reset your form
unset($_REQUEST);
}

?>


Generate Report





Select
Group(s)
Select Columns


Category One
Category Two




Group A
Group B
Group C
Group D



Column 
A
Column 
B
Column 
C
Column 
D
Column 
E
Column 
F


Column 
G
Column 
H
Column 
I
Column 
J
Column 
K
Column 
L











-- end generate_report.php --


Good Luck Buddy!!


Regards,

Luis Morales 

On Tue, 2006-02-21 at 23:06 -0500, Jeff Broomall wrote: 
> I thank those who promptly responded to my first inquiry on the list.
> 
> This second request is, I assume, a tad more challanging.
> 
> I need a "Generate Report" function that'll allow the user to select one or 
> more "groups" and what columns he would like to view.
> 
> For instance,
> 
> Generate Report
> 
> 
> 
> 
> 
> Select Group(s)
> Select Columns
> 
> 
> Category One
> Category Two
> 
> 
> 
> 
> Group A
> Group B
> Group C
> Group D
> 
> 
> 
> Column 
> A
> Column 
> B
> Column 
> C
> Column 
> D
> Column 
> E
> Column 
> F
> 
> 
> Column 
> G
> Column 
> H
> Column 
> I
> Column 
> J
> Column 
> K
> Column 
> L
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Let's say the user wants to view Group A and Group B AND view content from 
> the Coulmn A, Column B, Column D, and Column K.
> 
> So a checkmark would be placed within each box and the "Generate Report" 
> button would be "hit" to generate a report with titles situated 
> horizontally.
> 
> I'm assuming I'll need to create an array for both "sel_group" and 
> "sel_cols" and then, I believe it's "implode" them into string values??? Am 
> I thinking correctly???
> 
> I know this query won't work...but this is the direction I'm headed...
> 
> $query = "SELECT $sel_cols FROM tasks WHERE groups_id=$sel_groups";
> 
> IOW, the columns from the sel_cols array would go there, and the group 
> or groups would go after the WHERE statement.
> 
> Then I guess I would have to figure out the code for the echo.
> 
> Am I at least in the ballpark???
> 
> Thank you and good night.
> 
> Jeff
> 
-- 
-
Luis Morales 
Consultor de Tecnologia
Cel: +(58)416-4242091
-
"Empieza por hacer lo necesario, luego lo que es posible... y de pronto
estarás haciendo lo imposible"
-

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Generate Report

[MIGUEL ANTONIO GUIRAO AGUILAR]

It seems that you need to get your nose into your books!!
More about SQL statements!!

> I'm assuming I'll need to create an array for both "sel_group" and 
> "sel_cols" and then, I believe it's "implode" them into string 
> values??? Am 
> I thinking correctly???
NO, YOU ONLY NEED TO WALK THRU YOUR ARRAYS TO GET THE DATA.

> 
> I know this query won't work...but this is the direction I'm headed...
> 
> $query = "SELECT $sel_cols FROM tasks WHERE groups_id=$sel_groups";
NO, IT WON'T WORK!
YOU NEED FIRST TO KNOW WHAT COLUMNS HAVE BEEN SELECTED, I RECOMMEND TO GIVE 
YOUR CHECHBOXES THE VALUE OF THE COLUMN NAMES IN THE TABLE
select "your columns $sel_cols" from tasks were group_id IN ($group_id1, 
$group_id2...) 

> 
>IOW, the columns from the sel_cols array would go there, and 
> the group 
> or groups would go after the WHERE statement.
> 
> Then I guess I would have to figure out the code for the echo.
> 
> Am I at least in the ballpark???
> 
> Thank you and good night.
> 
> Jeff
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 

Este mensaje es exclusivamente para el uso de la persona o entidad a quien esta 
dirigido; contiene informacion estrictamente confidencial y legalmente 
protegida, cuya divulgacion es sancionada por la ley. Si el lector de este 
mensaje no es a quien esta dirigido, ni se trata del empleado o agente 
responsable de esta informacion, se le notifica por medio del presente, que su 
reproduccion y distribucion, esta estrictamente prohibida. Si Usted recibio 
este comunicado por error, favor de notificarlo inmediatamente al remitente y 
destruir el mensaje. Todas las opiniones contenidas en este mail son propias 
del autor del mensaje y no necesariamente coinciden con las de Radiomovil 
Dipsa, S.A. de C.V. o alguna de sus empresas controladas, controladoras, 
afiliadas y subsidiarias. Este mensaje intencionalmente no contiene acentos.

This message is for the sole use of the person or entity to whom it is being 
sent.  Therefore, it contains strictly confidential and legally protected 
material whose disclosure is subject to penalty by law.  If the person reading 
this message is not the one to whom it is being sent and/or is not an employee 
or the responsible agent for this information, this person is herein notified 
that any unauthorized dissemination, distribution or copying of the materials 
included in this facsimile is strictly prohibited.  If you received this 
document by mistake please notify  immediately to the subscriber and destroy 
the message. Any opinions contained in this e-mail are those of the author of 
the message and do not necessarily coincide with those of Radiomovil Dipsa, 
S.A. de C.V. or any of its control, controlled, affiliates and subsidiaries 
companies. No part of this message or attachments may be used or reproduced in 
any manner whatsoever.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php