php.ini not being read

[nathj]

Hi,
I am just abut to use PHP and MySQL together, I have used PHP previously but never with MySQL.

At present I am working on a test site which is not visible outside the localhost but I'll try to explain as best I can.

System Info:
OS: Vista Business
Web Server: IIS 7
PHP: 5.2.2
MySQL: 5.0

I have a test page with the code:
[PHP]
<?php
$lvConnection = mysql_connect("localhost:3306", "root", $password);
if(!$lvConnection)
{
die('Could not connect: ' .mysql_error());
}
?>
[/PHP]

This however gives me the message:
Fatal error: Call to undefined function mysql_connect()

SO after some Googling around I found that there were a few steps I needed to take that I hadn't taken. Here's what I did:
1) loaded the c:\php\php.ini-recommended file into TextPad
2) changed the extension_dir to "c:\php\ext"
3) enabled the php_mysql.dll
4) Saved this as c:\Windows\php.ini
5) loaded libmysql.dll into the system32 directory and registered it.

All of that went well, or so I thought. I then ran another test page:
[PHP]<?php phpinfo() ?>[/PHP]

This shows that the correct ini file is being read, however it still lists the extension_dir as ./

I am really baffled by this and so I tried changing other settings in the file to see if they would show as I'd set them when ran my test page. It appears that nothing I change makes any difference to the results of phpinfo() and still get the fatal error when issuing mysql_connect().

If anyone can shed any light on this for me that would be great. I've been pulling my hair out for 2 days now,

Many thanks
Nathan

[Purple]

Hi nathj,

can you post the PHP Core and Envronment sections of your phpinfo into this thread and we will take a look.

Purple

[shoonya]

hope you checked mySQL as your db while installing the php
then the phpinfo.php page will be having the details of mysql along with other specifications
if you are not able to find it there
re install the php carefully

shoonya

[nathj]

Hi,

Here is the core section:

<table border="0" cellpadding="3" width="600">
<tbody><tr class="h"><th>Directive</th><th>Local Value</th><th>Master Value</th></tr>
<tr><td class="e">allow_call_time_pass_reference</td><td class="v">On</td><td class="v">On</td></tr>
 
<tr><td class="e">allow_url_fopen</td><td class="v">On</td><td class="v">On</td></tr>
<tr><td class="e">allow_url_include</td><td class="v">Off</td><td class="v">Off</td></tr>
<tr><td class="e">always_populate_raw_post_data</td><td class="v">Off</td><td class="v">Off</td></tr>
<tr><td class="e">arg_separator.input</td><td class="v">&amp;</td><td class="v">&amp;</td></tr>
<tr><td class="e">arg_separator.output</td><td class="v">&amp;</td><td class="v">&amp;</td></tr>
<tr><td class="e">asp_tags</td><td class="v">Off</td><td class="v">Off</td></tr>
 
<tr><td class="e">auto_append_file</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">auto_globals_jit</td><td class="v">On</td><td class="v">On</td></tr>
<tr><td class="e">auto_prepend_file</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">browscap</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">default_charset</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
 
<tr><td class="e">default_mimetype</td><td class="v">text/html</td><td class="v">text/html</td></tr>
<tr><td class="e">define_syslog_variables</td><td class="v">Off</td><td class="v">Off</td></tr>
<tr><td class="e">disable_classes</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">disable_functions</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">display_errors</td><td class="v">On</td><td class="v">On</td></tr>
 
<tr><td class="e">display_startup_errors</td><td class="v">Off</td><td class="v">Off</td></tr>
<tr><td class="e">doc_root</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">docref_ext</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">docref_root</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">enable_dl</td><td class="v">On</td><td class="v">On</td></tr>
 
<tr><td class="e">error_append_string</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">error_log</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">error_prepend_string</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">error_reporting</td><td class="v">6135</td><td class="v">6135</td></tr>
<tr><td class="e">expose_php</td><td class="v">On</td><td class="v">On</td></tr>
 
