database - Issue Upload Image in Folder using PHP -


i'm struggling how upload picture in folder called uploads , insert name of image in database. know how make work? thanks

index.php

<form action="index.php" method="post" enctype="multipart/form-data">      select image upload:      <input type="file" name="image" id="image">     <input type="submit" value="upload image" name="submit"> </form>

upload.php

// connect localhost project 1 $host = 'localhost'; $db = 'pju2173'; $user = 'pju2173'; $pwd = 'fr1end';  try{     $dbh = new pdo("mysql:host=$host;dbname=$db", $user, $pwd);     $dbh->setattribute(pdo::attr_errmode, pdo::errmode_exception); } catch(pdoexception $e){     return 'connection failed: ' . $e->getmessage(); } if(isset($_post['submit'])){     $image = $_files['image']['name'];     $target_dir = "uploads/";     $target_file = $target_dir . basename($_files['image']['name']);     $imagefiletype = pathinfo($target_file, pathinfo_extension);     // move_uploaded_file($_files['image']['tmp_name'], $target_file);     move_uploaded_file($_files['image']['tmp_name'], $target_file.time().$image);      $query = "insert imagetable(image) values(:image)";     $stmt = $dbh->prepare($query);     $stmt->bindparam(":image", $image);     $result = $stmt->execute();     if($result){         echo "uploaded";     }     else{         echo "something wrong";     } }

this possible helps

http://www.w3schools.com/php/php_file_upload.asp

complete upload file php script

<?php $target_dir = "uploads/"; $target_file = $target_dir . basename($_files["filetoupload"]["name"]); $uploadok = 1; $imagefiletype = pathinfo($target_file,pathinfo_extension); // check if image file actual image or fake image if(isset($_post["submit"])) {     $check = getimagesize($_files["filetoupload"]["tmp_name"]);     if($check !== false) {         echo "file image - " . $check["mime"] . ".";         $uploadok = 1;     } else {         echo "file not image.";         $uploadok = 0;     } } // check if file exists if (file_exists($target_file)) {     echo "sorry, file exists.";     $uploadok = 0; } // check file size if ($_files["filetoupload"]["size"] > 500000) {     echo "sorry, file large.";     $uploadok = 0; } // allow file formats if($imagefiletype != "jpg" && $imagefiletype != "png" && $imagefiletype != "jpeg" && $imagefiletype != "gif" ) {     echo "sorry, jpg, jpeg, png & gif files allowed.";     $uploadok = 0; } // check if $uploadok set 0 error if ($uploadok == 0) {     echo "sorry, file not uploaded."; // if ok, try upload file } else {     if (move_uploaded_file($_files["filetoupload"]["tmp_name"], $target_file)) {         echo "the file ". basename( $_files["filetoupload"]["name"]). " has been uploaded.";     } else {         echo "sorry, there error uploading file.";     } } ?>

Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more