PHP not showing error in browser

Question

i am able to enter text in html and am able to submit. but then i get a blank page. whats wrong? is it the code? here it is

<html>
<body>
<form action ="students.php" method="post">
USN : <input type="text" name="id">
NAME : <input type="text" name="n">
age : <input type="text" name="a">
<input type="submit">
</form>
</body>
</html>

and php code is 
<html>
<body>
<?php
$connect=mysqli_connect("localhost","root","1234") or die("cant connect");
mysqli_select_db($connect,"student") or die("cant connect to database");
$usn=$_POST["id"];
$name=$_POST["n"];
$age=$_POST["a"];
$query="insert into student_info (usn,name,age) values('$usn','$name','$age')";
if(mysqli_query($connect,$query))
{
echo "inserted";
}
else
{
echo "could not insert";
}
mysqli_close($connect);
?>
</body>
</html>

error_reporting(E_ALL); ini_set("display_errors", 1);

Ima
– Ima

2016-11-20 13:02:05 +00:00
Commented Nov 20, 2016 at 13:02 — Ima
– Ima, Commented Nov 20, 2016 at 13:02

Community · Accepted Answer · 2017-05-23 12:09:01Z

1

as stated in this answer :

https://stackoverflow.com/a/21429652/7091942.

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

However, this doesn't make PHP to show parse errors - the only way to show those errors is to modify your php.ini with this line:

display_errors = on

edited May 23, 2017 at 12:09

CommunityBot

11 silver badge

answered Nov 20, 2016 at 13:00

Michael Yousrie

1,1523 gold badges10 silver badges20 bronze badges

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

Comments

score 0 · Accepted Answer · 2016-11-20 13:05:12Z

0

You are validating incorrectly... You can use mysqli_affected_rows to check if there was a change in the database, instead of putting the query in an if statement, since that shouldn't work.

Also, consider using error_reporting(E_ALL); and look up sanitation, to secure your queries for sql-injection.

edited Nov 20, 2016 at 13:05

answered Nov 20, 2016 at 12:56

user2506641

Collectives™ on Stack Overflow

PHP not showing error in browser

2 Answers 2

as stated in this answer :

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

as stated in this answer :

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related