I'm facing problem with insering data with my database and I'm also not sure about the file path which I wrote

Asked Jul 05 '19 at 10:43

Active Jul 05 '19 at 11:15

Viewed 32 times

I'm creating a form and want to insert the user's data along with a random profile image, but my data is not inserting in phpMyAdmin.

I'm using sublime text-editor.

if(empty($error_array)) {
    $password = md5($password);

    $rand = rand(1, 2);

    if($rand == 1)
        $profile_pic = "E:/xampp/htdocs/social/assets/images/profile_pics/defaults/head_emerald.png";
    else if($rand == 2)
        $profile_pic = "E:/xampp/htdocs/social/assets/images/profile_pics/defaults/head_deep_blue.png";

    $query = mysqli_query($con, "INSERT INTO users VALUES ('', '$fname', '$em', '$password', '$date', '$profile_pic', '0', '0', 'no', ',')"); ```
}

My data is not being inserted into my database.

edited Jul 05 '19 at 10:44

treyBake

6,440
6
26
57

asked Jul 05 '19 at 10:43

G19TV

1

you're open to SQL injection and should address immediately – treyBake Jul 05 '19 at 10:44
1

phpMyAdmin is not a database. It is a tool for DB management. – Dharman Jul 05 '19 at 10:44
1

Do not use MD5 for passwords. – Dharman Jul 05 '19 at 10:45
This question is essentially unanswerable without guessing or further details. See the linked duplicates on the most relevant things to try at least. – mario Jul 05 '19 at 11:17

I'm facing problem with insering data with my database and I'm also not sure about the file path which I wrote

0 Answers0