Superior University Depalpur: Dreamweaver

<div dir="ltr" style="text-align: left;" trbidi="on"><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">Suppose that if you want to create some dynamic pagez in php with some profile photoz for different <span class="skimlinks-unlinked" style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">userz. What</span> will you do???? Uploading the photos directly to your database will make it heavy and difficult to <span class="skimlinks-unlinked" style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">load.Here</span> we will learn how to upload a photo into a directory in your server and save the path in your sql database from a form so that you can display the images in your <span class="skimlinks-unlinked" style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">websites.We</span> will see all things step by <span class="skimlinks-unlinked" style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">step.That</span> will give you clear understanding.</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKWDSTh6DHVhh_ZVSRGGGt6ZESva7X9wlI8yLSUzhKKVs9m-Di1KKbqiSSGi8Me_JomMlfKDbwCyt5045Gy8-ofrlKOhJU901uCD1NMkpsKxYqv4CKUKLIt_KlPAnwwW9uTHR94SLNDg/s1600/fileuploadform.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="202" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKWDSTh6DHVhh_ZVSRGGGt6ZESva7X9wlI8yLSUzhKKVs9m-Di1KKbqiSSGi8Me_JomMlfKDbwCyt5045Gy8-ofrlKOhJU901uCD1NMkpsKxYqv4CKUKLIt_KlPAnwwW9uTHR94SLNDg/s400/fileuploadform.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><br /></div><div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;"><strong style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Step 1:Create a form named <span class="skimlinks-unlinked" style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">form.php</span>.</strong></div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;"><form action=”insert.php” method=”post” enctype=”multipart/form-data” role=”form”></div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;"><input name=”file” type=”file”></div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;"><input type=submit ></div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;"></form></div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">Now your simple form with a single input is <span class="skimlinks-unlinked" style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">ready.On</span> clicking submit button,you will be redirected to the page ‘<span class="skimlinks-unlinked" style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">insert.php</span>’.</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;"><strong style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Step 2:Create a file <span class="skimlinks-unlinked" style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">insert.php</span></strong></div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;"><?php</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">$allowedExts = array(“gif”, “jpeg”, “jpg”, “png”);//you can add more extensions if required</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">$temp = explode(“.”, $_FILES[“file”][“name”]);</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">$extension = end($temp);</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">if ((($_FILES[“file”][“type”] == “image/gif”)</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">|| ($_FILES[“file”][“type”] == “image/jpeg”)</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">|| ($_FILES[“file”][“type”] == “image/jpg”)</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">|| ($_FILES[“file”][“type”] == “image/pjpeg”)</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">|| ($_FILES[“file”][“type”] == “image/x-png”)</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">|| ($_FILES[“file”][“type”] == “image/png”))</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">&& ($_FILES[“file”][“size”] < 200000)</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">&& in_array($extension, $allowedExts))</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">{</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">if ($_FILES[“file”][“error”] > 0)</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">{</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">echo “Return Code: ” . $_FILES[“file”][“error”] . “<br>”;</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">}</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">else</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">{</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">echo “Upload: ” . $_FILES[“file”][“name”] . “<br>”;</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">echo “Type: ” . $_FILES[“file”][“type”] . “<br>”;</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">echo “Size: ” . ($_FILES[“file”][“size”] / 1024) . ” kB<br>”;</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">echo “Temp file: ” . $_FILES[“file”][“tmp_name”] . “<br>”;</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">if (file_exists(“upload/” . $_FILES[“file”][“name”]))</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">{</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">echo $_FILES[“file”][“name”] . ” already exists. “;</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">}</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">else</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">{</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">$imgpath=”upload/” . $_FILES[“file”][“name”];</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">move_uploaded_file($_FILES[“file”][“tmp_name”],</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">“upload/” . $_FILES[“file”][“name”]); //storing image into upload folder</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">echo “Stored in: ” . “upload/” . $_FILES[“file”][“name”]; //displaying the path</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">}</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">}</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">}</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">else //matching the extensions</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">{</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">echo “Invalid file”;</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">}</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">//here starts the database</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">$con=mysqli_connect(“localhost”,”root”,”password”,”databasename”);</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">// Check connection</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">if (mysqli_connect_errno())</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">{</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">echo “Failed to connect to MySQL: ” . mysqli_connect_error();</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">}</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">//query starts here</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">$imgpath=”admin/upload/” . $_FILES[“file”][“name”];//image path stored in variable imgpath</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">$query=”insert into tablename(imgpath) values(‘$imgpath’)”; //sql query to upload path to table</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">//query ends here</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">if (!mysqli_query($con,$query))</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">{</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">die(‘Error: ‘ . mysqli_error($con));</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">}</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">echo “1 record added”;</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">mysqli_close($con);</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">?></div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">Note1:All the lines after “//” is a comment line and need not insert it in the <span class="skimlinks-unlinked" style="border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">script.It</span> is only for your understanding</div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;"><strong style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Note2:You should create a folder “upload” in the same directory</strong></div><div style="background-color: white; border: 0px; color: #111111; font-family: Verdana, sans-serif; font-size: 13px; margin-bottom: 1.615em; outline: 0px; padding: 0px; vertical-align: baseline;">Done..!!now you can enjoy uploading photos smoothly and have fun.</div></div></div>