Database fout/probleem
Script:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<?
/*
CREATE TABLE 'teller' (
'teller' TEXT NOT NULL
);
*/
mysql_connect("localhost","****","******");
mysql_select_db("teller");
$sql = "UPDATE teller SET teller = teller+1";
$sql = mysql_query($sql) or die (mysql_error());
$sql2 = "SELECT * FROM teller";
$sql2 = mysql_query($sql2) or die (mysql_error());
while($query = mysql_fetch_object($sql2)) {
echo "Deze site heeft al <b>$query->teller</b> hits!";
}
?>
/*
CREATE TABLE 'teller' (
'teller' TEXT NOT NULL
);
*/
mysql_connect("localhost","****","******");
mysql_select_db("teller");
$sql = "UPDATE teller SET teller = teller+1";
$sql = mysql_query($sql) or die (mysql_error());
$sql2 = "SELECT * FROM teller";
$sql2 = mysql_query($sql2) or die (mysql_error());
while($query = mysql_fetch_object($sql2)) {
echo "Deze site heeft al <b>$query->teller</b> hits!";
}
?>
Ik heb de tabel teller aangemaakt met phpmyadmin
Het programma zegt dit:
Veld Type Attributen Null Standaardwaarde Extra Actie
teller text Nee Veranderen Verwijderen Primaire sleutel Index Unieke waarde Volledige tekst
Ik weet niet of je er wat aan hebt maja
Je moet je username of password nog eens checken...
Doe het zo:
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
<?
mysql_select_db("teller", mysql_connect("localhost", "user", "pass")) or die("Verbindingsfoutjuh!");
# CREATE TABLE `hits` (
# `hid` int(11) primary key auto_increment,
# `hip` varchar(15) not null default '',
$sql1 = "INSERT INTO `hits` SET `hip` = '" . $_SERVER['REMOTE_ADDR'] . "'";
$res1 = mysql_query($sql1);
$sql2 = "SELECT COUNT(`hid`) as `aantal` FROM `hits`";
$res2 = mysql_query($sql2);
$hits = mysql_fetch_array($res2, MYSQL_ASSOC);
echo("Er zijn al " . $hits['aantal'] . " bezoekers geweest!");
?>
mysql_select_db("teller", mysql_connect("localhost", "user", "pass")) or die("Verbindingsfoutjuh!");
# CREATE TABLE `hits` (
# `hid` int(11) primary key auto_increment,
# `hip` varchar(15) not null default '',
$sql1 = "INSERT INTO `hits` SET `hip` = '" . $_SERVER['REMOTE_ADDR'] . "'";
$res1 = mysql_query($sql1);
$sql2 = "SELECT COUNT(`hid`) as `aantal` FROM `hits`";
$res2 = mysql_query($sql2);
$hits = mysql_fetch_array($res2, MYSQL_ASSOC);
echo("Er zijn al " . $hits['aantal'] . " bezoekers geweest!");
?>
Net getypt dus kunnen typos in zitten ...