PHP MySQL query returning zero results when table has data

Question

My PHP query is returning zero results when the table has 10 rows. What is actually displayed is a portion of the PHP table formatting code.

ACTUAL OUTPUT:

0) { // output data of each row while($row = mysql_fetch_assoc($result)) { echo "in: " . $row["in"]. " - Name: " . $row["Name"]. " - Email: " . $row["Email"]. "
"; } } else { echo "0 re
sults"; } mysql_close($conn);?

HTML/PHP CODE:

<div class="about-text">

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "db";

// Create connection
$conn = mysql_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysql_connect_error());
}

$sql = "SELECT * FROM tablename";
$result = mysql_query($conn, $sql);

if (mysql_num_rows($result) > 0) {
    // output data of each row
    while($row = mysql_fetch_assoc($result)) {
        echo "in: " . $row["in"]. " - Name: " . $row["Name"]. " - Email: " . $row["Email"]. "<br>";
    }
} else {
    echo "0 results";
}

mysql_close($conn);
?>

</div>

you must stop using mysql_ -- php.net/manual/en/mysqlinfo.api.choosing.php — hanshenrik
– hanshenrik, Commented Sep 19, 2015 at 16:06
check out wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers — hanshenrik
– hanshenrik, Commented Sep 19, 2015 at 16:06

M0rtiis · Accepted Answer · 2015-09-19 04:50:55Z

0

http://php.net/manual/en/function.mysql-query.php

replace

$result = mysql_query($conn, $sql);

with

$result = mysql_query($sql, $conn);

answered Sep 19, 2015 at 4:50

M0rtiis

3,7611 gold badge17 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

VolkerK · Accepted Answer · 2015-09-19 05:02:05Z

Passing the connection resource/instance as the first parameter is the style of the mysqli extension, which you should use, instead of passing the resource as the second parameter (optional) - which is how the old and now deprecated mysql_* extension does it. mysql_* will be removed with the upcoming php version 7.

<?php
$mysqli = mysqli_connect('localhost', 'root', '', 'db');
if ($mysqli->connect_errno) {
    die("Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error);
}

$sql = "SELECT `in`,`Name`,`Email` FROM tablename";
$result = mysqli_query($mysqli, $sql);
if ( !$result ) {
    die('query failed: '.$mysqli->error);
}

$row = mysqli_fetch_array($result);
if ( !$row ) {
    echo '0 results';
}
else {
    do {
        echo "in: " . $row["in"]. " - Name: " . $row["Name"]. " - Email: " . $row["Email"]. "<br>\r\n";
    }
    while( NULL!=($row=mysqli_fetch_array($result)) );
}

noushid p · Accepted Answer · 2015-09-19 06:35:04Z

0

you can use mysqli extension

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "your_db";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
$sql = "SELECT * FROM mytable";
$result = mysqli_query( $conn, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "in: " . $row["id"]. " - Name: " . $row["Name"]. " - Email: " . $row["Email"]. "<br>";
    }
} else {
    echo "0 results";
}
mysqli_close($conn);
?>

answered Sep 19, 2015 at 6:35

noushid p

1,4935 gold badges17 silver badges29 bronze badges

1 Comment

treponema Over a year ago

Are mysqli extensions supported in PHP 4.4.4? That is what is currently running on the server I'm using.

Manisha Chaudhary · Accepted Answer · 2015-09-19 07:17:49Z

Try this code. This is your confic.php file:

<?php
$hostname = "localhost";
$username = "root";
$password = "";
$dbname = "database_name";

$connection = mysql_connect($hostname, $username, $password, $dbname);

if (!$connection) {

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

And make new php file and include your config file:

<?php
include('config.php');
$sql = "SELECT * FROM table_name";
$result = mysql_query($sql);

if (mysql_num_rows($result) > 0) {

    while($row = mysql_fetch_assoc($result)) {

        ?>
            <div class="about-text">
                <?php
                    echo "In: ".$row["in"]."Name: ". $row['Name'].","."Email: ".$row['Email']."</br>";
                ?>
            </div>
        <?php
    }
}else{
    echo "There is no Result!!!!";
}
mysql_close($connection);

i think this will help you.

Collectives™ on Stack Overflow

PHP MySQL query returning zero results when table has data

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related