Einzelnen Beitrag anzeigen
  #3  
Alt 24.10.2003, 18:49:50
schmidt schmidt ist offline
Anfänger
 
Registriert seit: Oct 2003
Beiträge: 42
schmidt eine Nachricht über ICQ schicken
nee nicht so ganz!!
ich poste mal den Code dazu!!



<?php
// ------------- db with table l_user_group for Update open ------------------------
$db = "sage";
$link = mysql_connect ("localhost","...","...");
if ( ! $link )
die ("keine Verbindung ");
mysql_select_db( $db, $link )
or die ("konnte DB nicht oeffnen" );
if ($Submit == "Save")
{
$anfrage = "UPDATE l_user_group SET l_user_group_user = '$user_num_up', l_user_group_group = '$l_user_group_group_up'
where l_user_group_id = '$l_user_group_id_up'";
$ergebnis = mysql_query ( $anfrage );
}
if ($Submit_del == "YES")
{
$anfrage = "DELETE FROM l_group_perm WHERE l_user_group_id = '$l_user_group_id_del'";
$ergebnis = mysql_query ( $anfrage );

}
mysql_close ($link);
?>

<?
// ------------- db with table user for Update open ------------------------
$db = "sage";
$link = mysql_connect ("localhost","...","...");
if ( ! $link )
die ("keine Verbindung ");
mysql_select_db( $db, $link )
or die ("konnte DB nicht oeffnen" );
if ($Submit == "Save")
{
$anfrage = "UPDATE user SET user_num = '$user_num_up', user_cp_fname = '$user_cp_fname_up', user_cp_lname = '$user_cp_lname_up',
user_cp_position = '$user_cp_position_up', user_cp_phone ='$user_cp_phone_up', user_cp_phone_m ='$user_cp_phone_m_up',
user_cp_fax ='$user_cp_fax_up', user_cp_email ='$user_cp_email_up', user_comp_name = '$user_comp_name_up',
user_comp_street = '$user_comp_street_up', user_comp_city = '$user_comp_city_up', user_comp_zip = '$user_comp_zip_up',
user_comp_country = '$user_comp_country_up', user_comp_phone_1 = '$user_comp_phone_1_up', user_comp_phone_2 = '$user_comp_phone_2_up',
user_comp_fax = '$user_comp_fax_up', user_comp_email_1 = '$user_comp_email_1_up', user_comp_email_2 = '$user_comp_email_2_up',
user_comp_web_1 = '$user_comp_web_1_up', user_comp_web_2 = '$user_comp_web_2_up', user_name = '$user_name_up',
password = '$password_up_up' where user_id = '$user_id_up'";
$ergebnis = mysql_query ( $anfrage );
}
if ($Submit_del == "YES")
{
$anfrage = "DELETE FROM user WHERE user_id = '$user_id_del'";
$ergebnis = mysql_query ( $anfrage );

}
mysql_close ($link);
?>

<?php
// ------------- db with table group_desc open ------------------------
$link = mysql_connect ("localhost","...","...")
or die ("Verbindungsversuch ist fehlgeschlagen!");

$erfolg = mysql_select_db ("sage")
or die ("Angegebene Datenbank ist nicht vorhanden!");

$query_handle = mysql_query
("select group_desc_id, group_desc_num, group_desc_desc from group_desc ORDER BY group_desc_desc",$link);
$result = mysql_query($query);
$zeilen = mysql_num_rows ($query_handle);
$zeilen_perm = $zeilen;
for ($i = 0; $i<$zeilen;$i++)
{
$elemente_perm[$i]=mysql_fetch_row($query_handle);
}
mysql_close ($link);
?>

<?php
// ------------- db with user for select ------------------------
$db_handle = mysql_connect ("localhost","...","...")
or die ("Verbindungsversuch ist fehlgeschlagen!");

$erfolg = mysql_select_db ("sage")
or die ("Angegebene Datenbank ist nicht vorhanden!");

