Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Sep 2004
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can you check the error inside?

    Hi everyone!!
    I have just written a piece of code..
    it has error but I don't know that the error is from php or mysql connection
    here is the source:
    /*
    <html>
    <head>
    <title>Film Search Result</title>
    </head>

    <body>
    <h1>Film Search Results</h1>
    <?php
    trim($searchterm);
    if (!$searchterm||!$searchtype)
    {
    echo "You have not entered search details. Please go back and try again.";
    exit;
    }
    $searchtype=addslashes($searchtype);
    $searchterm=addslashes($searchterm);
    @ $db= mysql_connect("localhost");
    if (!$db)
    {
    echo "Error: Could not connect to databases. Please try again later.";
    exit;
    }
    mysql_select_db("test");
    $query="SELECT* FROM film WHERE ". $searchtype. "like '%".$searchterm. "%'";
    $result= mysql_query($query);
    $num_results=mysql_num_rows($result);
    echo "<p>Number of films found: ".$num_results."</p>";
    for ($i=0; $i<$num_results; $i++)
    {
    $row= mysql_fetch_array($result);
    echo "<p><strong>".($i+1).".Title:";
    echo htmlspecialchars(stripslashes($row["title"]));
    echo "</strong><br />Director: ";
    echo htmlspecialchars(stripslashes($row["director"]));
    echo "<br />Presenting Date:";
    echo htmlspecialchars(stripslashes($row["presentingdate"]));
    echo"</p>";
    }
    ?>

    </body>
    </html>
    */
    by the way, can you show me how to put the code in a separate bounded text area..Because it's not so clear to see when I just copy and paste my code like this.
    Thanks!!

  • #2
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,980
    Thanks
    4
    Thanked 2,659 Times in 2,628 Posts
    What is the error you are receiving?

  • #3
    New Coder
    Join Date
    Sep 2004
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I create a Javacript page to receive the key word form user ( the searchtype: is to fix the type of searching( title, director, date)
    the searchterm is used to search for description that contain the search term..
    the table film I created include :title, presentingdate, director..and so on..I think I declared an keyed in data correctly..
    When I click the submit button on the Javacript page, it links to the result.php , but in this page, it just displays as follow:
    /*Film Search Results
    "; for ($i=0; $i<$num_results; $i++) { $row= mysql_fetch_array($result); echo "
    ".($i+1).".Title:"; echo htmlspecialchars(stripslashes($row["title"])); echo "
    Director: "; echo htmlspecialchars(stripslashes($row["director"])); echo "
    Presenting Date:"; echo htmlspecialchars(stripslashes($row["presentingdate"])); echo"

    "; } ?>
    */
    Can you help me!!


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •