2 databases help

PHP
1

I have to databases running my site, this is inserted on my page how can i choose which database to run a query with?:

$server = “121chatrooms.net”;

$dbuser = “aaaaaaaa”;

$dbpass = “aaaaaaa”;

$dbname = “aaaa”;

mysql_connect($server,$dbuser,$dbpass) or die (“Could not establish connection”); // make connection

mysql_select_db($dbname); // select database

$conn=mysql_connect($server, $dbuser, $dbpass) or die(mysql_error());
$db=mysql_select_db($dbname,$conn) or die(mysql_error());

database 2

<?php
// Connect to the database REMEMBER TO ALSO MODIFY CONFIG.PROPERTIES ALSO TO THE SAME DATABASE INFORMATION

$server2 = “localhost”;

$dbuser2 = “aaaa”;

$dbpass2 = “aaaa”;

$dbname2 = “aaaaaaa”;

mysql_connect($server2,$dbuser2,$dbpass2) or die (“Could not establish connection”); // make connection

mysql_select_db($dbname2); // select database

$conn2=mysql_connect($server2, $dbuser2, $dbpass2) or die(mysql_error());
$db2=mysql_select_db($dbname2,$conn2) or die(mysql_error());

?>

2
  1. Pass $conn or $conn2 as a second parameter to mysql_query.
  2. You can use the database name in your query string, if you use 2 databases on the same server. e.g.
    “SELECT * FROM {$dbname2}.foo WHERE such and such”;
3

like this?

$query23 = mysql_query $conn ("SELECT * FROM member WHERE UserName=‘$loggeduser’ ")

4

$conn goes inside the parentheses:
// I prefer to use heredoc:
$query_string =<<<EOQ
SELECT *
FROM member
WHERE UserName = ‘$loggeduser’
EOQ;
$query23 = mysql_query($query_string, $conn);

and now, I will refer you to the definition of mysql_query.

5

i have attached the $conn to all my code and still is showing the error can you please take a look?


<?php
session_start(); 
include "../remotedatabase.php";
include "../socialdatabase.php";
$loggeduser= "v4";
$updateuser = "$_GET[updateuser]";
$remove = "$_GET[remove]";
$add = "$_GET[add]";

$query23 = mysql_query ("SELECT * FROM member WHERE UserName='$loggeduser' ")
or die("Could not insert data because ".mysql_error());
$qry23 = mysql_fetch_array( $query23, $conn );

if ( $qry23[MemberType] == "5" ||  $qry23[MemberType] == "4" ||  $qry23[MemberType] == "3" ) {
?>
<b>UserName:</b> <select id=userlevel>
<?php
if ( $qry23[MemberType] == "5" ) {
?>
<option value=>SELECT USERNAME</option>
<?php
$result = mysql_db_query($dbname, "SELECT * FROM member WHERE MemberType = '1' or MemberType = '2' or MemberType = '3' or MemberType = '4'  order by username asc ");
if (mysql_num_rows($result, $conn)) {
   while ($qry = mysql_fetch_array($result, $conn)) {
?>
<option value=<?= $qry[UserName] ?>><?= $qry[UserName] ?></option>
<?php
}
}
}
?>
<?php
if ( $qry23[MemberType] == "4" ) {
?>
<option value=>SELECT USERNAME</option>
<?php
$result = mysql_db_query($dbname, "SELECT * FROM member WHERE MemberType = '1' or MemberType = '2' or MemberType = '3'  order by username asc ");
if (mysql_num_rows($result, $conn)) {
   while ($qry = mysql_fetch_array($result, $conn)) {
?>
<option value=<?= $qry[UserName] ?>><?= $qry[UserName] ?></option>
<?php
}
}
}
?>
<?php
if ( $qry23[MemberType] == "3" ) {
?>
<option value=>SELECT USERNAME</option>
<?php
$result = mysql_db_query($dbname, "SELECT * FROM member WHERE MemberType = '1'  order by username asc ");
if (mysql_num_rows($result, $conn)) {
   while ($qry = mysql_fetch_array($result, $conn)) {
?>
<option value=<?= $qry[UserName] ?>><?= $qry[UserName] ?></option>
<?php
}
}
}
?>
</select>
<b>UserLevel:</b> <select id=userlevel>
<?php
if ( $qry23[MemberType] == "5" ) {
?>

<option value=moderator>Moderator</option>
<option value=seniormoderator>Senior Moderator</option>
<option value=administrator>Administrator</option>
<?php
}
?>
<?php
if ( $qry23[MemberType] == "4" ) {
?>

<option value=moderator>Moderator</option>
<option value=seniormoderator>Senior Moderator</option>
<?php
}
?>
<?php
if ( $qry23[MemberType] == "3" ) {
?>

<option value=moderator>Moderator</option>
<?php
}
?>
</select>

<?php
}
$result = mysql_db_query($dbname, "SELECT * FROM member WHERE MemberType = '5' or MemberType = '4' order by username asc ");
echo "<b>Administrators:</b><br>";
if (mysql_num_rows($result, $conn)) {
   while ($qry = mysql_fetch_array($result, $conn)) {

$query2 = mysql_query("SELECT * FROM member WHERE UserName='$qry[UserName]' ")
or die("Could not insert data because ".mysql_error());
$qry2 = mysql_fetch_array( $query2, $conn );

$query4 = mysql_query("SELECT * FROM onlineusers WHERE UserName='$qry[UserName]' ")
or die("Could not insert data because ".mysql_error());
$qry4 = mysql_fetch_array( $query4, $conn );

$query3 = mysql_query("SELECT * FROM room WHERE RoomID='$qry4[RoomID]' ")
or die("Could not insert data because ".mysql_error());
$qry3 = mysql_fetch_array( $query3, $conn );

if (mysql_num_rows($query4) == 0) {
$status = "Offline";
}
else
{
$status = "$qry3[RoomName]";
}
echo "<img src=../images/icons/admin.png> <a href='../profile/$qry2[UserName]' target='_parent'>$qry2[UserName]</a> ($status)";
if ( $qry23[MemberType] == "5" )
{
echo "<a href='test.php?updateuser=$qry2[UserName]&remove=yes'> [Remove]</a>";
}
?>
<br>
<?php
}
}

