PHP-PDO-to-Mysqli Conversion (FileUpload-FileDownload)

-

i have code upload file , download file in pdo. want convert mysqli. don't know how do.it's confusing me.

please me , convert pdo code mysqli code.

 

upload.php

 

<!doctype html public "-//w3c//dtd html 4.01 transitional//en">

<b></b><html>

    <head>

        <title>file upload utility</title>

    </head>

    <body>

        <?php

        if(isset($_post['cmdsubmit']) && $_files['userfile']['size'] > 0) {

            extract( $_post );

            $filename = $_files['userfile']['name'];

            $tmpname  = $_files['userfile']['tmp_name'];

            $filesize = $_files['userfile']['size'];

            $filetype = $_files['userfile']['type'];

  

 

   

   

 

 

           // move_uploaded_file ($tmpname, "/temp/$filename");

           // $tmpname = "/temp/$filename";

 

 

#$tmpname="c:/tmp/test.txt";

           // echo "<h1>opening: $tmpname </h1>";

 

 

            $fp      = fopen($tmpname, 'r');

            $content = fread($fp, filesize($tmpname));

# $content = addslashes($content);

            fclose($fp);

  if(!get_magic_quotes_gpc()) {

                $filename = addslashes($filename);

            }

 

            $dsn = 'mysql:dbname=test;host=localhost;port=3306';

            $user= 'root';

            $password='';

 

 

            try {

                $dbh = new pdo($dsn, $user, $password);

 

 

                $insertsql = $dbh->prepare(

                        "insert documents (email, full_name, file_name, " .

                            "file_size, file_bytes, file_type, received) values (?,?,?,?,?,?,sysdate())")

                        or die ($mysqli->error);

 

 

                $insertsql->bindparam(1, $email, pdo::param_str, 60);

                $insertsql->bindparam(2, $fullname, pdo::param_str, 60);

                $insertsql->bindparam(3, $filename, pdo::param_str, 60);

                $insertsql->bindparam(4, $filesize, pdo::param_int, 60);

                $insertsql->bindparam(5, $content, pdo::param_str, $filesize);

                $insertsql->bindparam(6, $filetype, pdo::param_str, 60);

 

 

               // echo "<h1>about upload $filename database! $filesize</h1>";

                $insertsql->execute() or die ("<p>upload error: $insertsql->error</p>");

            } catch (pdoexception $e) {

                die ('connection failed: '.$e->getmessage());

            }

 

 

            echo "<br>file $filename uploaded<br>";

        }

        ?>

        <a href="files.php">return file list</a>

    </body>

</html>

 

 

 

download.php

 

<?php

//include("database.php");

 

 

$fileid = $_get["fileid"];

$sql = "select file_type, file_name, file_size, file_bytes documents file_id = ?";

 

 

$conn = mysqli_connect("localhost","root");

mysqli_select_db($conn,"test");

 

 

 

 

  $dbh = new pdo($dsn,$user);

  $stmt = $dbh->prepare($sql) or die(implode(':',$stmt->errorinfo()));

  $stmt->bindparam(1,$fileid,pdo::param_int,60);

  $stmt->execute() or die(implode(':',$stmt->errorinfo()));

  $cols = $stmt->columncount();

 

  $row = $stmt->fetch();

  header("content-type: $row[0]");

  header("content-length: $row[2]");

  header("content-disposition: attachment; filename = $row[1]");

  print $row[3];

 

 

 

 

 

 

?>

please me



More discussions in Dreamweaver support forum


adobe

Comments

Post a Comment

Popular posts from this blog

Illustrator CS6 Ocurrío un error E/S en el archivo.

-
este error me me sale cada ves que guardo un archivo que ya estado trabajando varias veces, sale cuando ya esta finalizando el proceso de guardar, ya probe cambiar nombre del archivo, ubicación de guardado, convertí curvas las fuentes y sigue saliendo el mismo error, no se que mas hacer, si alguien le ha sucedido y sabe como solucionarlo por favor ayuda. versión exacta (acerca de illustrator) de illustrator? versión sistema operativo?   guardas en el disco duro principal del ordenador o en otro disco, memoria pendrive,...? ese disco que clase de disco, modelo, antiguedad, espacio libre,...? More discussions in Foro en español adobe
Read more

Why is os_ViewContainer running?

-
when open illustrator (cc) opens window os_viewcontainer cannot view or close. shows in taskbar second window illustrator when mousing on ai icon. have tried select no luck. have tried clear using red x, no luck. close when close illustrator. wondering why there , if should concerned. oh, running windows 10. hi ccsachs,   as per query when launch illustrator opens " os_viewcontainer "   i request please share screenshots along below-mentioned details:   exact version of illustrator  graphic card using , when updated last time how performs in safe mode? ( https://support.microsoft.com/en-in/help/12376/windows-10-start-your-pc-in-safe-mode ) if works fine in safe mode please share antivirus using?   regards srishti More discussions in Illustrator adobe
Read more

Animate - problem with duplicating scripts after loop

-
hi all,   i have problem simple button script @ first frame. fine when timeline playing first time. after when timeline loops , stop again @ 0 frame button script fireing 2 times, when loops third time fireing 3 times etc...   here script:   this.stop(); exportroot.mc_cta.cursor = "pointer";   this.mc_cta.on("click", clickfunc.bind(this));   function clickfunc() {     console.log("clicked");     eb.useractioncounter("clicked");     exportroot.gotoandplay(1); }   anybody ideas? wrong?   thanks! kris use:   this.stop(); exportroot.mc_cta.cursor = "pointer";   if(!this.alreadyexecuted){ this.alreadyexecuted=true; this.mc_cta.on("click", clickfunc.bind(this));   function clickfunc() { console.log("clicked"); eb.useractioncounter("clicked"); exportroot.gotoandplay(1); } } More discussions in Adobe Animate CC - General adobe
Read more