PHP - Moved: Training Php - What Mysql Program/server?

<?php
//this is the isset function which allows us to submit back
//to the same form.  If there isn't anything in the ISBN, it will
//show the bottom part of the form
if(isset($_POST["ISBN"])|| empty($_POST['isbn_type']) 
	|| empty($_POST['Valid_Invalid']))
{
	$ISBN = $_POST["ISBN"];;
	$IsbnType = $_POST["isbn_type"];;
	$VaorIn = $_POST["Valid_Invalid"];;

	$ISBN_Arr = str_split($ISBN);
	$not10 =0;
	$notNum=0;
	$notX=0;
	//entering error checking for the code
	//check for 10 first, if clear do additional checking
	if(strlen($ISBN) == 10)
		{//start further error checking	
		//check to make sure first 9 are numeric
		for($i=0;$i<=8;$i++)
			{
			if(!is_numeric($ISBN_Arr[$i]))
				$notNum = 1;
			}//end for loop check
		//check to see if there is a X or a x
		if($ISBN_Arr[9]=='x' || $ISBN_Arr[9]=='X')
			{
				$ISBN_Arr[9] = 10;
			}
			//if not an x, is it at least numeric?
			else if (!is_numeric($ISBN_Arr[9]) )
			{
				$notX=1;
			}
		}//end additional error checking 
		else {
			$not10=1;	
			}//end not 10 check
	//start of error messages if prereqs are not met			
	if($notNum ==1 || $notX ==1 || $not10)
		{
		Print "<h2>Input error</h2><br/>";
		Print "Here is the error(s) discovered:<br/>";
		if($notNum ==1)
			print"Your ISBN contains non-numeric data.<br/>";
		if($notX ==1)
			print"The last digit is not a number or a X.<br/>";
		if($not10 ==1)
			print"ISBN 10 number should contain 10 characters.<br/>";
				
		include"ISBN_not_val_include.html";
		}
	//end error checking
	else{
		$chk_sum_num=10;
		$chk_sum =0;
		for($i=0;$i<=9;$i++)
		{
			$chk_sum +=$ISBN_Arr[$i] *$chk_sum_num;
				//print"$ISBN_Arr[$i] | $chk_sum_num<br/>";
			$chk_sum_num--;
		}//end for loop
		$is_valid_ISBN= $chk_sum%11;
		//print"chk_sum: $chk_sum </br> is_valid_ISBN: $is_valid_ISBN</br>";
		if($is_valid_ISBN==0)
			{
			print"<h3>VALID</h3><br/>";
			print"$ISBN is a VALID 10 digit ISBN number.<br/>";
			include"ISBN_val_include.html";
			}
			else{
			print"<h3>INVALID</h3><br/>";
			print"$ISBN is an INVALID 10 number ISBN.<br/>";
			include"ISBN_not_val_include.html";
			}//end is_valid if
		}//end
	}//end is set if
	else{
	include"ISBN_val_include.html";
}//end isset else
?>


</form>
<p><a href="_ShowISBN10and13DBProject.php">Show ISBN 
</a></p> 


</body>
</html>

<?php

if (empty($_POST['ISBN'])|| empty($_POST['isbn_type']) 
	|| empty($_POST['Valid_Invalid']))
	
	echo "<p>You must enter a Valid ISBN 10 to Continue! 
		 Please Click your browser's Back Button to return 
		 to the input page of ISBN 10 with Database.</p>\n";
		 
else {
	$DBConnect = @mysql_connect("xxx.xxx.xx.xxx", "xxxxxxxx", "xxxxxxxx");
	if($DBConnect === false)
		echo"<p>Unable to conenct to the database server.</p>"
		. "<p>Error code " . mysql_errno()
		. ": " . mysql_error() . "</p>";
	else{
	$DBName = "xxxxxxxx";
	if (!@mysql_select_db($DBName, $DBConnect)) {
		$SQLstring = "CREATE DATABASE $DBName";
		$QueryResult = @mysql_query($SQLstring,
		$DBConnect);
		
		if ($QueryResult === FALSE)
		echo "<p>Unable to execute the query.</p>"
		. "<p>Error code " . mysql_errno($DBConnect)
		. ": " . mysql_error($DBConnect) . "</p>";
	else 
		echo "<p>You are the first visitor!</p>";
	}
	mysql_select_db($DBName, $DBConnect);
	
	$TableName = "isbn";
	$SQLstring = "SHOW TABLES LIKE '$TableName'";
	$QueryResult = @mysql_query($SQLstring, $DBConnect);
	
	
	
	if ($QueryResult === FALSE) 
		echo "<p>Unable to create the table.</p>"
		. "<p>Error code " . mysql_errno($DBConnect)
		. ": " . mysql_error($DBConnect) . "</p>";
		
	$ISBNum = stripslashes($_POST['ISBN']);
	$ISBNType = stripslashes($_POST['isbn_type']);
	$VaORIn = stripslashes($_POST['Valid_Invalid']);
	$SQLstring = "INSERT INTO $TableName 
	VALUES(NULL, '$ISBNum', '$ISBNType', 
	'$VaORIn')";
	$QueryResult = @mysql_query($SQLstring, $DBConnect);
		
		if($QueryResult === false)
			echo"<p>Unable to execute the query.</p>"
			. "<p>Error code " . mysql_errno($DBConnect)
			. ": " . mysql_error($DBConnect) . "</p>";
		else
			echo"<h1>Thank you for trying our ISBN 10 program!</h1>";	
	
	
	mysql_close($DBConnect);
	}
}
	
	


