My PHP file is not getting executed

Question

I created a .php file and when I am trying to execute it via- localhost, it shows nothing. If the script is working fine, then it should print something on the screen. <- The basic idea of the script, but nothing is getting displayed.

<?php
$con = mysql_connect("localhost","somanshu","somanshu");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("james007", $con);

$result = mysql_query("SELECT * FROM info");
while($row = mysql_fetch_array($result))
  {
  if($_POST['mail'] == $row['email'])
  {
  echo "Logged In.<META HTTP-EQUIV=\"refresh\" CONTENT=\"0;URL=home\">";
  }
  else
  {
  $sql="INSERT INTO info (email, password)
  VALUES
  ('$_POST[mail]','$_POST[pwd]')";
   if (!mysql_query($sql,$con))
   {
   die('Error: ' . mysql_error());
   }
   else
   {
   echo "Added. <META HTTP-EQUIV=\"refresh\" CONTENT=\"0;URL=home\">";
   }
  }
  }
mysql_close($con);
?>

You are using a soon-to-be-removed API. Use PDO or MySQLi, not ext/mysql, or you will suddenly find that your code doesn't work. Also, it's famously insecure due to lack of proper(ly used) escaping and lack of prepared statements — Amelia
– Amelia, Commented Feb 23, 2013 at 12:50

Dipesh Parmar · Accepted Answer · 2013-02-23 12:31:31Z

2

Use ini_set('error_reporting', E_ALL); and see if its give errors.

add below code at top of the page.

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

if its still not display errors then try

mysqli_select_db("james007", $con)or die(mysqli_error());

Also check

mysqli_query("SELECT * FROM info")or die(mysqli_error());

edited Feb 23, 2013 at 12:31

answered Feb 23, 2013 at 12:22

Dipesh Parmar

27.3k8 gold badges65 silver badges92 bronze badges

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

2 Comments

Miloš Đakonović Over a year ago

I meant code doesn't looks broke, if someone likes to ignore official warnings from PHP team, that's a bit about personal preferences. Of course it's better to switch to PDO or mysqli

Somanshu Srivastava Over a year ago

Thanks for the information. If that API is going down, its good to change our approach right now.

sevenseacat · Accepted Answer · 2013-02-23 12:29:26Z

0

Ensure that there is data in the database to select. If SELECT * FROM info returns no rows, this script will not output anything.

answered Feb 23, 2013 at 12:29

sevenseacat

25.1k6 gold badges66 silver badges90 bronze badges

1 Comment

Somanshu Srivastava Over a year ago

This works. Actually, I emptied my table ( via TRUNCATE method. ) Thanks for help.

sevenseacat · Accepted Answer · 2013-02-23 12:41:24Z

0

First things first: Is php executed at all? To find out create a file called test.php and write

<?php
phpinfo();
?>

inside.

If this is not working you have to set up php for your webserver properly.

edited Feb 23, 2013 at 12:41

sevenseacat

25.1k6 gold badges66 silver badges90 bronze badges

answered Feb 23, 2013 at 12:29

Christoph Grimmer

4,3434 gold badges43 silver badges66 bronze badges

2 Comments

sjdaws Over a year ago

phpinfo() not php_info() I can't edit your post as it's not a big enough edit.

Christoph Grimmer Over a year ago

Sorry, doing this from memory while in the hospital :-)

Collectives™ on Stack Overflow

My PHP file is not getting executed

3 Answers 3

2 Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related