$result = mysql_db_query($dbname, "SELECT * FROM member WHERE MemberType = '3' order by username asc ");
echo "<br><b>Senior Moderators:</b><br>";
if (mysql_num_rows($result, $conn)) {
   while ($qry = mysql_fetch_array($result, $conn)) {

$query2 = mysql_query("SELECT * FROM member WHERE UserName='$qry[UserName]' ")
or die("Could not insert data because ".mysql_error());
$qry2 = mysql_fetch_array( $query2, $conn );

$query4 = mysql_query("SELECT * FROM onlineusers WHERE UserName='$qry[UserName]' ")
or die("Could not insert data because ".mysql_error());
$qry4 = mysql_fetch_array( $query4, $conn );

$query3 = mysql_query("SELECT * FROM room WHERE RoomID='$qry4[RoomID]' ")
or die("Could not insert data because ".mysql_error());
$qry3 = mysql_fetch_array( $query3, $conn );

if (mysql_num_rows($query4) == 0) {
$status = "Offline";
}
else
{
$status = "$qry3[RoomName]";
}
echo "<img src=../images/icons/srmod.png> <a href='../profile/$qry2[UserName]' target='_parent'>$qry2[UserName]</a> ($status)";
if ( $qry23[MemberType] == "5" || $qry23[MemberType] == "4" )
{
echo "<a href='test.php?updateuser=$qry2[UserName]&remove=yes'> [Remove]</a>";
}
?>
<br>
<?php
}
}
$result = mysql_db_query($dbname, "SELECT * FROM member WHERE MemberType = '2' order by username asc ");
echo "<br><b>Moderators:</b><br>";
if (mysql_num_rows($result)) {
   while ($qry = mysql_fetch_array($result, $conn)) {

$query2 = mysql_query("SELECT * FROM member WHERE UserName='$qry[UserName]' ")
or die("Could not insert data because ".mysql_error());
$qry2 = mysql_fetch_array( $query2, $conn );

$query4 = mysql_query("SELECT * FROM onlineusers WHERE UserName='$qry[UserName]' ")
or die("Could not insert data because ".mysql_error());
$qry4 = mysql_fetch_array( $query4, $conn );

$query3 = mysql_query("SELECT * FROM room WHERE RoomID='$qry4[RoomID]' ")
or die("Could not insert data because ".mysql_error());
$qry3 = mysql_fetch_array( $query3, $conn );

if (mysql_num_rows($query4) == 0) {
$status = "Offline";
}
else
{
$status = "$qry3[RoomName]";
}
echo "<img src=../images/icons/moderator.png> <a href='../profile/$qry2[UserName]' target='_parent'>$qry2[UserName]</a> ($status)";
if ( $qry23[MemberType] == "5" || $qry23[MemberType] == "4" || $qry23[MemberType] == "3" )
{
echo "<a href='test.php?updateuser=$qry2[UserName]&remove=yes'> [Remove]</a>";
}
?>
<br>
<?php
}
}


