|
|
Posted by Jerry Stuckle on 03/21/07 12:04
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
==================
Navigation:
[Reply to this message]
|