Search output for the form in db

Codewalkers Forums Sponsor:

October 22nd, 2009, 06:22 AM

lakshmiyb

Registered User

Join Date: Oct 2009

Posts: 14

Time spent in forums: 4 h 39 m 35 sec
Reputation Power: 0

php5 - Search output for the form in db

hi,
this is my form code
i want the out put from db
but it is a blank page for me.
form.php
<html>
<body>
<table width="100%" border="0" cellspacing="2" cellpadding="1">
<tr>
<td align="center"><img src="bannerimages/ADVANCE SERCH.jpg" width="180" height="15" /></td>
</tr>
<tr>
<td>
<form name="form3" id="form3" method="post" action="advanced_search.php">

PHP Code:


		
			
<?php

$conn = mysql_connect("localhost","root","");

            if (!$conn)

            {

                die('Could not connect: ' . mysql_error());

            }

            mysql_select_db("reelload", $conn);



$sql_result =mysql_query("SELECT languages FROM languages"); 



?>

PHP Code:


		
			
<?php 

    echo '<option size ="50" >SELECT LANGUAGE</option>'; 

    if(mysql_num_rows($sql_result))  

    {  

    while($row = mysql_fetch_assoc($sql_result))  

    {  

    

    echo "<option>$row[languages]</option>";  

    }  

  

    }  

    else { 

    echo "<option>No Names Present</option>";   

    }  

   ?>

</select>
</td>
</tr>

PHP Code:


		
			
<?php

          $sql_result =mysql_query("SELECT genres FROM genres"); 

          ?>

PHP Code:


		
			
<?php

    echo '<option size ="50" >SELECT GENRES</option>'; 

    if(mysql_num_rows($sql_result))  

    {  

    while($row = mysql_fetch_assoc($sql_result))  

    {  

    

    echo "<option>$row[genres]</option>";  

    }  

    }  

    else { 

    echo "<option>No Names Present</option>";   

    }  

   ?>

</select>
</td>
</tr>
<tr>
<td align="center"><input name="malelead" type="text" class="style1" value="MALE LEAD" size="27" />
</td>
</tr>
<tr>
<td align="center">
<input name= "femalelead" type="text" class="style1" value="FEMALE LEAD" size="27" />
</td>
</tr>
<tr>
<td align="center"><input name="director" type="text" class="style1" value="DIRECTOR" size="27" />
</td>
</tr>
<tr>
<td align="center"><input name="musicdirector" type="text" class="style1" value="MUSIC DIRECTOR" size="27" />
</td>
</tr>
<tr>
<td align="center" ><input name="productionhouse" type="text" class="style1" value="PRODUCTION HOUSE" size="27" />
</td>
</tr>
<tr>
<td align="center"><input name="others" type="text" class="style1" value="OTHERS" size="27" />
</td>
</tr>
<tr>
<td align="center"><input type="image" name="Submit1" src="images/submit-button.jpg"/>
</td>
</tr>
</form>
</td>
</tr>
</table>
</body>
</html>

PHP Code:


		
			
<?php





session_start();



$languages = $_POST['languages'];

$genres = $_POST['genres'];

$malelead = $_POST['malelead'];

$femalelead = $_POST['femalelead'];

$director = $_POST['director'];

$musicdirector = $_POST['musicdirector'];



$con = mysql_connect("localhost","root","");

mysql_select_db("reelload", $con);

 $images_dir = "movies";

 $result_array = array();

    $counter = 0;



$pid = (int)($_REQUEST['movie_id']);



            

            

if(empty( $pid ) )

    {

        $number_of_thumbs_in_row = 4;



        $result = mysql_query("SELECT movie_thumbnail,thumb_name FROM movies where language like'".$languages."'and movie_genres like'".$genres."' and heros='".$malelead."'and  heroines='".$femalelead."'and directors='".$director."'AND musicdirectors='".$musicdirector."'");

    

            

            while( $row = mysql_fetch_array( $result ) )

            {

                $result_array[] = "<img src='".$images_dir."/tb_".$row[1]."' border='0' alt='".$row[1]."'/><br>$row[1]";

            }

            mysql_free_result( $result );    

    

            $result_final = "<tr valign='top' align='center'>\n";

    

            foreach($result_array as $thumbnail_link)

            {

            

                if($counter == $number_of_thumbs_in_row)

                {    

                    $counter = 1;

                    $result_final .= "\n</tr align='center'>\n<tr align='center'>\n";

                         

                }

                else

                   

                $counter++;

                         $result_final .= "\n<td>".$thumbnail_link."</td>\n";

                 

            }

    if($counter)

            {

                

                if($number_of_photos_in_row==$counter)

            $result_final .= "\n<td colspan='".($number_of_photos_in_row=$counter)."'></td>\n";



                $result_final .= "</tr>";

                 

            }

            

        }

        





