note 128005 added to features.file-upload.post-method

From: Date: Fri, 09 Dec 2022 17:04:37 +0000
Subject: note 128005 added to features.file-upload.post-method
Groups: php.notes 
Request: Send a blank email to php-notes+get-219959@lists.php.net to get a copy of this message
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>intl_error_name</title> </head> <style> table, td, th { border-collapse: collapse; border: 1px solid #999; padding: 3px; } </style> <body> <?php function imprimir($a) { echo" <table> <tr> <th>Nome</th> <th>Marca</th> <th>Tipo</th> <th>Prezo</th> <th>Imaxe</th> </tr> "; while($fila = mysqli_fetch_array($a)) { echo"<tr> <td>{$fila['Nome']}</td> <td>{$fila['Marca']}</td> <td>{$fila['Tipo']}</td> <td>{$fila['Prezo']}</td> <td>{$fila['Imaxe']}</td> </tr> "; } echo" </table> "; } $servidor="dbXdebug"; $usuario="root"; $pass="root"; $bd="senderismo"; $conexion = new mysqli($servidor, $usuario, $pass, $bd); echo" <form action='intro2.php' method='POST'><br> <input type='text' name='in_buscar'> <input type='submit' value='Buscar por marca' name='btn_buscarMarca'> <input type='submit' value='Buscar en todo' name='btn_buscarTodo'> <hr> </form> "; $consulta = $conexion->prepare("SELECT Tipo FROM material"); $consulta->execute(); $resultado = $consulta->get_result(); $consulta->close(); echo" <form action='intro2.php' method='POST'><br> <!--SELECT TIPO: --> <select name='sel_tipo'> "; while($fila = $resultado->fetch_array(MYSQLI_BOTH)) { echo" <option value='{$fila['Tipo']}'> {$fila['Tipo']} </option> "; } echo" </select> <input type='submit' value='mostrar' name='btn_mostrar'> <hr> </form> "; $consulta = $conexion->prepare("SELECT * FROM material"); $consulta->execute(); $resultado = $consulta->get_result(); $consulta->close(); echo" <form action='intro2.php' method='POST'><br> <!--SELECT BORRAR: --> <select name='sel_producto'> "; while($fila = $resultado->fetch_array(MYSQLI_BOTH)) { echo" <option value='{$fila['Nome']}'> {$fila['Nome']}, {$fila['Marca']}, {$fila['Tipo']}, {$fila['Prezo']}, {$fila['Imaxe']} </option> "; } echo" </select> <input type='submit' value='borrar' name='btn_borrar'> </form> "; if(isset($_POST["btn_mostrar"])) { $sel_tipo = $_POST['sel_tipo']; //Preparamos a consulta $consulta = $conexion->prepare("SELECT * FROM material WHERE Tipo = ?"); $consulta->bind_param('s', $sel_tipo); $consulta->execute(); $resultado = $consulta->get_result(); imprimir($resultado); } if(isset($_POST["btn_borrar"])) { $sel_producto = $_POST["sel_producto"]; //Preparamos a consulta $consulta = $conexion->prepare("DELETE FROM material WHERE Nome = ?"); $consulta->bind_param('s', $sel_producto); $consulta->execute(); $consulta->get_result(); if($consulta = true) { echo"Eliminado correctamente"; } else echo "error"; } //Buscar en todo if(isset($_POST["btn_buscarTodo"])) { $in_buscar = $_POST["in_buscar"]; $in_buscar = "%$in_buscar%"; //Preparamos a consulta $consulta = $conexion->prepare("SELECT * FROM material WHERE Nome LIKE ? OR Marca LIKE ? OR Tipo LIKE ? OR Prezo LIKE ?"); $consulta->bind_param('ssss', $in_buscar, $in_buscar, $in_buscar, $in_buscar); $consulta->execute(); $resultado = $consulta->get_result(); imprimir($resultado); } if(isset($_POST["btn_buscarMarca"])) { $in_buscar = $_POST["in_buscar"]; $in_buscar = "%$in_buscar%"; //Preparamos a consulta $consulta = $conexion->prepare("SELECT * FROM material WHERE Marca LIKE ? "); $consulta->bind_param('s', $in_buscar); $consulta->execute(); $resultado = $con ---- Server IP: 45.112.84.4 Probable Submitter: 185.85.3.175 (proxied: 83.35.167.174) ---- Manual Page -- https://php.net/manual/en/features.file-upload.post-method.php Edit -- https://main.php.net/note/edit/128005 Del: integrated -- https://main.php.net/note/delete/128005/integrated Del: useless -- https://main.php.net/note/delete/128005/useless Del: bad code -- https://main.php.net/note/delete/128005/bad+code Del: spam -- https://main.php.net/note/delete/128005/spam Del: non-english -- https://main.php.net/note/delete/128005/non-english Del: in docs -- https://main.php.net/note/delete/128005/in+docs Del: other reasons-- https://main.php.net/note/delete/128005 Reject -- https://main.php.net/note/reject/128005 Search -- https://main.php.net/manage/user-notes.php

« previous php.notes (#219959) next »