Bonger,
Are you using Apache with the Worker MPM? If so, that could be your
problem. It is fairly well documented and highly discussed that the Worker
MPM on *nix is not a good combination, as explained here:
http://us2.php.net/manual/en/faq.installation.php#faq.installation.apache2.
The problem is not the PHP core itself, but the third-party libraries that
may not be thread-safe. According to the link above, this is of much less
concern to those using Windows. But perhaps it's worth a try to switch to
the Prefork MPM and see if the symtpoms disappear.
Cheers,
Rich
On Sun, Jul 6, 2008 at 9:31 AM, Bradley Giesbrecht <[EMAIL PROTECTED]> wrote:
> With php when you include vars in double quotes don't you want to put curly
> braces around them like so?
>
> $query = "SELECT * FROM Pet WHERE petType='{$pettype}'";
>
> That's how I do it but I've been doing it so long I don't remember why.
>
> Anyway, I would guess this is a php issue and not an apache problem.
>
> Turn up your php error reporting. Off the top of my head something like
> this at the top of your script.
>
> error_reporting(E_ALL);
>
> php.net is your friend:
>
> http://php.net/while
>
> http://php.net/error_reporting
>
>
> //brad
>
>
>
> On Jul 5, 2008, at 10:55 AM, Bonger O wrote:
>
> Hi,
>>
>> I have set up an environment on my Vista laptop comprising of Apache 2.2,
>> MySQL Server 5.1 and Php 5.2.5.
>>
>> I'm using a simple php program that I found in a PHP/SQL book. The PHP
>> program queries a MySQL table and uses a WHILE loop to traverse the results
>> array of the query and display on screen. However, there seems to be a
>> problem with my environment and using a WHILE loop as every time I run the
>> program I get the error "Apache HTTP server stopped working and was closed".
>>
>> I have no problems using a FOR loop but every time I use a WHILE loop
>> Apache seems to crash. Please see below for the code I have used.
>>
>> I would be extremely for any suggestions of why this is happening and any
>> solutions offered.
>>
>> Thanks.
>>
>> <?php
>> /* Program: petDisplay.php
>> * Desc: Displays all pets in selected category.
>> */
>> ?>
>> <html>
>> <head><title>Pet Catalog</title></head>
>> <body>
>> <?php
>>
>> $user="root";
>> $host="localhost";
>> $password="PASSWORD";
>> $database = "am";
>> $cxn = mysqli_connect($host,$user,$password,$database)
>> or die ("couldn't connect to server");
>> $pettype = "horse"; //horse was typed in a form by user
>> $query = "SELECT * FROM Pet WHERE petType='$pettype'";
>> $result = mysqli_query($cxn,$query)
>> or die ("Couldn't execute query.");
>>
>> /*Display results in a table */
>> $pettype = ucfirst($pettype)."s";
>>
>> echo "<h1>$pettype</h1>";
>> echo "<table cellspacing='15'>";
>> echo "<tr><td colspan='3'><hr /></td></tr>";
>> while($row = mysqli_fetch_assoc($result))
>> {
>> extract($row);
>>
>> $f_price = number_format($price,2);
>> echo "<tr>\n
>> <td>$petName</td>\n
>> <td>$petDescription</td>\n
>> <td style='text-align: right'>\$$f_price</td>\n
>> </tr>\n";
>> echo "<tr><td colspan='3'><hr /></td></tr>\n";
>> }
>> echo "</table>\n";
>> ?>
>> </body></html>
>>
>>
>>
>>
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> " from the digest: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
