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