PHP File -> DB field

[pavmoxo]

I have the next code to convert php for txt:

<?php 
    if($_POST["phptohtml"] != "") 
    { 
        // Open a script file 
           $File = "http://10.0.0.9/cm-lousa.pt/2.0/newsletter/newstotxt.php"; 
            
           //Open the file $File 
           $FileOpen = fopen($File, "r"); 
            
           // Init Contain 
           $Contain =""; 
            
           //Create the ouptut file (temp.html as example) 
           touch("temphtml/news.txt"); 
            
            
           //Open the file on "append" mode 
           $Add = fopen("temphtml/news.txt","a"); 
            
            
             
           //Fill Contain   
           while (!feof($FileOpen))  
           { 
              $Contain .= fread($FileOpen, 8192); 
           } 
            
           //Fill temp.html 
           fwrite($Add,$Contain); 
            
           //Close 
           fclose ($FileOpen); 
            
           fclose ($Add); 
           

    } 
    ?>

and wan't to put the content of a php file into a DB field!! How can I do this?? It's possible?

[Twey]

Do you want to put in the source or the output of the PHP file?
What sort of database are we talking here?

[pavmoxo]

I want to put the html code converted of the PHP file
The database is mysql

[Twey]

<?php
  $conn = mysql_connect("host", "username", "password");
  mysql_select_db($conn, "cm-lousa");
  ob_start(); // begin output buffer
  include("newsletter/newstotext.php"); // put output of script into output buffer -- more efficient than using an HTTP connection
  $html = mysql_real_escape_string(ob_get_clean(), $conn); // store the output and delete the buffer
  mysql_query($conn, "insert into table (news) values (\"$html\");") or die("Query error.");
?>

[pavmoxo]

At this moment I have:

$conn = mysql_connect(SERVER,DBUSER,DBPWD) or die ("Problemas na ligação MySQL");
mysql_select_db (DB);
ob_start(); // begin output buffer
include("http://10.0.0.9/cm-lousa.pt/2.0/newsletter/newstohtml.php"); 
$html = mysql_real_escape_string(ob_get_clean(), $conn); // store the output and delete the buffer
include("http://10.0.0.9/cm-lousa.pt/2.0/newsletter/newstotxt.php"); 
$txt = mysql_real_escape_string(ob_get_clean(), $conn); // store the output and delete the buffer
$sql = "insert into newsletters values(NULL, 'zamalek', 'too soft', '".$html."', '".$txt."', '1')";
$query = query($sql) or die ("Query failed: " . mysql_error() . " Actual query: " . $sql); 

I want to put the output of newstotxt.php in the DB in the var $txt. Why I doesn't obtain the result that I want in this code?? Can You explain to me??

[Twey]

Because you end the output buffer with ob_get_clean(). You must call ob_start() again before the second include to create a new output buffer.

You ought to avoid using URLs if the page is on the same server as the requested page, since you are establishing a TCP HTTP connection to localhost, which is pointless and far less efficient than accessing the include by a local path.

[pavmoxo]

But only with

include("newsletter/newstotxt.php");

it can't open the file!!! the script that insert the text in DB is in /admin

Any suggestion??

[Twey]

the script that insert the text in DB is in /admin

At http://10.0.0.9/admin/?

[pavmoxo]

File to open:
newsletter/newstotxt.php

Script
admin/phptoDB.php

[Twey]

Then it would be ../newsletter/newstotext.php.