php not returning any echo

up vote
-1
down vote

favorite

I have a table which Displays the book list from mysql Database and search form where user can search books.
I"m looking forward to show the book list as per title and author when user search for by input value of title and author and display " NO Books by name or author" as echo when there is no any record.

My code is

<!DOCTYPE HTML>

<html>

    <body bgcolor="87ceeb">

        <center><h2>Central Department of Physics</h2></center>

        <br>

        <?php

        include("DBConnection.php");

        $search = isset($_REQUEST["search"]) ?  $_REQUEST["search"] : '';



        $query = "select ISBN,Title,Author,Edition,Publication from book_info where author like '%$search%' or title like '%$search%'"; 

        //search with a book name in the table book_info

        $result = mysqli_query($db,$query);





        ?>

        <a href="searchform.php" class="btn btn-primary">Go Back</a>

        <table border="2" align="center" cellpadding="5" cellspacing="5">

            <tr>

                <th> ISBN </th>

                <th> Title </th>

                <th> Author </th>

                <th> Edition </th>

                <th> Publication </th>

            </tr>

            <?php 

            if(mysqli_num_rows($result)>0){

                while($row = mysqli_fetch_assoc($result))

                {

            ?>

                <tr>



                    <td><?php echo $row["ISBN"];?> </td>

                    <td><?php echo $row["Title"];?> </td>

                    <td><?php echo $row["Author"];?> </td>

                    <td><?php echo $row["Edition"];?> </td>

                    <td><a href="<?php  echo $row["Publication"];?>" target="_blank">Click Me</a></td>



                </tr>



            <?php



                }



            }

            else{ ?>

                <tr>

                    <td colspan="5">

                        <center>No books found in the library by the name $search </center>

                    </td>

                </tr>



        <?php } ?>

        </table>

        

    </body>

</html>

<br>

My Search form is

<!DOCTYPE HTML>

<html>

<body bgcolor="87ceeb">



<form action = "DisplayBooks.php" method="get">

<br>

<center>Enter the title of the book to be searched :

<input type="text" name="search" size="48">

<br></br>

<input type="submit" value="submit">

<input type="reset" value="Reset">

</center>

<br>

</form>

</body>

</html>

But it sucessfully displays list of books but when there is no any record ..it don't launch echo.

ps. How can I add link button such that it shows Back to search results to navigate user to Searchform and user can go back to previous form.

edited Nov 22 at 4:31

Funk Forty Niner

80.4k124799

asked Nov 22 at 3:38

redface

196

This is open to SQL injection. Use a prepared statement if you value the time and effort you've put into this. We wouldn't want you to have your database compromised and possibly deleted.
– Funk Forty Niner
Nov 22 at 4:31

@FunkFortyNiner no it is just test it won't matter ....echo problems has been solved thanks to Delwar but I want to add button to go back to Serchform from results....that is only I"m not getting.
– redface
Nov 22 at 4:35

add a comment |

up vote
-1
down vote

favorite

My code is

<!DOCTYPE HTML>

<html>

    <body bgcolor="87ceeb">

        <center><h2>Central Department of Physics</h2></center>

        <br>

        <?php

        include("DBConnection.php");

        $search = isset($_REQUEST["search"]) ?  $_REQUEST["search"] : '';



        $query = "select ISBN,Title,Author,Edition,Publication from book_info where author like '%$search%' or title like '%$search%'"; 

        //search with a book name in the table book_info

        $result = mysqli_query($db,$query);





        ?>

        <a href="searchform.php" class="btn btn-primary">Go Back</a>

        <table border="2" align="center" cellpadding="5" cellspacing="5">

            <tr>

                <th> ISBN </th>

                <th> Title </th>

                <th> Author </th>

                <th> Edition </th>

                <th> Publication </th>

            </tr>

            <?php 

            if(mysqli_num_rows($result)>0){

                while($row = mysqli_fetch_assoc($result))

                {

            ?>

                <tr>



                    <td><?php echo $row["ISBN"];?> </td>

                    <td><?php echo $row["Title"];?> </td>

                    <td><?php echo $row["Author"];?> </td>

                    <td><?php echo $row["Edition"];?> </td>

                    <td><a href="<?php  echo $row["Publication"];?>" target="_blank">Click Me</a></td>



                </tr>



            <?php



                }



            }

            else{ ?>

                <tr>

                    <td colspan="5">

                        <center>No books found in the library by the name $search </center>

                    </td>

                </tr>



        <?php } ?>

        </table>

        

    </body>

