Avatar billede acidburndk Nybegynder
24. februar 2004 - 13:13 Der er 3 kommentarer

mysql på whitehat.dk

nogen der kender whitehat.dk og ved hvad man skal skrive under $host, når man laver et tagwall script
Avatar billede schaefner Juniormester
24. februar 2004 - 13:15 #1
du skal skrive localhost
Avatar billede acidburndk Nybegynder
24. februar 2004 - 17:25 #2
hvad er der galt med det her script???

<html>
<head>
<style type='text/css'>
body {
  font-family: Trebuchet MS;
  color: #000000;
  font-size: 10pt;
}
INPUT {
  border: 1px solid;
  color: #000000;
}
TEXTAREA {
  border: 1px solid;
  color: #000000;
}
A {
  text-decoration: dotted;
  color: #000000;
}
A:hover {
  text-decoration: underline;
}
</style>
  <title>Sig din mening</title>
</head>
<body>
<form method='post' action=''>

<table cellspacing='3'>
  <tr>
    <td><input type='text' name='name' value='Name' onfocus="if(this.value=='Name')this.value='';" onblur="if(this.value=='')this.value='Name';" size='22'></td>
  </tr>
  <tr>
    <td><input type='text' name='email' value='E-mail' onfocus="if(this.value=='E-mail')this.value='';" onblur="if(this.value=='')this.value='E-mail';" size='22'></td>
  </tr>
  <tr>
    <td><textarea cols='30' rows='7' name='text'></textarea></td>
  </tr>
  <tr>
    <td><input type='submit' name='send' value='Post'></form></td>
  </tr>
</table>
<br><br>

<?php

//MySQL server configuration
$host = "localhost"; //Enter the address to your MySQL server
$user = "acidburn"; //Enter the user to your MySQL server
$pass = "101283"; //Enter the password to your user
$db = "acidburn"; //Enter the database on your MySQL server where you created the table from the structure.sql

//Do not modify anything under this line!

//Get the input typed in the form
$name = $_POST['name'];
$email = $_POST['email'];
$text = $_POST['text'];
$time = date("d/m-Y H:i:s");

//If nothing was typed in the name field, then the Name will be replaced with 'anonymous'
if ($_POST['name'] == "Name") {
    $name = "Anonymous";
}

//If nothing was typed in the E-mail field, then the E-mail will be replaced with null@null
if ($_POST['email'] == "E-mail") {
    $email = "null@null";
}

//Connect to the MySQL server
mysql_connect("$localhost", "$acidburn", "$101283");

//Select a database
mysql_select_db($acidburn);

//If the text field isn't empty, then this code will be executed:
//If an URL was typed in the text field, then it will be replaced with <a href='http://somedomain.com'>http://somedomain.com</a>
//If an < or > has been typed, it will be replaced with &lt; or &gt;
//Insert the data into the MySQL database
if(!empty($_POST['text'])){
    $text = ereg_replace("<", "&lt;", $text);
    $text = ereg_replace(">", "&gt;", $text);
    $text = ereg_replace("[[:alpha:]]+://[^<>[:space:]]+[[:alnum:]/]", "<a href=\"\\0\">\\0</a>", $text);
    $insertSQL = "insert into tagwall2 (name, email, time, text) values ('$name', '$email', '$time', '$text')";
    mysql_query($insertSQL);
}

//Get all the data from the MySQL database, sort by the row 'id' and limit the rows that's being printed to 20
//Make an array from the $result variable
//Convert the 'new line's to <br>
$result = mysql_query("SELECT * FROM `tagwall2` WHERE 1") or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
    echo "<font family='Trebuchet MS, sans-serif' size='2'><b><a href='mailto:".$row['email']."'>".$row['name']."</a></b> - ".$row['time']."<br>";
    echo nl2br($row['text']);
    echo "<br><br>";
}

//Close the connection to the MySQL server
mysql_close();
?>

<br><br>

</body>
</html>

når jeg så går ind på siden, så skriver den

Warning: mysql_connect(): Access denied for user: 'mads@localhost' (Using password: YES) in /usr/home/whitehat_dk/users/acidburn/tag3.php on line 73

Warning: mysql_select_db(): Access denied for user: 'mads@localhost' (Using password: NO) in /usr/home/whitehat_dk/users/acidburn/tag3.php on line 76

Warning: mysql_select_db(): A link to the server could not be established in /usr/home/whitehat_dk/users/acidburn/tag3.php on line 76

Warning: mysql_query(): Access denied for user: 'mads@localhost' (Using password: NO) in /usr/home/whitehat_dk/users/acidburn/tag3.php on line 93

Warning: mysql_query(): A link to the server could not be established in /usr/home/whitehat_dk/users/acidburn/tag3.php on line 93
Access denied for user: 'mads@localhost' (Using password: NO)
Avatar billede egonspock Seniormester
24. februar 2004 - 22:44 #3
Jeg kan umiddelbart se to problemer:
1) i linjen; "//Connect to the MySQL server
mysql_connect("$localhost", "$acidburn", "$101283");"
bruger du variaber med navnene localhost, acidburn og 101283. Det du ønsker er at bruge variablene host, user og pass. ($ foran et navn betyder at det er en variabel), fjern også gåseøjnene ved samme lejlighed.
2) et eller andet sted har du sat variablen $acidburn til at hedde mads, og jeg forstår ikke helt hvor den kommer fra, men skidt så med det.
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester