New Here & Need Some Help

[Duncan Brown]

Hello All,

 

i do not know if i am posting in the right place, I am having problems with my apache server not being able to load php files. every time i access http://localhost:8080/ it keeps saying "Bad Requets Your browser sent a request that this server could not understand" (Fire Fox) and "The webpage cannot be found"(Internet Explorer).

 

I have installed:

 

Apache - 2.2

PHP - 5

MySQL - 5

 

I have followed a video on how to install these and configure them.

 

My Apache Configuration:

#
# This is the main Apache HTTP server configuration file.  It contains the
# configuration directives that give the server its instructions.
# See <URL:http://httpd.apache.org/docs/2.2> for detailed information.
# In particular, see 
# <URL:http://httpd.apache.org/docs/2.2/mod/directives.html>
# for a discussion of each configuration directive.
#
# Do NOT simply read the instructions in here without understanding
# what they do.  They're here only as hints or reminders.  If you are unsure
# consult the online docs. You have been warned.  
#
# Configuration and logfile names: If the filenames you specify for many
# of the server's control files begin with "/" (or "drive:/" for Win32), the
# server will use that explicit path.  If the filenames do *not* begin
# with "/", the value of ServerRoot is prepended -- so "logs/foo.log"
# with ServerRoot set to "C:/Program Files/Apache Software Foundation/Apache2.2" will be interpreted by the
# server as "C:/Program Files/Apache Software Foundation/Apache2.2/logs/foo.log".
#
# NOTE: Where filenames are specified, you must use forward slashes
# instead of backslashes (e.g., "c:/apache" instead of "c:\apache").
# If a drive letter is omitted, the drive on which Apache.exe is located
# will be used by default.  It is recommended that you always supply
# an explicit drive letter in absolute paths to avoid confusion.

#
# ServerRoot: The top of the directory tree under which the server's
# configuration, error, and log files are kept.
#
# Do not add a slash at the end of the directory path.  If you point
# ServerRoot at a non-local disk, be sure to point the LockFile directive
# at a local disk.  If you wish to share the same ServerRoot for multiple
# httpd daemons, you will need to change at least LockFile and PidFile.
#
ServerRoot "C:/Program Files/Apache Software Foundation/Apache2.2"

#
# Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, instead of the default. See also the <VirtualHost>
# directive.
#
# Change this to Listen on specific IP addresses as shown below to 
# prevent Apache from glomming onto all bound IP addresses.
#
#Listen 12.34.56.78:80
Listen 8080

#
# Dynamic Shared Object (DSO) Support
#
# To be able to use the functionality of a module which was built as a DSO you
# have to place corresponding `LoadModule' lines at this location so the
# directives contained in it are actually available _before_ they are used.
# Statically compiled modules (those listed by `httpd -l') do not need
# to be loaded here.
#
# Example:
# LoadModule foo_module modules/mod_foo.so
#
LoadModule actions_module modules/mod_actions.so
LoadModule alias_module modules/mod_alias.so
LoadModule asis_module modules/mod_asis.so
LoadModule auth_basic_module modules/mod_auth_basic.so
#LoadModule auth_digest_module modules/mod_auth_digest.so
#LoadModule authn_alias_module modules/mod_authn_alias.so
#LoadModule authn_anon_module modules/mod_authn_anon.so
#LoadModule authn_dbd_module modules/mod_authn_dbd.so
#LoadModule authn_dbm_module modules/mod_authn_dbm.so
LoadModule authn_default_module modules/mod_authn_default.so
LoadModule authn_file_module modules/mod_authn_file.so
#LoadModule authnz_ldap_module modules/mod_authnz_ldap.so
#LoadModule authz_dbm_module modules/mod_authz_dbm.so
LoadModule authz_default_module modules/mod_authz_default.so
LoadModule authz_groupfile_module modules/mod_authz_groupfile.so
LoadModule authz_host_module modules/mod_authz_host.so
#LoadModule authz_owner_module modules/mod_authz_owner.so
LoadModule authz_user_module modules/mod_authz_user.so
LoadModule autoindex_module modules/mod_autoindex.so
#LoadModule cache_module modules/mod_cache.so
#LoadModule cern_meta_module modules/mod_cern_meta.so
LoadModule cgi_module modules/mod_cgi.so
#LoadModule charset_lite_module modules/mod_charset_lite.so
#LoadModule dav_module modules/mod_dav.so
#LoadModule dav_fs_module modules/mod_dav_fs.so
#LoadModule dav_lock_module modules/mod_dav_lock.so
#LoadModule dbd_module modules/mod_dbd.so
#LoadModule deflate_module modules/mod_deflate.so
LoadModule dir_module modules/mod_dir.so
#LoadModule disk_cache_module modules/mod_disk_cache.so
#LoadModule dumpio_module modules/mod_dumpio.so
LoadModule env_module modules/mod_env.so
#LoadModule expires_module modules/mod_expires.so
#LoadModule ext_filter_module modules/mod_ext_filter.so
#LoadModule file_cache_module modules/mod_file_cache.so
#LoadModule filter_module modules/mod_filter.so
#LoadModule headers_module modules/mod_headers.so
#LoadModule ident_module modules/mod_ident.so
#LoadModule imagemap_module modules/mod_imagemap.so
LoadModule include_module modules/mod_include.so
#LoadModule info_module modules/mod_info.so
LoadModule isapi_module modules/mod_isapi.so
#LoadModule ldap_module modules/mod_ldap.so
#LoadModule logio_module modules/mod_logio.so
LoadModule log_config_module modules/mod_log_config.so
#LoadModule log_forensic_module modules/mod_log_forensic.so
#LoadModule mem_cache_module modules/mod_mem_cache.so
LoadModule mime_module modules/mod_mime.so
#LoadModule mime_magic_module modules/mod_mime_magic.so
LoadModule negotiation_module modules/mod_negotiation.so
#LoadModule proxy_module modules/mod_proxy.so
#LoadModule proxy_ajp_module modules/mod_proxy_ajp.so
#LoadModule proxy_balancer_module modules/mod_proxy_balancer.so
#LoadModule proxy_connect_module modules/mod_proxy_connect.so
#LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
#LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
#LoadModule proxy_http_module modules/mod_proxy_http.so
#LoadModule rewrite_module modules/mod_rewrite.so
LoadModule setenvif_module modules/mod_setenvif.so
#LoadModule speling_module modules/mod_speling.so
#LoadModule ssl_module modules/mod_ssl.so
#LoadModule status_module modules/mod_status.so
#LoadModule substitute_module modules/mod_substitute.so
#LoadModule unique_id_module modules/mod_unique_id.so
#LoadModule userdir_module modules/mod_userdir.so
#LoadModule usertrack_module modules/mod_usertrack.so
#LoadModule version_module modules/mod_version.so
#LoadModule vhost_alias_module modules/mod_vhost_alias.so

<IfModule !mpm_netware_module>
<IfModule !mpm_winnt_module>
#
# If you wish httpd to run as a different user or group, you must run
# httpd as root initially and it will switch.  
#
# User/Group: The name (or #number) of the user/group to run httpd as.
# It is usually good practice to create a dedicated user and group for
# running httpd, as with most system services.
#
User daemon
Group daemon

</IfModule>
</IfModule>

# 'Main' server configuration
#
# The directives in this section set up the values used by the 'main'
# server, which responds to any requests that aren't handled by a
# <VirtualHost> definition.  These values also provide defaults for
# any <VirtualHost> containers you may define later in the file.
#
# All of these directives may appear inside <VirtualHost> containers,
# in which case these default settings will be overridden for the
# virtual host being defined.
#

#
# ServerAdmin: Your address, where problems with the server should be
# e-mailed.  This address appears on some server-generated pages, such
# as error documents.  e.g. admin@your-domain.com
#
ServerAdmin admin@gateway.2wire.net

#
# ServerName gives the name and port that the server uses to identify itself.
# This can often be determined automatically, but we recommend you specify
# it explicitly to prevent problems during startup.
#
# If your host doesn't have a registered DNS name, enter its IP address here.
#
#ServerName testserver.net:8080

#
# DocumentRoot: The directory out of which you will serve your
# documents. By default, all requests are taken from this directory, but
# symbolic links and aliases may be used to point to other locations.
#
DocumentRoot "C:/Inetpub/wwwroot"

#
# Each directory to which Apache has access can be configured with respect
# to which services and features are allowed and/or disabled in that
# directory (and its subdirectories). 
#
# First, we configure the "default" to be a very restrictive set of 
# features.  
#
<Directory />
    Options FollowSymLinks
    AllowOverride None
    Order deny,allow
    Deny from all
</Directory>

#
# Note that from this point forward you must specifically allow
# particular features to be enabled - so if something's not working as
# you might expect, make sure that you have specifically enabled it
# below.
#

#
# This should be changed to whatever you set DocumentRoot to.
#
<Directory "C:/Inetpub/wwwroot">
    #
    # Possible values for the Options directive are "None", "All",
    # or any combination of:
    #   Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
    #
    # Note that "MultiViews" must be named *explicitly* --- "Options All"
    # doesn't give it to you.
    #
    # The Options directive is both complicated and important.  Please see
    # http://httpd.apache.org/docs/2.2/mod/core.html#options
    # for more information.
    #
    Options Indexes FollowSymLinks

    #
    # AllowOverride controls what directives may be placed in .htaccess files.
    # It can be "All", "None", or any combination of the keywords:
    #   Options FileInfo AuthConfig Limit
    #
    AllowOverride None

    #
    # Controls who can get stuff from this server.
    #
    Order allow,deny
    Allow from all

</Directory>

#
# DirectoryIndex: sets the file that Apache will serve if a directory
# is requested.
#
<IfModule dir_module>
    DirectoryIndex index.php index.html index.phtml
</IfModule>

#
# The following lines prevent .htaccess and .htpasswd files from being 
# viewed by Web clients. 
#
<FilesMatch "^\.ht">
    Order allow,deny
    Deny from all
    Satisfy All
</FilesMatch>

#
# ErrorLog: The location of the error log file.
# If you do not specify an ErrorLog directive within a <VirtualHost>
# container, error messages relating to that virtual host will be
# logged here.  If you *do* define an error logfile for a <VirtualHost>
# container, that host's errors will be logged there and not here.
#
ErrorLog "logs/error.log"

#
# LogLevel: Control the number of messages logged to the error_log.
# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.
#
LogLevel warn

<IfModule log_config_module>
    #
    # The following directives define some format nicknames for use with
    # a CustomLog directive (see below).
    #
    LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
    LogFormat "%h %l %u %t \"%r\" %>s %b" common

    <IfModule logio_module>
      # You need to enable mod_logio.c to use %I and %O
      LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio
    </IfModule>

    #
    # The location and format of the access logfile (Common Logfile Format).
    # If you do not define any access logfiles within a <VirtualHost>
    # container, they will be logged here.  Contrariwise, if you *do*
    # define per-<VirtualHost> access logfiles, transactions will be
    # logged therein and *not* in this file.
    #
    CustomLog "logs/access.log" common

    #
    # If you prefer a logfile with access, agent, and referer information
    # (Combined Logfile Format) you can use the following directive.
    #
    #CustomLog "logs/access.log" combined
</IfModule>

<IfModule alias_module>
    #
    # Redirect: Allows you to tell clients about documents that used to 
    # exist in your server's namespace, but do not anymore. The client 
    # will make a new request for the document at its new location.
    # Example:
    # Redirect permanent /foo http://testserver.net/bar

    #
    # Alias: Maps web paths into filesystem paths and is used to
    # access content that does not live under the DocumentRoot.
    # Example:
    # Alias /webpath /full/filesystem/path
    #
    # If you include a trailing / on /webpath then the server will
    # require it to be present in the URL.  You will also likely
    # need to provide a <Directory> section to allow access to
    # the filesystem path.

    #
    # ScriptAlias: This controls which directories contain server scripts. 
    # ScriptAliases are essentially the same as Aliases, except that
    # documents in the target directory are treated as applications and
    # run by the server when requested rather than as documents sent to the
    # client.  The same rules about trailing "/" apply to ScriptAlias
    # directives as to Alias.
    #
    ScriptAlias /cgi-bin/ "C:/Program Files/Apache Software Foundation/Apache2.2/cgi-bin/"

</IfModule>

<IfModule cgid_module>
    #
    # ScriptSock: On threaded servers, designate the path to the UNIX
    # socket used to communicate with the CGI daemon of mod_cgid.
    #
    #Scriptsock logs/cgisock
</IfModule>

#
# "C:/Program Files/Apache Software Foundation/Apache2.2/cgi-bin" should be changed to whatever your ScriptAliased
# CGI directory exists, if you have that configured.
#
<Directory "C:/Program Files/Apache Software Foundation/Apache2.2/cgi-bin">
    AllowOverride None
    Options None
    Order allow,deny
    Allow from all
</Directory>

#
# DefaultType: the default MIME type the server will use for a document
# if it cannot otherwise determine one, such as from filename extensions.
# If your server contains mostly text or HTML documents, "text/plain" is
# a good value.  If most of your content is binary, such as applications
# or images, you may want to use "application/octet-stream" instead to
# keep browsers from trying to display binary files as though they are
# text.
#
DefaultType text/plain

<IfModule mime_module>
    #
    # TypesConfig points to the file containing the list of mappings from
    # filename extension to MIME-type.
    #
    TypesConfig conf/mime.types

    #
    # AddType allows you to add to or override the MIME configuration
    # file specified in TypesConfig for specific file types.
    #
AddType application/x-httpd-php .php
AddType application/x-httpd-php .php3
AddType application/x-httpd-php .phtml
Action application/x-httpd-php "php-exe-location.php.exe"
ScriptAlias /php-exe-location/ "C:/Program Files/PHP/"

AddType text/plain .txt

    #AddType application/x-gzip .tgz
    #
    # AddEncoding allows you to have certain browsers uncompress
    # information on the fly. Note: Not all browsers support this.
    #
    #AddEncoding x-compress .Z
    #AddEncoding x-gzip .gz .tgz
    #
    # If the AddEncoding directives above are commented-out, then you
    # probably should define those extensions to indicate media types:
    #
    AddType application/x-compress .Z
    AddType application/x-gzip .gz .tgz

    #
    # AddHandler allows you to map certain file extensions to "handlers":
    # actions unrelated to filetype. These can be either built into the server
    # or added with the Action directive (see below)
    #
    # To use CGI scripts outside of ScriptAliased directories:
    # (You will also need to add "ExecCGI" to the "Options" directive.)
    #
    #AddHandler cgi-script .cgi

    # For type maps (negotiated resources):
    #AddHandler type-map var

    #
    # Filters allow you to process content before it is sent to the client.
    #
    # To parse .shtml files for server-side includes (SSI):
    # (You will also need to add "Includes" to the "Options" directive.)
    #
    #AddType text/html .shtml
    #AddOutputFilter INCLUDES .shtml
</IfModule>

#
# The mod_mime_magic module allows the server to use various hints from the
# contents of the file itself to determine its type.  The MIMEMagicFile
# directive tells the module where the hint definitions are located.
#
#MIMEMagicFile conf/magic

