maxves1

April 20, 2010

hello,

I have made a drop down menu that fetches results from database, you can see it here:

http://faculty.poly.edu/~yjeanpie/searchcat.php

and I have attached the products database print screen with this topic

The problem I am facing is, I dont kust want to display the selected results but alongwith the selected stuff, say( software : photoshop ) I want it to display the other stuff in the database that is related to the selected stuff, like if i select category software and product as phooshop, i want to display tutorials associated with photoshop, with images associated and other data, i have written the queries for that in mysql, but i dk why it still doesnt retrieve other things, i even tried print_r option, but it displays only the selected stuff and not other queries from database, i have given the drop down form name f1, and even tried $_REQUEST['f1'] and $_GET, $_POST, and even tried foreach loop, but nothing ever works, so I was wondering if its the database fault, or is there some way out of this issue?

Any help would be appreciated, i cant advance with my project without fixing this problem

thx

[attachment deleted by admin]

April 6, 2010

hello, I have my php dynamic drop down menu at :

http://faculty.poly.edu/~yjeanpie/searchcat.php

As you can see, when you select a category and product, it displays the selected stuff on the other page, but that is not exactly what i wanna do, I want it to retrieve all other attributes related to the selection, from the database,

suppose I have selected software and photoshop ( from my PRODUCTS table in database) I want it to display those plus all other attributes related to photoshop say tutorial links, id ,description ,etc, see the following for a brief idea:

http://faculty.poly.edu/~yjeanpie/generalinfo.php

so i need all those attributes to be pulled from database as soon as i select these 2 things from drop down,

i used the following print_r command on the results page, but its not working, can anyone help me fix it or rewrite it?>

<?php

print_r($_POST);

?>

<?php

require("db_connect.php");

/*$query = mysql_query("SELECT * FROM products NATURAL JOIN category WHERE prod_name='".$_POST['subcat']."'");

echo '<pre>';

print_r($row = mysql_fetch_assoc($query));

//echo .$row['prod_info'].;

echo '</pre>';

*/

print_r($_SESSION);

//while ($row = mysql_fetch_assoc($query)) {

