FSD - учим php/sql

Код AS3:

public function getExternalData(url:String , var1:String , var2:String , var3:String ):void
{
_variables = new URLVariables();
_variables["var1"] = var1;
_variables["var2"] = var2;
_variables["var3"] = var3;
 
const req:URLRequest = new URLRequest(url);
req.method = URLRequestMethod.POST;
req.data = _variables;
 
_dbLoader.dataFormat = URLLoaderDataFormat.TEXT;
_dbLoader.addEventListener(Event.COMPLETE, onGetExternalData);
_dbLoader.load(req);
}

Код AS3:

_connector.getExternalData('someUrl.php' , 1 , 'hello' , 'world');

<?php
$var1 = $_POST['var1'];
$var2 = $_POST['var2'];
$var3 = $_POST['var3'];
echo $var1 . "/" . $var2 . "/" . $var3 ;
?>

1/hello/world

<?php
if( isset($_POST['var1'] , $_POST['var2'] , $_POST['var3'])) {
$var1 = $_POST['var1'];
$var2 = $_POST['var2'];
$var3 = $_POST['var3'];
echo $var1 . "/" . $var2 . "/" . $var3 ;
}
else echo 'PHP : no post params';
?>

session1.php
<?php
start_session(); // открыли сессию
$_SESSION['key'] = 123456789;
?>

session2.php
<?php
start_session();
echo $_SESSION['key']; // 123456789;
unset($_SESSION["key"]); // убили переменную
session_destroy();  //убили сессию
?>

<?php
	  
                # author : in4core lab
	
                final class DBConnector {
		
		private $link;
		private $results;
		
		public function DBConnector() { }
		
		public function connect_once( $db, $user, $password )
		{
			$this->link = mysql_connect( "localhost", $user , $password );
			
			if (!$this->link) echo "Could not connect: " . mysql_error();
			
			mysql_select_db( $db , $this->link);
		}
		
		public function selectAllFromTable($tableName)
		{
			$query = "SELECT * FROM $tableName";
	
			$this->results = mysql_query($query);
	
			if (!$this->results) echo 'no results : ' . mysql_error();
			
			return $this->results;
		}
		
		public function getEchoFromSelectedTable()
		{
			if ($this->results)
			{	
				echo "Table results\n";
				
				while ($line = mysql_fetch_assoc($this->results) ) 
				{
					print_r ($line);
				}
			}
			else 
			{
				echo "Operation not available";
			}
		}
		
		public function close()
		{
			if($this->link) mysql_close($this->link);
		}
		
		public function insertIntoTable($tableName , $values , $names = NULL )
		{
			if ($names) 
			{
				mysql_query("INSERT INTO $tableName ($names) VALUES ($values)") or die( mysql_error() );
			}
			else 
			{	
				mysql_query("INSERT INTO $tableName VALUES ($values)") or die( mysql_error() );
			}
		}
		
		public function findThis( $arr , $table ) 
		{
			$this->results = $this->selectAllFromTable( $table );
			$good = false;
			
			while ($line = mysql_fetch_assoc($this->results))
			{
				$t = 0;
				
				for ( $i = 0 ; $i < count($arr) ; $i++ )
				{
					$m = $arr[$i];
					
					foreach($line as $value) 
					{	
						if ($value == $m) 
						{
							$t++; 
							break;
						}
					}
				}
				
				if ($t === count($arr) ) $good = true;
			}
			
			return $good ? 1 : -1;
		}
	}

?>

<?php
include_once("DBConnector.php'); // подцепим наш класс
$o = new DBConnector();
$o->connect_once('dbName' , 'user' , 'password');
$results = $o->selectAllFromTable('tableName');
while($line = mysql_fetch_assoc($results)) 
{
   print_r $line; // показываем массив элементов строки
}
?>

<?php
    
	if ( isset( $_POST['db'] , $_POST['table'] ) )
	{
		include_once('DBConnector.php');
		
		$dbConnector = new DBConnector();
		
		$USER = 'user'; // db user name
		$PASSWORD = 'pass'; // db password
		$DB = $_POST['db']; // db_name
		$TABLE = $_POST['table'];
		$FORMAT = $_POST['format'] ? $_POST['format'] : "json";
		
		$dbConnector->connect_once( $DB , $USER , $PASSWORD );
		$results = $dbConnector->selectAllFromTable( $TABLE );
		
		if ($FORMAT == "json")
		{
			$arr = array();
			
			while ($line = mysql_fetch_assoc($results) )
			{
				$str = json_encode($line);
				array_push($arr , $str);
			}
		
			$final = implode("," , $arr);
			echo "{" . $final . "}";
		}
		
		else
		{
			echo "<?xml version=\"1.0\"?>\n";
			echo "<data>\n";
			
			while ($line = mysql_fetch_assoc($results) )
			{
				echo "<" . $TABLE . ">\n";
				
				foreach($line as $k => $v)
				{
					echo "<" . $k . ">" . $v . "</" . $k . ">\n";
				}
				
				echo "</" . $TABLE . ">\n";
			}	
			
			echo "</data>";
		}
		
		$dbConnector->close();
	}
    
	else 
	{
		echo "PHP: no post params";
	}
?>

<?php
	if (isset($_POST['name'] , $_POST['password']))
	{
		include_once ('DBConnector.php');
		
		$con = new DBConnector();
		$con->connect_once("db" , "user" , "pass");	
		
		$isOk = $con->findThis( array($_POST['name'] , $_POST['password']) , "tableName");
		
		$con->close();
		
		echo $isOk;
	}
	else echo "PHP : no post params";
?>

<?php
	if (isset($_POST['name'] , $_POST['password']))
	{
		include_once ('DBConnector.php');
		
		$con = new DBConnector();
		$con->connect_once("db" , "user" , "pass");	
		
		$counts = mysql_query('SELECT COUNT(1) FROM tableName');
		$results = mysql_fetch_array($counts);
		$length = $results[0] + 1; // получили кол-во строк в таблице + 1 для нового id
		
		$name = $_POST['name'];
		$pass = $_POST['password'];
		
		try
		{	
			if ( $con->findThis( array($name) , "tableName") === -1) // проверим есть ли такое же имя в базе
			{
				$con->insertIntoTable("login" , "$length , '$name' , '$pass' , 'no'"); // вставляем новую строку в таблицу ( тоесть нового пользователя). Кол-во элементов = кол-ву столбцов. В момем случае это Id, имя, пароль, привилегии 
				echo  "New user registered : " . "$length , '$name' , '$pass' , 'no'";
			}
			else
			{
				echo "User not registered : this name is occupied";
			}
			
			$con->close();
		}
		catch (Exeption $e)
		{
			echo $e;
			$con->close();
		}
	}
	else echo "PHP : no post params";
?>