echo <<<__HTML_END



<html>

<head>

    <title>Gallery View</title>

</head>

<body>

<table width='100%'  border='1' cellpadding="10" cellspacing="10">

$result_final    

      

</table>

</body>

</html>



__HTML_END;
    

?>

October 23rd, 2009, 03:27 AM

lakshmiyb

Registered User

Join Date: Oct 2009

Posts: 14

Time spent in forums: 4 h 39 m 35 sec
Reputation Power: 0

hey

can any one help me out for this.

thanku u in advance

October 23rd, 2009, 01:01 PM

IAmALlama

Join Date: Apr 2007

Location: Seattle, WA

Posts: 1,937

Time spent in forums: 1 Week 5 Days 1 h 54 m 18 sec
Reputation Power: 4

I personally wouldn't have a problem helping, but the code in the first post is pretty messed up with all the [php] tags around just the php parts. You should edit that and put the tags around the entire code. As it is I can't test it without doing like 6 copy pastes. Just put everything in one set of tags and then its simpler.

Also, if you put error_reporting(E_ALL) at the top of the script (first line) you would probably see the error you are having. I'm guessing now that its because of the session_start() at the bottom of the page. session_start() generally has to be on the page before any output to the browser including all html.

October 24th, 2009, 01:47 AM

lakshmiyb

Registered User

Join Date: Oct 2009

Posts: 14

Time spent in forums: 4 h 39 m 35 sec
Reputation Power: 0

this is my form
when submited i want the out put from the db

PHP Code:


		
			
<form name="form3" id="form3" method="post" action="search.php"> 

          

   <?php

 include "dbconnection.php";



$sql_result =mysql_query("SELECT languages FROM movie_languages"); 



?>

            <tr>            

            <td align="center" >

            

   <select name="languages" style="width:150px" class="style1">

    <?php 

    echo '<option size ="50" >SELECT LANGUAGE</option>'; 

    if(mysql_num_rows($sql_result))  

    {  

    while($row = mysql_fetch_assoc($sql_result))  

    {  

    

    echo "<option>$row[languages]</option>";  

    }  

  

    }  

    else { 

    echo "<option>No Names Present</option>";   

    }  

   ?>

           </select>

             </td>

          </tr>

         <?php

          $sql_result =mysql_query("SELECT genres FROM movie_genres"); 

          ?>

          <tr>

            <td align="center" class="style1">

    <select name="genres" style="width:150px" class="style1">

    <?php

    echo '<option size ="50" >SELECT GENRES</option>'; 

    if(mysql_num_rows($sql_result))  

    {  

    while($row = mysql_fetch_assoc($sql_result))  

    {  

    

    echo "<option>$row[genres]</option>";  

    }  

    }  

    else { 

    echo "<option>No Names Present</option>";   

    }  

   ?>

   </select>

              </td>

           </tr>

          <tr>

            <td align="center"><input name="malelead" type="text" class="style1" value="MALE LEAD" size="27" />

              </td>

          </tr>

           <tr>

            <td align="center">

            <input name= "femalelead" type="text" class="style1" value="FEMALE LEAD" size="27" />

               </td>

          </tr>

           <tr>

            <td align="center"><input name="director" type="text" class="style1" value="DIRECTOR" size="27" />

              </td>

          </tr>

           <tr>

            <td align="center"><input name="musicdirector" type="text" class="style1" value="MUSIC DIRECTOR" size="27" />

              </td>

          </tr>

           <tr>

            <td align="center" ><input name="productionhouse" type="text" class="style1" value="PRODUCTION HOUSE" size="27" />

              </td>

          </tr>

           <tr>

            <td align="center"><input name="others" type="text" class="style1" value="OTHERS" size="27" />

              </td>

          </tr>

           <tr>

            <td align="center"><input type="image" name="Submit1" src="images/submit-button.jpg"/>

              </td>

          </tr>

          </form>

