php mysql page not display data from mysql table row

Asked Mar 29 '18 at 15:54

Active Mar 29 '18 at 19:38

Viewed 41 times

When I run this I am getting no errors and no data back. What am I doing wrong?

Here is my code:

<?php
include 'connnectionmsql.php';

    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);

    //Query

    $sql = $conn->prepare("SELECT carid, carname FROM Cars WHERE carid = '1578'"); 

    $sql->execute() ;

?>
<div id="contents">
    <header>
        <div id="top">
            <div class="h2">
                <?php while( $row = $sql->fetch()) : ?>
                <h1><span><?php echo $row['carname']; ?></span>
                <?php endwhile ?>

edited Mar 29 '18 at 19:38

StaceyGirl

6,826
12
33
59

asked Mar 29 '18 at 15:54

John Paul

5

*"No errors"*. - I see no error handling whatsoever. – Funk Forty Niner Mar 29 '18 at 15:55
1

A lot of problems can be detected and resolved by [enabling exceptions in `mysqli`](https://stackoverflow.com/questions/14578243/turning-query-errors-to-exceptions-in-mysqli) so mistakes aren't easily ignored. – tadman Mar 29 '18 at 15:56
1

is there data in the table? – Richard Housham Mar 29 '18 at 15:57
this code is incomplete. So.... how are you running this off of? as `file:///`? on a hosted site? local? – Funk Forty Niner Mar 29 '18 at 15:57
yes there is data in the table hosted on linux server vps – John Paul Mar 29 '18 at 15:57
1

If the carid column is numeric remove the single quotes around it in your query. – Dave Mar 29 '18 at 15:58
also php errors. https://stackoverflow.com/questions/1053424/how-do-i-get-php-errors-to-display – Richard Housham Mar 29 '18 at 15:58
add some text around see what comes back – Richard Housham Mar 29 '18 at 15:58
text is coming back like it's having issue pulling the results – John Paul Mar 29 '18 at 16:01
No errors? try adding `ini_set('display_errors', 'On'); error_reporting(E_ALL | E_STRICT);` to the top – Raymond Nijland Mar 29 '18 at 16:02
added that line nothing – John Paul Mar 29 '18 at 16:04
What does the query return using phpAdmin (or similar)? – Sloan Thrasher Mar 29 '18 at 16:15
Showing rows 0 - 0 (1 total, Query took 0.0005 seconds.) 1578 Nissan – John Paul Mar 29 '18 at 16:18
1

If you're getting 0 rows then either your query is wrong or your table is empty (which you already said is not the case). @Dave above had a good suggestion. Is `carid` a numeric field? You have it in quotes. – Paulo Hgo Mar 29 '18 at 16:22
Its int(11) for field name carid – John Paul Mar 29 '18 at 16:24
$sql = $conn->prepare("SELECT carid, carname FROM Cars WHERE caridid = 1578"); still nothing – John Paul Mar 29 '18 at 16:26
1

You haven't bound the results to anything. "Fetch results from a prepared statement into the bound variables". See [bind_result()](http://php.net/manual/en/mysqli-stmt.bind-result.php) – Patrick Q Mar 29 '18 at 16:40

php mysql page not display data from mysql table row

0 Answers0