help form to upload title, images and links with php and mysql

Question

help form to upload title, images and links with php and mysql

Navigation

#1 by (0 votes)

0

I have a form that should send a title, two images and several links, my problem is not sending any of those things, the point is when I want everything to be sent in a single form I can not do the correct php, the images they are uploaded but they are uploaded in different IDs of the databases instead of going all together, here is the php code:

    for ($i = 0; $i <= 2; $i++) {
$target_dir = "../uploads/";
$j = 1;
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"][$i]);
$uploadOk = 1;
$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);
// Check if image file is a actual image or fake image
if(isset($_POST["submit"])) {
    $check = getimagesize($_FILES["fileToUpload"]["tmp_name"][$i]);
    if($check !== false) {
        echo "File is an image - " . $check["mime"] . ".";
        $uploadOk = 1;
    } else {
        echo "File is not an image.";
        $uploadOk = 0;
    }
}
// Check if file already exists
if (file_exists($target_file)) {
    echo "Sorry, file already exists.";
    $uploadOk = 0;
}
// Check file size
if ($_FILES["fileToUpload"]["size"][$i] > 500000) {
    echo "Sorry, your file is too large.";
    $uploadOk = 0;
}
// Allow certain file formats
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
&& $imageFileType != "gif" ) {
    echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
    $uploadOk = 0;
}
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
    echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
    if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"][$i], $target_file)) {
$parte1="";
$parte1.= "http://demo.com";
$parte1.= substr($target_file, 2);


// Inserta el nuevo usuario a la base de datos.  
        if ($insert_stmt = $mysqli->prepare("INSERT INTO articulos (imagen$j) VALUES (?)")) {
            $insert_stmt->bind_param('s', $parte1);
            // Ejecuta la consulta preparada.
            if (! $insert_stmt->execute()) {
                header('Location: ../error.php?err=Registration failure: INSERT');
            }
        }
$j = $j + 1;
} else {
        echo "Sorry, there was an error uploading your file.";
    }
}
}
header('Location: ../añadir.php');

mysql php

asked by xtrios 01.05.2016 в 22:47

source

1 answer

Print templates with ternary in coffeescript Kivy, save contents of the Canvas in a StringIO

score 0 · Answer 1

In the code you are putting in effect as indicated, it is only the insert for the image, not for the other data, at some point I did something similar to what you want, I will share the code that I use, I hope work for you or at least to clarify your doubt

<?php session_start();

require 'config.php';
require '../functions.php';

comprobarSession();

$conexion = conexion($bd_config);
if (!$conexion) {
    header('Location: ../error.php');
}

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $titulo = limpiarDatos($_POST['titulo']);
    $extracto = limpiarDatos($_POST['extracto']);
    $texto = $_POST['texto'];
    $thumb = $_FILES['thumb']['tmp_name'];

    $archivo_subido = '../' . $blog_config['carpeta_imagenes'] . $_FILES['thumb']['name'];

    move_uploaded_file($thumb, $archivo_subido);

    $statement = $conexion->prepare(
    'INSERT INTO articulos (id, titulo, extracto, texto, thumb)
    VALUES (null, :titulo, :extracto, :texto, :thumb)'
    );

    $statement->execute(array(
        ':titulo' => $titulo,
        ':extracto' => $extracto,
        ':texto' => $texto,
        ':thumb' => $_FILES['thumb']['name']
    ));

    header('Location: '. RUTA . '/admin');
}

require '../views/nuevo.view.php';

?>