|
|
Posted by Bruce A. Julseth on 03/20/07 19:54
"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
Navigation:
[Reply to this message]
|