Advanced-Service-Editor/loadableList.htm at master · ehwest/Advanced-Service-Editor · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
<?php

        $dbhostname = "localhost";
        $dblogin= "seqops1";
        $dbpassword= "seqops1";
        $dbname="seqops1";


        error_reporting(E_PARSE);

        if(!($dbLink = mysql_connect($dbhostname,$dblogin,$dbpassword)))
                {
                print("Failed to connect to db server.");
                exit();
                }
        if(!mysql_select_db($dbname,$dbLink))
                {
                print("Failed to select database.");
                exit();
                }

	$q1 = "SELECT * from jaml";
	$dbr1 = mysql_query($q1);
	print "<table>";
	while($row1=mysql_fetch_object($dbr1)){

		$q2 = "SELECT * from users where uix='" . $row1->modifiedby . "';";
		$dbr2 = mysql_query($q2);
		$row2 = mysql_fetch_object($dbr2);
		$username = $row2->name;
		//print_r($row1);
		print "<tr>";
		print "<td>" . $row1->description . " </td>";
		print "<td> " . date("n/j/Y H:i",$row1->modified) . "</td>";
		print "<td> " . $username . "</td>";
		$link = "providejaml.htm?jix=" . $row1->jix;
		print "<td> <button style = 'display:inline; margin-left:10px' onClick='loadFile(0," . '"' . $link  . '"' . ");'>Replace</button> </td>";
		print "<td> <button style = 'display:inline; margin-left:10px' onClick='loadFile(1," . '"' . $link  . '"' . ");'>Append</button> </td>";
		print "<td> <button style = 'display:inline; margin-left:10px' onClick='loadFile(2," . '"' . $link  . '"' . ");'>Source</button> </td>";
		print "</tr>";
	}
	print "</table>";
?>