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