I'm sorry, but I'm still confused. Can you show us a sample of the data in the database and what you want the resulting form to look like for that data? Maybe that'll help.
---John Holmes... > -----Original Message----- > From: Floyd Baker [mailto:[EMAIL PROTECTED]] > Sent: Sunday, November 24, 2002 11:29 PM > To: Hugh Danaher > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] dynamic arraynames > > > Thank you for your efforts. The ideas are helping but sorry I am not > clear. Not used to expressing myself regarding the coding I do. > > What I am looking to do is this: > > >From a loop that is reading a list of titles, I want to input pieces > of information to each... The input fields will be in a column on a > form with the name of the array at the top. > > In a loop to n: > print "<INPUT TYPE='text' NAME='fred[]' SIZE='10' MAXLENGTH='10'> "; > > Fred works fine hard coded but i get n fred's... I need the > individual array names to be whatever comes from the list, column by > column. > > Maybe this is very simple but I am not seeing how it's done. > > Floyd > > > > > > On Sat, 23 Nov 2002 15:28:13 -0800, you wrote: > > >Floyd, > >if you are using mysql then you can use the mysql_list_fields to get the > >names of the mysql table's column (field) names, then do mysql_num_fields > to > >get the number of columns (fields), then fill the columns with whatever > >using a while loop. > >I've attached a php page that fetches this info from any size table then > >displays the table. You can extract the info you need and extend it with > >check boxes etc. > >Hope this helps. > >Hugh > > > > > ><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> > ><html> > ><head> > ><meta http-equiv="Content-Type" content="text/html; charset=utf-8"> > ><title>Input Data Page</title> > ><?php include ("css.txt"); ?> > ></head> > ><body bgcolor="#1D3E81" > > ><h1><font color="#ffff33">DATABASE TABLES</font></h1> > > > ><form action="<?php print $php_self?>" method="post"> > ><?php > > > >print "<table cellpadding=7 border=1 bgcolor=#d5d5d5><tr><td>"; > >print "<h6>Database name:</h6><input type=text name=db > >STYLE=width:140px></td><td>"; > >print "<h6>Username:</h6><input type=text name=user STYLE=width:140px>"; > >print "<h6>Password:</h6><input type=text name=pass STYLE=width:140px>"; > >print "</td><td valign=middle align=center><input type=submit value=\" go > >\">"; > >print "<input type=hidden name=start value=1>"; > >print "</td></tr></table></form><br>"; > >if ($start=="1") > > { > > $link=mysql_connect("localhost","$user","$pass"); > > if (! $link) die("couldn't connect mysql"); > > mysql_select_db($db,$link) or die ("couldn't open $db ".mysql_error()); > > $tables=mysql_list_tables($db,$link); > > $num=mysql_num_rows($tables)-1; > > mysql_close($link); > > ?> > > <form action="<?php print $php_self?>" method="post"> > > <?php > > print "<table cellpadding=7 border=1 bgcolor=#d5d5d5><tr><td>"; > > print "<h6>Table Name: </h6><select type=text name=table > >STYLE=width:140px><option>"; > > > > for ($i=0;$i<=$num;$i++) > > { > > print "<option>".mysql_tablename($tables,$i); > > } > > print "</select>"; > > > > print "</td><td><input type=submit value=\" go \">"; > > print "<input type=hidden name=start value=2>"; > > > > print "<input type=hidden name=db value=$db>"; > > print "<input type=hidden name=user value=$user>"; > > print "<input type=hidden name=pass value=$pass>"; > > print "</td></tr></table></form><br>"; > > } > > > >if ($start=="2") > > { > > $link=mysql_connect("localhost","$user","$pass"); > > if (! $link) die("couldn't connect mysql"); > > mysql_select_db($db,$link) or die ("couldn't open $db ".mysql_error()); > > > > $results=mysql_query("select * from $table"); > > $fields = mysql_list_fields("$db", "$table", $link); > > $columns = mysql_num_fields($fields); > > mysql_close($link); > > print "<table width=95% bgcolor=#d5d5d5 border=1 cellspacing=0 > >cellpadding=0><tr><td align=center><h3>$table</h3>"; > > print "<table width=100% bgcolor=#d5d5d5 border=1 cellspacing=0 > >cellpadding=4>"; > > print "<tr>"; > > for ($i = 0; $i < $columns; $i++) > > { > > print "<td align=center bgcolor=#6c6c6c><h5><font > >color=white>".mysql_field_name($fields, $i)."</font></h5></td>"; > > } > > print "</tr>"; > > print "<tr>"; > > for ($i = 0; $i < $columns; $i++) > > { > > print "<td align=center > bgcolor=#fbfbfb><h5>".mysql_field_type($results, > >$i)."</h5></td>"; > > } > > print "</tr>"; > > while ($a_row=mysql_fetch_row($results)) > > { > > print "<tr>"; > > foreach($a_row as $field) > > { > > if ($field=="") > > { > > $field=" "; > > } > > print "<td align=center><h5>".$field."</h5></td>"; > > } > > print "</tr>"; > > } > > print "</table></td></tr></table>"; > > } > >?> > ></body> > ></html> > > > > > > > >----- Original Message ----- > >From: "Floyd Baker" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Cc: <[EMAIL PROTECTED]> > >Sent: Saturday, November 23, 2002 2:07 PM > >Subject: Re: [PHP] dynamic arraynames > > > > > >> On Sat, 23 Nov 2002 10:58:02 -0500, you wrote: > >> > >> >> I am trying to generate arrays to hold inputs to columns. Column > >> >> titles are input to a table as needed. They are read by the program > >> >> and placed across the page. Then an array goes under each column > name > >> >> to collect the inputs to the various rows. Everything works except > to > >> >> dynamically change the name of the array. > >> >> > >> >> > >> >> while($foo=mysql_fetch_array($mysql_result)){ > >> >> print "<INPUT TYPE=text NAME=correspondingfoo[]>";} > >> > > >> >Do you want this?? > >> > > >> >print "<INPUT TYPE=text NAME=" . $foo['something'] . "[]>"; > >> > > >> >---John Holmes... > >> > >> > >> No John. I'm ok with simply inputting a value and otherwise using > >> arrays that are hard coded and previously named but my problem is in > >> creating different arrays on the fly to represent each column that > >> there is a name for. I want to end up with something like $meat[] and > >> $potatoes[] and whatever else is needed from a list... The list of > >> meat, potatoes, etc determines how many arrays and their names. > >> > >> I'm not to swift when it comes to arrays and think I'm probably stuck > >> on some simple misconception. I'm trying to convert $meat to $meat[], > >> on the fly, to have something to input to... I read today maybe I > >> don't need the brackets? > >> > >> Floyd > >> > >> > >> -- > >> > >> > >> -- > >> PHP General Mailing List (http://www.php.net/) > >> To unsubscribe, visit: http://www.php.net/unsub.php > >> > > -- > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