#
# Customizable error responses come in three flavors:
# 1) plain text 2) local redirects 3) external redirects
#
# Some examples:
#ErrorDocument 500 "The server made a boo boo."
#ErrorDocument 404 /missing.html
#ErrorDocument 404 "/cgi-bin/missing_handler.pl"
#ErrorDocument 402 http://testserver.net/subscription_info.html
#

#
# EnableMMAP and EnableSendfile: On systems that support it, 
# memory-mapping or the sendfile syscall is used to deliver
# files.  This usually improves server performance, but must
# be turned off when serving from networked-mounted 
# filesystems or if support for these functions is otherwise
# broken on your system.
#
#EnableMMAP off
#EnableSendfile off

# Supplemental configuration
#
# The configuration files in the conf/extra/ directory can be 
# included to add extra features or to modify the default configuration of 
# the server, or you may simply copy their contents here and change as 
# necessary.

# Server-pool management (MPM specific)
#Include conf/extra/httpd-mpm.conf

# Multi-language error messages
#Include conf/extra/httpd-multilang-errordoc.conf

# Fancy directory listings
#Include conf/extra/httpd-autoindex.conf

# Language settings
#Include conf/extra/httpd-languages.conf

# User home directories
#Include conf/extra/httpd-userdir.conf

# Real-time info on requests and configuration
#Include conf/extra/httpd-info.conf

# Virtual hosts
#Include conf/extra/httpd-vhosts.conf

# Local access to the Apache HTTP Server Manual
#Include conf/extra/httpd-manual.conf

# Distributed authoring and versioning (WebDAV)
#Include conf/extra/httpd-dav.conf

# Various default settings
#Include conf/extra/httpd-default.conf

# Secure (SSL/TLS) connections
#Include conf/extra/httpd-ssl.conf
#
# Note: The following must must be present to support
#       starting without SSL on platforms with no /dev/random equivalent
#       but a statically compiled-in mod_ssl.
#
<IfModule ssl_module>
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
</IfModule>

 

When I view the defualt folder it brings me up a list of pages that are in the directory, but if I add a index.php it just returns as a "Bad Request" / "The webpage cannot be found". Does anybody know or can point out why i cannot view a .php page on my local server. ???

 

Many Thanks

 

Duncan Brown

 

[Duncan Brown]

Ok i have found a mistake in the httpd.conf file,

 

This was my mistake:

Action application/x-httpd-php "php-exe-location.php.exe"

 

Should have been:

Action application/x-httpd-php "/php-exe-location/php.exe"

 

After doing this i no longer get the message "Bad Requet Your browser sent a request that this server could not understand" (Fire Fox) and "The webpage cannot be found"(Internet Explorer)." But i am now getting another message instead.

 

Error Message:

Not Found

The requested URL /php-exe-location/php.exe/indexold.php was not found on this server.

 

Can somebody please tell me what i have done wrong?

 

Many Thanks

 

Duncan Brown

[trq]

These two lines in fact....

 

Action application/x-httpd-php "php-exe-location.php.exe"
ScriptAlias /php-exe-location/ "C:/Program Files/PHP/"

 

do not make any sense to me at all. Comment them out, restart apache and see how you go.

[wildteen88]

Action application/x-httpd-php "php-exe-location.php.exe"
ScriptAlias /php-exe-location/ "C:/Program Files/PHP/"

Those two lines should be like so:

ScriptAlias /php/ "C:/Program Files/PHP/"
Action application/x-httpd-php "/php/php-cgi.exe"

[Duncan Brown]

Thanks a lot for the replies, 

 

I tried wildteen88's first and i got an error message saying Forbidden, You don't have permission to access /php/php-cgi.exe/index.php on this server.

 

Then i tried thorpe's solution and now the server is giving me the option to download the .php file. i read somewhere that you had to make sure you added index.php to the config file, which i have done.

 

