Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db_host="localhost";
- $db_user="root";
- $db_password="";
- $db_name="proyectos";
- $db_table_name="proyecto";
- $db_connection = new mysqli($db_host, $db_user, $db_password, $db_name);
- if (!$db_connection) {
- die('No se ha podido conectar a la base de datos');
- }
- $subs_Id_Pro = utf8_decode($_POST['Id_Pro']);
- $subs_nombre = utf8_decode($_POST['nombre']);
- $subs_departamento = utf8_decode($_POST['departamento']);
- $subs_encargado = utf8_decode($_POST['encargado']);
- $subs_costo = utf8_decode($_POST['costo']);
- $resultado = $db_connection->query("SELECT * FROM $db_table_name WHERE Id_Pro = $subs_Id_Pro and Nombre = '$subs_nombre'");
- if ($resultado->num_rows > 0 ) {
- header('Location: Fail.html');
- } else {
- $insert_value=$db_connection->query("INSERT INTO $db_table_name(Id_Pro, Nombre, Departamento, Encargado, Costo) VALUES($subs_Id_Pro, '$subs_nombre', '$subs_departamento', '$subs_encargado', $subs_costo)");
- if($insert_value){
- header('Location: Success.html');
- }else{
- //CÓDIGO EN CASO QUE NO SE PUEDA HACER EL INSERT.
- }
- }
- $db_connection->close();
Add Comment
Please, Sign In to add comment