Member Avatar for aru211285

Dear friends,

I have created a html page with dynamic select boxes and included the below line in the form <form action="sqlpage.php"target="_blank" method="post">. The mentioned sqlpage.php contains some php code which connects to MySQL DB and search for queries and displays the results on a webpage.

But when i run the html page and enter search terms in the query box and click search it directs to this sqlpage and i don't see any results but the php code is displayed as it it on the page. This is bcoz i guess that html page is not interpreting this action sqlpage.php.

I would be thankful if someone help me in this matter.

Thanks in advance.

Kind Regards
Aravind

  • 7 Contributors
  • 9 Replies
  • 151 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by aru211285
Member Avatar for IIM

Have you install php editor for that....you require Apache server for that...So check whether you have that or not....otherwise download WAMP Server,Xampp server...

Member Avatar for Xufyan

you are required to install php, mysql to run .php files so simply download XAMPP and install it into your local machine

Member Avatar for krabz01

try using calling php in ajax which is in an html doc

Member Avatar for diafol

Is there a reason to give target="_blank" ?

Member Avatar for aru211285

Dear All,

Thanks for your replies. I have installed WAMP and then started coding HTML and PHP but i have no clue why i get this problem.....i have used target=_blank as i want my result page in a new tab or new window. Could someone think of a solution.

Thanks in advance.

Cheers,
Aravind

Member Avatar for ko ko

Post that 'sqlpage.php'.

Member Avatar for aru211285 
<html>
<head>
<title>Query results</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
</head>
 
<?php
header("content-type: application/x-javascript");
$class=  $_GET["class"];
$subclass= $_GET["subclass"]; 
$subject = $_GET["subject"];

echo("Searching for entries with Class = $class, Subclass = $subclass and Subject = $subject")."<br />";

$link = mysql_connect('localhost','root'); 
if (!$link) { 
	die('Could not connect to MySQL database ' . mysql_error()); 
} 
echo 'Connected to the Database. Please scroll down for the results'. "<br />";
mysql_select_db("Human-Mouse") or die(mysql_error());
// Query statement with Inner join
if ($subject == NULL && $subclass != "All")
{
$result = mysql_query("SELECT * FROM differences d INNER JOIN `references` r on d.reference = r.reference WHERE class = '$class' AND subclass LIKE '%$subclass%'") or die (mysql_error());
}
else if($subclass == "All" && $subject != NULL)
{
$result = mysql_query("SELECT * FROM differences d INNER JOIN `references` r on d.reference = r.reference WHERE class = '$class' AND subject LIKE '%$subject%' OR human LIKE '%$subject%' OR mouse LIKE '%$subject%'") or die (mysql_error());
} 
else if($subclass == "All" && $subject == NULL)
{
$result = mysql_query("SELECT * FROM differences d INNER JOIN `references` r on d.reference = r.reference WHERE class = '$class'") or die (mysql_error());
} 
else
{
$result = mysql_query("SELECT * FROM differences d INNER JOIN `references` r on  d.reference = r.reference WHERE class ='$class' AND subclass LIKE '%$subclass%' AND subject LIKE '%$subject%' OR human LIKE '%$subject%' OR mouse LIKE '%$subject%'")
or die(mysql_error());
}
if (mysql_num_rows($result)==0 ) 
{
    die('Sorry. No results could be found with your query. Please try with other keywords.' . mysql_error());
}

 echo '<table border="1">';
 echo '<tr>';
 // Columns names of the table
 echo '<th>Class</th><th>Subclass</th><th>Subject</th><th>Human</th><th>Mouse</th><th>Reference</th>';
 echo  '</tr>';
 while($row = mysql_fetch_array($result))
{
// linking the reference key to its url	
$hyperlink = '<a href = "'.$row[9].'" target="_blank">'.$row[6].'</a>';     
	 // start of a new row 
	   echo '<tr>'; 
   //loop through elements (ie td's)
    echo "<td>$row[1]</td><td>$row[2]</td><td>$row[3]</td><td>$row[4]</td><td>$row[5]</td><td>$hyperlink</td>";
    echo "<br />";
	echo '</tr>';
 }    
	echo '</table>';
mysql_free_result($result);	
?>

<body>
</body>
</html>
Edited by aru211285 because: n/a
Member Avatar for tristanhall

From your first post you setup your form to use the POST method but your PHP page references $_GET variables. You should change $_GET to $_POST so that your form data is sent over to the PHP page.
I have had the same issue with WAMP and XAMPP where my PHP code is displayed as if I'm looking at a text file. I ended up uninstalling WAMP and re-installing XAMPP to fix it although I think it's got something to do with the permissions of the htdocs folder (Windows doesn't like the use Unix permissions on their folders, so it's not the easiest to change in my opinion).
Hope this gives you some direction.

Member Avatar for aru211285

thanks to aall for trying.....i have solved the problem......its due to error in the installation and configuaration of PHP and HTML details in the WAMP server......now its running as i expected.....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.