Now i am stuck and i do not know which answer is correct, if wildteen88's is correct i have some privalage problems, if thorpe's is correct then i have a configuration error.

 

Any ideas that can steer me in the right direction to solving this problem.

 

Thanks

 

Duncan

[madmax]

You're on Win32 so running PHP as an external app is somewhat bizarre. No idea why you're doing that

 

You need only load the PHP dll with a command like - (PHP5) - Caveat: You need PHP (say 5) installed in c:\php

For PHP4 replace 5 with 4 and the example below is for Apache 2.0

 

LoadModule php5_module "c:/php/sapi/php5apache2.dll"

 

You need to ensure you have php5ts.dll in a "pathed" location. I usually copy it to \windows\system32. Ensure only one copy is referenced.  Remove the "Action" directive to the external EXE.

 

Keep DirectoryIndex, main ScriptAlias (for non-PHP apps) and the AddType directives

Remove Action and the 2nd ScriptAlias below

 

AddType application/x-httpd-php .php
AddType application/x-httpd-php .php3
AddType application/x-httpd-php .phtml
Action application/x-httpd-php "php-exe-location.php.exe"  (DELETE)
ScriptAlias /php-exe-location/ "C:/Program Files/PHP/"  (DELETE)

 

Don't forget your properly-configured PHP.INI file!!

 

I can't really recommend calling the external EXE unless you have particular reasons to do so esp given the weaker security model of Win32 v's Linux.  Did the method of install come from the PHP documentation ???

 

I've not scanned through your entire config file so there may be other peculiarities which need looking at.

 

[madmax]

PS Try these resources too...

 

http://www.onlamp.com/pub/a/php/2000/12/14/php_admin.html

 

http://uk.php.net/manual/en/install.windows.php

[wildteen88]

You need to ensure you have php5ts.dll in a "pathed" location. I usually copy it to \windows\system32.

Add PHP to the Path Environment Variable instead. I do not recommend moving files outside of the PHP's installation folder this can cause more problems, especially when upgrading.

[madmax]

I usually copy it to \windows\system32

 

Of course, absolutely yes. I should have added the caveat - "Although I personally do the above, you are free to choose an appropriate strategy on it's specific merits". I am assuming you are mature enough to be able to take responsibility for any changes you make to the standard config.

 

However, I personally use few components from the PHP directory and if your requirements are minimal most of the PHP dir contents can be eliminated to save space. You do however have to take total responsibility for file management during upgrades in such cases and it's certainly not recommended for everyone but may be of interest to others who follow the thread with similar issues.

 

In my own portable distros I put the whole shebang including phpXts.dll into one common folder and it all works fine. Just be aware that there are a number of flexible alternatives which should work and each may have it's own conveniences and drawbacks.

 

Additionally the bare minimal contents you will need from the PHP folder in ISAPI mode are as follows (I do stress minimal here since you mention also use MySQL and perhaps other loaded modules which require additional DLL dependencies)

 

phpXts.dll

phpXapache2.dll (apache 2.0.x - or phpXapache2_2.dll for Apache 2.2)

php.ini

 

The remainder consists of optional components which need to be added say for MySQL support/GDI, SSL or extensions support etc. Additional info for MySQL support should you want to tweak your config

 

http://uk.php.net/mysql  - this may also be useful for MySQL which suggests the following 2 DLL dependencies for PHP 5+ ...

 

libmysql.dll

ext\php_mysql.dll

 

