Mysql fetch array error 2

Question

I have this code:

<?php
include 'config.php';
date_default_timezone_set('America/Los_Angeles');
$d = date('Y-m-d');
$m = date("m");
$day = date("d");
$t = date("His");
$ip = $_SERVER['REMOTE_ADDR'];
$c = file_get_contents('http://api.wipmania.com/'.$ip);

echo "<h2>ALL RESULTS TODAY:</h2><table>";
$_GET['c'] = $c;
$sc = $_GET['sc'];
if($c === "key"){
    if($sc === "t"){
        $result = "SELECT * FROM main WHERE date = '$d' ORDER BY time";
        while($row = mysqli_fetch_array($result))
  {echo "<tr><td>".$row['key'] . "</td><td> " . $row['country']."</td><td>".$row['ip']."</td></tr>";  }
        }

}

echo '</table>';
?>

i have tried without $con: mysqli_fetch_array($result), but it was the same...

But nothings appear... no error no results... Please help... Thanks!

You need to run your query - $result = mysqli_query($con, $sql) or die (mysqli_error($con)), where $sql is the query you want to run, and $con is a valid mysqli database connection. — andrewsi
– andrewsi, Commented Aug 30, 2013 at 18:47
Please, before you write any more SQL interfacing code, you must read up on proper SQL escaping to avoid severe SQL injection bugs. When using mysqli you should be using parameterized queries and bind_param to add user data to your query. Never use string interpolation to accomplish this. — tadman
– tadman, Commented Aug 30, 2013 at 19:03

crowebird · Accepted Answer · 2013-08-30 18:48:01Z

1

You have not connected to the database or queried your results:

$conn = mysqli_connect($hostname,$username,$password,$dbname) or die(mysqli_error());
//...
$your_query = "SELECT * FROM main WHERE date = '$d' ORDER BY time";
$result = mysqli_query($conn, $your_query);
while ($row = mysqli_fetch_array($result)){
  //...
}

answered Aug 30, 2013 at 18:48

crowebird

2,5961 gold badge19 silver badges20 bronze badges

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

Comments

echo_Me · Accepted Answer · 2013-08-30 18:53:44Z

0

you forgot mysqli_query.

replace this

   $result = "SELECT * FROM main WHERE date = '$d' ORDER BY time";

by

   $result =mysqli_query("SELECT * FROM main WHERE date = '$d' ORDER BY time");

answered Aug 30, 2013 at 18:53

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

Comments

Barmar · Accepted Answer · 2013-08-30 18:48:24Z

0

You forgot to perform the query.

$result = mysqli_query($con, "SELECT * FROM main WHERE date = '$d' ORDER BY time");

answered Aug 30, 2013 at 18:48

Barmar

789k57 gold badges554 silver badges669 bronze badges

Collectives™ on Stack Overflow

Mysql fetch array error 2

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related