el problema es que borre una tabla de la base de datos esta es la tabla que volvi a crear `id` int(11) NOT NULL auto_increment, `page` text NOT NULL, `date` text NOT NULL, `title` text NOT NULL, `description` longtext NOT NULL, `file` blob NOT NULL, `file_name` text NOT NULL, `file_type` text NOT NULL, `file_size` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ;
al volverla a crear no funciona la pagina como debe de funcionar
este script llena la tabla que borre <?php
if ($_FILES) { $file_types = Array ("application/pdf");
$userfile = addslashes (fread (fopen ($_FILES["pdf"]["tmp_name"], "r"), filesize ($_FILES["pdf"]["tmp_name"]))); $file_name = $_FILES["pdf"]["name"]; $file_size = $_FILES["pdf"]["size"]; $file_type = $_FILES["pdf"]["type"]; $date = $_REQUEST["date"]; $month = substr ($date, 0, 2); $year = substr ($date, 2, 2); $date = $year.$month; $page = $_REQUEST["page"]; $title = htmlspecialchars($_REQUEST["title"]); $description = htmlspecialchars($_REQUEST["description"]); $description = nl2br ($description); if (in_array (strtolower ($file_type), $file_types)) { require_once "script.db.php"; $sql = "INSERT INTO articles (date, page, title, description, file, file_name, file_type, file_size) "; $sql.= "VALUES ("; $sql.= "'{$date}', '{$page}', '{$title}', '{$description}', '{$userfile}', '{$file_name}', '{$file_type}', '{$file_size}')"; mysql_query ($sql, $presencia); mysql_close($presencia); } }else {echo "file not uploaded";} header ("Location: article_add.php"); ?>
este scipt es el que me abre como script en logar de como pdf
<?php // database connection require_once "script.db.php"; $id = $_REQUEST["id"];
//begin database consult $sql = "SELECT file, file_name, file_size, file_type FROM articles WHERE id=$id"; $result = mysql_query($sql, $presencia); //end database consult
//begin image creation if (mysql_num_rows ($result)>0) { $row = @mysql_fetch_array ($result); $file_type = $row["file_type"]; $file = $row["file"]; Header ("Content-type: $file_type"); print $file; // diplay image } //end image creation mysql_free_result($result); mysql_close ($presencia); ?>
|
Por oui55555
Envíale un mensaje privado
|