SA:MP UCP Problem Mysql

Maurice. · 19. November 2013

HIer mal der mir angezeigt wird : Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/www/cwcity/hosting/m/a/maurice2013/htdocs/index.php on line 4 hier mal index.php

SQL

<?php
include('config.php');
session_start(); 
while($RowIN = mysql_fetch_array($ResultIN))
{ 

if($RowIN['wartung'] == 1)
{
	include("templates/wartung.tpl");
}
else
{
	if(isset($_SESSION['name'])) 
	{
		header('location: profile.php'); 
	}
	else
	{
		?>
		<!DOCTYPE HTML>
	<html>
	<head>
	<meta charset="utf-8">
	<link rel="stylesheet" type="text/css" href="./stylesheet.css">
	<title>Basic UCP</title>
	<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
	<script type="text/javascript">
	$(document).ready(function () {
		$('#wrapper #navigation li').hover(
			function () {
				$('ul', this).slideDown(200);

			},
			function () {
				$('ul', this).slideUp(200);        
			}
		);    
	});
	</script>
	</head>


	<body>
		<div id="global">
			<div id="wrapper">
				<div id="header"></div>

				<div id="content">
					<?php include('menu.php') ?>
					<div id="text">
					<div class="info">
					Wenn es mit unserem User Control Panel Probleme geben sollte, solltest du dich sofort bei uns Melden!<br>
					<hr>Das geht derzeit leider nur in unserem Forum. (<a href="http://streets-of-life.de">HIER</a>)
					</div><br>
						<?php
						$query = "SELECT * FROM ucp_news ORDER BY ID DESC LIMIT 3";
						$ResultIN = mysql_query($query);
						while($RowIN = mysql_fetch_array($ResultIN))
						{ 						
						  echo '<div class="headline"><h3>'.$RowIN['title'].' <div style="float: right"> '.$RowIN['time'].'</div></div><hr></h3><br><center>'.$RowIN['text'].'</center><br><hr>'; 
						}    
						?>	
					</div>
				</div>

				<div id="userbox" class="box_small">
					<div id="head">
						Benutzer
					</div>

					<div id="text">
						<form action="login.php" method="POST">
						<table>
							<tr>
								<td><input type="text" name="name" class="textbox"></td>
							</tr>
							<tr>
								 <td><input type="password" name="password" class="textbox"></td>
							</tr>
						</table>

						<div id="userbuttons">
							<input type="submit" name="submit" value="Login" class="button">
						</div>
						</form>
					</div>
				</div>

				<div id="serverbox" class="box_large">
					<div id="head">
						Server Status
					</div>

					<div id="text">
					<?php


	if($eeee->isOnline())
	{
		$aInformation = $eeee->getInfo();
		$aServerRules = $eeee->getRules();



	?>
						<span class="param">Name</span> <?= htmlentities($aInformation['hostname']) ?>
						<span class="param">Spieler</span> <?= $aInformation['players'] ?> / <?= $aInformation['maxplayers'] ?>
						<span class="param">Gamemode</span> <?= htmlentities($aInformation['gamemode']) ?>
						<span class="param">IP-Adresse</span> <?= $ip?>:<?= $port; ?>

						<div id="serverbutton">
							<?php echo '<form action="samp://'.$ip.':'.$port.'">'; ?>
								<input type="submit" value="Join" class="button">
							</form>
						</div>

						<?php
							}
	?>
					</div>
				</div>
			</div>

			<br class="clear">

			<div id="footer">
				<?php echo $footer; ?>
			   <!-- <a href="policy.html">Impressum</a>&nbsp;&nbsp;<a href="contact.html">Kontakt</a> -->
			</div>
		</div>
	</body>
	</html>
		<?php
	}
}	
}
	?>

Alles anzeigen

Beavis · 19. November 2013

du solltest vorher auch mal nen query ausführen denn der Fehler kommt da kein Query abgesendet wurde

Maurice. · 19. November 2013

sry das ich frage wie mache ich das den ?

Slash™ · 19. November 2013

ich glaube so

PHP

$mysql = "SELECT * FROM `tabelle`";
			$mysql_query = mysql_query($mysql);
while($RowIN = mysql_fetch_object($mysql_query))
{

Maurice. · 19. November 2013

So ? <?php
include('config.php');
session_start();
$mysql = "SELECT * FROM `user`";
$mysql_query = mysql_query($mysql);
while($RowIN = mysql_fetch_object($mysql_query))
{
while($RowIN = mysql_fetch_array($ResultIN))
{

if($RowIN['wartung'] == 1)
{
include("templates/wartung.tpl");
}
else
{
if(isset($_SESSION['name']))
{
header('location: profile.php');
}
else
{
?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<link rel="stylesheet" type="text/css" href="./stylesheet.css">
<title>Basic UCP</title>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
$('#wrapper #navigation li').hover(
function () {
$('ul', this).slideDown(200);

},
function () {
$('ul', this).slideUp(200);
}
);
});
</script>
</head>

<body>
<div id="global">
<div id="wrapper">
<div id="header"></div>

<div id="content">
<?php include('menu.php') ?>
<div id="text">
<div class="info">
Wenn es mit unserem User Control Panel Probleme geben sollte, solltest du dich sofort bei uns Melden!<br>
<hr>Das geht derzeit leider nur in unserem Forum. (<a href="http://streets-of-life.de">HIER</a>)
</div><br>
<?php
$query = "SELECT * FROM ucp_news ORDER BY ID DESC LIMIT 3";
$ResultIN = mysql_query($query);
while($RowIN = mysql_fetch_array($ResultIN))
{
echo '<div class="headline"><h3>'.$RowIN['title'].' <div style="float: right"> '.$RowIN['time'].'</div></div><hr></h3><br><center>'.$RowIN['text'].'</center><br><hr>';
}
?>
</div>
</div>

<div id="userbox" class="box_small">
<div id="head">
Benutzer
</div>

<div id="text">
<form action="login.php" method="POST">
<table>
<tr>
<td><input type="text" name="name" class="textbox"></td>
</tr>
<tr>
<td><input type="password" name="password" class="textbox"></td>
</tr>
</table>

<div id="userbuttons">
<input type="submit" name="submit" value="Login" class="button">
</div>
</form>
</div>
</div>

<div id="serverbox" class="box_large">
<div id="head">
Server Status
</div>

<div id="text">
<?php

if($eeee->isOnline())
{
$aInformation = $eeee->getInfo();
$aServerRules = $eeee->getRules();

?>
<span class="param">Name</span> <?= htmlentities($aInformation['hostname']) ?>
<span class="param">Spieler</span> <?= $aInformation['players'] ?> / <?= $aInformation['maxplayers'] ?>
<span class="param">Gamemode</span> <?= htmlentities($aInformation['gamemode']) ?>
<span class="param">IP-Adresse</span> <?= $ip?>:<?= $port; ?>

<div id="serverbutton">
<?php echo '<form action="samp://'.$ip.':'.$port.'">'; ?>
<input type="submit" value="Join" class="button">
</form>
</div>

<?php
}
?>
</div>
</div>
</div>

<br class="clear">

<div id="footer">
<?php echo $footer; ?>

</div>
</div>
</body>
</html>
<?php
}
}
}
?>

Beavis · 19. November 2013

warum 2 While schleifen?!
lern lieber mal die Grundlagen von php anstatt irgendwas zusammen zu schustern

SLaYz · 19. November 2013

Und Sessions immer in die Erste Zeile eines Php Codes danach der Rest
Also

Session_start()
Session_destroy()

breadfish.de 12. März 2022