links

[jolee]

hello.

i have a sybase table that stores server info (servername, status, server type, uptime... etc). say i send a sql query that retrieves all the servernames and displays it as a list on a php webpage. is there way to make it so that the user can click on a servername and a query is sent back to retrieve the entire row of info for this specific servername and display it?

thanks a lot.

[tekky]

Obviously this isnt EXACTLY what you want, but it will give you an amazing head start 😉

note you will need to add the connect statments as this is an include to another db connect file already

.....
$result = mysql_list_tables($dbn);
if (!$result)
{
	echo "DB Error, could not list tables\n";
	echo 'MySQL Error: ' . mysql_error();
	exit;
}
while ($row = mysql_fetch_row($result))
{
	if ($row[0] == "permissions") { continue; }
	if (($table) && ($table != $row[0])) { continue; }
	if ($table)
	{
		echo "<form name=row[0] method=post action=update.php>\n<table width=256 border=1 cellspacing=1 cellpadding=1>\n";
		echo "<tr><td colspan=3>Table: $row[0]</td></tr>\n";
		$res = mysql_query("SELECT * from $row[0]");
		$cols = mysql_fetch_array($res, MYSQL_ASSOC);
		while(list($name, $value) = $cols)
		{
			echo "<tr><td>$name</td>\n<td>";
			echo "<input name=$name type=text size=25 value=\"$value\">\n";
			echo "</td></tr>\n";
		}
		echo "</td></tr><input type=hidden name=table value=$row[0]>\n";
		echo "<tr><td colspan=2><input type=submit name=action value=insert>&nbsp<input type=submit name=action value=$ed>&nbsp<input type=submit name=action value=delete>&nbsp<input type=submit name=action value=clear>&nbsp<input type=submit name=action value=back></td>\n";
		echo "</form>\n</table><br>\n";
	}
	else
	{	
		if (!$j)
		{
			echo "<form name=list method=post action=update.php>\n<table width=256 border=1 cellspacing=1 cellpadding=1>\n<tr><td>Select table to view</td></tr>";
		}
		echo "<tr><td><input type=submit name=table value=$row[0]></td></tr>";
	}
	$j=1;
}
if (!$table) { echo "<tr><td><input type=submit name=logout value=logout></td></tr></table></form>"; }
mysql_free_result($result);
?>

basically what this does, is list the tables in a database (ignoring permissions for obvious reasons) and make form submit buttons out of them, then you click on one, and and will list ALL the fields in that table in a table/form layout with text boxes for inputs to them, I'm sure you can see how this is sort of what you want...

hopefully I didnt make any stupid mistakes when I was removing all the uneeded junk I have need of in there 😉
btw, this should also set the text boxes default values to the values from the database

[jolee]

hi. thanks for the reply. 🙂

i am having trouble with your code tho.

i created an empty page and called it update.php

the page with the code u gave me displays all the tables in my database but when i click on any table, it goes to update.php which is still blank. nothing is posted. any suggestions? is update.php missing code?

[tekky]

maybe i missed something when I took out the useless code for your example (I did this REALLY late in the morning at work) heaing to the vet with my cat now, will double check it again when I return,

my bad :/

[tekky]

ahh, I See, I forgot to parse the $_POST var

$table = $_POST["table"];

should get your next screen to show right

of course to get the full function you really need to do a loop through $_POST and do

$$key = $val;

so that my script handles it right later on.

[tekky]

Oke found the mistake

including the above mistake I jacked up the list() loop

shoulda been while(list($key,$val) = each($cols))

the attached file works great 😉

obviously the input buttons wont work since I didnt include the meat of the script that handled the actions

[jolee]

thanks a lot buddy!! i got everything to work the way i wanted it to. i wouldnt have thought of making each item a submit button if it wasnt for u! here is what my code looks like now if ur interested!

	if ($row[1] = 'Up')  { 
	echo "<td><INPUT TYPE=\"submit\" NAME=\"server\"  VALUE=". $row[0] ." style=\" font-size:9pt; color:#008000; background-color:#ffffff; overflow:hidden; border-width:0px; height:17px; width:200px; vertical-align:middle; text-align:left; cursor:pointer; cursor:hand\"></td>"; 
	}
	elseif ($row[1] = 'Off') { 
	echo "<td><INPUT TYPE=\"submit\" NAME=\"server\"  VALUE=". $row[0] ." style=\" font-size:9pt; color:#ffff00; background-color:#ffffff; overflow:hidden; border-width:0px; height:17px; width:200px; vertical-align:middle; text-align:left; cursor:pointer; cursor:hand\"></td>"; 
 	}	
	elseif ($row[1] = 'Down') { 
	echo "<td><INPUT TYPE=\"submit\" NAME=\"server\"  VALUE=". $row[0] ." style=\" font-size:9pt; color:#ff0000; background-color:#ffffff; overflow:hidden; border-width:0px; height:17px; width:200px; vertical-align:middle; text-align:left; cursor:pointer; cursor:hand\"></td>"; 	    

thanks again!

[tekky]

hey, glad my
over achieving ideas for a tiny chat network can help someone besides me :p

let me know how things go 🙂