Ad:

PHP Discussion Thread
Marked Solved
Views: 1967

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Jul 2nd, 2008

The page donot load completely untill I refresh the page

Expand Post »

Hello All,
I have this strange problem ..

I am using require function twice in a single program to call two different programs.Each one of them has their own database connections.

The page doesnot execute completely untill I hit refresh.

It works as if those functions are executing one-after-the-other while I use refresh ...till then the HTML parts in the called functions appear but the mysql database values do not appear while leaving blank or previous data values in that place

Do I have to close the database connections at the end of each and every program?
I am getting the desired output only after hitting the refresh each time.

Can someone help me out with this.

Thanks in advance,

Last edited by Kavitha Butchi; Jul 2nd, 2008 at 3:35 am.

Kavitha Butchi

Reputation Points: 10

Solved Threads: 4

Junior Poster in Training

Offline

69 posts
since May 2008

Permalink

Jul 2nd, 2008

Re: The page donot load completely untill I refresh the page

try to use require once rather than require.
are they each connectiong to a different Db?
and yes as a security flaw you should close the connection when you are finished.

casper_wang

Reputation Points: 13

Solved Threads: 7

Junior Poster in Training

Offline

67 posts
since Jul 2008

Permalink

Jul 2nd, 2008

Re: The page donot load completely untill I refresh the page

Click to Expand / Collapse Quote originally posted by casper_wang ...

try to use require once rather than require.
are they each connectiong to a different Db?
and yes as a security flaw you should close the connection when you are finished.

Hi casper_wang,
Thankyou for your time. As per your suggestions,

I changed each and every require() to require_once().

I used mysql_free_result( ) and mysql_close( ) at the end of every program.

Yes each are connecting to different databases.

Still the same problem persists.. any more suggestions will be appreciated.

Thank you.

Kavitha Butchi

Reputation Points: 10

Solved Threads: 4

Junior Poster in Training

Offline

69 posts
since May 2008

Permalink

Jul 2nd, 2008

Re: The page donot load completely untill I refresh the page

Please Let me know if you want to have a look at the code to resolve the issue.

Kavitha Butchi

Reputation Points: 10

Solved Threads: 4

Junior Poster in Training

Offline

69 posts
since May 2008

Permalink

Jul 3rd, 2008

Re: The page donot load completely untill I refresh the page

yes, please post the code so I and others may look for a problem in the code itself.

casper_wang

Reputation Points: 13

Solved Threads: 7

Junior Poster in Training

Offline

67 posts
since Jul 2008

Permalink

Jul 3rd, 2008

Re: The page donot load completely untill I refresh the page

Thank you for that.. post your code as well give me a link to your site so I can see what it is doing as well.

Thank you

casper_wang

Reputation Points: 13

Solved Threads: 7

Junior Poster in Training

Offline

67 posts
since Jul 2008

Permalink

Jul 4th, 2008

Re: The page donot load completely untill I refresh the page

Hello All,

The code is as following:

home.php

php Syntax (Toggle Plain Text)
 
<?php
session_start();
?>
 
<?php
if(isset( $_GET['userid'] ))
{
require_once('outlineget.php'); 
// calling another program which also has database connections. This is the one that is //executing after  a REFRESH and which do not execute before using a REFRESH
$userid = $_GET['userid'];
$conn=mysql_connect( ) or die ('I cannot connect to the database because: ' . mysql_error());
 
 
mysql_select_db('db1') or die (mysql_error());
 
$sql = "SELECT * FROM registrations WHERE userid = '$userid'";
$result1 = mysql_query("$sql") or die("Invalid query: " . mysql_error());
$row = mysql_fetch_array( $result1 );
$displayname = $row['displayname'];
$_SESSION['getdisplayname']=$displayname;
 
mysql_select_db('db2') or die (mysql_error());
 
echo '
<html>
<head>
<title>profile</title>
<style type="text/css">
// style code...
</style>
</head>';
 
$sql = "SELECT * FROM usersprofile WHERE displayname = '$displayname'";
$result = mysql_query("$sql") or die("Invalid query: " . mysql_error());
$row = mysql_fetch_array( $result );
$profnamedb = $row['profname'];
 
echo '
<table id=content  border="0" cellspacing="2" cellpadding="2" >';
 echo '<tr ><td align="center"> 
                <span ><font size=4 >'.$row['displayname'].'\'s'.
'<font size=3>&nbsp&nbsp&nbsp Profile</font></span>
	     </td></tr> <br/>';
 
//....table data is displayed ...no problem here
 
if ($educationdb != NULL)
echo '<tr><td><font face="arial">
<div class="signupFormLftcol">Education: </div>
<div class="signupFormRgtcol" >'.$educationdb.'</div></td></tr>';
 
echo '</table>';
mysql_free_result($conn);
mysql_close($conn);
}
 
