Display query results on same page

[Dennis10]

I've created a form on my webpage which when submitted runs a script file. The query works however the results appear on a blank page.

Can I edit my code to make the results appear on the same page?

Code:

<?
$result = mysql_query("SELECT * FROM $table")
or die(mysql_error());

echo "<table border='1'>";
echo "<tr> <th>Vehicle</th> <th>Description</th> </tr>";

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {

// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['Vehicle'];
echo "</td><td>";
echo $row['Description'];
echo "</td></tr>";
}

echo "</table>";
?>

[Dawg]

Make sure you form declaration is like this

<form action="<? echo $_SERVER['PHP_SELF']; ?>" target="_self" method="post" name="DBsearch"  id="DBsearch">

Then what I do is call a function and pass the query results then return a string with the html code and display it where I want on the page.

function get_page2($result)

{

	if ($result)
		{

			while ($row = mysql_fetch_array($result, MYSQL_NUM))

				{
					$id = $row['0'];
					$article = stripslashes($row['1']);
					$page_title = stripslashes($row['2']);
					$display = stripslashes($row['3']);
					$date = $row['4'];
					$category = $row['5'];

					$articles .= "<table align=\"center\" width=\"90%\"><td align=\"left\">\r\n";
					if ((strlen(trim($display))) < (strlen(trim($article))))
						{
							$articles .= $display . "\r\n";
							$articles .= "<font face=\"Arial, Helvetica, sans-serif\" size=\"2\" color=\"#003399\"><a href=\"http://www.xxx.com/article.php?get=$id\" target=\"_blank\">  Read On</a></font><br /><br />\r\n";
							//$articles .= "<font face=\"Arial, Helvetica, sans-serif\" size=\"2\" color=\"#003399\">$date</font>";								
						}
					else
						{
							$articles .= $article . "\r\n";
							$articles .= "<p><font face=\"Arial, Helvetica, sans-serif\" size=\"2\" color=\"#003399\"><a href=\"http://www.xxx.com/article.php?get=$id\" target=\"_blank\">  Article Link</a></font></p>\r\n";
							//$articles .= "<font face=\"Arial, Helvetica, sans-serif\" size=\"2\" color=\"#003399\">$date</font>";					
						}

					$articles .= "<font face=\"Arial, Helvetica, sans-serif\" size=\"2\" color=\"#003399\">$date</font></td></table>\r\n";
					$articles .= "<p align=\"center\"><img src=\"/gif/line_body.gif\" alt=\"Article Seperator Line\" /></p>\r\n";

				}


		}

	@mysql_free_result ($result);
	return $articles;

}

Hope this helps.

[bradgrafelman]

If you mean that you don't want the user redirected to another page when submitting the form, but that the results should simply appear, then you'll have to look into some AJAX solutions that post and retrieve data via Javascript in the background.

[Dawg]

So Brad, are you saying that what I do (code below) is not good or good pratice? It is the code for a search page of a database. that uses the function I posted above to display results.

I am trying to learn to write classes to make the code more stream line and reusable. But as a beginner/intermediate I am having enough of a time learning php without adding Ajax and Java in the mix.

deleted for no particular reason

I am currently working on streamlining the code and making the search function easier for the user.

Advice from experts is always greatly appreciated just as long as you don't push too hard.

[bradgrafelman]

Whether or not that code is good "practice" to follow, I don't really have any comments (although I would critique some semantic errors/practices). I simply offered the AJAX approach because it sounded like that's what the OP was after. It seems that the idea of "Web 2.0" usually involves the use of AJAX and related technologies.

[Drakla]

Just want to ask why stripslashes is being applied to some of the fields being pulled from the database? You do escape strings when putting them in, but don't when pulling them out. Hence there's mysql_real_escape_string, but no equivalent unescape.

[Dawg]

I actually wrote this a while back and probably can clean it up.

Thanks