Hola que tal, espero que bien ... alguien sabe eliminar 2 registros de una tabla eh intentado y no se han eliminado
Código PHP:
Ver original<?php
require 'php/con.php';
$id = 0;
if ( !empty($_GET['id'])) { $id = $_REQUEST['id'];
}
// keep track post values
// delete data
$cod = $_POST["ins"];
$use = $_POST["uns"];
$pdo = Database::connect();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "delete from Jv WHERE uns= 'use' and ins = 'cod' ";
$q = $pdo->prepare($sql);
Database::disconnect();
header("Location: usuarios.php"); echo "<script> alert('se quitaron los registro'); </script>";
}
?>
Código PHP:
Ver original<form class="form-horizontal" action="Quitar_perm.php" method="post">
<?php
include 'php/conesion.php';
$query = 'SELECT * FROM Um' ;
$result = $con->query($query);
?>
<select id="uns" name="uns" requierd="true">
<?php
while ( $row = $result->fetch_array() )
{
?>
<option value=" <?php echo $row['uns'] ?> " >
<?php echo $row['uns']; ?></option>
<?php
}
?>
</select>
<?php
include 'php/conesion.php';
$query = 'SELECT * FROM pe' ;
$result = $con->query($query);
?>
<select id="ins" name="ins" requierd="true">
<?php
while ( $row = $result->fetch_array() )
{
?>
<option value=" <?php echo $row['ins'] ?> " >
<?php echo $row['Des']; ?></option>
<?php
}
?>
</select>
Gracias si me podrian explicar que hago mal