foreach ($row as $col=>$val) {

if (!empty($val)) {

echo 'col: '.$col.' val: '.$val.'<br />';

}

echo '<br />';

//}

?>

</body>

</html>

April 6, 2010

do you have any chat messenger ?

April 6, 2010

i tried that but its still not working

can you fix the above code in such a way that it helps me retirieve without many modifications

April 6, 2010

this is the code so far :

<?php

session_start(); // SESSION STARTED

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<head>

<!--

.style1 {

font-family: Arial, Helvetica, sans-serif;

font-weight: bold;

}

.style3 {font-family: Arial, Helvetica, sans-serif}

-->

</style>

<!--

function popup(mylink, windowname)

{

if (! window.focus)return true;

var href;

if (typeof(mylink) == 'string')

href=mylink;

else

href=mylink.href;

window.open(href, windowname, 'width=400,height=200,scrollbars=yes');

return false;

}

//-->

</SCRIPT>

<!--//

function changePage(number){

var firstNumber = 001;

var lastNumber = 999;

var content = document.getElementById('content');

var oldNumber = content.src.match(/(\d+)(?=\.)/);

var newNumber = RegExp.$1*1+number;

if(newNumber < firstNumber){ newNumber = lastNumber };

if(newNumber > lastNumber) { newNumber = firstNumber };

content.src = content.src.replace(/(\d+)(?=\.)/,newNumber);

document.getElementById('test').innerHTML = content.src;

}

//-->

</script>

<title>FITL Search Page</title></head>

<BODY>

<br>

<br>

<?php

$ids=$_SESSION['id']; // USER ID

echo "<font size = 4 <b>All Products </b></font>".$ids."<br>";

?>

<br>

</td></tr>

<h3>Search Results</h3>

<tbody>

<tr>

<tr>

<a href="" STYLE="text-decoration:none"><font color="#99CCFF">Category</font></a>

<a href="" STYLE="text-decoration:none"><font color="#99CCFF">Sub-Category</font></a></td>

</tr>

</table>

</td><td>

<?php

include ('db_connect.php'); // DATABASE CONNECTION

{

$keyword=$_REQUEST['T1'];

if($keyword=="")

{

header( 'location:http://faculty.poly.edu/~yjeanpie/search.html');

exit();

}

$sql="select * from PRODUCTS NATURAL JOIN category NATURAL JOIN SUB_CATEGORIES where PRODUCTS.prod_name like '$keyword%'";

$result=mysql_query($sql);

$rowcount=mysql_num_rows($result);

if($rowcount<1)

{

echo "Search Results not Found";

exit();

}

else

{

?>

<tr><th>Image</th><th>Category</th><th>Sub-Category</th><th>Product Name</th><th>Version</th></tr>

<?php

while($mem=mysql_fetch_array($result))

{

$number1=$mem['category'];

$number=$mem['prod_name'];

$number3=$mem['sub_category_name'];

$number5=$mem['prod_model_version'];

$number2=$mem['img'];

?>

<tr>

<td> <?php

$sql3="select img from PRODUCTS where img='$number2'";

$result3=mysql_query($sql3);

$rowcount3=mysql_num_rows($result3);

if($rowcount3<1)

{

$rate='Not found';

}

else

{

while($row3=mysql_fetch_array($result3))

{

$rate=$row3[0];

if (!empty($row3[0]))

{

// Output the MIME header

header("Content-Type:image/jpeg");

// Output the image

echo $row3[0];

}

?>

<?php

if($rate!=null)

//header("Content-type: image/jpeg");

echo '<a href="generalinfo.php"><img src="'.$rate.'"></a>';

else

echo " ";

?>

</td> <td>

<?php

$sql3="select category from category NATURAL JOIN PRODUCTS where category='$number1' and PRODUCTS.cat_id=category.cat_id";

$result3=mysql_query($sql3);

$rowcount3=mysql_num_rows($result3);

if($rowcount3<1)

{

$rate="Not found";

}

else

{

while($row3=mysql_fetch_array($result3))

{

$rate=$row3[0];

}

?>

<?php

if($rate!=null)

echo '<center>'.$rate.'</center>';

else

echo "Available";

?></td><td>

<?php

$sql3="select sub_category_name from SUB_CATEGORIES NATURAL JOIN PRODUCTS where sub_category_name='$number3' and PRODUCTS.sub_category_id=SUB_CATEGORIES.sub_category_id";

$result3=mysql_query($sql3);

$rowcount3=mysql_num_rows($result3);

if($rowcount3<1)

{

$rate="Not found";

}

else

{

while($row3=mysql_fetch_array($result3))

{

$rate=$row3[0];

}

?>

<?php

if($rate!=null)

echo '<center>'.$rate.'</center>';

else

echo " ";

?></td><td>

<?php

$sql3="select prod_name from PRODUCTS where prod_name='$number'";

$result3=mysql_query($sql3);

$rowcount3=mysql_num_rows($result3);

if($rowcount3<1)

{

$rate="Not found";

}

else

{

while($row3=mysql_fetch_array($result3))

{

$rate=$row3[0];

}

?>

<?php

if($rate!=null)

echo '<center><a href="generalinfo.php">'.$rate.'</a></center>';

else

echo " ";

?></td>

<td>

<?php

$sql3="select prod_model_version from PRODUCTS where prod_model_version='$number5'";

$result3=mysql_query($sql3);

$rowcount3=mysql_num_rows($result3);

if($rowcount3<1)

{

$rate="Not found";

}

else

{

while($row3=mysql_fetch_array($result3))

{

$rate=$row3[0];

}

?>

<?php

if($rate!=null)

echo "<center>".$rate."</center>";

else

echo " ";

?>

</td></tr>

<?php

}

?>

</table>

</form>

<?php

}

?></td><td>

</td>

</td>

</tr>

</table>

</td></tr>

</table>

</td>

</table>

</center>

</body>

</html>

the first loop is for the images , i have used "img" for that, but still it is not working, I dont know what to do to get it working,

you can see the demo at:

http://faculty.poly.edu/~yjeanpie/search.html

put in "a" in the searchbox and you will see the output, (same code) , but without images , i wonder how to fix this, any help would be appreciated

April 5, 2010

Hello ,

Can anyone help me with displaying results of my php onto another page?

Heres the code I wrote for search category and it works fine :

<?php

include ('db_connect.php'); // DATABASE CONNECTION

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html>

<head>

function reload(form)

{

var val=form.cat.options[form.cat.options.selectedIndex].value;

self.location='searchcat.php?cat=' + val ;

}

</script>

<!--

function confirm_dropdown()

{

if (f1.cat.options.selectedIndex == 0)

{

alert("Please select the Category.");

f1.cat.focus();

return (false);

}

if (f1.subcat.options.selectedIndex == 0)

{

alert("Please select the Products.");

f1.subcat.focus();

return (false);

}

return (true);

}

//--></script>

function MyReload()

{

window.location.reload();

}

//--></script>

</head>

<p><font face="Arial, Helvetica, sans-serif" size="2" align="Left">Search by Category</font></p>

<?

@$cat=$_GET['cat'];

if(strlen($cat) > 0 and !is_numeric($cat)){

echo "Data Error";

exit;

}

$quer2=mysql_query("SELECT DISTINCT category,cat_id FROM category order by category");

if(isset($cat) and strlen($cat) > 0){

$quer=mysql_query("SELECT DISTINCT prod_name FROM PRODUCTS where cat_id=$cat order by prod_name");

}

echo '<form method=post name=f1 action="dd-check1.php" onsubmit="return confirm_dropdown()">';

echo "<select name='cat' onchange=\"reload(this.form)\"><option value='' style= width:13em;>Select category</option>";

while($noticia2 = mysql_fetch_array($quer2)) {

if($noticia2['cat_id']==@$cat){echo "<option selected value='$noticia2[cat_id]'>$noticia2[category]</option>"."<BR>";}

else{echo "<option value='$noticia2[cat_id]'>$noticia2[category]</option>";}

}

echo "</select>";

echo "<br>";

echo "<select name='subcat' style= width:15em;><option value=''>Select products</option>";

while($noticia = mysql_fetch_array($quer)) {

echo "<option value='$noticia[prod_name]'>$noticia[prod_name]</option>";

}

echo "</select>";

echo "<br>";

echo '<input type=image src="back.jpg" srcname=btnback id=btnback onclick="history.go(-1);return false;"/>';

echo '<span style="padding-left:10px">';

echo '<input type=image src="button.JPG" >';

echo '</span>';

echo "</form>";

?>

</div></center>

<br>

</div></center>

</div> </center>

</body></html>

Now I saved this file onto my database as searchcat.php

you can check the link at:

http://faculty.poly.edu/~yjeanpie/searchcat.php

only problem is upon submission ,I want it to display results onto a new page "dd-check1" in this case, in such a way, that it displays the category and product selected and along with it, it displays relevant information related with the specific product for the category selected,

like say for example

"if i select software and photoshop "

I want it to show that on the other page along with the tutorial links i have in database and other relevant info "

My databse PRODUCTS looks like the file attached ( from where i want to retrieve other relevant results"

PLEASE HELP ME ASAP , i need to get this done within 2 weeks

any help will be honestly appreciated

[attachment deleted by admin]

Sign In

maxves1

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by maxves1

help with displaying the results of drop down menu

help with print_r function for a drop down menu ?

How do I display images stored in my databse???

How do I display images stored in my databse???

How do I display images stored in my databse???

Help with displaying selected dropdown menu on another page with related queries

Browse

Activity

Important Information