PHP script not working on local computer but works on the webserver

Question

I am new to coding in php and also getting the environment set up on my local computer.

Here's the current setup configuration - I have installed wamp server version 2.2 which has the following - Apache 2.4.2, php 5.4.3, mysql 5.5.24

There is a very simple php code that i had written -

<?
mysql_connect("localhost","user","password");
mysql_select_db("mydbase");
$result = mysql_query("SELECT * FROM names WHERE ID LIKE '2'"); 
   while($r=mysql_fetch_array($result))
{
$id = $r["id"];
$name = $r["name"];

}//close while
?>

Even a simple echo is not working. the output is blank. the same code works on the web server. It has the same user name, password and the tables were exported (from the webserver) and imported (into the local mysql).

The phpinfo() page shows the following -

display_errors - on - on error_log - no value - no value

The php.ini file shows the following - ; display_errors ; Default Value: On ; Development Value: On ; Production Value: Off and

;error_log = php_errors.log
; Log errors to syslog (Event Log on NT, not valid in Windows 95).
;error_log = syslog
error_log = c:/wamp/logs/php_error.log

The error logs are empty.

When i look at the source in the browser, for the page online - it shows the output for the page on the local computer - it just shows the php code

Could anyone please let me know what the problem could be? It seems like that there are some settings that i have messed up. But, i did not change anything - it is a regular installation and no custom settings were added.

Make sure that the server (I assume apache) is set up to handle php requests. It should be handling php extensions with application/x-httpd-php (and mod_php should be enabled unless you are using FastCGI or something) — Explosion Pills
– Explosion Pills, Commented Aug 7, 2012 at 13:41
Does the MySQL user/password form the webserver also exist on your local server? — Mike Brant
– Mike Brant, Commented Aug 7, 2012 at 13:41
@MikeBrant "It has the same user name, password and the tables were exported (from the webserver) and imported (into the local mysql)" — Peon
– Peon, Commented Aug 7, 2012 at 13:42

Dean Grell · Accepted Answer · 2012-08-07 15:06:27Z

1

Your script doesn't work, but your phpinfo page works? Check short_open_tag in your php.ini. Or modify your script and change your opening <? to <?php. If that works, you found the problem!

answered Aug 7, 2012 at 15:06

Dean Grell

1438 bronze badges

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

3 Comments

nk369 Over a year ago

the short_open_tag is set to off (on both local and master value)

Peon Over a year ago

Glad to hear it helped, but to please refer from not using short opening tags. That's not good practice.

nk369 Over a year ago

@DainisAbols, oh, okay.. didnt know that. was just experimenting with a code i found.. will use the standard codes now.. (which i am assuming, would be using <?php > instead of <? > )

Soundz · Accepted Answer · 2012-08-07 13:51:53Z

0

this happened to me too, try enabling the mime_module of apache

answered Aug 7, 2012 at 13:51

Soundz

1,30010 silver badges17 bronze badges

1 Comment

nk369 Over a year ago

the mime_module is enabled (there is a tick next to it in Apache Modules in the WAMP configuration)

Peon · Accepted Answer · 2012-08-07 18:30:43Z

0

If, on info.php file creation with

<?php phpinfo(); ?>

You actully get that result, check if your webserver is configured to use php as script files:

Check inside httpd.conf for these lines and alter them if necessary:

<IfModule dir_module>
    DirectoryIndex index.html index.php
</IfModule>

Restart server and try to run the script again.

edited Aug 7, 2012 at 18:30

answered Aug 7, 2012 at 14:04

Peon

8,0417 gold badges63 silver badges104 bronze badges

2 Comments

Peon Over a year ago

Or try installing an older wamp version and carefully click on all php options when installing it. That might be easier for you.

nk369 Over a year ago

i checked the httpd.conf and it shows the following <IfModule dir_module> DirectoryIndex index.php index.php3 index.html index.htm </IfModule>

Collectives™ on Stack Overflow

PHP script not working on local computer but works on the webserver

3 Answers 3

3 Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related