DB Connection Status

SOL-ion

Hi all,

I have a script that for some strange reason will not hold a connection at a particular part of the code??? I am storing the db connection in a variable e.g:

$db_con = mysql_connect ( "127.0.0.1", "user", "p");

How can I check if this variable is still holding a valid connection? Echoing states the resource id, which is the same throughout. I am sorry if this is all very vague, but I really do not understand the problem to be honest.

Cheers

SOL

parawizard

if that is ur real name and password u might want tto edit them out and also post all ur code 🙂 or at least to the part the connection doesnt work

SOL-ion

lol no its not my username and password. Right this is a cut down version of the code; it uses a lot of included functions.

<?php
get_source_page ("CSM.php"); 

$db_connection = mysql_connect ();
switch ($_SESSION['referer']) {
	case "CSM.php": 
		$first_execution = ums_setup($db_connection);
		if ( $_GET['install'] == "reinstall" ) { $reinstall = true; } 
		else { $reinstall = false; }
		if ( ( $first_execution ) || ( $reinstall ) ) {
			// IF IT IS FROM REINSTALL MUST CHECK FOR ADMIN LOGIN
			display_welcome_first_time ();
			// Will have to delete the db first for the reinstall.			
			if ( $reinstall ) {
				mysql_dropdb ("ums", $db_connection); 
			}
			// THIS WORKS
			create_ums_tables ($db_connection);			
			display_register_form ("ums02", $db_connection);
		} else {
			// This is not an install situation, it is a management one.
			?>
			<p>Welcome to the CSM: Site install detected.</p>
			<p>Click this link to <a href="CSM.php?install=reinstall">reinstall</a></p>
			<?php
		}
		break;
	case "ums_exe_register.php":
		echo "Your admin account is now registered and you are logged in.";

	if ( $_GET['install'] == "yes" ) {
		// Needs to create assett item first.

		// check that admin is logged in.
				// See if usertype exists in table


	//****** PROBLEM IS HERE - Will not do even that simple INSERT.		

	echo "<p><b>It is: ".$db_connection."</b></p>";
	$sql = "INSERT INTO ums_error VALUES ('ums10','test','Test')";
	echo $sql;
	$result = query_database ($sql, $db_connection);
	// create the site itself's pages.
		create_site ($db_connection);
	} else {
		echo "Not sure whats going on yet";
	}
	break;
}  // switch
echo "connection closed";
close_db_connection ($db_connection); // in database_interface.inc.php
?>