Cannot find database

jimmysupport

Lots of good stuff here on this forum..but I fit in this area. While I have been using php for quite some time...all I did was have some code done for me years ago and modified them as I needed...figured it out and it worked.
This week though...I changed to a vps hosting system and everything is different and I have a script I can't get to work for me just says...
Cannot find database

I got the connection script live and working, but the one I need I can't figure out what to put for the database to named properly.

I tried using justanswer.com and they were no help...worse than me.

I think I have it looking for a table in a databse. Here is my code:

<?php
session_start();
//Include database connection details
require_once('connection.php');
?>
<html>
<head>
<script type="text/javascript">

function checkEmail(field) 
{
if (/^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,3})+$/.test(field.value)){
return (true)
}
alert("Invalid Member ID! Please re-enter.")
return (false)
}

function validate_required(field,alerttxt)
{
with (field)
  {
  if (value==null||value=="")
    {
    alert(alerttxt);
    return false;
    }
  else
    {
    return true;
    }
  }
}

function validate_form(thisform)
{
with (thisform)
  {
  if ((validate_required(txt_Member,"Member ID Must Be filled!")==false) || (checkMember(txt_Member) == false))
  {txt_Member.focus();return false;}
  }
}
</script>

<title>Special KWAOR Board Area</title>
<style type="text/css">
<!--
.style1 {
	color: #FFFFFF;
	font-weight: bold;
}
-->
</style>
</head>
<body>
<?php
if( ! isset($_SESSION['status']))
{
?>
<form method="post" action="code30.php" onsubmit="return validate_form(this)">
<table width="100%" height="100%" cellpadding="0" cellspacing="0">
  <tr>
    <td align="center" valign="middle"><table style="border:#006600 1px solid;" width="320" height="120" cellpadding="0" cellspacing="0" bgcolor="#EFEFEF">
      <tr>
        <td valign="top"><table width="100%" height="120" cellpadding="0" cellspacing="0">
          <tr>
            <td colspan="3" align="center" bgcolor="#006600">
			<span class="style1">Member ID Required!</span> </td>
            </tr>
          <tr>
            <td width="41%" align="right">Member ID </td>
            <td width="3%">&nbsp;</td>
            <td width="56%">
              <label>
                <input name="txt_Email" id="txt_Email" type="text">
				<input type="hidden" name="check_submit" value="yes">
                </label>
				</td>
          </tr>
          <tr>
            <td colspan="3" align="center">
              <label>
              <input type="submit" name="Submit" value="Submit">
              </label>
         		<b><font color="#FF0000">Your IP is being Recorded</font></b></td>
            </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table>
</form>
<?php
$_SESSION['status']=1;
}
else
{
if($_POST["check_submit"] == "yes")
{
$eid=$_POST["txt_Email"];

 global $cnnDB2;
 connectDB2();
 $imemberCount = 0;
 $sQuery = "SELECT COUNT(member) AS cnt FROM Members WHERE member = '$eid'";
 $objResult = mysql_query($sQuery, $cnnDB2);

 $aResult=mysql_fetch_array($objResult);
 $imemberCount = $aResult[0];
 ResetDB2();
 if($imemberCount > 0)
 {

$sql='select * from fp14361_Board.kwboard where member ="' . $eid . '"';
$result=mysql_query($sql);
//mysql_close($con);
 if(mysql_num_rows($result) >= 1)
 {
 $row=mysql_fetch_array($result);
 $_SESSION['bcode'] = $row['fld_code'];
 }
else
 {
  $sql="select MAX(fld_code) from fp14361_Board.kwboard";
  $maxcode=mysql_query($sql);
  $row=mysql_fetch_array($maxcode);
  $maxcode=$row[0];
  $maxcode++;
   $sql="insert into code30 values('" .$eid. "'," .$maxcode. ")";  

 mysql_query($sql);
  $_SESSION['bcode'] =$maxcode;
 }
?>
<div align="center">
	<table border="0" width="695" id="table1">
		<tr>
			<td colspan="3" align="center">
			<font size="6" color="#0000FF"><b><br>
			KWAOR Board Area</b></font></td>
		</tr>
		<tr>
			<td align="center" width="326">
			<p align="left"></p>
			<p align="left">&nbsp;</td>
			<td align="center" width="88">
			&nbsp;</td>
			<td align="center" width="267">
			&nbsp;</td>
		</tr>
		<tr>
			<td colspan="3">
			<p align="center">&nbsp;</td>
		</tr>
		<tr>
			<td colspan="3">
			<p align="center"><img id="code_img" src="http://bcgen.com/img/29430-RI95-lin.aspx?D=<?php echo($_SESSION['bcode']); ?>">
</tr>
		<tr><td colspan="3" align="center"><font size="5" color="#0000FF">
							Admission is </font>
												<font size="5" color="#0000ff">ONLY for (<?php echo $eid; ?>)</font></td>
			</tr>
		<tr>
			<td colspan="3">
			<p align="center">&nbsp;</td>
<tr>

<td colspan="3">
<p align="center"><a href="http://kwaor.org/a/bd/MostRecentCommitteeReports_8_24_10.pdf">&nbsp;&nbsp; 
Download Committee Reports Here</a> <font color="#FF0000">(PDF format)</font></p></td>
		</tr>
</table>
</div>

<?php
}
else
{
 echo("<br/><br/><h3>Sorry, Member ID is not in our database. Page authorized only for validated Member ID.</h3><br/><a href='http://www.kwaor.org' >Please Click here to load home Page</a>");
}
}
else
{
echo("<a href='http://kwaor.org' >Please Click here to load home Page</a>");
}
session_destroy();
}
?>
</body>

