Php script is working on its own but not included in html

Question

i am trying to use a php script in my html website. The php script is working as intended when I run it. My php script:

<?php
mysql_connect("localhost","demo","123abc");
mysql_select_db("demo");
$sql=mysql_query("SELECT vorname FROM users"); 
if(mysql_num_rows($sql)){ 
$select= '<select name="select">';   
while($rs=mysql_fetch_array($sql)){ 
      $select.='<option value='.$rs['vorname'].'>'.$rs['vorname'].'</option>'; 
  } 
} 
$select.='</select>'; 
echo $select;  
?>

Now what I want is, to have the dropdown on my website on different locations. My idea was to just insert the php script whenever I need it. My html part:

<td>
<?php include 'http://localhost/Testsamples/test.php'; ?>
</td>

But it is not working and I don't know why. Can someone help me out?

Thanks

The html file is in a different folder. Html= localhost/Prompt/index.html and then php= localhost/Testsamples/test.php — LittleMonstr
– LittleMonstr, Commented Jun 28, 2014 at 16:04
Apart from the answers below about the path, your php will probably not get executed if the including file has the .html extension. Change that to .php as well. — jeroen
– jeroen, Commented Jun 28, 2014 at 16:05
@jeroen it's possible to have HTML execute php, but it requires some adjustments in the system files. I have no clue on where he should look though, since I have no clue what local server he uses. However safer bet is indeed to just change html to php — Dorvalla
– Dorvalla, Commented Jun 28, 2014 at 16:10
@Dorvalla That's why I said probably. Modifying the OP's server settings is indeed a bit out of the scope of this question :-) — jeroen
– jeroen, Commented Jun 28, 2014 at 16:12
@jeroen your post was the solution in the end. Thanks a lot to all the help from everyone. =D — LittleMonstr
– LittleMonstr, Commented Jun 28, 2014 at 20:35

John Conde · Accepted Answer · 2014-06-28 16:01:19Z

5

You don't include the file by its URL, you must use the system filepath:

<td>
<?php include '/path/to/Testsamples/test.php'; ?>
</td>

answered Jun 28, 2014 at 16:01

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

4 Comments

LittleMonstr Over a year ago

I moved them in the same folder now. Its localhost/Prompt/test.php now. The html file is in the Prompt folder also. Do I just write /test.php as the path now?

John Conde Over a year ago

You can do ./test.php or test.php

jeroen Over a year ago

@LittleMonstr Change include to require, the error message will tell you what path php is looking for.

John Conde Over a year ago

Do you have error reporting turned on PHP should be telling you if it can't find that file.

Vincent Decaux · Accepted Answer · 2014-06-28 16:16:28Z

3

You can't include using URL (like http://www.domain.com/script.php).

Use relative path like :

<?php include "/path/test.php"; ?>

Use require is better than include, you will have a direct error if file is not found.

edited Jun 28, 2014 at 16:16

answered Jun 28, 2014 at 16:01

Vincent Decaux

10.9k7 gold badges67 silver badges103 bronze badges

3 Comments

Nisse Engström Over a year ago

"/path/test.php" is an absolute path. What the OP had was a URL.

jeroen Over a year ago

You should modify the wording a bit: As mentioned, the original path is a url and the path you are using is actually an absolute path.

Vincent Decaux Over a year ago

You are right, I just named "absolute" too fast. I edit my answer.

Ionuț Staicu · Accepted Answer · 2014-06-28 16:02:05Z

1

In order to include it from an absolute path you need to have allow_url_include enabled on your php.ini.

See here: http://phpsec.org/projects/phpsecinfo/tests/allow_url_include.html

However, if your file is on the same system, you should use relative urls. i.e. include 'testSamples/test.php (or something similar). You could also use basic folder nav ( e.g. ../testSamples/test.php or use an include relative to root: /public_html/foo/bar/testSamples/test.php)

answered Jun 28, 2014 at 16:02

Ionuț Staicu

22.3k11 gold badges54 silver badges58 bronze badges

Comments

dangdis · Accepted Answer · 2014-06-28 16:08:02Z

0

Try this

<?php /* At the first instance of call, to eliminate multiple opening of SQL connections for the smae data */
    ob_start();
    get_file_contents('http://localhost/Testsamples/test.php'); 
    $contents = ob_get_contents();
?>
<td>
    <?php echo $contents; ?>
</td>

edit - as pointed out in the other answers, you probably do not want to be including absolute paths!

answered Jun 28, 2014 at 16:08

dangdis

3782 silver badges11 bronze badges

Collectives™ on Stack Overflow

Php script is working on its own but not included in html

4 Answers 4

4 Comments

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related