21,886
社区成员
发帖
与我相关
我的任务
分享
<?php
require ('inc/config.php');
$page_title = '注册-CNode博客';
include ('inc/header.php');
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
require (MYSQL);
$trimmed = array_map('trim', $_POST);
$errors = array();
if ($_POST['code'] != $_SESSION['code']) {
$errors[] = '验证码不正确!';
}
if(empty($trimmed['username'])) {
$errors[] = '用户名不能为空';
} else {
if (preg_match ('/^[A-Z \'.-]{5,20}$/i', $trimmed['username'])) {
$un = mysqli_real_escape_string ($conn, $trimmed['username']);
} else {
$errors[] = '您的用户名格式不对';
}
}
if(empty($trimmed['email'])) {
$errors[] = '电子邮件地址不能为空';
} else {
if (filter_var($trimmed['email'], FILTER_VALIDATE_EMAIL)) {
$e = mysqli_real_escape_string ($conn, $trimmed['email']);
} else {
$errors[] = '您的电子邮件地址格式不对';
}
}
if(!empty($trimmed['password'])) {
if (preg_match ('/^\w{4,20}$/', $trimmed['password']) ) {
if ($trimmed['password'] == $trimmed['notpassword']) {
$p = mysqli_real_escape_string ($conn, $trimmed['password']);
} else {
$errors[] = '登录密码和确认密码不一致';
}
} else {
$errors[] = '请输入有效的登录密码';
}
} else {
$errors[] = '登录密码不能为空';
}
if(empty($trimmed['notpassword'])) {
$errors[] = '确认密码不能为空';
}
if (empty($errors)) {
// 确定电子邮件是否被使用
$q = "SELECT user_id FROM users WHERE email='$e'";
$r = mysqli_query ($conn, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($conn));
if (mysqli_num_row($r) == 0) { // 如果查询验证电子邮件地址未被使用,则注册用户
$a = md5(uniqid(rand(), true)); // 创建一个激活码(创建一个长度正好为32个字符的字符串)
$q = "INSERT INTO users (username, email, password, active, registration_date) VALUES ('$un', '$e', SHA1('$p'), '$a', NOW() )";
$r = mysqli_query ($conn, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($conn));
if (mysqli_affected_rows($conn) == 1) {
$body = "感谢您的注册,激活您的帐户,请点击这里:\n\n";
$body .= BASE_URL . 'activate.php?x=' . urlencode($e) . "&y=$a";
mail($trimmed['email'], '确认注册', $body, 'From: 414412984@qq.com');
echo '<h3>感谢您的注册!一封确认邮件已经发送到您的邮箱。请在该电子邮件中单击链接,以激活您的帐户。</h3>';
exit();
} else {
echo '<p class="error">用户注册失败,为此我们表示抱歉,请在注册一次</p>';
}
} else { // 查询验证出来的电子邮件地址已经被注册
echo '<p class="error">电子邮件地址已经被注册</p>';
}
} else {
foreach ($errors as $msg) { // Print each error.
echo " - $msg<br />\n";
}
}
mysqli_close($conn);
}
?>
<div class="wrap login">
<div class="path"><a href="#">主页</a> > 注册</div>
<div class="info">
<form method="post" name="register" action="">
<p>
<label for="username">用户名:</label><input type="text" name="username" id="username" class="text" value="<?php if (isset($trimmed['username'])) echo $trimmed['username']; ?>" />
<span>限5~20个字符,可用中文、英文、数字及“_”、“-”组成</span>
</p>
<p>
<label for="email">电子邮件:</label><input type="text" name="email" id="email" class="text" value="<?php if (isset($trimmed['email'])) echo $trimmed['email']; ?>" />
<span>请填写您的常用邮箱,它是您激活帐号和找回密码的凭证!</span>
</p>
<p>
<label for="password">登录密码:</label><input type="password" name="password" id="password" class="text" value="<?php if (isset($trimmed['password'])) echo $trimmed['password']; ?>" />
<span>密码由4-20位字母、数字组成</span>
</p>
<p>
<label for="notpassword">确认密码:</label><input type="password" name="notpassword" id="notpassword" class="text" value="<?php if (isset($trimmed['notpassword'])) echo $trimmed['notpassword']; ?>" />
<span>请再次输入密码</span>
</p>
<p>
<label for="yzm">验证码:</label><input type="text" name="code" id="yzm" class="text1" />
<img src="code.php" id="code" />
<span>看不清,请重新点击验证码(注意大小写)</span>
</p>
<div class="submit">
<input type="submit" name="submit" class="btn-1" value="立即注册" />
</div>
</form>
</div>
</div>
<?php
include ('inc/footer.php');
?>
print_r(get_extension_funcs('mysqli'));
你自己看看有没有
Array
(
[0] => mysqli_affected_rows
[1] => mysqli_autocommit
[2] => mysqli_change_user
[3] => mysqli_character_set_name
[4] => mysqli_close
[5] => mysqli_commit
[6] => mysqli_connect
[7] => mysqli_connect_errno
[8] => mysqli_connect_error
[9] => mysqli_data_seek
[10] => mysqli_dump_debug_info
[11] => mysqli_debug
[12] => mysqli_errno
[13] => mysqli_error
[14] => mysqli_error_list
[15] => mysqli_stmt_execute
[16] => mysqli_execute
[17] => mysqli_fetch_field
[18] => mysqli_fetch_fields
[19] => mysqli_fetch_field_direct
[20] => mysqli_fetch_lengths
[21] => mysqli_fetch_all
[22] => mysqli_fetch_array
[23] => mysqli_fetch_assoc
[24] => mysqli_fetch_object
[25] => mysqli_fetch_row
[26] => mysqli_field_count
[27] => mysqli_field_seek
[28] => mysqli_field_tell
[29] => mysqli_free_result
[30] => mysqli_get_connection_stats
[31] => mysqli_get_client_stats
[32] => mysqli_get_charset
[33] => mysqli_get_client_info
[34] => mysqli_get_client_version
[35] => mysqli_get_host_info
[36] => mysqli_get_proto_info
[37] => mysqli_get_server_info
[38] => mysqli_get_server_version
[39] => mysqli_get_warnings
[40] => mysqli_init
[41] => mysqli_info
[42] => mysqli_insert_id
[43] => mysqli_kill
[44] => mysqli_more_results
[45] => mysqli_multi_query
[46] => mysqli_next_result
[47] => mysqli_num_fields
[48] => mysqli_num_rows 这个是你要的吗?但你写错了
[49] => mysqli_options
[50] => mysqli_ping
[51] => mysqli_poll
[52] => mysqli_prepare
[53] => mysqli_report
[54] => mysqli_query
[55] => mysqli_real_connect
[56] => mysqli_real_escape_string
[57] => mysqli_real_query
[58] => mysqli_reap_async_query
[59] => mysqli_rollback
[60] => mysqli_select_db
[61] => mysqli_set_charset
[62] => mysqli_stmt_affected_rows
[63] => mysqli_stmt_attr_get
[64] => mysqli_stmt_attr_set
[65] => mysqli_stmt_bind_param
[66] => mysqli_stmt_bind_result
[67] => mysqli_stmt_close
[68] => mysqli_stmt_data_seek
[69] => mysqli_stmt_errno
[70] => mysqli_stmt_error
[71] => mysqli_stmt_error_list
[72] => mysqli_stmt_fetch
[73] => mysqli_stmt_field_count
[74] => mysqli_stmt_free_result
[75] => mysqli_stmt_get_result
[76] => mysqli_stmt_get_warnings
[77] => mysqli_stmt_init
[78] => mysqli_stmt_insert_id
[79] => mysqli_stmt_more_results
[80] => mysqli_stmt_next_result
[81] => mysqli_stmt_num_rows
[82] => mysqli_stmt_param_count
[83] => mysqli_stmt_prepare
[84] => mysqli_stmt_reset
[85] => mysqli_stmt_result_metadata
[86] => mysqli_stmt_send_long_data
[87] => mysqli_stmt_store_result
[88] => mysqli_stmt_sqlstate
[89] => mysqli_sqlstate
[90] => mysqli_ssl_set
[91] => mysqli_stat
[92] => mysqli_store_result
[93] => mysqli_thread_id
[94] => mysqli_thread_safe
[95] => mysqli_use_result
[96] => mysqli_warning_count
[97] => mysqli_refresh
[98] => mysqli_escape_string
[99] => mysqli_set_opt
)