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@psd267.wednet.edu -----Original Message----- From: Janet Valade [mailto:jvalade@eoni.com] Sent: Monday, July 09, 2007 10:53 AM To: Jacob Bergman Subject: Re: [PHP-WIN] 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@psd267.wednet.edu > > -----Original Message----- > From: Janet Valade [mailto:jvalade@eoni.com] > Sent: Monday, July 09, 2007 10:04 AM > To: Jacob Bergman > Subject: Re: [PHP-WIN] 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@psd267.wednet.edu >> >>-----Original Message----- >>From: Janet Valade [mailto:jvalade@eoni.com] >>Sent: Monday, July 09, 2007 9:17 AM >>To: Jacob Bergman >>Subject: Re: [PHP-WIN] 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@psd267.wednet.edu >>> >>> >>> >>> >> >> >> > > -- Janet Valade -- janet.valade.com