</html>

<br>

My Search form is

<!DOCTYPE HTML>

<html>

<body bgcolor="87ceeb">



<form action = "DisplayBooks.php" method="get">

<br>

<center>Enter the title of the book to be searched :

<input type="text" name="search" size="48">

<br></br>

<input type="submit" value="submit">

<input type="reset" value="Reset">

</center>

<br>

</form>

</body>

</html>

But it sucessfully displays list of books but when there is no any record ..it don't launch echo.

ps. How can I add link button such that it shows Back to search results to navigate user to Searchform and user can go back to previous form.

edited Nov 22 at 4:31

Funk Forty Niner

80.4k124799

asked Nov 22 at 3:38

redface

196

This is open to SQL injection. Use a prepared statement if you value the time and effort you've put into this. We wouldn't want you to have your database compromised and possibly deleted.
– Funk Forty Niner
Nov 22 at 4:31

@FunkFortyNiner no it is just test it won't matter ....echo problems has been solved thanks to Delwar but I want to add button to go back to Serchform from results....that is only I"m not getting.
– redface
Nov 22 at 4:35

add a comment |

up vote
-1
down vote

favorite

My code is

<!DOCTYPE HTML>

<html>

    <body bgcolor="87ceeb">

        <center><h2>Central Department of Physics</h2></center>

        <br>

        <?php

        include("DBConnection.php");

        $search = isset($_REQUEST["search"]) ?  $_REQUEST["search"] : '';



        $query = "select ISBN,Title,Author,Edition,Publication from book_info where author like '%$search%' or title like '%$search%'"; 

        //search with a book name in the table book_info

        $result = mysqli_query($db,$query);





        ?>

        <a href="searchform.php" class="btn btn-primary">Go Back</a>

        <table border="2" align="center" cellpadding="5" cellspacing="5">

            <tr>

                <th> ISBN </th>

                <th> Title </th>

                <th> Author </th>

                <th> Edition </th>

                <th> Publication </th>

            </tr>

            <?php 

            if(mysqli_num_rows($result)>0){

                while($row = mysqli_fetch_assoc($result))

                {

            ?>

                <tr>



                    <td><?php echo $row["ISBN"];?> </td>

                    <td><?php echo $row["Title"];?> </td>

                    <td><?php echo $row["Author"];?> </td>

                    <td><?php echo $row["Edition"];?> </td>

                    <td><a href="<?php  echo $row["Publication"];?>" target="_blank">Click Me</a></td>



                </tr>



            <?php



                }



            }

            else{ ?>

                <tr>

                    <td colspan="5">

                        <center>No books found in the library by the name $search </center>

                    </td>

                </tr>



        <?php } ?>

        </table>

        

    </body>

</html>

<br>

My Search form is

<!DOCTYPE HTML>

<html>

<body bgcolor="87ceeb">



<form action = "DisplayBooks.php" method="get">

<br>

<center>Enter the title of the book to be searched :

<input type="text" name="search" size="48">

<br></br>

<input type="submit" value="submit">

<input type="reset" value="Reset">

</center>

<br>

</form>

</body>

</html>

But it sucessfully displays list of books but when there is no any record ..it don't launch echo.

ps. How can I add link button such that it shows Back to search results to navigate user to Searchform and user can go back to previous form.

edited Nov 22 at 4:31

Funk Forty Niner

80.4k124799

asked Nov 22 at 3:38

redface

196

My code is

<!DOCTYPE HTML>

