I want to upload images to my database, these can be done using php and mysqli . The form contains some information like file descriptiopn and input file and when i submit the file the file will automatically enters in to the database and the image will be stored in a directoy (my default directory uploads). After SUbmit i can edit and delete the information and images in the db and the changes keep saved.

Please help me thanq

Please help me thanq

Any specific issue, or are you just looking for a ready-made script?

i want this to learn also can someone provide links for this so i can also study the code :)

Add record – Insert sql query
List record - Select sql query
Edit record - update sql query
Delete record - delete sql query
w3schools.com is the best site to learn these things.

ready-made script or a tutorial to do that

Could be a nice one for our tutorial section though.

Hi i am uploading images to a folder and also the path to database can anyone please tell me how to fetch those images and text from the database.



    $ece_title= $_POST['ece_title'];
    $designation= $_POST['designation'];
    $qualification= $_POST['qualification'];
    $experience= $_POST['experience'];

    $repl= $_POST['repl'];


    $allowedExts = array("jpg", "jpeg", "gif", "PNG", "png", "bmp");
    $extension = end(explode(".", $_FILES["clogo"]["name"]));

    if (is_uploaded_file($_FILES["clogo"]["tmp_name"])) {
        //echo "Type: " .$_FILES["clogo"]["type"]. "<br>";
        if ((($_FILES["clogo"]["type"] == "image/gif") || ($_FILES["clogo"]["type"] == "image/jpeg") || ($_FILES["clogo"]["type"] == "image/png") || ($_FILES["clogo"]["type"] == "image/pjpeg")) && in_array($extension, $allowedExts)){
        //&& ($_FILES["clogo"]["size"] < 20000)
          if ($_FILES["clogo"]["error"] > 0)
            //echo "Return Code: " . $_FILES["clogo"]["error"] . "<br />";
            $msg= "Return Code: " . $_FILES["clogo"]["error"] . "<br />";
            if (file_exists("upload/" . $_FILES["clogo"]["name"]) && $repl<>1)
              //echo $_FILES["clogo"]["name"] . " already exists. ";    
              $msg = $_FILES["clogo"]["name"] . " already exists. ";    
                move_uploaded_file($_FILES["clogo"]["tmp_name"], "upload/" . $_FILES["clogo"]["name"]);
                //echo "Campus Fest added Successfully.<br>";
          $msg= "Invalid file";
          //echo "Invalid file";
        $QUERY= "insert into ece_faculty (title, image, designation, qualification, experience)".
                " values ('" .escapeChar($ece_title). "','" .escapeChar($logo_image). "', '" .escapeChar($designation). "',".
                "'" .escapeChar($qualification). "', '" .escapeChar($experience). "')";
        //echo "Query:$QUERY<br><br>";
        $result = mysql_query($QUERY);
        $ece_title= "";
        $logo_image= "";
        $designation= "";
        $qualification= "";
        $experience= "";
        $msg= "Facutly Details Added Successfully.<br>";
//      $msg.= "Query: $QUERY";