Beispiel #1
0
function Reg_to_Geo($User_ID, $Address)
{
    $geo = Geo($Address);
    //		printf("x = %f, y = %f, city = %s",$geo[0],$geo[1],$geo[2]);
    $City_ID = Name_2_ID($geo[2]);
    //conect database
    $link = mysql_connect("localhost", "Reciplan", "reciplan");
    if (!$link) {
        die("Connection Failed." . mysql_error());
    }
    $dbselect = mysql_select_db('Users_Geo', $link);
    if (!$dbselect) {
        die("DB Select Failed." . mysql_error());
    }
    $chartype = mysql_query("SET NAMES utf8", $link);
    if (!$chartype) {
        die("Query Failed." . mysql_error());
    }
    // 	query
    //insert data into User_Geo
    $query = sprintf("INSERT INTO Users_Geo.User_Geo VALUES ('%06s,',%d,%f,%f)", $User_ID, $City_ID, $geo[0], $geo[1]);
    //		printf("query = %s\n",$query);
    $result = mysql_query($query);
    // MySQL に送られたクエリと返ってきたエラーをそのまま表示します。デバッグに便利です。
    if (!$result) {
        $message = 'Invalid query: ' . mysql_error() . "\n";
        $message .= 'Whole query: ' . $query;
        die($message);
    }
    //create table
    $query = sprintf("CREATE TABLE U%06d ( ID char(9) NOT NULL, Price float NOT NULL, Mount float NOT NULL, Day date NOT NULL )", $User_ID);
    //		printf("\nquery = %s\n",$query);
    $result = mysql_query($query);
    // MySQL に送られたクエリと返ってきたエラーをそのまま表示します。デバッグに便利です。
    if (!$result) {
        $message = 'Invalid query: ' . mysql_error() . "\n";
        $message .= 'Whole query: ' . $query;
        die($message);
    }
    //	exit
    $flag = mysql_close($link);
    if (!$flag) {
        die("Close Failed." . mysql_error());
    }
}
Beispiel #2
0
      	if( $_POST["send"] != "send" )
        	die( "" );
    
      	for( $i = 0; $i < 3; $i++ ){
        	if( !$_POST[$index_POST[$i]] )
        	  die( "<br>require ".$index_POST[$i] );
      	}
    */
    //メールアドレスチェック
    if (Is_Mail($_POST['mail']) == FALSE) {
        $error = "Individual MailAddress";
    } else {
        if ($_POST['password'] != $_POST['password_r']) {
            $error = "Password is not mach";
        } else {
            if (Geo($_POST['address']) == NULL) {
                $error = "Individual Address";
            } else {
                $_SESSION['Address'] = $_POST['address'];
                $_SESSION['Mail'] = $_POST['mail'];
                $_SESSION['Password'] = $_POST['password'];
                $_SESSION['Name'] = $_POST['username'];
                header("Location: ./SignupCheck.php");
                echo "</center>";
            }
        }
    }
}
?>

<!DOCTYPE html>