Example #1
0
<?php

include './ConectorBaseDatos.php';
$conn = new ConectorBaseDatos();
$codPed = $_POST["codped"];
$sql = "SELECT * FROM pedidos WHERE CodigoPedido='{$codPed}'";
$result = $conn->ejecutar($sql, "", "");
if ($result != null) {
    $resultado = $result->fetch_assoc();
    //Esta linea se puede obviar, en el ajax de recogida, se pondria en vez de data.apellidos, se pondria data[0]['apellido'];
    if (is_null($resultado)) {
        echo false;
    } else {
        echo json_encode($resultado);
    }
}
Example #2
0
<?php

include './ConectorBaseDatos.php';
$codClien = $_POST["codClien"];
$nombreClien = $_POST["nombreClien"];
$nombreCont = $_POST["nombreCont"];
$apellidoCont = $_POST["apellidoCont"];
$tfno = $_POST["tfno"];
$fax = $_POST["fax"];
$direccion1 = $_POST["direccion1"];
$direccion2 = $_POST["direccion2"];
$ciudad = $_POST["ciudad"];
$region = $_POST["region"];
$pais = $_POST["pais"];
$codPos = $_POST["codPos"];
$credito = $_POST["credito"];
$empleado = $_POST["empleado"];
$conn = new ConectorBaseDatos();
$text = "<table>\r\n                    <tr>\r\n                        <td>Codigo Cliente: </td>\r\n                        <td>{$codClien}</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Nombre Cliente: </td>\r\n                        <td>{$nombreClien}</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Nombre Contacto: </td>\r\n                        <td>{$nombreCont}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Apellido Contacto: </td>\r\n                        <td>{$apellidoCont}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Telefono: </td>\r\n                        <td>\r\n                            {$tfno}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Fax: </td>\r\n                        <td>\r\n                            {$fax}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Direccion1: </td>\r\n                        <td>{$direccion1}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Direccion2: </td>\r\n                        <td>{$direccion2}</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Ciudad: </td>\r\n                        <td>{$ciudad}</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Region: </td>\r\n                        <td>{$region}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Pais: </td>\r\n                        <td>{$pais}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Codigo Postal: </td>\r\n                        <td>\r\n                            {$codPos}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Limite Credito: </td>\r\n                        <td>\r\n                            {$credito}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Empleado: </td>\r\n                        <td>{$empleado}\r\n                        </td>\r\n                    </tr>\r\n                </table>";
$sql = "INSERT INTO clientes (CodigoCliente,NombreCliente,NombreContacto,ApellidoContacto,Telefono,Fax,LineaDireccion1,LineaDireccion2,Ciudad,Region,Pais,CodigoPostal,CodigoEmpleadoRepVentas,LimiteCredito) VALUES " . "({$codClien},'{$nombreClien}','{$nombreCont}','{$apellidoCont}','{$tfno}','{$fax}','{$direccion1}','{$direccion2}','{$ciudad}','{$region}','{$pais}','{$codPos}',{$empleado},{$credito})";
$succesfulText = "New Client added correctly";
$datos = $conn->ejecutar($sql, $text, $succesfulText);
include './ControlSesion.php';
$sesion = new ControlSesion();
$sesion->gestiona();
?>
<!DOCTYPE html>
<html>
    <head>
        <title>Listar Departamento</title>
        <script src="js/libs/jquery/jquery.js" type="text/javascript"></script>
    </head>
    <body>
        <table style="border-collapse: collapse; text-align: center">
            <tr>
                <td style="border:1px black solid; padding:5px">Id</td><td style="border:1px black solid; padding:5px">Nombre</td><td style="border:1px black solid; padding:5px">Localizción</td>
            </tr>
            <?php 
include './ConectorBaseDatos.php';
$sql = "SELECT dept_no, dnombre, loc FROM departamentos";
$conn = new ConectorBaseDatos();
$text = "";
$succesfulText = "";
$result = $conn->ejecutar($sql, $text, $succesfulText);
$row = mysqli_fetch_array($result);
while ($row) {
    echo "<tr><td style='border:1px black solid; padding:5px'>" . $row['dept_no'] . "</td><td style='border:1px black solid; padding:5px'>" . $row['dnombre'] . "</td><td style='border:1px black solid; padding:5px'>" . $row['loc'] . "</td></tr>";
    $row = mysqli_fetch_array($result);
}
?>
        </table>
    </body>
</html> 
Example #4
0
                        <td>Salario: </td>
                        <td>
                            <input type="text" name="salario" id="salario"/>
                        </td>
                    </tr>
                    <tr>
                        <td>Comision: </td>
                        <td><input type="text" name="comision" id="comision" required/>
                        </td>
                    </tr>
                    <tr>
                        <td>Departamento: </td>
                        <td>
                            <select name="depto" id="depto">
                                <?php 
$conn2 = new ConectorBaseDatos();
$sql2 = "SELECT * FROM departamentos";
$result2 = $conn2->ejecutar($sql2, "", "");
if ($result2->num_rows > 0) {
    while ($row = $result2->fetch_assoc()) {
        echo "<option value='" . $row["dept_no"] . "'>" . $row["dept_no"] . "-" . $row["dnombre"] . "</option>";
    }
} else {
    echo "0 results";
}
?>
                            </select>
                        </td>
                    </tr>
                </table>
                <input type="submit" id="submit" value="Modificar"/>
<?php

include './ConectorBaseDatos.php';
$emp_no = $_POST["emp_no"];
$ape = $_POST["apellido"];
$dept_no = $_POST["dept_no"];
$oficio = $_POST["oficio"];
$dir = $_POST["dir"];
$fecha = $_POST["fecha"];
$salario = $_POST["salario"];
$comision = $_POST["comision"];
$text = "<table>\r\n                    <tr>\r\n                        <td>Id Empleado: </td>\r\n                        <td>{$emp_no}</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Apellido: </td>\r\n                        <td>{$ape}</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Oficio: </td>\r\n                        <td>{$oficio}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Dirigido (id del superior): </td>\r\n                        <td>{$dir}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Fecha: </td>\r\n                        <td>\r\n                            {$fecha}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Salario: </td>\r\n                        <td>\r\n                            {$salario}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Comision: </td>\r\n                        <td>{$comision}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Departamento: </td>\r\n                        <td>{$dept_no}\r\n                        </td>\r\n                    </tr>\r\n                </table>";
$conn = new ConectorBaseDatos();
$sql = "UPDATE Empleados SET apellido='{$ape}', oficio='{$oficio}', dir={$dir}, fecha_alt='{$fecha}', salario={$salario},comision={$comision},dept_no={$dept_no} WHERE emp_no='{$emp_no}'";
$result = $conn->ejecutar($sql, $text, "Updated Employee successfully");