|
|
Posted by The Eclectic Electric on 10/12/91 11:57
Can I just bump this please? I'm still stuck!
"The Eclectic Electric" <nospam@spamispoo.spam> wrote in message
news:ZrAHg.3873$s4.3793@newsfe3-win.ntli.net...
> Hi, I'm teaching myself PHP/MySQL with the Welling/Thomson book and it's
> been fun so far. I've got stuck on prepared statements though as the book
> sort of abandons it (I guess it wasn't fully formed when it was written).
> It's something I'm likely to need so I don't want to skip it and so far my
> searches on the internet have drawn a blank.
>
> It seems that the query itself is working fine (it produces the correct
> number of results according to the parameters I enter), but the results
> aren't populating the variables.
>
> My thanks for any advice you can offer.
>
> +e
>
> My bind_result statement looks like this:
>
> mysqli_stmt_bind_result($stmt, $v_title, $v_author, $v_isbn, $v_price);
>
> The rest of the code is like this:
>
> <html>
> <head>
> <title>Book-O-Rama Search Results</title>
> </head>
> <body>
> <h1>Book-O-Rama Search Results</h1>
> <?php
> // create short variable names
> $searchtype=$_POST['searchtype'];
> $searchterm=$_POST['searchterm'];
> $searchterm= trim($searchterm);
> if (!$searchtype || !$searchterm)
> {
> echo 'You have not entered search details. Please go back and try again.';
> exit;
> }
> if (!get_magic_quotes_gpc())
> {
> $searchtype = addslashes($searchtype);
> $searchterm = addslashes($searchterm);
> }
> @ $db = mysqli_connect('localhost', 'bookorama', 'bookorama123', 'books');
> if (mysqli_connect_errno())
> {
> echo 'Error: Could not connect to database. Please try again later.';
> exit;
> }
> $query = "select * from books where ".$searchtype." like
> '%".$searchterm."%'";
>
> $stmt = mysqli_stmt_init ( $db );
> //IF ( mysqli_stmt_prepare($stmt, "select * from books where
> ".$searchtype." like '%".?."%'") )
> IF ( mysqli_stmt_prepare($stmt, $query) )
> {
> // mysqli_stmt_bind_param($stmt, "s", $searchterm);
> mysqli_stmt_execute($stmt);
> //
>
> mysqli_stmt_bind_result($stmt, $v_title, $v_author, $v_isbn, $v_price);
>
> while (mysqli_stmt_fetch($stmt))
> {
>
> echo '<p><strong>'.($i+1).'. Title: ';
> echo htmlspecialchars(stripslashes($v_title));
> echo '</strong><br />Author: ';
> echo stripslashes($v_author);
> echo '<br />ISBN: ';
> echo stripslashes($v_isbn);
> echo '<br />Price: ';
> echo stripslashes($v_price);
> echo '</p>';
> }
>
> mysqli_stmt_close($stmt);
> }
> ELSE
> {
> ECHO 'Gone wrong.';
> }
>
> mysqli_close($db);
>
> ?>
> </body>
> </html>
>
Navigation:
[Reply to this message]
|