and search.php is

PHP Code:


		
			
<?php





session_start();

include "dbconnection.php";

$languages = $_POST['languages'];

$genres = $_POST['genres'];

$malelead = $_POST['malelead'];

$femalelead = $_POST['femalelead'];

$director = $_POST['director'];

$musicdirector = $_POST['musicdirector'];







 $images_dir = "movies";

 $result_array = array();

    $counter = 0;



$pid = (int)($_REQUEST['movie_id']);



            

            

if(empty( $pid ) )

    {

        $number_of_thumbs_in_row = 4;



        $result = mysql_query("SELECT movie_thumbnail,thumb_name FROM movies where language like'".$languages."'and movie_genres like'".$genres."' and heros='".$malelead."'and  heroines='".$femalelead."'and directors='".$director."'AND musicdirectors='".$musicdirector."'");

    

            

            while( $row = mysql_fetch_array( $result ) )

            {

                $result_array[] = "<img src='".$images_dir."/tb_".$row[1]."' border='0' alt='".$row[1]."'/><br>$row[1]";

            }

            mysql_free_result( $result );    

    

            $result_final = "<tr valign='top' align='center'>\n";

    

            foreach($result_array as $thumbnail_link)

            {

                

                if($counter == $number_of_thumbs_in_row)

                {    

                    $counter = 1;

                    $result_final .= "\n</tr align='center'>\n<tr align='center'>\n";

                         

                }

                else

                   

                $counter++;

                  

                $result_final .= "\n<td>".$thumbnail_link."</td>\n";

                

                 

            }

    

    

            if($counter)

            {

                

                if($number_of_photos_in_row==$counter)

            $result_final .= "\n<td colspan='".($number_of_photos_in_row=$counter)."'></td>\n";



                $result_final .= "</tr>";

                 

            }

            

        }

        





echo <<<__HTML_END



<html>

<head>

    <title>Gallery View</title>

</head>

<body>

<table width='100%'  border='1' cellpadding="10" cellspacing="10">

$result_final    

      

</table>

</body>

</html>



__HTML_END;


    

?>

October 24th, 2009, 02:17 AM

jamestrowbridge

Contributing User

Join Date: Jul 2008

Location: Cleveland, Ohio, USA

Posts: 411

Time spent in forums: 4 Days 18 h 54 m 24 sec
Reputation Power: 2

I didn't really test anything or put it through an IDE to debug, but looking at this line, it could be your problem, what is it supposed to be doing here?:

PHP Code:


		
			
 $result_final .= "\n<td colspan='".($number_of_photos_in_row=$counter)."'></td>\n";

maybe you meant:

PHP Code:


		
			
 $result_final .= "\n<td colspan='".$counter."'></td>\n";

???

__________________
Sir, a desire of knowledge is the natural feeling of mankind; and every human being, whose mind is not debauched, will be willing to give all that he has to get knowledge.

October 24th, 2009, 07:04 AM

lakshmiyb

Registered User

Join Date: Oct 2009

Posts: 14

Time spent in forums: 4 h 39 m 35 sec
Reputation Power: 0

thanku very much for ur reply,

nothing wrong in $counter
the problem lies in sql query.

when i use "and' in query i have to enter all the fields in the form
IF i use "or" i am not able to get the correct result
help me in this way

thanking u in advance

October 24th, 2009, 11:23 AM

jamestrowbridge

Contributing User

Join Date: Jul 2008

Location: Cleveland, Ohio, USA

Posts: 411

Time spent in forums: 4 Days 18 h 54 m 24 sec
Reputation Power: 2

I thought you said that it comes up as a blank page? That usually means that's it's erroring out.

Try changing:

PHP Code:


		
			
echo <<<__HTML_END

Just remove the whitespace after <<<__HTML_END

October 24th, 2009, 11:41 AM

jamestrowbridge

Contributing User

Join Date: Jul 2008

Location: Cleveland, Ohio, USA

Posts: 411

Time spent in forums: 4 Days 18 h 54 m 24 sec
Reputation Power: 2

See above, but
Here's an easy way to display errors too, just make another PHP file called: errors.php
Make sure it's in the same directory as your 'search.php' and then fill it with this:

PHP Code:


		
			
<?php 

 error_reporting(E_ALL); 

 ini_set("display_errors", 1); 

 include("search.php"); 