<tr><td class="e">extension_dir</td><td class="v">./</td><td class="v">./</td></tr>
<tr><td class="e">file_uploads</td><td class="v">On</td><td class="v">On</td></tr>
<tr><td class="e">highlight.bg</td><td class="v"><font style="color: rgb(255, 255, 255);">#FFFFFF</font></td><td class="v"><font style="color: rgb(255, 255, 255);">#FFFFFF</font></td></tr>
<tr><td class="e">highlight.comment</td><td class="v"><font style="color: rgb(255, 128, 0);">#FF8000</font></td><td class="v"><font style="color: rgb(255, 128, 0);">#FF8000</font></td></tr>
<tr><td class="e">highlight.default</td><td class="v"><font style="color: rgb(0, 0, 187);">#0000BB</font></td><td class="v"><font style="color: rgb(0, 0, 187);">#0000BB</font></td></tr>
 
<tr><td class="e">highlight.html</td><td class="v"><font style="color: rgb(0, 0, 0);">#000000</font></td><td class="v"><font style="color: rgb(0, 0, 0);">#000000</font></td></tr>
<tr><td class="e">highlight.keyword</td><td class="v"><font style="color: rgb(0, 119, 0);">#007700</font></td><td class="v"><font style="color: rgb(0, 119, 0);">#007700</font></td></tr>
<tr><td class="e">highlight.string</td><td class="v"><font style="color: rgb(221, 0, 0);">#DD0000</font></td><td class="v"><font style="color: rgb(221, 0, 0);">#DD0000</font></td></tr>
<tr><td class="e">html_errors</td><td class="v">On</td><td class="v">On</td></tr>
<tr><td class="e">ignore_repeated_errors</td><td class="v">Off</td><td class="v">Off</td></tr>
 
<tr><td class="e">ignore_repeated_source</td><td class="v">Off</td><td class="v">Off</td></tr>
<tr><td class="e">ignore_user_abort</td><td class="v">Off</td><td class="v">Off</td></tr>
<tr><td class="e">implicit_flush</td><td class="v">Off</td><td class="v">Off</td></tr>
<tr><td class="e">include_path</td><td class="v">.;C:\php5\pear</td><td class="v">.;C:\php5\pear</td></tr>
<tr><td class="e">log_errors</td><td class="v">Off</td><td class="v">Off</td></tr>
 
<tr><td class="e">log_errors_max_len</td><td class="v">1024</td><td class="v">1024</td></tr>
<tr><td class="e">magic_quotes_gpc</td><td class="v">On</td><td class="v">On</td></tr>
<tr><td class="e">magic_quotes_runtime</td><td class="v">Off</td><td class="v">Off</td></tr>
<tr><td class="e">magic_quotes_sybase</td><td class="v">Off</td><td class="v">Off</td></tr>
<tr><td class="e">mail.force_extra_parameters</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
 
<tr><td class="e">max_execution_time</td><td class="v">30</td><td class="v">30</td></tr>
<tr><td class="e">max_input_nesting_level</td><td class="v">64</td><td class="v">64</td></tr>
<tr><td class="e">max_input_time</td><td class="v">60</td><td class="v">60</td></tr>
<tr><td class="e">memory_limit</td><td class="v">128M</td><td class="v">128M</td></tr>
<tr><td class="e">open_basedir</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
 
<tr><td class="e">output_buffering</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">output_handler</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">post_max_size</td><td class="v">8M</td><td class="v">8M</td></tr>
<tr><td class="e">precision</td><td class="v">12</td><td class="v">12</td></tr>
<tr><td class="e">realpath_cache_size</td><td class="v">16K</td><td class="v">16K</td></tr>
 
<tr><td class="e">realpath_cache_ttl</td><td class="v">120</td><td class="v">120</td></tr>
<tr><td class="e">register_argc_argv</td><td class="v">On</td><td class="v">On</td></tr>
<tr><td class="e">register_globals</td><td class="v">Off</td><td class="v">Off</td></tr>
<tr><td class="e">register_long_arrays</td><td class="v">On</td><td class="v">On</td></tr>
<tr><td class="e">report_memleaks</td><td class="v">On</td><td class="v">On</td></tr>
 
<tr><td class="e">report_zend_debug</td><td class="v">On</td><td class="v">On</td></tr>
<tr><td class="e">safe_mode</td><td class="v">Off</td><td class="v">Off</td></tr>
<tr><td class="e">safe_mode_exec_dir</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">safe_mode_gid</td><td class="v">Off</td><td class="v">Off</td></tr>
<tr><td class="e">safe_mode_include_dir</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
 
<tr><td class="e">sendmail_from</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">sendmail_path</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">serialize_precision</td><td class="v">100</td><td class="v">100</td></tr>
<tr><td class="e">short_open_tag</td><td class="v">On</td><td class="v">On</td></tr>
<tr><td class="e">SMTP</td><td class="v">localhost</td><td class="v">localhost</td></tr>
 
<tr><td class="e">smtp_port</td><td class="v">25</td><td class="v">25</td></tr>
<tr><td class="e">sql.safe_mode</td><td class="v">Off</td><td class="v">Off</td></tr>
<tr><td class="e">track_errors</td><td class="v">Off</td><td class="v">Off</td></tr>
<tr><td class="e">unserialize_callback_func</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">upload_max_filesize</td><td class="v">2M</td><td class="v">2M</td></tr>
 
<tr><td class="e">upload_tmp_dir</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">user_dir</td><td class="v"><i>no value</i></td><td class="v"><i>no value</i></td></tr>
<tr><td class="e">variables_order</td><td class="v">EGPCS</td><td class="v">EGPCS</td></tr>
<tr><td class="e">xmlrpc_error_number</td><td class="v">0</td><td class="v">0</td></tr>
<tr><td class="e">xmlrpc_errors</td><td class="v">Off</td><td class="v">Off</td></tr>
 
<tr><td class="e">y2k_compliance</td><td class="v">On</td><td class="v">On</td></tr>
<tr><td class="e">zend.ze1_compatibility_mode</td><td class="v">Off</td><td class="v">Off</td></tr>
</tbody></table><br>
 

And the environment settings:

<h2>Environment</h2>
<table border="0" cellpadding="3" width="600">
<tbody><tr class="h"><th>Variable</th><th>Value</th></tr>
 
<tr><td class="e">ALLUSERSPROFILE </td><td class="v">C:\ProgramData </td></tr>
<tr><td class="e">APPDATA </td><td class="v">C:\Windows\ServiceProfiles\NetworkService\AppData\Roaming </td></tr>
<tr><td class="e">CLASSPATH </td><td class="v">.;C:\Program Files\Java\jre1.6.0\lib\ext\QTJava.zip </td></tr>
<tr><td class="e">CommonProgramFiles </td><td class="v">C:\Program Files\Common Files </td></tr>
<tr><td class="e">COMPUTERNAME </td><td class="v">HP3 </td></tr>
<tr><td class="e">ComSpec </td><td class="v">C:\Windows\system32\cmd.exe </td></tr>
 
<tr><td class="e">FP_NO_HOST_CHECK </td><td class="v">NO </td></tr>
<tr><td class="e">LOCALAPPDATA </td><td class="v">C:\Windows\ServiceProfiles\NetworkService\AppData\Local </td></tr>
<tr><td class="e">NUMBER_OF_PROCESSORS </td><td class="v">2 </td></tr>
<tr><td class="e">OnlineServices </td><td class="v">Online Services </td></tr>
<tr><td class="e">OS </td><td class="v">Windows_NT </td></tr>
<tr><td class="e">Path </td><td class="v">C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;c:\Program Files\Common Files\Roxio Shared\DLLShared\;c:\Program Files\Common Files\Roxio Shared\DLLShared\;c:\Program Files\Common Files\Roxio Shared\9.0\DLLShared\;c:\Program Files\Hewlett-Packard\IAM\bin;C:\Program Files\QuickTime\QTSystem\ </td></tr>
 
<tr><td class="e">PATHEXT </td><td class="v">.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC </td></tr>
<tr><td class="e">PLATFORM </td><td class="v">BNB </td></tr>
<tr><td class="e">PROCESSOR_ARCHITECTURE </td><td class="v">x86 </td></tr>
<tr><td class="e">PROCESSOR_IDENTIFIER </td><td class="v">x86 Family 6 Model 15 Stepping 6, GenuineIntel </td></tr>
<tr><td class="e">PROCESSOR_LEVEL </td><td class="v">6 </td></tr>
<tr><td class="e">PROCESSOR_REVISION </td><td class="v">0f06 </td></tr>
 
