HELP WITH WEBCAM+PHP+SQL+PDF

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
naverus
Forum Newbie
Posts: 1
Joined: Tue Dec 03, 2013 7:32 pm

HELP WITH WEBCAM+PHP+SQL+PDF

Post 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
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: HELP WITH WEBCAM+PHP+SQL+PDF

Post by Christopher »

That is a lot of code! What part of the code is not working?
(#10850)
Post Reply