ir2sedair
دوشنبه 09 مرداد 1391, 17:02 عصر
سلام دوستان من یه کد ساده نوشتم که واسه ثبت یوزر و پسورد هست دخل دیتابیس
ولی ذخیره نمیشه
این کد خیره در mysql
<?php
session_start();
require_once('config.php');
require_once('class.php');
$errmsg_arr = array();
$errflag = false;
$link = mysql_connect(_dbHost_, _dbUser_, _dbPass_);
if(!$link) {
die('Failed to connect to server: ' . mysql_error());
}
$db = mysql_select_db(_dbName_);
if(!$db) {
die("Unable to select database");
}
function clean($str) {
$str = @trim($str);
if(get_magic_quotes_gpc()) {
$str = stripslashes($str);
}
return mysql_real_escape_string($str);
}
$username = clean($_POST['username']);
$password = clean($_POST['password']);
if($username == '') {
$errmsg_arr[] = 'Confirm password missing';
$errflag = true;
}
if($password == '') {
$errmsg_arr[] = 'Confirm password missing';
$errflag = true;
}
if($username != '') {
$qry = "SELECT * FROM users WHERE username='$username'";
$result = mysql_query($qry);
if($result) {
if(mysql_num_rows($result) > 0) {
$errmsg_arr[] = 'Login ID already in use';
$errflag = true;
}
@mysql_free_result($result);
}
else {
die("Query failed");
}
}
if($errflag) {
$_SESSION['ERRMSG_ARR'] = $errmsg_arr;
session_write_close();
//header("location: register-form.php");
echo ("error")
exit();
}
$qry = "INSERT INTO user(username, password) VALUES('$username','".Hsh($_POST['password'])."')";
$result = @mysql_query($qry);
if($result) {
echo'<script>window.location="register-success.php"</script>';
exit();
}else {
die("Query failed");
}
?>
این هم کد دیتابیس
DROP TABLE IF EXISTS users;
CREATE TABLE `users` (
`username` varchar(30) NOT NULL default 'admin',
`password` varchar(36) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
این هم فرم ثبت یوزر و پسورد
<p class="form_input_BG"><input name="username" type="text" class="textfield" id="username" />
</p>
<!-- User Name -->
<!-- Clear -->
<p class="clear">
</p>
<!-- Clear -->
<!-- User Name -->
<p class="form_text">
نام کلمه عبور
</p>
<p class="form_input_BG"> <input name="password" type="password" class="textfield" id="password" /></p>
<!-- User Name -->
<!-- Clear -->
<p class="clear">
</p>
ولی ذخیره نمیشه
این کد خیره در mysql
<?php
session_start();
require_once('config.php');
require_once('class.php');
$errmsg_arr = array();
$errflag = false;
$link = mysql_connect(_dbHost_, _dbUser_, _dbPass_);
if(!$link) {
die('Failed to connect to server: ' . mysql_error());
}
$db = mysql_select_db(_dbName_);
if(!$db) {
die("Unable to select database");
}
function clean($str) {
$str = @trim($str);
if(get_magic_quotes_gpc()) {
$str = stripslashes($str);
}
return mysql_real_escape_string($str);
}
$username = clean($_POST['username']);
$password = clean($_POST['password']);
if($username == '') {
$errmsg_arr[] = 'Confirm password missing';
$errflag = true;
}
if($password == '') {
$errmsg_arr[] = 'Confirm password missing';
$errflag = true;
}
if($username != '') {
$qry = "SELECT * FROM users WHERE username='$username'";
$result = mysql_query($qry);
if($result) {
if(mysql_num_rows($result) > 0) {
$errmsg_arr[] = 'Login ID already in use';
$errflag = true;
}
@mysql_free_result($result);
}
else {
die("Query failed");
}
}
if($errflag) {
$_SESSION['ERRMSG_ARR'] = $errmsg_arr;
session_write_close();
//header("location: register-form.php");
echo ("error")
exit();
}
$qry = "INSERT INTO user(username, password) VALUES('$username','".Hsh($_POST['password'])."')";
$result = @mysql_query($qry);
if($result) {
echo'<script>window.location="register-success.php"</script>';
exit();
}else {
die("Query failed");
}
?>
این هم کد دیتابیس
DROP TABLE IF EXISTS users;
CREATE TABLE `users` (
`username` varchar(30) NOT NULL default 'admin',
`password` varchar(36) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
این هم فرم ثبت یوزر و پسورد
<p class="form_input_BG"><input name="username" type="text" class="textfield" id="username" />
</p>
<!-- User Name -->
<!-- Clear -->
<p class="clear">
</p>
<!-- Clear -->
<!-- User Name -->
<p class="form_text">
نام کلمه عبور
</p>
<p class="form_input_BG"> <input name="password" type="password" class="textfield" id="password" /></p>
<!-- User Name -->
<!-- Clear -->
<p class="clear">
</p>