Need another pair of eyes:

[timstring]

Here's the scripts I have been working on for half a day.

<?php


$host="localhost";
$user="root";
$password="password";
$Dbname = "calls_to_dispatch";

$mysqli = new mysqli($host, $root, $password, $Dbname);


if (mysqli_connect_error()) {
    die('Connect Error (' . mysqli_connect_errno() . ') '
            . mysqli_connect_error());
}


?>

<?php

echo '<form name="SystemForm" method="post" action = "Splash.php">';
echo '<select name="SystemNumForm" size="8" multiple="multiple" style="text-align:left;" onChange = "loadXMLDoc(this.value)">';
echo '<option value = "0">All Systems In Texoma</option>';


if (!$mysqli->query("SELECT SystemNum, LongSystem FROM Systems")) {
    printf("Errormessage: %s\n", $mysqli->error);
	die();
}


$SystemResult = $mysqli->query("SELECT SystemNum, LongSystem FROM Systems ORDER BY LongSystem");
		{
		 while ($row = $SystemResult->fetch_assoc()) {
				$SystemNum = $row['SystemNum'];
				$LongSystem = $row['LongSystem'];

			echo '<option value = "' . $SystemNum . '">' . $LongSystem . '</option>';

		}
	}

echo '</select>';

I am not getting any errors, but the output is garbled:

'; echo ''; //echo ''; if (!$mysqli->query("SELECT SystemNum, LongSystem FROM Systems")) { printf("Errormessage: %s\n", $mysqli->error); die(); } $SystemResult = $mysqli->query("SELECT SystemNum, LongSystem FROM Systems"); { while ($row = $SystemResult->fetch_assoc()) { $SystemNum = $row['SystemNum']; $LongSystem = $row['LongSystem']; echo ''; } } echo ''; ?>

I have absolutely no clue where the

; echo ''; //echo '';

came from, and also the same at the end of the statement.

What am I missing?

[bradgrafelman]

Two questions:

1. Did you give these two files the proper file extension (e.g. .php) that your webserver is configured to pass to the PHP interpreter?

2. Is what you posted the actual output, or is that just some rendered version of the output (e.g. something a web browser produced)? If it's the latter, try examining the actual output (e.g. viewing the "source" of the rendered page your browser is displaying).

   It seems like the PHP interpeter is being bypassed altogether (hence why I asked question #1 above).

EDIT: Also, you might want to obfuscate your SQL credentials in the future before posting them on a public forum.

[dalecosp]

And what does loadXML doc do?

Just wondering ... IIRC, XML docs start with a [noparse]<?[/noparse] ... Might that be causing issues? Wouldn't seem likely, as that's in JS (and ostensibly the DOM after rendering ... but ... )

[timstring]

Yes, the file extension is '.php'. What I posted was from Safari's output. I don't see anything unusual in the source code. However, when I call up the page in Chrome, I get:

' . $LongSystem . '

which would put the problem here:

	echo '<option value = "' . $SystemNum . '">' . $LongSystem . '</option>';

Again, the source code looks just like the original script.

FYI: this is from an old script I wrote. All I did was update to the mysqli statements. The original script works, even though out-dated.

[bradgrafelman]

timstring;11030111 wrote:

Again, the source code looks just like the original script.

This is what I was getting at: you're seeing PHP source code exactly as it was written even when viewing the output as sent by your webserver.

This suggests that the webserver never even invoked the PHP interpreter, which suggests that you've got some sort of configuration (or lack thereof) problem. Have you verified PHP works at all on this webserver? For example, can you create a "phpinfo.php" file that contains nothing but:

<?php
phpinfo();

, browse to it via your web browser, and successfully receive the PHP info printout?

[timstring]

Yes, the little script says that I'm running PHP 5.3.15, and the source code is mammoth. I upgraded to 5.4, and I verified that 5.4.16 resides in /usr/local/php. However, the info script still returns 5.3.15.

Have I verified that PHP works on my server? Multiple and multiple times a day for many, many, moons, with more than a few scripts. This is the only script I've had with this sort of trouble.

Don't ask me how or why, the script is now functioning