силно се надявам някой да ми каже каде ми е грешката
база данни:
users.php
ou_action.php
защо не работи?
база данни:
Код:
--
-- Структура на таблица `ou_logins`
--
CREATE TABLE IF NOT EXISTS `ou_logins` (
`id` mediumint(8) unsigned NOT NULL default '0',
`owner_id` mediumint(8) unsigned NOT NULL default '0',
`uname` varchar(100) NOT NULL default '',
`statut` enum('standard','advanced') NOT NULL default 'standard',
`upass` varchar(32) NOT NULL default '',
`title` varchar(20) default NULL,
`fname` varchar(50) default NULL,
`lname` varchar(50) default NULL,
`uposition` varchar(255) default NULL,
`contactn` varchar(100) default NULL,
`dateadd` datetime default NULL,
`sq` tinyint(3) unsigned default NULL,
`sa` varchar(100) default NULL,
PRIMARY KEY (`uname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;users.php
Код:
<?php
require_once ("../check_session.php");
require_once ("../mysql_conn.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Nexus Business Support</title>
<link href="global.css" rel="stylesheet" type="text/css" />
<style type="text/css">
.red {
font-weight: bold;
color: #FF0000;
}
h1 {
color:#636363;
float:left;
font-size:1.8em;
padding:0;
}
.content h2 {
color:#FFF;
font-weight:bold;
margin:0.2em 0;
padding:0.2em 0.3em;
}
.content p {
margin:0.5em 0;
padding:0.2em 0.3em;
}
.content p a {
font-size:1.2em;
}
.contentr1c1 h2 {
background-color: #369;
background-position: center bottom;
}
.contentr1c2 h2 {
background:#DDAD08;
}
.contentr2c1 h2 {
background:#396;
margin:0.7em 0 0;
}
.glassTable
{
background-image: url(../..//images/bg_hero_aurora.jpg);
border: none;
background-repeat: no-repeat;
background-position: center top;
background-color:#d3e2e9;
}
.style6 {font-size: 1px}
.style10{
font-family: Arial, Helvetica, sans-serif;
color: #336699;
text-decoration: underline;
font-size: 12px;
}
#Layer1 {
width:130px;
height:30px;
text-align: left;
float: right;
clear: none;
}
.style16 {color: #336699}
.style18 {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
font-weight: bold;
color: #336699;
line-height: normal;
}
.style19 {
font-size: 12px;
color: #336699;
font-family: Arial, Helvetica, sans-serif;
font-weight: normal;
font-style: normal;
text-indent: 10px;
text-align: left;
}
.style20 {
color: #132D68;
font-weight: bold;
font-size: 12px;
}
</style>
</head>
<body>
<table width="100%" height="60" align="center">
<tr>
<td width="216"><a href="../../index.html"><img src="http://nexussupport.co.uk/images/logo2.jpg" border="0"></a></td>
<td width="309"> </td>
<td width="209" align="right" ><br>
<?php
require_once ("header.php");
?>
<div id="contentWrapper">
<div id="contentMain">
<p><strong>Users</strong></p>
<?php
$has_users_query = mysql_query ("SELECT * FROM ou_logins WHERE owner_id=$_SESSION[uid] ORDER BY fname");
if (mysql_affected_rows() == 0) {
echo ("<strong>No registered users in section \"Other Users\".</strong>");
} else {
?>
<table width="100%" cellspacing="1" cellpadding="3" bgcolor="#73ABE2">
<tr bgcolor="#EEF7FF">
<td><strong>Name</strong></td>
<td><strong>Email</strong></td>
<td><strong>Status</strong></td>
<td> </td>
</tr>
<?php
while ($result = mysql_fetch_array ($has_users_query)) {
echo ("<tr bgcolor=\"#FFFFFF\">");
echo ("<td>$result[title] $result[fname] $result[lname]</td><td>$result[uname]</td><td>$result[statut]</td><td><a href=\"ou_edit.php?uid=$result[id]\">view</a></td>");
echo ("</tr>");
}
?>
</table>
<?php } ?>
<?php
if ($_GET['a'] == "y") echo ("<p><strong>Employee added successfully.</strong></p>");
if ($_GET['a'] == "b") echo ("<p class=\"red\">Error. Please, fill all required fields marked with an *</p>");?>
<p>To add a new user, fill in the form below and click 'Add user'.<br />
All required fields are marked with an <span class="red">*</span></p>
<table cellpadding="2" border="0" width="90%" align="center">
<form action="ou_action.php" method="post">
<tr>
<td width="28%"> </td>
<td>Title</td>
<td>1st</td>
<td>2nd</td>
</tr>
<tr>
<td>Name: <span class="red">*</span></td>
<td><input type="text" name="title" style="width:40px;" /></td>
<td><input type="text" name="fname" style="width:120px;" /></td>
<td><input type="text" name="lname" style="width:120px;" /></td>
</tr>
<tr>
<td>Position:</td>
<td colspan="3"><input type="text" name="position" style="width:310px;" /></td>
</tr>
<tr>
<td>Email Address: <span class="red">*</span></td>
<td colspan="3"><input type="text" name="email" style="width:310px;" /></td>
</tr>
<tr>
<td>Contact Number:</td>
<td colspan="3"><input type="text" name="cnumber" style="width:310px;" /></td>
</tr>
<tr>
<td>Password: <span class="red">*</span></td>
<td colspan="3"><input type="password" name="pass1" /></td>
</tr>
<tr>
<td>Confirm Password: <span class="red">*</span></td>
<td colspan="3"><input type="password" name="pass2" /></td>
</tr>
<tr>
<td> </td>
<td colspan="3" height="40">
<input type="hidden" name="act" value="add" />
<input type="submit" value="Add user" /></td>
</tr>
</form>
</table>
</div>
</div>
<div class="clear"><p> </p><p> </p><p> </p></div>
</body>
</html>ou_action.php
Код:
<?php
require_once ("../check_session.php");
require_once ("../mysql_conn.php");
$title = trim (strip_tags (htmlspecialchars ($_POST['title'], ENT_QUOTES)));
$fname = trim (strip_tags (htmlspecialchars ($_POST['fname'], ENT_QUOTES)));
$lname = trim (strip_tags (htmlspecialchars ($_POST['lname'], ENT_QUOTES)));
$position = trim (strip_tags (htmlspecialchars ($_POST['position'], ENT_QUOTES)));
$email = trim (strip_tags (htmlspecialchars ($_POST['email'], ENT_QUOTES)));
$cnumber = trim (strip_tags (htmlspecialchars ($_POST['cnumber'], ENT_QUOTES)));
$pass1 = trim (strip_tags (htmlspecialchars ($_POST['pass1'], ENT_QUOTES)));
$pass2 = trim (strip_tags (htmlspecialchars ($_POST['pass2'], ENT_QUOTES)));
if ($_POST['act'] == "add") {
if (empty($fname) || empty($lname) || empty($email) || empty($pass1) || empty($pass2)) {
header ("Location: users.php");
exit;
}
if ($pass1 != $pass2) {
header ("Location: users.php");
exit;
}
$check_username_query = mysql_query ("SELECT uname FROM ou_logins");
while ($check_username_result = mysql_fetch_array ($check_username_query)) {
if ($check_username_result ['uname'] == $email) {
header ("Location: users.php");
exit;
}
}
$max_id_query = mysql_fetch_row (mysql_query ("SELECT MAX(id) FROM ou_logins"));
$new_max_id = $max_id_query [0] + 1;
mysql_query ("INSERT INTO ou_logins VALUES ($new_max_id, ".$_SESSION['uid'].", '$email', 'standard', '$pass2', '$title', '$fname', '$lname', '$position', '$cnumber', '".date("Y-m-d H:i:s")."')");
}
if ($_POST['duser'] == "on") {
$uid = $_POST['uid'];
mysql_query ("DELETE FROM ou_logins WHERE id=$uid AND owner_id=".$_SESSION['uid']);
header ("Location: users.php");
exit;
}
if ($_POST['act'] == "update") {
$uid = $_POST['uid'];
$statut = $_POST['ustatut'];
if (empty($email) || empty($pass1) || empty($statut)) {
header ("Location: users.php");
exit;
}
$check_username_query = mysql_query ("SELECT uname FROM ou_logins");
while ($check_username_result = mysql_fetch_array ($check_username_query)) {
if ($check_username_result ['uname'] == $email) {
$my_mail = mysql_fetch_row (mysql_query ("SELECT uname FROM ou_logins WHERE id=$uid"));
if ($my_mail [0] != $email) {
header ("Location: users.php");
exit;
}
}
}
mysql_query ("UPDATE ou_logins SET uname='$email', statut='$statut', upass='$pass1' WHERE id=$uid AND owner_id=".$_SESSION['uid']);
}
header ("Location: users.php");
exit;
?>защо не работи?