From 3b5a092df12e386624414f32962bfd500fbabcbb Mon Sep 17 00:00:00 2001 From: William Harrington Date: Tue, 12 Feb 2019 15:57:59 -0600 Subject: Add A8 server build layout --- A8_srv_build/add.php | 125 +++++++++++++++++++++ A8_srv_build/config.inc | 18 +++ A8_srv_build/delete.php | 52 +++++++++ A8_srv_build/delete.php.old | 77 +++++++++++++ A8_srv_build/edit.php | 114 +++++++++++++++++++ A8_srv_build/list.php | 253 +++++++++++++++++++++++++++++++++++++++++++ A8_srv_build/openfile.php | 36 ++++++ A8_srv_build/sessionvars.php | 61 +++++++++++ A8_srv_build/test.php | 29 +++++ 9 files changed, 765 insertions(+) create mode 100644 A8_srv_build/add.php create mode 100644 A8_srv_build/config.inc create mode 100644 A8_srv_build/delete.php create mode 100644 A8_srv_build/delete.php.old create mode 100644 A8_srv_build/edit.php create mode 100644 A8_srv_build/list.php create mode 100644 A8_srv_build/openfile.php create mode 100644 A8_srv_build/sessionvars.php create mode 100644 A8_srv_build/test.php diff --git a/A8_srv_build/add.php b/A8_srv_build/add.php new file mode 100644 index 0000000..dcad257 --- /dev/null +++ b/A8_srv_build/add.php @@ -0,0 +1,125 @@ + + + + + + + + + +'; +//var_dump($_SESSION); +?> +
+Add Record +
+beginTransaction(); + $stmt = $pdo->prepare($sqlpkg); + $stmt->execute(['seq' => $seq, 'name' => $name, 'version' => $version]); + $pkgid = $pdo->lastInsertId(); + //echo "PKGID: '$pkgid' '$seq' '$name' '$version'"; + + $stmt = $pdo->prepare($sqlcfg); + $stmt->execute(['pkg_id' => $pkgid, 'configure' => $configure]); + $stmt = $pdo->prepare($sqlbld); + $stmt->execute(['pkg_id' => $pkgid, 'build' => $build]); + $stmt = $pdo->prepare($sqlnst); + $stmt->execute(['pkg_id' => $pkgid, 'install' => $install]); + $stmt = $pdo->prepare($sqlset); + $stmt->execute(['pkg_id' => $pkgid, 'setup' => $setup]); + $stmt = $pdo->prepare($sqlnot); + $stmt->execute(['pkg_id' => $pkgid, 'notes' => $notes]); + $stmt = $pdo->prepare($sqlurl); + $stmt->execute(['pkg_id' => $pkgid, 'url' => $url]); + + $pdo->commit(); + + } catch(Exception $e) { + $pdo->rollBack(); + throw $e; + } + + header("location:list.php#$seq"); + + } else { + echo '
';
+		echo 'Need at least the following attributes: Sequence, Name';
+		echo '
'; + } +} +?> +
+ +
+ +
+ +

+ +

+ +

+ +

+ +

+ +

+ +

+
+
+ +
+
+ + diff --git a/A8_srv_build/config.inc b/A8_srv_build/config.inc new file mode 100644 index 0000000..ffea00e --- /dev/null +++ b/A8_srv_build/config.inc @@ -0,0 +1,18 @@ + PDO::ERRMODE_EXCEPTION, + PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, + PDO::ATTR_EMULATE_PREPARES => false, + ]; +$pdo = new PDO($dsn, $user, $pass, $opt); + +?> diff --git a/A8_srv_build/delete.php b/A8_srv_build/delete.php new file mode 100644 index 0000000..cfa52a3 --- /dev/null +++ b/A8_srv_build/delete.php @@ -0,0 +1,52 @@ + + + + + + + +Delete ID + + +'; +//var_dump($_SESSION); +?> + +
+prepare($sql);
+		$stmt->execute(['id' => $did]);
+	} catch (PDOException $e) {
+		echo '
Have a big problem
';
+		throw $e;
+	}
+
+	}
+} else {
+	echo "No rows selected to delete!";
+}
+?>
+
+
+ +
+ + diff --git a/A8_srv_build/delete.php.old b/A8_srv_build/delete.php.old new file mode 100644 index 0000000..cb342aa --- /dev/null +++ b/A8_srv_build/delete.php.old @@ -0,0 +1,77 @@ + + + + + + + +Delete ID + + +'; +//var_dump($_SESSION); +?> +