?><!--End PHP Script-->

<?php

	$DBConnect = @mysql_connect("xxx.xxx.xx.xxx", "xxxxxxx", "xxxxx");
	if($DBConnect === false)
		echo"<p>Unable to conenct to the database server.</p>"
		. "<p>Error code " . mysql_errno()
		. ": " . mysql_error() . "</p>";
	else{
		$DBName = "xxxxxx";
	if (!@mysql_select_db($DBName, $DBConnect))
		echo"<p>There are no entries in the guest book!</p>";
	else {
	$TableName = "isbn";
	$SQLstring = "SELECT * FROM $TableName";
	$QueryResult = @mysql_query($SQLstring, $DBConnect);
	
	if (mysql_num_rows($QueryResult) == 0) 
		echo"<p>There are no entries in the ISBN 10 Database!</p>";
	else{
		echo"<p>The following ISBN have 
		been recorded:</p>";
		echo"<table width='100%' border='1'>";
		echo"<tr><th>ISBN Number</th><th>ISBN Type</th><th>
			Date Entred</th><th>
			Valid OR Invalid</th></tr>";
		while (($Row = mysql_fetch_assoc($QueryResult)) !==FALSE) {
			echo "<tr><td>{$Row['ISBN']}</td>";
			echo "<tr><td>{$Row['isbn_type']}</td>";
			echo "<tr><td>{$Row['TIMESTAMP']}</td>";
			echo "<td>{$Row['Valid_Invalid']}</td></tr>";
			
			}
			
		}
		mysql_free_result($QueryResult);
	}
	mysql_close($DBConnect);
}
	
		

	public function getColumnNames($table){
		$sql = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = :table";
		try {
			$stmt = $this->dbh->prepare($sql);
			$stmt->bindValue(':table', $table, PDO::PARAM_STR);
			$stmt->execute();
			$output = array();
				while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
				$output[] = $row['COLUMN_NAME'];                
			}
			
			$all = array($output);
			
			$a1 = array_slice($output, 1); // I don't want column 1, it contains the ID, its auto incremented.
			$a2 = array_slice($a1, 0, -3); // I don't want the last 3 columns as they have default values
			
			$selected = array($a2);  // contains all the columns except those excluded by array_slice, columns now match all of the input fields on the form
			
			foreach ($selected as $row){
					$fields = "`" . implode('`, `', $row) . "`"; // I'm making `fields` here,
					$bind = ":" . implode(', :', $row);	// And making :values here			
					}	
			return array (
					"raw" 	        => $all,
					"fields" 	=> $fields,
					"bind"		=> $bind
				     );
			}
			catch(PDOException $pe) {
			    trigger_error('Could not connect to MySQL database. ' . $pe->getMessage() , E_USER_ERROR);
			}
	}
	
	public function addRecord(){
		$col = array();
		$col = $this->getColumnNames("table");
		$raw = array($col['raw']);
		$fields = array($col['fields']);
		$bind = array($col['bind']);
		$columnList = implode('`, `', $fields);
		$paramList = implode(', ', $bind); 
		
		$sql = "INSERT INTO `{$this->dbtable}` ($columnList) VALUES ($paramList)";
		
		return $sql; // this returns something like:
INSERT INTO `table` (`field1`, `field2`, `field3`) VALUES (:field1, :field2, :field3)";

For example with an IDE to run a program is there a way to put some code in the path and let it tell me where it came from like a referral?
For example lets say I am at pgm1.php and at the top of that program i put something like.

$ref = $_SERVER['HTTP_REFERER'];
echo("$ref<br>";

Result: https://www.mydomain.com/wp-admin/admin.php?page=lambo

As you can clearly see the page that we have entered the code in is referred by the URL here.

It tells me that it was last at a word press page /wp-admin/admin-php and I can go to that page and it will be the last page it was at..

So bottom line then if i add this code to the admin page and click the same button i had before.. it will tell me the file that called out the admin page.

Baslcaly I am looking for ideas on how to track the page i am now all the way back to the page with the button on it and all intermediate pages that it passes thru to get to the final destination.  It seems that to succesfully troubleshoot a fault is to follow the path of the entire job and see if any breaks...

Any thoughts or suggestions on how to best do this would greatly be appreciated.