<?php
$dbh = new PDO('mysql:host=localhost;dbname=test', 'userId', 'password', array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
/*
$connect = mysql_connect("localhost","test","password") or die("not bad");
$dbconn = mysql_select_db("homesi",$connect);
*/
$stmt = $dbh->prepare("INSERT INTO mans (userId, userName, userPassword, userCellphone, userTelephone, userEmail, userAddress, userMemo, userLevel, registDay) VALUES (:userId, :userName, :userPassword, :userCellphone, :userTelephone, :userEmail, :userAddress, :userMemo, 1, now())");
$stmt->bindParam(':userId',$userId);
$stmt->bindParam(':userName',$userName);
$stmt->bindParam(':userPassword',$userPassword);
$stmt->bindParam(':userCellphone',$userCellphone);
$stmt->bindParam(':userTelephone',$userTelephone);
$stmt->bindParam(':userEmail',$userEmail);
$stmt->bindParam(':userAddress',$userAddress);
$stmt->bindParam(':userMemo',$userMemo);
$userId = $_POST['userId'];
$userName = $_POST['userName'];
$userPassword = $_POST['userPassword'];
$userCellphone = $_POST['userCellphone'];
$userTelephone = $_POST['userTelephone'];
$userEmail = $_POST['userEmail'];
$userAddress = $_POST['userAddress'];
$userMemo = $_POST['userMemo'];
$stmt->execute();
//header("Location: list.php");
/*
$userId = $_POST['userId'];
$userName = $_POST['userName'];
$userPassword = $_POST['userPassword'];
$userCellphone = $_POST['userCellphone'];
$userTelephone = $_POST['userTelephone'];
$userEmail = $_POST['userEmail'];
$userAddress = $_POST['userAddress'];
$userMemo = $_POST['userMemo'];
$SQL="insert into mans (userId, userName, userPassword, userCellphone, userTelephone, userEmail, userAddress, userMemo, userLevel, registDay)";
$SQL.="values ('$userId', '$userName', '$userPassword', '$userCellphone', '$userTelephone', '$userEmail', '$userAddress', '$userMemo', 1, now())";
mysql_query($SQL,$connect);
echo $SQL;
*/
echo $_POST['userId']."<br />";
echo $_POST['userName']."<br />";
echo $_POST['userPassword']."<br />";
echo $_POST['userCellphone']."<br />";
echo $_POST['userTelephone']."<br />";
echo $_POST['userEmail']."<br />";
echo $_POST['userAddress']."<br />";
echo $_POST['userMemo']."<br />";
?>
'기존카테고리 > mysql' 카테고리의 다른 글
SELECT @rownum:=@rownum (0) | 2022.10.09 |
---|---|
INFORMATION_SCHEMA.TABLES (0) | 2018.02.02 |
고도에서 workbench use database 선택 (0) | 2017.12.07 |
PDO 출력 및 그룹핑 (0) | 2014.11.10 |