countrysql.php | searchcode

/booking/reservations/countrysql.php

https://bitbucket.org/anneivycat/california-tour · PHP · 452 lines · 303 code · 108 blank · 41 comment · 36 complexity · 3348b48f73763565495966f20a6e1feb MD5 · raw file

<?


/* SQL specific functions call for users.php */

	// connect to server
	include ("../sqlfuncs.php");

	// open a connection to mysql

	$mysql_link = connect_to_db();
	$mysql_result = select_db($mysql_link);

	// get current database size

	$query = "SELECT * FROM COUNTRY ORDER BY COUNTRY_DESC ASC";

	$mysql_result = mysql_query($query, $mysql_link);

	$totalnumrows = mysql_num_rows($mysql_result);

	if ($totalnumrows > 0)
	{
		if ($totalnumrows == 1)
		{
			$ResultString = "<b><font color='blue'>Database has </font><font color='red'> $totalnumrows </font><font color='blue'> record</font></b>";
		}
		else
		{
			$ResultString = "<b><font color='blue'>Database has </font><font color='red'> $totalnumrows </font><font color='blue'> records</font></b>";
		}
	}
	else
	{
		$ResultString = "<b><font color='red'>Database has no records</font></b>";
	}



// check which key was pressed
if ($DelUser)
{

//	print("Key Pressed=$DelUser");

	$query = "SELECT * FROM COUNTRY WHERE COUNTRY_DESC = '$CountryDesc' ORDER BY COUNTRY_ID ASC";
	$mysql_result = mysql_query($query, $mysql_link);

	$numrows = mysql_num_rows($mysql_result);

	if ($numrows > 0)
	{
		$row = mysql_fetch_array($mysql_result);
		// get row result
		$CountryId = $row[0];
	}

// delete current record from db

	$query = "DELETE FROM COUNTRY WHERE COUNTRY_ID = '$CountryId'";

	// print($query);
	$mysql_result = mysql_query($query, $mysql_link);

// get current database size

	$query = "SELECT * FROM COUNTRY";

	$mysql_result = mysql_query($query, $mysql_link);

	$totalnumrows = mysql_num_rows($mysql_result);

	$ResultString = "<b><font color='blue'>Database has </font><font color='red'>$totalnumrows</font><font color='blue'> records</font></b>";

// then display the next record in the database, if not zero

	$query = "SELECT * FROM COUNTRY WHERE COUNTRY_DESC > '$CountryDesc' ORDER BY COUNTRY_DESC ASC";

	$mysql_result = mysql_query($query, $mysql_link);

	$numrows = mysql_num_rows($mysql_result);

	if ($numrows > 0)
	{
		$row = mysql_fetch_array($mysql_result);
		$CountryId = $row[0];
		$CountryCode = strtoupper($row[1]);
		$CountryDesc = strtoupper($row[2]);
		$TimeStamp = $row[3];
	}
	else
	{
	// display the previous record if not zero

		$query = "SELECT * FROM COUNTRY WHERE COUNTRY_DESC < '$CountryDesc' ORDER BY COUNTRY_DESC ASC";

		$mysql_result = mysql_query($query, $mysql_link);

		$numrows = mysql_num_rows($mysql_result);

		if ($numrows > 0)
		{
			while ($row = mysql_fetch_array($mysql_result))
			{
				// get row result
				$CountryId = $row[0];
				$CountryCode = strtoupper($row[1]);
				$CountryDesc = strtoupper($row[2]);
				$TimeStamp = $row[3];
			}

			// get current database size
			$query = "SELECT * FROM COUNTRY";
			$mysql_result = mysql_query($query, $mysql_link);
			$totalrows = mysql_num_rows($mysql_result);
			if ($totalrows == 1)
			{
				$ResultString = "<b><font color='blue'>Database has</font><font color='red'> $totalrows </font><font color='blue'>record.</font></b>";
			}
			else
			{
				$ResultString = "<b><font color='blue'>Database has</font><font color='red'> $totalrows </font><font color='blue'>records.</font></b>";
			}
		}
		else
		{
			$ResultString = "<b><font color='red'>Database has no records</font></b>";

			// database is empty
			$CountryId 		= "";
			$CountryDesc 	= "";
			$CountryCode 	= "";
			$TimeStamp 			= "";
		}
	}

}

