PHP MYSQL IMAGE UPLOAD CODE

<!-- wp:paragraph -->\n<p>In this article we will learn how to upload image using PHP and MYSQL</p>\n<!-- /wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p></p>\n<!-- /wp:paragraph -->\n\n<!-- wp:code -->\n<pre class=\"wp-block-code\"><code>\n&lt;?php\n\n \n$servername = \"localhost\";\n$username = \"root\";\n$password = \"\";\n$database = \"db_name\";\n\ntry {\n $conn = new PDO(\"mysql:host=$servername;dbname=$database\", $username, $password);\n // set the PDO error mode to exception\n $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\n //echo \"Connected successfully\";\n} catch(PDOException $e) {\n echo \"Connection failed: \" . $e->getMessage();\n}\n \n\n\n$allow = array(\"jpg\", \"JPG\", \"jpeg\", \"JPEG\", \"gif\", \"GIF\", \"png\", \"PNG\", \"pdf\", \"PDF\");\n //1st File\n if($_FILES&#91;'photo1']&#91;'name'] == \"\") {\n //echo \"No Image\"\n } else {\n\n $photo1=basename($_FILES&#91;'photo1']&#91;'name']);\n $extension = pathinfo($photo1, PATHINFO_EXTENSION);\n if(in_array($extension,$allow)){\n $target_path = \"../assets/img/trainers/\";\n $photo1 = md5(rand() * time()).'.'.$extension;\n $target_path = $target_path . $photo1;\n move_uploaded_file($_FILES&#91;'photo1']&#91;'tmp_name'], $target_path);\n $image_1 = ($photo1!='')?\" trainer_photo='$photo1' \". ',':'';\n }\n \n }\n\n\n$insert_bookings = \"UPDATE "$table_name" SET\n $image_1 \n col_1 = '\".addslashes($col_a).\"'\n where id='\".$edit_id.\"'\"; \n \n \n$sql_insert = $dbconn->prepare($insert_bookings);\n$sql_insert->execute();\n\n?>\n\n\n</code></pre>\n<!-- /wp:code -->\n\n<!-- wp:paragraph -->\n<p>Simply replace the $target_path = \"../assets/img/trainers/\"; and trainer_photo which is the column name</p>\n<!-- /wp:paragraph -->