10. oktober 2001 - 18:58
Der er
4 kommentarer og
1 løsning
hvor skal jeg insætte min connect her?
har den kode.. (connect_db_inc) men ved ik lige hvad for en jeg skal skrive mit brugernanvn/kode.... til min mysql en der kan hjælpe?
<?//-*- C++ -*-
/**
* Create a database connection
*
* Tries to connect to database and print out an error if that fails.
* In case of success a data base handle is returned.
*
* @author Michael Oertel <Michael@ortelius.de>
* @global $FEHLER,$BACKGROUNDIMAGE,$CHAT_OVERLOAD,$FILE_EXTENSION,$REPEAT_LOGIN,$INSTALL_DIR
* @return string contains the database handle
*/
function connect_db ($DATABASEHOST,$DATABASEUSER,$DATABASEPASSWD){
global $FEHLER,$BACKGROUNDIMAGE;
$noconnectmsg = \"<HTML><HEAD><TITLE>$FEHLER</TITLE></HEAD><BODY BGCOLOR=\\\"#FFFFFF\\\" BACKGROUND=\\\"$BACKGROUNDIMAGE\\\"><BR>\";
$noconnectmsg .= \"<DIV STYLE=\\\"color:#f00\\\">$FEHLER:</DIV> \";
$noconnect = 0;
$dbh = @mysql_connect($DATABASEHOST,$DATABASEUSER,$DATABASEPASSWD);
// tries to connect to database five times
while (!$dbh && $noconnect<5){
$noconnect++;
Sleep(2);
$dbh = @mysql_connect($DATABASEHOST,$DATABASEUSER,$DATABASEPASSWD);
if($debug){
echo \"$noconnect. connection try.<BR>\";
}
if($noconnect>4){
global $CHAT_OVERLOAD,$FILE_EXTENSION,$REPEAT_LOGIN,$INSTALL_DIR;
echo $noconnectmsg,\"$CHAT_OVERLOAD <A HREF=\\\"/frame_set.$FILE_EXTENSION\\\" TARGET=\\\"_top\\\">$REPEAT_LOGIN</A>.\";
echo \"<P><A HREF=\\\"/$INSTALL_DIR\\\">Chat-HomePage</A></BODY></HTML>\";
@mail($TEAM_MAIL_ADDR,$ERRORMAIL_SUBJECT,$ERRORMAIL_BODY,\'FROM: phpOpenChat\');
return -1;
}
}
global $DATABASENAME;
if(!mysql_select_db($DATABASENAME,$dbh)){
echo $noconnectmsg,\"Can\'t find database \'$DATABASENAME\'\";
global $INSTALL_DIR;
echo \"<P><A HREF=\\\"/$INSTALL_DIR\\\">Chat-HomePage</A></BODY></HTML>\";
@mysql_close($db_handle);
return -1;
}
return $dbh;
}
?>
10. oktober 2001 - 19:23
#1
$DATABASEHOST = \"navnet / ip på den server der kløre sql server\";
$DATABASEUSER = \"Brugernavnet\";
$DATABASEPASSWD = \"Passwordet til databasen\";
$DATABASENAME = \"Navnet på databasen\";
Dette indsætter du ØVEREST i dit script, lige efter <?
Og så retter du selvf. til så den indeholder de rigtige brugernavne og pass. m.m.
10. oktober 2001 - 19:46
#2
<?//-*- C++ -*-
/**
* Create a database connection
*
* Tries to connect to database and print out an error if that fails.
* In case of success a data base handle is returned.
*
* @author Michael Oertel <Michael@ortelius.de>
* @global $FEHLER,$BACKGROUNDIMAGE,$CHAT_OVERLOAD,$FILE_EXTENSION,$REPEAT_LOGIN,$INSTALL_DIR
* @return string contains the database handle
*/
$DATABASEHOST = \"localhost\";
$DATABASEUSER = \"?!?_dk\";
$DATABASEPASSWD = \"?!?!\";
$DATABASENAME = \"?!?_dk_db\";
function connect_db ($DATABASEHOST,$DATABASEUSER,$DATABASEPASSWD){
global $FEHLER,$BACKGROUNDIMAGE;
$noconnectmsg = \"<HTML><HEAD><TITLE>$FEHLER</TITLE></HEAD><BODY BGCOLOR=\\\"#FFFFFF\\\" BACKGROUND=\\\"$BACKGROUNDIMAGE\\\"><BR>\";
$noconnectmsg .= \"<DIV STYLE=\\\"color:#f00\\\">$FEHLER:</DIV> \";
$noconnect = 0;
$dbh = @mysql_connect($DATABASEHOST,$DATABASEUSER,$DATABASEPASSWD);
den virker ik.. for den her fejl i på en anden side: Warning: Failed opening \'defaults_inc.php\' for inclusion (include_path=\'.:/usr/local/lib/php\') in /web/www.dipz.dk/phpopenchat/html/index.php on line 29
Warning: Failed opening \'connect_db_inc.php\' for inclusion (include_path=\'.:/usr/local/lib/php\') in /web/www.dipz.dk/phpopenchat/html/index.php on line 36
Fatal error: Call to undefined function: connect_db() in /web/www.dipz.dk/phpopenchat/html/index.php on line 37
håber en lige kan finde du af om den sidder rigtig eller hvad!