<tr><td class="e">ProgramData </td><td class="v">C:\ProgramData </td></tr>
<tr><td class="e">ProgramFiles </td><td class="v">C:\Program Files </td></tr>
<tr><td class="e">PUBLIC </td><td class="v">C:\Users\Public </td></tr>
<tr><td class="e">QTJAVA </td><td class="v">C:\Program Files\Java\jre1.6.0\lib\ext\QTJava.zip </td></tr>
<tr><td class="e">RoxioCentral </td><td class="v">c:\Program Files\Common Files\Roxio Shared\9.0\Roxio Central33\ </td></tr>
<tr><td class="e">SystemDrive </td><td class="v">C: </td></tr>
 
<tr><td class="e">SystemRoot </td><td class="v">C:\Windows </td></tr>
<tr><td class="e">TEMP </td><td class="v">C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp </td></tr>
<tr><td class="e">TMP </td><td class="v">C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp </td></tr>
<tr><td class="e">USERDOMAIN </td><td class="v">WORKGROUP </td></tr>
<tr><td class="e">USERNAME </td><td class="v">HP3$ </td></tr>
<tr><td class="e">USERPROFILE </td><td class="v">C:\Windows\ServiceProfiles\NetworkService </td></tr>
 
<tr><td class="e">windir </td><td class="v">C:\Windows </td></tr>
</tbody></table><br>
 

I will also try a reinstall of PHP as I can't remember what was set.

I'll let you know if there is any progress. Thank you for your help
Nathan

[nathj]

Hi,

I tried to load the contesnts in a file attachment but that was too large, I tried to display them in the message but that wouldn't display.

I have now added them to a page on another site that will hopefully give you the info you are after. The address:

www.ne1online.org/demo.html

This is table output that I get from running phpinfo() - a simple copy of the source.

In the mean time I will try to re-install php ensuring to select MySQL as the database.

Many thanks
Nathan

[shoonya]

there you are
the page is showing no db
jo just reinstall care fully this time

cheers

shoonya

[nathj]

there you are
the page is showing no db
jo just reinstall care fully this time

cheers

shoonya

I am trying to re-install, but that all went horribly wrong. I then uninstalled php from my machine and installed php5.2.3 and ensured that IIS knew where the php5isapi.dll file was. Unfortunately this is now not working at all. No php pages display. So I removed IIS and reinstalled it and now I can't get any pages to display at all. I don't get errors I just don't get anything, it's all highly frustrating.

When in installed php I configured it for IIS isapi and ensured the MySQL side of things was selected. This process was very different from the previous attempt, I think previously I must of just downloaded the zip file and not the msi. This time I have downloaded the msi, installed it and then loaded the zip file contents over the top, but nothing. It's like I'm step further back than before.

I would really appreciate some advice on the best way forward from here. I am open to the idea of using other web servers, pretty much anything is a possibility. However, I know precious little about this systems side of things, and that's more than anyone else in the organisation, so I really need some help and advice.

Many thanks
Nathan

[shoonya]

go step wise then
considering that your IIS is working fine (though i have never wrkd on it)
type [HTML]php -v[/HTML] on command promp nd check whether your php is installed well or not

[nathj]

go step wise then
considering that your IIS is working fine (though i have never wrkd on it)
type [HTML]php -v[/HTML] on command promp nd check whether your php is installed well or not

The result of this is:
PHP 5.2.3 (cli) (built May 31 200709:37:32)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright 1998-2007Zend Technologies
Error in my_thread_global_end(): 2 threads didn't exist

I must admit this means nothing to me at all. I really appreciate your help with this.

Nathan

[shoonya]

why don't u try apache ??
frankly speakin
for me also it's the same thng :)

can u look for any error in th confg file

shoonya

[nathj]

why don't u try apache ??
frankly speakin
for me also it's the same thng :)

can u look for any error in th confg file

shoonya

I would happily use Apache but I find the download and install a little scary. What Apache project would I need to run a local web server, it's not going to be exposed to the outside world, it's just on my laptop and that's that. Please advise on the best way forward, I really appreciate your help.

Many thanks
Nathan

[Purple]

Hi,

Whilst I have no problem with shoonya's suggestion of loading and running Apache, I will say the config you are trying to make work should not be causing you a problem..

