php-windows Digest 10 Jul 2007 03:03:18 -0000 Issue 3278

Topics (messages 28176 through 28191):

Windows 2k3 sp2 and mssql error
        28176 by: Zleviticus
        28190 by: bedul

Testing MySQL PHP connection
        28177 by: Jacob Bergman
        28178 by: Stut
        28179 by: Niel Archer
        28180 by: Stut
        28181 by: Jacob Bergman
        28182 by: Stut
        28183 by: Jacob Bergman
        28184 by: Bill Bolte
        28185 by: Jacob Bergman
        28186 by: Jacob Bergman
        28187 by: Jacob Bergman
        28188 by: Murphy, Matt

Re : [PHP-WIN] Testing MySQL PHP connection
        28189 by: Defo Landry

system() call in PHP5 on win2003
        28191 by: Xiaogang

Administrivia:

To subscribe to the digest, e-mail:
        [EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
        [EMAIL PROTECTED]

To post to the list, e-mail:
        [EMAIL PROTECTED]


----------------------------------------------------------------------
--- Begin Message ---
I am perplexed with an issue that i need help on. I have searched and can
not find a resolution and can not find out what is going on. 
 
Here is the situation:
 
I have a windows 2003 Server running IIS 6, php 5.2.1
I have another windows 2003 server running mssql 2000 with all the latest
service packs.
 
i am using a php script via a web page to access data on the server and
display it. when i run the page i get  the standard:
Warning: mssql_connect() [ <http://solomon/Flash/function.mssql-connect>
function.mssql-connect]: Unable to connect to server: 192.168.1.9
 
I can connect to the sql server via the php script if i run it from my
client in my editing software. 
 
What can i do at thins point to troubleshoot and get it to work. It was
working prior to an installation of sp2 for win2k3
 
uninstalling sp2 is not an option. 

--- End Message ---
--- Begin Message ---
sry if i mistaken

----- Original Message -----
From: "Zleviticus" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2007 10:11 PM
Subject: [PHP-WIN] Windows 2k3 sp2 and mssql error


> I am perplexed with an issue that i need help on. I have
searched and can
> not find a resolution and can not find out what is going
on.
>
> Here is the situation:
>
> I have a windows 2003 Server running IIS 6, php 5.2.1
> I have another windows 2003 server running mssql 2000 with
all the latest
> service packs.
i think i will called the first as A and the second as B

------------------------------------------------------------
>
> i am using a php script via a web page to access data on
the server and
> display it. when i run the page i get  the standard:
> Warning: mssql_connect() [
<http://solomon/Flash/function.mssql-connect>
> function.mssql-connect]: Unable to connect to server:
192.168.1.9
where do you execute this script?? on A or B?
i notice 192.168.1.9 was B right??
--------------------------------------------------
> I can connect to the sql server via the php script if i
run it from my
> client in my editing software.
there were another ?? well are this on A or the new one.

i think the problem are on the permision in B.
you should create an user (example)

user: Bedul
Host: %
password: bedul

then when u want to connect this.. try using user Bedul

--- End Message ---
--- Begin Message ---
While trying to connect to the mysqll database with php, I use the
following file:

 

<?php

/* Program: mysql_up.php

 * Desc:    Connects to MySQL Server and 

 *          outputs settings.

 */

 echo "<html>

       <head><title>Test MySQL</title></head>

       <body>";

 $host="PHP-AND-MYSQL";

 $user="root";

 $password="Britt9906";

 

 $cxn = mysqli_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>

 

When I access this file I I get "Fatal error: Call to undefined function
mysqli_connect() in C:\Program Files\Apache
Group\Apache2\htdocs\mysql_up.php on line 13"

 

Not sure what is wrong...  I'm pretty new to all this and grabbed this
out of a book.  Thanks for the help!

 

Jacob Bergman

Network Technician

Pullman School District #267

(509) 432-4012

[EMAIL PROTECTED]

 


--- End Message ---
--- Begin Message ---
Jacob Bergman wrote:
While trying to connect to the mysqll database with php, I use the
following file:

<snip lots of code including the root password!!>

When I access this file I I get "Fatal error: Call to undefined function
mysqli_connect() in C:\Program Files\Apache
Group\Apache2\htdocs\mysql_up.php on line 13"

Not sure what is wrong...  I'm pretty new to all this and grabbed this
out of a book.  Thanks for the help!

You need to enable/install the MySQLi extension. Your book should tell you how to do that, if not: http://php.net/mysqli

-Stut

--
http://stut.net/

--- End Message ---
--- Begin Message ---
Hi

make sure the required dll ("php_mysqli.dll") is enabled in the php.ini
and not still commented out as is the default
--
Niel Archer

--- End Message ---
--- Begin Message ---
Please include the list when replying.

Jacob Bergman wrote:
Yeah, the extension=php_mysqli.dll line is enabled in the php.ini file.
Doesn't that error indicate something wrong with the php file itself?

Have you restarted Apache/IIS/whatever since changing it?

The error indicates that it doesn't have any knowledge of a function called mysqli_connect. That function will be registered when the extension is loaded, so the extension is not being loaded (either correctly or at all).

If you have then make a phpinfo page (http://php.net/phpinfo) and check that PHP thinks MySQLi is installed.

-Stut

--
http://stut.net/

-----Original Message-----
From: Stut [mailto:[EMAIL PROTECTED] Sent: Monday, July 09, 2007 8:18 AM
To: Jacob Bergman
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] Testing MySQL PHP connection

Jacob Bergman wrote:
While trying to connect to the mysqll database with php, I use the
following file:

<snip lots of code including the root password!!>

When I access this file I I get "Fatal error: Call to undefined
function
mysqli_connect() in C:\Program Files\Apache
Group\Apache2\htdocs\mysql_up.php on line 13"

Not sure what is wrong...  I'm pretty new to all this and grabbed this
out of a book.  Thanks for the help!

You need to enable/install the MySQLi extension. Your book should tell you how to do that, if not: http://php.net/mysqli

-Stut


--- End Message ---
--- Begin Message ---
Sorry about that...

Anyways, I created a phpinfo page and don't see anything about mysql in
the output...  

PHP Version 5.2.3 

System  Windows NT PHP-AND-MYSQL 5.1 build 2600  
Build Date  May 31 2007 09:36:39  
Configure Command  cscript /nologo configure.js
"--enable-snapshot-build" "--with-gd=shared"  
Server API  Apache 2.0 Handler  
Virtual Directory Support  enabled  
Configuration File (php.ini) Path  C:\WINDOWS  
Loaded Configuration File  C:\PHP\php.ini  
PHP API  20041225  
PHP Extension  20060613  
Zend Extension  220060519  
Debug Build  no  
Thread Safety  enabled  
Zend Memory Manager  enabled  
IPv6 Support  enabled  
Registered PHP Streams  php, file, data, http, ftp, compress.zlib  
Registered Stream Socket Transports  tcp, udp  
Registered Stream Filters  convert.iconv.*, string.rot13,
string.toupper, string.tolower, string.strip_tags, convert.*, consumed,
zlib.*  

 This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
 


------------------------------------------------------------------------
--------

PHP Credits

------------------------------------------------------------------------
--------

Configuration
PHP Core
Directive Local Value Master Value 
allow_call_time_pass_reference On On 
allow_url_fopen On On 
allow_url_include Off Off 
always_populate_raw_post_data Off Off 
arg_separator.input & & 
arg_separator.output & & 
asp_tags Off Off 
auto_append_file no value no value 
auto_globals_jit On On 
auto_prepend_file no value no value 
browscap no value no value 
default_charset no value no value 
default_mimetype text/html text/html 
define_syslog_variables Off Off 
disable_classes no value no value 
disable_functions no value no value 
display_errors On On 
display_startup_errors Off Off 
doc_root no value no value 
docref_ext no value no value 
docref_root no value no value 
enable_dl On On 
error_append_string no value no value 
error_log no value no value 
error_prepend_string no value no value 
error_reporting 6135 6135 
expose_php On On 
extension_dir ./ ./ 
file_uploads On On 
highlight.bg #FFFFFF #FFFFFF 
highlight.comment #FF8000 #FF8000 
highlight.default #0000BB #0000BB 
highlight.html #000000 #000000 
highlight.keyword #007700 #007700 
highlight.string #DD0000 #DD0000 
html_errors On On 
ignore_repeated_errors Off Off 
ignore_repeated_source Off Off 
ignore_user_abort Off Off 
implicit_flush Off Off 
include_path .;C:\php5\pear .;C:\php5\pear 
log_errors Off Off 
log_errors_max_len 1024 1024 
magic_quotes_gpc Off Off 
magic_quotes_runtime Off Off 
magic_quotes_sybase Off Off 
mail.force_extra_parameters no value no value 
max_execution_time 30 30 
max_input_nesting_level 64 64 
max_input_time 60 60 
memory_limit 128M 128M 
open_basedir no value no value 
output_buffering no value no value 
output_handler no value no value 
post_max_size 8M 8M 
precision 12 12 
realpath_cache_size 16K 16K 
realpath_cache_ttl 120 120 
register_argc_argv On On 
register_globals Off Off 
register_long_arrays On On 
report_memleaks On On 
report_zend_debug On On 
safe_mode Off Off 
safe_mode_exec_dir no value no value 
safe_mode_gid Off Off 
safe_mode_include_dir no value no value 
sendmail_from no value no value 
sendmail_path no value no value 
serialize_precision 100 100 
short_open_tag On On 
SMTP localhost localhost 
smtp_port 25 25 
sql.safe_mode Off Off 
track_errors Off Off 
unserialize_callback_func no value no value 
upload_max_filesize 2M 2M 
upload_tmp_dir no value no value 
user_dir no value no value 
variables_order EGPCS EGPCS 
xmlrpc_error_number 0 0 
xmlrpc_errors Off Off 
y2k_compliance On On 
zend.ze1_compatibility_mode Off Off 


apache2handler
Apache Version  Apache/2.0.59 (Win32) PHP/5.2.3  
Apache API Version  20020903  
Server Administrator  [EMAIL PROTECTED]  
Hostname:Port  PHP-AND-MYSQL.VMware.psd267.wednet.edu:80  
Max Requests  Per Child: 0 - Keep Alive: on - Max Per Connection: 100  
Timeouts  Connection: 300 - Keep-Alive: 15  
Virtual Server  No  
Server Root  C:/Program Files/Apache Group/Apache2  
Loaded Modules  core mod_win32 mpm_winnt http_core mod_so mod_access
mod_actions mod_alias mod_asis mod_auth mod_autoindex mod_cgi mod_dir
mod_env mod_imap mod_include mod_isapi mod_log_config mod_mime mod_php5
mod_negotiation mod_setenvif mod_userdir  

Directive Local Value Master Value 
engine 1 1 
last_modified 0 0 
xbithack 0 0 


Apache Environment
Variable Value 
HTTP_ACCEPT  image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/x-shockwave-flash, application/xaml+xml,
application/vnd.ms-xpsdocument, application/x-ms-xbap,
application/x-ms-application, */*  
HTTP_ACCEPT_LANGUAGE  en-us  
HTTP_ACCEPT_ENCODING  gzip, deflate  
HTTP_USER_AGENT  Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
.NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)  
HTTP_HOST  localhost  
HTTP_CONNECTION  Keep-Alive  
PATH  C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem  
SystemRoot  C:\WINDOWS  
COMSPEC  C:\WINDOWS\system32\cmd.exe  
PATHEXT  .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH  
WINDIR  C:\WINDOWS  
SERVER_SIGNATURE  <address>Apache/2.0.59 (Win32) PHP/5.2.3 Server at
localhost Port 80</address>  
SERVER_SOFTWARE  Apache/2.0.59 (Win32) PHP/5.2.3  
SERVER_NAME  localhost  
SERVER_ADDR  127.0.0.1  
SERVER_PORT  80  
REMOTE_ADDR  127.0.0.1  
DOCUMENT_ROOT  C:/Program Files/Apache Group/Apache2/htdocs  
SERVER_ADMIN  [EMAIL PROTECTED]  
SCRIPT_FILENAME  C:/Program Files/Apache Group/Apache2/htdocs/Info.php  
REMOTE_PORT  2597  
GATEWAY_INTERFACE  CGI/1.1  
SERVER_PROTOCOL  HTTP/1.1  
REQUEST_METHOD  GET  
QUERY_STRING  no value  
REQUEST_URI  /info.php  
SCRIPT_NAME  /info.php  


HTTP Headers Information
HTTP Request Headers 
HTTP Request  GET /info.php HTTP/1.1  
Accept  image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/x-shockwave-flash, application/xaml+xml,
application/vnd.ms-xpsdocument, application/x-ms-xbap,
application/x-ms-application, */*  
Accept-Language  en-us  
Accept-Encoding  gzip, deflate  
User-Agent  Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET
CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)  
Host  localhost  
Connection  Keep-Alive  
HTTP Response Headers 
X-Powered-By  PHP/5.2.3  
Keep-Alive  timeout=15, max=100  
Connection  Keep-Alive  
Transfer-Encoding  chunked  
Content-Type  text/html  


bcmath
BCMath support  enabled  


calendar
Calendar support  enabled  


com_dotnet
COM support enabled 
DCOM support disabled 
.Net support enabled 

Directive Local Value Master Value 
com.allow_dcom 0 0 
com.autoregister_casesensitive 1 1 
com.autoregister_typelib 0 0 
com.autoregister_verbose 0 0 
com.code_page no value no value 
com.typelib_file no value no value 


ctype
ctype functions  enabled  


date
date/time support  enabled  
"Olson" Timezone Database Version  2007.5  
Timezone Database  internal  
Default timezone  Europe/London  

Directive Local Value Master Value 
date.default_latitude 31.7667 31.7667 
date.default_longitude 35.2333 35.2333 
date.sunrise_zenith 90.583333 90.583333 
date.sunset_zenith 90.583333 90.583333 
date.timezone no value no value 


dom
DOM/XML  enabled  
DOM/XML API Version  20031129  
libxml Version  2.6.26  
HTML Support  enabled  
XPath Support  enabled  
XPointer Support  enabled  
Schema Support  enabled  
RelaxNG Support  enabled  


filter
Input Validation and Filtering  enabled  
Revision  $Revision: 1.52.2.39 $  

Directive Local Value Master Value 
filter.default unsafe_raw unsafe_raw 
filter.default_flags no value no value 


ftp
FTP support  enabled  


hash
hash support  enabled  
Hashing Engines  md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128
ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3
tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b
haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4
haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5
haval192,5 haval224,5 haval256,5  


iconv
iconv support  enabled  
iconv implementation  "libiconv"  
iconv library version  1.9  

Directive Local Value Master Value 
iconv.input_encoding ISO-8859-1 ISO-8859-1 
iconv.internal_encoding ISO-8859-1 ISO-8859-1 
iconv.output_encoding ISO-8859-1 ISO-8859-1 


json
json support  enabled  
json version  1.2.1  


libxml
libXML support  active  
libXML Version  2.6.26  
libXML streams  enabled  


odbc
ODBC Support enabled 
Active Persistent Links  0  
Active Links  0  
ODBC library  Win32  

Directive Local Value Master Value 
odbc.allow_persistent On On 
odbc.check_persistent On On 
odbc.default_db no value no value 
odbc.default_pw no value no value 
odbc.default_user no value no value 
odbc.defaultbinmode return as is return as is 
odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes 
odbc.max_links Unlimited Unlimited 
odbc.max_persistent Unlimited Unlimited 


pcre
PCRE (Perl Compatible Regular Expressions) Support  enabled  
PCRE Library Version  7.0 18-Dec-2006  


Reflection
Reflection enabled 
Version  $Id: php_reflection.c,v 1.164.2.33.2.39 2007/05/29 08:44:05
helly Exp $  


session
Session Support  enabled  
Registered save handlers  files user  
Registered serializer handlers  php php_binary wddx  

Directive Local Value Master Value 
session.auto_start Off Off 
session.bug_compat_42 On On 
session.bug_compat_warn On On 
session.cache_expire 180 180 
session.cache_limiter nocache nocache 
session.cookie_domain no value no value 
session.cookie_httponly Off Off 
session.cookie_lifetime 0 0 
session.cookie_path / / 
session.cookie_secure Off Off 
session.entropy_file no value no value 
session.entropy_length 0 0 
session.gc_divisor 100 100 
session.gc_maxlifetime 1440 1440 
session.gc_probability 1 1 
session.hash_bits_per_character 4 4 
session.hash_function 0 0 
session.name PHPSESSID PHPSESSID 
session.referer_check no value no value 
session.save_handler files files 
session.save_path no value no value 
session.serialize_handler php php 
session.use_cookies On On 
session.use_only_cookies Off Off 
session.use_trans_sid 0 0 


SimpleXML
Simplexml support enabled 
Revision  $Revision: 1.151.2.22.2.26 $  
Schema support  enabled  


SPL
SPL support enabled 
Interfaces  Countable, OuterIterator, RecursiveIterator,
SeekableIterator, SplObserver, SplSubject  
Classes  AppendIterator, ArrayIterator, ArrayObject,
BadFunctionCallException, BadMethodCallException, CachingIterator,
DirectoryIterator, DomainException, EmptyIterator, FilterIterator,
InfiniteIterator, InvalidArgumentException, IteratorIterator,
LengthException, LimitIterator, LogicException, NoRewindIterator,
OutOfBoundsException, OutOfRangeException, OverflowException,
ParentIterator, RangeException, RecursiveArrayIterator,
RecursiveCachingIterator, RecursiveDirectoryIterator,
RecursiveFilterIterator, RecursiveIteratorIterator,
RecursiveRegexIterator, RegexIterator, RuntimeException,
SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage,
SplTempFileObject, UnderflowException, UnexpectedValueException  


standard
Regex Library  Bundled library enabled  
Dynamic Library Support  enabled  
Internal Sendmail Support for Windows  enabled  

Directive Local Value Master Value 
assert.active 1 1 
assert.bail 0 0 
assert.callback no value no value 
assert.quiet_eval 0 0 
assert.warning 1 1 
auto_detect_line_endings 0 0 
default_socket_timeout 60 60 
safe_mode_allowed_env_vars PHP_ PHP_ 
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH 
url_rewriter.tags a=href,area=href,frame=src,input=src,form=,fieldset=
a=href,area=href,frame=src,input=src,form=,fieldset= 
user_agent no value no value 


tokenizer
Tokenizer Support  enabled  


wddx
WDDX Support enabled 
WDDX Session Serializer  enabled  


xml
XML Support  active  
XML Namespace Support  active  
libxml2 Version  2.6.26  


xmlreader
XMLReader  enabled  


xmlwriter
XMLWriter  enabled  


zlib
ZLib Support  enabled  
Stream Wrapper support  compress.zlib://  
Stream Filter support  zlib.inflate, zlib.deflate  
Compiled Version  1.2.3  
Linked Version  1.2.3  

Directive Local Value Master Value 
zlib.output_compression Off Off 
zlib.output_compression_level -1 -1 
zlib.output_handler no value no value 


Additional Modules
Module Name 


Environment
Variable Value 
ALLUSERSPROFILE  C:\Documents and Settings\All Users  
CommonProgramFiles  C:\Program Files\Common Files  
COMPUTERNAME  PHP-AND-MYSQL  
ComSpec  C:\WINDOWS\system32\cmd.exe  
FP_NO_HOST_CHECK  NO  
NUMBER_OF_PROCESSORS  1  
OS  Windows_NT  
Path  C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem  
PATHEXT  .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH  
PROCESSOR_ARCHITECTURE  x86  
PROCESSOR_IDENTIFIER  x86 Family 15 Model 6 Stepping 8, GenuineIntel  
PROCESSOR_LEVEL  15  
PROCESSOR_REVISION  0608  
ProgramFiles  C:\Program Files  
SystemDrive  C:  
SystemRoot  C:\WINDOWS  
TEMP  C:\WINDOWS\TEMP  
TMP  C:\WINDOWS\TEMP  
USERPROFILE  C:\Documents and Settings\LocalService  
windir  C:\WINDOWS  
AP_PARENT_PID  3196  


PHP Variables
Variable Value 
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg,
image/pjpeg, application/x-shockwave-flash, application/xaml+xml,
application/vnd.ms-xpsdocument, application/x-ms-xbap,
application/x-ms-application, */* 
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us 
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate 
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30) 
_SERVER["HTTP_HOST"] localhost 
_SERVER["HTTP_CONNECTION"] Keep-Alive 
_SERVER["PATH"] C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem 
_SERVER["SystemRoot"] C:\WINDOWS 
_SERVER["COMSPEC"] C:\WINDOWS\system32\cmd.exe 
_SERVER["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH 
_SERVER["WINDIR"] C:\WINDOWS 
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.0.59 (Win32) PHP/5.2.3
Server at localhost Port 80</address>  
_SERVER["SERVER_SOFTWARE"] Apache/2.0.59 (Win32) PHP/5.2.3 
_SERVER["SERVER_NAME"] localhost 
_SERVER["SERVER_ADDR"] 127.0.0.1 
_SERVER["SERVER_PORT"] 80 
_SERVER["REMOTE_ADDR"] 127.0.0.1 
_SERVER["DOCUMENT_ROOT"] C:/Program Files/Apache Group/Apache2/htdocs 
_SERVER["SERVER_ADMIN"] [EMAIL PROTECTED] 
_SERVER["SCRIPT_FILENAME"] C:/Program Files/Apache
Group/Apache2/htdocs/Info.php 
_SERVER["REMOTE_PORT"] 2597 
_SERVER["GATEWAY_INTERFACE"] CGI/1.1 
_SERVER["SERVER_PROTOCOL"] HTTP/1.1 
_SERVER["REQUEST_METHOD"] GET 
_SERVER["QUERY_STRING"] no value 
_SERVER["REQUEST_URI"] /info.php 
_SERVER["SCRIPT_NAME"] /info.php 
_SERVER["PHP_SELF"] /info.php 
_SERVER["REQUEST_TIME"] 1183995709 
_SERVER["argv"] Array
(
)

 
_SERVER["argc"] 0 
_ENV["ALLUSERSPROFILE"] C:\Documents and Settings\All Users 
_ENV["CommonProgramFiles"] C:\Program Files\Common Files 
_ENV["COMPUTERNAME"] PHP-AND-MYSQL 
_ENV["ComSpec"] C:\WINDOWS\system32\cmd.exe 
_ENV["FP_NO_HOST_CHECK"] NO 
_ENV["NUMBER_OF_PROCESSORS"] 1 
_ENV["OS"] Windows_NT 
_ENV["Path"] C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem 
_ENV["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH 
_ENV["PROCESSOR_ARCHITECTURE"] x86 
_ENV["PROCESSOR_IDENTIFIER"] x86 Family 15 Model 6 Stepping 8,
GenuineIntel 
_ENV["PROCESSOR_LEVEL"] 15 
_ENV["PROCESSOR_REVISION"] 0608 
_ENV["ProgramFiles"] C:\Program Files 
_ENV["SystemDrive"] C: 
_ENV["SystemRoot"] C:\WINDOWS 
_ENV["TEMP"] C:\WINDOWS\TEMP 
_ENV["TMP"] C:\WINDOWS\TEMP 
_ENV["USERPROFILE"] C:\Documents and Settings\LocalService 
_ENV["windir"] C:\WINDOWS 
_ENV["AP_PARENT_PID"] 3196

Jacob Bergman
Network Technician
Pullman School District #267
(509) 432-4012
[EMAIL PROTECTED]

-----Original Message-----
From: Stut [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 09, 2007 8:41 AM
To: Jacob Bergman
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] Testing MySQL PHP connection

Please include the list when replying.

Jacob Bergman wrote:
> Yeah, the extension=php_mysqli.dll line is enabled in the php.ini
file.
> Doesn't that error indicate something wrong with the php file itself?

Have you restarted Apache/IIS/whatever since changing it?

The error indicates that it doesn't have any knowledge of a function 
called mysqli_connect. That function will be registered when the 
extension is loaded, so the extension is not being loaded (either 
correctly or at all).

If you have then make a phpinfo page (http://php.net/phpinfo) and check 
that PHP thinks MySQLi is installed.

-Stut

-- 
http://stut.net/

> -----Original Message-----
> From: Stut [mailto:[EMAIL PROTECTED] 
> Sent: Monday, July 09, 2007 8:18 AM
> To: Jacob Bergman
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-WIN] Testing MySQL PHP connection
> 
> Jacob Bergman wrote:
>> While trying to connect to the mysqll database with php, I use the
>> following file:
> 
> <snip lots of code including the root password!!>
> 
>> When I access this file I I get "Fatal error: Call to undefined
> function
>> mysqli_connect() in C:\Program Files\Apache
>> Group\Apache2\htdocs\mysql_up.php on line 13"
>>
>> Not sure what is wrong...  I'm pretty new to all this and grabbed
this
>> out of a book.  Thanks for the help!
> 
> You need to enable/install the MySQLi extension. Your book should tell

> you how to do that, if not: http://php.net/mysqli
> 
> -Stut
> 

--- End Message ---
--- Begin Message ---
Jacob Bergman wrote:
Sorry about that...

Anyways, I created a phpinfo page and don't see anything about mysql in
the output...

<snip>

Then it's not enabled. Have you restarted your web server since changing php.ini? Are you sure you changed the right php.ini (look near the top of the phpinfo output for where it should go).

-Stut

--
http://stut.net/

-----Original Message-----
From: Stut [mailto:[EMAIL PROTECTED] Sent: Monday, July 09, 2007 8:41 AM
To: Jacob Bergman
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] Testing MySQL PHP connection

Please include the list when replying.

Jacob Bergman wrote:
Yeah, the extension=php_mysqli.dll line is enabled in the php.ini
file.
Doesn't that error indicate something wrong with the php file itself?

Have you restarted Apache/IIS/whatever since changing it?

The error indicates that it doesn't have any knowledge of a function called mysqli_connect. That function will be registered when the extension is loaded, so the extension is not being loaded (either correctly or at all).

If you have then make a phpinfo page (http://php.net/phpinfo) and check that PHP thinks MySQLi is installed.

-Stut



-Stut

--
http://stut.net/

--- End Message ---
--- Begin Message ---
Yes, I restarted Apache and yes I edited the correct php.ini file, it is
looking in C:\windows for the file and I checked to make sure that the
line was uncommented.  Is there anything else I need to be changing in
the php.ini file??  I made sure the php_mysqli.dll file was in the
c:\php folder, in case that would do anything like this...

Jacob Bergman
Network Technician
Pullman School District #267
(509) 432-4012
[EMAIL PROTECTED]

-----Original Message-----
From: Stut [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 09, 2007 8:58 AM
To: Jacob Bergman
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] Testing MySQL PHP connection

Jacob Bergman wrote:
> Sorry about that...
> 
> Anyways, I created a phpinfo page and don't see anything about mysql
in
> the output...  

<snip>

Then it's not enabled. Have you restarted your web server since changing

php.ini? Are you sure you changed the right php.ini (look near the top 
of the phpinfo output for where it should go).

-Stut

-- 
http://stut.net/

> -----Original Message-----
> From: Stut [mailto:[EMAIL PROTECTED] 
> Sent: Monday, July 09, 2007 8:41 AM
> To: Jacob Bergman
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-WIN] Testing MySQL PHP connection
> 
> Please include the list when replying.
> 
> Jacob Bergman wrote:
>> Yeah, the extension=php_mysqli.dll line is enabled in the php.ini
> file.
>> Doesn't that error indicate something wrong with the php file itself?
> 
> Have you restarted Apache/IIS/whatever since changing it?
> 
> The error indicates that it doesn't have any knowledge of a function 
> called mysqli_connect. That function will be registered when the 
> extension is loaded, so the extension is not being loaded (either 
> correctly or at all).
> 
> If you have then make a phpinfo page (http://php.net/phpinfo) and
check 
> that PHP thinks MySQLi is installed.
> 
> -Stut
> 


-Stut

-- 
http://stut.net/

--- End Message ---
--- Begin Message ---
The extension probably needs to be in the "ext" folder inside the php
folder. There is an extension path statement in the ini that points to
where extensions should go. 

-----Original Message-----
From: Jacob Bergman [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 09, 2007 11:04 AM
To: Stut
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] Testing MySQL PHP connection

Yes, I restarted Apache and yes I edited the correct php.ini file, it is
looking in C:\windows for the file and I checked to make sure that the
line was uncommented.  Is there anything else I need to be changing in
the php.ini file??  I made sure the php_mysqli.dll file was in the
c:\php folder, in case that would do anything like this...

Jacob Bergman
Network Technician
Pullman School District #267
(509) 432-4012
[EMAIL PROTECTED]

-----Original Message-----
From: Stut [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 09, 2007 8:58 AM
To: Jacob Bergman
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] Testing MySQL PHP connection

Jacob Bergman wrote:
> Sorry about that...
> 
> Anyways, I created a phpinfo page and don't see anything about mysql
in
> the output...  

<snip>

Then it's not enabled. Have you restarted your web server since changing

php.ini? Are you sure you changed the right php.ini (look near the top 
of the phpinfo output for where it should go).

-Stut

-- 
http://stut.net/

> -----Original Message-----
> From: Stut [mailto:[EMAIL PROTECTED] 
> Sent: Monday, July 09, 2007 8:41 AM
> To: Jacob Bergman
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-WIN] Testing MySQL PHP connection
> 
> Please include the list when replying.
> 
> Jacob Bergman wrote:
>> Yeah, the extension=php_mysqli.dll line is enabled in the php.ini
> file.
>> Doesn't that error indicate something wrong with the php file itself?
> 
> Have you restarted Apache/IIS/whatever since changing it?
> 
> The error indicates that it doesn't have any knowledge of a function 
> called mysqli_connect. That function will be registered when the 
> extension is loaded, so the extension is not being loaded (either 
> correctly or at all).
> 
> If you have then make a phpinfo page (http://php.net/phpinfo) and
check 
> that PHP thinks MySQLi is installed.
> 
> -Stut
> 


-Stut

-- 
http://stut.net/

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--- End Message ---
--- Begin Message ---
The extension is also in the ext folder, I just copied it to the main
c:\php folder... mostly cause the book said too... O.o

Jacob Bergman
Network Technician
Pullman School District #267
(509) 432-4012
[EMAIL PROTECTED]

-----Original Message-----
From: Bill Bolte [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 09, 2007 9:09 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] Testing MySQL PHP connection

The extension probably needs to be in the "ext" folder inside the php
folder. There is an extension path statement in the ini that points to
where extensions should go. 

-----Original Message-----
From: Jacob Bergman [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 09, 2007 11:04 AM
To: Stut
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] Testing MySQL PHP connection

Yes, I restarted Apache and yes I edited the correct php.ini file, it is
looking in C:\windows for the file and I checked to make sure that the
line was uncommented.  Is there anything else I need to be changing in
the php.ini file??  I made sure the php_mysqli.dll file was in the
c:\php folder, in case that would do anything like this...

Jacob Bergman
Network Technician
Pullman School District #267
(509) 432-4012
[EMAIL PROTECTED]

-----Original Message-----
From: Stut [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 09, 2007 8:58 AM
To: Jacob Bergman
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] Testing MySQL PHP connection

Jacob Bergman wrote:
> Sorry about that...
> 
> Anyways, I created a phpinfo page and don't see anything about mysql
in
> the output...  

<snip>

Then it's not enabled. Have you restarted your web server since changing

php.ini? Are you sure you changed the right php.ini (look near the top 
of the phpinfo output for where it should go).

-Stut

-- 
http://stut.net/

> -----Original Message-----
> From: Stut [mailto:[EMAIL PROTECTED] 
> Sent: Monday, July 09, 2007 8:41 AM
> To: Jacob Bergman
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-WIN] Testing MySQL PHP connection
> 
> Please include the list when replying.
> 
> Jacob Bergman wrote:
>> Yeah, the extension=php_mysqli.dll line is enabled in the php.ini
> file.
>> Doesn't that error indicate something wrong with the php file itself?
> 
> Have you restarted Apache/IIS/whatever since changing it?
> 
> The error indicates that it doesn't have any knowledge of a function 
> called mysqli_connect. That function will be registered when the 
> extension is loaded, so the extension is not being loaded (either 
> correctly or at all).
> 
> If you have then make a phpinfo page (http://php.net/phpinfo) and
check 
> that PHP thinks MySQLi is installed.
> 
> -Stut
> 


-Stut

-- 
http://stut.net/

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--- End Message ---
--- Begin Message ---
Thanks for all the help guys... but I think I am going to blow away what
I have so far and install wamp5.  I want to be able to get on with your
book Janet :) Thanks for the help though.  I'm sure I will have plenty
more questions.

Jacob Bergman
Network Technician
Pullman School District #267
(509) 432-4012
[EMAIL PROTECTED]

-----Original Message-----
From: Janet Valade [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 09, 2007 9:17 AM
To: Jacob Bergman
Subject: Re: [PHP-WIN] Testing MySQL PHP connection

There error message means that the mysqli functions are not enabled. 
This means one of two things: (1) you did not activate the mysqli 
functions in php.ini by commenting the mysqli line. After editing 
php.ini, you need to restart your web server. Also, be sure you are 
editing the correct php.ini, as shown in the output of phpinfo().

(2) PHP cannot the find one or both of the files: php_mysqli.dll 
andlibmysqli.dll. The files must be located where PHP can find them. The

simplest way is to locate them in a folder that is in your system path. 
If you added c:\php to your system path, copy them there. Or you can 
copy them to your windows\system32 folder.

Janet


Jacob Bergman wrote:

> While trying to connect to the mysqll database with php, I use the
> following file:
> 
>  
> 
> <?php
> 
> /* Program: mysql_up.php
> 
>  * Desc:    Connects to MySQL Server and 
> 
>  *          outputs settings.
> 
>  */
> 
>  echo "<html>
> 
>        <head><title>Test MySQL</title></head>
> 
>        <body>";
> 
>  $host="PHP-AND-MYSQL";
> 
>  $user="root";
> 
>  $password="Britt9906";
> 
>  
> 
>  $cxn = mysqli_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>
> 
>  
> 
> When I access this file I I get "Fatal error: Call to undefined
function
> mysqli_connect() in C:\Program Files\Apache
> Group\Apache2\htdocs\mysql_up.php on line 13"
> 
>  
> 
> Not sure what is wrong...  I'm pretty new to all this and grabbed this
> out of a book.  Thanks for the help!
> 
>  
> 
> Jacob Bergman
> 
> Network Technician
> 
> Pullman School District #267
> 
> (509) 432-4012
> 
> [EMAIL PROTECTED]
> 
>  
> 
> 


-- 
Janet Valade -- janet.valade.com

--- End Message ---
--- Begin Message ---
Ok, so I put the two files into my system32 directory, which seems to
have fixed the error I was getting... but wouldn't you know it, I know
have 3 more... :(  


Warning: mysqli_connect() [function.mysqli-connect]: (00000/1130): Host
'PHP-AND-MYSQL.VMware.psd267.wednet.edu' is not allowed to connect to
this MySQL server in C:\Program Files\Apache
Group\Apache2\htdocs\mysql_up.php on line 13

Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given
in C:\Program Files\Apache Group\Apache2\htdocs\mysql_up.php on line 15

Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given
in C:\Program Files\Apache Group\Apache2\htdocs\mysql_up.php on line 18

Error:

I have checked the hostname, user, and password in the php file, and
they are all correct.

Jacob Bergman
Network Technician
Pullman School District #267
(509) 432-4012
[EMAIL PROTECTED]

-----Original Message-----
From: Janet Valade [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 09, 2007 9:17 AM
To: Jacob Bergman
Subject: Re: [PHP-WIN] Testing MySQL PHP connection

There error message means that the mysqli functions are not enabled. 
This means one of two things: (1) you did not activate the mysqli 
functions in php.ini by commenting the mysqli line. After editing 
php.ini, you need to restart your web server. Also, be sure you are 
editing the correct php.ini, as shown in the output of phpinfo().

(2) PHP cannot the find one or both of the files: php_mysqli.dll 
andlibmysqli.dll. The files must be located where PHP can find them. The

simplest way is to locate them in a folder that is in your system path. 
If you added c:\php to your system path, copy them there. Or you can 
copy them to your windows\system32 folder.

Janet


Jacob Bergman wrote:

> While trying to connect to the mysqll database with php, I use the
> following file:
> 
>  
> 
> <?php
> 
> /* Program: mysql_up.php
> 
>  * Desc:    Connects to MySQL Server and 
> 
>  *          outputs settings.
> 
>  */
> 
>  echo "<html>
> 
>        <head><title>Test MySQL</title></head>
> 
>        <body>";
> 
>  $host="PHP-AND-MYSQL";
> 
>  $user="root";
> 
>  $password="Britt9906";
> 
>  
> 
>  $cxn = mysqli_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>
> 
>  
> 
> When I access this file I I get "Fatal error: Call to undefined
function
> mysqli_connect() in C:\Program Files\Apache
> Group\Apache2\htdocs\mysql_up.php on line 13"
> 
>  
> 
> Not sure what is wrong...  I'm pretty new to all this and grabbed this
> out of a book.  Thanks for the help!
> 
>  
> 
> Jacob Bergman
> 
> Network Technician
> 
> Pullman School District #267
> 
> (509) 432-4012
> 
> [EMAIL PROTECTED]
> 
>  
> 
> 


-- 
Janet Valade -- janet.valade.com

--- End Message ---
--- Begin Message ---
 
Mysql can be configured to only allow connections from certain hosts,
and it appears your host is not allowed. 

You need to talk to the mysql admin. 

Matt

-----Original Message-----
From: Jacob Bergman [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 09, 2007 11:23 AM
To: Janet Valade
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] Testing MySQL PHP connection

Ok, so I put the two files into my system32 directory, which seems to
have fixed the error I was getting... but wouldn't you know it, I know
have 3 more... :(  


Warning: mysqli_connect() [function.mysqli-connect]: (00000/1130): Host
'PHP-AND-MYSQL.VMware.psd267.wednet.edu' is not allowed to connect to
this MySQL server in C:\Program Files\Apache
Group\Apache2\htdocs\mysql_up.php on line 13

Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given
in C:\Program Files\Apache Group\Apache2\htdocs\mysql_up.php on line 15

Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given
in C:\Program Files\Apache Group\Apache2\htdocs\mysql_up.php on line 18

Error:

I have checked the hostname, user, and password in the php file, and
they are all correct.

Jacob Bergman
Network Technician
Pullman School District #267
(509) 432-4012
[EMAIL PROTECTED]

-----Original Message-----
From: Janet Valade [mailto:[EMAIL PROTECTED]
Sent: Monday, July 09, 2007 9:17 AM
To: Jacob Bergman
Subject: Re: [PHP-WIN] Testing MySQL PHP connection

There error message means that the mysqli functions are not enabled. 
This means one of two things: (1) you did not activate the mysqli
functions in php.ini by commenting the mysqli line. After editing
php.ini, you need to restart your web server. Also, be sure you are
editing the correct php.ini, as shown in the output of phpinfo().

(2) PHP cannot the find one or both of the files: php_mysqli.dll
andlibmysqli.dll. The files must be located where PHP can find them. The

simplest way is to locate them in a folder that is in your system path. 
If you added c:\php to your system path, copy them there. Or you can
copy them to your windows\system32 folder.

Janet


Jacob Bergman wrote:

> While trying to connect to the mysqll database with php, I use the 
> following file:
> 
>  
> 
> <?php
> 
> /* Program: mysql_up.php
> 
>  * Desc:    Connects to MySQL Server and 
> 
>  *          outputs settings.
> 
>  */
> 
>  echo "<html>
> 
>        <head><title>Test MySQL</title></head>
> 
>        <body>";
> 
>  $host="PHP-AND-MYSQL";
> 
>  $user="root";
> 
>  $password="Britt9906";
> 
>  
> 
>  $cxn = mysqli_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>
> 
>  
> 
> When I access this file I I get "Fatal error: Call to undefined
function
> mysqli_connect() in C:\Program Files\Apache 
> Group\Apache2\htdocs\mysql_up.php on line 13"
> 
>  
> 
> Not sure what is wrong...  I'm pretty new to all this and grabbed this

> out of a book.  Thanks for the help!
> 
>  
> 
> Jacob Bergman
> 
> Network Technician
> 
> Pullman School District #267
> 
> (509) 432-4012
> 
> [EMAIL PROTECTED]
> 
>  
> 
> 


--
Janet Valade -- janet.valade.com

--
PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php

--- End Message ---
--- Begin Message ---
Generaly, i have this error ecause i am not using the right version of file 
libmySQL.dll.

It seems like there is compatibility with this file and the one with came with 
mysql (bin directory).
My workaround is to find all occurences of this file in the computer, delete 
(or rename) them all. Then, i copy the version file with came with php (or the 
one with came with mysql, i dont remember well) in the Window directory.

Let me know if it work for you. I always have this error when i install PHP.



----- Message d'origine ----
De : Bill Bolte <[EMAIL PROTECTED]>
À : [EMAIL PROTECTED]
Envoyé le : Lundi, 9 Juillet 2007, 16h08mn 35s
Objet : RE: [PHP-WIN] Testing MySQL PHP connection

The extension probably needs to be in the "ext" folder inside the php
folder. There is an extension path statement in the ini that points to
where extensions should go. 

-----Original Message-----
From: Jacob Bergman [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 09, 2007 11:04 AM
To: Stut
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] Testing MySQL PHP connection

Yes, I restarted Apache and yes I edited the correct php.ini file, it is
looking in C:\windows for the file and I checked to make sure that the
line was uncommented.  Is there anything else I need to be changing in
the php.ini file??  I made sure the php_mysqli.dll file was in the
c:\php folder, in case that would do anything like this...

Jacob Bergman
Network Technician
Pullman School District #267
(509) 432-4012
[EMAIL PROTECTED]

-----Original Message-----
From: Stut [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 09, 2007 8:58 AM
To: Jacob Bergman
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] Testing MySQL PHP connection

Jacob Bergman wrote:
> Sorry about that...
> 
> Anyways, I created a phpinfo page and don't see anything about mysql
in
> the output...  

<snip>

Then it's not enabled. Have you restarted your web server since changing

php.ini? Are you sure you changed the right php.ini (look near the top 
of the phpinfo output for where it should go).

-Stut

-- 
http://stut.net/

> -----Original Message-----
> From: Stut [mailto:[EMAIL PROTECTED] 
> Sent: Monday, July 09, 2007 8:41 AM
> To: Jacob Bergman
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-WIN] Testing MySQL PHP connection
> 
> Please include the list when replying.
> 
> Jacob Bergman wrote:
>> Yeah, the extension=php_mysqli.dll line is enabled in the php.ini
> file.
>> Doesn't that error indicate something wrong with the php file itself?
> 
> Have you restarted Apache/IIS/whatever since changing it?
> 
> The error indicates that it doesn't have any knowledge of a function 
> called mysqli_connect. That function will be registered when the 
> extension is loaded, so the extension is not being loaded (either 
> correctly or at all).
> 
> If you have then make a phpinfo page (http://php.net/phpinfo) and
check 
> that PHP thinks MySQLi is installed.
> 
> -Stut
> 


-Stut

-- 
http://stut.net/

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php








      
_____________________________________________________________________________ 
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail 

--- End Message ---
--- Begin Message --- We used to use php 4 on our web server on win2000, and use the system() to call some DOS programs. That how we call it:

    $cmd = "c:\\Inetpub\\wwwroot\\test.exe";
        $last_line = system($cmd, $retval);
        print ("<br>\nretval =\"". $retval. "\"<br>\n");

It was working perfectly for years.

However, recently we moved to a win2003 server, and install the php 5.2.3, and now the system() no longer works as expected:

   1. It no longer work in the web, the only result returned
      to the web browser is "retval =-1";

   2. It still works if tested in DOS commandline (use the
      command such as "php test.php");

   3. Even change the $cmd to "type test.txt" or "dir", the
      result is the same: works in DOS prompt window, but
      not web browser (received only "retval =-1").

I have checked the permissions on all those files/folders, even tried giving read/execute permission to "everyone", still no help.

In our configuation, the safe mode is off.

Any clue? Thanks in advance.

Xiaogang

--- End Message ---

Reply via email to