formualrio html a php

[apuu]

Código PHP:

$name = $_POST[name1];
// vemos si el campo name1 es solo texto
foreach ($name as $element) {
if (is_numeric($element)) {
echo "no se aceptan numeros en el nombre<br>";
exit;
}
}
// si estos 3 campos no estan completos
if(!isset($_POST['username']) && !isset($_POST['password']) && !isset($_POST['email'])){
echo "no escribiste nada en los campos requeridos<br>";
}else{
// si username y password no son mayores a 6 caracteres
if(strlen($_POST['username']) < 6 && strlen($_POST['password']) < 6)
{
echo "los campos tienen menos de 6 caracteres<br>";
}else{
 
 
// connect to the mysql server
$link = mysql_connect($server, $db_user, $db_pass)
or die ("Could not connect to mysql because ".mysql_error());
 
// select the database
mysql_select_db($database)
or die ("Could not select database because ".mysql_error());
 
// check if the username is taken
$check = "select id from $table where username = '".$_POST['username']."';";
$qry = mysql_query($check)
or die ("Could not match data because ".mysql_error());
$num_rows = mysql_num_rows($qry);
if ($num_rows != 0) {
echo "<center>
<br>$p43<br><br>
<a target=_top href=registrar.php class=link-login>$p44</a></center>
";
exit;
} else {
 
// insert the data
$ip = $_SERVER['REMOTE_ADDR'];
$insert = mysql_query("insert into $table values ('NULL', '".$_POST['username']."', '".$_POST['password']."', '".$_POST['name1']."', '".$_POST['name2']."', '".$_POST['email']."', '".$_POST['website']."', 'img/avatar.jpg', '".$ip."')")
or die("Could not insert data because ".mysql_error());
 
// print a success message
echo "
<center><br>$p45<br><br>
<a target=_top href=index.php class=link-login><b>$p46</b></a></center>
";
}
}
}