Connecting to mySQL db using php error checking

Question

When I run the script below on my browser all that prints out is 0: If I erase MySQL_errno I get nothing. How would I get a more detailed error?

 <?php
  $link = mysql_connect("192...", "root", "");
  mysql_select_db("visitors_tables");

  echo mysql_errno($link) . ": " . mysql_error($link). "\n";
  echo mysql_error();
   $query = "SELECT * FROM visitors";
  $result = mysql_query($query);
  while ($line = mysql_fetch_array($result))
  {
     foreach ($line as $value)
       {
     print "$value\n";
  }
  }
mysql_close($link);
?>

You can start by not using the mysql_*() functions in your script. stackoverflow.com/questions/12859942/… — WWW
– WWW, Commented Feb 20, 2014 at 15:48

kero · Accepted Answer · 2014-02-20 15:49:49Z

2

You aren't getting an error. But since mysql_errno() and mysql_error() is in no condition, it gets echoed anyway.

You can do it like this:

function showError($link) {
    return mysql_errno($link).': '.mysql_error($link);
}

$link = mysql_connect("192...", "root", "") or die(showError($link));
mysql_select_db("visitors_tables") or die(showError($link));
//etc.
$result = mysql_query($query) or die(showError($link));

or ...; only gets called when there actually is an error.

answered Feb 20, 2014 at 15:49

kero

10.7k5 gold badges44 silver badges52 bronze badges

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

1 Comment

Aaron Over a year ago

Thanks, I needed to test that my script is ok. It looks like the error is in my android code. On to the next problem

Akhil Sidharth · Accepted Answer · 2014-02-20 15:55:20Z

0

try using the below code. & insert the column_name you want to fetch at echo $line['column_name']

<?php
  $link = mysql_connect("192...", "root", "");
  if($link){
    mysql_select_db("visitors_tables");
  }
  $query = "SELECT * FROM visitors";
  $result = mysql_query($query);
  while ($line = mysql_fetch_array($result)){
    echo $line['column_name']
  }
mysql_close($link);
?>

answered Feb 20, 2014 at 15:55

Akhil Sidharth

7461 gold badge6 silver badges16 bronze badges

Collectives™ on Stack Overflow

Connecting to mySQL db using php error checking

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related