<html>

    <body bgcolor="87ceeb">

        <center><h2>Central Department of Physics</h2></center>

        <br>

        <?php

        include("DBConnection.php");

        $search = isset($_REQUEST["search"]) ?  $_REQUEST["search"] : '';



        $query = "select ISBN,Title,Author,Edition,Publication from book_info where author like '%$search%' or title like '%$search%'"; 

        //search with a book name in the table book_info

        $result = mysqli_query($db,$query);





        ?>

        <a href="searchform.php" class="btn btn-primary">Go Back</a>

        <table border="2" align="center" cellpadding="5" cellspacing="5">

            <tr>

                <th> ISBN </th>

                <th> Title </th>

                <th> Author </th>

                <th> Edition </th>

                <th> Publication </th>

            </tr>

            <?php 

            if(mysqli_num_rows($result)>0){

                while($row = mysqli_fetch_assoc($result))

                {

            ?>

                <tr>



                    <td><?php echo $row["ISBN"];?> </td>

                    <td><?php echo $row["Title"];?> </td>

                    <td><?php echo $row["Author"];?> </td>

                    <td><?php echo $row["Edition"];?> </td>

                    <td><a href="<?php  echo $row["Publication"];?>" target="_blank">Click Me</a></td>



                </tr>



            <?php



                }



            }

            else{ ?>

                <tr>

                    <td colspan="5">

                        <center>No books found in the library by the name $search </center>

                    </td>

                </tr>



        <?php } ?>

        </table>

        

    </body>

</html>

<br>

My Search form is

<!DOCTYPE HTML>

<html>

<body bgcolor="87ceeb">



<form action = "DisplayBooks.php" method="get">

<br>

<center>Enter the title of the book to be searched :

<input type="text" name="search" size="48">

<br></br>

<input type="submit" value="submit">

<input type="reset" value="Reset">

</center>

<br>

</form>

</body>

</html>

But it sucessfully displays list of books but when there is no any record ..it don't launch echo.

ps. How can I add link button such that it shows Back to search results to navigate user to Searchform and user can go back to previous form.

<!DOCTYPE HTML>

<html>

    <body bgcolor="87ceeb">

        <center><h2>Central Department of Physics</h2></center>

        <br>

        <?php

        include("DBConnection.php");

        $search = isset($_REQUEST["search"]) ?  $_REQUEST["search"] : '';



        $query = "select ISBN,Title,Author,Edition,Publication from book_info where author like '%$search%' or title like '%$search%'"; 

        //search with a book name in the table book_info

        $result = mysqli_query($db,$query);





        ?>

        <a href="searchform.php" class="btn btn-primary">Go Back</a>

        <table border="2" align="center" cellpadding="5" cellspacing="5">

            <tr>

                <th> ISBN </th>

                <th> Title </th>

                <th> Author </th>

                <th> Edition </th>

                <th> Publication </th>

            </tr>

            <?php 

            if(mysqli_num_rows($result)>0){

                while($row = mysqli_fetch_assoc($result))

                {

            ?>

                <tr>



                    <td><?php echo $row["ISBN"];?> </td>

                    <td><?php echo $row["Title"];?> </td>

                    <td><?php echo $row["Author"];?> </td>

                    <td><?php echo $row["Edition"];?> </td>

                    <td><a href="<?php  echo $row["Publication"];?>" target="_blank">Click Me</a></td>



                </tr>



            <?php



                }



            }

            else{ ?>

                <tr>

                    <td colspan="5">

                        <center>No books found in the library by the name $search </center>

                    </td>

                </tr>



        <?php } ?>

        </table>

        

    </body>

</html>

<br>

<!DOCTYPE HTML>

<html>

    <body bgcolor="87ceeb">

        <center><h2>Central Department of Physics</h2></center>

        <br>

        <?php

        include("DBConnection.php");

        $search = isset($_REQUEST["search"]) ?  $_REQUEST["search"] : '';



        $query = "select ISBN,Title,Author,Edition,Publication from book_info where author like '%$search%' or title like '%$search%'"; 

        //search with a book name in the table book_info

        $result = mysqli_query($db,$query);





        ?>

        <a href="searchform.php" class="btn btn-primary">Go Back</a>

        <table border="2" align="center" cellpadding="5" cellspacing="5">

            <tr>

                <th> ISBN </th>

                <th> Title </th>

                <th> Author </th>

                <th> Edition </th>

                <th> Publication </th>

            </tr>

            <?php 

            if(mysqli_num_rows($result)>0){

                while($row = mysqli_fetch_assoc($result))

                {

            ?>

                <tr>



                    <td><?php echo $row["ISBN"];?> </td>

                    <td><?php echo $row["Title"];?> </td>

                    <td><?php echo $row["Author"];?> </td>

                    <td><?php echo $row["Edition"];?> </td>

                    <td><a href="<?php  echo $row["Publication"];?>" target="_blank">Click Me</a></td>



                </tr>



            <?php



                }



            }

            else{ ?>

                <tr>

                    <td colspan="5">

                        <center>No books found in the library by the name $search </center>

                    </td>

                </tr>



        <?php } ?>

        </table>

        

    </body>

