User Customisable Select Statment--Check boxes

moonman89

Hey forum.
This is going to take a while, but i think i can explain it. And if you know of any other forums that this might be more applicable in please say so...
I want to be able to have a first page that will list all the Fields in a database and put a check box next to them so the user can select weather or not they want to view them.
I have the code to do that :

Code:

<?PHP
// Main Index.
include("config.inc");				// Include Config
include("db_connect.inc");		// Connect to the DB

$sql_query = pg_exec($db_conn,"SELECT * FROM $view_table");
$field_count = pg_numfields($sql_query);
$rows = pg_numrows($sql_query);

echo "<html>";
echo "<form name='input' action='viewdata.php' method='get'>";
// traverse rows
for ($i=0; $i < 1; $i++) {
	// For each row, print the name!
  for ($j=0; $j < $field_count; $j++) {
    $field = pg_fieldname($sql_query,$j);
    echo "View $field" ;
		echo "<input type='checkbox' name='$field' checked='checked'>";
		echo "<br>" ;
  }
}

echo "<input type='submit' value='Submit'>";
echo "</form>";
echo "</html>";

pg_Close($db_conn);
?>

nd that works fine. But how can:
1) check what boxes are selected..
2) customise the Select statment depending on what ones are selected (with $sql_query .= WHATEVER??)
3) Print only enough rows in the table to actually display it right?

I have this for the php file that will display the table so far...HELP???

Code:

<?php
// Views the Selected columns from before
include("config.inc");				// Include Config
include("db_connect.inc");		// Connect to the DB

//-----------VARIABLES BELOW HERE-----------------------//

$sql_query = pg_exec($db_conn, "SELECT * FROM php");
$num_rows = pg_NumRows($sql_query);

//--------------END VARIABLES----------------------------//


// echo the Query.

$html .= "<table width=100 border=1>" ;
$html .= "<center><table cellpadding=6 cellspacing=0 border='2'>\n";
$html .= "</tr>\n";

$row=pg_Fetch_Row($sql_query);

for ($i=0; $i < $row; $i++){
		$html .= "<tr><td bgcolor=#111111><font color=ff3311 face=Verdana size=2>%s</td>\n",
		$row[$i]);
}
$html .= "</tr>\n";
$html .= "</table></center>\n"

echo $html

pg_Close($db_conn);
?>

I really dont think that is right. I dont know much about Loops etc...
Help please..
Cheers,
Nathan

bogu

First of all:

moonman89 wrote:
1) check what boxes are selected..

u should create an array of checkboxes and the key of each element should be your $field (or id ...)

echo "<input type='checkbox' name='check[$field]' checked='checked'>";

This will return on POST value an array like this:

$_POST['check'] = array(
    'field1'='',
    'field2'='',
    ...
    'fieldn'=''
);

and is your answer to the second question ...

moonman89 wrote:
3) Print only enough rows in the table to actually display it right?

U can limit your select, look for LIMIT statement in SELECT syntax from mysql manual ...

moonman89 wrote:
I have this for the php file that will display the table so far...HELP???

I dont work with postgresql but I can show u how I do in mysql
Tip ...

//create your query
$sql = "SELECT .....";
//send the query to mysql server
$rez = mysql_query($sql);
//grab result in an array
while($sc = mysql_fetch_assoc($rez)) {
//parse the results ....
}

Anyway u could look for the associated function for postgresql ...
Your last code is messed up:

$html .= "<center><table cellpadding=6 cellspacing=0 border='2'>\n";
//$html .= "</tr>\n"; /* u close the <tr> tag but u should open an his place is not here u want to open it into the loop soo u need to deleted  */

$row=pg_Fetch_Row($sql_query);

for ($i=0; $i < $row; $i++){
		/* u need to close your rows in the loop and u delete the sprintf funtion from the begining */
		$html .= sprintf("<tr><td bgcolor=#111111><font color=ff3311 face=Verdana size=2>%s</td></tr>\n", $row[$i]);
}
//$html .= "</tr>\n"; /* this is not need it because you create your html rows into the loop, u need to delete this line */
$html .= "</table></center>\n"

echo $html

BTW, who wrote this script u or one of your friends and u try to modify it?

moonman89

It was originaly writtin in my high school days. I have figured it out now though 🙂 A totally different and neater way of doing things. Lol, my high school days 😛 That sounds like a long time ago, its only a year. im only 16 :p
This is how i did it.
And i rote the whole thing myslef now 🙂
as you can tell. I know a bit more now

http://phpbuilder.com/board/showthread.php?t=10323987

Cheers,
Nathan