Connectie probleem

xifiz · 29 October 2009

Ik heb een bank script die geen connectie wilt maken met de DB.
De hele website werkt behalve die bank.
Dit is een bank met bankrekening functie etc.

Dit zijn de foutmeldingen:
Warning: mysql_query() [function.mysql-query]: Access denied for user 'md049425'@'localhost' (using password: NO) in /storage/mijndomein/users/049425/public/sites/www.thehood.nl/bank.php on line 5

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /storage/mijndomein/users/049425/public/sites/www.thehood.nl/bank.php on line 5

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /storage/mijndomein/users/049425/public/sites/www.thehood.nl/bank.php on line 6

Warning: mysql_query() [function.mysql-query]: Access denied for user 'md049425'@'localhost' (using password: NO) in /storage/mijndomein/users/049425/public/sites/www.thehood.nl/bank.php on line 9

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /storage/mijndomein/users/049425/public/sites/www.thehood.nl/bank.php on line 9

En dit is het stukje script:

PHP

<?php /* ------------------------- */






$dbres = mysql_query("SELECT * FROM `bankrekeningen` WHERE `owner`='{$data['login']}'");
$queries = mysql_num_rows($dbres);
if ($queries == 0){
$rand = rand(000000,999999);
mysql_query("INSERT INTO `bankrekeningen`(owner,rekening,createdate,bank) values('{$data['login']}','$rand',NOW(),'{$data['bank']}')");
print"";
}
/* ------------------------- */ ?>

Toon Meer

Als iemand het ziet graag want ik ziet het niet

Groetjes xifiz

Frenzo · 29 October 2009

post is heel je script

Nieuwe reactie samengevoegd met originele reactie op 29.10.09 20:00:56:
of misschien inlcude config of wat de connectie ook is:)

xifiz · 29 October 2009

Dit is de bank:

PHP

<?php /* ------------------------- */






$dbres = mysql_query("SELECT * FROM `bankrekeningen` WHERE `owner`='{$data['login']}'");
$queries = mysql_num_rows($dbres);
if ($queries == 0){
$rand = rand(000000,999999);
mysql_query("INSERT INTO `bankrekeningen`(owner,rekening,createdate,bank) values('{$data['login']}','$rand',NOW(),'{$data['bank']}')");
print"";
}
/* ------------------------- */ ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Xtreme-War.nl</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">




<body background="#333333" text="#FFFFFF" link="#999999" vlink="#999999" alink="#999999" topmargin="0">


<?
  if(isset($_GET['v']) && ($_GET['v'] == 1 || $_GET['v'] == 2 || $_GET['v'] == 3)) {
    setcookie("v",$_GET['v'],time()+24*60*60*365,"/","");
    $_COOKIE['v']			= $_GET['v'];
  }


  if($_COOKIE['v'] == '3') {
    include("style3.php");
} else
  if($_COOKIE['v'] == '2') {
    include("style2.php");
} else
  if($_COOKIE['v'] == '1') {
    include("style1.php");
} else
    include("style3.php");
?>


<base target="main" />


</head>


<center>
<table width=100 cellspacing=0 cellpadding=0 border=0>
<tr>
<td width=50% valign=top align=center>
<table align=center width=310>
	<tr>
	<td colspan="2" class="subTitle" align="center">Bank</td>
	</tr>
  <tr><td class=mainTxt>