</html>

<br>

<!DOCTYPE HTML>

<html>

<body bgcolor="87ceeb">



<form action = "DisplayBooks.php" method="get">

<br>

<center>Enter the title of the book to be searched :

<input type="text" name="search" size="48">

<br></br>

<input type="submit" value="submit">

<input type="reset" value="Reset">

</center>

<br>

</form>

</body>

</html>

<!DOCTYPE HTML>

<html>

<body bgcolor="87ceeb">



<form action = "DisplayBooks.php" method="get">

<br>

<center>Enter the title of the book to be searched :

<input type="text" name="search" size="48">

<br></br>

<input type="submit" value="submit">

<input type="reset" value="Reset">

</center>

<br>

</form>

</body>

</html>

php mysql forms mysqli

edited Nov 22 at 4:31

Funk Forty Niner

80.4k124799

asked Nov 22 at 3:38

redface

196

edited Nov 22 at 4:31

Funk Forty Niner

80.4k124799

asked Nov 22 at 3:38

redface

196

edited Nov 22 at 4:31

Funk Forty Niner

80.4k124799

edited Nov 22 at 4:31

Funk Forty Niner

80.4k124799

edited Nov 22 at 4:31

Funk Forty Niner

80.4k124799

asked Nov 22 at 3:38

redface

196

asked Nov 22 at 3:38

redface

196

asked Nov 22 at 3:38

redface

196

This is open to SQL injection. Use a prepared statement if you value the time and effort you've put into this. We wouldn't want you to have your database compromised and possibly deleted.
– Funk Forty Niner
Nov 22 at 4:31

@FunkFortyNiner no it is just test it won't matter ....echo problems has been solved thanks to Delwar but I want to add button to go back to Serchform from results....that is only I"m not getting.
– redface
Nov 22 at 4:35

add a comment |

This is open to SQL injection. Use a prepared statement if you value the time and effort you've put into this. We wouldn't want you to have your database compromised and possibly deleted.
– Funk Forty Niner
Nov 22 at 4:31

@FunkFortyNiner no it is just test it won't matter ....echo problems has been solved thanks to Delwar but I want to add button to go back to Serchform from results....that is only I"m not getting.
– redface
Nov 22 at 4:35

This is open to SQL injection. Use a prepared statement if you value the time and effort you've put into this. We wouldn't want you to have your database compromised and possibly deleted.
– Funk Forty Niner
Nov 22 at 4:31

@FunkFortyNiner no it is just test it won't matter ....echo problems has been solved thanks to Delwar but I want to add button to go back to Serchform from results....that is only I"m not getting.
– redface
Nov 22 at 4:35

add a comment |

2 Answers
2

active

oldest

votes

up vote
-1
down vote

accepted

Try This:

<!DOCTYPE HTML>

<html>

    <body bgcolor="87ceeb">

        <center><h2>Central Department of Physics</h2></center>

        <br>

        <?php

        include("DBConnection.php");

        $search = isset($_REQUEST["search"]) ?  $_REQUEST["search"] : '';



        $query = "select ISBN,Title,Author,Edition,Publication from book_info where author like '%$search%' or title like '%$search%'"; 

        //search with a book name in the table book_info

        $result = mysqli_query($db,$query);





        ?>

        <table border="2" align="center" cellpadding="5" cellspacing="5">

            <tr>

                <th> ISBN </th>

                <th> Title </th>

                <th> Author </th>

                <th> Edition </th>

                <th> Publication </th>

            </tr>

            <?php 

            if(mysqli_num_rows($result)>0){

                while($row = mysqli_fetch_assoc($result))

                {

            ?>

                <tr>



                    <td><?php echo $row["ISBN"];?> </td>

                    <td><?php echo $row["Title"];?> </td>

                    <td><?php echo $row["Author"];?> </td>

                    <td><?php echo $row["Edition"];?> </td>



                    <td><a href="<?php  echo $row["Publication"];?>" target="_blank">Click Me</a></td>

                </tr>



            <?php



                }



            }

            else{ ?>

                <tr>

                    <td colspan="5">

                        <center>No books found in the library by the name $search </center>

                    </td>

                </tr>



        <?php } ?>

        </table>

    </body>

