wmguk Posted November 14, 2008 Share Posted November 14, 2008 Hi, I have a script, and the connect script is in the correct folder etc.. however when i view the page it doesnt load properly and then if i view the source it says Could not connect, and everything stops (it doesnt even give the error or finish loading the page <?php include "../admin/scripts/connection.php"; if (!$con) { die( 'Could not connect: ' . mysql_error() ); } mysql_select_db($db, $con); $sqlcms = "SELECT * FROM cmssystem WHERE active = 'yes'"; $resultcms = mysql_query( $sqlcms ) or die( "<strong>Query Error</strong>: " . mysql_error() . "<br><strong>Query</strong>: $sqlcms<br><br>" ); while($row = mysql_fetch_array($resultcms)) { ?> <li><a href="../admin/cms/edit.php?name=<?php echo $row['name']; ?>"><?php echo $row['displayname']; ?></a></li> <?php } ?> is there anything obvious? Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/ Share on other sites More sharing options...
Lee-Bartlett Posted November 14, 2008 Share Posted November 14, 2008 Im not sure why it wont connect, i am new, but why do you leave the if con, die bit out of your include file? Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/#findComment-690244 Share on other sites More sharing options...
flyhoney Posted November 14, 2008 Share Posted November 14, 2008 Going to need to see what is in that connection script. Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/#findComment-690245 Share on other sites More sharing options...
wmguk Posted November 14, 2008 Author Share Posted November 14, 2008 <?php $host = "localhost"; //Host name $dbUser = "XXX"; //MySQL Username $dbPass = "XXXX"; //MySQL Password $db = "XXXX" ; //Database name $con = mysql_connect($host,$dbUser,$dbPass) or die(mysql_error()); mysql_select_db($db, $con) or die(mysql_error()); ?> Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/#findComment-690253 Share on other sites More sharing options...
Lee-Bartlett Posted November 14, 2008 Share Posted November 14, 2008 is it cause you repeated the if con, die, say could not connect. basically twice? Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/#findComment-690255 Share on other sites More sharing options...
flyhoney Posted November 14, 2008 Share Posted November 14, 2008 Your script looks fine. You just need to verify that your information is correct. If you are using a hosting service it is possible that 'localhost' will not work. Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/#findComment-690256 Share on other sites More sharing options...
wmguk Posted November 14, 2008 Author Share Posted November 14, 2008 the thing that gets me is this whole site is CMS etc, and this is the only error with scripts... its like the script crashes half way through the page, ive commented out the second connection info and that still hasnt fixed ... how odd Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/#findComment-690264 Share on other sites More sharing options...
wmguk Posted November 14, 2008 Author Share Posted November 14, 2008 this is the page script: <?php session_start(); if (!isset($_SESSION['username'])) { header('Location: http://www.XXXXXX.co.uk/admin'); exit; } $name = $_SESSION['name'] ; $admin = $_SESSION['admin']; ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/admin.dwt" codeOutsideHTMLIsLocked="false" --> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>XXXXX is a highly professional and Independent Recruitment Agency</title> <link href="../../XXXXX.css" rel="stylesheet" type="text/css" /> <script src="../../SpryAssets/SpryMenuBar.js" type="text/javascript"></script> <link href="../../SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" /> <link href="../../SpryAssets/SpryMenuBarVertical.css" rel="stylesheet" type="text/css" /> <!-- InstanceBeginEditable name="head" --> <script src="../../SpryAssets/SpryMenuBar.js" type="text/javascript"></script> <link href="../../SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" /> <link href="../../SpryAssets/SpryMenuBarVertical.css" rel="stylesheet" type="text/css" /> <!-- InstanceEndEditable --> </head> <body> <table width="800" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td colspan="2" align="center"><img src="../../images/demotop.gif" alt="XXXXX" width="800" height="122" /></td> </tr> <tr> <td height="21" bgcolor="#006699"><span class="adminheader"> Welcome to the XXXXXX Control Panel</span></td> <td align="right" bgcolor="#006699"><span class="adminheader">You are currently logged in as: <? echo $name ; ?> </span></td> </tr> <tr> <td colspan="2" align="right" class="header">User Level: <? echo $admin; ?> </td> </tr> <tr> <td colspan="2"><table width="100%" border="0" cellspacing="10" cellpadding="0"> <tr> <td align="left" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="130" valign="top"><ul id="MenuBar1" class="MenuBarVertical"> <li><a class="MenuBarItemSubmenu" href="../main.php">Clients</a> <ul> <li><a href="../clientlist.php">View List</a></li> <li><a href="../create.php?type=client">Create Client</a></li> <li><a href="../amend.php?type=client">Amend Client</a> </li> <li><a href="../create.php?type=contact">Create Contact</a></li> <li><a href="../amend.php?type=contact">Amend Contact</a></li> </ul> </li> <li><a href="#" class="MenuBarItemSubmenu">General Admin</a> <ul> <li><a href="../sector.php">Business Sector</a></li> </ul> </li> <li><a class="MenuBarItemSubmenu" href="../main.php">Candidates</a> <ul> <li><a href="#">View List</a></li> <li><a href="../create.php?type=candidate">Create Candidate</a></li> <li><a href="../amend.php?type=candidate">Amend Candidate</a></li> </ul> </li> <li><a href="#" class="MenuBarItemSubmenu">Prospective Clients</a> <ul> <li><a href="../prospectlist.php">View List</a></li> <li><a href="#">Add Prospect</a></li> <li><a href="#">Amend Prospect</a></li> </ul> </li> <li><a href="../main.php" class="MenuBarItemSubmenu">Communications</a> <ul> <li><a href="#">Client Communications</a></li> <li><a href="#">Candidate Communications</a></li> </ul> </li> <li><a href="../main.php" class="MenuBarItemSubmenu">Cowper Staff</a> <ul> <li><a href="create.php">Create Staff</a></li> <li><a href="edit.php">Edit Staff</a></li> <li><a href="delete.php">Delete Staff</a></li> </ul> </li> <li><a href="../main.php" class="MenuBarItemSubmenu">Main Website</a> <ul> <?php include "../admin/scripts/connection.php"; if (!$con) { die( 'Could not connect: ' . mysql_error() ); } mysql_select_db($db, $con); $sqlcms = "SELECT * FROM cmssystem WHERE active = 'yes' && team != '1'"; $resultcms = mysql_query( $sqlcms ) or die( "<strong>Query Error</strong>: " . mysql_error() . "<br><strong>Query</strong>: $sqlcms<br><br>" ); while($row = mysql_fetch_array($resultcms)) { ?> <li><a href="../cms/edit.php?name=<?php echo $row['name']; ?>"><?php echo $row['displayname']; ?></a></li> <?php } ?> <li><a href="../cms/theteam.php" class="MenuBarItemSubmenu">Our Team</a> <ul> <?php $sqlteam = "SELECT * FROM cmssystem WHERE active = 'yes' && team == '1'"; $resultteam = mysql_query( $sqlteam ) or die( "<strong>Query Error</strong>: " . mysql_error() . "<br><strong>Query</strong>: $sqlteam<br><br>" ); while($row = mysql_fetch_array($resultteam)) { ?> <li><a href="../cms/edit.php?name=<?php echo $row['name']; ?>"><?php echo $row['displayname']; ?></a></li> <?php } ?> </ul> </li> <li><a href="../cms/contact.php">Contact Us</a></li> </ul> </li> <li><a href="../main.php">Timesheets</a></li> <? if ($admin == 'User') { } else {?> <li><a href="../main.php" class="MenuBarItemSubmenu">Reports</a> <ul> <li><a href="#" class="MenuBarItemSubmenu">Current</a> <ul> <li><a href="#">Report 1</a></li> <li><a href="#">Report 2</a></li> </ul> </li> <li><a href="#" class="MenuBarItemSubmenu">Archived</a> <ul> <li><a href="#">Report 1</a></li> <li><a href="#">Report 2</a></li> </ul> </li> </ul> </li><?php } ?> </ul></td> <td align="left" valign="top"><!-- InstanceBeginEditable name="mainpage" --> <table width="600" border="1" align="center" cellpadding="3" cellspacing="0" bordercolor="#006699" background="../../images/pageback.gif"> <tr> <td bgcolor="#006699" class="adminheader">Staff Editing Page</td> </tr> <tr> <td><p class="general">Please select the member of staff below:</p> <p class="general"> <form> <select name="direct" class="general" onchange="if(this.selectedIndex) document.getElementById('editu').src = 'editu.php?username='+this.options[this.selectedIndex].value;"> <option selected="selected">- Select -</option> <?php /* include "../scripts/connection.php"; if (!$con) { die( 'Could not connect: ' . mysql_error() ); } mysql_select_db($db, $con); $sql = "SELECT * FROM users"; $result = mysql_query( $sql ) or die( "<strong>Query Error</strong>: " . mysql_error() . "<br><strong>Query</strong>: $sql<br><br>" ); */ while($row = mysql_fetch_array($result)) { echo "<option value=". $row['username'] . ">". $row['name'] . "</option>"; } ?> </select> </form> </p> <iframe id="editu" width="500" height="300" frameborder="0" scrolling="no" src="blankpage.html"></iframe> </td> </tr> </table> <p class="general"> <!-- InstanceEndEditable --></td> </tr> </table> <script type="text/javascript"> <!-- var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgRight:"../SpryAssets/SpryMenuBarRightHover.gif"}); //--> </script> </td> </tr> </table></td> </tr> <tr> <td colspan="2" align="center" bgcolor="#006699"> <table width="800" border="0" cellspacing="3" cellpadding="0"> <tr> <td><span class="adminheader">©2008 XXXX Limited.</span></td> <td align="right" class="adminheader">Telephone: XXX</td> </tr> </table></td> </tr> </table> </body> <!-- InstanceEnd --></html> Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/#findComment-690269 Share on other sites More sharing options...
runnerjp Posted November 14, 2008 Share Posted November 14, 2008 <?php // we connect to your website $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); ?> [code] give it a go and see what you get... Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/#findComment-690270 Share on other sites More sharing options...
wmguk Posted November 14, 2008 Author Share Posted November 14, 2008 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/admin.dwt" codeOutsideHTMLIsLocked="false" --> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>XXXXLimited is a highly professional and Independent Recruitment Agency</title> <link href="../../XXXX.css" rel="stylesheet" type="text/css" /> <script src="../../SpryAssets/SpryMenuBar.js" type="text/javascript"></script> <link href="../../SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" /> <link href="../../SpryAssets/SpryMenuBarVertical.css" rel="stylesheet" type="text/css" /> <!-- InstanceBeginEditable name="head" --> <script src="../../SpryAssets/SpryMenuBar.js" type="text/javascript"></script> <link href="../../SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" /> <link href="../../SpryAssets/SpryMenuBarVertical.css" rel="stylesheet" type="text/css" /> <!-- InstanceEndEditable --> </head> <body> <table width="800" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td colspan="2" align="center"><img src="../../images/demotop.gif" alt="XXXXLimited is a highly professional and Independent Recruitment Agency" width="800" height="122" /></td> </tr> <tr> <td height="21" bgcolor="#006699"><span class="adminheader"> Welcome to the XXXXXControl Panel</span></td> <td align="right" bgcolor="#006699"><span class="adminheader">You are currently logged in as: XXX </span></td> </tr> <tr> <td colspan="2" align="right" class="header">User Level: Administrator </td> </tr> <tr> <td colspan="2"><table width="100%" border="0" cellspacing="10" cellpadding="0"> <tr> <td align="left" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="130" valign="top"><ul id="MenuBar1" class="MenuBarVertical"> <li><a class="MenuBarItemSubmenu" href="../main.php">Clients</a> <ul> <li><a href="../clientlist.php">View List</a></li> <li><a href="../create.php?type=client">Create Client</a></li> <li><a href="../amend.php?type=client">Amend Client</a> </li> <li><a href="../create.php?type=contact">Create Contact</a></li> <li><a href="../amend.php?type=contact">Amend Contact</a></li> </ul> </li> <li><a href="#" class="MenuBarItemSubmenu">General Admin</a> <ul> <li><a href="../sector.php">Business Sector</a></li> </ul> </li> <li><a class="MenuBarItemSubmenu" href="../main.php">Candidates</a> <ul> <li><a href="#">View List</a></li> <li><a href="../create.php?type=candidate">Create Candidate</a></li> <li><a href="../amend.php?type=candidate">Amend Candidate</a></li> </ul> </li> <li><a href="#" class="MenuBarItemSubmenu">Prospective Clients</a> <ul> <li><a href="../prospectlist.php">View List</a></li> <li><a href="#">Add Prospect</a></li> <li><a href="#">Amend Prospect</a></li> </ul> </li> <li><a href="../main.php" class="MenuBarItemSubmenu">Communications</a> <ul> <li><a href="#">Client Communications</a></li> <li><a href="#">Candidate Communications</a></li> </ul> </li> <li><a href="../main.php" class="MenuBarItemSubmenu">Cowper Staff</a> <ul> <li><a href="create.php">Create Staff</a></li> <li><a href="edit.php">Edit Staff</a></li> <li><a href="delete.php">Delete Staff</a></li> </ul> </li> <li><a href="../main.php" class="MenuBarItemSubmenu">Main Website</a> <ul> Could not connect: this is the source of the page that is displayed Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/#findComment-690271 Share on other sites More sharing options...
runnerjp Posted November 14, 2008 Share Posted November 14, 2008 Could not connect: ... what was the error?? Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/#findComment-690272 Share on other sites More sharing options...
wmguk Posted November 14, 2008 Author Share Posted November 14, 2008 thats what i mean, the page stops..... there is nothing at all after could not connect: (I ran <?php // we connect to your website $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); ?> and got connected successfully Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/#findComment-690274 Share on other sites More sharing options...
flyhoney Posted November 14, 2008 Share Posted November 14, 2008 Copy the contents of that include file into the main script and remove the include statement and see what happens. Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/#findComment-690279 Share on other sites More sharing options...
wmguk Posted November 14, 2008 Author Share Posted November 14, 2008 hmmm, that failed so I just made a new page: <?php $host = "localhost"; //Host name $dbUser = "XXX"; //MySQL Username $dbPass = "XXX"; //MySQL Password $db = "X_X" ; //Database name $con = mysql_connect($host,$dbUser,$dbPass) or die(mysql_error()); if (!$con) { die( 'Could not connect: ' . mysql_error() ); } mysql_select_db($db, $con) or die(mysql_error()); $sqlcms = "SELECT * FROM cmssystem WHERE active = 'yes' && team != '1'"; $resultcms = mysql_query( $sqlcms ) or die( "<strong>Query Error</strong>: " . mysql_error() . "<br><strong>Query</strong>: $sqlcms<br><br>" ); while($row = mysql_fetch_array($resultcms)) { ?> <li><a href="../admin/cms/edit.php?name=<?php echo $row['name']; ?>"><?php echo $row['displayname']; ?></a></li> <?php } ?> and it worked fine, so there must be a code issue.... Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/#findComment-690286 Share on other sites More sharing options...
wmguk Posted November 14, 2008 Author Share Posted November 14, 2008 hey, omg!!! I missed a </ul>!!!! Solved it! Link to comment https://forums.phpfreaks.com/topic/132730-mysql-could-not-connect/#findComment-690292 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.