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