// end of home.php
<?php
session_start();
?>

<?php
if(isset( $_GET['userid'] ))
{
require_once('outlineget.php'); 
// calling another program which also has database connections. This is the one that is //executing after  a REFRESH and which do not execute before using a REFRESH
$userid = $_GET['userid'];
$conn=mysql_connect( ) or die ('I cannot connect to the database because: ' . mysql_error());


mysql_select_db('db1') or die (mysql_error());

$sql = "SELECT * FROM registrations WHERE userid = '$userid'";
$result1 = mysql_query("$sql") or die("Invalid query: " . mysql_error());
$row = mysql_fetch_array( $result1 );
$displayname = $row['displayname'];
$_SESSION['getdisplayname']=$displayname;

mysql_select_db('db2') or die (mysql_error());

echo '
<html>
<head>
<title>profile</title>
<style type="text/css">
// style code...
</style>
</head>';

$sql = "SELECT * FROM usersprofile WHERE displayname = '$displayname'";
$result = mysql_query("$sql") or die("Invalid query: " . mysql_error());
$row = mysql_fetch_array( $result );
$profnamedb = $row['profname'];

echo '
<table id=content  border="0" cellspacing="2" cellpadding="2" >';
 echo '<tr ><td align="center"> 
                <span ><font size=4 >'.$row['displayname'].'\'s'.
'<font size=3>&nbsp&nbsp&nbsp Profile</font></span>
	     </td></tr> <br/>';
     
//....table data is displayed ...no problem here

if ($educationdb != NULL)
echo '<tr><td><font face="arial">
<div class="signupFormLftcol">Education: </div>
<div class="signupFormRgtcol" >'.$educationdb.'</div></td></tr>';

echo '</table>';
mysql_free_result($conn);
mysql_close($conn);
}

// end of home.php

outlineget.php

php Syntax (Toggle Plain Text)
 
<?php
session_start();
?>
 
<?php
$conn=mysql_connect(".....") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db('db1') or die (mysql_error());
 
$displayname = $_SESSION['getdisplayname'];
$sql = "SELECT profilepic FROM registrations WHERE displayname = '$displayname'";
$result = mysql_query("$sql") or die("Invalid query: " . mysql_error());
$row = mysql_fetch_array( $result );
$profpic = $row['profilepic'];
$_SESSION['profpic'] = $profpic;
 
echo '
<html>
<head>
 
<style type="text/css">
 
 // ...style code...
 
</style>
</head>
 
<body>
 
<table width="99%" border="2" cellpadding="3" cellspacing="0" BGCOLOR=A9A9A9>
<tr><td><font face="Arial" font size="2" align="center"><img src="pic1.gif"></td>
</tr>
<tr><td align="right"><font face="Arial" font size="2"><a href="home.php" class="uline">Home</a>&nbsp|&nbsp<a href="logout.php">Log out</a></td></tr>
</table>
 
<table width=95%>
<tr><td >
<table  width="200" border="1" cellpadding="1" cellspacing="0">
		<tr><td height="25" align="center"  BGCOLOR="A9A9A9"><font face="arial" font size="4">'.$displayname.'</td></tr>
// ... similar table data ...retreiving values from same database,table
</td></tr>
</table>
</body>
</html>
';
mysql_free_result($conn);
mysql_close($conn);
?>
<?php
session_start();
?>

<?php
$conn=mysql_connect(".....") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db('db1') or die (mysql_error());

$displayname = $_SESSION['getdisplayname'];
$sql = "SELECT profilepic FROM registrations WHERE displayname = '$displayname'";
$result = mysql_query("$sql") or die("Invalid query: " . mysql_error());
$row = mysql_fetch_array( $result );
$profpic = $row['profilepic'];
$_SESSION['profpic'] = $profpic;