if ($AddUser)
{
// check if user name exists, if not create record
// if it exists, populate the fields with the current values
// for the record


	$query = "SELECT * FROM COUNTRY WHERE COUNTRY_DESC = '$CountryDesc' ORDER BY COUNTRY_DESC ASC";

	$mysql_result = mysql_query($query, $mysql_link);

	$numrows = mysql_num_rows($mysql_result);

	if ($numrows > 0)
	{
		$row = mysql_fetch_array($mysql_result);
		$CountryId = $row[0];
		$CountryCode = strtoupper($row[1]);
		$CountryDesc = strtoupper($row[2]);
		$TimeStamp = $row[3];
	}
	else
	{


		$CountryId = 1;

// get first unused user id

		$query = "SELECT * FROM COUNTRY ORDER BY COUNTRY_ID ASC";
		$mysql_result = mysql_query($query, $mysql_link);
		$newnumrows = mysql_num_rows($mysql_result);

		if ($newnumrows > 0)
		{
			$CountryId = $newnumrows + 1;
		}
	}

	$current_time = getdate(time());
	$current_hours = $current_time["hours"];
	$current_mins = $current_time["minutes"];
	$current_secs = $current_time["seconds"];
	$current_date = date("Y-m-d");

	$TimeStamp = sprintf("%s %d:%d:%d",$current_date,$current_hours,$current_mins,$current_secs);


	$CountryDesc = strtoupper($CountryDesc);

	$query = "INSERT INTO COUNTRY (COUNTRY_ID,COUNTRY_CODE,COUNTRY_DESC,COUNTRY_TIMESTAMP) VALUES ('$CountryId', '$CountryCode', '$CountryDesc','$TimeStamp')";
			// print($query);

	$mysql_result = mysql_query($query, $mysql_link);

	// print($mysql_result);

	// get current database size
	$query = "SELECT * FROM COUNTRY";
	$mysql_result = mysql_query($query, $mysql_link);
	$totalrows = mysql_num_rows($mysql_result);
	if ($totalrows == 1)
	{
		$ResultString = "<b><font color='blue'>Database has</font><font color='red'> $totalrows </font><font color='blue'>record.</font></b>";
	}
	else
	{
		$ResultString = "<b><font color='blue'>Database has</font><font color='red'> $totalrows </font><font color='blue'>records.</font></b>";
	}

//	print("Key Pressed=$AddUser");
}

if ($PrevUser)
{
	$query = "SELECT * FROM COUNTRY WHERE COUNTRY_DESC < '$CountryDesc' ORDER BY COUNTRY_DESC ASC";

	$mysql_result = mysql_query($query, $mysql_link);

	$numrows = mysql_num_rows($mysql_result);

	if ($numrows > 0)
	{
		while ($row = mysql_fetch_array($mysql_result))
		{
			// get row result
			$CountryId = $row[0];
			$CountryCode = strtoupper($row[1]);
			$CountryDesc = strtoupper($row[2]);
			$TimeStamp = $row[3];
		}
	}
	else
	{
		$query = "SELECT * FROM COUNTRY WHERE COUNTRY_DESC = '$CountryDesc' ORDER BY COUNTRY_DESC ASC";

		$mysql_result = mysql_query($query, $mysql_link);

		$numrows = mysql_num_rows($mysql_result);

		if ($numrows > 0)
		{
			$row = mysql_fetch_array($mysql_result);
			// get row result
			$CountryId = $row[0];
			$CountryCode = strtoupper($row[1]);
			$CountryDesc = strtoupper($row[2]);
			$TimeStamp = $row[3];

			$ResultString = "<b><font color='red'>First Record</font></font></b><br>";

			// get current database size
			$query = "SELECT * FROM COUNTRY";
			$mysql_result = mysql_query($query, $mysql_link);
			$totalrows = mysql_num_rows($mysql_result);
			if ($totalrows == 1)
			{
				$ResultString2 = "<b><font color='blue'>Database has</font><font color='red'> $totalrows </font><font color='blue'>record.</font></b>";
			}
			else
			{
				$ResultString2 = "<b><font color='blue'>Database has</font><font color='red'> $totalrows </font><font color='blue'>records.</font></b>";
			}

		}
		else
		{
			$ResultString = "<b><font color='red'>Database has no records</font></b>";
		}
	}

//	print("Key Pressed=$PrevUser");
}
if ($LastUser)
{
	$query = "SELECT * FROM COUNTRY ORDER BY COUNTRY_DESC DESC";

	$mysql_result = mysql_query($query, $mysql_link);

	$numrows = mysql_num_rows($mysql_result);

	if ($numrows > 0)
	{
			$row = mysql_fetch_array($mysql_result);
			// get row result
			$CountryId = $row[0];
			$CountryCode = strtoupper($row[1]);
			$CountryDesc = strtoupper($row[2]);
			$TimeStamp = $row[3];
			$ResultString = "<b><font color='red'>Last Record</font></font></b><br>";

			// get current database size
			$query = "SELECT * FROM COUNTRY";
			$mysql_result = mysql_query($query, $mysql_link);
			$totalrows = mysql_num_rows($mysql_result);
			if ($totalrows == 1)
			{
				$ResultString2 = "<b><font color='blue'>Database has</font><font color='red'> $totalrows </font><font color='blue'>record.</font></b>";
			}
			else
			{
				$ResultString2 = "<b><font color='blue'>Database has</font><font color='red'> $totalrows <font color='blue'>records.</font></b>";

			}

	}
	else
	{
			$ResultString = "<b><font color='red'>Database has no records</font></b>";
	}

//	print("Key Pressed=$LastUser");
}


