note 130049 added to class.pdoexception
| From: | dgonbla@gmail.com | Date: | Fri, 21 Feb 2025 09:44:17 +0000 |
| Subject: | note 130049 added to class.pdoexception | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-221873@lists.php.net to get a copy of this message | ||
<?php
$host = "localhost";
$user = "root";
$password = "";
$database = "Almacen";
try {
$db = new PDO("mysql:host=$host", $user, $password);
$query = "CREATE DATABASE IF NOT EXISTS $database;";
$db->exec($query);
$query = "USE $database;";
$db->exec($query);
$query = "CREATE TABLE IF NOT EXISTS Productos (
Id INT PRIMARY KEY,
Nombre VARCHAR(50),
Marca VARCHAR(50),
Origen VARCHAR(50),
Categoria ENUM('A', 'B', 'C', 'D', 'E'),
Clasificacion ENUM ('X', 'Y', 'Z', 'W')
);";
$db->exec($query);
$query = "CREATE TABLE IF NOT EXISTS Componentes (
Id INT PRIMARY KEY,
Tipo VARCHAR(50),
Procedencia VARCHAR(50),
Caracteristica VARCHAR(50),
Descripcion VARCHAR(50)
);";
$db->exec($query);
$query = "CREATE TABLE IF NOT EXISTS Detalles (
Producto INT NOT NULL,
Componente INT NOT NULL,
Cantidad INT,
FOREIGN KEY (Producto) REFERENCES Productos(Id),
FOREIGN KEY (Componente) REFERENCES Componentes(Id)
);";
$db->exec($query);
} catch (PDOException $e) {
echo "Error de conexión: " . $e->getMessage();
}
?>
<?php
$host = "localhost";
$user = "root";
$password = "";
$database = "Almacen";
try {
$db = new PDO("mysql:host=$host;dbname=$database", $user, $password);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query = $db->prepare("INSERT INTO Productos (Id, Nombre, Marca, Origen, Categoria,
Clasificacion)
VALUES (?, ?, ?, ?, ?, ?)");
$query->execute([
$_POST['id'],
$_POST['nombre'],
$_POST['marca'],
$_POST['origen'],
$_POST['categoria'],
$_POST['clasificacion']
]);
echo "Registro añadido con éxito";
} catch (PDOException $e) {
echo "Error: " . $e->getMessage();
} finally {
$db = null;
}
?>
----
Server IP: 45.112.84.4
Probable Submitter: 80.90.5.137 (proxied: 80.28.211.131)
----
Manual Page -- https://php.net/manual/en/class.pdoexception.php
Edit -- https://main.php.net/note/edit/130049
Del: integrated -- https://main.php.net/note/delete/130049/integrated
Del: useless -- https://main.php.net/note/delete/130049/useless
Del: bad code -- https://main.php.net/note/delete/130049/bad+code
Del: spam -- https://main.php.net/note/delete/130049/spam
Del: non-english -- https://main.php.net/note/delete/130049/non-english
Del: in docs -- https://main.php.net/note/delete/130049/in+docs
Del: other reasons-- https://main.php.net/note/delete/130049
Reject -- https://main.php.net/note/reject/130049
Search -- https://main.php.net/manage/user-notes.php