Re: Waiting for localhost
| From: | Ethan Rosenberg | Date: | Thu, 02 Apr 2015 04:18:45 +0000 |
| Subject: | Re: Waiting for localhost | ||
| References: | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48998@lists.php.net to get a copy of this message | ||
On 04/01/2015 11:41 PM, Karl DeSaulniers wrote:
Question to list, since I have not had to venture to the mysqli territory just yet, but is it proper to use mysql_error() with mysqli transactions? This may be what your missing Ethan. mysql_error() looks for a mysql_ transactions doesn't it? Or are they interchangeable? Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Apr 1, 2015, at 10:35 PM, Ethan Rosenberg <erosenberg@hygeiabiomedical.com> wrote:Dear List - Here are some hints.... service apache2 restart [....] Restarting web server: apache2AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message . ok using 127.0.1.1 OUCH Added this as last line in /etc/apache2/apache2.conf ServerName localhost root@meow:/var/www# service apache2 restart [ ok ] Restarting web server: apache2 OK ...good But ... I am still getting the same performance - TestConnect [the code above] gives the same result, and HandleWeight hangs!!! TIA Ethan<snip> Richard - Thanks. The problem is in the database connection. from MySQL mysql> show tables; +-----------------+ | Tables_in_Store | +-----------------+| Charges | | Customers | | Food | | Inventory | | Orders | | Purchases |+-----------------+ This code works... $hostname="localhost"; $database="Store"; $username="ethan"; $password="xxxxx"; $link = mysqli_connect($hostname, $username, $password); if (!$link) { die('Connection failed: ' . mysql_error()); } else{echo "Connection to MySQL server " .$hostname . " successful!" . PHP_EOL; } $db_selected = mysqli_select_db($link, $database); if (!$db_selected) {die ('Can\'t select database: ' . mysql_error());} else {echo 'Database ' . $database . ' successfully selected!';} $sql1 = "show tables"; $result1 = mysqli_query($link, $sql1); $row1 = mysqli_fetch_array($result1); echo 'row1<br />'; print_r($row1); BUT The output is .... Connection to MySQL server localhost successful! Database Store successfully selected! row1 Array ( [0] => Charges [Tables_in_Store] => Charges ) What am I missing?? TIA Ethan -----