From 6c7a859fcf9691023c418366a62ece2f19cf4c9f Mon Sep 17 00:00:00 2001 From: William Harrington Date: Mon, 12 Mar 2018 15:51:42 -0500 Subject: Initial commit for project. --- list.php | 237 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 237 insertions(+) create mode 100644 list.php (limited to 'list.php') diff --git a/list.php b/list.php new file mode 100644 index 0000000..1750a34 --- /dev/null +++ b/list.php @@ -0,0 +1,237 @@ + + + + + + + + + + + + +'; +//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 + + + // Begin Table + $html_table = ''; + + // Table Header + $html_table .= ''; + $html_table .= ''; + if($cn){$html_table .= '';} + if($bl){$html_table .= '';} + if($ns){$html_table .= '';} + if($se){$html_table .= '';} + if($no){$html_table .= '';} + if($ur){$html_table .= '';} + $html_table .= ''; + + // Table Footer + $html_table .= ''; + $html_table .= ''; + if($cn){$html_table .= '';} + if($bl){$html_table .= '';} + if($ns){$html_table .= '';} + if($se){$html_table .= '';} + if($no){$html_table .= '';} + if($ur){$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($cn) { + $rowcfg = nl2br(str_replace(' ', ' ', $row['configure'])); + } + if($bl) { + $rowbld = nl2br(str_replace(' ', ' ', $row['build'])); + } + if($ns) { + $rownst = nl2br(str_replace(' ', ' ', $row['install'])); + } + if($se) { + $rowset = nl2br(str_replace(' ', ' ', $row['setup'])); + } + if($no) { + $rownot = nl2br(str_replace(' ', ' ', $row['notes'])); + } + if($ur) { + $rowurl = nl2br(str_replace(' ', ' ', $row['url'])); + } + $html_table .= ''; + $html_table .= ""; + $html_table .= ''; + $html_table .= ''; + $html_table .= ''; + if($cn){$html_table .= '';} + if($bl){$html_table .= '';} + if($ns){$html_table .= '';} + if($se){$html_table .= '';} + if($no){$html_table .= '';} + if($ur){$html_table .= '';} + $html_table .= ""; + + $html_table .= ''; + } + + // End Table Body + $html_table .= ''; + + // End Table + $html_table .= '
A8-3800 CLFS Server
EDITSEQNAMEVERSIONCONFIGUREBUILDINSTALLSETUPNOTESURLDELETE
EDITSEQNAMEVERSIONCONFIGUREBUILDINSTALLSETUPNOTESURLDELETE
Edit'.$rowseq.''.($rownm).''.($rowver).''.($rowcfg).''.($rowbld).''.($rownst).''.($rowset).''.($rownot).''.($rowurl).'Delete
'; + + //Output Table + echo $html_table; + +} else { + // No Data received + echo '
No data found!
'; +} +?> + + +

+ Valid HTML 4.01 Transitional +

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