Php - mysql foute weergave
ik roep een woord of zin uit een mysql op en het resultaar word b.v. "--[DAF]->" terwijl er in mijn table "--[DAF]--" staat???
ik heb het met verschillende script alle manieren is dit een fout van mij
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
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
<?php
include("connect.php");
putenv("TZ=Europe/Amsterdam");
$csql = "SELECT tid, datum, catogory FROM `replys` ORDER BY `datum` desc";
$res = mysql_query($csql);
$aantal_lijnen=mysql_num_rows($res);
$i=0;
echo "<table width=\"100%\" cellspacing=\"0\" cellpading=\"0\">";
for($g=0;$g<"5";) {
$row=mysql_fetch_row($res);
if ($row[0]!= $test[1] && $row[0]!= $test[2] && $row[0]!= $test[3] && $row[0]!= $test[4] && $row[0]!= $test[5]){
$g++;
$csql2 = "SELECT titel, catogory FROM `topics` where id='$row[0]'";
$res2 = mysql_query($csql2);
$row2=mysql_fetch_row($res2);
$datum=date("d.m",$row[1]);
if ($row2[0]!=""){
if ($row2[0]=="[Che-Lives-clan] Geustbook"){
echo "<tr><td class=\"menu\"><a href=\"guestbook.php\">Guestbook</a></td><td class=\"menu\">$datum<br></td></tr>";
}
elseif ($row2[1]=="5"){}
else{
echo "<tr><td class=\"menu\"><a href=\"replys.php?id=$row[0]&cat=$row[2]\">$row2[0]</a></td><td class=\"menu\"> $datum<br></td></tr>";}
}
$test[$g]="$row[0]";
}
else{$i++;
if ($i=="20"){$g="5";}}
}
echo "</table>";
?>
include("connect.php");
putenv("TZ=Europe/Amsterdam");
$csql = "SELECT tid, datum, catogory FROM `replys` ORDER BY `datum` desc";
$res = mysql_query($csql);
$aantal_lijnen=mysql_num_rows($res);
$i=0;
echo "<table width=\"100%\" cellspacing=\"0\" cellpading=\"0\">";
for($g=0;$g<"5";) {
$row=mysql_fetch_row($res);
if ($row[0]!= $test[1] && $row[0]!= $test[2] && $row[0]!= $test[3] && $row[0]!= $test[4] && $row[0]!= $test[5]){
$g++;
$csql2 = "SELECT titel, catogory FROM `topics` where id='$row[0]'";
$res2 = mysql_query($csql2);
$row2=mysql_fetch_row($res2);
$datum=date("d.m",$row[1]);
if ($row2[0]!=""){
if ($row2[0]=="[Che-Lives-clan] Geustbook"){
echo "<tr><td class=\"menu\"><a href=\"guestbook.php\">Guestbook</a></td><td class=\"menu\">$datum<br></td></tr>";
}
elseif ($row2[1]=="5"){}
else{
echo "<tr><td class=\"menu\"><a href=\"replys.php?id=$row[0]&cat=$row[2]\">$row2[0]</a></td><td class=\"menu\"> $datum<br></td></tr>";}
}
$test[$g]="$row[0]";
}
else{$i++;
if ($i=="20"){$g="5";}}
}
echo "</table>";
?>
dit scriptje geef fe laatse forum berichten hier heb ik de fout onderandere
p.s. dit is connect.php
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
2
3
4
5
6
7
8
9
10
11
12
13
<?
// mysql connectie
$user = "******";
$dbpass = "******";
$host = "*******";
$dbdb = "**********";
if (!mysql_select_db($dbdb, mysql_connect($host, $user, $dbpass)))
{
echo "Errow with Msql.";
exit();
}
?>
// mysql connectie
$user = "******";
$dbpass = "******";
$host = "*******";
$dbdb = "**********";
if (!mysql_select_db($dbdb, mysql_connect($host, $user, $dbpass)))
{
echo "Errow with Msql.";
exit();
}
?>
connect.php (verbeterd)
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
2
3
4
5
6
7
8
9
10
11
12
13
<?
# Zooi definen
$SQL['user'] = '...';
$SQL['pass'] = '...';
$SQL['host'] = '...';
$SQL['db'] = '...';
# Connecten met database
mysql_connect($SQL['host'],$SQL['user'],$SQL['pass']) or die('[1] » '.mysql_error());
# Database selecteren
mysql_select_db($SQL['db']) or die('[2] » '.mysql_error());
?>
# Zooi definen
$SQL['user'] = '...';
$SQL['pass'] = '...';
$SQL['host'] = '...';
$SQL['db'] = '...';
# Connecten met database
mysql_connect($SQL['host'],$SQL['user'],$SQL['pass']) or die('[1] » '.mysql_error());
# Database selecteren
mysql_select_db($SQL['db']) or die('[2] » '.mysql_error());
?>
Je gaf aan dat daar onder andere errors zitten. Nu hopelijk niet meer.
Die andere lap code is nogal onoverzichtelijk. Wat geeft ie voor errors?
er staatd in de mysql database als topics name: --[DAF]-- en er word weer gegeven op het script hierboevn --[DAF]-> en een beetje later op het forum staat dit --[DAF]-- als je het niet snapt http://www.che-lives-clan.com[/URL]
weet je zeker dat het geen cache was ofzo?