UPDATE and INSERT SQL tables with php mysqli->prepare

Question

I'm trying to run two stmts and bind them with php. When I just run the $stmt and delete all of $stmt2, it works perfectly. I'm trying to change the 'active' column to Zeros. Basically trying to search and update all the other pictures the user has uploaded and change them to zero (so that it's not profile picture), only the most recent one should be active (1 in the $active).

 if (!$mysqli) {
echo "Error: Unable to connect to MySQL." . PHP_EOL;
echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
echo $db;
exit;
}

try {

if (empty($_FILES['image'])) {
    throw new Exception('Image file is missing');
}

$image = $_FILES['image'];

// check INI error
if ($image['error'] !== 0) {
    if ($image['error'] === 1) 
        throw new Exception('Max upload size exceeded');

    throw new Exception('Image uploading error: INI Error');
}

// check if the file exists
if (!file_exists($image['tmp_name']))
    throw new Exception('Image file is missing in the server');

$maxFileSize = 2 * 10e6; // in bytes
if ($image['size'] > $maxFileSize)
    throw new Exception('Max size limit exceeded'); 

// check if uploaded file is an image
$imageData = getimagesize($image['tmp_name']);
if (!$imageData) 
    throw new Exception('Invalid image');

$mimeType = $imageData['mime'];

// validate mime type
$allowedMimeTypes = ['image/jpeg', 'image/png', 'image/gif'];
if (!in_array($mimeType, $allowedMimeTypes)) 
    throw new Exception('Only JPEG, PNG and GIFs are allowed');

// nice! it's a valid image

// get file extension (ex: jpg, png) not (.jpg)
$fileExtention = strtolower(pathinfo($image['name'] ,PATHINFO_EXTENSION));

// create random name for your image
$fileName = round(microtime(true)) . mt_rand() . '.' . $fileExtention; // anyfilename.jpg

// Create the path starting from DOCUMENT ROOT of your website
$path = '/php/image_upload/images/' . $fileName;

// file path in the computer - where to save it 
$destination = $_SERVER['DOCUMENT_ROOT'] . $path;

if (move_uploaded_file($image['tmp_name'], $destination)) {
    // create the url
    $protocol = stripos($_SERVER['SERVER_PROTOCOL'],'https') === true ? 'https://' : 'http://';
    $domain = $protocol . $_SERVER['SERVER_NAME'];
    $url = $domain . $path;
    $active = 1;

    $mysqli->autocommit(FALSE);
    $stmt2 = $mysqli->prepare('UPDATE image_uploads SET active = ? WHERE user_id = ?');
    $stmt = $mysqli -> prepare('INSERT INTO image_uploads (url, active, user_id) VALUES (?, ?, ?)');
    if (
        $stmt &&
        $stmt2 &&
        $stmt2 -> bind_param('ii', 0, $_SESSION['id']) &&
        $stmt -> bind_param('sii', $url, $_SESSION['id'], $active) &&
        $stmt2 -> execute() &&
        $stmt -> execute()
    ) {
        exit(
            json_encode(
                array(
                    'status' => true,
                    'url' => $url

                )
            )
        );
    } else {
        throw new Exception('Error in saving into the database');
    }

}


 } catch (Exception $e) {

exit(json_encode(
    array (
        'status' => false,
        'error' => $e -> getMessage()
    )
));

}

Where is the rest of this `} catch (Exception $e) {` Like the `try{` part. Likely you just have a syntax error or something `500` is very generic error. — ArtisticPhoenix, Jan 16 '19 at 22:14
Just altered the code now. I tried to catch errors but the console isn't showing much. The code just stops running. — Apf42589, Jan 16 '19 at 22:53
I think that the problem is in this line : $maxFileSize = 2 * 10e6; — Hema D., Jan 16 '19 at 23:02

Hema D. · Answer 1 · 2019-01-16T23:01:56.173

0

You probably forgot to close else here

} else 
    throw new Exception('Error in saving into the database');

should be

} else 
    throw new Exception('Error in saving into the database');
}

UPDATE :

I didn't notice that you've updated your code.

The Problem is in this line : $maxFileSize = 2 * 10e6;

Should be $maxFileSize = 2 * 1024;

edited Jan 16 '19 at 23:01

answered Jan 16 '19 at 22:17

Hema D.

140
2
5
17

1

Thanks, but I tried fixing/adding an extra curly to be safe but it originally got cut off in the post. – Apf42589 Jan 16 '19 at 22:53
1

Wouln't that be very small, however even so, I had the same code working when I took out the UPDATE query. It loaded and posted all the pictures perfectly. – Apf42589 Jan 17 '19 at 00:37
Althought some servers consider this as an error like. – Hema D. Jan 17 '19 at 13:02
Have you checked your error_log.txt file in the cpanel ? Also, The problem might be in the rest of the code. Because there's no problem in this code. Something like Included files or etc. – Hema D. Jan 17 '19 at 13:06

UPDATE and INSERT SQL tables with php mysqli->prepare

1 Answers1