Undelig løkke ved udtræk af mysql db med mysqli (oo-aproach)
HejsaJeg har understående kode. Den resulterer dog i en evig løkke men det forstår jeg ikke lige hvorfor(se også resultat nedenfor) - håber nogen kan forklare. Der er kun en række i den tabel udtrække laves fra.
Kode:
<html>
<head>
<title>Problem Set 8 - Commentary Service—database transactions via web forms/title>
<link rel="stylesheet" type="text/css" href="../common.css" media="screen" />
</head>
<body>
<div id="banner">
<?php require("../banner.php"); ?>
</div>
<div id="indhold">
<h1>Problem Set 8 - Commentary Service—database transactions via web forms</h1>
<?php
ps8_getCom();
function ps8_getCom() {
$db = db_connect();
$qResult = db_query("SELECT id, url, insertdate, name, email, text FROM Comments WHERE url like 'http://www.itu.dk%'", $db);
echo "antal: $qResult->num_rows";
//$res = new array();
$n = $qResult->num_rows;
for($i=0; i<$n; $i++) {
$row = $qResult->fetch_assoc();
echo '<p>'+$i;
echo htmlspecialchars(stripslashes($row['url']));
echo '</p>';
$res[$i] = $row;
}
db_freeResult($qResult);
db_closeConnection($db);
echo 'Done';
}
function error($msg){
echo '<p>'.$msg.'</p>';
}
function db_connect() {
@ $db = new mysqli('localhost', 'torben', 'skidefrans', 'W2_F2006_trp');
if(mysqli_connect_errno()) {
error("Could not connect to database");
}
return $db;
}
function db_query($sql, $db) {
return $db->query($sql);
}
function db_freeResult($result) {
$result->free();
}
function db_closeConnection($db) {
$db->close();
}
?>
aa
</div>
</body>
</html>
resultat:
<html>
<head>
<title>Problem Set 8 - Commentary Service—database transactions via web forms/title>
<link rel="stylesheet" type="text/css" href="../common.css" media="screen" />
</head>
<body>
<div id="banner">
<table width="100%">
<tr>
<td align="left"><h3 class="obs red">Torben Pedersen</h3></td>
<td align="center"><h3 class="obs red">W2</h3></td>
<td align="right"><a href=mailto:trp@itu.dk><h3 class="obs red">trp@itu.dk</a></h3></td>
</tr>
</table> </div>
<div id="indhold">
<h1>Problem Set 8 - Commentary Service—database transactions via web forms</h1>
antal: 10http://www.itu.dk/people/trp/w2/index.html</p>1</p>2</p>3</p>4</p>5</p>6</p>7</p>8</p>9</p>10</p>11</p>12</p>13</p>14</p>15</p>16</p>17</p>18.... osv...
