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