if ( $user_auth && $user_level <= -1 )
{
$blq1 ="pvp,descrCorta,descrLarga";
$list = true;
if ( isset( $sins ) )
{
displayForm( "./?dgo=adm/tdiscos.php&ins=new" );
$list = false;
}
if ( isset( $smod ) )
{
$res = @mysql_query( "SELECT id,$blq1 FROM TiposDiscos WHERE id=$smod", $conexion );
$datos = @mysql_fetch_array( $res );
list( $db_id, $db_pvp, $db_descrCorta, $db_descrLarga ) = $datos;
displayForm( "./?dgo=adm/tdiscos.php&mod=$smod" );
$list = false;
}
if ( isset( $mod ) )
{
$sql = "UPDATE TiposDiscos SET ".
"pvp='$db_pvp' ".
",descrCorta='$db_descrCorta' ".
",descrLarga='".urlencode($db_descrLarga)."' ".
" WHERE id=$mod";
$res = @mysql_query( $sql, $conexion );
$list = true;
}
if( isset( $ins ) )
{
$sql = "INSERT INTO TiposDiscos ($blq1) VALUES ('$db_pvp','$db_descrCorta','$db_descrLarga')";
$res = @mysql_query( $sql, $conexion ) OR die( "Error
".@mysql_error($conexion) );
echo "
ID asignado = ".@mysql_insert_id($conexion)."
"; $list = true; } if( isset( $del ) ) { $res = @mysql_query( "DELETE FROM TiposDisco WHERE id=$del" ); $list = true; } if ( isset( $list ) && $list ) { displayList($conexion); } displayMenu(); } function displayList($cnx) { $thisLOCATION = "./?dgo=adm/tdiscos.php"; $res = @mysql_query( "SELECT id, pvp, descrCorta FROM TiposDiscos", $cnx ); echo "id | ". "Descripción | ". "PVP | ". "Borrar |
$db_id | ". "$db_descrCorta | ". "$db_pvp # $db_tlf2 | ". "X |