$query_handle = mysql_query
("select user_id, user_num, user_cp_fname, user_cp_lname, user_cp_position , user_cp_phone,
user_cp_phone_m, user_cp_fax, user_cp_email, user_comp_name, user_comp_street, user_comp_city,
user_comp_zip, user_comp_country, user_comp_phone_1, user_comp_phone_2, user_comp_fax,
user_comp_email_1, user_comp_email_2, user_comp_web_1, user_comp_web_2, user_name, password, l_user_group_group, l_user_group_id
from user LEFT JOIN l_user_group ON user.user_num = l_user_group.l_user_group_user where user_id = ('$user_id')",$db_handle);

$result = mysql_query($query);

$zeilen = mysql_num_rows ($query_handle);

for ($i = 0; $i<$zeilen;$i++)
{
$elemente=mysql_fetch_row($query_handle);

?>
<FORM METHOD="POST" ACTION="/admin/user/user_desc_up.php?user_id=<?php print $user_id?>">
<b>User ID: <?php print $user_id?> </b>
<br>
<input type="hidden" name="user_id" value="<?php print $user_id?>">
User Number:
<br>
<input type="text" name="user_num" size="10" value="<?php print $user_num?>">
<br>
Contact Person First Name:
<br>
<input type="text" name="user_cp_fname" size="50" value="<?php print $user_cp_fname?>">
<br>
Contact Person Last Name:
<br>
<input type="text" name="user_cp_lname" size="50" value="<?php print $user_cp_lname?>">
<br>
Contact Person Position:
<br>
<input type="text" name="user_cp_position" size="50" value="<?php print $user_cp_position?>">
<br>
<table bgcolor="#FFFFFF" span class = "body">
<tr>
<td>
Contact Person Phone:
<br>
<input type="text" name="user_cp_phone" size="30" value="<?php print $user_cp_phone?>">
</td>
<td>
Contact Person Cellular Phone:
<br>
<input type="text" name="user_cp_phone_m" size="30" value="<?php print $user_cp_phone_m?>">
</td>
</tr>
</table>
Contact Person Fax:
<br>
<input type="text" name="user_cp_fax" size="30" value="<?php print $user_cp_fax?>">
<br>
Contact Person E-Mail:
<br>
<input type="text" name="user_cp_email" size="50" value="<?php print $user_cp_email?>">
<br>
Company Name:
<br>
<input type="text" name="user_comp_name" size="50" value="<?php print $user_comp_name?>">
<br>
Street:
<br>
<input type="text" name="user_comp_street" size="50" value="<?php print $user_comp_street?>">
<br>
City:
<br>
<input type="text" name="user_comp_city" size="30" value="<?php print $user_comp_city?>">
<br>
<table bgcolor="#FFFFFF" span class = "body">
<tr>
<td>
Zip:
<br>
<input type="text" name="user_comp_zip" size="10" value="<?php print $user_comp_zip?>">
</td>
<td>
Country:
<br>
<select name="user_comp_country">
<option selected><?php print $user_comp_country?></option>
<option>Austria</option>
<option>Denmark</option>
<option>France</option>
<option>Germany</option>
<option>Greece</option>
<option>Italy</option>
<option>Netherlands</option>
<option>Spain</option>
<option>Sweden</option>

</select>
</td>
</tr>
</table>
<table bgcolor="#FFFFFF" span class = "body">
<tr>
<td>
Company Phone 1:
<br>
<input type="text" name="user_comp_phone_1" size="30" value="<?php print $user_comp_phone_1?>">
</td>
<td>
Company Phone 2:
<br>
<input type="text" name="user_comp_phone_2" size="30" value="<?php print $user_comp_phone_2?>">
</td>
</tr>
</table>
Company Fax:
<br>
<input type="text" name="user_comp_fax" size="30" value="<?php print $user_comp_fax?>">
<br>
Company E-Mail 1:
<br>
<input type="text" name="user_comp_email_1" size="50" value="<?php print $user_comp_email_1?>">
<br>
Company E-Mail 2:
<br>
<input type="text" name="user_comp_email_2" size="50" value="<?php print $user_comp_email_2?>">
<br>
Company Web 1:
<br>
<input type="text" name="user_comp_web_1" size="50" value="<?php print $user_comp_web_1?>">
<br>
Company Web 2:
<br>
<input type="text" name="user_comp_web_2" size="50" value="<?php print $user_comp_web_2?>">
<br>
User Name:
<br>
<input type="text" name="user_name" size="30" value="<?php print $user_name?>">
<br>
Password:
<br>
<input type="text" name="password" size="30" value="<?php print $password?>">
<br>
<?php
$query_l_user_group = mysql_query
("select l_user_group_id, l_user_group_user, l_user_group_group from l_user_group where l_user_group_user = ('$user_id')",$db_handle);

$result = mysql_query($query);

$zeilen_l_user_group = mysql_num_rows ($query_l_user_group);

for ($i = 0; $i<$zeilen_l_user_group;$i++)
{
$elemente_l_user_group=mysql_fetch_row($query_l_user_group);

$l_user_group_id = $elemente_l_user_group[0];
$l_user_group_user = $elemente_l_user_group[1];
$l_user_group_group = $elemente_l_user_group[2];
?>

<?php print $l_user_group_id?> <?php print $l_user_group_user?> <?php print $l_user_group_group?><br>
Group Description: <?php print $l_user_group_group?>
<br>
<input type="hidden" name="l_user_group_id" value="<?php print $l_user_group_id?>">
<select name="l_user_group_group<?php print $l_user_group_id?>">
<?php
for ($i_perm = 0; $i_perm<$zeilen_perm;$i_perm++)
{
if ($l_user_group_group == $elemente_perm[$i_perm][1])
{
?>
<option VALUE="<?php print $elemente_perm[$i_perm][1]?>" selected><?php print $elemente_perm[$i_perm][2]?></option>
<?php
}
else
{
?>
<option VALUE="<?php print $elemente_perm[$i_perm][1]?>"><?php print $elemente_perm[$i_perm][2]?></option>
<?php
}
}
?>
</select>
<br>

<?php
}
?>

<p>
<INPUT TYPE="SUBMIT" Name="Submit" VALUE="Save">&nbsp; <INPUT TYPE="SUBMIT" Name="Submit" VALUE="Delete">
</form>
<?php
}
mysql_close ($db_handle);
?>
</td>
</tr>
</table>
Mit Zitat antworten