</html>

Do you think you can help?

I have almost the same code working at oceantate.tv/nordic/test/code30.php

the new site has a different version of MySql and I couldn't match them up.

Krik

First please use the bb tags for php and code. Just above where you type your question and responses is a lot of nifty icons, 3 of them are for code, html, and php. Using the php bb tags makes reading your code much easier.

Next you posted the code that uses data from the database but I suspect that connection.php is were you "connect" to the database and where the problem will be.

jimmysupport

Thank you for looking at the stuff..when I invoke the php code30, it begins to work..
When I first tried I couldn't because I had to fix this connection code...it would always give an error..it does not give any errors now.

<?php
$host="localhost";
$username="fp14361";
$password="kwar100";
$databaseusername="fp14361_fp14361";
$databasename="fp14361_Board";
$connect=mysql_connect($host,$username,$password)
or die("Cannot Connect to database");
mysql_select_db($databasename,$connect) or die
("Cannot find database");

function connectDB2()
{
 global $cnnDB2;
 $db2name = "fp14361_Board";
 $cnnDB2 = mysql_connect("localhost","fp14361_fp14361","kwar100") or die("Cannot Connect to database");
 mysql_select_db($db2name,$cnnDB2) or die("Cannot find database");
}

function ResetDB2()
{
 global $cnnDB2;
 if($cnnDB2)
 {
  mysql_select_db("fp14361_Board",$cnnDB2) or die("Cannot find database");
 }
}
?>

Krik

Just a thought, in the future you may want to exclude your database name, user names and passwords as these forums are open to the public.

But if you notice in the code you have 3 lines that have the error message of "Cannot find database" so that means one, 2 or all 3 of those line are not working.

I would note that you have 2 user names for your database but only one password. Usually if you have 2 user names you have 2 passwords.

After that I would make dead certain that the user name, database name, and passwords are correct.

jimmysupport

The user names do both have the same password.
I think it has to do with the way I have the database name and table specified...
is this the right way to specify the database and the table?:
fp14361_Board.kwboard

Krik

That isthe correct way to refer to a database and one of its tables in a query.

If you need to check to see if a particular query is working do something like this

$sql="select MAX(fld_code) from fp14361_Board.kwboard";
  $maxcode=mysql_query($sql) or die('maxcode query failed');

Note the "or die('maxcode query failed')"