「PHP」ユーザ新規登録メールを有効
<?php
session_start();
header('Content-Type:text/html;charset=UTF8’);
include_once(“conn/conn.php");
if (!empty($_GET['name’]) && !is_null($_GET['name’])){ //ユーザ登録を有効
$num=$conne->getRowsNum(“select * from tb_member where name='".$_GET['name’]."' and password = '".$_GET['pwd’]."'");
if ($num>0){
$upnum=$conne->uidRst(“update tb_member set active = 1 where name='".$_GET['name’]."' and password = '".$_GET['pwd’]."'");
if($upnum > 0){
$_SESSION['name’] = $_GET['name’];
echo “<script>alert('ユーザ登録成功!’);window.location.href=’main.php’;</script>";
}else{
echo “<script>alert('すでに有効!’);window.location.href=’main.php’;</script>";
}
}else{
echo “<script>alert('ユーザ登録失敗!’);window.location.href=’register.php’;</script>";
}
}
?>