mysqli insert

^<?php

^{extract($_POST);}

^{echo $user_id.'<br>';}

^{echo $user_pass.'<br>';}

^{echo $user_email.'<br>';}

        ^{$mysqli = new mysqli("localhost", "root", "password", "DB");}

        ^{if ($mysqli->connect_errno) {}

                ^{echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;}

        ^}

        ^{$query="INSERT INTO `join` ( `id`, `pw`, `email` ) VALUES ( '$user_id', '$user_pass', '$user_email' )";}

        ^{$mysqli->query($query);}

        ^{if($mysqli->insert_id) {}

                ^{echo 1;}

        ^{} else {}

                ^{echo 2;}

        ^}

^?>