That said, I am running dual boot Win/XP, IIS, PHP 5.2 and MSSQL one partition and Win/Vista as a base install on the other.

If you want to persue the IIS route, I will take 30 mins to download and install PHP and see where I get to - see if can work through this together..

Post back into this thread to let me know.

Purple

[nathj]

Hi,

Whilst I have no problem with shoonya's suggestion of loading and running Apache, I will say the config you are trying to make work should not be causing you a problem..

That said, I am running dual boot Win/XP, IIS, PHP 5.2 and MSSQL one partition and Win/Vista as a base install on the other.

If you want to persue the IIS route, I will take 30 mins to download and install PHP and see where I get to - see if can work through this together..

Post back into this thread to let me know.

Purple

This sounds great. I'd love the help. However, I have to finish for the day now to go to a speed awareness workshop. I'll post in tomorrow and we can take it from there.

Many thanks Nathan

[nathj]

I am now back at work and ready to learn. I am also feeling slightly less frustrated than yesterday. I should just point out my current system configuration:

Web Server : None
PHP: no longer installed
MYSQL: Installed and working fine

My aim is to have php working correctly with the ability to connect to the MySQL database I have. All of this is just local machine stuff, it is not visible to the outside world, it is for development and testing purposes prior to publication.

Many thanks
Nathan

[shoonya]

gud then
start with web server first
IIS or apache or any other which you prefer
i personally prefer apache coz of open source
nd check whether or your localhost is running or not??

shoonya

[nathj]

gud then
start with web server first
IIS or apache or any other which you prefer
i personally prefer apache coz of open source
nd check whether or your localhost is running or not??

shoonya

I have now ensured that IIS 7.0 is working. On testing this it told me that the php5isapi.dll wasn't installed where it thought it should be. So, I took a risk, I installed php5.2.3 in that location using the msi. This worked a treat. I can now see the main page, which will at least enable me to present the basic template proposal.

I have one question based on the following code and output sample:
[PHP]
<?php
$path = get_cfg_var($cfg_file_path);
if ( $path ){
print "cfg_file_path variable is |$path|";
} else {
print "there was no file path for config <br />";
}

$lvConnection = mysql_connect("localhost:3306", "root", $lcPassword);
if(!$lvConnection)
{
die('Could not connect: ' .mysql_error());
}
else
{
echo "the connection string is $lvConection";
}
?>
[/PHP]

The output is:
there was no file path for config
the connection string is

What am I missing? What should the file path be, and what should the result of mysql_connect9) be?

I really appreciate all the help I'm getting here. I do take a look through the posts everyday to see if there is anything I can help with, even in my Newbie way.

I have also updated the page showing the output of my phpInfo() line:
http://www.ne1online.org/demo.html

I'd really appreciate it if you could point out anything you think I may be missing.

Once again many thanks to you both for all your help, it is greatly appreciated.

Nathan

[shoonya]

your phpinfo.php results are fine showing mySQL is connected

just try the mysql_connect thing only and check whether it's working fine or not
I hope that it should be fine now

enjoy

shoonya

[nathj]

your phpinfo.php results are fine showing mySQL is connected

just try the mysql_connect thing only and check whether it's working fine or not
I hope that it should be fine now

enjoy

shoonya

Thank you, thank you, thank you! I have just run some very simple SQL from the database and printed the results, it is all exactly as I expected. I am actually quite excited by this.

Many thanks for all your help and patience with a newbie, I really appreciate it and hopefully this thread will help others as well.

I'm sure I'll be back asking questions again soon, but for now I'm going to look for someone to help.

Once again my thanks to you all
Nathan

PS I have now removed the demo.html page.

[Purple]

Hi Nathj,

good job getting it all sorted,

as a suggestion take a look at this to help you through your development phase..

Good Luck

Regards Purple

[nathj]

Hi Nathj,

good job getting it all sorted,

as a suggestion take a look at this to help you through your development phase..

Good Luck

Regards Purple

Hey Purple,

I saw that one, I'll take a look at that for the development phase, some good debugging info is always helpful.

Thanks again for your help.
Nathan

[Purple]

Nathan,

No problem, look forward to seeing you back here soon

Purple