|
|
Posted by Jerry Stuckle on 03/21/07 21:02
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
==================
[Back to original message]
|