<?php /* ------------------------- */
if(isset($_POST['Submit'])){
$dbres = mysql_query("SELECT * FROM `bankrekeningen` WHERE `owner`='{$data['login']}' AND `rekening`='{$_POST['rekening']}'");
$rek = mysql_fetch_assoc($dbres);
$rekening = $_POST['rekening'];
      $nowcash			= $data['cash'];
      $nowbank			= $rek['bank'];
}elseif(isset($_POST['in']) || isset($_POST['out'])){
$rekening = $_POST['rekening2'];
$dbres = mysql_query("SELECT * FROM `bankrekeningen` WHERE `owner`='{$data['login']}' AND `rekening`='{$rekening}'");
$rek = mysql_fetch_assoc($dbres);
}
if (isset($_POST['Submit']) || isset($_POST['in']) || isset($_POST['out'])){
  if(isset($_POST['out']) && preg_match('/^[0-9]+$/',$_POST['gek'])) {
    if($_POST['gek'] <= $rek['bank']) {
      $cash			= $_POST['gek'];
      $bank			= $_POST['gek'];
      $nowcash			= $data['cash']+$_POST['gek'];
      $nowbank			= $rek['bank']-$_POST['gek'];
      mysql_query("UPDATE `bankrekeningen` SET `bank`=`bank`-{$bank} WHERE `owner`='{$data['login']}' AND `rekening`='{$rekening}'");
	  mysql_query("UPDATE `[users]` SET `cash`=`cash`+'{$cash}' WHERE `login`='{$data['login']}'");
      print "Er is &euro;{$cash},- van rekening {$rekening} gehaald.";
    }
    else
      print "<font color=red>Zoveel geld staat er niet op de rekening {$rekening}";
  }
  else if(isset($_POST['in']) && preg_match('/^[0-9]+$/',$_POST['gek'])) {
    if($_POST['gek'] <= $data['cash']) {
if ($rek['bank']+$_POST['gek'] <= 999999999999999999999999999999999999){
      $cash			= $_POST['gek'];
      $bank			= $_POST['gek'];
      $nowcash			= $data['cash']-$_POST['gek'];
      $nowbank			= $rek['bank']+$_POST['gek'];
	$max = ($rek['bank']+$_POST['gek']) - 100000000;
	$max		= preg_replace('/-/',"",$max);
      mysql_query("UPDATE `bankrekeningen` SET `bank`=`bank`+{$bank} WHERE `owner`='{$data['login']}' AND `rekening`='{$rekening}'");
	  mysql_query("UPDATE `[users]` SET `cash`=`cash`-'{$cash}' WHERE `login`='{$data['login']}'");
      print "  Er is &euro;{$cash},- op rekening {$rekening} gezet. U kunt nog &euro;$max,- storten.";
    }
	else{
	$max = $rek['bank'] - 999999999999999999999999999999999999;
	$max		= preg_replace('/-/',"",$max);
      print "<font color=red>Dit overschrijdt het maximum van &euro;999999999999999999999999999999999999,-! U kunt nog maar &euro;$max,- storten!";
	}
	}
    else
      print "<font color=red>Zoveel geld heb je niet";
  }
  print <<<ENDHTML
<table align="center">


	  <tr><td width=100>Contant:</td>	<td align="right">&euro;{$nowcash},-</td></tr>
	  <tr><td width=100>Op de bank:</td>	<td align="right">&euro;{$nowbank},-</td></tr>
	</table>
	<form method="post"><table align="center">
	<input type="hidden" name="rekening2" value="{$rekening}">
	  <tr><td align="center">&euro;<input type="text" name="gek" maxlength="9">,-
		<input type="submit" name="out"  value="Uit" style="width: 100;">
		<input type="submit" name="in" value="In"  style="width: 100;"></td></tr>
          </table>
        </form>
      </div></td>


ENDHTML;
}elseif(!isset($_POST['Submit'])){
print <<<ENDHTML
<table width="100%" height="83" border="0">
<tr>
    <td><div align="center"> 
        <form name="form1" method="post">
          <table width="60%" border="0" align="center">
            <tr>
              <td width="60%">Selecteer Rekening:</td>
              <td width="40%"><select name="rekening">
ENDHTML;
$dbres = mysql_query("SELECT * FROM `bankrekeningen` WHERE `owner`='{$data['login']}'");
while($list = mysql_fetch_assoc($dbres)){
echo"<option value="{$list['rekening']}">{$list['rekening']} (&euro;{$list['bank']},-)</option>";
}
print <<<ENDHTML
                </select></td>
            </tr>
            <tr> 
              <td colspan="2"><div align="center"> 
                  <input type="submit" name="Submit" value="Check Rekening">
                </div></td>
            </tr>
<tr><td><br></td></tr>
<tr><td><br></td></tr>
<tr><td><br></td></tr>
<br><br><br>
          </table>
        </form></table>
ENDHTML;
}
	print "</table>";
?>
</td>
<td width=50% valign=top align=center>
<table align=center width=310>
	<tr>
	<td colspan="2" class="subTitle" align="center">Doneren</td>
	</tr>
  <tr><td class=mainTxt>