MySQL is no longer enabled by default, so the php_mysql.dll DLL must be enabled inside of php.ini. Also, PHP needs access to the MySQL client library. A file named libmysql.dll is included in the Windows PHP distribution and in order for PHP to talk to MySQL this file needs to be available to the Windows systems PATH. See the FAQ titled "How do I add my PHP directory to the PATH on Windows" for information on how to do this. Although copying libmysql.dll to the Windows system directory also works (because the system directory is by default in the system's PATH), it's not recommended.

 

and...

 

How to Install PHP 5 Apache 2.2.x and MySQL 5 in Windows ...

http://16bytes.com/How_to_install_PHP5_Apache_2_2_and_MySQL_5_on_Windows.html

 

LoadModule php5_module "c:/php/php5apache2_2.dll"

AddType application/x-httpd-php .php .php5

PHPIniDir "c:/php"

 

All of this may be of some use if you're taking control over your config rather than going with the install default.

[Duncan Brown]

Thanks alot guys i have got it working  (even though some of that is going over my head  ???)

 

I added the 'LoadModule php5_module "c:/php/php5apache2_2.dll"' into the config file and it worked, I really apreciate all the help you gave me.

 

Thanks alot.

 

i have another question if anybody can help  ??? I have setup an MySQL server and added a table but i cannot get Dreamweaver to connect to the server on the local network, has anybody got any ideas or know a place where I can go and look and find a solution, Also the error message is "An unidentifed error has occured" 

 

Anyway thanks once again it really has helped.

 

Many Thanks

 

Duncan Brown

 

 

[Duncan Brown]

Ok i am still looking on the internet for the Dreamweaver problem

 

Anyway I am testing mySQL connection with php script, when  run the page i get the following error -

 

'Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\wwwroot\mysql_up.php on line 12'

 

This is the script i am using:

<?php
/* Program: mysql_up.php
* Desc: Connects to MySQL Server and
* outputs settings.
*/
echo "<html>
<head><title>Test MySQL</title></head>
<body>";
$host="localhost";
$user= "root";
$password= "????";
$cxn = mysql_connect($host,$user,$password);
$sql='SHOW STATUS';
$result = mysqli_query($cxn,$sql);
if($result == false)
{
echo '<h4>Error: '.mysqli_error($cxn).'</h4>';
}
else
{
/* Table that displays the results */
echo '<table border=’1’>
<tr><th>Variable_name</th>
<th>Value</th></tr>';
for($i = 0; $i < mysqli_num_rows($result); $i++)
{
echo '<tr>';
$row_array = mysqli_fetch_row($result);
for($j = 0;$j < mysqli_num_fields($result);$j++)
{
echo '<td>'.$row_array[$j].'</td>\n';
}
}
echo '</table>';
}
?>
</body></html>

 

Would like some help on this if anyone has an answer to what is going on or if have done something wrong.

 

Many Thanks

 

Duncan

[trq]

Read this sticky in our MySql Help -> Installation & Configuration Issues board.

[Duncan Brown]

Thanks Thorpe  i owe you one. 

[Duncan Brown]

Prehaps I spoke too soon,

 

I followed all the steps in the link and I thought that would solve the problem, but I am still getting 'Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\wwwroot\mysqltest2.php on line 2'

 

I think that maybe I have configured something wrongley or I am missing something from the instalation of PHP. In the link is says to 'extension_dir = "C:\php\ext"' but i do not have a folder called ext. I have downloaded php-5.2.5-win32-installer from the php site and installed it,

 

The PHP ini file: http://www.theoaps.co.uk/Downloads/php.ini

 

 

Have i got the wrong version ? or can anybody see a mistake in the .ini file ?

 

I am at the final hurdle and can’t seem to jump over it would really appreciate any help.

 

Thanks

 

Duncan

 

[wildteen88]

Is the link above you posted your current php.ini?

 

If it is then your ext folder is located in C:/Program Files/PHP

 

You should of changed C:/php to the actual path you installed PHP to (as mentioned in the FAQ).

 

As you have you used the installer, go a head an download the zipped package from php.net instead and extract the contents of the zip to where you have installed PHP to. Making sure you overwrite existing files. The installer comes with limited files/extensions.

 

Make sure whenever you are modifying the php.ini that your restart IIS. Also verify that php is using the php.ini your are editing too by running phpinfo() function within a script. The line that reads Loaded Configuration File should stat the path to the php.ini PHP is reading.