Estrazione non riuscita dal db
Ciao a tutti, fresco fresco dal ritorno di una breve punizione :mrgreen: ho rimesso mano al mio sito che sto finendo.
Finendo la pagina delgli album (ringrazio alemoppo per l'aiuto), mi sono imbattuto in un problema di estrazione dal db.
Il codice è il seguente, il server non stampa nessun errore.
Codice PHP:
<!DOCTYPE html>
<?php
if(!$_COOKIE['user']) {
header("Location: index.html");
}
@require_once("/membri/edoardosavinientertainme/inc/config.inc.php");
connect();
session_start();
$id = $_COOKIE['user'];
$query_name = @mysql_query("SELECT * FROM utenti WHERE id = '$id'");
$name_fetch = mysql_fetch_array($query_name);
$firstname = $name_fetch['nome'];
?>
<html>
<head>
<title>Polaroid</title>
<link type="text/css" rel="stylesheet" media="all" href="/css/reset.css" />
<link type="text/css" rel="stylesheet" media="all" href="/css/font.css" />
<link type="text/css" rel="stylesheet" media="all" href="/css/screen_polaroid.css" />
<meta charset="UTF-8">
<style type="text/css">
#blank400 { height: 400px; width: 100%; }
#boxCreate { height: 25px; width: 237.5px; border: 1px solid #0066af; line-height: 25px; text-align: center; }
#boxCreate { background: linear-gradient(#0096ff, #0066af); background: -webkit-linear-gradient(#0096ff, #0066af); background: -moz-linear-gradient(#0096ff, #0066af); background: -o-linear-gradient(#0096ff, #0066af); }
#boxCreate:hover { background: linear-gradient(#57b9ff 0%, #0369b2 100%); background: -webkit-linear-gradient(#57b9ff 0%, #0369b2 100%); background: -moz-linear-gradient(#57b9ff 0%, #0369b2 100%); background: -o-linear-gradient(#57b9ff 0%, #0369b2 100%); }
.linkByLink { color: #fff; font-family: wf_SegoeUI, Arial, Helvetica, sans-serif; }r
#album { margin: 0 auto; text-align: center; }
</style>
</head>
<body>
<div id="header">
<div id="logoArea">
<a href="/polaroid/index.html"><img src="/images/logo_polaroid.png" alt="Polaroid"/></a>
</div>
<div id="nav">
<ul>
<li><a href="myprofile.php" id="left"> Home </a></li>
<li><a href="login.php?a=logout" id="right"> Esci </a></li>
</ul>
</div>
</div>
<div id="content">
<h1>I tuoi album</h1>
<div id="blank10"></div>
<div id="boxCreate">
<a href="createalbum.php" class="linkByLink">Crea un nuovo album</a>
</div>
<div id="blank40"></div>
<div id="album">
<?php
$id = $_COOKIE['user'];
$query_album = mysql_query("SELECT * FROM album WHERE id_utente = '$id'");
$count_album = mysql_num_rows($query_album);
$row = mysql_fetch_array($query_album);
if($count_album == 0) {
echo '<p><span class="noAlbum">Ci dispiace, ma non hai album.</span></p>';
} else {
while($row = mysql_fetch_array($query_album)) {
$name = $row['nome'];
$id_album = $row['id'];
echo '<div id="album_box">';
echo '<a href="myphoto.php?id='.$id_album.'">'.$name.'</a>';
echo '</div>';
$i = 0;
if(!($i++%3)) {
echo '<br />';
}
}
}
?>
</div>
</div>
<div id="blank400"></div>
<div id="footer">
<div id="like">
<div id="fb-root"></div>
<script>(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = "//connect.facebook.net/it_IT/all.js#xfbml=1&appId=249881301821284";
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>
<div class="fb-like" data-href="http://edoardosavinientertainme.altervista.org/polaroid/" data-send="false" data-layout="button_count" data-width="450" data-show-faces="true" data-font="segoe ui"></div>
<script type="text/javascript" src="https://apis.google.com/js/plusone.js"> {lang: 'it'} </script>
<div class="g-plusone" data-href="http://edoardosavinientertainme.altervista.org/"></div>
</div>
<div id="hr"></div>
<p>Polaroid è un marchio di PLR IP Holdings, LLC. Copyright 2013 Edoardo Savini e PLR IP Holdings, LLC. Tutti i diritti riservati.</p>
<div id="hr"></div>
</div>
</body>
</html>