$query19 = mysql_query("SELECT * FROM member WHERE UserName='$updateuser' ")
or die("Could not insert data because ".mysql_error());
$qry19 = mysql_fetch_array( $query19, $conn );

if ( $remove == "yes" ) {
if ( $qry23[MemberType] == "5" || $qry23[MemberType] == "4" || $qry23[MemberType] == "3" ) { 

if ( $qry23[MemberType] == "3" ) {
if ( $qry19[MemberType] == "1" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('<?= $updateuser ?> is not a moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "2" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('Moderator has been removed');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "3" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot remove this moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "4" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot remove this moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "5" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot remove this moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "6" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot remove this user!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "7" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot remove this user!');
// end hiding -->
</SCRIPT>
<?php
}
}

if ( $qry23[MemberType] == "4" ) {
if ( $qry19[MemberType] == "1" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('<?= $updateuser ?> is not a moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "2" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('Moderator has been removed');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "3" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('Moderator has been removed');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "4" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot remove this moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "5" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot remove this moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "6" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot remove this user!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "7" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot remove this user!');
// end hiding -->
</SCRIPT>
<?php
}
}

if ( $qry23[MemberType] == "5" ) {
if ( $qry19[MemberType] == "1" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('<?= $updateuser ?> is not a moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "2" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('Moderator has been removed');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "3" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('Moderator has been removed');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "4" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('Moderator has been removed');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "5" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot remove this moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "6" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot remove this user!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "7" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot remove this user!');
// end hiding -->
</SCRIPT>
<?php
}
}

}
}




if ( $add == "yes" ) {
if ( $qry23[MemberType] == "5" || $qry23[MemberType] == "4" || $qry23[MemberType] == "3" ) { 

if ( $qry23[MemberType] == "3" ) {
if ( $qry19[MemberType] == "1" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('Moderator has been updated!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "2" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('<?= $updateuser ?> is already a moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "3" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('<?= $updateuser ?> is already a moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "4" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('<?= $updateuser ?> is already a moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "5" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('<?= $updateuser ?> is already a moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "6" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot add this user!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "7" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot add this user!');
// end hiding -->
</SCRIPT>
<?php
}
}

if ( $qry23[MemberType] == "4" ) {
if ( $qry19[MemberType] == "1" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('Moderator has been updated!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "2" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('Moderator has been updated!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "3" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('Moderator has been updated!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "4" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('<?= $updateuser ?> is already a moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "5" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('<?= $updateuser ?> is already a moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "6" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot add this user!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "7" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot add this user!');
// end hiding -->
</SCRIPT>
<?php
}
}

if ( $qry23[MemberType] == "5" ) {
if ( $qry19[MemberType] == "1" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('Moderator has been updated!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "2" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('Moderator has been updated!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "3" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('Moderator has been updated!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "4" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('Moderator has been updated!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "5" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot add this moderator!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "6" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot add this user!');
// end hiding -->
</SCRIPT>
<?php
}
if ( $qry19[MemberType] == "7" ) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from older browsers
alert('You cannot add this user!');
// end hiding -->
</SCRIPT>
<?php
}
}

}
}
?>
6
  1. mysql_db_query has been deprecated as of version 5.3.0, but if you use an earlier version of PHP, add $conn as the 3rd parameter.
  2. $conn is not a parameter of fetch commands. You don’t need it there. The 2nd parameter is the result type: MYSQL_NUM, MYSQL_ASSOC or MYSQL_BOTH, depending on how do you want the returned array indexed.
7

so on this $conn is currently the second parameter what do i add for the 3rd?

$qry23 = mysql_fetch_array( $query23, $conn );

8

You are missing quite a few sets of quotes

9

Check out the manual page for mysql_fetch_array().