newbie needs help!

danbot26

Hi,

I downloaded a script and Im having trouble implementing it. the problem appears to be that the script won't transfer information between scripts. This is my script (in brief)

<?php
$page_account = "admin";
require('include.php');
$selectdb = mysql_select_db ($database_dbConnection,$dbConnection) or die ("Cannot connect to database");
?>

and this is what's in the inculde file

<?php

FileName="Connection_php_mysql.htm"

Type="MYSQL"

HTTP="true"

$hostname_dbConnection = "xxxx";
$database_dbConnection = "xxxx";
$username_dbConnection = "xxxx";
$password_dbConnection = "xxxx";
$dbConnection = mysql_pconnect($hostname_dbConnection, $username_dbConnection, $password_dbConnection) or die ("Cannot connect to database");
require "engine.php";
?>

none of the db_connecttion values seem to transfer so I can't connect to my datatbase.

This is probably very simple but any ideas why it doesn't work?

tsinka

Hi,

is the mysql_select_db stuff located inside a function ? You might then need to use

function theFunction(...) {
$selectdb = mysql_select_db ($GLOBALS["database_dbConnection"],$GLOBALS["dbConnection"]) or die ("Cannot connect to database"); 
}

Hard to imagine ... can you post the complete script ?

danbot26

This is the complete script that uses the include file shown above. Everytime it gets to the select db line it gices and error. The route to the file is correct but it doesn't seem to want to collect the information.