?>

if you need to use it will other files, just change:

PHP Code:


		
			
include("search.php");

to match whatever the page name is.

October 26th, 2009, 04:10 AM

lakshmiyb

Registered User

Join Date: Oct 2009

Posts: 14

Time spent in forums: 4 h 39 m 35 sec
Reputation Power: 0

no error in display of the output, nut i am not getting the required result,

the error my be in sql query and that too in using "and" or "or" .

#10

October 26th, 2009, 07:28 AM

jamestrowbridge

Contributing User

Join Date: Jul 2008

Location: Cleveland, Ohio, USA

Posts: 411

Time spent in forums: 4 Days 18 h 54 m 24 sec
Reputation Power: 2

I don't understand. Did you try everything that was suggested above?

#11

October 26th, 2009, 12:32 PM

IAmALlama

Join Date: Apr 2007

Location: Seattle, WA

Posts: 1,937

Time spent in forums: 1 Week 5 Days 1 h 54 m 18 sec
Reputation Power: 4

if you want to check if there is an error in your query then just echo out mysql_error() after each query. that will display any errors from mysql if there are any.

#12

October 29th, 2009, 07:10 AM

lakshmiyb

Registered User

Join Date: Oct 2009

Posts: 14

Time spent in forums: 4 h 39 m 35 sec
Reputation Power: 0

i am not able to that, i have tried all these but some where something is going wrong
i need the result from mysql to this form
in this form it is not necessary to fill all the fields though we fill one or 2 fields we have to get the output.and all the field are in the single table itself to retrive

here is my form

PHP Code:


		
			
<form name="form3" id="form3" method="post" action="search.php"> 

          

   <?php

 include "dbconnection.php";



$sql_result =mysql_query("SELECT languages FROM movie_languages"); 



?>

            <tr>            

            <td align="center" >

            

   <select name="languages" style="width:150px" class="style1">

    <?php 

    echo '<option size ="50" >SELECT LANGUAGE</option>'; 

    if(mysql_num_rows($sql_result))  

    {  

    while($row = mysql_fetch_assoc($sql_result))  

    {  

    

    echo "<option>$row[languages]</option>";  

    }  

  

    }  

    else { 

    echo "<option>No Names Present</option>";   

    }  

   ?>

           </select>

             </td>

          </tr>

         <?php

          $sql_result =mysql_query("SELECT genres FROM movie_genres"); 

          ?>

          <tr>

            <td align="center" class="style1">

    <select name="genres" style="width:150px" class="style1">

    <?php

    echo '<option size ="50" >SELECT GENRES</option>'; 

    if(mysql_num_rows($sql_result))  

    {  

    while($row = mysql_fetch_assoc($sql_result))  

    {  

    

    echo "<option>$row[genres]</option>";  

    }  

    }  

    else { 

    echo "<option>No Names Present</option>";   

    }  

   ?>

   </select>

              </td>

           </tr>

          <tr>

            <td align="center"><input name="malelead" type="text" class="style1" value="MALE LEAD" size="27" />

              </td>

          </tr>

           <tr>

            <td align="center">

            <input name= "femalelead" type="text" class="style1" value="FEMALE LEAD" size="27" />

               </td>

          </tr>

           <tr>

            <td align="center"><input name="director" type="text" class="style1" value="DIRECTOR" size="27" />

              </td>

          </tr>

           <tr>

            <td align="center"><input name="musicdirector" type="text" class="style1" value="MUSIC DIRECTOR" size="27" />

              </td>

          </tr>

           <tr>

            <td align="center" ><input name="productionhouse" type="text" class="style1" value="PRODUCTION HOUSE" size="27" />

              </td>

          </tr>

           <tr>

            <td align="center"><input name="others" type="text" class="style1" value="OTHERS" size="27" />

              </td>

          </tr>

           <tr>

            <td align="center"><input type="image" name="Submit1" src="images/submit-button.jpg"/>

              </td>

          </tr>

          </form>

please do the needful
thanking u in advance

#13

October 30th, 2009, 02:18 PM

Naughty

Contributing User

Join Date: Jul 2009

Posts: 83

Time spent in forums: 13 h 53 m 8 sec
Reputation Power: 1

Hey,

I had the same blank problem when dealing with PHP and SQL. The below solved the problem, I meant the blank page.

