server crashes

dominant

When i execute a php file the server stucks 🙁

What is wrong?

cyclops

Your question sounds like :
When I execute the coffeemachine it gives me cappucino.
What is wrong ?

More details plz, like OS, kind of script, etc

dominant

Although it works properly, however, it fails to load a script that read a table from the database(10 fields).

My OS win2k and i run php 4.2.3 Apache 1.3.28

Here is the script

<? session_start();
if($_SESSION['id']) {include("db_name.php");include("format_text.php");
mysql_connect(server,username,password);mysql_select_db(db_name);
$user_id=$_SESSION['id'];
$result=mysql_query("SELECT username FROM users WHERE userid=$user_id");
$user_element=mysql_fetch_assoc($result);?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-7">
<meta name="Generator" content="Dev-PHP 1.9.4">
<title>Document Title</title>
<script language="javascript">
function check() {

var reply=confirm("ÈÝëåôå ïðùóäÞðïôå íá êÜíåôå ôç äéáãñáöÞ?");

return reply;}

</script>


<link rel="stylesheet" href="dark_grey.css" type="text/css">


</head>
<body class="right_table" bgcolor="#999999" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
<? if($true=mysql_num_rows(mysql_query("SELECT userid FROM users WHERE userid='$user_id' AND user_level='2'"))) {?>
<?

echo "<center>ÐñïâïëÞ Ëßóôáò Áíáêïéíþóåùí <br><br>";?>
<a href=admin_user_place.php>ÅðéóôñïöÞ óôïí ðßíáêá åëÝã÷ïõ</a></center><br>

<center>
<table class="right_table" border=1><tr><td colspan=3 align=center>
Ôáîéíüìçóç</td></tr><tr><td>
<?php
switch($_GET[order]) {
case 1:
echo "
<a href=admin_text_post.php?order=3>¼ëåò</a></td><td>
<a href=admin_text_post.php?order=2>ÖáíåñÝò</a></td><td>
<a href=admin_text_post.php?order=1><font color=black><b>ÊñõöÝò</b></font></a></td></tr>
</table></center>
<hr>";
break;

case 2:
echo "<a href=admin_text_post.php?order=3>¼ëåò</a></td><td>
<a href=admin_text_post.php?order=2><font color=black><b>ÖáíåñÝò</b></font></a></td><td>
<a href=admin_text_post.php?order=1>ÊñõöÝò</a></td></tr>
</table></center>
<hr>";
break;

default:
echo "<a href=admin_text_post.php?order=3><font color=black><b>¼ëåò</b></font></a></td><td>
<a href=admin_text_post.php?order=2>ÖáíåñÝò</a></td><td>
<a href=admin_text_post.php?order=1>ÊñõöÝò</a></td></tr>
</table></center>
<hr>";
break;
}



if(!$_GET[page]) {

switch($_GET[order]) {

case 1:
$rows_number=mysql_result(mysql_query("SELECT COUNT(postid) FROM post WHERE display=0"),0);
$pages=ceil($rows_number/20);
break;

case 2:
$rows_number=mysql_result(mysql_query("SELECT COUNT(postid) FROM post WHERE display=1"),0);
$pages=ceil($rows_number/20);
break;

default:
$rows_number=mysql_result(mysql_query("SELECT COUNT(postid) FROM post"),0);
$pages=ceil($rows_number/20);
break;}
}


if($rows_number>20&&(!$_GET[page])) {
echo "<center>Óåëßäá 1</center>";

switch($_GET[order]) {

case 1:
$result=mysql_query("SELECT *,DATE_FORMAT(date_posted, '%e-%m-%Y')AS date_posted,DATE_FORMAT(expire_date, '%e-%m-%Y')AS expire_date FROM post WHERE display=0 ORDER BY postid DESC LIMIT 0,20");

break;

case 2:
$result=mysql_query("SELECT *,DATE_FORMAT(date_posted, '%e-%m-%Y')AS date_posted,DATE_FORMAT(expire_date, '%e-%m-%Y')AS expire_date FROM post WHERE display=1 ORDER BY postid DESC LIMIT 0,20");

break;

default:
$result=mysql_query("SELECT *,DATE_FORMAT(date_posted, '%e-%m-%Y')AS date_posted,DATE_FORMAT(expire_date, '%e-%m-%Y')AS expire_date FROM post ORDER BY postid DESC LIMIT 0,20");

break;
}
}


elseif($_GET[page]) {

echo "<center>Óåëßäá $_GET[page]</center>";

$each_page=$_GET[page]*20-20;

switch($_GET[order]) {

case 1:
$result=mysql_query("SELECT *,DATE_FORMAT(date_posted, '%e-%m-%Y')AS date_posted,DATE_FORMAT(expire_date, '%e-%m-%Y')AS expire_date FROM post WHERE display=0 ORDER BY postid DESC LIMIT $each_page,20");

break;

case 2:
$result=mysql_query("SELECT *,DATE_FORMAT(date_posted, '%e-%m-%Y')AS date_posted,DATE_FORMAT(expire_date, '%e-%m-%Y')AS expire_date FROM post WHERE display=1 ORDER BY postid DESC LIMIT $each_page,20");

break;


default:
$result=mysql_query("SELECT *,DATE_FORMAT(date_posted, '%e-%m-%Y')AS date_posted,DATE_FORMAT(expire_date, '%e-%m-%Y')AS expire_date FROM post ORDER BY postid DESC LIMIT $each_page,20");

}
}





else {

switch($_GET[order]){

case 1:
$result=mysql_query("SELECT *,DATE_FORMAT(date_posted, '%e-%m-%Y')AS date_posted,DATE_FORMAT(expire_date, '%e-%m-%Y')AS expire_date FROM post WHERE display=0 ORDER BY postid DESC");

break;

case 2:
$result=mysql_query("SELECT *,DATE_FORMAT(date_posted, '%e-%m-%Y')AS date_posted,DATE_FORMAT(expire_date, '%e-%m-%Y')AS expire_date FROM post WHERE display=1 ORDER BY postid DESC");

break;

default:

$result=mysql_query("SELECT *,DATE_FORMAT(date_posted, '%e-%m-%Y')AS date_posted,DATE_FORMAT(expire_date, '%e-%m-%Y')AS expire_date FROM post ORDER BY postid DESC");

}
}



$counter=0;


echo "<DIV ALIGN=CENTER> <TABLE WIDTH=100% HEIGHT=AUTO border=1 bordercolor='#666666'><TR class='general'><TD align=center VALIGN=baseline><b> Ôñïðïðïßçóç </b></TD><TD align=center VALIGN=baseline><b> ÄéáãñáöÞ </b></TD><TD align=center VALIGN=baseline><b> ÅìöÜíéóç </b></TD><TD align=center VALIGN=baseline><b> Êùä. Áíáê </b></TD><TD align=center VALIGN=baseline><b> ×ñÞóôçò </b> </TD><TD align=center VALIGN=baseline><b> Êáôçãïñßá </b></TD><TD align=center VALIGN=baseline><b> Ôßôëïò </b></TD><TD align=center VALIGN=baseline><b> Ó÷åôéêü Link </b></TD><TD align=center VALIGN=baseline><b> Åéêüíá </b></TD><TD align=center VALIGN=baseline><b> Çì. Äçì. </b></TD><TD align=center VALIGN=baseline><b> Çì. Ëçî. </b></TD><TD align=center VALIGN=baseline><b> ÐñïâïëÞ </b></TD><TD align=center VALIGN=baseline><b> Ðñüóâáóç </b></TD></TR>";
while($row=mysql_fetch_assoc($result)) {

if(!empty($row['image'])) {$pic="<img src=images/".$row['image']." height=50 width=50>";$photo="<center><a href='admin_delete_image.php?post_id=".$row['postid']."&type=$_GET[type]&page=$_GET[page]&route=1&order=$_GET[order]' onClick='return check()'>ÄéáãñáöÞ åéêüíáò</a><br></center>".$pic; } else  {$photo="No Photo Here";}

switch($row['display']) {
case 0: $display="<img src='no.gif' border=0>";
break;
case 1: $display="<img src='yes.gif' border=0>";
break;
}

switch($row['protected']) {
case 0: $protected="<img src='unlocked.gif' border=0>";
break;
case 1: $protected="<img src='locked.gif' border=0>";
break;
}

$category=mysql_fetch_assoc(mysql_query("SELECT category FROM category c, post p WHERE c.categoryid=p.categoryid AND p.categoryid='$row[categoryid]'"));

$each_userid=$row['userid'];
$result1=mysql_query("SELECT username FROM users WHERE userid ='$each_userid'");
$each_username=mysql_fetch_assoc($result1);

if(!empty($row['relevant_link'])) {$row['relevant_link']="<a href='$row[relevant_link]' target=_blank><img src=link.gif border=0></a>";}

if($counter%2) {$class="right_table";} else {$class="dark_grey";}
echo "<TR class='$class'><TD align=center VALIGN=center ><a href='admin_user_edit_post.php?post_id=".$row['postid']."&page=$_GET[page]&order=$_GET[order]'><img src=edit.gif border=0></a></TD><TD align=center VALIGN=center ><a href='admin_user_delete_post.php?post_id=".$row['postid']."&page=$_GET[page]&order=$_GET[order]' onClick='return check()'><img src=delete.gif border=0></a></TD><TD align=center VALIGN=center ><a href='admin_show_post.php?post_id=".$row['postid']."&page=$_GET[page]&order=$_GET[order]'><img src=preview.gif border=0></a></TD><TD align=center VALIGN=center > $row[postid] </TD> <TD align=center VALIGN=center > $each_username[username] </TD><TD align=center VALIGN=center > $category </TD><TD align=center VALIGN=center > $row[title] </TD><TD align=center VALIGN=center > $row[relevant_link] </TD><TD align=center VALIGN=center > $photo </TD><TD align=center VALIGN=center >$row[date_posted]</TD><TD align=center VALIGN=center nowrap> $row[expire_date] </TD>
<TD align=center VALIGN=center nowrap><a href='admin_change_display.php?post_id=".$row['postid']."&page=$_GET[page]&route=1&order=$_GET[order]'>$display</a></TD><TD align=center VALIGN=center><a href='admin_change_protected.php?post_id=".$row['postid']."&page=$_GET[page]&route=1&order=$_GET[order]'>$protected</a></TD></TR>";
$counter++;
}



echo "</TABLE> </DIV>";

switch($_GET[order]) {

case 1:
$rows_number=mysql_result(mysql_query("SELECT COUNT(postid) FROM post WHERE display=0"),0);
$pages=ceil($rows_number/20);
break;

case 2:
$rows_number=mysql_result(mysql_query("SELECT COUNT(postid) FROM post WHERE display=1"),0);
$pages=ceil($rows_number/20);
break;

default:
$rows_number=mysql_result(mysql_query("SELECT COUNT(postid) FROM post"),0);
$pages=ceil($rows_number/20);
break;
}

echo "<center>";
if($rows_number>20||$_GET[page]) {$before=$_GET['page']-1;

if(!$_GET['page']) {$after=2;} else {$after=$_GET['page']+1;}

if($_GET['page']>1) {
echo "|<a href='admin_text_post.php?page=$before&order=$_GET[order]'>Ðñïçãïýìåíï</a>| ";}

for($i=1;$i<=$pages;$i++) {echo "|<a href='admin_text_post.php?page=$i&order=$_GET[order]'>$i</a>| ";}

if($_GET['page']!=$pages) {
echo "|<a href='admin_text_post.php?page=$after&order=$_GET[order]'>Åðüìåíï</a>| ";}


}
echo "</center>";

mysql_close();
 } else { echo "Äåí åðéôñÝðåôáé ç ðñüóâáóç";} ?>

</body>
</html><?}
else echo "Authentication Required";?>

