stevew Posted July 26, 2012 Share Posted July 26, 2012 See attachment for screenshot of phpmyadmin. This connection is producing the following error: it works! Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\xampp\myxampp\TESTING\comment box\data.php on line 11 <?php $sql=mysql_connect("localhost","","") or die(mysql_error()); $select_db = mysql_select_db("commentbox" , $sql); if(isset($select_db)) { echo 'it works!'; } ?> <?php $result = mysql_query("SELECT * FROM comments"); while($row = mysql_fetch_array($result)) { echo $row['comment'] . "<br>"; } ?> Link to comment https://forums.phpfreaks.com/topic/266290-connecting-to-database-problem-in-xampp/ Share on other sites More sharing options...
scootstah Posted July 26, 2012 Share Posted July 26, 2012 You didn't specify a database user. Link to comment https://forums.phpfreaks.com/topic/266290-connecting-to-database-problem-in-xampp/#findComment-1364599 Share on other sites More sharing options...
stevew Posted July 26, 2012 Author Share Posted July 26, 2012 You didn't specify a database user. ok...but if I use the same snippet of code, but direct it to another database it connects (and outputs) fine. Link to comment https://forums.phpfreaks.com/topic/266290-connecting-to-database-problem-in-xampp/#findComment-1364601 Share on other sites More sharing options...
Jessica Posted July 26, 2012 Share Posted July 26, 2012 That database probably allows the root user to have access, while this one doesn't. Link to comment https://forums.phpfreaks.com/topic/266290-connecting-to-database-problem-in-xampp/#findComment-1364603 Share on other sites More sharing options...
stevew Posted July 26, 2012 Author Share Posted July 26, 2012 These are the current privileges: User Host Type Privileges Grant Action root linux global ALL PRIVILEGES Yes Edit Privileges root localhost global ALL PRIVILEGES Yes Edit Privileges All boxes are checked. Link to comment https://forums.phpfreaks.com/topic/266290-connecting-to-database-problem-in-xampp/#findComment-1364604 Share on other sites More sharing options...
Jessica Posted July 26, 2012 Share Posted July 26, 2012 Try putting "root" as the user maybe instead of just ""? Link to comment https://forums.phpfreaks.com/topic/266290-connecting-to-database-problem-in-xampp/#findComment-1364605 Share on other sites More sharing options...
stevew Posted July 26, 2012 Author Share Posted July 26, 2012 You didn't specify a database user. Try putting "root" as the user maybe instead of just ""? That works...thanks Link to comment https://forums.phpfreaks.com/topic/266290-connecting-to-database-problem-in-xampp/#findComment-1364606 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.