php code entering my html

Question

I'm trying to insert data from a php page into my mySQL databse. when I refresh the page parts of my php code is being displayed on the page rather than being processed below is my code(sensitive info blocked):

<?php
  $servername = "localhost";
  $username = "*******";
  $password = "*******";
  $dbname = "accounts";

  // Create connection
  $conn = mysqli_connect($servername, $username, $password, $dbname);
  // Check connection
  if (!$conn) {
      die("Connection failed: " . mysqli_connect_error());
  }

  $sql = "INSERT INTO MyGuests (firstname, lastname, email)
  VALUES ('John', 'Doe', '[email protected]')";

  if (mysqli_query($conn, $sql)) {
  echo "New record created successfully";
  } else {
     echo "Error: " . $sql . "<br>" . mysqli_error($conn);
  }

  mysqli_close($conn);
?>

and this is a screenshot of the "view source", as you can see it sort of stops doing it's PHP and displaying into my page. thoughts?

I don’t see there’s any issue with your code. You sure your server is on and the php lib is installed? — Rupesh Bhandari
– Rupesh Bhandari, Commented Sep 14, 2017 at 1:30
may be bad configuration in your vhosts, htaccess, bad rights file/folders, or you apache stop for some reason ... did you got some errors in your logs? — user8556290
– user8556290, Commented Sep 14, 2017 at 1:31
Which web server are you using? Does it support PHP at all ? — Raptor
– Raptor, Commented Sep 14, 2017 at 1:44

Muhammad Irfan Mayo · Accepted Answer · 2017-09-14 06:17:39Z

1

Hello bro your code is alright i test it on my local server. i think you are not saving file with correct extension. or your mysql table fields are incorrect if data is not inserting. Correct extension for php file name.php

answered Sep 14, 2017 at 6:17

Muhammad Irfan Mayo

1431 gold badge1 silver badge11 bronze badges

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

Comments

sg1994 · Accepted Answer · 2017-09-14 06:29:23Z

1

I think there is issue with either your web server or your file extension, Make sure your web server is active and file extension is .php

answered Sep 14, 2017 at 6:29

sg1994

7271 gold badge5 silver badges6 bronze badges

Collectives™ on Stack Overflow

php code entering my html

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related