[Phpsqliteadmin-devel] phpsqliteadmin2 table_browse.php, 1.1.1.1, 1.2

[Slythfox <sly...@us...>]

Update of /cvsroot/phpsqliteadmin/phpsqliteadmin2
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29832/phpsqliteadmin2

Modified Files:
	table_browse.php 
Log Message:
Added edit/delete icons.

Index: table_browse.php
===================================================================
RCS file: /cvsroot/phpsqliteadmin/phpsqliteadmin2/table_browse.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- table_browse.php	24 Jul 2005 12:59:38 -0000	1.1.1.1
+++ table_browse.php	12 Jul 2008 23:36:00 -0000	1.2
@@ -25,12 +25,20 @@
 print "<h3>Table '".$_GET['object']."'</h3>\n";
 print "<table>\n";
 
+// Get table columns.
+$userdbh->_setTableInfo($_GET['object']);
+$cols = $userdbh->getColsType();
+
 $userdbh->query('select * from '.$_GET['object']);
 
-print "<tr>\n";
+print "<tr>\n<th></th>\n<th></th>\n";
 
 for ($i=0; $i<$userdbh->numFields(); $i++) {
     print "<th>" . $userdbh->fieldName($i)  . "</th>\n";
+   	if (strpos(strtolower($cols[$userdbh->fieldName($i)]), "primary")) {
+		$primary_key = $userdbh->fieldName($i); // The field name of the primary key.
+		$primary_key_order = $i; // The "order" of the primary key (to be used to fetch the field's value for a given row).
+	}
 }
 
 print "</tr>\n";
@@ -40,6 +48,8 @@
 	//$rows = $userdbh->returnRows('num');
 	//$table->print_header();
 	print "<tr>\n";
+	print "<td><a href=\"row_edit.php?object=" .$_GET['object']. "&primary_key=" .$primary_key. "&row=" .$row[$primary_key_order]. "\"><img src=\"images/edit.png\" alt=\"Edit\" title=\"Edit\" /></a></td>
+<td><a href=\"row_edit.php?object=" .$_GET['object']. "&primary_key=" .$primary_key. "&row=" .$row[$primary_key_order]. "&type=delete\" onclick=\"return confirm_delete_row();\"><img src=\"images/delete.png\" alt=\"Delete\" title=\"Delete\" /></a></td>\n";
 	for ($i=0; $i<$nr_fields; $i++) {
 		if (strlen($row[$i]) > 50) {
 			print '<td>'.substr(htmlentities($row[$i],ENT_QUOTES,$encoding),0,50)."...</td>\n";
@@ -56,4 +66,4 @@
 print "</html>\n";
 
 
-?>
\ No newline at end of file
+?>