</html>

<br>

answered Nov 22 at 3:53

Delwar Sumon

374112

ok it works..lastly One question How can I add link such that whether it displays book result or echo ..there will be a BUtton with Go back to search and when user click it will navigate back to search form. any help?
– redface
Nov 22 at 4:11

You can add anchor tag anywhere in showing result page.... Like this -> <a href="search page link" class="btn btn-primary">Go Back</a> ...btn btn-primary -> Basically this classes are design of button in bootstrap
– Delwar Sumon
Nov 22 at 4:15

Umm but I have to add in displayBooks.php form which will show even when no search is made....I only want to show it when user goes to serchform and when click on submit button then it will open Displaybooks form only with books that match the result and also show the link to go back to search form again similar to echo which displays when only search is made in displaybooks form...!!
– redface
Nov 22 at 4:19

<a href="searchform.php" class="btn btn-primary">Go Back</a>....add this to displayBooks.php up on the table.
– Delwar Sumon
Nov 22 at 4:24

Please tell everyone by editing your answer to tell us what exactly it is you did to solve the question. It makes it very hard to compare between both the OP's code and the answer here.
– Funk Forty Niner
Nov 22 at 4:30

|
show 3 more comments

up vote
1
down vote

You have duplicated your check for "no results":

if(mysqli_num_rows($result)>0)if(mysqli_num_rows($result)>0)

Remove one.

answered Nov 22 at 3:51

Joni

75.4k996148

This answer was entirely clear and IMHO, should have been the accepted answer. The other one being a "Try this", was hard for me to compare what it was exactly they did to deserve it being accepted/awarded. For all I know, there could have been more things wrong with the OP's code.
– Funk Forty Niner
Nov 22 at 4:29

"surely such a mysterious problem has a more complex solution" - non-experts
– Joni
Nov 22 at 16:09

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53423536%2fphp-not-returning-any-echo%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

up vote
-1
down vote

accepted

Try This:

<!DOCTYPE HTML>

<html>

    <body bgcolor="87ceeb">

        <center><h2>Central Department of Physics</h2></center>

        <br>

        <?php

        include("DBConnection.php");

        $search = isset($_REQUEST["search"]) ?  $_REQUEST["search"] : '';



        $query = "select ISBN,Title,Author,Edition,Publication from book_info where author like '%$search%' or title like '%$search%'"; 

        //search with a book name in the table book_info

        $result = mysqli_query($db,$query);





        ?>

        <table border="2" align="center" cellpadding="5" cellspacing="5">

            <tr>

                <th> ISBN </th>

                <th> Title </th>

                <th> Author </th>

                <th> Edition </th>

                <th> Publication </th>

            </tr>

            <?php 

            if(mysqli_num_rows($result)>0){

                while($row = mysqli_fetch_assoc($result))

                {

            ?>

                <tr>



                    <td><?php echo $row["ISBN"];?> </td>

                    <td><?php echo $row["Title"];?> </td>

                    <td><?php echo $row["Author"];?> </td>

                    <td><?php echo $row["Edition"];?> </td>



                    <td><a href="<?php  echo $row["Publication"];?>" target="_blank">Click Me</a></td>

                </tr>



            <?php



                }



            }

            else{ ?>

                <tr>

                    <td colspan="5">

                        <center>No books found in the library by the name $search </center>

                    </td>

                </tr>



        <?php } ?>

        </table>

    </body>

</html>

<br>

answered Nov 22 at 3:53

Delwar Sumon

374112

ok it works..lastly One question How can I add link such that whether it displays book result or echo ..there will be a BUtton with Go back to search and when user click it will navigate back to search form. any help?
– redface
Nov 22 at 4:11

You can add anchor tag anywhere in showing result page.... Like this -> <a href="search page link" class="btn btn-primary">Go Back</a> ...btn btn-primary -> Basically this classes are design of button in bootstrap
– Delwar Sumon
Nov 22 at 4:15

Umm but I have to add in displayBooks.php form which will show even when no search is made....I only want to show it when user goes to serchform and when click on submit button then it will open Displaybooks form only with books that match the result and also show the link to go back to search form again similar to echo which displays when only search is made in displaybooks form...!!
– redface
Nov 22 at 4:19

