Къде е грешката?!

Prolux · 1 Юни 2011

Къде има грешки?

PHP:

<TABLE width='100%' border='0px' align='center' cellspacing="1" cellpadding="1">
<tr>
<td style="padding:3px;background:#ccc;border:1px solid #ccc;color:#000;"><center>Име</td>
<td style="padding:3px;background:#ccc;border:1px solid #ccc;color:#000;"><center>Емайл</td>
<td style="padding:3px;background:#ccc;border:1px solid #ccc;color:#000;"><center>Скайп</td>
</tr>
<?php
include('connect.php');
$broinastranica =25; 
$pageNum = 1; 
$cat = $_GET['cat'];
$pagecat = (isset($cat)) ? "cat=$cat&":"";
if(isset($_GET['page'])) 
{ 
$pageNum = $_GET['page']; 
} 
$redove = ($pageNum - 1) * $broinastranica; 
if(isset($cat) && $cat != ""){
$obshto = "SELECT * FROM users WHERE cat='$cat'";
}
else {
$obshto = "SELECT * FROM users";
}
$results = mysql_query($obshto);
$count = mysql_num_rows($results);
if(isset($cat) && $cat != ""){
$db = ("SELECT * FROM users WHERE cat='$cat' ORDER BY id DESC LIMIT $redove, $broinastranica");
}
else {
$db = ("SELECT * FROM users ORDER BY id DESC LIMIT $redove, $broinastranica");
}
$results = mysql_query($db)or die(mysql_error());
while($row = mysql_fetch_array($results)){
$username = $row['username'];
$email = $row['email'];
$skype = $row['skype'];
$cat = $row['cat'];
$date = $row['date'];
$id = $row['id'];
$vic2 = strlen($vic) > 15 ? substr($vic,0,20) . "...<a href=read.php?id=$id>Преглед</a>" : $vic;
if($avtor == NULL){
$avtor = "ne e vuveden";
}
else {
$avtor = $row['avtor'];
}
echo "
<TR valign=top>
<TD style='padding:4px;background:#fff;border:1px solid #ccc;'>
<center><a href=read.php?id=$id>$username</a>
</TD>
<TD style='padding:4px;background:#fff;border:1px solid #ccc;color:#000;'>
<center> $email
</TD>
<TD style='padding:4px;background:#fff;border:1px solid #ccc;color:#000;'>
<center> $skype
</TD>
</TR>

";
}
echo '</TABLE><br>';
if(isset($_GET['cat'])){
$query = "SELECT COUNT(id) AS numrows FROM users WHERE cat='$cat'";
}
elseif(!isset($_GET['cat'])){
$query = "SELECT COUNT(id) AS numrows FROM users";
}
$result = mysql_query($query) or die('Error, query failed'); 
$row = mysql_fetch_array($result, MYSQL_ASSOC); 
$numrows = $row['numrows']; 
$maxPage = ceil($numrows/$broinastranica); 
$nomeranastranici = ''; 
for($page = 1; $page <= $maxPage; $page++) 
{ 
if ($page == $pageNum) 
{ 
$nomeranastranici .= " $page "; 
} 
else 
{ 
$nomeranastranici .= " <a href=\"$self?".$pagecat."page=$page\">$page</a> "; 
} 
} 
if ($pageNum > 1) 
{ 
$page = $pageNum - 1; 
$predishna = " <a href=\"$self?".$pagecat."page=$page\"> [<<] </a> "; 

$parva = " <a href=\"$self?".$pagecat."page=1\">[първа]</a> "; 
} 
else 
{ 
$predishna = ' '; 
$parva = ' '; 
} 

if ($pageNum < $maxPage) 
{ 
$page = $pageNum + 1; 
$sledvashta = "<a href=\"$self?".$pagecat."page=$page\"> [>>] </a> "; 

$posledna = " <a href=\"$self?".$pagecat."page=$maxPage\">[последна]</a> "; 
} 
else 
{ 
$sledvashta = ' '; 
$posledna = ' '; 
} 
echo "</div><div id='centerf'>$parva  $predishna  $nomeranastranici  $sledvashta  $posledna</div>";
?>


	</td>
    </tr>
</table>

Дава грешки в:

Notice: Undefined index: cat in C:\xampp\htdocs\sss\members.php on line 11

Notice: Undefined index: cat in C:\xampp\htdocs\sss\members.php on line 37

Notice: Undefined index: date in C:\xampp\htdocs\sss\members.php on line 38

Notice: Undefined variable: vic in C:\xampp\htdocs\sss\members.php on line 40

Notice: Undefined variable: vic in C:\xampp\htdocs\sss\members.php on line 40

Notice: Undefined variable: avtor in C:\xampp\htdocs\sss\members.php on line 41

Notice: Undefined index: cat in C:\xampp\htdocs\sss\members.php on line 37

Notice: Undefined index: date in C:\xampp\htdocs\sss\members.php on line 38

Notice: Undefined variable: vic in C:\xampp\htdocs\sss\members.php on line 40

Notice: Undefined variable: vic in C:\xampp\htdocs\sss\members.php on line 40

Notice: Undefined index: avtor in C:\xampp\htdocs\sss\members.php on line 45

Notice: Undefined index: cat in C:\xampp\htdocs\sss\members.php on line 37

Notice: Undefined index: date in C:\xampp\htdocs\sss\members.php on line 38

Notice: Undefined variable: vic in C:\xampp\htdocs\sss\members.php on line 40

Notice: Undefined variable: vic in C:\xampp\htdocs\sss\members.php on line 40

Notice: Undefined index: cat in C:\xampp\htdocs\sss\members.php on line 37

Notice: Undefined index: date in C:\xampp\htdocs\sss\members.php on line 38

Notice: Undefined variable: vic in C:\xampp\htdocs\sss\members.php on line 40

Notice: Undefined variable: vic in C:\xampp\htdocs\sss\members.php on line 40

Notice: Undefined index: avtor in C:\xampp\htdocs\sss\members.php on line 45

Notice: Undefined index: cat in C:\xampp\htdocs\sss\members.php on line 37

Notice: Undefined index: date in C:\xampp\htdocs\sss\members.php on line 38

Notice: Undefined variable: vic in C:\xampp\htdocs\sss\members.php on line 40

Notice: Undefined variable: vic in C:\xampp\htdocs\sss\members.php on line 40

kopura · 1 Юни 2011

Това не са грешки а забележки. Дава ти ги заштото $_GET променливите ти са празни по някаква причина. Това не пречи на скрипта по никакъв начин. В такъв случай пред проблемните $_GET или $_POST променливи слагам @ например

PHP:

@$cat = $_GET['cat'];

и така пред всички на съответните редове.

tedo96 · 1 Юни 2011

Или направи просто да не ти се показват Notice.

Ev0luti0N · 1 Юни 2011

Така мисля, че ще потръгне:

PHP:

<TABLE width='100%' border='0px' align='center' cellspacing="1" cellpadding="1">
<tr>
<td style="padding:3px;background:#ccc;border:1px solid #ccc;color:#000;"><center>Име</td>
<td style="padding:3px;background:#ccc;border:1px solid #ccc;color:#000;"><center>Емайл</td>
<td style="padding:3px;background:#ccc;border:1px solid #ccc;color:#000;"><center>Скайп</td>
</tr>
<?php
include('connect.php');
$broinastranica =25; 
$pageNum = 1; 
$cat = (isset($_GET['cat']) ? $_GET['cat'] : '');
$pagecat = (isset($cat)) ? "cat=$cat&":"";
if(isset($_GET['page'])) 
{ 
$pageNum = $_GET['page']; 
} 
$redove = ($pageNum - 1) * $broinastranica; 
if(isset($cat) && $cat != ""){
$obshto = "SELECT * FROM users WHERE cat='$cat'";
}
else {
$obshto = "SELECT * FROM users";
}
$results = mysql_query($obshto);
$count = mysql_num_rows($results);
if(isset($cat) && $cat != ""){
$db = ("SELECT * FROM users WHERE cat='$cat' ORDER BY id DESC LIMIT $redove, $broinastranica");
}
else {
$db = ("SELECT * FROM users ORDER BY id DESC LIMIT $redove, $broinastranica");
}
$results = mysql_query($db)or die(mysql_error());
while($row = mysql_fetch_array($results)){
$username = $row['username'];
$email = $row['email'];
$skype = $row['skype'];
$cat = (isset($row['cat']) ? $row['cat'] : '');
$date = (isset($row['date']) $row['date'] : '');
$id = $row['id'];
$vic = (isset($vic) ? strlen($vic) : '');
$vic2 = $vic > 15 ? substr($vic,0,20) . "...<a href=read.php?id=$id>Преглед</a>" : $vic;
if($row['avtor'] == NULL){
$avtor = "ne e vuveden";
}
else {
$avtor = $row['avtor'];
}
echo "
<TR valign=top>
<TD style='padding:4px;background:#fff;border:1px solid #ccc;'>
<center><a href=read.php?id=$id>$username</a>
</TD>
<TD style='padding:4px;background:#fff;border:1px solid #ccc;color:#000;'>
<center> $email
</TD>
<TD style='padding:4px;background:#fff;border:1px solid #ccc;color:#000;'>
<center> $skype
</TD>
</TR>

";
}
echo '</TABLE><br>';
if(isset($_GET['cat'])){
$query = "SELECT COUNT(id) AS numrows FROM users WHERE cat='$cat'";
}
elseif(!isset($_GET['cat'])){
$query = "SELECT COUNT(id) AS numrows FROM users";
}
$result = mysql_query($query) or die('Error, query failed'); 
$row = mysql_fetch_array($result, MYSQL_ASSOC); 
$numrows = $row['numrows']; 
$maxPage = ceil($numrows/$broinastranica); 
$nomeranastranici = ''; 
for($page = 1; $page <= $maxPage; $page++) 
{ 
if ($page == $pageNum) 
{ 
$nomeranastranici .= " $page "; 
} 
else 
{ 
$nomeranastranici .= " <a href=\"$self?".$pagecat."page=$page\">$page</a> "; 
} 
} 
if ($pageNum > 1) 
{ 
$page = $pageNum - 1; 
$predishna = " <a href=\"$self?".$pagecat."page=$page\"> [<<] </a> "; 

$parva = " <a href=\"$self?".$pagecat."page=1\">[първа]</a> "; 
} 
else 
{ 
$predishna = ' '; 
$parva = ' '; 
} 

if ($pageNum < $maxPage) 
{ 
$page = $pageNum + 1; 
$sledvashta = "<a href=\"$self?".$pagecat."page=$page\"> [>>] </a> "; 

$posledna = " <a href=\"$self?".$pagecat."page=$maxPage\">[последна]</a> "; 
} 
else 
{ 
$sledvashta = ' '; 
$posledna = ' '; 
} 
echo "</div><div id='centerf'>$parva  $predishna  $nomeranastranici  $sledvashta  $posledna</div>";
?>


        </td>
    </tr>
</table>

Къде е грешката?!

Prolux

Registered

kopura

Registered

tedo96

Registered

Ev0luti0N

Registered