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()); } }
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>