+Delete Record +
+prepare($sql); + $stmt->execute(['id' => $id]); + } catch (PDOException $e) { + echo '
Have a big problem
'; + throw $e; + } + header("location:list.php"); + } + + $sql = 'SELECT id, seq, name, version, configure, build, install, setup, notes, url FROM PKG, PKG_CFG, PKG_BLD, PKG_NST, PKG_SET, PKG_NOT, PKG_URL WHERE PKG_CFG.pkg_id=PKG.id AND PKG_BLD.pkg_id=PKG.id AND PKG_NST.pkg_id=PKG.id AND PKG_SET.pkg_id = PKG.id AND PKG_NOT.pkg_id=PKG.id AND PKG_URL.pkg_id=id AND PKG.id=:id'; + try { + + $stmt = $pdo->prepare($sql); + $stmt->execute(['id' => $id]); + } catch (PDOException $e) { + echo '
Have a big problem
'; + throw $e; + } + + $row = $stmt->fetch(PDO::FETCH_ASSOC) +?> +
+ +
+ +
+ +

+

+

+

+

+

+

+
+
+ +
+
No ID given to delete!
'; +} +?> +
+ + diff --git a/A8_srv_build/edit.php b/A8_srv_build/edit.php new file mode 100644 index 0000000..c3fda52 --- /dev/null +++ b/A8_srv_build/edit.php @@ -0,0 +1,114 @@ + + + + + + + +Edit ID + + +'; +//var_dump($_SESSION); +?> +

+Update Record +
+prepare($sql); + $stmt->execute(['seq' => $seq, 'name' => $name, 'version' => $version, 'configure' => $configure, 'build' => $build, 'install' => $install, 'setup' => $setup, 'notes' => $notes, 'url' => $url, 'id' => $id]); + } catch (PDOException $e) { + echo '
Have a big problem
'; + throw $e; + } + header("location:list.php#$seq"); + exit(); + } + + + $sql = 'SELECT id, seq, name, version, configure, build, install, setup, notes, url FROM PKG, PKG_CFG, PKG_BLD, PKG_NST, PKG_SET, PKG_NOT, PKG_URL WHERE PKG_CFG.pkg_id=PKG.id AND PKG_BLD.pkg_id=PKG.id AND PKG_NST.pkg_id=PKG.id AND PKG_SET.pkg_id = PKG.id AND PKG_NOT.pkg_id=PKG.id AND PKG_URL.pkg_id=id AND PKG.id=:id'; + + try { + + $stmt = $pdo->prepare($sql); + $stmt->execute(['id' => $id]); + } catch (PDOException $e) { + echo '
Have a big problem
'; + throw $e; + } + + $row = $stmt->fetch(PDO::FETCH_ASSOC) +?> +
+ +
+ +
+ +

+ +

+ +

+ +

+ +

+ +

+ +

+
+
+ +
+
+ +
+No ID given to edit!'; +} +?> +
+ + + diff --git a/A8_srv_build/list.php b/A8_srv_build/list.php new file mode 100644 index 0000000..0bac433 --- /dev/null +++ b/A8_srv_build/list.php @@ -0,0 +1,253 @@ + + + + + + + + + + + + + +'; +//echo '$_SESSION' . var_dump($_SESSION) . '
'; +//echo '$_POST' . var_dump($_POST) . '
'; +?> + + Add Record

+
+ Select columns:
+ />Configure + />Build + />Install + />Setup + />Notes + />URL
+ +
+ +prepare($sql); + $stmt->execute(); +} catch (PDOException $e) { + echo '
Have a big problem
'; + throw $e; + echo "$e->getMessage()"; +} + +if ($stmt->rowCount() > 0) { + + // Data received + + echo '
'; + + // Begin Table + $html_table = ''; + + // Table Header + $html_table .= ''; + $html_table .= ''; + if($con){$html_table .= '';} + if($bul){$html_table .= '';} + if($nst){$html_table .= '';} + if($set){$html_table .= '';} + if($not){$html_table .= '';} + if($url){$html_table .= '';} + $html_table .= ''; + + // Table Footer + $html_table .= ''; + $html_table .= ''; + if($con){$html_table .= '';} + if($bul){$html_table .= '';} + if($nst){$html_table .= '';} + if($set){$html_table .= '';} + if($not){$html_table .= '';} + if($url){$html_table .= '';} + $html_table .= ''; + + // Table Body + $html_table .= ''; + + // Table Rows + while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { + $rowid = $row['id']; + $rowseq = $row['seq']; + $rownm = $row['name']; + $rowver = $row['version']; + if($con) { + $rowcfg = nl2br(str_replace(' ', ' ', $row['configure'])); + } + if($bul) { + $rowbld = nl2br(str_replace(' ', ' ', $row['build'])); + } + if($nst) { + $rownst = nl2br(str_replace(' ', ' ', $row['install'])); + } + if($set) { + $rowset = nl2br(str_replace(' ', ' ', $row['setup'])); + } + if($not) { + $rownot = nl2br(str_replace(' ', ' ', $row['notes'])); + } + if($url) { + $rowurl = nl2br(str_replace(' ', ' ', $row['url'])); + } + $html_table .= ''; + $html_table .= ""; + $html_table .= ''; + $html_table .= ''; + $html_table .= ''; + if($con){$html_table .= '';} + if($bul){$html_table .= '';} + if($nst){$html_table .= '';} + if($set){$html_table .= '';} + if($not){$html_table .= '';} + if($url){$html_table .= '';} + //$html_table .= ""; + $html_table .= ''; + $html_table .= ''; + } + + // End Table Body + $html_table .= ''; + + // End Table + $html_table .= '
A8-3800 CLFS Server
ACTIONSEQNAMEVERSIONCONFIGUREBUILDINSTALLSETUPNOTESURLDELETE
ACTIONSEQNAMEVERSIONCONFIGUREBUILDINSTALLSETUPNOTESURLDELETE
View'.$rowseq.''.($rownm).''.($rowver).''.($rowcfg).''.($rowbld).''.($rownst).''.($rowset).''.($rownot).''.($rowurl).'Delete
'; + + //Output Table + echo $html_table; + +} else { + // No Data received + echo '
No data found!
'; +} +?> + + Check All +
+ +

+ Valid HTML 4.01 Transitional +

+ + + + + diff --git a/A8_srv_build/openfile.php b/A8_srv_build/openfile.php new file mode 100644 index 0000000..3ad1c1f --- /dev/null +++ b/A8_srv_build/openfile.php @@ -0,0 +1,36 @@ + + + + + + + +File List + + +

+Installed File List for + + +
+Name found'; + $myfile = fopen("/sources/installed-files/$name", "r") + or die("Unable to open file!"); + echo ""; + fclose($myfile); +} else { + echo '
No NAME given to list installed files!
'; +} +?> +
+ + diff --git a/A8_srv_build/sessionvars.php b/A8_srv_build/sessionvars.php new file mode 100644 index 0000000..dca0bb0 --- /dev/null +++ b/A8_srv_build/sessionvars.php @@ -0,0 +1,61 @@ + + + + + + + + + + + + + diff --git a/A8_srv_build/test.php b/A8_srv_build/test.php new file mode 100644 index 0000000..a7fc5ff --- /dev/null +++ b/A8_srv_build/test.php @@ -0,0 +1,29 @@ + + + + + + + + + +Add Record


+prepare($sql); + $stmt->execute(); +echo 'test'; +?> + +

+Valid HTML 4.01 Transitional +

+ + + -- cgit v1.2.3-54-g00ecf