<a href="searchform.php" class="btn btn-primary">Go Back</a>....add this to displayBooks.php up on the table.
– Delwar Sumon
Nov 22 at 4:24

Please tell everyone by editing your answer to tell us what exactly it is you did to solve the question. It makes it very hard to compare between both the OP's code and the answer here.
– Funk Forty Niner
Nov 22 at 4:30

|
show 3 more comments

up vote
-1
down vote

accepted

Try This:

<!DOCTYPE HTML>

<html>

    <body bgcolor="87ceeb">

        <center><h2>Central Department of Physics</h2></center>

        <br>

        <?php

        include("DBConnection.php");

        $search = isset($_REQUEST["search"]) ?  $_REQUEST["search"] : '';



        $query = "select ISBN,Title,Author,Edition,Publication from book_info where author like '%$search%' or title like '%$search%'"; 

        //search with a book name in the table book_info

        $result = mysqli_query($db,$query);





        ?>

        <table border="2" align="center" cellpadding="5" cellspacing="5">

            <tr>

                <th> ISBN </th>

                <th> Title </th>

                <th> Author </th>

                <th> Edition </th>

                <th> Publication </th>

            </tr>

            <?php 

            if(mysqli_num_rows($result)>0){

                while($row = mysqli_fetch_assoc($result))

                {

            ?>

                <tr>



                    <td><?php echo $row["ISBN"];?> </td>

                    <td><?php echo $row["Title"];?> </td>

                    <td><?php echo $row["Author"];?> </td>

                    <td><?php echo $row["Edition"];?> </td>



                    <td><a href="<?php  echo $row["Publication"];?>" target="_blank">Click Me</a></td>

                </tr>



            <?php



                }



            }

            else{ ?>

                <tr>

                    <td colspan="5">

                        <center>No books found in the library by the name $search </center>

                    </td>

                </tr>



        <?php } ?>

        </table>

    </body>

</html>

<br>

answered Nov 22 at 3:53

Delwar Sumon

374112

ok it works..lastly One question How can I add link such that whether it displays book result or echo ..there will be a BUtton with Go back to search and when user click it will navigate back to search form. any help?
– redface
Nov 22 at 4:11

You can add anchor tag anywhere in showing result page.... Like this -> <a href="search page link" class="btn btn-primary">Go Back</a> ...btn btn-primary -> Basically this classes are design of button in bootstrap
– Delwar Sumon
Nov 22 at 4:15

Umm but I have to add in displayBooks.php form which will show even when no search is made....I only want to show it when user goes to serchform and when click on submit button then it will open Displaybooks form only with books that match the result and also show the link to go back to search form again similar to echo which displays when only search is made in displaybooks form...!!
– redface
Nov 22 at 4:19

<a href="searchform.php" class="btn btn-primary">Go Back</a>....add this to displayBooks.php up on the table.
– Delwar Sumon
Nov 22 at 4:24

Please tell everyone by editing your answer to tell us what exactly it is you did to solve the question. It makes it very hard to compare between both the OP's code and the answer here.
– Funk Forty Niner
Nov 22 at 4:30

|
show 3 more comments

up vote
-1
down vote

accepted

Try This:

<!DOCTYPE HTML>

<html>

    <body bgcolor="87ceeb">

        <center><h2>Central Department of Physics</h2></center>

        <br>

        <?php

        include("DBConnection.php");

        $search = isset($_REQUEST["search"]) ?  $_REQUEST["search"] : '';



        $query = "select ISBN,Title,Author,Edition,Publication from book_info where author like '%$search%' or title like '%$search%'"; 

        //search with a book name in the table book_info

        $result = mysqli_query($db,$query);





        ?>

        <table border="2" align="center" cellpadding="5" cellspacing="5">

            <tr>

                <th> ISBN </th>

                <th> Title </th>

                <th> Author </th>

                <th> Edition </th>

                <th> Publication </th>

            </tr>

            <?php 

            if(mysqli_num_rows($result)>0){

                while($row = mysqli_fetch_assoc($result))

                {

            ?>

                <tr>



                    <td><?php echo $row["ISBN"];?> </td>

                    <td><?php echo $row["Title"];?> </td>

                    <td><?php echo $row["Author"];?> </td>

                    <td><?php echo $row["Edition"];?> </td>



                    <td><a href="<?php  echo $row["Publication"];?>" target="_blank">Click Me</a></td>

                </tr>



            <?php



                }



            }

            else{ ?>

                <tr>

                    <td colspan="5">

                        <center>No books found in the library by the name $search </center>

                    </td>

                </tr>



        <?php } ?>

        </table>

    </body>

