mysql php problem: no error message despite error_reporting(E_ALL) line

Question

index.php

<html>
  <head>
    <title>Josh's Online Playground</title>
  </head>
  <body>

    <form method="POST" action="action.php">
      <table>
        <tr>
      <td>"data for stuff"</td>
      <td><input type="text" ?></td>
    </tr>

        <tr>
          <td><input type="submit"></td>
        </tr>
      </table>
    </form>

  </body>
</html>

action.php

<?php
  error_reporting(E_ALL);
  ini_sit("display_errors", 1);

  $mysqli = new mysqli('localhost', 'root', 'password', 'website');

  $result = $mysqli->query("insert into stuff (data) values ('
        .$_POST['data']
        ."');

  echo $mysqli->error();

  if($result = $mysqli->query("select data from stuff")){
    echo 'There are '.$result->num_rows.' results.';
  }

  while ($row = $result->fetch_object()){
    echo 'stuff' . $row->data;
  }
?>

Despite the first two lines in action.php, I get no error or warning messages. Instead I get a blank page after clicking the submit button.

Do I have to do something differently to insert data?

Haim Evgi · Accepted Answer · 2010-06-15 10:53:15Z

3

you have a syntax error in action.php :

ini_set not ini_sit in line 2 !

answered Jun 15, 2010 at 10:53

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

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

Comments

oezi · Accepted Answer · 2010-06-15 10:58:03Z

1

ini_sit

has to be

ini_set

;)

answered Jun 15, 2010 at 10:58

oezi

51.9k10 gold badges102 silver badges119 bronze badges

Comments

Mark Baker · Accepted Answer · 2010-06-15 11:06:36Z

1

You have a fatal error, so the script simply cannot run, and therefore cannot report any errors. Look at this line:

$result = $mysqli->query("insert into stuff (data) values ('
        .$_POST['data']
        ."');

Should read:

$result = $mysqli->query("insert into stuff (data) values ('".$_POST['data']."')");

And escape your $_POST['data'] value before using it in the SQL statement

edited Jun 15, 2010 at 11:06

answered Jun 15, 2010 at 10:53

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

2 Comments

lowerkey Over a year ago

I fixed that. But still no results. The line now reads: $result = $mysqli->query("insert into stuff (data) values ('" . $_POST['data'] . "')";

Mark Baker Over a year ago

get into the habit of using an editor with syntax highlighting, and it becomes much easier to see errors such as this... if you look at your original posting, it's obvious even there.

greg0ire · Accepted Answer · 2010-06-15 10:52:08Z

0

You have inverted single quotes and double quotes somewhere in your code (at the end of your request). Make sure the display_error php setting is on

answered Jun 15, 2010 at 10:52

greg0ire

23.3k17 gold badges76 silver badges104 bronze badges

Comments

ircmaxell · Accepted Answer · 2010-06-15 11:07:43Z

Ok, first off, you have a massive SQL Injection vulnerability in there. Second, you have no error checking. Third, your quotes are incorrectly nested (which will cause a fatal error, which is why you're not seeing anything)

Modify it to something like this:

$mysqli = new mysqli('localhost', 'root', 'password', 'website');
if ($mysqli->connecterror) {
    //There was an error connecting, handle it
}

$result = $mysqli->query("insert into stuff (data) values ".
    " ('".$mysqli->real_escape_string($_POST['data'])."')";

if ($result === false) {
    //Query error, handle it
}

Also, you're looping through the data without checking if the result is valid:

if($result = $mysqli->query("select data from stuff")){
    echo 'There are '.$result->num_rows.' results.';
    while ($row = $result->fetch_object()){
        echo 'stuff' . $row->data;
    }
}

Collectives™ on Stack Overflow

mysql php problem: no error message despite error_reporting(E_ALL) line

5 Answers 5

Comments

Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related