From 763134d4eaabd357b7c908a5b5e8f3c3283651c6 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Tue, 23 Jan 2018 09:33:52 +0100 Subject: web-scripts/statistics.php, web-scripts/packages.php new in git --- web-scripts/packages.php | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 web-scripts/packages.php (limited to 'web-scripts/packages.php') diff --git a/web-scripts/packages.php b/web-scripts/packages.php new file mode 100644 index 0000000..5f04979 --- /dev/null +++ b/web-scripts/packages.php @@ -0,0 +1,20 @@ +connect_error) { + die("Connection failed: " . $mysql->connect_error); +} + +$result = $mysql -> query("SELECT * FROM buildmaster.binary_packages"); +if ($result -> num_rows > 0) { + while($row = $result->fetch_assoc()) { + foreach ($row as $key => $val) { + print $key .": ".$val." - "; + } + print "
\n"; + } +} + +print 'OK'; + +?> -- cgit v1.2.3-70-g09d2 From 25c3af1f1af84f79a44155078c1cbc1705c723b2 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Tue, 23 Jan 2018 09:37:31 +0100 Subject: web-scripts/packages.php: use same user as other scripts --- web-scripts/packages.php | 24 ++++++++++++------------ 1 file changed, 12 insertions(+), 12 deletions(-) (limited to 'web-scripts/packages.php') diff --git a/web-scripts/packages.php b/web-scripts/packages.php index 5f04979..b8b5dda 100644 --- a/web-scripts/packages.php +++ b/web-scripts/packages.php @@ -1,20 +1,20 @@ connect_error) { - die("Connection failed: " . $mysql->connect_error); -} + $mysql = new mysqli("localhost", "http", "http"); + if ($mysql->connect_error) { + die("Connection to mysql database failed: " . $mysql->connect_error); + } -$result = $mysql -> query("SELECT * FROM buildmaster.binary_packages"); -if ($result -> num_rows > 0) { - while($row = $result->fetch_assoc()) { - foreach ($row as $key => $val) { - print $key .": ".$val." - "; + $result = $mysql -> query("SELECT * FROM buildmaster.binary_packages"); + if ($result -> num_rows > 0) { + while($row = $result->fetch_assoc()) { + foreach ($row as $key => $val) { + print $key .": ".$val." - "; + } + print "
\n"; } - print "
\n"; } -} -print 'OK'; + print 'OK'; ?> -- cgit v1.2.3-70-g09d2