</html>

<br>

answered Nov 22 at 3:53

Delwar Sumon

374112

Try This:

<!DOCTYPE HTML>

<html>

    <body bgcolor="87ceeb">

        <center><h2>Central Department of Physics</h2></center>

        <br>

        <?php

        include("DBConnection.php");

        $search = isset($_REQUEST["search"]) ?  $_REQUEST["search"] : '';



        $query = "select ISBN,Title,Author,Edition,Publication from book_info where author like '%$search%' or title like '%$search%'"; 

        //search with a book name in the table book_info

        $result = mysqli_query($db,$query);





        ?>

        <table border="2" align="center" cellpadding="5" cellspacing="5">

            <tr>

                <th> ISBN </th>

                <th> Title </th>

                <th> Author </th>

                <th> Edition </th>

                <th> Publication </th>

            </tr>

            <?php 

            if(mysqli_num_rows($result)>0){

                while($row = mysqli_fetch_assoc($result))

                {

            ?>

                <tr>



                    <td><?php echo $row["ISBN"];?> </td>

                    <td><?php echo $row["Title"];?> </td>

                    <td><?php echo $row["Author"];?> </td>

                    <td><?php echo $row["Edition"];?> </td>



                    <td><a href="<?php  echo $row["Publication"];?>" target="_blank">Click Me</a></td>

                </tr>



            <?php



                }



            }

            else{ ?>

                <tr>

                    <td colspan="5">

                        <center>No books found in the library by the name $search </center>

                    </td>

                </tr>



        <?php } ?>

        </table>

    </body>

</html>

<br>

answered Nov 22 at 3:53

Delwar Sumon

374112

answered Nov 22 at 3:53

Delwar Sumon

374112

answered Nov 22 at 3:53

Delwar Sumon

374112

answered Nov 22 at 3:53

Delwar Sumon

374112

ok it works..lastly One question How can I add link such that whether it displays book result or echo ..there will be a BUtton with Go back to search and when user click it will navigate back to search form. any help?
– redface
Nov 22 at 4:11

You can add anchor tag anywhere in showing result page.... Like this -> <a href="search page link" class="btn btn-primary">Go Back</a> ...btn btn-primary -> Basically this classes are design of button in bootstrap
– Delwar Sumon
Nov 22 at 4:15

Umm but I have to add in displayBooks.php form which will show even when no search is made....I only want to show it when user goes to serchform and when click on submit button then it will open Displaybooks form only with books that match the result and also show the link to go back to search form again similar to echo which displays when only search is made in displaybooks form...!!
– redface
Nov 22 at 4:19

<a href="searchform.php" class="btn btn-primary">Go Back</a>....add this to displayBooks.php up on the table.
– Delwar Sumon
Nov 22 at 4:24

Please tell everyone by editing your answer to tell us what exactly it is you did to solve the question. It makes it very hard to compare between both the OP's code and the answer here.
– Funk Forty Niner
Nov 22 at 4:30

|
show 3 more comments

ok it works..lastly One question How can I add link such that whether it displays book result or echo ..there will be a BUtton with Go back to search and when user click it will navigate back to search form. any help?
– redface
Nov 22 at 4:11

You can add anchor tag anywhere in showing result page.... Like this -> <a href="search page link" class="btn btn-primary">Go Back</a> ...btn btn-primary -> Basically this classes are design of button in bootstrap
– Delwar Sumon
Nov 22 at 4:15

Umm but I have to add in displayBooks.php form which will show even when no search is made....I only want to show it when user goes to serchform and when click on submit button then it will open Displaybooks form only with books that match the result and also show the link to go back to search form again similar to echo which displays when only search is made in displaybooks form...!!
– redface
Nov 22 at 4:19

<a href="searchform.php" class="btn btn-primary">Go Back</a>....add this to displayBooks.php up on the table.
– Delwar Sumon
Nov 22 at 4:24