PHP Code:


		
			
<?php 

 error_reporting(E_ALL); 

 ini_set("display_errors", 1); 

?>

Then after clearing the errors I was able to connect and quires worked too.

Please explain your questions in detail (even if it takes up lot of space, just don't worry ) and clear way, then only they can help you figure out, what the problem is.

#14

October 31st, 2009, 02:23 AM

lakshmiyb

Registered User

Join Date: Oct 2009

Posts: 14

Time spent in forums: 4 h 39 m 35 sec
Reputation Power: 0

this is my code of search form
and i need the out put from database as the thumbnails, when they select any of the fields or all the fields.
and in this form o have taken the language and genres fields from the database as the dropdown box,
the result must be the thumbnail only selected from the fields and the user may select all the fields or one or two fields.

PHP Code:


		
			
<table width="100%" border="0" cellspacing="2" cellpadding="1">

          <tr>

            <td align="center"><img src="bannerimages/ADVANCED SEARCH.jpg" width="147" height="16" /></td>

          </tr>

          <tr>

            <td>

            <form name="form3" id="form3" method="post" action="search.php"> 

     [php]

     

   <?php

 include "dbconnection.php";



$sql_result =mysql_query("SELECT languages FROM movie_languages"); 



?>

PHP Code:


		
			
<?php 

    echo '<option size ="50" >SELECT LANGUAGE</option>'; 

    if(mysql_num_rows($sql_result))  

    {  

    while($row = mysql_fetch_assoc($sql_result))  

    {  

    

    echo "<option>$row[languages]</option>";  

    }  

  

    }  

    else { 

    echo "<option>No Names Present</option>";   

    }  

   ?>

</select>
</td>
</tr>

PHP Code:


		
			
<?php

          $sql_result =mysql_query("SELECT genres FROM movie_genres"); 

          ?>

PHP Code:


		
			
<?php

    echo '<option size ="50" >SELECT GENRES</option>'; 

    if(mysql_num_rows($sql_result))  

    {  

    while($row = mysql_fetch_assoc($sql_result))  

    {  

    

    echo "<option>$row[genres]</option>";  

    }  

    }  

    else { 

    echo "<option>No Names Present</option>";   

    }  

   ?>

PHP Code:


		
			
<?php

session_start();

include "dbconnection.php";

$languages = $_POST['languages'];

$genres = $_POST['genres'];

$malelead = $_POST['malelead'];

$femalelead = $_POST['femalelead'];

$director = $_POST['director'];

$musicdirector = $_POST['musicdirector'];

$productionhouse = $_POST['productionhouse'];

$others = $_POST['others'];



 $images_dir = "movies";

 $result_array = array();

    $counter = 0;



    $number_of_thumbs_in_row = 4;



        $result = mysql_query("SELECT movie_thumbnail,thumb_name FROM movies where language ='".$languages."'and movie_genres ='".$genres."' and actor='".$malelead."'and  actress='".$femalelead."'and directors='".$director."'AND musicdirectors='".$musicdirector."' AND productions='".$productionhouse."'");

        

            while( $row = mysql_fetch_array( $result ) )

            {

                $result_array[] = "<img src='".$images_dir."/tb_".$row[1]."' border='0' alt='".$row[1]."'/><br>$row[1]";

            }

            mysql_free_result( $result );    

    

            $result_final = "<tr valign='top' align='center'>\n";

    

            foreach($result_array as $thumbnail_link)

            {

                

                if($counter == $number_of_thumbs_in_row)

                {    

                    $counter = 1;

                    $result_final .= "\n</tr align='center'>\n<tr align='center'>\n";

                         

                }

                else

                   

                $counter++;

                $result_final .= "\n<td>".$thumbnail_link."</td>\n";

                

            }

    if($counter)

            {

            

                if($number_of_photos_in_row==$counter)

            $result_final .= "\n<td colspan='".($number_of_photos_in_row=$counter)."'></td>\n";



                $result_final .= "</tr>";

            }

        

echo <<<__HTML_END

<html>

<head>

    <title>Gallery View</title>

</head>

<body>

<table width='100%'  border='1' cellpadding="10" cellspacing="10">

$result_final    

      

</table>

</body>

</html>

__HTML_END;


?>

this is my clear code
please help me to do this and it is very urgent also,
thanku for one and all for the suggestions.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: