xHTML MP + PHP + MySQL

joefriend

Hi...

I'm a newbie on PHP and I'm trying to make PHP link with xHTML MP.. I tested out on my mobile phone and it download the code on your mobile. Is pretty weird :bemused: , i thought...
I guess you guy can help me out with this... I just need an example on how to link xHTML MP with PHP...

here's my code..for search results :

<?php header('Content-type: application/vnd.wap.xhtml+xml');?>
<?php echo '<?xml version="1.0"?'.'>';?>
<?

include('db_Include.php');

$searchTerm = $_GET['name'];

$data = databaseConnect();
$staffInfo = mysql_query("SELECT * FROM staff_detail WHERE Name LIKE '%$searchTerm%'")
or die('There was an error with your query.');

$numOfsearch = mysql_num_rows($staffInfo);

?>

<!DOCTYPE html PUBLIC "-//WAPFORUM//DTD XHTML Mobile 1.0//EN" "http://www.wapforum.org/DTD/xhtml-mobile10.dtd">

<html>
<head>
</head>

<p>We found <?= $numOfsearch ?> staff(s) from <br /> your search "<?= $searchTerm ?>".</p>

<table width="128" border="0" cellspacing="0" cellpadding="0">

	<tr>
	  	<td colspan="2" align="center">
		   	<span>Search Result</span>
	  	</td>
	</tr>
    <? While ($search = mysql_fetch_array($staffInfo)) { ?>               
	<tr> 
      	<td>
	  		Name 
	 	</td>

	 	<td> 
			<?= php echo $search['Name'] ?>
	  	</td>

  	</tr>

</table>

</body>
</html>
[/I]

Hope everyone out there can help...
Thanks 🙂

Weedpacket

Hey, where did this code on my phone come from?

If I understand your problem rightly then congratulations, your install of PHP hasn't had its XML compatibility broken by someone turning short_tags on: write "<?php" instead of "<?", "<?php echo" instead of "<?=" and then you can write '<?xml version="1.0"?>' without having to echo it.

joefriend

Hi..

Well basically, I builded xhtml mp on wap site...and now I'm trying to link xhtml mp with php and mysql. So I wonder how I can make php read on mobile phones.

xhtml mp -> php(searching) -> mysql(database)

And also, on the extension part, can mobile phone know .php files?

Weedpacket

So ... did you read my post or not?

joefriend wrote:
And also, on the extension part, can mobile phone know .php files?

Irrelevant; it's the server's job to "know .php files".

joefriend

Yeah...I did read your post...
ok... without "echo" can it work it?

how about like this:

<?
//send xhtml mp headers
header ('Content-type: application/vnd.wap.xhtml+xml');
'<?xml version="1.0"?>';
'<!DOCTYPE html PUBLIC "-//WAPFORUM//DTD XHTML Mobile 1.0//EN"
'.' "http://www.wapforum.org/DTD/xhtml-mobile10.dtd">';

Weedpacket

You're still using "<?" instead of "<?php".
You've got strings there without telling PHP what you want to do with them.
Did you try it?

By just

<?php
//send xhtml mp headers
header ('Content-type: application/vnd.wap.xhtml+xml');
?>
<?xml version="1.0"?>
<!DOCTYPE html PUBLIC "-//WAPFORUM//DTD XHTML Mobile 1.0//EN"
    "http://www.wapforum.org/DTD/xhtml-mobile10.dtd">

Litewebsite

On top of Weedpacket's tips you will also benefit from testing the mobile site on phone simulator like OpenWave phone simulator .

Some mobile browsers are very sensitive to line breaks in the header of the document (that will result in a parse error).

joefriend

Hi...

I just test them.. and respond well..
But some how I got a parse error on line 2.. I think is the header error...

this how i put them..

<?php
//send xhtml mp headers
header ('Content-type: application/vnd.wap.xhtml+xml');
?>
<? xml version="1.0" ?>
<!DOCTYPE html PUBLIC "-//WAPFORUM//DTD XHTML Mobile 1.0//EN"
"http://www.wapforum.org/DTD/xhtml-mobile10.dtd">

and on my search coding...this is how i put them...:

<?php
// connect to database
$staffInfo = mysql_pconnect("hostname", "id", "password");

	//select database
	$db = mysql_select_db("db name");

	//select information from sports db
	$query = "select name, phNo, office"; 

	$result = @mysql_query($query);

	print "<b>Staff Searched:</b> <br />";

	//if information fitting the query is found, it will display it to the screen.
	if (mysql_num_rows($result) > 0) :

	while ($row = mysql_fetch_array($result)) :

	print "$row[Name] $row[Work Phone] $row[Other Phone] $row[Email] $row[Office Location] <br />";

	endwhile;

	//if no information is available, error message display
	else:

		print "Search not found.";

	endif;

[/I]

Hope you get it... for this searching functionality contain on this page only..