Please tell everyone by editing your answer to tell us what exactly it is you did to solve the question. It makes it very hard to compare between both the OP's code and the answer here.
– Funk Forty Niner
Nov 22 at 4:30

ok it works..lastly One question How can I add link such that whether it displays book result or echo ..there will be a BUtton with Go back to search and when user click it will navigate back to search form. any help?
– redface
Nov 22 at 4:11

You can add anchor tag anywhere in showing result page.... Like this -> <a href="search page link" class="btn btn-primary">Go Back</a> ...btn btn-primary -> Basically this classes are design of button in bootstrap
– Delwar Sumon
Nov 22 at 4:15

Umm but I have to add in displayBooks.php form which will show even when no search is made....I only want to show it when user goes to serchform and when click on submit button then it will open Displaybooks form only with books that match the result and also show the link to go back to search form again similar to echo which displays when only search is made in displaybooks form...!!
– redface
Nov 22 at 4:19

<a href="searchform.php" class="btn btn-primary">Go Back</a>....add this to displayBooks.php up on the table.
– Delwar Sumon
Nov 22 at 4:24

Please tell everyone by editing your answer to tell us what exactly it is you did to solve the question. It makes it very hard to compare between both the OP's code and the answer here.
– Funk Forty Niner
Nov 22 at 4:30

|
show 3 more comments

up vote
1
down vote

You have duplicated your check for "no results":

if(mysqli_num_rows($result)>0)if(mysqli_num_rows($result)>0)

Remove one.

answered Nov 22 at 3:51

Joni

75.4k996148

This answer was entirely clear and IMHO, should have been the accepted answer. The other one being a "Try this", was hard for me to compare what it was exactly they did to deserve it being accepted/awarded. For all I know, there could have been more things wrong with the OP's code.
– Funk Forty Niner
Nov 22 at 4:29

"surely such a mysterious problem has a more complex solution" - non-experts
– Joni
Nov 22 at 16:09

add a comment |

up vote
1
down vote

You have duplicated your check for "no results":

if(mysqli_num_rows($result)>0)if(mysqli_num_rows($result)>0)

Remove one.

answered Nov 22 at 3:51

Joni

75.4k996148

This answer was entirely clear and IMHO, should have been the accepted answer. The other one being a "Try this", was hard for me to compare what it was exactly they did to deserve it being accepted/awarded. For all I know, there could have been more things wrong with the OP's code.
– Funk Forty Niner
Nov 22 at 4:29

"surely such a mysterious problem has a more complex solution" - non-experts
– Joni
Nov 22 at 16:09

add a comment |

up vote
1
down vote

You have duplicated your check for "no results":

if(mysqli_num_rows($result)>0)if(mysqli_num_rows($result)>0)

Remove one.

answered Nov 22 at 3:51

Joni

75.4k996148

You have duplicated your check for "no results":

if(mysqli_num_rows($result)>0)if(mysqli_num_rows($result)>0)

Remove one.

answered Nov 22 at 3:51

Joni

75.4k996148

answered Nov 22 at 3:51

Joni

75.4k996148

answered Nov 22 at 3:51

Joni

75.4k996148

answered Nov 22 at 3:51

Joni

75.4k996148

This answer was entirely clear and IMHO, should have been the accepted answer. The other one being a "Try this", was hard for me to compare what it was exactly they did to deserve it being accepted/awarded. For all I know, there could have been more things wrong with the OP's code.
– Funk Forty Niner
Nov 22 at 4:29

"surely such a mysterious problem has a more complex solution" - non-experts
– Joni
Nov 22 at 16:09

add a comment |

This answer was entirely clear and IMHO, should have been the accepted answer. The other one being a "Try this", was hard for me to compare what it was exactly they did to deserve it being accepted/awarded. For all I know, there could have been more things wrong with the OP's code.
– Funk Forty Niner
Nov 22 at 4:29

"surely such a mysterious problem has a more complex solution" - non-experts
– Joni
Nov 22 at 16:09

This answer was entirely clear and IMHO, should have been the accepted answer. The other one being a "Try this", was hard for me to compare what it was exactly they did to deserve it being accepted/awarded. For all I know, there could have been more things wrong with the OP's code.
– Funk Forty Niner
Nov 22 at 4:29

"surely such a mysterious problem has a more complex solution" - non-experts
– Joni
Nov 22 at 16:09

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Qfyilyi