Thread: [Phpsqliteadmin-devel] SF.net SVN: phpsqliteadmin: [45] trunk/phpsqliteadmin2

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Revision: 45
          http://phpsqliteadmin.svn.sourceforge.net/phpsqliteadmin/?rev=45&view=rev
Author:   slythfox
Date:     2008-07-13 10:12:41 -0700 (Sun, 13 Jul 2008)

Log Message:
-----------


Modified Paths:
--------------
    trunk/phpsqliteadmin2/javascript.txt

Added Paths:
-----------
    trunk/phpsqliteadmin2/export.php
    trunk/phpsqliteadmin2/row_edit.php

Added: trunk/phpsqliteadmin2/export.php
===================================================================

--- trunk/phpsqliteadmin2/export.php	                        (rev 0)
+++ trunk/phpsqliteadmin2/export.php	2008-07-13 17:12:41 UTC (rev 45)
@@ -0,0 +1,75 @@
+<?php
+
+require_once('include.php');
+
+?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml">
+<head>
+	<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15" />
+	<link href="phpsla.css" rel="stylesheet" type="text/css" />
+	<title>phpSQLiteAdmin</title>
+	<meta http-equiv="expires" content="0" />
+	<meta http-equiv="pragma" content="no-cache" />
+	<meta http-equiv="cache-control" content="no-cache" />
+	<script language="Javascript" src="javascript.txt" type="text/javascript"></script>
+</head>
+<body class="right">
+<?php
+
+print_top_links($_GET['object']);
+
+//$sth = sqlite_query($link,"select * from '{$table->name}' limit 30");
+//$sth = sqlite_query($link,"select * from '{$table->name}'");
+
+print "<h3>Export Table '".$_GET['object']."'</h3>\n";
+
+// Get table schema
+$table_schema = "";
+$userdbh->query('select sql from sqlite_master');
+while($row = $userdbh->fetchArray()) {
+	if (strpos($row[0], "table " .$_GET['object'])) {
+		$table_schema = "/*\nTable structure for table '" .$_GET['object']. "'\n*/\n";
+		$table_schema .= $row[0]. ";\n\n";
+	}
+}
+
+// Get columns
+$userdbh->query('select * from '.$_GET['object']);
+
+for ($i=0; $i<$userdbh->numFields(); $i++) {
+    $column[$i] = $userdbh->fieldName($i);
+}
+$columns = implode(", ", $column);
+
+// Get row values
+while($row = $userdbh->fetchArray()) {
+	$nr_fields = count($row);
+	/*
+	for ($i=0; $i<$nr_fields; $i++) {
+		//$value = htmlentities($row[$i],ENT_QUOTES,$encoding);
+		$value[$i] = $row[$i];
+	}
+	print_r($value);
+	*/
+	$values = implode("', '", $row);
+	$values = "'" .$values. "'";
+	$queries .= "INSERT INTO " .$_GET['object']. " (" .$columns. ") VALUES
+(" .$values. ");\n";
+}
+
+$queries = "/*\nSQL data dump for table '" .$_GET['object']. "'\n*/\n" .$queries;
+
+// Generation information
+$generated_by = "/*\nphpSQLiteAdmin SQL Export
+-- Generated On " .date("D, j M Y H:i:s T"). "
+-- SQLite Version " .$sqliteversion. "
+-- PHP Version " .$sqliteversion. "\n*/\n\n";
+// Show export
+print "<textarea name=\"sql\" rows=\"16\" cols=\"80\">" .$generated_by. "" .$table_schema. "" .$queries. "</textarea>";
+
+print "</body>\n";
+print "</html>\n";
+
+
+?>

Modified: trunk/phpsqliteadmin2/javascript.txt
===================================================================
--- trunk/phpsqliteadmin2/javascript.txt	2008-07-13 10:03:11 UTC (rev 44)
+++ trunk/phpsqliteadmin2/javascript.txt	2008-07-13 17:12:41 UTC (rev 45)
@@ -17,6 +17,14 @@
 	}
 }
 
