php file is not running using xampp

Question

I am a newbie in web development and I have just installed xampp. The control panel show everything is fine. All the services are running.

I have created a database in mySQL using the phpMyAdmin and everything is fine with phpMyAdmin. I am trying to make a simple form which will make me able to add data in database table. My html form and php code are as follows. Both files are in htdocs folder:

form.html

<form action="signup.php" method="post">
Email: <input type="text" name="email"> <br>
Firstname: <input type="text" name="f_name"> <br>
Lastname: <input type="text" name="l_name"> <br>
Password: <input type="password" name="password"> <br>
Stream: <input type="text" name="stream"> <br>
<input type="submit">
</form>

</body>
</html>

signup.php:

$sql="INSERT INTO student (email,f_name,l_name,password,stream)
VALUES
  ('$_POST[email]','$_POST[f_name]','$_POST[l_name]','$_POST[password]','$_POST[stream]')";

if (!mysqli_query($con,$sql))
  {
  die('Error: ' . mysqli_error($con));
  }
echo "1 record added";

mysqli_close($con);
?>

When I click on the submit button in the form, my browser, Google Chrome, takes me to file:///C:/xampp/htdocs/signup.php and shows the contents of php script instead of running it.

If i manually enter into the address bar http://localhost/signup.php the script is executed and a record with all attributes blank is inserted into student table. So m conclusion is that php is running properly.

How to run the php script when I submit my form? Thanks :)

In your browser please make sure that your url is localhost/form.html — Goikiu
– Goikiu, Commented Jan 7, 2014 at 11:14
As an aside, using mysqli like this still opens you up to SQL injection. Consider using prepared statements. — Bart Friederichs
– Bart Friederichs, Commented Jan 7, 2014 at 11:16
Check Your URL in address bar Your URL should be localhost/form.html — railsbox
– railsbox, Commented Jan 7, 2014 at 11:18

René Höhle · Accepted Answer · 2015-04-27 13:38:22Z

6

You have to call your html file over your local Webserver http://localhost/form.html otherwise your base path is your local file like you see with file:/// and your submit URL is incorrect.

edited Apr 27, 2015 at 13:38

answered Jan 7, 2014 at 11:15

René Höhle

27.4k22 gold badges78 silver badges91 bronze badges

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

Comments

Ajit Singh · Accepted Answer · 2014-01-07 11:16:43Z

1

use the full url for the form.html file as u have done for the signup.php

use this http://localhost/form.html

and it will work fine.

answered Jan 7, 2014 at 11:16

Ajit Singh

1,1501 gold badge13 silver badges24 bronze badges

Comments

skaul05 · Accepted Answer · 2019-02-26 08:05:50Z

1

First of all, you need to pass the url https://localhost/form.html to execute your form.html file properly saved in htdocs folder otherwise upon submission only PHP script will be displayed.

About Blank entries do not run signup.php directly first run form.html. If the problem continues to check that the names of columns in the database and PHP file are same or not.

Hope this answers your question!!!

edited Feb 26, 2019 at 8:05

answered May 26, 2017 at 21:00

skaul05

2,3843 gold badges21 silver badges29 bronze badges

Collectives™ on Stack Overflow

php file is not running using xampp

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related