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