+function confirm_delete_row() {
+	Check = confirm("Delete this row ?");
+	if (Check == true) {
+		return true;
+	} else {
+		return false;
+	}
+}
 
 function confirm_drop_index() {
 	Check = confirm("Drop this index ?");

Added: trunk/phpsqliteadmin2/row_edit.php
===================================================================
--- trunk/phpsqliteadmin2/row_edit.php	                        (rev 0)
+++ trunk/phpsqliteadmin2/row_edit.php	2008-07-13 17:12:41 UTC (rev 45)
@@ -0,0 +1,182 @@
+<?php
+
+require_once('include.php');
+
+// Query (form submitted) portion
+if ($_POST['type'] == "edit") {
+
+	if (!$_GET['primary_key']) {
+		print "Table needs a primary key identifier.";
+		exit();
+	}
+
+	//print "<h3>Edit Row</h3>";
+
+	foreach (array_keys($_POST) as $column) {
+		// Only do columns, not $_POST['type'] and so on...
+		if (strstr($column, "column__") !== false) {
+			$columns .= ", " .str_replace("column__", "", $column). " = '" .$_POST[$column]. "'";
+		}
+		//echo $column. "<br>";
+
+	}
+	// Clean up columns:
+	$columns = "randomkeytoberemoved" .$columns;
+	$columns = str_replace("randomkeytoberemoved, ", "", $columns);
+	//print $columns;
+	
+	$userdbh->query("UPDATE " .$_POST['object']. " SET " .$columns. " WHERE " .$_POST['primary_key']. " = '" .$_POST['row']. "'");
+	$_SESSION['phpSQLiteAdmin_currentdb'] = '';
+	header("Location: table_browse.php?object=" .$_POST['object']. "");
+	exit();
+
+} else if ($_POST['type'] == "add") {
+
+	//print "<h3>Add Row</h3>";
+
+	foreach (array_keys($_POST) as $column) {
+		// Only do columns, not $_POST['type'] and so on...
+		if (strstr($column, "column__") !== false) {
+			$columns .= str_replace("column__", "", $column). ", ";
+			$values .= "'" .$_POST[$column]. "', ";
+		}
+		//echo $column. "<br>";
+
+	}
+	// Clean up columns/values:
+	$columns = $columns. "randomkeytoberemoved";
+	$columns = str_replace(", randomkeytoberemoved", "", $columns);
+	$values = $values. "randomkeytoberemoved";
+	$values = str_replace(", randomkeytoberemoved", "", $values);
+	//print $columns. "<br>";
+	//print $values;
+	
+	$userdbh->query("INSERT INTO " .$_POST['object']. "(" .$columns. ") VALUES(" .$values. ")");
+	header("Location: table_browse.php?object=" .$_POST['object']. "");
+	exit();
+
+}
+if ($_GET['type'] == "delete") {
+	if (!$_GET['primary_key']) {
+		print "Table needs a primary key identifier.";
+		exit();
+	}
+
+	$userdbh->query("delete from ".$_GET['object']. " where " .$_GET['primary_key']. " = '" .$_GET['row']. "'");
+	header("Location: table_browse.php?object=" .$_GET['object']. "");
+	exit();
+}
+
+?>
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN">
+<html>
+<head>
+	<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
+	<title>phpSQLiteAdmin</title>
+	<meta http-equiv="expires" content="0">
+	<script language="Javascript" src="javascript.txt" type="text/javascript"></script>
+	<link href="phpsla.css" rel="stylesheet" type="text/css">
+</head>
+<body class="right">
+<?php
+
+print_top_links($_GET['object']);
+
+// Show main content: add or edit a row form.
+if (!$_GET['row']) {
+	$type = "add";
+} else {
+	$type = "edit";
+}
+
+if (!$_GET['object']) {
+	print "Error: No table selected.";
+}
+
+if ($type == "edit") {
+	print "<h3>Edit Row from Table '{$_GET['object']}'</h3>\n";
+} else {
+	print "<h3>Add Row to Table '{$_GET['object']}'</h3>\n";
+}
+
+print "<form action=\"row_edit.php\" method=\"post\">";
+print "<table border=\"1\">\n";
+print "<tr><th>Column</th><th>Type</th><th>Value</th></tr>\n";
+$userdbh->_setTableInfo($_GET['object']);
+$cols = $userdbh->getColsType();
+$k = 0;
+while (list($key,$value) = each($cols)) {
+	$col_name[$k] = $key;
+	$col_value[$k] = strtolower($value);
+	
+	// Clean up col_value to only display databtype.
+	if ($col_value[$k] == "") { $col_value[$k] = "typeless"; }
+	//if (strpos(strtolower(" " .$col_value[$k]. " "), "text")) { $col_value[$k] = "text"; }
+	$col_value[$k] = str_replace("not null", "", $col_value[$k]);
+	$col_value[$k] = str_replace("null", "", $col_value[$k]);
+	$col_value[$k] = str_replace("primary key", "", $col_value[$k]);
+	$col_value[$k] = str_replace("default", "", $col_value[$k]);
+	$col_value[$k] = preg_replace("/\'[^>]*\'/iU", "", $col_value[$k]);
+	$col_value[$k] = preg_replace("/\"[^>]*\"/iU", "", $col_value[$k]);
+	
+	$k++;
+}
+
+if ($type == "edit") {
+	$userdbh->query("select * from ".$_GET['object']. " where " .$_GET['primary_key']. " = '" .$_GET['row']. "'");
+	//$userdbh->query('select * from '.$_GET['object']);
+	while($row = $userdbh->fetchArray()) {
+		$nr_fields = count($row);
+		for ($i=0; $i<$nr_fields; $i++) {
+		print "<tr>\n";
+		print "<td>" .$col_name[$i]. "</td>\n";
+		print "<td>" .$col_value[$i]. "</td>\n";
+		if (strpos(" " .$col_value[$i]. " ", "text")) {
+			print "<td><textarea name=\"column__" .$col_name[$i]. "\">" .$row[$i]. "</textarea></td>\n";
+		} else {
+			print "<td><input type=\"text\" name=\"column__" .$col_name[$i]. "\" value=\"" .$row[$i]. "\" /></td>\n";
+		}
+		print "</tr>\n";
+		}
+	}
+} else {
+	$nr_fields = count($col_name);
+	for ($i=0; $i<$nr_fields; $i++) {
+		print "<tr>\n";
+		print "<td>" .$col_name[$i]. "</td>\n";
+		print "<td>" .$col_value[$i]. "</td>\n";
+		if (strpos(" " .$col_value[$i]. " ", "text")) {
+			print "<td><textarea name=\"column__" .$col_name[$i]. "\"></textarea></td>\n";
+		} else {
+			print "<td><input type=\"text\" name=\"column__" .$col_name[$i]. "\" value=\"\" /></td>\n";
+		}
+		print "</tr>\n";
+	}
+}
+print "</table>\n";
+print "<input type=\"hidden\" name=\"row\" value=\"" .$_GET['row']. "\" />\n";
+print "<input type=\"hidden\" name=\"primary_key\" value=\"" .$_GET['primary_key']. "\" />\n";
+print "<input type=\"hidden\" name=\"object\" value=\"" .$_GET['object']. "\" />\n";
+print "<input type=\"hidden\" name=\"type\" value=\"" .$type. "\" />\n";
+print "<input type=\"submit\" name=\"\" value=\"Save\" />\n";
+print "<input type=button value=\"Cancel\" onclick=\"history.back();\">";
+print "</form>";
+
+/*
+print "<table border=1>\n";
+print "<tr><th>Column</th><th>Type</th></tr>\n";
+$userdbh->_setTableInfo($_GET['object']);
+$cols = $userdbh->getColsType();
+while (list($key,$value) = each($cols)) {
+	print "<tr><td>$key</td><td>$value</td></tr>\n";
+}
+print "</table>\n";
+
+print "<p>Rows in table: ".$userdbh->numRows($_GET['object'])."</p>\n";
+*/
+
+print "</body>\n";
+print "</html>\n";
+
+
+?>


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.




Thread: [Phpsqliteadmin-devel] SF.net SVN: phpsqliteadmin: [45] trunk/phpsqliteadmin2

phpsqliteadmin-devel