CODEWITHSUNDEEP
phpsqlupload
Hoàng Nhật
Hoàng Nhật

Reputation: 33

upload file to sql sever with php

I try to upload file to a database by using php. Here is my code:

    <?php
$servername = "localhost";
$username = "root";
$password = "";
$db ='testdb';
// Create connection
mysql_connect($servername, $username, $password);
mysql_select_db("testdb");

    if(isset($_POST['submit']))
    {
        $UploadName = $_FILES['UploadFileField']['name'];       
        $UploadTmp =  $_FILES['UploadFileField']['tmp_name'];       
        $UploadName = preg_replace("#[^a-z0-9.]#i","",$UploadName);
        if (!$UploadTmp)
         {
            die ("No File Selected, Please Upload Again");          
         } else
         {
            move_uploaded_file($UploadTmp,"uploaded/$UploadName");      
            $url = "http://localhost/uploadandview/uploaded/$UploadName";           
            mysql_query("INSERT INTO `videos` VALUE('1','$UploadName','$url')");           
          }}?>

But i have a proplem, I can't upload any file mp3/mp4, just only upload file text, such as .doc,pdf, css, etc... Please help me!

Upvotes: 0

Views: 74

Answers (1)

Divyesh
Divyesh

Reputation: 329

Try this code 

   <?php
$servername = "localhost";
$username = "root";
$password = "";
$db ='testdb';
// Create connection
mysql_connect($servername, $username, $password);
mysql_select_db("testdb");

    if(isset($_POST['submit']))
    {
        $UploadName = $_FILES['UploadFileField']['name'];       
        $UploadTmp =  $_FILES['UploadFileField']['tmp_name'];       
        $UploadName = preg_replace("#[^a-z0-9.]#i","",$UploadName);
        if (!$UploadTmp)
         {
            die ("No File Selected, Please Upload Again");          
         } else
         {
            move_uploaded_file($UploadTmp,"uploaded/".$UploadName);      
            $url = "http://localhost/uploadandview/uploaded/".$UploadName;           
            mysql_query("INSERT INTO `videos` VALUE('1','$UploadName','$url')");           

      }} ?>

Upvotes: 1

Related Questions