mysql werkt niet
Warning: mysql_query() [function.mysql-query]: Can't connect to MySQL server on 'localhost' (10061) in C:\server\apache\htdocs\test.php on line 16
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\server\apache\htdocs\test.php on line 16
Can't connect to MySQL server on 'localhost' (10061)
ook als ik met CMD probeer in te loggen bij mysql krijg ik een foutmelding:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
kan het zijn dat localhost al bezet is? iemand die kan helpen?
Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in C:\server\apache\htdocs\test.php on line 7
Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to MySQL server on 'localhost' (10061) in C:\server\apache\htdocs\test.php on line 12
Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in C:\server\apache\htdocs\test.php on line 12
Warning: mysql_query() [function.mysql-query]: Can't connect to MySQL server on 'localhost' (10061) in C:\server\apache\htdocs\test.php on line 17
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\server\apache\htdocs\test.php on line 17
Can't connect to MySQL server on 'localhost' (10061)
maar als ik met CMD probeer in te loggen bij mysql krijg ik ook een foutmelding
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
<?php
function connect() {
$host = "localhost";
$username = "maurice";
$password = "*******";
$connect = mysql_connect("$host","$username","$password");
}
function select_db() {
$database = "maurice";
$database = mysql_select_db("$database");
}
connect();
select_db();
$sql = "SELECT member_naam FROM members WHERE member_gebruikersnaam='maurice'";
$query = mysql_query($sql) or die (mysql_error());
$row = mysql_fetch_object($query);
$naam = htmlspecialchars($row->member_naam);
echo $naam;
?>
function connect() {
$host = "localhost";
$username = "maurice";
$password = "*******";
$connect = mysql_connect("$host","$username","$password");
}
function select_db() {
$database = "maurice";
$database = mysql_select_db("$database");
}
connect();
select_db();
$sql = "SELECT member_naam FROM members WHERE member_gebruikersnaam='maurice'";
$query = mysql_query($sql) or die (mysql_error());
$row = mysql_fetch_object($query);
$naam = htmlspecialchars($row->member_naam);
echo $naam;
?>
ik denk dat het ligt aan mijn mysql server
Gewijzigd op 01/01/1970 01:00:00 door Maurice B
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
<?php
function connect() {
$host = 'localhost';
$username = 'maurice';
$password = '*******';
$connect = mysql_connect($host, $username, $password);
}
function select_db() {
$database = 'maurice';
$database = mysql_select_db($database);
}
connect();
select_db();
$sql = "SELECT member_naam FROM members WHERE member_gebruikersnaam = 'maurice'";
$query = mysql_query($sql) or die (mysql_error());
$row = mysql_fetch_object($query);
$naam = htmlspecialchars($row->member_naam);
echo $naam;
?>
function connect() {
$host = 'localhost';
$username = 'maurice';
$password = '*******';
$connect = mysql_connect($host, $username, $password);
}
function select_db() {
$database = 'maurice';
$database = mysql_select_db($database);
}
connect();
select_db();
$sql = "SELECT member_naam FROM members WHERE member_gebruikersnaam = 'maurice'";
$query = mysql_query($sql) or die (mysql_error());
$row = mysql_fetch_object($query);
$naam = htmlspecialchars($row->member_naam);
echo $naam;
?>
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
<?php
function connect() {
$host = 'localhost';
$username = 'maurice';
$password = '*******';
$connect = mysql_connect($host, $username, $password);
if (!$connect)
{
echo '<pre>MySQL connect error.</pre>';
connect();
exit;
}
return true;
}
function select_db() {
$database = 'maurice';
$database = mysql_select_db($database);
if (!$database)
{
echo '<pre>MySQL select error.</pre>';
connect();
exit;
}
return true;
}
connect();
select_db();
$sql = "SELECT member_naam FROM members WHERE member_gebruikersnaam = 'maurice'";
$query = mysql_query($sql) or die (mysql_error());
$row = mysql_fetch_object($query);
$naam = htmlspecialchars($row->member_naam);
echo $naam;
?>
function connect() {
$host = 'localhost';
$username = 'maurice';
$password = '*******';
$connect = mysql_connect($host, $username, $password);
if (!$connect)
{
echo '<pre>MySQL connect error.</pre>';
connect();
exit;
}
return true;
}
function select_db() {
$database = 'maurice';
$database = mysql_select_db($database);
if (!$database)
{
echo '<pre>MySQL select error.</pre>';
connect();
exit;
}
return true;
}
connect();
select_db();
$sql = "SELECT member_naam FROM members WHERE member_gebruikersnaam = 'maurice'";
$query = mysql_query($sql) or die (mysql_error());
$row = mysql_fetch_object($query);
$naam = htmlspecialchars($row->member_naam);
echo $naam;
?>
Moet je niet een while lus gebruiken ??? :S
Controleer in Windows ook even of MySQL uberhaubt wel draait.
Gewijzigd op 01/01/1970 01:00:00 door Maurice B
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<?php
function connect() {
$host = 'localhost';
$username = 'maurice';
$password = '*******';
$connect = mysql_connect($host, $username, $password);
if (!$connect)
{
echo '<pre>MySQL connect error.</pre>';
// hieronder roep je de functie op waar je nu in bent.
connect();
// bij deze exit zal ie dus nooit komen
exit;
}
return true;
}
?>
function connect() {
$host = 'localhost';
$username = 'maurice';
$password = '*******';
$connect = mysql_connect($host, $username, $password);
if (!$connect)
{
echo '<pre>MySQL connect error.</pre>';
// hieronder roep je de functie op waar je nu in bent.
connect();
// bij deze exit zal ie dus nooit komen
exit;
}
return true;
}
?>