dominant

could it be a mysql misconfiguration or a php misconfiguration regarding the mysql?

cyclops

do you get any errors returned ?
if so, plz post them here.
if not, plz do following

open DOS-prompt
execute your script from the prompt, e.g. :
c:\php\php.exe name_of_script.php

this way you can see exactly what happens and php.exe will show you errors in the DOS-prompt

axo

and please rethink your coding-style. it's no great wonder that php crashes.

first: read this one.

there is so much redundancy in your code, so many if - for- and switch-clauses, that you always will have problems with not finding your errors. why, for example, do you switch $_GET['order'] so many times? i've counted 4 until now.
switch on your warnings (with error_reporting(8); )and correct your code so long until you don't even get notices reported !

always indent your code, tab-spaces are NOT useless.
don't make too big "{}" - brackets - you make everything unreadable

example:

/** your code */
if(!$_SESSION[id]) {
// here's your whole code


// ... until your last lines look like this:
} else {
echo "authorisation required";
}

/** much better, but still not perfect after all */
if(!$_SESSION['id']) {
die("authorisation required");
}
// the whole code continues here.

think that with so many variables you spoil your whole namespace of variables and make your code very buggy. work with arrays, or better, work object oriented.

try to make differences between html and php - don't mix it up like you do in this line...

and these were only the first few tips.

dominant

The script i posted works fine on every system except for mine.

I feel that its a misconfiguration matter,but i don't know what to configure first 🙁