<?php
$page_account = "admin";
require('include.php');
?>
<?php
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($HTTP_GET_VARS['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $HTTP_GET_VARS['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_dbConnection, $dbConnection);
$Result1 = mysql_query($updateSQL, $dbConnection) or die(mysql_error());

$selectdb = mysql_select_db($database_dbConnection,$dbConnection) or die ("Cannot connect to database");

$query_Recordset1 = "SELECT id, first_name, last_name, payment_type, account_type_name FROM members_waiting_approval ORDER BY first_name ASC";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $dbConnection) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($HTTP_GET_VARS['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $HTTP_GET_VARS['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">

</script>
</head>

<body bgcolor="#cccccc">
<div align="center"></div>
<?php
if (mysql_num_rows($Recordset1) > 0) {
?>
<table width="100%" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#0000CC" bgcolor="#CCCCCC">
<tr bgcolor="#0000CC">
<td> <div align="center"><font size="2"><strong><font color="#FFFFFF" face="Arial, Helvetica, sans-serif">First
Name</font></strong></font></div></td>
<td> <div align="center"><font size="2"><strong><font color="#FFFFFF" face="Arial, Helvetica, sans-serif">Last
Name</font></strong></font></div></td>
<td> <div align="center"><font size="2"><strong><font color="#FFFFFF" face="Arial, Helvetica, sans-serif">Payment
Type</font></strong></font></div></td>
<td><div align="center"><font size="2"><strong><font color="#FFFFFF" face="Arial, Helvetica, sans-serif">Membership</font></strong></font></div></td>
<td> <div align="center"><font size="2"><strong><font color="#FFFFFF" face="Arial, Helvetica, sans-serif">Process</font></strong></font></div></td>
</tr>
<?php do { ?>
<tr bordercolor="#000000" bgcolor="#FFFFFF">
<td><strong><font color="#000000" size="1" face="Arial, Helvetica, sans-serif"><?php echo $row_Recordset1['first_name']; ?></font></strong></td>
<td><strong><font color="#000000" size="1" face="Arial, Helvetica, sans-serif"><?php echo $row_Recordset1['last_name']; ?></font></strong></td>
<td><strong><font color="#000000" size="1" face="Arial, Helvetica, sans-serif"><?php echo $row_Recordset1['payment_type']; ?></font></strong></td>
<td><strong><font color="#000000" size="1" face="Arial, Helvetica, sans-serif"><?php echo $row_Recordset1['account_type_name']; ?></font></strong></td>
<td><div align="center"><strong><font size="1" face="Arial, Helvetica, sans-serif"><a href="waiting_approve.php?id=<?php echo $row_Recordset1['id']; ?>"><font color="#0000CC">+</font></a>
/ <font color="#0000CC"><a href="waiting_approval.php" onClick="MM_openBrWindow('waiting_details.php?id=<?php echo $row_Recordset1['id']; ?>','details','width=350,height=390')"><font color="#0000CC">D</font></a></font>
/ <a href="waiting_delete.php?id=<?php echo $row_Recordset1['id']; ?>"><font color="#FF0000">X</font></a></font></strong></div></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
<?php
}else{
echo "<center><font face=\"arial\"><b>No one is waiting for approval!</b></font></center>";
}
?>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

tsinka

What error do you get exactly and what are the contents of engine.php

danbot26

I get these errors,

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/.sites/95/site464/web/admin/members/members/admin/waiting_approval.php on line 12

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/.sites/95/site464/web/admin/members/members/admin/waiting_approval.php on line 13

the engine.php goes as follows

<?php
function mail_invoice() {
}
/**** DO NOT EDIT BELOW THIS LINE ***/
mysql_select_db($database_dbConnection, $dbConnection);
$get_system_info = "SELECT FROM system_variables";
$result = mysql_query($get_system_info);
while($row = mysql_fetch_object($result)) {
$site_name = "$row->site_name";
$company_name = "$row->company_name";
$company_email = "$row->company_email";
$website_address = "$row->website_address";
$authnet_login = "$row->authnet_login";
$results_url = "$row->results_url";
$finished_url = "$row->finished_url";
$worldpay_installation_id = "$row->worldpay_installation_id";
$worldpay_currency = "$row->worldpay_currency";
$worldpay_finished_url = "$row->worldpay_finished_url";
$paypal_email_address = "$row->paypal_email_address";
$notify_url = "$row->notify_url";
$payment_module_directory = "$row->payment_module_directory";
$password_directory = "$row->password_directory";
$temp_directory = "$row->temp_directory";
$data_directory = "$row->data_directory";
$template_directory = "$row->template_directory";
$block_number = "$row->block_number";
$invoice_url = "$row->invoice_url";
$include_template = "$row->include_template";
$include_agreement = "$row->include_agreement";
$agreement_page = "$row->agreement_page";
$include_billing = "$row->include_billing";
$thank_you_page = "$row->thank_you_page";
$thank_you_page_awaiting_approval = "$row->thank_you_page_awaiting_approval";
$declined_page = "$row->declined_page";
$cancel_page = "$row->cancel_page";
$error_page = "$row->error_page";
$full_url = "$row->full_url";
$member_modify = "$row->member_modify";
$renewal_link = "$row->renewal_link";
$admin_home_page = "$row->admin_home_page";
$member_index = "$row->member_index";
$keep_stats = "$row->keep_stats";
$block_users = "$row->block_users";
$login_page = "$row->login_page";
$use_radio = "$row->use_radio";
$ibill_account = "$row->ibill_account";
$ibill_password = "$row->ibill_password";
}

session_start();
$user = $HTTP_SESSION_VARS[valid_user];
$member_date = date("Y-m-d");
$ok = "deny";

if (session_is_registered("valid_user")) {
$check_user = "SELECT * FROM memberships WHERE user_name = \"$user\" AND active = \"1\" AND paid_until_date >= \"$member_date\"";
$result = mysql_query($check_user);
while ($row = mysql_fetch_object($result)) {
if (stristr($row->package,$page_account)) {
$ok = "valid";
if ($row->paid_until_date < $member_date) {
mail_invoice();
}
}
}
if ($ok != "valid" && $page_account != "form" && $page_account != "membership_home") {
echo "<center><h3><font face=\"arial\">Access Denied!</font></h3></center>";
$update_user = "UPDATE memberships SET active = \"0\" WHERE id = \"$row->id\"";
mysql_query($update_user);
exit;
}
if ($keep_stats == "1") {
$the_page = $SERVER[PHP_SELF];

$ip = $SERVER['REMOTE_ADDR'];
$get_details_sql = "INSERT INTO members_stats (id, user_name, pages, ip)
VALUES (\"\", \"$user\", \"$the_page\", \"$ip\");";
mysql_query($get_details_sql);
}
}else{
if ($page_account != "form" && $page_account != "membership_home" && $page_account != "") {
if ($page_account != "admin") {
header("Location: $login_page");
exit;
}else{
header("Location: login.php");
exit;
}
}
if ($page_account == "membership_home" && !session_is_registered("valid_user")) {
header("Location: login.php");
exit;
}
}

if ($block_users == "1") {
$get_block_data = "SELECT * FROM block WHERE user_name = \"$user\" AND date = \"$member_date\"";
$total_logins = mysql_query($get_block_data, $dbConnection) or die(mysql_error());
$user_logins = mysql_num_rows($total_logins);

if ($block_number < $user_logins) {
	echo "<center><h3>Access Denied!</h3></center>";
	exit;
}else{
	$ip = $_SERVER['REMOTE_ADDR'];
	$get_user_list = "SELECT * FROM block WHERE user_name = \"$user\" AND date = \"$member_date\" AND ip = \"$ip\"";
	$total_list = mysql_query($get_user_list, $dbConnection) or die(mysql_error());
	$total_logins = mysql_num_rows($total_list);
	if ($total_logins <= 0) {
		$ip = $_SERVER['REMOTE_ADDR'];
		$get_details_sql = "INSERT INTO block (id, user_name, date, ip)
					VALUES (\"\", \"$user\", \"$member_date\", \"$ip\");";
		mysql_query($get_details_sql);
	}	
}

}
?>

cgraz

have a look here: mysql_select_db()

Cgraz

DeltaRho2K

You may also want to verify some of the following:

If you have the $hostname_dbConnection variable set as your domain name (something.com), then try switching it to localhost (or whatever your domain has set you up with.)

Also, is a persistent connection important to you? Several users here, and at the php.net manual site kinda frown upon it for several reasons...

Try changing this:

$dbConnection = mysql_pconnect($hostname_dbConnection, $username_dbConnection, $password_dbConnection) or die ("Cannot connect to database");
require "engine.php";

to this:

$dbConnection = mysql_connect($hostname_dbConnection, $username_dbConnection, $password_dbConnection) or die ("Cannot connect to database");
require "engine.php";

and see if that helps any...

Here is the manual link to the persistent connect method:

PHP Manual for mysql_pconnect()