Expand|Select|Wrap|Line Numbers
- Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\BizzarServer\Apache2\htdocs\index.php on line 77
- Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\BizzarServer\Apache2\htdocs\index.php on line 77
- Access denied for user 'ODBC'@'localhost' (using password: NO)
connect.php
[PHP]<?php
// Connect to server and select databse.
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '****';
$link = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = "accountdb";
mysql_select_db($dbname);
?>[/PHP]
Some Other Page Then Login
[PHP]//Top
ob_start();
session_start();
include 'connect.php';
$query = "SELECT * FROM accountTbl";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array( $result, MYSQL_NUM ) or die(mysql_error());
$avatar = $row['avatar'];
if($avatar == ""){
$avatar = "http://img1.jurko.net/avatar_5450.jpg";
}
echo "Welcome {$row['email']}! <br>" .
"points: {$row['points']} <br>" .
"Avatar: <img src=\"$avatar \" width=\"100px\" height=\"100px\"><br><br>";
include 'closedb.php';
?>
[/PHP]
Close.php
[PHP]<?php
include 'connect.php'
mysql_close($link);
?>
[/PHP]