if ($ChgUser)
{

	$query = "SELECT * FROM COUNTRY WHERE COUNTRY_ID = '$CountryId'";
	$mysql_result = mysql_query($query, $mysql_link);

	$numrows = mysql_num_rows($mysql_result);

	if ($numrows > 0)
	{
			//print("Changing record..\n");

			$row = mysql_fetch_array($mysql_result);
			// get row result
			$CountryId = $row[0];

			$query = "DELETE FROM COUNTRY WHERE COUNTRY_ID = '$CountryId'";
			$mysql_result = mysql_query($query, $mysql_link);

			$current_time = getdate(time());
			$current_hours = $current_time["hours"];
			$current_mins = $current_time["minutes"];
			$current_secs = $current_time["seconds"];
			$current_date = date("Y-m-d");

			$TimeStamp = sprintf("%s %d:%d:%d",$current_date,$current_hours,$current_mins,$current_secs);

			$CountryDesc = strtoupper($CountryDesc);

			$query = "INSERT INTO COUNTRY (COUNTRY_ID,COUNTRY_CODE,COUNTRY_DESC,COUNTRY_TIMESTAMP) VALUES ('$CountryId', '$CountryCode', '$CountryDesc','$TimeStamp')";
			// print($query);

			$mysql_result = mysql_query($query, $mysql_link);
	}

//	print("Key Pressed=$ChgUser");
}

if ($NextUser)
{
	$query = "SELECT * FROM COUNTRY WHERE COUNTRY_DESC > '$CountryDesc' ORDER BY COUNTRY_DESC ASC";

	$mysql_result = mysql_query($query, $mysql_link);

	$numrows = mysql_num_rows($mysql_result);

	if ($numrows > 0)
	{
		$row = mysql_fetch_array($mysql_result);
		// get row result
			$CountryId = $row[0];
			$CountryCode = strtoupper($row[1]);
			$CountryDesc = strtoupper($row[2]);
			$TimeStamp = $row[3];
	}
	else
	{
		$query = "SELECT * FROM COUNTRY WHERE COUNTRY_DESC = '$CountryDesc'";

		$mysql_result = mysql_query($query, $mysql_link);

		$numrows = mysql_num_rows($mysql_result);

		if ($numrows > 0)
		{
			$row = mysql_fetch_array($mysql_result);
			// get row result
			$CountryId = $row[0];
			$CountryCode = strtoupper($row[1]);
			$CountryDesc = strtoupper($row[2]);
			$TimeStamp = $row[3];
			$ResultString = "<b><font color='red'>Last Record</font></font></b><br>";
			// get current database size
			$query = "SELECT * FROM COUNTRY";
			$mysql_result = mysql_query($query, $mysql_link);
			$totalrows = mysql_num_rows($mysql_result);
			if ($totalrows == 1)
			{
				$ResultString2 = "<b><font color='blue'>Database has</font><font color='red'> $totalrows </font><font color='blue'>record.</font></b>";
			}
			else
			{
				$ResultString2 = "<b><font color='blue'>Database has</font><font color='red'> $totalrows </font><font color='blue'>records.</font></b>";
			}

		}
		else
		{
			$ResultString = "<b><font color='red'>Database has no records</font></b>";
		}
	}

//	print("Key Pressed=$NextUser");
}

if ($FirstUser)
{

// print("Key Pressed=$FirstUser");

	$query = "SELECT * FROM COUNTRY ORDER BY COUNTRY_DESC ASC";

	$mysql_result = mysql_query($query, $mysql_link);

	$numrows = mysql_num_rows($mysql_result);

	if ($numrows > 0)
	{
			$row = mysql_fetch_array($mysql_result);
			// get row result
			$CountryId = $row[0];
			$CountryCode = strtoupper($row[1]);
			$CountryDesc = strtoupper($row[2]);
			$TimeStamp = $row[3];
			$ResultString = "<b><font color='red'>First Record</font></font></b><br>";
			// get current database size
			$query = "SELECT * FROM COUNTRY";
			$mysql_result = mysql_query($query, $mysql_link);
			$totalrows = mysql_num_rows($mysql_result);
			if ($totalrows == 1)
			{
				$ResultString2 = "<b><font color='blue'>Database has</font><font color='red'> $totalrows </font><font color='blue'>record.</font></b>";
			}
			else
			{
				$ResultString2 = "<b><font color='blue'>Database has</font><font color='red'> $totalrows </font><font color='blue'>records.</font></b>";
			}

	}
	else
	{
			$ResultString = "<b><font color='red'>Database has no records</font></b>";
	}
}


?>
Alerts (11)

'mysql_fetch_array(' Deprecated mysql_* functions; use PDO or MySQLi for modern database access
53 85 103 154 222 241 282 326 362 379 422