INSERTAR FOTO FORMATO BINARIO Y NO BINARIO MYSQL PHP PDO JSON

 FETCH post json api insert data and url photos mysql pdo php display table html

To insert data and photos using a POST JSON API in PHP and PDO to a MySQL database, you can follow the steps outlined below:

 

Create a database table to store the data and images. Let's call the table "my_table". The table should have columns for the data you want to store (such as name, age, etc.) and a column to store the image data (in binary format).

 

Create a PHP script to handle the API request. This script will receive the JSON data and image file in the request body, extract the data, and insert it into the database. Here's an example of what the script could look like:

 

php

Copy code

<?php

// Get the JSON data from the request body

$json_data = file_get_contents('php://input');

 

// Decode the JSON data into an array

$data = json_decode($json_data, true);

 

// Get the image file from the request

$image_data = file_get_contents($_FILES['photo']['tmp_name']);

 

// Connect to the database using PDO

$db = new PDO('mysql:host=localhost;dbname=my_database', 'username', 'password');

 

// Prepare the SQL statement to insert the data and image

$stmt = $db->prepare('INSERT INTO my_table (name, age, photo) VALUES (:name, :age, :photo)');

 

// Bind the data to the SQL parameters

$stmt->bindParam(':name', $data['name']);

$stmt->bindParam(':age', $data['age']);

$stmt->bindParam(':photo', $image_data, PDO::PARAM_LOB);

 

// Execute the SQL statement

$stmt->execute();

?>

In the HTML code for the page where you want to display the data, create a PHP script to retrieve the data from the database and display it in a table. Here's an example of what the script could look like:

php

Copy code

<?php

// Connect to the database using PDO

$db = new PDO('mysql:host=localhost;dbname=my_database', 'username', 'password');

 

// Prepare the SQL statement to retrieve the data

$stmt = $db->prepare('SELECT name, age, photo FROM my_table');

 

// Execute the SQL statement

$stmt->execute();

 

// Loop through the result set and display the data in a table

echo '<table>';

echo '<tr><th>Name</th><th>Age</th><th>Photo</th></tr>';

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

    echo '<tr>';

    echo '<td>' . htmlspecialchars($row['name']) . '</td>';

    echo '<td>' . htmlspecialchars($row['age']) . '</td>';

    echo '<td><img src="data:image/jpeg;base64,' . base64_encode($row['photo']) . '"></td>';

    echo '</tr>';

}

echo '</table>';

?>

Note: This code assumes that the image data is stored in the database as a binary blob. If you're using a different method to store the images (such as storing them on disk and storing the file path in the database), you'll need to modify the code accordingly.

 

 

 

 

jose fernandez

not binary format

If you're not storing the image data in binary format in your database, you can still use PDO to insert and retrieve image data. Here's how you can modify the code:

 

Modify your database table to have a column for the image file path. Let's call this column "photo_path".

 

Modify your PHP script to handle the API request. This script will receive the JSON data and image file in the request body, extract the data, and save the image file to a directory on your server. Here's an example of what the script could look like:

 

php

Copy code

<?php

// Get the JSON data from the request body

$json_data = file_get_contents('php://input');

 

// Decode the JSON data into an array

$data = json_decode($json_data, true);

 

// Get the image file from the request

$image = $_FILES['photo'];

 

// Save the image file to a directory on your server

$target_dir = "uploads/";

$target_file = $target_dir . basename($image["name"]);

move_uploaded_file($image["tmp_name"], $target_file);

 

// Connect to the database using PDO

$db = new PDO('mysql:host=localhost;dbname=my_database', 'username', 'password');

 

// Prepare the SQL statement to insert the data and image path

$stmt = $db->prepare('INSERT INTO my_table (name, age, photo_path) VALUES (:name, :age, :photo_path)');

 

// Bind the data to the SQL parameters

$stmt->bindParam(':name', $data['name']);

$stmt->bindParam(':age', $data['age']);

$stmt->bindParam(':photo_path', $target_file);

 

// Execute the SQL statement

$stmt->execute();

?>

In the HTML code for the page where you want to display the data, create a PHP script to retrieve the data from the database and display it in a table. Here's an example of what the script could look like:

php

Copy code

<?php

// Connect to the database using PDO

$db = new PDO('mysql:host=localhost;dbname=my_database', 'username', 'password');

 

// Prepare the SQL statement to retrieve the data

$stmt = $db->prepare('SELECT name, age, photo_path FROM my_table');

 

// Execute the SQL statement

$stmt->execute();

 

// Loop through the result set and display the data in a table

echo '<table>';

echo '<tr><th>Name</th><th>Age</th><th>Photo</th></tr>';

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

    echo '<tr>';

    echo '<td>' . htmlspecialchars($row['name']) . '</td>';

    echo '<td>' . htmlspecialchars($row['age']) . '</td>';

    echo '<td><img src="' . htmlspecialchars($row['photo_path']) . '"></td>';

    echo '</tr>';

}

echo '</table>';

?>

Note: This code assumes that the image data is stored as a file on your server, and the file path is stored in the database. If you're using a different method to store the images, you'll need to modify the code accordingly.

 

FETCH post json api update data and url photos not binary mysql pdo php

 

Here's how you can update data with photos in MySQL using PDO:

 

Modify your database table to have a column for the image file path. Let's call this column "photo_path".

 

Modify your PHP script to handle the API request. This script will receive the JSON data and image file in the request body, extract the data, and save the image file to a directory on your server. Here's an example of what the script could look like:

 

php

Copy code

<?php

// Get the JSON data from the request body

$json_data = file_get_contents('php://input');

 

// Decode the JSON data into an array

$data = json_decode($json_data, true);

 

// Get the image file from the request

$image = $_FILES['photo'];

 

// Save the image file to a directory on your server

$target_dir = "uploads/";

$target_file = $target_dir . basename($image["name"]);

move_uploaded_file($image["tmp_name"], $target_file);

 

// Connect to the database using PDO

$db = new PDO('mysql:host=localhost;dbname=my_database', 'username', 'password');

 

// Prepare the SQL statement to update the data and image path

$stmt = $db->prepare('UPDATE my_table SET name=:name, age=:age, photo_path=:photo_path WHERE id=:id');

 

// Bind the data to the SQL parameters

$stmt->bindParam(':id', $data['id']);

$stmt->bindParam(':name', $data['name']);

$stmt->bindParam(':age', $data['age']);

$stmt->bindParam(':photo_path', $target_file);

 

// Execute the SQL statement

$stmt->execute();

?>

In the HTML code for the page where you want to display the data, create a PHP script to retrieve the data from the database and display it in a table. Here's an example of what the script could look like:

php

Copy code

<?php

// Connect to the database using PDO

$db = new PDO('mysql:host=localhost;dbname=my_database', 'username', 'password');

 

// Prepare the SQL statement to retrieve the data

$stmt = $db->prepare('SELECT id, name, age, photo_path FROM my_table');

 

// Execute the SQL statement

$stmt->execute();

 

// Loop through the result set and display the data in a table

echo '<table>';

echo '<tr><th>Name</th><th>Age</th><th>Photo</th><th>Action</th></tr>';

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

    echo '<tr>';

    echo '<td>' . htmlspecialchars($row['name']) . '</td>';

    echo '<td>' . htmlspecialchars($row['age']) . '</td>';

    echo '<td><img src="' . htmlspecialchars($row['photo_path']) . '"></td>';

    echo '<td><a href="edit.php?id=' . htmlspecialchars($row['id']) . '">Edit</a></td>';

    echo '</tr>';

}

echo '</table>';

?>

Note: This code assumes that the image data is stored as a file on your server, and the file path is stored in the database. If you're using a different method to store the images, you'll need to modify the code accordingly. Also, the example code for editing the data in the database assumes that you have a separate "edit.php" file that handles the editing of the data

Comentarios

Publicar un comentario

Entradas populares de este blog

INSERTAR Y UPDATE FECHA CON PHP MYSQL EN FORMULARIO METODO POST CON JQUERY ETIQUETA DATE

COMO INSERTAR FECHA CON PHP MYSQL EN FORMULARIO METODO POST CON JQUERY ETIQUETA DATE ChatGPT Para insertar una fecha con PHP y MySQL en un formulario usando el método POST con jQuery y la etiqueta date, puedes seguir estos pasos. Asumiré que estás utilizando un formulario HTML con un campo de fecha: Crear el formulario HTML: html Copy code <!DOCTYPE html> <html lang="es"> <head>     <meta charset="UTF-8">     <meta name="viewport" content="width=device-width, initial-scale=1.0">     <title>Formulario de Fecha</title>     <!-- Agregar jQuery -->     <script src="https://code.jquery.com/jquery-3.6.4.min.js"></script> </head> <body>     <form id="miFormulario">         <label for="fecha">Fecha:</label>         <input type="date" id="fecha" name="fecha" required>         <but...
Leer más

Copia de Seguridad de Archivo MS Access (.mdb) a Pendrive con VB6

  Copia de Seguridad de Archivo MS Access (.mdb) a Pendrive con VB6   Para crear una copia de seguridad de un archivo MS Access (.mdb) a un pendrive cuando se hace clic en un botón en un formulario VB6, puedes usar el siguiente código: vb Private Sub cmdBackup_Click ()     On Error GoTo ErrorHandler         Dim ArchivoOrigen As String     Dim ArchivoDestino As String     Dim UnidadPendrive As String     Dim FSO As Object     Dim Drv As Object     Dim Existe As Boolean         ' Ruta del archivo de origen (base de datos Access)     ArchivoOrigen = "C:\Ruta\A\Tu\BaseDeDatos.mdb" ' Cambiar por tu ruta real         ' Verificar si el archivo de origen existe     If Dir(ArchivoOrigen) = "" Then         Ms...
Leer más

CONVERTIR IMÁGEN JPG O PNG A WEBP CON PHP DE FORMA SIMPLE

ChatGPT Puedes convertir imágenes de formato JPG o PNG a WebP utilizando la biblioteca GD en PHP. Aquí te muestro un ejemplo simple de cómo hacerlo: php Copy code <?php // Ruta de la imagen de entrada (puede ser JPG o PNG) $imagen_entrada = 'imagen.jpg'; // Ruta de la imagen de salida en formato WebP $imagen_salida = 'imagen.webp'; // Cargar la imagen de entrada $imagen = imagecreatefromstring(file_get_contents($imagen_entrada)); // Verificar si la carga de la imagen fue exitosa if ($imagen !== false) {     // Guardar la imagen en formato WebP     imagewebp($imagen, $imagen_salida);     // Liberar la memoria utilizada por la imagen cargada     imagedestroy($imagen);     echo 'La imagen se ha convertido a formato WebP correctamente.'; } else {     echo 'No se pudo cargar la imagen de entrada.'; } ?> Asegúrate de que la extensión PHP GD esté habilitada en tu servidor. Además, si necesitas ajustar la calidad de la imagen Web...
Leer más