login  Naam:   Wachtwoord: 
Registreer je!
 Scripts:
Scripts > Overige > AJAX > AJAX MySQL DBMS

AJAX MySQL DBMS

Auteur: barry - 17 maart 2006 - 13:32 - Gekeurd door: nemesiskoen - Hits: 4421 - Aantal punten: 3.40 (5 stemmen)




Geen installatie nodig...
Het bestand met een willekeurige bestandsnaam plaatsen op een webserver met php/mysql en het werkt.
Ook je Javascript moet aanstaan.
Het loginsysteem gebruikt (zoals je ziet) sessions.

Let wel dat alle SQL-instructies werken, dus ook DROP, ALTER, DELETE, kortom alle mogelijkheden die MySQL ondersteund, pas hier dus mee op!!

Het script is werkend getest in IE 6.0 en FireFox 1.0.7!

Code:
willekeurigebestandsnaam.php
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?
  3.  
  4. 	$nArray = explode('/', strrev($_SERVER['SCRIPT_NAME']));
  5. 	$fileName = strrev($nArray[0]);
  6. 	define ('definedFileName', $fileName);	
  7.  
  8. 	if ($_POST['sbmitMysqlLog']) {
  9. 		if (@mysql_connect($_POST['host'], $_POST['user'], $_POST['pass'])) {
  10. 			$_SESSION['host'] = $_POST['host'];
  11. 			$_SESSION['user'] = $_POST['user'];
  12. 			$_SESSION['pass'] = $_POST['pass'];
  13. 			$_SESSION['connected'] = mktime();
  14. 			header("location: ".definedFileName);
  15. 		}
  16. 		else {
  18. 			header("location: ".definedFileName."?err=notlogged");
  19. 		}
  20. 	}
  21.  
  22. 	if ($_GET['action'] == 'logout') {
  24. 		header("location: ".definedFileName."");
  25. 	}
  26.  
  27. 	if ($_GET['getStuff']) {
  28. 		mysql_connect($_SESSION['host'], $_SESSION['user'], $_SESSION['pass']) or die ('<b>Error!</b><br>No connection with mysql...');
  29. 		if (!mysql_select_db($_GET['db'])) {
  30. 			echo '<h2>Databases:</h2>';
  31. 			echo '	<table border=0 style="border: 1px #000000 solid; background-color: #E0DFE3; padding: 0px; margin: 2px;">';
  32. 			$r = mysql_query("SHOW DATABASES");
  33. 			while ($a = mysql_fetch_array($r, MYSQL_ASSOC)) {
  34. 				$c = ($c == '#CCC4E8') ? '#C4DDE8' : '#CCC4E8';
  35. 				$mouseDown  = "document.getElementById('db').value = '".$a['Database']."'; ";
  36. 				$mouseDown .= "document.getElementById('tbls').value = 'Show tables in ".$a['Database']."'; ";
  37. 				$mouseDown .= "document.getElementById('sql').value = 'SHOW TABLES'; ";
  38. 				$mouseDown .= "getList('getStuff', 'sql', 'db', 'output', '".definedFileName."', 'GET');";
  39. 				echo '<tr><td style="background-color: '.$c.'; cursor: pointer;" width=256 onMouseDown="'.$mouseDown.'">'.$a['Database'].'</td></tr>';
  40. 			}
  41.  
  42. 		}
  43. 		else {
  44. 			if (strtoupper($_GET['getStuff']) == 'SHOW DATABASES') {
  45. 				echo '<h2>Databases:</h2>';
  46. 				echo '	<table border=0 style="border: 1px #000000 solid; background-color: #E0DFE3; padding: 0px; margin: 2px;">';
  47. 				$r = mysql_query("SHOW DATABASES");
  48. 				while ($a = mysql_fetch_array($r, MYSQL_ASSOC)) {
  49. 					$c = ($c == '#CCC4E8') ? '#C4DDE8' : '#CCC4E8';
  50. 					$mouseDown  = "document.getElementById('db').value = '".$a['Database']."'; ";
  51. 					$mouseDown .= "document.getElementById('tbls').value = 'Show tables in ".$a['Database']."'; ";
  52. 					$mouseDown .= "document.getElementById('sql').value = 'SHOW TABLES'; ";
  53. 					$mouseDown .= "getList('getStuff', 'sql', 'db', 'output', '".definedFileName."', 'GET');";
  54. 					echo '<tr><td style="background-color: '.$c.'; cursor: pointer;" width=256 onMouseDown="'.$mouseDown.'">'.$a['Database'].'</td></tr>';
  55. 				}			
  56. 			}
  57.  
  58. 			elseif (strtoupper($_GET['getStuff']) == 'SHOW TABLES') {
  59. 				echo '<h2>Tables in '.$_GET['db'].':</h2>';
  60. 				echo '	<table border=0 style="border: 1px #000000 solid; background-color: #E0DFE3; padding: 0px; margin: 2px;">';
  61. 				$r = mysql_query("SHOW TABLES");
  62. 				echo '<td style="background-color: #9D936B; font-color: #FFFFFF;"><b>Tables_in_'.$_GET['db'].'</b>&nbsp;</td>';
  63. 				while ($a = mysql_fetch_array($r)) {
  64. 					$c = ($c == '#CCC4E8') ? '#C4DDE8' : '#CCC4E8';
  65. 					$mouseDown  = "document.getElementById('sql').value = 'SELECT * FROM `".$a[0]."`'; ";
  66. 					$mouseDown .= "getList('getStuff', 'sql', 'db', 'output', '".definedFileName."', 'GET');";
  67. 					echo '<tr><td style="background-color: '.$c.'; cursor: pointer;" width=256 onMouseDown="'.$mouseDown.'">'.$a[0].'</td></tr>';
  68. 				}			
  69. 			}
  70.  
  71. 			else {
  72. 				$r = mysql_query(str_replace("\'", "'", $_GET['getStuff'])) or die ('<b>Error in query</b><br><pre>'.wordwrap(mysql_error(), 60).'</pre>');
  73. 				if (mysql_num_rows($r) == 0) {
  74. 					echo '<b>Empty table...</b>';
  75. 				}
  76. 				else {
  77. 					$aOnce = mysql_fetch_array($r, MYSQL_ASSOC);
  78. 					echo '<h2>SQL Output:</h2>';
  79. 					echo '	<table border=0 style="border: 1px #000000 solid; background-color: #E0DFE3; padding: 0px; margin: 2px;">	<tr>';
  80. 					foreach ($aOnce as $key => $value) {
  81. 						echo '<td style="background-color: #9D936B; font-color: #FFFFFF;"><b>'.$key.'</b>&nbsp;</td>';
  82. 					}
  83. 					echo '</tr>';
  84. 					$rMore = mysql_query(str_replace("\'", "'", $_GET['getStuff'])) or die ('<b>Error in query</b><br><pre>'.wordwrap(mysql_error(), 60).'</pre>');
  85. 					while ($a = mysql_fetch_array($rMore, MYSQL_ASSOC)) {
  86. 						echo '<tr>';
  87. 						foreach ($a as $key => $value) {
  88. 							$c = ($c == '#CCC4E8') ? '#C4DDE8' : '#CCC4E8';
  89. 							echo '<td style="background-color: '.$c.';">'.$value.'&nbsp;</td>';
  90. 						}
  91. 						echo '</tr>';
  92. 					}
  93. 				}
  94. 			}
  95. 		}
  96.  
  98. 	}
  99. ?>
  100.  
  101. <html>
  102. 	<head>
  103. 		<title>AJAX MYSQL</title>
  104. 		<style type="text/css">
  105. 			<!--
  106. 			a:link {
  107. 				color: #000000;
  108. 				text-decoration: none;
  109. 			}
  110. 			a:visited {
  111. 				text-decoration: none;
  112. 				color: #000000;
  113. 			}
  114. 			a:hover {
  115. 				text-decoration: underline;
  116. 				color: #666666;
  117. 			}
  118. 			a:active {
  119. 				text-decoration: none;
  120. 				color: #000000;
  121. 			}
  122.  
  123. 			table.bodyTable {
  124. 				border: 1px #000000 solid;
  125. 			}
  126.  
  127. 		body {
  128. 			background-color: #015BE1;
  129. 			margin-left: 8px;
  130. 			margin-top: 8px;
  131. 			margin-right: 8px;
  132. 			margin-bottom: 8px;
  133. 		}
  134.  
  135. 		body,td,th {
  136. 			font-family: Arial, Helvetica, sans-serif;
  137. 			font-size: 12px;
  138. 			color: #333333;
  139. 		}
  140.  
  141. 		td.menuHeader {
  142. 			background-color: #D5E5E0;
  143. 			padding: 2px;
  144. 			padding-bottom: 8px;
  145. 			border-bottom: 1px #FFFFFF solid;
  146. 			vertical-align: top;
  147. 		}
  148.  
  149. 		td.center {
  150. 			background-color: #DDE3E1;
  151. 			padding: 2px;
  152. 			padding-top: 8px;
  153. 			vertical-align: top;
  154. 		}
  155.  
  156. 		.output { 
  157. 			width: 100%;
  158. 			background-color: #FFFFFF;
  159. 			border: 1px #B1CBC2 dotted;
  160. 			padding: 2px;
  161. 		}
  162.  
  163. 		input {
  164. 			font-family: Verdana, Arial, Helvetica, sans-serif;
  165. 			font-size: 9px;
  166. 		}
  167.  
  168. 		pre {
  169. 			width: 512px;
  170. 			max-width: 512px;
  171. 			border: 1px #FF5519 solid;
  172. 			color: #8D5541;
  173. 			background-color: #EDE1DD;
  174. 		}
  175. 			-->
  176. 		</style>
  177.  
  178. 		<script>
  179. 		function getList(vari, theField, theField2, divv, file, method) {
  180.  
  181. 		// vari 		= $_GET waarde voor het server bestand
  182. 		// theField 	= het veld waar hij de waardes uit gaat gebruiken
  183. 		// theField2 	= ,,
  184. 		// divv			= de div waar de output terecht komt (kan ook wat anders zijn, als het innerHTML maar ondersteund 
  185. 		//				  (zoals bijv. textarea's en span's).
  186. 		// file			= het bestand dat aangeroepen wordt
  187. 		// method		= GET of POST, GET is het meest gebruikelijke, aangezien je geen gegevens kunt posten, 
  188. 		//			      dan wordt de pagina vernieuwd namelijk...
  189.  
  190.  
  191. 			var w3c = (typeof window.XMLHttpRequest != 'undefined');
  192. 			var ie = (typeof window.ActiveXObject != 'undefined');
  193. 			if (w3c) {
  194. 				var xmlHttp = new XMLHttpRequest();
  195. 			} 
  196. 			else if (ie) {
  197. 				var xmlHttp = new ActiveXObject("Msxml2.XMLHTTP");
  198. 			} 
  199. 			else {
  200. 				return false;
  201. 			}
  202.  
  203. 			var d = new Date();
  204. 			var inp = document.getElementById(theField).value;
  205. 			var inpDB = document.getElementById(theField2).value;
  206.  
  207. 			if (inp) {
  208. 				var url = file+'?'+vari+'='+inp+'&db='+inpDB
  209. 				var randomUrl = d.getFullYear()+(d.getMonth()+1)+d.getDate()+d.getHours()+d.getMinutes()+d.getSeconds()
  210. 				xmlHttp.open(method, url+'&random='+randomUrl,true);
  211.  
  212. 				xmlHttp.onreadystatechange = function() {
  213. 					if (xmlHttp.readyState == 4) {
  214. 						var content = xmlHttp.responseText;
  215. 						document.getElementById(divv).innerHTML = content;
  216. 					}
  217. 				}
  218.  
  219. 				xmlHttp.send(null);
  220. 				return (false);
  221. 			}
  222. 		}
  223. 		</script>	
  224.  
  225.  
  226. 	</head>
  227. 	<body>
  228. 	<table width="100%" height="100%"  border="0" cellpadding="0" cellspacing="0" class="bodyTable">
  229.         <tr>
  230.             <td height="10" class="menuHeader">
  231. 				<p>
  232. 					<?
  233. 						if (!$_SESSION['connected']) {
  234. 							?>
  235. 				<form method="post" action=""> 
  236. <table align="center">
  237. 									<tr>
  238. 										<td width="128"><b>Host:</b></td>
  239. 										<td><input name="host" type="text" value="localhost"></td>
  240. 									</tr>
  241. 									<tr>
  242. 										<td><b>Username:</b></td>
  243. 										<td><input name="user" type="text" value="root"></td>
  244. 									</tr>
  245. 									<tr>
  246. 										<td><b>Password:</b></td>
  247. 										<td><input name="pass" type="password"></td>
  248. 									</tr>
  249. 									<tr>
  250. 										<td>&nbsp;</td>
  251. 										<td><input name="sbmitMysqlLog" type="submit" value="Connect"></td>
  252. 									</tr>
  253. 					</table>
  254. 								</form>
  255. 							<?
  256. 						}
  257. 						else {
  258. 							$xhttpCmd = "getList('getStuff', 'sql', 'db', 'output', '".definedFileName."', 'GET');";
  259. 							?>
  260. 							SQL Instructie:
  261. 							<input name="sql" type="text" id="sql" style="width: 512px;" onKeyUp="<?=$xhttpCmd;?>">
  262. 							Database:	
  263. 							<input name="db" id="db" type="text" style="width: 128px;" readonly>
  264. 							<input type="button" name="noname" value="Logout" 					onMouseDown="window.location='<?=definedFileName;?>?action=logout'">
  265. 							<br>
  266. 							<input type="button" name="noname" value="Clear DB" 				onMouseDown="document.getElementById('tbls').value = 'Show tables'; document.getElementById('db').value = ''; <?=$xhttpCmd;?>">
  267. 							<input type="button" name="noname" value="Databases" 				onMouseDown="document.getElementById('sql').value = 'SHOW DATABASES'; <?=$xhttpCmd;?>">
  268. 							<input type="button" name="noname" id="tbls" value="Show tables" 	onMouseDown="document.getElementById('sql').value = 'SHOW TABLES'; <?=$xhttpCmd;?>">
  269. 							<?
  270. 						}
  271. 					?>
  272. 				</p>
  273.             </td>
  274.         </tr>
  275.         <tr>
  276.             <td class="center">
  277. 				<div id="output" class="output">
  278. 					<?
  279. 					if ($_GET['err'] == 'notlogged') {
  280. 						echo 'Not logged in because the login settings are incorrect...';
  281. 					}
  282. 					elseif (!$_SESSION['connected']) {
  283. 						echo 'Please login first...';
  284. 					}
  285. 					?>
  286. 				</div>
  287. 			</td>
  288.         </tr>
  289.     </table>
  290. 	</body>	
  291. </html>
Download code! Download code (.txt)

 Stemmen
Niet ingelogd.

 Reacties
Post een reactie
Lees de reacties (5)
© 2002-2024 Sitemasters.be - Regels - Laadtijd: 0.047s