Page 1 of 1

HELP WITH WEBCAM+PHP+SQL+PDF

Posted: Tue Dec 03, 2013 7:35 pm
by naverus
Hello I hope someone can help me

I'm doing an example with a web cam in php and sql and order form and send it to a pdf to print, my problem is I can not get the picture, and only passes the address of the image and repeated twice the extension ". jpg "and make as a link in the pdf.
i dont now what is my problem.


This are the example of my code.

***** Please user the PHP Code tag *****

this are my database sql

/////////////////////////////////////// database sql /////////////////////////////////////////////////

Code: Select all

--
-- Estructura de tabla para la tabla `fotos`
--

CREATE TABLE IF NOT EXISTS `fotos` (
  `id_foto` varchar(20) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `des` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
//////////////////////// FIN DE BASE DE DATOS /////////////////////////////////////////////////



this are my code of: clase_conexion.php.php

/////////////////////////////////////// CONEXION /////////////////////////////////////////////////

Code: Select all

<?php
class conexion{
var $serv="localhost";
var $usuario="*******";
var $contra="******";
var $conexi;
function conecta()
{
$s=$this->serv;
$u=$this->usuario;
$c=$this->contra;
$conex=mysql_connect($s,$u,$c);
$this->conexi=$conex;
}

}
$cono= new conexion();
$cono->conecta();
$c=$cono->conexi;
$select=mysql_select_db("progresa_webcam",$c);
?>



///////////////////////////////////End of conexion/////////////////////////////////////////////



this are my code of:: index.php

/////////////////////////////////////// INDEX /////////////////////////////////////////////////

Code: Select all

<style type="text/css">

/* jQuery lightBox plugin - Gallery style */

#cuadro_camara {

background-color: #444;

padding-left: 30px;

padding-top:20px;

}

#titulo_camara {

background-color: #666;

color:#FFF;

padding-left: 30px;

font-size: 14px;

text-align:center;

}

.botones_cam {

background-color:#FFF;

color:#333;

font-family: "Comic Sans MS", cursive;

font-size:14px;

margin-top:10px;

width:120px;

height:40px;

}

.formulario {

color: #FFF;

}



</style>

<script type="text/javascript" src="jquery-1.6.2.min.js"></script>

<script type="text/javascript" src="jquery.lightbox-0.5.js"></script>

<link rel="stylesheet" type="text/css" href="jquery.lightbox-0.5.css" media="screen" />

<script type="text/javascript" src="webcam.js"></script>

    <script language="JavaScript">

webcam.set_api_url( 'test.php' );//PHP adonde va a recibir la imagen y la va a guardar en el servidor

webcam.set_quality( 90 ); // calidad de la imagen

webcam.set_shutter_sound( true ); // Sonido de flash

</script>

<script language="JavaScript">

webcam.set_hook( 'onComplete', 'my_completion_handler' );



function do_upload() {

// subir al servidor

document.getElementById('upload_results').innerHTML = '<h1>Cargando al servidor...</h1>';

webcam.upload();

}



function my_completion_handler(msg) {



if (msg.match(/(http\:\/\/\S+)/)) {

var image_url = RegExp.$1;//respuesta de text.php que contiene la direccion url de la imagen



// Muestra la imagen en la pantalla

document.getElementById('upload_results').innerHTML = 

'<img src="' + image_url + '">'+

'<form action="gen.php" method="post">'+
                    

'<input type="hidden" name="id_foto" id="id_foto" value="'+ image_url + '"  /><br>'+

'<tr><td><label>Nombre</td><td></label><input type="text" name="nombre" id="nombre"/></td></tr><br />'+

'<tr><td><label>Descripcion</label></td><td><input type="text" name="des" id="des"/></td></tr>'+

//'<label>Escuelas</label><select name="select" id="select"><option value="casa">casa</option><option value="casa2">casa2</option><option value="casa3">casa3</option></select>'+

   '<input type="submit" name="button" id="button" value="Enviar" /></form>';

// reset camera for another shot

webcam.reset();

}

else alert("PHP Error: " + msg);

}

</script>

<div align="left" id="cuadro_camara">    



<table width="100%" height="144"><tr><td width="124" valign=top>

<form>

<input type=button value="Configurar Camara" onClick="webcam.configure()" class="botones_cam">

&nbsp;&nbsp;

<input type=button value="Tomar foto" onClick="webcam.freeze()" class="botones_cam">

&nbsp;&nbsp;

<input type=button value="Subir" onClick="do_upload()" class="botones_cam">

&nbsp;&nbsp;

<input type=button value="Borrar" onClick="webcam.reset()" class="botones_cam">

</form>



</td>

    <td width="212" valign=top>

<script language="JavaScript">

document.write( webcam.get_html(320, 240) );//dimensiones de la camara

</script>

    </td>

    <td width=370>

   <div id="upload_results" class="formulario" > </div>

  </td></tr></table><br /><br />

</div>







<br />

<br />

<script type="text/javascript">

    $(function() {

        $('#gallery a').lightBox();//Galeria jquery

    });

    </script>

    <style type="text/css">

/* jQuery lightBox plugin - Gallery style */

#gallery {

background-color: #444;

width: 100%;

}

#gallery ul { list-style: none; }

#gallery ul li { display: inline; }

#gallery ul img {

border: 5px solid #3e3e3e;

border-width: 5px 5px 5px;

}

#gallery ul a:hover img {

border: 5px solid #fff;

border-width: 5px 5px 5px;

color: #fff;

}

#gallery ul a:hover { color: #fff; }

</style>

    

    <div id="gallery">

    <ul>

  <?php  

  

  include("clase_conexion.php");

  $consulta="select * from fotos order by id_foto desc";

  $busca_fotos=mysql_query($consulta,$c);

  while($row=mysql_fetch_array($busca_fotos)){


   $url=$row['id_foto'];  

   $nombre=$row['nombre']; 

     $des=$row['des'];

     echo "<li>

            <a href=\"fotos/".$url.".jpg\" title=\"<a href=ver.php?nombre=".$nombre." ['id'] target='_blank'>Informacion del Alumno\">

            <img src=\"fotos/".$url.".jpg\" width=\"150\" height=\"120\" alt=\"\" /></a>

        </li>";

  }

?>    

    </ul>

</div>
///////////////////////////////////END INDEX/////////////////////////////////////////////


this are my code of: ver.php


/////////////////////////////////////// SEE/////////////////////////////////////////////////

Code: Select all

<?php 
 // Connects to your Database 
 include("clase_conexion.php");
 $consulta = mysql_query("SELECT id_foto, nombre, des FROM fotos WHERE nombre like'%".$_GET["nombre"]."%'
or id_foto like'%".$_GET["nombre"]."%'") 
 or die(mysql_error()); 
  $info = mysql_fetch_array( $consulta );
  
  $url=$info['id_foto'];  
   $nombre=$info['nombre']; 
     $des=$info['des'];
  
     
 echo "<b>Nombre</b> ".$info['nombre'] . " <br>"; 
 echo "<b>Descripcion</b> ".$info['des'] . " <br>";
 echo"<img src = \"fotos/".$info['id_foto'].'.jpg  "height=100 width=100"'."\" />";
 //echo "<a href=gen.php?id_foto=.$url ['id_foto ']target='_blank'>Imprimir Credencial del Alumno\>";
 echo"<a href='#'>hola</a>";

 ?> 
///////////////////////////////////END OF SEE/////////////////////////////////////////////


this are my code of: gen.php


/////////////////////////////////////// GEN /////////////////////////////////////////////////

Code: Select all

<?php
/* incluimos primeramente el archivo que contiene la clase fpdf */
include ('pdf/fpdf.php');
   /* tenemos que generar una instancia de la clase */
        $pdf = new FPDF();
        $pdf->AddPage();

/* seleccionamos el tipo, estilo y tamaño de la letra a utilizar */
        $pdf->SetFont('Helvetica', 'B', 14);
$pdf->Write (7,"...");
$pdf->Ln();
$pdf->Write(7,$_POST['id_foto'].'.jpg' );
$pdf->Ln(); //salto de linea
$pdf->Cell(60,7,$_POST['nombre'],1,0,'C');
$pdf->Ln(15);//ahora salta 15 lineas 
$pdf->SetTextColor('255','0','0');//para imprimir en rojo 
$pdf->Multicell(190,7,$_POST['des']."...",1,'R');
$pdf->Line(0,160,300,160);//impresión de linea
        $pdf->Output("prueba.pdf",'F');
echo "<script language='javascript'>window.open('prueba.pdf','_self','');</script>";//para ver el archivo pdf generado
exit;
?>
///////////////////////////////////END OF GEN/////////////////////////////////////////////


i dont now where is the problem i understand what happend pls help me

Re: HELP WITH WEBCAM+PHP+SQL+PDF

Posted: Wed Dec 04, 2013 9:47 pm
by Christopher
That is a lot of code! What part of the code is not working?