I already explained this error to you once, the MySQL server is rejecting your connection. You need to talk to the person who set up the MySQL server and have them allow connections from your host. If you are the admin of this MySQL server, install phpmyadmin and figure it out. Matt -----Original Message----- From: Jacob Bergman [mailto:jbergman@xxxxxxxxxxxxxxxxx] Sent: Wednesday, July 11, 2007 10:34 AM To: Janet Valade Cc: php-windows@xxxxxxxxxxxxx Subject: Mysql_send.php When I try to run the mysql_send.php function from your website... from the 3rd edition of the php and mysql for dummies, I get these errors: ************************************************************************ ** Warning: mysqli_connect() [function.mysqli-connect]: (00000/1130): Host 'PHP-AND-MYSQL.VMware.psd267.wednet.edu' is not allowed to connect to this MySQL server in C:\xampp\htdocs\mysql_send.php on line 21 Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in C:\xampp\htdocs\mysql_send.php on line 22 Database Selected: Query: Results ------------------------------------------------------------------------ -------- Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in C:\xampp\htdocs\mysql_send.php on line 28 Error: ------------------------------------------------------------------------ -------- ************************************************************************ **** The screen with the database name and and query comes up ok, but I get what is displayed above as soon as I hit the submit query button. Thanks for the help. Jacob Bergman Network Technician Pullman School District #267 (509) 432-4012 jbergman@xxxxxxxxxxxxxxxxx -----Original Message----- From: Janet Valade [mailto:jvalade@xxxxxxxx] Sent: Monday, July 09, 2007 10:53 AM To: Jacob Bergman Subject: Re: Testing MySQL PHP connection Here you go. Hope the editing marks aren't too confusing. The lines through things don't mean they are crossed out. It means they are in a different type face. Janet Jacob Bergman wrote: > That would be great, thanks! > > Jacob Bergman > Network Technician > Pullman School District #267 > (509) 432-4012 > jbergman@xxxxxxxxxxxxxxxxx > > -----Original Message----- > From: Janet Valade [mailto:jvalade@xxxxxxxx] > Sent: Monday, July 09, 2007 10:04 AM > To: Jacob Bergman > Subject: Re: Testing MySQL PHP connection > > I have installed a document with complete, up-to-date instructions for > installing PHP on my web site at janet.valade.com. This might be helpful > > for you. > > Also, I have instructions that I have just written for installing from > XAMPP on Windows. They are for the book I am writing now. I could send > the XAMPP instructions to you if you would like. > > Janet > > > Jacob Bergman wrote: > > >>Thanks for all the help guys... but I think I am going to blow away > > what > >>I have so far and install wamp5. I want to be able to get on with > > your > >>book Janet :) Thanks for the help though. I'm sure I will have plenty >>more questions. >> >>Jacob Bergman >>Network Technician >>Pullman School District #267 >>(509) 432-4012 >>jbergman@xxxxxxxxxxxxxxxxx >> >>-----Original Message----- >>From: Janet Valade [mailto:jvalade@xxxxxxxx] >>Sent: Monday, July 09, 2007 9:17 AM >>To: Jacob Bergman >>Subject: Re: Testing MySQL PHP connection >> >>There error message means that the mysqli functions are not enabled. >>This means one of two things: (1) you did not activate the mysqli >>functions in php.ini by commenting the mysqli line. After editing >>php.ini, you need to restart your web server. Also, be sure you are >>editing the correct php.ini, as shown in the output of phpinfo(). >> >>(2) PHP cannot the find one or both of the files: php_mysqli.dll >>andlibmysqli.dll. The files must be located where PHP can find them. > > The > >>simplest way is to locate them in a folder that is in your system > > path. > >>If you added c:\php to your system path, copy them there. Or you can >>copy them to your windows\system32 folder. >> >>Janet >> >> >>Jacob Bergman wrote: >> >> >> >>>While trying to connect to the mysqll database with php, I use the >>>following file: >>> >>> >>> >>><?php >>> >>>/* Program: mysql_up.php >>> >>>* Desc: Connects to MySQL Server and >>> >>>* outputs settings. >>> >>>*/ >>> >>>echo "<html> >>> >>> <head><title>Test MySQL</title></head> >>> >>> <body>"; >>> >>>$host="PHP-AND-MYSQL"; >>> >>>$user="root"; >>> >>>$password="Britt9906"; >>> >>> >>> >>>$cxn = mysqli_connect($host,$user,$password); >>> >>>$sql="SHOW STATUS"; >>> >>>$result = mysqli_query($cxn,$sql); >>> >>>if($result == false) >>> >>>{ >>> >>> echo "<h4>Error: ".mysqli_error($cxn)."</h4>"; >>> >>>} >>> >>>else >>> >>>{ >>> >>> /* Table that displays the results */ >>> >>> echo "<table border='1'> >>> >>> <tr><th>Variable_name</th> >>> >>> <th>Value</th></tr>"; >>> >>> for($i = 0; $i < mysqli_num_rows($result); $i++) >>> >>> { >>> >>> echo "<tr>"; >>> >>> $row_array = mysqli_fetch_row($result); >>> >>> for($j = 0;$j < mysqli_num_fields($result);$j++) >>> >>> { >>> >>> echo "<td>".$row_array[$j]."</td>\n"; >>> >>> } >>> >>> } >>> >>> echo "</table>"; >>> >>>} >>> >>>?> >>> >>></body></html> >>> >>> >>> >>>When I access this file I I get "Fatal error: Call to undefined >> >>function >> >> >>>mysqli_connect() in C:\Program Files\Apache >>>Group\Apache2\htdocs\mysql_up.php on line 13" >>> >>> >>> >>>Not sure what is wrong... I'm pretty new to all this and grabbed this >>>out of a book. Thanks for the help! >>> >>> >>> >>>Jacob Bergman >>> >>>Network Technician >>> >>>Pullman School District #267 >>> >>>(509) 432-4012 >>> >>>jbergman@xxxxxxxxxxxxxxxxx >>> >>> >>> >>> >> >> >> > > -- Janet Valade -- janet.valade.com -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
