#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2013
    Posts
    1
    Rep Power
    0

    Help with webcam+php+sql+pdf


    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.

    example...
    institutouniversitarioprogresa.edu.mx/omar/


    this are my database sql

    Code:
    --
    -- 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;

    this are my code of: clase_conexion.php.php

    PHP Code:
    <?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);
    ?>
    this are my code of:: index.php

    Code:
    <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>

    this are my code of: ver.php
    PHP Code:
    <?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>";

     
    ?>

    this are my code of: gen.php
    PHP Code:
    <?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;
    ?>
    i dont now where is the problem i understand what happend pls help me
    Last edited by requinix; December 3rd, 2013 at 09:32 PM. Reason: bbcode tags
  2. #2
  3. --
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Jul 2012
    Posts
    3,920
    Rep Power
    1045
    Cross-posted here.

    I think my motivation to wade through 500 lines of completely unprotected Spanish spaghetti code from the 90s just dropped to zero.

    If you want help, it might be a good idea to make it easy to help. Do some basic debugging yourself, reduce the problem, explain it. For example, you said you get a double ".jpg" extension. Why do you add this extension in the first place? Doesn't $_POST['id_foto'] already contain the full URL? If not, where does the second extension come from etc.

    And your code is wide open to attacks, which means your server is in danger right now. But I guess you don't care ...
    The 6 worst sins of securityHow to (properly) access a MySQL database with PHP

    Why can’t I use certain words like "drop" as part of my Security Question answers?
    There are certain words used by hackers to try to gain access to systems and manipulate data; therefore, the following words are restricted: "select," "delete," "update," "insert," "drop" and "null".

IMN logo majestic logo threadwatch logo seochat tools logo