echo '
<html>
<head>
       
<style type="text/css">

 // ...style code...

</style>
</head>

<body>

<table width="99%" border="2" cellpadding="3" cellspacing="0" BGCOLOR=A9A9A9>
<tr><td><font face="Arial" font size="2" align="center"><img src="pic1.gif"></td>
</tr>
<tr><td align="right"><font face="Arial" font size="2"><a href="home.php" class="uline">Home</a>&nbsp|&nbsp<a href="logout.php">Log out</a></td></tr>
</table>

<table width=95%>
<tr><td >
<table  width="200" border="1" cellpadding="1" cellspacing="0">
		<tr><td height="25" align="center"  BGCOLOR="A9A9A9"><font face="arial" font size="4">'.$displayname.'</td></tr>
// ... similar table data ...retreiving values from same database,table
</td></tr>
</table>
</body>
</html>
';
mysql_free_result($conn);
mysql_close($conn);
?>

This is all what the code is... reduced unnecessary length in the code.

All what happens here is ... am getting exact output only after refreshing the browser... if i do not refresh the browser the either NULL values are old data values will be present in the particular place. The problem is with OUTLINEGET.PHP part.... sometimes html part is getting displayed in it even before hitting the refresh but .. database values do not appear untill we hit refresh.

Any help

will be appreciated.

Thankyou all in advance.

Last edited by Kavitha Butchi; Jul 4th, 2008 at 12:03 pm.

Kavitha Butchi

Reputation Points: 10

Solved Threads: 4

Junior Poster in Training

Offline

69 posts
since May 2008

Permalink

Jul 4th, 2008

Re: The page donot load completely untill I refresh the page

Try this:

home.php

PHP Syntax (Toggle Plain Text)
<?php
require ('config.php');
 
// session_start();
$user->session_begin();
 
