How to create a text file while runnning PHP program from browser?

reksss · April 18, 2011

Hello Friends...

I am creating a HTML webpage and connecting with MYSQL.

If the client will check the conditions, it will pass it to PHP and get values from MYSQL and print it in the webpage as a HTML table format.

Now i want to create a SAVE button and save the HTML TAble values as TXT tab demilited file.

I tried of creating a TXT file by using fopen() and write the values by using fwrite() function. But it is working only in the putty. While running the program from the browser, its not working.

Will somebody help me to solve this prob?

I also was searched for creating a TXT file from HTML table. But i wouldnt get any codes reg this....

Thanks

Rose

dcro2 · April 18, 2011

Do you have any code we can look at? And what exactly do you get when you run it in the browser?

reksss · April 18, 2011

Hello....

I first want to thank u for your reply.

I am trying to run the program from IE.

Below i have listed the code.

U can see the fopen() and fwrite() in getDataFromDB() function.

Waiting for your reply.

<?php

if($_GET["gene"])

{

$select_species_human = $_GET['Human'];

$select_species_mouse = $_GET['Mouse'];

$genesymbol = $_GET['genesymbol'];

$gene = $_GET['gene'];

$submit_button = $_GET['submit'];

connectDatabase();

//echo "$select_species_human\t$select_species_mouse\n";

//SET THE TAX_ID

//**************

if(strlen($select_species_human)!=0)

$tax_id = "9606";

elseif(strlen($select_species_mouse)!=0)

$tax_id = "10090";

else

echo("<SCRIPT LANGUAGE='JavaScript'> window.alert('Choose a Species') </SCRIPT>");

if($genesymbol=="genesymbol")

{

$value = "genesymbol";

}

elseif($genesymbol=="geneid")

{

$value = "geneid";

//getDataFromDB($tax_id,$value,$gene);

}

?>

<head>

<title>Bioinformatics Biology Service Core</title>

</head>

<body>

<h2>Bioinformatics Biology Service Core</h2>

<h3>Institute of Molecular Biology</h3>

</center>

</div>

<h2>Select a Species</h2>

<li><input type="checkbox" name="Human" value="human">Human</li>

<li><input type="checkbox" name="Mouse" value="mouse">Mouse</li>

</ul>

<h2>Input details</h2>

<p>

GeneID

<input type="checkbox" name="genesymbol" value="genesymbol">Gene Symbol</p>

Enter Gene ID (or) Name

<br />

</form>

</div>

</div>

<ul>

<li><div class="tab"><a href="#"><span>latest news</span></a></div></li>

<li><div class="tab"><a href="#"><span>about</span></a></div></li>

<li><div class="tab"><a href="#"><span>contact us</span></a></div></li>

</ul>

</div>

<p>

<?php

connectDatabase();

getDataFromDB($tax_id,$value,$gene);

?>

</div>

</div>

</div>

<a href="http://gregdev.net">Bioinformatics Biology Service Core</a></p>

</div>

</body>

</html>

<?php

function myfunction($v1,$v2)

{

return $v1 .",". $v2;

}

//*************************************************************************************************

function getDataFromDB($tax_id,$value,$gene)

{

//CODINGS FOR "GENE ID"

//*********************

if($value == "geneid")

{

$total_gene_id = explode(",",$gene);

$size_of_total_gene = sizeof($total_gene_id);

$result_gene_id = (array_reduce($total_gene_id,"myfunction"));

$extract_gene_id_list = substr($result_gene_id,1);

//echo $extract_gene_id_list;

$query = "SELECT *

FROM gene2go

WHERE (tax_id = '$tax_id') AND

(GeneID IN ($extract_gene_id_list))";

}

//CODINGS FOR "GENE SYMBOL"

//*************************

else if($value == "genesymbol")

{

$total_gene_symbol = explode(",",$gene);

$size_of_total_gene_symbol = sizeof($total_symbol);

$result_gene_symbol = (array_reduce($total_gene_symbol,"myfunction"));

$extract_gene_name_list = substr($result_gene_symbol,1);

$query = "SELECT a.*

FROM gene2go a,`gene_info` b

WHERE b.`tax_id` =10090 AND

(b.Symbol IN('$extract_gene_name_list') OR b.Synonyms IN ('%$extract_gene_name_list%'))AND

(b.GeneID = a.GeneID)";

echo $query;

}

else

{

echo "\nError in choosing the Gene Id or Symbol\n";

}

$result = mysql_query($query) or die('Error, query failed'.mysql_error());

$fp = @fopen("sample.txt",'w') or die("Could not open sample.txt file");

//echo "<a href='http://192.168.100.152/~rekha/Webpage/result.xls'> SAVE </a>";

echo "<TABLE>";

echo "<TR>";

echo "<TH>TAX_ID</TH>";

echo "<TH>Gene_ID</TH>";

echo "<TH>Go_ID</TH>";

echo "<TH>Evidence</TH>";

echo "<TH>Qualifier</TH>";

echo "<TH>GO_Term</TH>";

echo "<TH>Pubmed</TH>";

echo "<TH>Catagory</TH>";

echo "</TR>";

while($row = mysql_fetch_array($result, MYSQL_BOTH))

{

$tax_id = trim($row[0]);

$gene_id = trim($row[1]);

$go_id = trim($row[2]);

$evidence = trim($row[3]);

$qualifier = trim($row[4]);

$go_term = trim($row[5]);

$pebmed = trim($row[6]);

$catagory = trim($row[7]);

echo "<TR><TD>$tax_id</TD> <TD>$gene_id</TD><TD>$go_id</TD><TD>$evidence</TD><TD>$qualifier</TD><TD>$go_term</TD><TD>$pebmed</TD><TD>$catagory</TD></TR>";

fwrite($fp,"$tax_id."\t".$gene_id."\t".$go_id."\t".$evidence."\t".$qualifier."\t".$go_term."\t".$pebmed."\t".$catagory."\n");

}

echo "</TABLE>";

//fclose($fp);

}

//*************************************************************************************************

//CONNECTING WITH THE DATABASE

//*****************************

function connectDatabase()

{

mysql_connect("IPaddress","uname","password") or die("could not connected".mysql_error());

mysql_select_db("NCBI_gene_info") or die(mysql_error());

}

?>

dcro2 · April 18, 2011

Ok, so your code is working on the command line, but not through the webserver. That means php probably doesn't have permissions to write to the folder this file is in.

Also, this:

fwrite($fp,"$tax_id."\t".$gene_id."\t".$go_id."\t".$evidence."\t".$qualifier."\t".$go_term."\t".$pebmed."\t".$catagory."\n");

should be

fwrite($fp,$tax_id."\t".$gene_id."\t".$go_id."\t".$evidence."\t".$qualifier."\t".$go_term."\t".$pebmed."\t".$catagory."\n");

reksss · April 18, 2011

I corrected it. While clicking the Submit button im getting error "Could not open sample.txt file"'.

I heard from one of my friend that if we run from browser, we cant able to write data in the file.

I tried a simple program.

<?php

//OPENING the input FILE

//**********************

$fp = @fopen("sample.txt",'w') or die("Could not open sample.txt file");

fwrite($fp,"Testing\n");

fclose($fp);

?>

<HTML>

File open testing

</HTML>

It is running well in putty but not from IE.

Plz help me.....

dcro2 · April 18, 2011

You have to set the permissions of the folder to let php write to it. Since I don't know what system you have, let's say you have a ubuntu installation. Apache runs under www-data, so you would do this in putty:

chown :www-data /path/to/directory
chmod 775 /path/to/directory

Replace /path/to/directory with whatever folder this script is in.

reksss · April 19, 2011

I changed the file permission

chown -R rekha /home/rekha/public_html/Webpage

chmod 755 /home.rekha/public_html/Webpage.

But still its not working!!!

maxudaskin · April 19, 2011

Please remember to put your code inside of

tags. It makes it much easier for everyone else to read it, as it highlights the code.

kenrbnsn · April 19, 2011

Try writing the file the directory "/tmp". Everyone should have write permissions to that directory. After the file is created do an "ls -l" on the file and see who the owner is. It's probably not your userid. That is probably where you're getting confused.

Ken

reksss · April 19, 2011

Hi Ken....

I used ls -l for checking the file permission in Linux. I found for user it doesnt has W permission. So i used chmod.

  
chmod -R 777 *

ls -l

Now it is working well............

Thanks u friends for ur help..............

Sign In

How to create a text file while runnning PHP program from browser?

Recommended Posts

reksss

Link to comment

Share on other sites

dcro2

Link to comment

Share on other sites

reksss

Link to comment

Share on other sites

dcro2

Link to comment

Share on other sites

reksss

Link to comment

Share on other sites

dcro2

Link to comment

Share on other sites

reksss

Link to comment

Share on other sites

maxudaskin

Link to comment

Share on other sites

kenrbnsn

Link to comment

Share on other sites

reksss

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information