<?
if(isset($_POST['donate']) && preg_match('/^[0-9]{1,15}$/',$_POST['amount']) && $_POST['amount'] > 0) {
$amount = $_POST['amount'];
$message = $_POST['message'];
$nick = $_POST['nick'];
$select = mysql_query("SELECT * FROM `[users]` WHERE `login`='$nick'");
$aantal = mysql_fetch_assoc($select);
$exists = mysql_num_rows($select);


if($exists < 1){
  print <<<ENDHTML
<font color=red>$nick bestaat niet.<meta http-equiv=Refresh content=3;url=bank.php>
ENDHTML;
}
elseif ($data['cash'] < $amount){
  print <<<ENDHTML
<font color=red>Je hebt niet ?$amount,- bij je.<meta http-equiv=Refresh content=3;url=bank.php>
ENDHTML;
}
else {
if($amount <= 500){
$timme = 5;
} elseif($amount > 500 AND $amount <= 2500){
$timme = 10;
}elseif($amount > 2500 AND $amount <= 5000){
$timme = 12;
} elseif($amount > 5000 AND $amount <= 10000){
$timme = 20;
} elseif($amount > 10000 AND $amount <= 15000){
$timme = 25;
} elseif($amount > 15000 AND $amount <= 25000){
$timme = 30;
} elseif($amount > 25000 AND $amount <= 50000){
$timme = 35;
} elseif($amount > 50000 AND $amount <= 75000){
$timme = 40;
} elseif($amount > 75000 AND $amount <= 150000){
$timme = 60;
} elseif($amount > 150000 AND $amount <= 250000){
$timme = 75;
} elseif($amount > 250000 AND $amount <= 500000){
$timme = 90;
} elseif($amount > 500000){
$timme = 120;
}
$way  = $_POST['way'];
if (isset($_POST['way']) && $_POST['way'] == 1) {
      $ramount = $amount*0.95;
      mysql_query("UPDATE `[users]` SET `cash`=`cash`-'$amount' WHERE `login`='{$data['login']}'");
      mysql_query("UPDATE `[users]` SET `cash`=`cash`+'$ramount' WHERE `login`='{$aantal['login']}'");
      mysql_query("INSERT INTO `[donates]`(`time`,`login`,`person`,`amount`,`timeneeded`,`message`) 
values(NOW(),'{$data['login']}','{$aantal['login']}','$ramount','$timme','$message')");
}
if (isset($_POST['way']) && $_POST['way'] == 2) {
if($amount > 5000){
  print <<<ENDHTML
Je mag max. ?5.000,- weggeven .<meta http-equiv=Refresh content=3;url=bank.php>
ENDHTML;
}
else {
      mysql_query("UPDATE `[users]` SET `cash`=`cash`-'$amount' WHERE `login`='{$data['login']}'");
      mysql_query("UPDATE `[users]` SET `cash`=`cash`+'$amount' WHERE `login`='{$aantal['login']}'");
      mysql_query("INSERT INTO `[donates]`(`time`,`login`,`person`,`amount`,`timeneeded`,`message`) values(NOW(),'{$data['login']}','{$aantal['login']}','$amount','$timme','$message')");
}
}
}
}
$sentlogs = mysql_query("SELECT * FROM `[donates]` WHERE `login`='{$data['login']}' ORDER BY `time` DESC LIMIT 0,10");
$receivlogs = mysql_query("SELECT * FROM `[donates]` WHERE `person`='{$data['login']}' ORDER BY `time` DESC LIMIT 0,10");


print <<<ENDHTML
<left>
<table width="95%">
	<form method="post">
	<table align="left" width="100%">
<tr><td style="border-bottom: 1px solid black;">Naar:
<input name="nick" type="text" maxlength=32></td>
</tr>
<tr>
<td class="tableitem">Donatie detail:</td>
</tr>
<tr>
<td style="border-bottom: 1px solid black;"><input name="way" value="1" type="radio" checked="checked"> Doneren - 5% vervoerskosten</td>
</tr>
<tr>
<td style="border-bottom: 1px solid black;"><input name="way" value="2" type="radio"> Weggeven - Maximaal 5000</td>
</tr>
<tr>
	<td class="tableitem">Met het bericht:
	<input width=100% name="message" maxlength="50" type="text"></td>
</tr>
<tr>
	<td class="tableitem">Bedrag:
	?<input width=100%; name="amount" maxlength="11" type="text">,-</td>
</tr>
<tr>
	<td><input value="Doneer/Geef weg" type="submit" name="donate"></td>
</tr>
</tbody></table>
	</form></td></left>
ENDHTML;
  print <<<ENDHTML
                     </td>
	</tr>
                      </tbody>
                      </table>
                     </td>
	</tr>
                      </tbody>
                      </table>
</td>
<br><br><center>
<b><small>Laatste 10 ontvangen donaties:</small></b></center>
<br><table align="center" width="600">
<tr>
<td class="subTitle" width="20%"><b>Van:</b></td>
<td class="subTitle" width="20%"><b>Bedrag:</b></td>
<td class="subTitle" width="25%"><b>Tijd:</b></td>
<td class="subTitle" width="35%"><b>Bericht</b></td>
</tr><tr>
<td colspan="4" height="1"></td>
</tr>
</left>
ENDHTML;
    while($info2 = mysql_fetch_assoc($receivlogs)) {
  print <<<ENDHTML
<tr>
<td class="mainTxt" width="20%"><b>{$info2['login']}</b></td>
<td class="mainTxt" width="20%"><b>{$info2['amount']}</b></td>
<td class="mainTxt" width="45%"><b>{$info2['time']}</b></td>
<td class="mainTxt" width="35%"><b>{$info2['message']}</b></td>
</tr>
ENDHTML;
}
  print <<<ENDHTML
</table>
<br>
<br><center>
<b><small>Laatste 10 verzonden donaties:</small></b></center><br>
<br><table align="center" width="600">
<tr>
<td class="subTitle" width="20%"><b>Aan:</b></td>
<td class="subTitle" width="20%"><b>Bedrag:</b></td>
<td class="subTitle" width="25%"><b>Tijd:</b></td>
<td class="subTitle" width="35%"><b>Bericht</b></td>
</tr><tr>
<td colspan="4" height="1"></td>
</tr>
</left>
ENDHTML;
    while($info = mysql_fetch_assoc($sentlogs)) {
  print <<<ENDHTML
<tr><td class="mainTxt" width="20%"><b>{$info['person']}</b></td>
<td class="mainTxt" width="20%"><b>{$info['amount']}</b></td>
<td class="mainTxt" width="45%"><b>{$info['time']}</b></td>
<td class="mainTxt" width="35%"><b>{$info['message']}</b></td></tr>
</tbody>
ENDHTML;
}
?>
	
</body>




</html>

Toon Meer

Nieuwe reactie samengevoegd met originele reactie op 29.10.09 20:15:59:
eerste stuk config:

PHP

<?php /* ------------------------- */


   if(!(@mysql_connect("db.thehood.nl","md49425db101048","pass") && @mysql_select_db("md49425db101048"))) {
   print <<<ENDHTML
<html>

Dpm_x · 29 October 2009

je config includen?:p

r-mulder · 29 October 2009

PHP

<?php /* ------------------------- */


   if(!(@mysql_connect("db.thehood.nl","md49425db101048","pass") && @mysql_select_db("md49425db101048"))) {
   print <<<ENDHTML
<html>

Dat stuk waar "pass" staat moet je je wachtwoord invullen anders gaan het niet werken..
Klopt trouwens je gebruikersnaam en database wel ?

JeroenH · 29 October 2009

servernaam db.thehood.nl? Heb je dat zelf in de DNS toegevoegd of wat moet ik me daarbij voorstellen? Lijkt me niet dat je een eigen DB server hebt die ook extern bereikbaar is (intern via VLAN kan, maar extern is niet aan te raden). Ik denk dat dat gewoon localhost of een 192.x IP moet zijn.

baldex · 30 October 2009

je moet localhost zeten geen db.thehood

en zeker heet je database db.thehood en je pass md49425db101048

:p

Smil-E · 30 October 2009

JeroenH;

is waarschijnlijk via mijndomein, daar staat de PHPMYADMIN niet op de host zelf

Jannick · 30 October 2009

baldex Als je geen verstand hebt van andere hosts, zeg dan ook niks. Database staat op een aparte host, databasenaam is de je username (md*****) met een database erachter (db******). Wachtwoord is zelf generated, dus het klopt wel degelijk. Zorg je wel dat je je wachtwoord van je eigen account niet gebruikt, maar dat van je database?

baldex · 30 October 2009

Jannick

ik heb wel verstand van maar heb me vergist kan gebeuren
maar dan moet jij niet meteen zegen dat ik versatnd er van heb

ik probeer aleen te helpen en mensen maken fouten dus jij ook
en als jij fouten maakt hier dan zeg ik ook niet meteen dat je er geen versand van hebt

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Plesk installer

cpanel / whm themes

PHP Point of Sale

Probleem omtrent Tinymce

Kunnen jullie mij helpen met deze enquete

een eigen cloud sever

Probleem C++ en CL

228 Nieuwe domeinnamen Maart 2025

285 Nieuwe domeinnamen Februari 2025

190 Nieuwe domeinnamen Januari 2025

Connectie probleem

Participate now!

Fijne feestdagen

Kritieke update voor Really Simple Security-plug-in

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

Functioneel ontwerp

Access Control List implementatie in PHP/MySQL - deel 1/2

Access Control List implementatie in PHP/MySQL - deel 2/2

Delen