A Flash Developer Resource Site

Page 1 of 2 12 LastLast
Results 1 to 20 of 30

Thread: [RESOLVED] Php And Flash

  1. #1
    Senior Member byweb's Avatar
    Join Date
    Apr 2007
    Location
    Andalucia (spain)
    Posts
    267

    resolved [RESOLVED] Php And Flash

    Hello everybody, before at all happy Christmas and happy new year for all.
    I have a system of news made done with php and MySql you can see it here But I want that it shows it in flash and not in php.
    My code php is
    Code:
    <?php
    $conn = mysql_connect("localhost","","");
    mysql_select_db("es_db",$conn);
    $ssql = "SELECT * FROM noticias";
    $ssql .= " ORDER BY id desc";
    $resultid = mysql_query($ssql,$conn);
    $n = 0;
    while ($damefila=mysql_fetch_object($resultid)) {
     echo "&titulo$n = strip_tags($damefila->titulo) &fecha$n = strip_tags($damefila->fecha)";
     echo "&mensaje$n = strip_tags($damefila->mensaje) &foto$n = strip_tags($damefila->foto)";
     $n++;
    }
    echo "&num_filas = $n";
    ?>
    With KollMoves I have created a mc with three dynamic text and a holder for the image. In the first one frame of this I have put this code:
    Code:
     function cargar_datos_php() {       
          mensaje.text = "...recibiendo datos";
          noticias_lv = new LoadVars();
          noticias_lv.sendAndLoad("mostrar.php");
          noticias_lv.onLoad = function() {
                //recibimos los datos de mostrar.php//
                titulo.text = this[titulo+n];
                fecha.text = this[fecha+n];
                mensaje.text = this[mensaje+n];
                scr.loadMovie(this[foto+n]);
           };
     }
    cargar_datos_php();
    stop();
    But it not work. Which is the error, which exists I begin badly. Can your help me. you can to see it here.Thanks.

  2. #2
    KoolMoves Moderator blanius's Avatar
    Join Date
    Jul 2001
    Location
    Atlanta GA
    Posts
    5,244
    mostly looks right but why the +n? I would expect that if you where looping through some variable n

    try
    noticias_lv.onLoad = function() {
    //recibimos los datos de mostrar.php//
    for (n=0;n<=this.num_filas;n++){
    titulo.text = this[titulo+n];
    fecha.text = this[fecha+n];
    mensaje.text = this[mensaje+n];
    scr.loadMovie(this[foto+n]);
    }//end for loop
    };
    Last edited by blanius; 12-14-2007 at 02:04 PM.

  3. #3
    KoolMoves Moderator blanius's Avatar
    Join Date
    Jul 2001
    Location
    Atlanta GA
    Posts
    5,244
    Did this help?

  4. #4
    Senior Member byweb's Avatar
    Join Date
    Apr 2007
    Location
    Andalucia (spain)
    Posts
    267
    Since the truth is that not. I have not achieved that it works. I have done everything as I indicate myself and it does not work if you wishes it one can see the fun file. Thank you for yours interest.
    Attached Files Attached Files

  5. #5
    KoolMoves Moderator blanius's Avatar
    Join Date
    Jul 2001
    Location
    Atlanta GA
    Posts
    5,244
    Ok two problems so far

    1) you are calling the load before declaring the onLoad function
    2) you are using sendAndLoad but not sending anything try just load
    3) Your PHP is wrong. I see strip_tags in the data.
    4) while Lycos is allowing PHP it's adding HTML text to the response sent.

    Look at what you get when you call the php directly:
    http://usuarios.lycos.es/bywebpruebas/mostrar.php
    gets you
    Code:
    <div id="a60a2cc14" style="text-align: center; margin: 0px; padding: 0px;" align="center"></div>
    <script>
    x6f37e8c46cd = "loranger-chand-cristofe";
    src7f683a26="http://ads.tripod.lycos.es/ad/google/frame.php?_url="+escape(self.location)+"&gg_bg=&gg_template=&mkw=&cat=noref";
    function srcIframe7f683a26(src, width) {if (document.getElementsByTagName("div")[0]) {document.getElementsByTagName("div")[0].id = "a60a2cc14";}return '<iframe id="f7f683a26" src="'+src+'" height="95" width="'+width+'" frameborder="0" marginwidth="0" marginheight="0" allowtransparency="true"></iframe>';}x33f1396b498 = new Array();function x71d616146a8(xfa39b0cfbaf, x7325e11c556) {x838ee4625c5 = new String(x7325e11c556);xc3605d47cee = x838ee4625c5.substr(0,x838ee4625c5.indexOf('px')) * 1 + 95;
    if (xfa39b0cfbaf.style.top == "" && !xfa39b0cfbaf.style.marginTop) {xfa39b0cfbaf.style.marginTop = "0px";xfa39b0cfbaf.style.paddingTop = "0px";}if ((x838ee4625c5.substr(0,x838ee4625c5.indexOf('px')) * 1 < 95) || (!x33f1396b498[xfa39b0cfbaf]) ) {xc3605d47cee = (xc3605d47cee<95) ? 95 : xc3605d47cee ;xfa39b0cfbaf.style.top = xc3605d47cee+"px" ;x33f1396b498[xfa39b0cfbaf] = 1 ;}}function checkGoogle7f683a26(width) {if (!document.getElementsByTagName("iframe")[0] || document.getElementsByTagName("iframe")[0].src != src7f683a26) {window.location.href="http://www.tripod.lycos.es";}x7280676f72a = new Array();x99cf756feb0 = new Array();x7280676f72a["a60a2cc14"] = new Array();x99cf756feb0["a60a2cc14"] = new Array();x7280676f72a["f7f683a26"] = new Array();x99cf756feb0["f7f683a26"] = new Array();x7280676f72a["a60a2cc14"][0] = "style.display" ;x99cf756feb0["a60a2cc14"][0] = "block" ;x7280676f72a["a60a2cc14"][1] = "style.height";x99cf756feb0["a60a2cc14"][1] = "95px";x7280676f72a["a60a2cc14"][2] = "style.width";x99cf756feb0["a60a2cc14"][2] = width+"px";x7280676f72a["a60a2cc14"][3] = "style.visibility";x99cf756feb0["a60a2cc14"][3] = "visible";x7280676f72a["a60a2cc14"][4] = "style.margin";x99cf756feb0["a60a2cc14"][4] = "0px";x7280676f72a["f7f683a26"][0] = "style.display" ;x99cf756feb0["f7f683a26"][0] = "block" ;x7280676f72a["f7f683a26"][1] = "style.height";x99cf756feb0["f7f683a26"][1] = "95px";x7280676f72a["f7f683a26"][2] = "style.width";x99cf756feb0["f7f683a26"][2] = width+"px";x7280676f72a["f7f683a26"][3] = "style.visibility";x99cf756feb0["f7f683a26"][3] = "visible";x7280676f72a["f7f683a26"][4] = "style.margin";x99cf756feb0["f7f683a26"][4] = "0px";for (var j in x7280676f72a) {for (i = 0 ; i < x7280676f72a[j].length ; i++) {if (!eval('document.getElementById("'+j+'")')) {break;}if (eval('document.getElementById("'+j+'").'+x7280676f72a[j][i]+' != "'+x99cf756feb0[j][i]+'"')) {eval('document.getElementById("'+j+'").'+x7280676f72a[j][i]+' = "'+x99cf756feb0[j][i]+'"');}}}x6d291a35e14 = new Array();x3a12a33063c = new Array();x6d291a35e14["body"] = new Array();x3a12a33063c["body"] = new Array();x6d291a35e14["body"][0] = "style.marginTop";x3a12a33063c["body"][0] = "0px" ;x6d291a35e14["body"][1] = "style.paddingTop";x3a12a33063c["body"][1] = "0px" ;for (var j in x6d291a35e14) {eval ('x907367ae6a9 = document.getElementsByTagName("'+j+'");');for (k = 0 ; k < x907367ae6a9.length ; k++) {for (i = 0 ; i < x6d291a35e14[j].length ; i++) {if (!eval('document.getElementsByTagName("'+j+'")')) {break;}if (eval('document.getElementsByTagName("'+j+'")['+k+'].'+x6d291a35e14[j][i]+' != "'+x3a12a33063c[j][i]+'"')) {eval('document.getElementsByTagName("'+j+'")['+k+'].'+x6d291a35e14[j][i]+' = "'+x3a12a33063c[j][i]+'"');}}}}x907367ae6a9 = document.getElementsByTagName("div");for (i = 0 ; i < x907367ae6a9.length ; i++) {if (document.all) {if ( (x907367ae6a9[i].currentStyle.position == "absolute") || (x907367ae6a9[i].currentStyle.position == "fixed") ) {x71d616146a8(x907367ae6a9[i], x907367ae6a9[i].offsetTop + "px");}}else {if ( (document.defaultView.getComputedStyle(x907367ae6a9[i], '').getPropertyValue("position") == "absolute") || (document.defaultView.getComputedStyle(x907367ae6a9[i], '').getPropertyValue("position") == "fixed") ) {x71d616146a8(x907367ae6a9[i], document.defaultView.getComputedStyle(x907367ae6a9[i], '').getPropertyValue("top"));}}}setTimeout("checkGoogle7f683a26("+width+")", 500);}
    function displayGoogleAd7f683a26() {width = (document.body.clientWidth > 770) ? document.body.clientWidth : 770 ;width -= 20;content7f683a26 = srcIframe7f683a26(src7f683a26, width);if (!this.document.getElementsByTagName("frameset")[0]) {document.getElementById("a60a2cc14").innerHTML = content7f683a26;checkGoogle7f683a26(width);}}window.onload = new Function("if (x6f37e8c46cd != '7f683a26') {displayGoogleAd7f683a26();}");
    
    document.getElementsByTagName("script")[0].text = "";
    </script>
    &titulo0 = strip_tags(probando) &fecha0 = strip_tags(15/12/2007)&mensaje0 = strip_tags(heyo perro!!!) &foto0 = strip_tags(Foto 2.jpg)&titulo1 = strip_tags(Abtenerse Idiotas) &fecha1 = strip_tags(13/12/2007)&mensaje1 = strip_tags(Este ejemplo solo lo puse para que pudieseis observar como funciona este ejemplo y mejorarlo para los que pudiesen hacerlo. He visto que últimamente se utiliza solo para escribir idioteces, pronto lo quitaré. Por cierto esta nena esta mu bien....) &foto1 = strip_tags(sho!.jpg)&titulo2 = strip_tags(prueba 3) &fecha2 = strip_tags(13/12/2007)&mensaje2 = strip_tags(Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut facilisis tristique nisi. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos. Phasellus semper hendrerit lectus. Cras semper diam nec quam. Nam lectus velit, tincidunt vel, interdum sed, lacinia at, lorem. Suspendisse feugiat ligula at justo. Duis velit. Maecenas suscipit ligula eu magna. In vulputate. Proin ullamcorper tincidunt pede. Donec eu metus. Vestibulum adipiscing massa at libero. Duis eu magna. Maecenas eget turpis auctor neque euismod consectetuer. Nunc nisl neque, eleifend nec, laoreet elementum, euismod at, neque. Nulla convallis. In hac habitasse platea dictumst. Cras non dui. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos.) &foto2 = strip_tags(barcos.jpg)&titulo3 = strip_tags(Prueba 2) &fecha3 = strip_tags(13/12/2007)&mensaje3 = strip_tags(Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut facilisis tristique nisi. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos. Phasellus semper hendrerit lectus. Cras semper diam nec quam. Nam lectus velit, tincidunt vel, interdum sed, lacinia at, lorem. Suspendisse feugiat ligula at justo. Duis velit. Maecenas suscipit ligula eu magna. In vulputate. Proin ullamcorper tincidunt pede. Donec eu metus. Vestibulum adipiscing massa at libero. Duis eu magna. Maecenas eget turpis auctor neque euismod consectetuer. Nunc nisl neque, eleifend nec, laoreet elementum, euismod at, neque. Nulla convallis. In hac habitasse platea dictumst. Cras non dui. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos.) &foto3 = strip_tags(3d (1).jpg)&titulo4 = strip_tags(Prueba De Noticia) &fecha4 = strip_tags(13/12/2007)&mensaje4 = strip_tags(Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut facilisis tristique nisi. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos. Phasellus semper hendrerit lectus. Cras semper diam nec quam. Nam lectus velit, tincidunt vel, interdum sed, lacinia at, lorem. Suspendisse feugiat ligula at justo. Duis velit. Maecenas suscipit ligula eu magna. In vulputate. Proin ullamcorper tincidunt pede. Donec eu metus. Vestibulum adipiscing massa at libero. Duis eu magna. Maecenas eget turpis auctor neque euismod consectetuer. Nunc nisl neque, eleifend nec, laoreet elementum, euismod at, neque. Nulla convallis. In hac habitasse platea dictumst. Cras non dui. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos.) &foto4 = strip_tags(20051221203729-vida-y-muerte.jpg)&num_filas = 5
    
    </pre></xmp></noscript>
    <script language="javascript" src="http://ads.tripod.lycos.es/ad/test_frame_size.js"></script>
    <script language="javascript">x6f37e8c46cd = "7f683a26";
    if (!AD_clientWindowSize()) {document.write("<NOSC"+"RIPT>");}</script>
    
    <script>displayGoogleAd7f683a26();</script>
    
    <script language="javascript" src="http://ads.tripod.lycos.es/ad/popunder_lycos_update.php?cat=noref&CC=es"></script>
    
    <script type="text/javascript" src="http://ads.tripod.lycos.es/ad/ad.php?cat=noref&mkw=&CC=es&ord=7f683a26&adpref="></script>
    <!-- START RedSheriff Measurement V5.01 -->
    <!-- COPYRIGHT 2002 RedSheriff Limited -->
    <script language="JavaScript" type="text/javascript"><!--
      var _rsCI='lycos-es';
      var _rsCG='noref';
      var _rsDT=1;
      var _rsSI=escape(window.location);
      var _rsLP=location.protocol.indexOf('https')>-1?'https:':'http:';
      var _rsRP=escape(document.referrer);
      var _rsND=_rsLP+'//secure-uk.imrworldwide.com/';
    
      if (parseInt(navigator.appVersion)>=4) {
        var _rsRD=(new Date()).getTime();
        var _rsSE=0;
        var _rsSV='';
        var _rsSM=0;
        _rsCL='<scr'+'ipt language="JavaScript" type="text/javascript" src="'+_rsND+'v5.js"><\/scr'+'ipt>';
      } else {
        _rsCL='<img src="'+_rsND+'cgi-bin/m?ci='+_rsCI+'&cg='+_rsCG+'&si='+_rsSI+'&rp='+_rsRP+'">';
      }
      document.write(_rsCL);
    //--></script>
    
    <noscript>
    <img src="//secure-uk.imrworldwide.com/cgi-bin/m?ci=lycos-es&amp;cg=noref" alt="">
    </noscript>
    <script>if (!AD_clientWindowSize()) {document.write("<NOSC"+"RIPT>");}</script>
    <!-- END RedSheriff Measurement V5 -->
    which I was able to load into a flash movie with:
    Code:
          
          
          noticias_lv = new LoadVars();
          noticias_lv.onData=function(src){
          	txt1.text=src;
          	}
         
          noticias_lv.load("http://usuarios.lycos.es/bywebpruebas/mostrar.php");
          
    
    stop();

  6. #6
    Senior Member byweb's Avatar
    Join Date
    Apr 2007
    Location
    Andalucia (spain)
    Posts
    267
    I am stubborn, do not understand it now it goes out this way
    http://www.usuarios.lycos.es/bywebpruebas/news.html

  7. #7
    KoolMoves Moderator blanius's Avatar
    Join Date
    Jul 2001
    Location
    Atlanta GA
    Posts
    5,244
    I was just using the onData to show you that it is indeed working just not quite right...

    first off you've got problems in the PHP... You should not be seening strip_tags()

    and the bigger problem is that lycos is forcing the google ads into your PHP generated page.

    There are ways to work around it but it's a little complicated.

    1) Use XMLsocket to send data only, bypassing the normal PHP output.
    OR
    2) Have your PHP genterate a little different layout and load everything in and in the onData function strip out only what you need.


    using loadVars you can get the RAW data as in the link above by using the onData function rather than the onLoad function.

    if you can generate the PHP output to be like this:
    Code:
    <data>probando|15/12/2007|heyo perro!!!|Foto 2.jpg
    Abtenerse Idiotas|13/12/2007|Este ejemplo solo lo puse para que pudieseis observar como funciona este ejemplo y mejorarlo para los que pudiesen hacerlo. He visto que �amente se utiliza solo para escribir idioteces, pronto lo quitar�Por cierto esta nena esta mu bien....|sho!.jpg</data>
    Then you could do this:
    http://bretlanius.com/flash/bywebnews.html

    with this code
    Code:
    noticias_lv = new LoadVars();
          noticias_lv.onData=function(src){
          pointer=src.indexOf("<data>");
          pointer2=src.lastIndexOf("</data>");
          mydata=src.substr(pointer+6,pointer2-6)
    
    records=new Array();
    records=mydata.split("\n")
    
    for (idx=0;idx<records.length;idx++){
    		fields = records[idx].split('|');
    		txt1.htmlText+="<B>"+fields[0]+"............."+fields[1]+"</B>";
    			txt1.htmlText+="<img src='http://usuarios.lycos.es/bywebpruebas/fotos/"+fields[3]+"' width='200' height='150' align='right'>"
    		txt1.htmlText+="<i>"+fields[2]+"</i><p><br><br><br><br><br><br>"
    		
    		}
    
    }

  8. #8
    Senior Member byweb's Avatar
    Join Date
    Apr 2007
    Location
    Andalucia (spain)
    Posts
    267
    I have used the system of news with XML and CSS, but in this work the client wants to modify it, because of it I have thought in php, I had an application that was generating a news in php and the only thing that it is to give exit in flash. If you have noticed in
    http://usuarios.lycos.es/bywebpruebas/
    it can introduce the information, then this news And then it goes out generated in to show news. You can try it if yuu wish it. I am going to try your code.Thank you.
    Last edited by byweb; 12-23-2007 at 08:19 AM.

  9. #9
    Senior Member byweb's Avatar
    Join Date
    Apr 2007
    Location
    Andalucia (spain)
    Posts
    267
    I¨m sorry, but it doesn´t work. Thank for you lessons. I am learning much.
    http://usuarios.lycos.es/bywebpruebas/news.html
    note: The php file I help me to build NECROMANTHUS.
    Last edited by byweb; 12-23-2007 at 08:52 AM.

  10. #10
    KoolMoves Moderator blanius's Avatar
    Join Date
    Jul 2001
    Location
    Atlanta GA
    Posts
    5,244
    Your PHP is still wrong...

    for my code to work you must have your PHP output as I showed
    PHP Code:
    <data>probando|15/12/2007|heyo perro!!!|Foto 2.jpg
    Abtenerse Idiotas
    |13/12/2007|Este ejemplo solo lo puse para que pudieseis observar como funciona este ejemplo y mejorarlo para los que pudiesen hacerloHe visto que &#65533;amente se utiliza solo para escribir idioteces, pronto lo quitar�Por cierto esta nena esta mu bien....|sho!.jpg</data> 
    right now you still have the PHP doing:
    Code:
    &titulo0 = strip_tags(probando) &fecha0 = strip_tags(15/12/2007)&mensaje0 = strip_tags(heyo perro!!!) &foto0 = strip_tags(Foto 2.jpg)&titulo1 = strip_tags(Abtenerse Idiotas) &fecha1 = strip_tags(13/12/2007)&mensaje1 = strip_tags(Este ejemplo solo lo puse para que pudieseis observar como funciona este ejemplo y mejorarlo para los que pudiesen hacerlo. He visto que últimamente se utiliza solo para escribir idioteces, pronto lo quitaré. Por cierto esta nena esta mu bien....) &foto1 = strip_tags(sho!.jpg)&titulo2 = strip_tags(prueba 3) &fecha2 = strip_tags(13/12/2007)&mensaje2 = strip_tags(Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut facilisis tristique nisi. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos. Phasellus semper hendrerit lectus. Cras semper diam nec quam. Nam lectus velit, tincidunt vel, interdum sed, lacinia at, lorem. Suspendisse feugiat ligula at justo. Duis velit. Maecenas suscipit ligula eu magna. In vulputate. Proin ullamcorper tincidunt pede. Donec eu metus. Vestibulum adipiscing massa at libero. Duis eu magna. Maecenas eget turpis auctor neque euismod consectetuer. Nunc nisl neque, eleifend nec, laoreet elementum, euismod at, neque. Nulla convallis. In hac habitasse platea dictumst. Cras non dui. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per in

  11. #11
    Senior Member byweb's Avatar
    Join Date
    Apr 2007
    Location
    Andalucia (spain)
    Posts
    267
    Then I have to change the file .php that generates this to mostrar.php that is this:
    PHP Code:
    <? 
    /*****Creado por: [email protected]*****/ 
    /* ginitofl */ 
    /* Gino Flores Lopez  */ 

    $server="localhost";              /* Nuestro server mysql:  */ 
    $database="noticias";               /* Nuestra base de datos */ 
    $dbpass="";               /*Nuestro password */ 
    $dbuser="";                 /* Nuestro user  */


    //datos del arhivo 
    $nombre_archivo = $HTTP_POST_FILES["userfile"]["name"]; 
    $tipo_archivo = $HTTP_POST_FILES["userfile"]["type"]; 
    $tamano_archivo = $HTTP_POST_FILES["userfile"]["size"]; 

    //compruebo si las caracter*sticas del archivo son las que deseo 

    if (!((strpos($tipo_archivo, "gif") || strpos($tipo_archivo, "jpeg")) && (    $tamano_archivo < 500000)))

        echo "La extensión o el tamaño de los archivos no es correcta. <br><br><table><tr><td><li>Se permiten archivos .gif o .jpg<br><li>se permiten archivos de 100 Kb máximo.</td></tr></table>";
    ?>
        <script language="javascript">
            setTimeout("url()",3000);
            function url()
            {
            window.history.back();
            }
        </script>           
    <?    
    }
    else

        $nom_img= $nombre_archivo;
        
        $directorio = 'fotos/';

        if (move_uploaded_file($HTTP_POST_FILES['userfile']['tmp_name'],$directorio . "/" . $nom_img))
        { 
                $diaactual= date("d"); 
            $mesactual= date("m"); 
            $anoactual= date("Y");
            $fecha= $diaactual . "/" . $mesactual . "/" . $anoactual;
            
            //NOS CONECTAMOS A LA BASE DE DATOS

            $link=mysql_connect($server,$dbuser,$dbpass);
                            
            $query="INSERT INTO noticias (titulo,mensaje,foto,fecha) VALUES ('$titulo','$mensaje','$nom_img','$fecha')"; 

            $result=mysql_db_query($database,$query,$link);
            
            if(mysql_affected_rows($link))
            { 
                echo "Noticia ingresada correctamente"; 
    ?>
    <table width="50%" border="0" cellspacing="3" cellpadding="0">
      <tr>
        <td> <p align="left"><b><font face="Arial" color="#FF0000"><a href="muestranoticia.php">Ver Noticias</a></td>
      </tr>
    </table>
    <?
            } else 
            { 
                echo "Error introduciendo la Noticia"; 
            } /* Cierre del else */ 




        }
        else
        {
            echo "error al subir la foto";
        }
    }

    ?>
    for generates your code but I don´t to do it. Help me please....

  12. #12
    KoolMoves Moderator blanius's Avatar
    Join Date
    Jul 2001
    Location
    Atlanta GA
    Posts
    5,244
    That looks like the PHP for inserting a new record. The code in your first post looks like what you are using.

    Anyway here is the code form your first post modified.
    Code:
    <?php
    $conn = mysql_connect("localhost","","");
    mysql_select_db("es_db",$conn);
    $ssql = "SELECT * FROM noticias";
    $ssql .= " ORDER BY id desc";
    $resultid = mysql_query($ssql,$conn);
    $n = 0;
    echo ("<data>");
    while ($damefila=mysql_fetch_object($resultid)) {
    	echo strip_tags($damefile->titulo."|");
    	echo strip_tags($damefila->fecha."|");
    	echo strip_tags($damefile->mensaje."|");
    	echo (damefila->foto."|");
     $n++;
    }
    echo "</data>";
    ?>

  13. #13
    KoolMoves Moderator blanius's Avatar
    Join Date
    Jul 2001
    Location
    Atlanta GA
    Posts
    5,244
    The trick here is that lycos is adding to what the PHP is sending to the browser which makes a mess of things. What we are doing is bypassing that by formatting the data in a way we can find it by wrapping it in <data></data> tags. Then we format the data in single lines that we can pull apart into arrays fairly easy in flash.

  14. #14
    Senior Member byweb's Avatar
    Join Date
    Apr 2007
    Location
    Andalucia (spain)
    Posts
    267
    I´m sorry but it doen´t work. Lycos I use only to prove it. Thanks.
    http://usuarios.lycos.es/bywebpruebas/mostrar.php

  15. #15
    KoolMoves Moderator blanius's Avatar
    Join Date
    Jul 2001
    Location
    Atlanta GA
    Posts
    5,244
    typo error
    Code:
    <?php
    $conn = mysql_connect("localhost","","");
    mysql_select_db("es_db",$conn);
    $ssql = "SELECT * FROM noticias";
    $ssql .= " ORDER BY id desc";
    $resultid = mysql_query($ssql,$conn);
    $n = 0;
    echo ("<data>");
    while ($damefila=mysql_fetch_object($resultid)) {
    	echo strip_tags($damefile->titulo."|");
    	echo strip_tags($damefila->fecha."|");
    	echo strip_tags($damefile->mensaje."|");
    	echo ($damefila->foto."|");
     $n++;
    }
    echo "</data>";
    ?>
    It's easy to miss when I can't test the code.

  16. #16
    KoolMoves Moderator blanius's Avatar
    Join Date
    Jul 2001
    Location
    Atlanta GA
    Posts
    5,244
    If the site is not going to be on lycos server then I would not test my PHP/flash there as they make it not work so well by pushing ads into the server response. You would not have to do some of this on paid hosting.

  17. #17
    KoolMoves Moderator blanius's Avatar
    Join Date
    Jul 2001
    Location
    Atlanta GA
    Posts
    5,244
    If you're going to offer PHP as part of sites you might want to take some time and learn it. It's not very hard to master. A glance at the code should have been obvious that I just left a "$" off the variable name and the error code tells what line to look on.

    Writing the PHP code for you is a little out of line for a support forum for koolmoves.

  18. #18
    Senior Member byweb's Avatar
    Join Date
    Apr 2007
    Location
    Andalucia (spain)
    Posts
    267
    Nothing , it does not work that not to do, only I want that at least me it works like to you. Thanks.

  19. #19
    KoolMoves Moderator blanius's Avatar
    Join Date
    Jul 2001
    Location
    Atlanta GA
    Posts
    5,244
    The last code should work.

  20. #20
    Senior Member byweb's Avatar
    Join Date
    Apr 2007
    Location
    Andalucia (spain)
    Posts
    267
    I sorry for bothering so much, but that I cannot happening, now I have the page is at a server of payment, have verified that the information is recorded in the database, but when I execute mostrar.php in the browser, only me there appear the images guarded in the database and the date, but does not show titulo and does not show mensaje.
    For it I believe that it does not show me the results in news, or possibly it is not well my file . fun
    Thank you again for your amiability.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  




Click Here to Expand Forum to Full Width

HTML5 Development Center