[Resolved] PHP/WAP problem

[mrbaseball34]

I've got this page and can't get it to display a DB result.
Should be a list of 35 teams and also show an edit for password
entry.

http://www.austinmetrobaseball.com/index.wml

You can test online using the "Wapalizer" at:
http://www.gelon.net/

Here is the source:

<?php
// contains db connection info
include '../dbconnect.inc';

mysql_pconnect($dbhost, $dbuser, $dbpw);

$sql = "SELECT `id`, `teamname` "
     . "FROM `teams` "
     . "WHERE `active` = 1 "
     . "ORDER BY `teamname`";

$query = mysql_query($sql);

Header("Content-type: text/vnd.wap.wml");
Header("Cache-Control: no-cache, must-revalidate");
Header("Pragma: no-cache");
echo ("<?xml version='1.0'?>");
?> 
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN"
    "http://www.wapforum.org/DTD/wml_1.1.xml" > 
  <wml> 
    <card id="card1" title="AMBL Games"> 
      <p>Select Team Name:</p>
<?php
echo ("      <p>);
echo ("        <select name='choice' title='AMBLGames' size='1'>");
while (list($id, $teamname)=$mysql_fetch_row($query))
{
    if ($id <> 36) 
    {  

       $str = "        <option value='";
       $str = $str.$id;
       $str = $str."'>";
       $str = $str.$teamname;
       $str = $str."</option>";
       echo ($str);
    }
}
echo ("        </select>");
echo ("      </p>");
echo ("      <p>Enter a password:</p>");
// Is this the right type to use here?
echo ("      <p><input type='text' name='pwd'></p>");
?>
      <p>
        <do type="text" label="Go"> 
          <go method="get" href="index2.wml#card2"> 
<?php
echo ("            <postfield name=\"$choice\" value=\"$"."$choice"."\"/>");
echo ("            <postfield name=\"pwd\" value=\"$pwd\"/>");
?>
          </go> 
        </do> 
      </p> 
    </card> 
  </wml>

[neerav]

Before you can fix the database query problem, you need to fix the output that's generated. Right now, part of the script's code is output. This results in an invalid query or no query at all.

Use the emulator at http://webcab.de/fetchpage.htm for debugging. I can't live without it.

[mrbaseball34]

This is the same code I use to build comboboxes in my other PHP scripts from my table.

[mrbaseball34]

Originally posted by neerav
Use the emulator at http://webcab.de/fetchpage.htm for debugging. I can't live without it.

BTW, do you know how that emulator is able to get the PHP code?
That would be bad if I had my DB connection info in there.

[neerav]

Because your web server is spitting it out! :bemused: There's no other way (that I know of). The emulator is just displaying what it's been served.

try changing "<?php" into simply "<?"

AHHHH! Wait! I just got it. Your web server isn't using php to parse the wml file. You need to add .wml parsed by php to the apache types.

Or if you don't want EVERY wml file parsed by php, then just change the name of the current file from index.wml to index.php

By the way, line 25 is missing an end quotation mark.

After all this is done, we can help you on your db query! 😃

[mrbaseball34]

Current code:

<?php
Header("Content-type: text/vnd.wap.wml");
Header("Cache-Control: no-cache, must-revalidate");
Header("Pragma: no-cache");
?> 
<?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN"
    "http://www.wapforum.org/DTD/wml_1.1.xml" > 
  <wml> 
    <card id="card1" title="Games"> 
      <p>Select Team Name:</p>
      <p>
      <select name="choice" title="AMBLGames" size="1">
<?php
// contains db connection info
include '../dbconnect.inc';

mysql_pconnect($dbhost, $dbuser, $dbpw);

$sql = "SELECT id, teamname FROM teams WHERE active = 1 ORDER BY teamname";

$query = mysql_query($sql);
if (isset($query)) {
while (list($id, $teamname) = $mysql_fetch_row($query)) {
    if ($id <> 36) {  

       $str = "        <option value='".$id."'>".$teamname."</option>";
       echo ($str);
    }
}
} else {
echo 'Bullshit';
}
?>
        </select>
        </p>
        <p>
        Password: <input name="pwd" title="pwd" type="password"/>
        <do type="text" label="Go"> 
          <go method="get" href="index2.wml#card2"> 
<?php
echo ("            <postfield name=\"$choice\" value=\"$"."$choice"."\" />");
echo ("            <postfield name=\"$pwd\" value=\"$pwd\" />");
?>
          </go> 
        </do> 
      </p> 
    </card> 
  </wml>

renders:
Select Team Name:
36) {
$str = " ".$teamname."";
echo ($str);
}
}
} else {
echo 'Bullshit';
}
?>
Password:

I can see a combo with the words
".$teamname."

and I can also see the password edit.

[mrbaseball34]

Originally posted by neerav

After all this is done, we can help you on your db query! 😃

There is nothing wrong with the query. It is putting out the corect
data when I run it from a PHP page.

[neerav]

Sorry, I meant to say your db" results".

As I said before, your webserver (apache) isn't seeing your index.wml file as a php script. THAT needs to be fixed first, before changing any more code.

Simply renaming index.wml to index.php would work, but I see that you already have another script named index.php.

Either rename your wml file with a .php ending OR configure Apache to parse wml as php.

[mrbaseball34]

Ok, I had to add some stuff to my .htaccess file to get PHP to
parse the WML.

The reason I wasn't getting any DB results was because I wasn't
selecting a database.

Anyway I got it working, thanks for your help, If I have any more
questions, I'll be sure to ask.