note 128005 added to features.file-upload.post-method
| From: | rcrdgz22 at protonmail dot com | 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