|
|
Posted by Jerry Stuckle on 03/21/07 21:07
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?
>
>
Also, another though here, Bruce. Do you have your permissions set to
allow your Apache user to read/execute libmysql.dll?
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|