View difference between Paste ID: 7HY8tAa5 and sQXg5Qwp
SHOW: | | - or go back to the newest paste.
1
<?php
2
// Include the required files
3
include('dbConfig.php');
4
5
if (isset($_POST['edit']))
6
{
7
	$id = $_POST['edit'];
8
	$image1 = $_POST['image'];
9
	$url1 = $_POST['url'];
10
11
	
12
	mysql_query("UPDATE advertisements SET image = '" . $image1 . "' AND url = '" . $url1 . "' WHERE id = '" . $id . "' LIMIT 1");
13
	//echo("Updated! Your advertisement has been put in the queue for processing. Please allow 12-48 hours!");
14
}
15
16
?>
17
18
<!DOCTYPE html>
19
<html lang="en">
20
  <head>
21
    <meta charset="utf-8">
22
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
23
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
24
    <meta name="description" content="">
25
    <meta name="author" content="">
26
    <link rel="shortcut icon" href="./docs-assets/ico/favicon.png">
27
28
    <title>Advertisement management panel</title>
29
30
    <!-- Bootstrap core CSS -->
31
    <link href="./dist/css/bootstrap.css" rel="stylesheet">
32
33
    <!-- Custom styles for this template -->
34
    <link href="./dist/sticky-footer-navbar.css" rel="stylesheet">
35
36
    <!-- Just for debugging purposes. Don't actually copy this line! -->
37
    <!--[if lt IE 9]><script src="./docs-assets/js/ie8-responsive-file-warning.js"></script><![endif]-->
38
39
    <!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries -->
40
    <!--[if lt IE 9]>
41
      <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
42
      <script src="https://oss.maxcdn.com/libs/respond.js/1.3.0/respond.min.js"></script>
43
    <![endif]-->
44
  </head>
45
46
  <body>
47
48
    <!-- Wrap all page content here -->
49
    <div id="wrap">
50
51
      <!-- Fixed navbar -->
52
      <div class="navbar navbar-default navbar-fixed-top" role="navigation">
53
        <div class="container">
54
          <div class="navbar-header">
55
            <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
56
              <span class="sr-only">Toggle navigation</span>
57
              <span class="icon-bar"></span>
58
              <span class="icon-bar"></span>
59
              <span class="icon-bar"></span>
60
            </button>
61
            <a class="navbar-brand" href="#"><?php echo('Username'); ?></a>
62
          </div>
63
          <div class="collapse navbar-collapse">
64
            <ul class="nav navbar-nav">
65
              <li class="active"><a href="main.php">Home</a></li>
66
              <li><a href="contact.php">Contact</a></li>
67
              <li class="dropdown">
68
                <a href="#" class="dropdown-toggle" data-toggle="dropdown">Management <b class="caret"></b></a>
69
                <ul class="dropdown-menu">
70
                  <li><a href="edit.php">Edit slots</a></li>
71
                  <li><a href="buy.php">Purchase slots</a></li>
72
                  <li><a href="rules.html">Rules</a></li>
73
                  <li class="divider"></li>
74
                  <li class="dropdown-header">Account</li>
75
                  <li><a href="acc-d.php">Details</a></li>
76
                  <li><a href="acc-s.php">Settings</a></li>
77
                </ul>
78
              </li>
79
            </ul>
80
          </div><!--/.nav-collapse -->
81
        </div>
82
      </div>
83
84
      <!-- Begin page content -->
85
      <div class="container">
86
        <div class="page-header">
87
          <h1>Manage advertisements</h1>
88
        </div>
89
        <p class="lead">
90
		You have <b>2</b> advertisement slots.<br /><br />
91
		
92
		<!-- Edit advertisement(s) -->
93
		<table class="table table-striped table-bordered table-condensed">
94
    <thead>
95
        <tr>
96
            <th>ID</th>
97
            <th>Advertisement image URL</th>
98
            <th>Advertisement URL</th>
99
			<th>Section</th>
100
            <th>Enabled</th>
101
			<th>Save</th>
102
        </tr>
103
    </thead>
104
    <tbody>
105
        <tr>
106
		
107
		<?php
108
		$getItems = mysql_query("SELECT * FROM ads WHERE owner = 'Usern' ORDER BY id ASC");
109
110
		while ($item = mysql_fetch_assoc($getItems))
111
		{
112
		echo'
113
		<form method="post">
114
		<input type="hidden" name="edit" value="' . $item['id'] . '">
115
	
116
            <td>' . $item['id'] . '</td>
117
            <td><input type="text" name="image" class="form-control" value="' . $item['image'] . '" placeholder="http://" required autofocus></td>
118
            <td><input type="text" name="url" class="form-control" value="' . $item['url'] . '" placeholder="http://website.com" required autofocus></td>
119
			<td>' . $item['section'] . '</td>
120
            <td><font color="green"><b>YES</b></font></td>
121
			<td><button class="btn btn-lg btn-primary btn-block" type="submit">Save</button></td>
122
        </form></tr>';
123
		}
124
		?>
125
    </tbody>
126
</table>
127
		
128
		</p>
129
      </div>
130
    </div>
131
132
    <div id="footer">
133
      <div class="container">
134-
        <p class="text-muted credit">Script coded by <a href="http://static.obbo.in/advert_manager">Obbo.IN</a> | Version 1.0</p>
134+
        <p class="text-muted credit"></p>
135
      </div>
136
    </div>
137
138
139
    <!-- Bootstrap core JavaScript
140
    ================================================== -->
141
    <!-- Placed at the end of the document so the pages load faster -->
142
    <script src="https://code.jquery.com/jquery-1.10.2.min.js"></script>
143
    <script src="./dist/js/bootstrap.min.js"></script>
144
  </body>
145
</html>