>Bruce A. Julseth wrote:
Quote:
>>"Jerry Stuckle" <jstucklex@attglobal.netwrote in message
>>news:rJOdndH_aOZq1pzbnZ2dnUVZ_qemnZ2d@comcast.co m...
>>>Bruce A. Julseth wrote:
>>>>"Jerry Stuckle" <jstucklex@attglobal.netwrote in message
>>>>news:TOqdnQaFier9jJzbnZ2dnUVZ_vmqnZ2d@comcast. com...
>>>>>Bruce A. Pulse's wrote:
>>>>>>"Jerry Stuckle" <jstucklex@attglobal.netwrote in message
>>>>>>news:fICdnY7P1clJ8J3bnZ2dnUVZ_vvinZ2d@comcas t.com...
>>>>>>>Bruce A. Julseth wrote:
>>>>>>>>"Erwin Moller"
>>>>>>>><since_humans_read_this_I_am_spammed_too_m uch@spamyourself.com>
>>>>>>>>wrote in message news:45fff99d$0$69886$e4fe514c@news.xs4all.nl...
>>>>>>>>>Bruce A. Julseth wrote:
>>>>>>>>>>
>>>>>>>>>>"Jerry Stuckle" <jstucklex@attglobal.netwrote in message
>>>>>>>>>>news:IamdnTLNMrgA02LYnZ2dnUVZ_oLinZ2d@co mcast.com...
>>>>>>>>>>>Bruce A. Julseth wrote:
>>>>>>>>>>>>"Jeff" <jeff@quixion.netwrote in message
>>>>>>>>>>>>news:1174344779.712020.258000@p15g2000 hsd.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\funct ions.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
>JDS Computer Training Corp.
