Beste,
Ik heb een klein probleempje. Ik werk voor het moment iemand anders zijn site af.
Eigenlijk ben ik ni meer dan een designer, maar heb me nu even op php gegooit.
het volgende script doet een tooltje draaien waarin ik normaal gezien nieuwe users kan in toevoegen.
Het probleem is nu het volgende. als ik gegevens invul en op toevoegen klik in het tooltje gebeurt er helaas niets.
Ik heb een vaag idee.. ik denk dat er een action moet worden toegevoegd aan de form
[code=...]
<?php require_once('../Connections/connexion.php'); ?>
<?php
mysql_select_db($database_connexion, $connexion);
$query_q_user_all = "SELECT * FROM tb_user ORDER BY nom ASC";
$q_user_all = mysql_query($query_q_user_all, $connexion) or die(mysql_error());
//$row_q_user_all = mysql_fetch_assoc($q_user_all);
$totalRows_q_user_all = mysql_num_rows($q_user_all);
define('SELF',$_SERVER['PHP_SELF']);
$content_line = '';
while ($row_q_user_all = mysql_fetch_assoc($q_user_all)){
$content_line .='<form name="form'.$row_q_user_all['id_user'].'" method="post" action="'.SELF.'">';
$content_line .='<tr><td><input name="id_user" type="hidden" value="'.$row_q_user_all['id_user'].'">';
$content_line .='<input type="text" name="nom" value="'.$row_q_user_all['nom'].'"></td>';
$content_line .='<td><input type="text" name="login" value="'.$row_q_user_all['login'].'"></td>';
$content_line .='<td><input type="password" name="pwd" value="'.$row_q_user_all['pwd'].'"></td>';
$content_line .='<td><input type="text" name="email" value="'.$row_q_user_all['email'].'"></td>';
$content_line .='a';
$content_line .='<td><select name="acces">
<option value="all" '.$row_q_user_all['acces']=='all'?'selected':''.'>All</option>
<option value="cafe"'.$row_q_user_all['acces']=='cafe'?'selected':''.'>Café</option>
<option value="hotel"'.$row_q_user_all['acces']=='hotel'?'selected':''.'>Hôtels</option>
<option value="resto"'.$row_q_user_all['acces']=='resto'?'selected':''.'>Restaurants</option>
</select></td>';
$content_line .='<td><input name="mod" type="submit" id="submit" value="Modifier"></td>';
$content_line .='<td><input type="Submit" name="sup" id="submit" value="Supprimer"></td></tr></form>';
};
?>
<?php echo $_POST['id_user']; ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>nom</td>
<td>login</td>
<td>mot de passe </td>
<td>email</td>
<td>acces</td>
<td>modifier</td>
<td>supprimer</td>
</tr>
<?php echo $content_line; ?>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<form name="form1" method="post" action="">
<tr>
<td><input name="id_user" type="hidden" value="">
<input type="text" name="nom"></td>
<td><input type="text" name="login"></td>
<td><input type="text" name="pwd"></td>
<td><input type="text" name="email"></td>
<td><select name="acces">
<option value="all">All</option>
<option value="cafe">Café</option>
<option value="hotel">Hôtels</option>
<option value="resto">Restaurants</option>
</select></td>
<td><input type="submit" name="Submit" value="Ajouter"></td>
<td> </td>
</tr>
</form>
</table>
<?php
mysql_free_result($q_user_all);
?>
[php/]
Ik heb een klein probleempje. Ik werk voor het moment iemand anders zijn site af.
Eigenlijk ben ik ni meer dan een designer, maar heb me nu even op php gegooit.
het volgende script doet een tooltje draaien waarin ik normaal gezien nieuwe users kan in toevoegen.
Het probleem is nu het volgende. als ik gegevens invul en op toevoegen klik in het tooltje gebeurt er helaas niets.
Ik heb een vaag idee.. ik denk dat er een action moet worden toegevoegd aan de form
[code=...]
<?php require_once('../Connections/connexion.php'); ?>
<?php
mysql_select_db($database_connexion, $connexion);
$query_q_user_all = "SELECT * FROM tb_user ORDER BY nom ASC";
$q_user_all = mysql_query($query_q_user_all, $connexion) or die(mysql_error());
//$row_q_user_all = mysql_fetch_assoc($q_user_all);
$totalRows_q_user_all = mysql_num_rows($q_user_all);
define('SELF',$_SERVER['PHP_SELF']);
$content_line = '';
while ($row_q_user_all = mysql_fetch_assoc($q_user_all)){
$content_line .='<form name="form'.$row_q_user_all['id_user'].'" method="post" action="'.SELF.'">';
$content_line .='<tr><td><input name="id_user" type="hidden" value="'.$row_q_user_all['id_user'].'">';
$content_line .='<input type="text" name="nom" value="'.$row_q_user_all['nom'].'"></td>';
$content_line .='<td><input type="text" name="login" value="'.$row_q_user_all['login'].'"></td>';
$content_line .='<td><input type="password" name="pwd" value="'.$row_q_user_all['pwd'].'"></td>';
$content_line .='<td><input type="text" name="email" value="'.$row_q_user_all['email'].'"></td>';
$content_line .='a';
$content_line .='<td><select name="acces">
<option value="all" '.$row_q_user_all['acces']=='all'?'selected':''.'>All</option>
<option value="cafe"'.$row_q_user_all['acces']=='cafe'?'selected':''.'>Café</option>
<option value="hotel"'.$row_q_user_all['acces']=='hotel'?'selected':''.'>Hôtels</option>
<option value="resto"'.$row_q_user_all['acces']=='resto'?'selected':''.'>Restaurants</option>
</select></td>';
$content_line .='<td><input name="mod" type="submit" id="submit" value="Modifier"></td>';
$content_line .='<td><input type="Submit" name="sup" id="submit" value="Supprimer"></td></tr></form>';
};
?>
<?php echo $_POST['id_user']; ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>nom</td>
<td>login</td>
<td>mot de passe </td>
<td>email</td>
<td>acces</td>
<td>modifier</td>
<td>supprimer</td>
</tr>
<?php echo $content_line; ?>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<form name="form1" method="post" action="">
<tr>
<td><input name="id_user" type="hidden" value="">
<input type="text" name="nom"></td>
<td><input type="text" name="login"></td>
<td><input type="text" name="pwd"></td>
<td><input type="text" name="email"></td>
<td><select name="acces">
<option value="all">All</option>
<option value="cafe">Café</option>
<option value="hotel">Hôtels</option>
<option value="resto">Restaurants</option>
</select></td>
<td><input type="submit" name="Submit" value="Ajouter"></td>
<td> </td>
</tr>
</form>
</table>
<?php
mysql_free_result($q_user_all);
?>
[php/]