|
|
Posted by Bruce A. Julseth on 03/22/07 02:30
"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:k4qdncq0WZzhEpzbnZ2dnUVZ_sGqnZ2d@comcast.com...
> Bruce A. Julseth wrote:
>> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
>> news:rJOdndH_aOZq1pzbnZ2dnUVZ_qemnZ2d@comcast.com...
>>> Bruce A. Julseth wrote:
>>>> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
>>>> news:TOqdnQaFier9jJzbnZ2dnUVZ_vmqnZ2d@comcast.com...
>>>>> Bruce A. Pulse's wrote:
>>>>>> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
>>>>>> news:fICdnY7P1clJ8J3bnZ2dnUVZ_vvinZ2d@comcast.com...
>>>>>>> Bruce A. Julseth wrote:
>>>>>>>> "Erwin Moller"
>>>>>>>> <since_humans_read_this_I_am_spammed_too_much@spamyourself.com>
>>>>>>>> wrote in message news:45fff99d$0$69886$e4fe514c@news.xs4all.nl...
>>>>>>>>> Bruce A. Julseth wrote:
>>>>>>>>>
>>>>>>>>>> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
>>>>>>>>>> news:IamdnTLNMrgA02LYnZ2dnUVZ_oLinZ2d@comcast.com...
>>>>>>>>>>> Bruce A. Julseth wrote:
>>>>>>>>>>>> "Jeff" <jeff@quixion.net> wrote in message
>>>>>>>>>>>> news:1174344779.712020.258000@p15g2000hsd.googlegroups.com...
>>>>>>>>>>>>> Get rid of the @ in front of the $db = new mysqli( ...
>>>>>>>>>>>>>
>>>>>>>>>>>>> That is suppressing any errors on that line of code. Then it
>>>>>>>>>>>>> should
>>>>>>>>>>>>> show you in your browser what the error is and then we can
>>>>>>>>>>>>> help you
>>>>>>>>>>>>> further.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Also, you can include $Database as the 4th parameter in your
>>>>>>>>>>>>> mysqli
>>>>>>>>>>>>> constructor to connect to that specific database.
>>>>>>>>>>>>>
>>>>>>>>>>>> Okay, I now have
>>>>>>>>>>>>
>>>>>>>>>>>> $Host = "localhost";
>>>>>>>>>>>> $User = "Fred";
>>>>>>>>>>>> $Database = "house";
>>>>>>>>>>>> $Password = "mypw"
>>>>>>>>>>>>
>>>>>>>>>>>> echo "before mysqli<br />Host: " . $Host . "<br />" . $User .
>>>>>>>>>>>> "<br />"
>>>>>>>>>>>> .
>>>>>>>>>>>> $Database;
>>>>>>>>>>>>
>>>>>>>>>>>> $db = new mysqli($Host, $User, $Password);
>>>>>>>>>>>>
>>>>>>>>>>>> echo "Connection is " . mysqli_connect_errno();
>>>>>>>>>>>>
>>>>>>>>>>>> I didn't add the database to the mysqli parameter list.
>>>>>>>>>>>>
>>>>>>>>>>>> I still never got to the 2nd echo statement. Firefox gives me a
>>>>>>>>>>>> "done"
>>>>>>>>>>>> in the lower left corner. The "mysqli" is the very first MySQL
>>>>>>>>>>>> command I
>>>>>>>>>>>> execute in my program. Do I need "Create" or "instantiate"
>>>>>>>>>>>> something
>>>>>>>>>>>> first? I'm running PHP 5.2.0 (re: phpinfo()) and MySQL Server
>>>>>>>>>>>> 5.0 [I'm
>>>>>>>>>>>> not sure what version. How can I find out?]
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>> Add this to the beginning of your script:
>>>>>>>>>>>
>>>>>>>>>>> error_reporting(E_ALL);
>>>>>>>>>>> ini_set("display_errors", "1");
>>>>>>>>>>>
>>>>>>>>>>> And see what error messages you get. Or check your PHP error
>>>>>>>>>>> log (which
>>>>>>>>>>> may be in the Apache log).
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> ==================
>>>>>>>>>>> Remove the "x" from my email address
>>>>>>>>>>> Jerry Stuckle
>>>>>>>>>>> JDS Computer Training Corp.
>>>>>>>>>>> jstucklex@attglobal.net
>>>>>>>>>>> ==================
>>>>>>>>>> Adding the above code gave the error message:
>>>>>>>>>>
>>>>>>>>>> Fatal error: Class 'mysqli' not found in
>>>>>>>>>> C:\Inetpub\wwwroot\SerenadeHOA\php\functions.php on line 47
>>>>>>>>>>
>>>>>>>>>> This implies to me that I have a configuration problem. What
>>>>>>>>>> should I look
>>>>>>>>>> for.
>>>>>>>>>>
>>>>>>>>>> My php.ini is in my C:\windows directory.:
>>>>>>>>>> I have extension_dir = "c:/php5/ext"
>>>>>>>>>>
>>>>>>>>>> What else should I check?
>>>>>>>>> search for mysqli in your php.ini and comment it in.
>>>>>>>>> Make sure you have the file in a place where PHP looks.
>>>>>>>>>
>>>>>>>>> Next thing to do is running phpinfo() and see if it finds and
>>>>>>>>> loads mysqli.
>>>>>>>>>
>>>>>>>>> Good luck.
>>>>>>>>>
>>>>>>>>> Regards,
>>>>>>>>> Erwin Moller
>>>>>>>>>
>>>>>>>>>> Thanks..
>>>>>>>> I checked my PHPInfo.php with Ctrl-F of the html code and found NOT
>>>>>>>> reference to mysqli. I am referencing C:\Windows\php.ini and
>>>>>>>> that's the correct directory.
>>>>>>>>
>>>>>>>> Here are the mysqli settings in my php.ini.
>>>>>>>>
>>>>>>>> [MySQLi]
>>>>>>>>
>>>>>>>> ; Maximum number of links. -1 means no limit.
>>>>>>>> mysqli.max_links = -1
>>>>>>>>
>>>>>>>> ; Default port number for mysqli_connect(). If unset,
>>>>>>>> mysqli_connect() will use
>>>>>>>> ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or
>>>>>>>> the
>>>>>>>> ; compile-time value defined MYSQL_PORT (in that order). Win32
>>>>>>>> will only look
>>>>>>>> ; at MYSQL_PORT.
>>>>>>>> mysqli.default_port = 3306
>>>>>>>>
>>>>>>>> ; Default socket name for local MySQL connects. If empty, uses the
>>>>>>>> built-in
>>>>>>>> ; MySQL defaults.
>>>>>>>> mysqli.default_socket =
>>>>>>>>
>>>>>>>> ; Default host for mysql_connect() (doesn't apply in safe mode).
>>>>>>>> mysqli.default_host =
>>>>>>>>
>>>>>>>> ; Default user for mysql_connect() (doesn't apply in safe mode).
>>>>>>>> mysqli.default_user =
>>>>>>>>
>>>>>>>> ; Default password for mysqli_connect() (doesn't apply in safe
>>>>>>>> mode).
>>>>>>>> ; Note that this is generally a *bad* idea to store passwords in
>>>>>>>> this file.
>>>>>>>> ; *Any* user with PHP access can run 'echo
>>>>>>>> get_cfg_var("mysqli.default_pw")
>>>>>>>> ; and reveal this password! And of course, any users with read
>>>>>>>> access to this
>>>>>>>> ; file will be able to reveal the password as well.
>>>>>>>> mysqli.default_pw =
>>>>>>>>
>>>>>>>> ; Allow or prevent reconnect
>>>>>>>> mysqli.reconnect = Off
>>>>>>> Do you have ext=extension=php_mysqli.dll in your php.ini?
>>>>>>>
>>>>>>> --
>>>>>>> ==================
>>>>>>> Remove the "x" from my email address
>>>>>>> Jerry Stuckle
>>>>>>> JDS Computer Training Corp.
>>>>>>> jstucklex@attglobal.net
>>>>>>> ==================
>>>>>> extension=php_mysqli.dll is set
>>>>>>
>>>>>> extension=php_mysql.dll is also set. Should I remove that?
>>>>> No, it's perfectly fine to have both of them. Are you sure you're
>>>>> editing the correct php.ini file? Where does phpinfo() say it's
>>>>> getting it from?
>>>>>
>>>>> Does phpinfo() show you're loading the mysql extension? If neither
>>>>> are being loaded, chances are there's a problem with the location of
>>>>> your libmysqlclient.dll file (probably the location). But if the
>>>>> mysql extension is being loaded, then you should be able to get to the
>>>>> MySQL libs.
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> ==================
>>>>> Remove the "x" from my email address
>>>>> Jerry Stuckle
>>>>> JDS Computer Training Corp.
>>>>> jstucklex@attglobal.net
>>>>> ==================
>>>> php.ini is coming from C:\Windows.
>>>>
>>>> Running phpinfo.php I find NO mention of mysql anywhere. Perhaps I
>>>> missed it. I have sent you a screen shot of the phpinfo.php..
>>>>
>>>> Thanks
>>>>
>>>>
>>>>
>>> OK, that means it isn't finding something it needs for mysql - probably
>>> libmysql.dll. Ensure your mysql\bin directory is in your PATH or
>>> libmysql.dll is in a directory in your PATH.
>>>
>>> And sorry - I don't have a screen shot handy - but if it were there
>>> you'd see it.
>>>
>>> --
>>> ==================
>>> Remove the "x" from my email address
>>> Jerry Stuckle
>>> JDS Computer Training Corp.
>>> jstucklex@attglobal.net
>>> ==================
>>
>> C:\Program Files\MySQL\MySQL Server 5.0\bin is in my path. I went to a
>> command line and "Dir"'d this directory to make sure nothing hoaky and
>> the dir worked. libmysql.dll is in this path.
>>
>> BTW: I emailed you (Jerry: removing the x) my php.ini and my phpinfo.php
>> as a pdf file. Did you get it?
>
> Hi, Bruce,
>
> I didn't look at every line - but it looks OK.
>
> Do you have anything in your Apache error log? The way things are set,
> any errors should go there.
>
> And it's find to have both mysql and mysqli extensions enabled.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================
This is the only error in the Apache Log file:
[Wed Mar 21 22:26:17 2007] [error] [client 127.0.0.1] PHP Fatal error:
Class 'mysqli' not found in
C:\\Inetpub\\wwwroot\\SerenadeHOA\\php\\functions.php on line 47, referer:
http://localhost:8080/serenade/Reservations/Schedule.php
Does this give me anything new?? I have a "Common" functions file that I
include in most of my PHP files.
Navigation:
[Reply to this message]
|