if(isset( $_GET['userid'] ))
{
require_once('outlineget.php'); 
// calling another program which also has database connections. This is the one that is //executing after  a REFRESH and which do not execute before using a REFRESH
$userid = $_GET['userid'];
// $conn=mysql_connect( ) or die ('I cannot connect to the database because: ' . mysql_error());
 
mysql_select_db($db1) or die ("Unable to select database!");
 
		$sql = 'SELECT * 
			FROM ' . registrations . "
			WHERE userid = '$userid'";
			$result = $db->sql_query($sql);
				while ($row = $db->sql_fetchrow($result))	
						{
 
$displayname = $row['displayname'];
$db->sql_freeresult($result);
 
$_SESSION['getdisplayname'] = $displayname;
 
mysql_select_db($db2) or die ("Unable to select database!");
 
echo '
<html>
<head>
<title>profile</title>
<style type="text/css">
// style code...
</style>
</head>';
 
		$sql = 'SELECT * 
			FROM ' . usersprofile . "
			WHERE displayname = '$displayname'";
			$result = $db->sql_query($sql);
				while ($row = $db->sql_fetchrow($result))	
						{
$profnamedb = $row['profname'];
$db->sql_freeresult($result);
 
echo '
<table id=content  border="0" cellspacing="2" cellpadding="2" >';
 echo '<tr ><td align="center"> 
                <span ><font size=4 >'.$row['displayname'].'\'s'.
'<font size=3>&nbsp&nbsp&nbsp Profile</font></span>
	     </td></tr> <br/>';
 
//....table data is displayed ...no problem here
 
if ($educationdb != NULL)
echo '<tr><td><font face="arial">
<div class="signupFormLftcol">Education: </div>
<div class="signupFormRgtcol" >'.$educationdb.'</div></td></tr>';
 
echo '</table>';
}
?>
<?php
require ('config.php');

// session_start();
$user->session_begin();

if(isset( $_GET['userid'] ))
{
require_once('outlineget.php'); 
// calling another program which also has database connections. This is the one that is //executing after  a REFRESH and which do not execute before using a REFRESH
$userid = $_GET['userid'];
// $conn=mysql_connect( ) or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db($db1) or die ("Unable to select database!");

		$sql = 'SELECT * 
			FROM ' . registrations . "
			WHERE userid = '$userid'";
			$result = $db->sql_query($sql);
				while ($row = $db->sql_fetchrow($result))	
						{

$displayname = $row['displayname'];
$db->sql_freeresult($result);

$_SESSION['getdisplayname'] = $displayname;

mysql_select_db($db2) or die ("Unable to select database!");

echo '
<html>
<head>
<title>profile</title>
<style type="text/css">
// style code...
</style>
</head>';

		$sql = 'SELECT * 
			FROM ' . usersprofile . "
			WHERE displayname = '$displayname'";
			$result = $db->sql_query($sql);
				while ($row = $db->sql_fetchrow($result))	
						{
$profnamedb = $row['profname'];
$db->sql_freeresult($result);

echo '
<table id=content  border="0" cellspacing="2" cellpadding="2" >';
 echo '<tr ><td align="center"> 
                <span ><font size=4 >'.$row['displayname'].'\'s'.
'<font size=3>&nbsp&nbsp&nbsp Profile</font></span>
	     </td></tr> <br/>';
     
//....table data is displayed ...no problem here

if ($educationdb != NULL)
echo '<tr><td><font face="arial">
<div class="signupFormLftcol">Education: </div>
<div class="signupFormRgtcol" >'.$educationdb.'</div></td></tr>';

echo '</table>';
}
?>

outlineget.php

PHP Syntax (Toggle Plain Text)
<?php
require ('config.php');
 
// $conn=mysql_connect(".....") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db('db1') or die (mysql_error());
 
$displayname = $_SESSION['getdisplayname'];
	$sql = ' SELECT profilepic 
		FROM ' . registrations ."
		WHERE displayname = '$displayname'";
		$result = $db->sql_query($sql);
		while ($row = $db->sql_fetchrow($result))
			{
$profpic = $row['profilepic'];
$_SESSION['profpic'] = $profpic;
 
echo '
<html>
<head>
 
<style type="text/css">
 
 // ...style code...
 
</style>
</head>
 
<body>
 
<table width="99%" border="2" cellpadding="3" cellspacing="0" BGCOLOR=A9A9A9>
<tr><td><font face="Arial" font size="2" align="center"><img src="pic1.gif"></td>
</tr>
<tr><td align="right"><font face="Arial" font size="2"><a href="home.php" class="uline">Home</a>&nbsp|&nbsp<a href="logout.php">Log out</a></td></tr>
</table>
 
<table width=95%>
<tr><td >
<table  width="200" border="1" cellpadding="1" cellspacing="0">
		<tr><td height="25" align="center"  BGCOLOR="A9A9A9"><font face="arial" font size="4">'.$displayname.'</td></tr>
// ... similar table data ...retreiving values from same database,table
</td></tr>
</table>
</body>
</html>
';
?>
<?php
require ('config.php');

// $conn=mysql_connect(".....") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db('db1') or die (mysql_error());

$displayname = $_SESSION['getdisplayname'];
	$sql = ' SELECT profilepic 
		FROM ' . registrations ."
		WHERE displayname = '$displayname'";
		$result = $db->sql_query($sql);
		while ($row = $db->sql_fetchrow($result))
			{
$profpic = $row['profilepic'];
$_SESSION['profpic'] = $profpic;

echo '
<html>
<head>
       
<style type="text/css">

 // ...style code...

</style>
</head>

<body>

<table width="99%" border="2" cellpadding="3" cellspacing="0" BGCOLOR=A9A9A9>
<tr><td><font face="Arial" font size="2" align="center"><img src="pic1.gif"></td>
</tr>
<tr><td align="right"><font face="Arial" font size="2"><a href="home.php" class="uline">Home</a>&nbsp|&nbsp<a href="logout.php">Log out</a></td></tr>
</table>

<table width=95%>
<tr><td >
<table  width="200" border="1" cellpadding="1" cellspacing="0">
		<tr><td height="25" align="center"  BGCOLOR="A9A9A9"><font face="arial" font size="4">'.$displayname.'</td></tr>
// ... similar table data ...retreiving values from same database,table
</td></tr>
</table>
</body>
</html>
';
?>

create new php:
config.php

PHP Syntax (Toggle Plain Text)
<?php
// set database server access variables: 
$host = "host_name"; 
$user = "user_name";  		//change this ti your user name
$pass = "user_password"; 	// change this to your database password
$db1 = "database_name"; 	// change tyhis to your database1 name
$db2 = "database_name"; 	// change tyhis to your database2 name
 
// open connection 
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 
 
// select database 
 
?>
<?php
// set database server access variables: 
$host = "host_name"; 
$user = "user_name";  		//change this ti your user name
$pass = "user_password"; 	// change this to your database password
$db1 = "database_name"; 	// change tyhis to your database1 name
$db2 = "database_name"; 	// change tyhis to your database2 name

// open connection 
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 

// select database 

?>

If still having problems let me know.

Last edited by casper_wang; Jul 4th, 2008 at 9:50 pm.

casper_wang

Reputation Points: 13

Solved Threads: 7

Junior Poster in Training

Offline

67 posts
since Jul 2008

Permalink

Jul 5th, 2008

Re: The page donot load completely untill I refresh the page

Well, Thats because, $_SESSION['getdisplayname']=$displayname; is being set after you include/require outlineget.php . That is, $_SESSION['getdisplayname'] is empty on the first run. So, outlineget.php will not display anything.

Quote ...

$conn=mysql_connect(".....") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db('db1') or die (mysql_error());

$displayname = $_SESSION['getdisplayname'];

$displayname is null here. The solution is to make sure $_SESSION['getdisplayname'] has a value before you include outlineget.php.

I hope its pretty clear. Eh ?

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Jul 5th, 2008

Re: The page donot load completely untill I refresh the page

yep he is correct. try this code, must have been very tired last night when I played with this.

home.php

PHP Syntax (Toggle Plain Text)
<?php
require ('config.php');
 
// session_start();
$user->session_begin();
 
if(isset( $_GET['userid'] ))
{
$userid = $_GET['userid'];
 
mysql_select_db($db1) or die ("Unable to select database!");
		$sql = 'SELECT * 
			FROM ' . registrations . "
			WHERE userid = '$userid'";
			$result = $db->sql_query($sql);
				while ($row = $db->sql_fetchrow($result))	
						{
$displayname = $row['displayname'];
$db->sql_freeresult($result);
 
$_SESSION['getdisplayname'] = $displayname;
 
require ('outlineget.php'); 
 
mysql_select_db($db2) or die ("Unable to select database!");
 
echo '
<html>
<head>
<title>profile</title>
<style type="text/css">
// style code...
</style>
</head>';
 
		$sql = 'SELECT * 
			FROM ' . usersprofile . "
			WHERE displayname = '$displayname'";
			$result = $db->sql_query($sql);
				while ($row = $db->sql_fetchrow($result))	
						{
$profnamedb = $row['profname'];
$db->sql_freeresult($result);
 
echo '
<table id=content  border="0" cellspacing="2" cellpadding="2" >';
 echo '<tr ><td align="center"> 
                <span ><font size=4 >'.$row['displayname'].'\'s'.
'<font size=3>&nbsp&nbsp&nbsp Profile</font></span>
	     </td></tr> <br/>';
 
//....table data is displayed ...no problem here
 
if ($educationdb != NULL)
echo '<tr><td><font face="arial">
<div class="signupFormLftcol">Education: </div>
<div class="signupFormRgtcol" >'.$educationdb.'</div></td></tr>';
 
echo '</table>';
}
?>
<?php
require ('config.php');

// session_start();
$user->session_begin();

if(isset( $_GET['userid'] ))
{
$userid = $_GET['userid'];

mysql_select_db($db1) or die ("Unable to select database!");
		$sql = 'SELECT * 
			FROM ' . registrations . "
			WHERE userid = '$userid'";
			$result = $db->sql_query($sql);
				while ($row = $db->sql_fetchrow($result))	
						{
$displayname = $row['displayname'];
$db->sql_freeresult($result);

$_SESSION['getdisplayname'] = $displayname;

require ('outlineget.php'); 

mysql_select_db($db2) or die ("Unable to select database!");

echo '
<html>
<head>
<title>profile</title>
<style type="text/css">
// style code...
</style>
</head>';

		$sql = 'SELECT * 
			FROM ' . usersprofile . "
			WHERE displayname = '$displayname'";
			$result = $db->sql_query($sql);
				while ($row = $db->sql_fetchrow($result))	
						{
$profnamedb = $row['profname'];
$db->sql_freeresult($result);

echo '
<table id=content  border="0" cellspacing="2" cellpadding="2" >';
 echo '<tr ><td align="center"> 
                <span ><font size=4 >'.$row['displayname'].'\'s'.
'<font size=3>&nbsp&nbsp&nbsp Profile</font></span>
	     </td></tr> <br/>';
     
//....table data is displayed ...no problem here

if ($educationdb != NULL)
echo '<tr><td><font face="arial">
<div class="signupFormLftcol">Education: </div>
<div class="signupFormRgtcol" >'.$educationdb.'</div></td></tr>';

echo '</table>';
}
?>

outlineget.php

PHP Syntax (Toggle Plain Text)
<?php
require ('config.php');
 
mysql_select_db('db1') or die (mysql_error());
	$sql = ' SELECT profilepic 
		FROM ' . registrations ."
		WHERE displayname = '$displayname'";
		$result = $db->sql_query($sql);
		while ($row = $db->sql_fetchrow($result))
			{
$profpic = $row['profilepic'];
$_SESSION['profpic'] = $profpic;
 
echo '
<html>
<head>
 
<style type="text/css">
 
 // ...style code...
 
</style>
</head>
 
<body>
 
<table width="99%" border="2" cellpadding="3" cellspacing="0" BGCOLOR=A9A9A9>
<tr><td><font face="Arial" font size="2" align="center"><img src="pic1.gif"></td>
</tr>
<tr><td align="right"><font face="Arial" font size="2"><a href="home.php" class="uline">Home</a>&nbsp|&nbsp<a href="logout.php">Log out</a></td></tr>
</table>
 
<table width=95%>
<tr><td >
<table  width="200" border="1" cellpadding="1" cellspacing="0">
		<tr><td height="25" align="center"  BGCOLOR="A9A9A9"><font face="arial" font size="4">'.$displayname.'</td></tr>
// ... similar table data ...retreiving values from same database,table
</td></tr>
</table>
</body>
</html>
';
?>
<?php
require ('config.php');

mysql_select_db('db1') or die (mysql_error());
	$sql = ' SELECT profilepic 
		FROM ' . registrations ."
		WHERE displayname = '$displayname'";
		$result = $db->sql_query($sql);
		while ($row = $db->sql_fetchrow($result))
			{
$profpic = $row['profilepic'];
$_SESSION['profpic'] = $profpic;

echo '
<html>
<head>
       
<style type="text/css">

 // ...style code...

</style>
</head>

<body>

<table width="99%" border="2" cellpadding="3" cellspacing="0" BGCOLOR=A9A9A9>
<tr><td><font face="Arial" font size="2" align="center"><img src="pic1.gif"></td>
</tr>
<tr><td align="right"><font face="Arial" font size="2"><a href="home.php" class="uline">Home</a>&nbsp|&nbsp<a href="logout.php">Log out</a></td></tr>
</table>

<table width=95%>
<tr><td >
<table  width="200" border="1" cellpadding="1" cellspacing="0">
		<tr><td height="25" align="center"  BGCOLOR="A9A9A9"><font face="arial" font size="4">'.$displayname.'</td></tr>
// ... similar table data ...retreiving values from same database,table
</td></tr>
</table>
</body>
</html>
';
?>

create new php:
config.php

PHP Syntax (Toggle Plain Text)
<?php
// set database server access variables: 
$host = "host_name"; 
$user = "user_name";  		//change this ti your user name
$pass = "user_password"; 	// change this to your database password
$db1 = "database_name"; 	// change tyhis to your database1 name
$db2 = "database_name"; 	// change tyhis to your database2 name
 
// open connection 
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 
 
// select database 
 
?>
<?php
// set database server access variables: 
$host = "host_name"; 
$user = "user_name";  		//change this ti your user name
$pass = "user_password"; 	// change this to your database password
$db1 = "database_name"; 	// change tyhis to your database1 name
$db2 = "database_name"; 	// change tyhis to your database2 name

// open connection 
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 

// select database 

?>

casper_wang

Reputation Points: 13

Solved Threads: 7

Junior Poster in Training

Offline

67 posts
since Jul 2008

Page 1
2
Next

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: how to insert a message board?

Next Thread in PHP Forum Timeline: PHP Paging and Page Number Nav

DaniWeb Message

Cancel Changes

User Name
Password