WML PHP and MySQL

[rmill9681]

I am trying to access a database through a cell phone. First page you enter a name to search for. This returns results on a second page.

I am able to enter a search name and it returns incorrect results from the database because for some reason the input parameter is not getting passed from the main wml page to the php code.

Here is the first page

<?php

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="search" title="SaintSearch">
<p> 
  <do type="accept">
  <go href="index2.php" method="post">
	<postfield value="$skier"/>

  </go>
  </do>
  Name: <input title="Name" name="skier"/>

</p>
</card>
</wml>

HERE IS THE PHP page

<?php

Header("Content-type: text/vnd.wap.wml");
printf("<?xml version=\"1.0\"?>\n");
printf("<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.1//EN\" "
        ."\"http://www.wapforum.org/DTD/wml_1.1.xml\" >\n");
printf("<wml>\n");

?>
	<wml>
	<card id="index2" title="sql">
	<?php
	@ $db = mysql_pconnect('localhost', 'xxx', 'xxxxx');

	if (!$db)
	{
		echo 'Error: Could not connect to database. Please try again later.';
		exit;
	}

	mysql_select_db('saintData') or die (mysql_error()."<br />Couldn't select database"); 

	$query = "select lastname, firstname from skiers where (firstname like '%$chicken%' or lastname like '%$skier%') AND (is_hidden = '0')";

	$result = mysql_query($query) or die (mysql_error()."<br />Couldn't execute query: $query"); 
	
    	while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
        	print $row["lastname"]."<br>\n";
        }


	mysql_free_result($result);
	
	?>
	</card>
	</wml>

[DavH27]

<--- Has no experience of WML but would like to learn it some day

Can you not pass the variable as a GET variable?

[rmill9681]

i tried get, but that didn't work either

[idx]

Depending on your PHP installation, using plain $skier in the SQL may not work. Try using $_POST['skier'] or $_REQUEST['skier'] .

Worst case put something at the top of the PHP page to see what the WML page is requesting. eg:

PHP Code:

<pre>
<?php print_r($_POST); ?>
</pre>

At the least you can see if anything is making it through.

-r

[rmill9681]

I get: array ( )

[sde]

Originally Posted by rmill9681

I get: array ( )

u sure you did print_r() and not print()

if you just get Array() on a print_r(), then the array is empty.

[sde]

i also noticed this line:

<postfield value="$skier"/>

php is not on when you use that line of code, so $skier will have no php value, you might want to try:

<postfield value="<?=$skier?>"/>

that is the php shortcut for echoing a value. it would be the equivalent to

<postfield value="<? echo $skier; ?>"/>

[Redline]

in proper XML don't you need to put a space before the self closing slash, like this?

<postfield value="<? echo $skier; ?>"/>   <!-- BAD -->
<postfield value="<? echo $skier; ?>" />  <!-- GOOD -->

[sde]

i don't think it really matters about the space.

[Redline]

Hmm, alright. I had read this on W3Schools XHTML page

http://www.w3schools.com/xhtml/xhtml_html.asp
IMPORTANT Compatibility Note:

To make your XHTML compatible with today's browsers, you should add an extra space before the "/" symbol like this: <br />, and this: <hr />.

But it could be outdated

[sde]

good find. i think the main browsers will not care either way, but he IS on a cell phone browser, so he should definately consider that.